All,
I guess I'm too stupid to understand the DB2-Manual or what I try to do
just doesn't work.
I have a application written in C runnting under z/OS. From this
application I need to query different (dynamic!) DB2 databases.
Let's compare to COBOL. In COBOL I usually write SQL Statements without
the prefix in front of the table names. I can write a "SELECT BLA FROM
FOO" instead of "SELECT BLA FROM XXX.FOO" - the "XXX" comes from the
PLAN I bind (due to the options OWNDER and QUALIFIER).
So, now with my C application I need to do the same - this time I also
want to omit the "XXX" - but the value of "XXX" is dynamic: I need to
Query XXX.MYTABLE, ABC.MYTABLE, ...
From my application I do a so called NULL-Connect with the
ODBC-compliant API. Then I issue a "SET CURRENT SQLID = 'XXX';" and
everything works like a charm - I can issue my "SELECT BLA FROM FOO" and
the table getting queried is XXX.FOO. Great!
Now I'm in deep need to archive the same results but without issuing the
"SET CURRENT SQLID...." Statement.
I've spent much time in understanding the docs and trying to get it
working with different entries in the DSNAOINI file but all in vain (ok,
my DB2-skills are rather bad).
Any idea anybody?
Thank you,
Michael
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
