Re: File updation in SQR

["Kulshrestha, Alok" <ALOKKULSHRESTHA@IMF.ORG>]

Akshay,

File manipulation is not supported in SQR except read, write & append
operations. The alternate way of doing this would be to read the file
content (or required columns) into an array and update there and write to
the file again. However this will get slow if file is too large.

Hope it helps you.

-alok
On Tuesday, November 03, 1998 3:54 PM, Akshey Sood
[SMTP:asood@CORPNOTES01.MW-CORP.COM] wrote:
: Hi Everybody,
: I am relatively new to this site and i have a question related to file
: updation in SQR. We are working in DB2 and implementing PS retail s/w. The
: no of records handled by the scripts is anywhere from 1.5 million to 6
: million. The problem is that in certain cases we need to write interface
: programs where only a few thousand records from a file need to be
: processed. Moreover in certain programs the business requirement is such
: that existing records in the file need to be updated after comparing them
: with records from the DB table(s). We can do that in COBOL by opening the
: file in I-O mode and declaring that fiel as an index file. Can the same
: thing be done in SQR. Is there any way we can reference records by indexes
: rather than sequential mode in SQR!!
:
: Thanx for your time and help in anticipation.
:
: Akshay
:
: (312) 467-6803