DSXchange

I need pass rows that saitsfy either of the two range date conditions ((A.date1 between B.date1 and B.date2) or (A.date2 between B.date1 and B.date2)).

if i use 2 range conditions in lookup its treating as ''AND''....but my requirement is to use ''OR''..please let know how to achice this...

Hi, I need help in implementing following join logic. Select * from Table A Left outer join table B on A.column1 = B.column1 and ((A.date1 between B.date1 and B.date2) or (A.date2 between B.date1 and B.date2)) First I used a Join and then used filter after that for date condition, but it gives me a ...

Thanks for your quick replay, unfortunately APT_OSL_PARAM_ESC_SQUOTE variable is not added in my project under user-defined environment variables, i requested my DataStage Administrator to add it, i hope he will .

yes its userstatus issue ,it should look like select * from emp where empno=\'xxx\' but ended up like select * from emp where empno= i am using above sql(userstatus) as query(read methold-user defined sql ) for netezza enterprize stage.... is there any other escape char i can use insted of backslash...

Hi , I have a job that retrieves a select statement (contains backslash) from a file and returns this value in a userstatus variable and passing this userstatus variable in next job as as user-defined SQL in netezza enterprize stage. problem is userstatus not reading compleate select statement conta...