Re: arrays or subscripts
>
> I hope someone here can help me. I am using Informix-SQL Version 4.10.UE2
> I am trying to use some form (any form) of an array to print table data.
> Currently the printed ascii text data appears as;
>
> S000001|060194|12|Apple|J|Davis|1 Main|Norfolk|Va|32211|2121111234|xx1|
> S000001|060194|12|Apple|J|Davis|1 Main|Norfolk|Va|32211|2121111234|xx2|
[other stuff removed.]
Will xx? always be the only difference? In which case:
SELECT statement
BEFORE GROUP OF xx_field
print other stuff; { <- note the semicolon - no new line }
ON EVERY ROW
print "|", xx_field; { <- still no new line }
AFTER GROUP OF xx_field
print { here's your carriage return }
try that out
j.
_____________________________________________________________________________
Jack Parker |
Hewlett Packard, BSMC Boise, Idaho, USA| Someday you'll go far,
jparker@hpbs3645.boi.hp.com | if you catch the right train.
(208) 396-5388 (W) (208) 384-1623 (H) |
_____________________________________________________________________________
Any opinions expressed herein are my own and not those of my employers.
_____________________________________________________________________________