Run DB2 Query without bind the program

Sudharsan24 · New User Joined: 23 Oct 2012 Posts: 4 Location: Arizona

Hi All,

I have requirement where I have to pull the data from multiple table using one key value. We used to get close to 100000 Key vlaues which we are unable to run in spufi to get the data. So we have written a JCL to pull the data from table using the key value. We are unable to give the whole key value at one time(100,000) because job is not accepting everything at one time. So we are have created a many steps using the same query but where clause will have 400 key values. Is there any way to execute the query with all 100000 keys in one query and run the job. We are not suppose to bind the Cobol program in Production for this Adhoc request. We have tried Easytreive as well but I am getting a below error
"A system abend 0C4 reason code X'4' occurred in module EZTCOM program *EZSQLFU at offset X'6458'."

Could anyone please help me on this.

Thank you.

Anuj Dhawan · Posted: Tue Oct 30, 2012 2:42 pm

With what you've posted - you're getting S0C4, which means 'protection exception' occurred. In other words, your program attempted to access a storage location that is protected (by storage keys) against the type of reference, and the PSW access key does not match the storage key -- i.e. you're trying to access a storage not defined to your program. So possibly, check why this happens.

Having said all that, have you tried executing your queries using DSNTIAUL?

enrico-sorichetti · Posted: Tue Oct 30, 2012 2:51 pm

Bill Woodger · Posted: Tue Oct 30, 2012 3:24 pm

Try Anuj's suggestion.

Do you mean "a Cobol program" rather than "the Cobol program" as in "we are not able to write a new Cobol program for this as we will not be able to implement an ad-hoc Cobol program which can access the production data"? However, it would be silly if you are not "allowed" to do it in Cobol, but you are "allowed" in Easytrieve.

Does your Easytrieve work with small amounts of data, or not at all?

dbzTHEdinosauer · Posted: Tue Oct 30, 2012 4:11 pm

a much quicker execution would be achieved by dumping the table
and using a sort product to JOINKEYS.

dick scherrer · Posted: Tue Oct 30, 2012 9:41 pm

Hello,

Or maybe loading the 100,000+ keys into another table and JOIN them?

Peresonally, i'd go for the unload and use the sort to JOINKEYS to do what you need.