MVSFORUMS.com

shyamsaravan · Posted: Thu Apr 12, 2012 7:40 am Post subject: Can we check DB2 table in sort

Hi;

I have a question like..

We have to match two PS files and the unmatching records should be wriiten in another file,before that we have to check the data existence in the DB2 table..
Is it possible to check DB2 data existence in the SORT process..

I will describe the detail in the next post,if the answer is YES..
Thanks;

dbzTHEdinosauer · Posted: Thu Apr 12, 2012 8:59 am Post subject:

syncsort allows for embedded sql in the control cards.
i do not believe dfsort has the sql type option.

what i would do, anyway, (i would refrain from db SELECTs to validate) is:
1. dump the db2 table (only the columns necessary for matching and validation.
2. use the dump as a third ps file for the sort.
_________________
Dick Brenholtz
American living in Varel, Germany

Sqlcode · Intermediate Joined: 15 Dec 2006 Posts: 157 Topics: 38

shyamsaravan,
It may be possible if you are willing to code DFSort user exit. I personally haven't coded one to check for dB2 existence but it may be possible.

Refer to link below for more information.
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/ice1ca50/4.8.3?ACTION=MATCHES&REQUEST=e35&TYPE=FUZZY&SHELF=&DT=20100630155256&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

Thanks,

kolusu · Posted: Thu Apr 12, 2012 10:31 am Post subject:

shyamsaravan,

You have 2 options.

1. Unload the DB2 table to a file and then perform the matching using JOINKEYS.

2. If for some reason you canNOT unload the table, then you can code an EXIT and validate the existence of the table in there. The exit would be like any other subroutine you code.
_________________
Kolusu
www.linkedin.com/in/kolusu

kolusu · Posted: Thu Apr 12, 2012 10:34 am Post subject: