Re: File updation in SQR

[Satish KARRY <Satish_Karry@EL.NEC.COM>]

Hi
If there is a RDBMS on your site. The easiest way would be to load the text
file into a table and manipulate the table.
If Oracle
        Sql Loader to upload the text File to Table.
If Sybase
        Bcp does the job.
If Sql Server
        Bcp Again
Others
        An utility from the vendor.
Otherwise
Import Manager of Peoplesoft.
Sqr to Create a Table and import Rows.
Hope one of them works

Satish KARRY
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
email              satishkarry@geocities.com
Live as if your were to die tomorrow.
Learn as if you were to live forever.
                                  -Gandhi
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

-----Original Message-----
From: Akshey Sood <asood@CORPNOTES01.MW-CORP.COM>
Sent: Tuesday, November 03, 1998 2:54 PM
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
Subject: File updation in SQR


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