MVSFORUMS.com

singhnarender79 · Posted: Tue Dec 24, 2002 12:08 am Post subject: DB2 ReXX Complier

Hi all,
I had Written a DB2 Rexx Program and i want to compile the program. Does REXXCOMP (I guess this is the compiler) compile the program or i had to do something else to compile it???

Like we do in COBOL prog. First we precompile it to remove the SQL statement and then Bind.

Do we have to do Similar steps here???

Plz help me out .. it has to be done urgently.

Thankx and Regards
_________________
"Hold fast to dreams, for if dreams die, life is a broken winged bird that cannot fly."

-- Langston Hughes

Manas Biswal · Posted: Tue Dec 24, 2002 1:12 am Post subject:

Hi,

As far as I know, when you are trying to run SQL through a REXX program, you need to call some REXX-DB2 Interface APIs and pass the SQL as a parameter to those APIs. There is no need to compile the program. You can run REXX the usual way. It will call those APIs during run time and the APIs in turn will pass the SQL to the DB2 run time supervisor.

The following link contains details about the REXX-DB2 interface in detail. Although the interface comes free from IBM, but I don't think many installations have the interface simply because REXX-DB2 is not an in-thing.

Go for REXX considerations in the following book-

http://www-3.ibm.com/software/data/db2/udb/ad/v7/adg/db2a0/frame3.htm#db2a011

Regards,
Manas

singhnarender79 · Posted: Tue Dec 24, 2002 4:06 am Post subject:

Hi,

I know we Don't have to complile a DB2 ReXX Program, But the Problem here is

I have written a DB2 ReXX Program which Export the data from DB2 Tables to a CSV File which then i can import it in Access. But the Data is so large around (50 - 70 Lakhs Records) that it almost take 6 - 9 Hours to make the CSV File, So i wanted to Compile my Program b'cause Compile Programs Runs (10 - 18 times) Faster.

So do u have any info about Compiling a DB2 ReXX Program.

Regards,
Naren
_________________
"Hold fast to dreams, for if dreams die, life is a broken winged bird that cannot fly."

-- Langston Hughes

kolusu · Posted: Tue Dec 24, 2002 5:36 am Post subject:

Singh Narender,

Check this link for REXXCLG Compile, link edit, and run a REXX program of OBJ type.

Hope this helps...

cheers

Kolusu

PS: please do not use words like urgent or urgently in the topic title. See the posting guideline 3.I am moving this topic to TSO AND ISPF forum as it is the right forum.