DSXchange

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

So... is this a QualityStage job?

Could be... we just don't know.

Hi ,

This DS server job

Hi there,

Sorry i have posted this in wrong forum and will close this here and open in DS forum