Re: Reading Flat Files from SQR

[Anders Eriksson <anders.eriksson@TELE2.SE>]

Hello Srini,

Yes it is easy to read flat files with SQR. We have used that opetunity a
lot.

1) Use OPEN to open the file(s).
OPEN { filename_lit | _var } AS { filenum_int_lit | _var }
{ FOR-READING | FOR-WRITING | FOR-APPEND }
{ RECORD = length_int_lit [ :FIXED | :FIXED_NOLF | :VARY ] }
[ STATUS = { num_var } ]

2) Read records with GET.
GET  { dst_any_var } ...  FROM  { src_array_name ( element ) }  [ field [ (
 occurs ) ] ] ...

3) Close the file with CLOSE.
CLOSE  { filenum_lit | _var }

Regards
Anders Eriksson