Running queries through SPUFI in distributed db2 systems

Eshwar CICS · New User Joined: 18 May 2011 Posts: 47 Location: India

We run queries using SPUFI in distributed db2 systems in following manner:

SELECT * FROM db2system.schema.table-name

But would like to run the query like below and would like to supply db2system and schema name separately:

SELECT * FROM table-name

Was successful in supplying the schema name separately using "SET CURRENT SCHEMA" but attempts of supplying db2system names have failed.

Any advise on how to supply db2system name separately is appreciated.

GuyC · Posted: Wed May 18, 2011 3:46 pm

Eshwar CICS · New User Joined: 18 May 2011 Posts: 47 Location: India

Yes that works.SPUFI issues a type 2 CONNECT statement to that server. But requirement is to do that in my input dataset.

GuyC · Posted: Wed May 18, 2011 5:25 pm

I don't think you can;
I don't understand who and why states such a requirement.
Or is it "Spufi in Batch" ?

Eshwar CICS · New User Joined: 18 May 2011 Posts: 47 Location: India

Hi GuyC,
At this point of time:

1. I still believe this can be done.Because SPUFI connects to location mentioned in option 10 and provides with a SQLCODE.So there is a SQL running behind the scenes which supports my belief.

2.Have such requirement because we deal with multiple DB2 subsystems and each time i dont want to change the location on option 10 and change the schema.

3. It believe it can be done with BATCH SPUFi which i am not looking for.

Thanks for your analysis and reply.Appreciate it.

GuyC · Posted: Fri May 20, 2011 12:22 pm

if possible , not by using he connect statement.