MVSFORUMS.com

thomas · Beginner Joined: 10 Mar 2006 Posts: 3 Topics: 2

Hi ,

I have data set TMC001.CUST.DATA , which having around 5000 custno . How to run the SELECT SQL in Batch using this dataset as 'in set'

ie select * from customer where custno in ()

Thanks
Thomas

kolusu · Posted: Fri Mar 10, 2006 5:26 am Post subject:

thomas,

Please search before posting. This topic has been discussed earlier. Check these links

http://www.mvsforums.com/helpboards/viewtopic.php?t=640&highlight=unload

http://www.mvsforums.com/helpboards/viewtopic.php?t=3928&highlight=unload

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

thomas · Beginner Joined: 10 Mar 2006 Posts: 3 Topics: 2

Hi Kolusu,

Thanks for your response ..

I want to execute a UPDATE Statement using DSNTEP2 and my search condition is in dataset TMC001.CUST.DATA , which having around 5000 record .

Just have look at my UPDATE statement in SYSIN CONTROL CARD

UPDATE AIS00.CUSTOMER SET MVALUE='Y' WHERE CUSTNO IN ( )

My problem is all the CUSTNO values for the search condition are stored in a dataset . Currently we are running a programe for updating this table .

Is there any way i can access these dataset in my UPDATE query in my batch programe

Thanks

kolusu · Posted: Fri Mar 10, 2006 8:24 am Post subject:

thomas,

Check these links which discuss about generating the update sqlcards and then running in batch mode.

http://www.mvsforums.com/helpboards/viewtopic.php?t=3369&highlight=sqlcards

http://www.mvsforums.com/helpboards/viewtopic.php?t=2787&highlight=sqlcards

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu