Downloading a db2 table to a flat file - opinion you
Really: Downloading a db2 table to a flat file
| Dewan e ghalib download for pc | 841 |
| Ptz controller software free download full version | 422 |
| How do you download videos from playstation for iso | 364 |
| Ipad old version of skype download | 366 |
| Sleaford mods obct download | 129 |
FREE TUTORIALS
Rinu,
Ok let me define ur requirement first
1. You have a transaction file -> This File has field AGENT-NO
2. you have a table AGENT -> Which consists of AGENT-NO,EMPLOYEE-NOand some more columns.
Now what is required is you need to get the EMPLOYEE-NO corresponding to the AGENT-NO from ur I/P trans file.
and you want to achieve this using only JCL.
Ok Rinu here is what i suggest..
you dint get back to us reg whether the TRANS FILE or the TABLE will have duplicates
on AGENT-NO and EMPLOYEE-NO.
well if there can be duplicates then you need few more steps .
NOTE : If you are planning to use EZT for matching then better to sort both the files on fields which we match.
whatever is suggested can be done using ONLY JCL without using ANY PROGRAM COBOL OR COBOL + DB2.
P.S : WHAT EVER YOU HAVE ASKED FOR IS NOT CLEAR AS DAVE SAID IF YOU CAN COME UP WITH ALL THE DETAILS AND STRUCURE YOUR REQUIREMENT CLEARLY THEN WE CAN GET BACK WITH BETTER SOLUTIONS.
If the suggested solution can give you and Idea how to procees we will be Glad
Thanks,
Veera.
Источник: www.cronistalascolonias.com.ar?t=Ok let me define ur requirement first
1. You have a transaction file -> This File has field AGENT-NO
2. you have a table AGENT -> Which consists of AGENT-NO,EMPLOYEE-NOand some more columns.
Now what is required is you need to get the EMPLOYEE-NO corresponding to the AGENT-NO from ur I/P trans file.
and you want to achieve this using only JCL.
Ok Rinu here is what i suggest..
Code: Select all
on AGENT-NO and EMPLOYEE-NO.
well if there can be duplicates then you need few more steps .
Code: Select all
whatever is suggested can be done using ONLY JCL without using ANY PROGRAM COBOL OR COBOL + DB2.
P.S : WHAT EVER YOU HAVE ASKED FOR IS NOT CLEAR AS DAVE SAID IF YOU CAN COME UP WITH ALL THE DETAILS AND STRUCURE YOUR REQUIREMENT CLEARLY THEN WE CAN GET BACK WITH BETTER SOLUTIONS.
If the suggested solution can give you and Idea how to procees we will be Glad
Thanks,
Veera.
-