Sql in rexx
Posted: Thu Sep 24, 2015 2:19 pm
Hi,
Please help me with a solution for my issue.
I want to develop a rexx program for selecting rows from a wuery and writing the rows fetched in an output file.
Say i hav 2 queries in a parm file.
Now my rexx prog should identify my first query in the parm file and execute them and write it in an output file.
Similarly it should do for the next query and write the results in another file.
The point here is al logics shoild be dynamic. The rexx should handle any number of queries i give in the parm file. But everytime when i add a query in the parm file, it should not ask me to make changes in the rexx prog. The rexx prog should remain as standard one.
Please help me with a solution for my issue.
I want to develop a rexx program for selecting rows from a wuery and writing the rows fetched in an output file.
Say i hav 2 queries in a parm file.
Now my rexx prog should identify my first query in the parm file and execute them and write it in an output file.
Similarly it should do for the next query and write the results in another file.
The point here is al logics shoild be dynamic. The rexx should handle any number of queries i give in the parm file. But everytime when i add a query in the parm file, it should not ask me to make changes in the rexx prog. The rexx prog should remain as standard one.