I have a select query in a JCL. For eg: the select query will fetch 130 rows with 6 columns. I need to pass the values of each row one by one to a REXX using the JCL. Is there a way to do it? Any help would be appreciated.
Asked
Active
Viewed 340 times
1
-
Why not save the result to a file and read the file in rexx ??? – Bruce Martin Dec 20 '17 at 09:50
-
you need to write them to a file, its really the only way. Then have the rexx routine parse through the columns. – SaggingRufus Dec 20 '17 at 11:21
-
Thanks to you both. I will try to write into a file and then parse it. – Sudarsan Rajagopalan Dec 20 '17 at 12:33