DSXchange

Okay. From datastage, I am only reading the data from Oracle table. But, on the other side, the source system is updating the same Oracle table, to remove the historical rows. I am not concerned about that as I am only reading the current and future rows. My question is that I want the connection to...

Hello All, I have an extract job, which reads the data from an Oracle job. This job has some extensive transformation logic in it. Does this job retains the connection to Oracle even after the extract stage is completely done? The problem is... we are getting the "Snapshot is too old" erro...

Thanks Brad. Will try the workaround.

Yup that is exactly the situation (> 18 digits). We are on 7.5.1a. Do you happen to know the patch number for this?

Thanks

Hello, We have a parallel job that had a fatal error in it (when looked into the log), but still had a statement "Sucessfully Finished" at the end of the job log. Why would it do that? Has anyone see this before? Are there any configuration settings that I am missing? Not all the jobs are ...

Hello All, I have a need to merge the columns based on the key. There are multiple rows with similar key. The output should have one row for a given key with the values from each row as different columns. Ex: 1, 1, a, Hello 1, 1, b, Bye 1, 1, c, Now With first two columns being the key, I wanted the...

[quote="toshea"]Yes, you can specify multiple statements separated by semicolon characters. Just don't use a line feed.[/quote]

Toshea... you rock!!! Thanks and it did work for me.

[quote="toshea"]0A is the ASCII hex value for a line feed character which the Teradata CLIv2 does not like. Try taking out any carriage returns in your statement. Does your DELETE statement span multiple lines? If you did a cut-and-paste from somewhere, make sure any terminating line feed ...

[quote="toshea"]Open the Teradata Enterprise stage. From the Properties tab of the Input page, click on Options folder and you'll see the Open Command option in the window of "Available properties to add". Click on it to add that option, type in your DELETE statement in the Open ...

[quote="toshea"]Open the Teradata Enterprise stage. From the Properties tab of the Input page, click on Options folder and you'll see the Open Command option in the window of "Available properties to add". Click on it to add that option, type in your DELETE statement in the Open ...

Hello,

Do we need to re-compile the DataStage jobs, when we upgrading to 7.5.3 version from 7.5.1a?

Thanks in advance.

Thanks to "TOSHEA" and all other responses.

Wonderful. Thanks.

Can you please expand on -open option of Enterprise Stage?

Makes sense. Thank you very much.

Thanks