![]() You need to handle duplicates by -811 or code a CURSOR.Ģ-> It is always good to query the table using the full key. Other wise there is a posibility that you will get duplicates for that either We need to consider few things in the above queryġ-> IT will give correct results only if you have UNIQUE AGENT_NO in the AGENT TABLE. but this failed when i gave a selective unload.WHERE AGENT_NO = :WS-Agent_No -> This field should be from ur TRANS FILE. I could unload the data when i gave a full unload without any DB2 query. Ppsd4.agent is fine.that s our table location. SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD FROM, TOKEN FOR WITH FETCH ORDER UNION EXCEPT QUERYNO OPTIMIZE SQL ERROR DURING SQL STATEMENT PREPARE, TABLE SELECT AGENT_JOB_C FROM PPSD4.AGENT When i entered the query to select the needed fields in the SYSIN statement the following error occured Remember to allocate enough space for the dataset that you are downloading your table into.īut, if we want to do a selective download from the table,what to do?Ĭan we write the query inside the sysin dd *? Use the batch mode to download the table in a dataset. There is an option to use batch or online mode. This is Fileaid Db2 option: 'Extract and Load Tables ' If u having more records in the table allocate sufficiant space for the data set in SYSREC00 DD nameĪnd the parameters given inside the SYSTSIN would be varying according to installations. SYSREC00 DD DSN=UNLOAD.dataset,DISP=SHR SYSPUNCH DD DSN=SYSPUNCH.dataset,DISP=SHR STEP01 EXEC PGM=IKJEFT01,DYNAMNBR=20,REGION=0M What utility would you suggest that is fast enough for downloading a db2 table which contains 655k+ records? thanks in advance for your replies. Downloading a db2 table which contains 655k+ records -IBM Mainframesĭownloading a db2 table which contains 655k+ records
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |