Reg Before SQl Statement

reddy82 · Post by **reddy82** » Tue Aug 25, 2009 1:01 pm

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

chulett · Post by **chulett** » Tue Aug 25, 2009 3:55 pm

So... is this a QualityStage job?

ray.wurlod · Post by **ray.wurlod** » Tue Aug 25, 2009 4:05 pm

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

reddy82 · Post by **reddy82** » Wed Aug 26, 2009 1:10 am

Hi ,

This DS server job

reddy82 · Post by **reddy82** » Wed Aug 26, 2009 1:17 am

Hi there,

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