DSXchange

Yes, that is a typing mistake.
The date1 is sysdate and coldate comes from the database. As I mentioned this SQL runs fine on TOAD. I think I am doing something wrong while coding in Datastage. I am not sure what.

Hi, I am trying to execute a SQL query at Oracle Stage. My query is --- select a.col1, a.col2,a.col3 from table1 a, table2 b where a.coldate>date1 and a.co4=b.col1 and b.col2-'1234' order by a.col1 desc; This SQL runs and gives correct result when run with TOAD. When I plug in the same query at Orac...

Thanks Craig, this is resolved for me.

This DB2 stored procedure gives correct output when I test it outside datastage. Is there something I need to set up for a stored procedure stage within datastage to view both the outputs?

I have a stored procedure which outputs two result sets. Result set #1 col1 col2 col3 1 b test Result set #2 col4 col5 col6 34 abcd 122 My first job is designed to get the Result set#1 and second job to get Result set#2.My problem is I get the results from Result set#1 in my second job also. I have ...

Hi, I am trying to use the FTP stage for the first time. I need to FTP a file from windows to UNIX. I need to FTP the same file after some transformation fromm UNIX to windows. The file is a sequential file. Is it possible to achieve just using the FTP enterprise stage? How would be my job design? F...

Hi, I am using the User Variable Activity Stage in my sequencer. I am calculating a value using this stage which will be used further down in the sequencer. My expression looks something like this Varaiblename : routinename("command":/directorypathname) I am trying to parameterize the /die...