Hi ,
I have a job which i need to set the some parameters in the BEFORE SQL tab of DB2 API stage
==> We have user defined datatypes for all the tables and while querying the these statements with our own logins to database other than our instance DB2INST1 we re having issues.
i am trying to set the following variables in before sql
SET PATH=DB2INST1;;
SET SCHEMA=DB2INST1;;
and my SQL statement is :
select * from table where varchar(field name)='????'
Before the above select statemnet executes i want to the SET variables ( mentioned above) to be executed in datastage .
I have unchecked the NON FATAL check box;
Please provide your options / suggestions so that this works
Regards,
Reddy
Using Before SQL
Moderators: chulett, rschirm, roy
Using Before SQL
Reddy