Good Evening All,
I am working on a program that well need to get data via a UDF from
multiple DB2 subsystems then make make some updates to the date and
then do a "select col1 from SESSION.tmp group by col1".
I have the program working for one subbsystem, but then I run into a
problem in how do I get the data from another subsystem? I am using a
declared global temporary table so if I try and connect to another
subsystem I loose my table. What would solve my problem being able to
call the UDF using a 3 part name, but I don't think that is supported.
The reason that I am using the temp table is that multiple people can
call the program at the same time, so I did that so each call would
have it's own copy of the table.
Any help would be great!
Thanks,
Doug