Select Data from table based on File Input
Posted: Mon Apr 15, 2013 9:11 am
Hi All,
I have got a requirement where i need to read values from the file and select data from db2 table based on this.
I can do it through a simple cobol-db2 program but i wanted to acheive this through any of db2 Utilty/JCL.
Example :
Sample File
Col1 Col2
AA BBB
CC DDD
I should select data from the table for this file input like
Select * from Table where col1= AA and Col2=BBB with ur;
The above has to be accomadated for all file input.
Any help here is greatly appreciated .Thanks.
I have got a requirement where i need to read values from the file and select data from db2 table based on this.
I can do it through a simple cobol-db2 program but i wanted to acheive this through any of db2 Utilty/JCL.
Example :
Sample File
Col1 Col2
AA BBB
CC DDD
I should select data from the table for this file input like
Select * from Table where col1= AA and Col2=BBB with ur;
The above has to be accomadated for all file input.
Any help here is greatly appreciated .Thanks.