Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
One thing that would help readability would be to use the Code tags. Click Code before your code then Code again at the end. This preserves actual spacing between characters. See FAQ and read about Formatting and Topic Types.
but in my scenario, i am not sure how many SQL going to come as a input. it could be 1,2 or could be many more.
So i want Dynamic JCL which will separate the input SQL depending upon the number of SQL present in input file and then generate the Dynamic JCL to unload the data from DB2 table based upon the input SQL.
Final Goal --> 1. Main JCL will read input file, extract first SQL, prepare Dynamic JCL to unload the data from DB2 table based upon first SQL.
2. then read second SQL from input file, prepare Dynamic SQL to unload th data from DB2 table based upon Second SQL.
3. This process should repeat until the EOF.
NOTE: Each SQL starts with "SELECT" and ends with ";"[/quote]