IKJEFT01 - Can we have two queries in one step?

lanand_hps · New User Joined: 05 Dec 2007 Posts: 82 Location: chennai

Hi,
My requirement is to check if data is present in a table.
But, i want to perform this check for different sub systems.
Can we have more than one sql query in one IKJEFT01 step or should i go for different steps?

Thanks.

tarun_bhardwaj · New User Joined: 18 Jul 2003 Posts: 39 Location: delhi

you can have 2 queries in the same step (needless to say that each query should end with a semi-colon ';')

hikaps14 · Active User Joined: 02 Sep 2005 Posts: 189 Location: Noida

Hi,

You may be able to run to 2 queries in a single step but can you access 2 different subsystems on the same step.

I have always run queries under single subsystem in one step. I doubt if it will work in this case as well(2 different SSID).

Thanks,
-Kapil.

lanand_hps · New User Joined: 05 Dec 2007 Posts: 82 Location: chennai

Thanks guys.
Can we use the SQLCODE generated from this query?
I'm submitting this job through REXX and want to make use of the sqlcode.

dick scherrer · Posted: Tue Dec 16, 2008 8:28 pm

Hello,

If you more completely explain what you want to do you will get more useful replies.

Once the job is submitted, the sqlcode will be available to the submitted job not the rexx that submitted the job (if i understand what you are asking

).