MVSFORUMS.com

ankushw · Beginner Joined: 14 Mar 2005 Posts: 2 Topics: 2

I'am in the process of writing a tool in REXX which involves executing a few SQL querries whose results are written into datasets.
The problem is that after the results of one querry are written into a dataset thru an EXECIO statement, it waits for me to press enter to proceed further. Can someone please tell me how can I avoid this situaton so as to proceed automatically with the rest of my prog after the results for an SQL are written into the dataset.

Thanks & Regards,
Ankush

ofer71 · Posted: Tue Mar 29, 2005 8:54 am Post subject:

I don't understand why your REXX waits for you to do something. Do you have something like PULL ? EDIT ? VIEW ? SAY ?

O.
________
buy herbalaire vaporizer

moyeenkhan · Beginner Joined: 04 Dec 2002 Posts: 64 Topics: 21

At the end, issue EXECIO 0 DISKW filename (FINIS

ofer71 · Posted: Tue Mar 29, 2005 10:10 am Post subject:

EXECIO itself is not a reason to hold the program and wait for user prompt. What is the first statement after the EXECIO ?
________
cheap glass bongs

garyb · Posted: Tue Mar 29, 2005 10:18 am Post subject:

If you are stacking the results of the query and then doing an EXECIO * to write them to a data set, you will need to stack a null line after the query. EXECIO looks for the null to signal the end of stack data. When it doesn't find it, I basically does a PULL, which gets satisfied by you pressing the ENTER key and thus entering a null value.
_________________
Gary