DSXchange

Thanks for the response.
how do I exit from the loop? using terminator activity? but this would abort the sequence. Can I exit grace fully without aborting the sequence.

The Job3 overwrites the file.

Hi, I have a scenario where Job1, Job2 and Job3 run in a sequence one after another. Input for Job 1 is a sequential file and output for job3 is the same sequential file. I want to put these 3 jobs in a sequence and run in a loop untill the input sequential file is "empty". Can this be ach...

True, it would be better having a low value like you have suggested but we dont have control over the source feed .

Regards
Om

Well I guess thats the only way around.
Thanks for your time.

Regards
Om

Hi, We have problem in reading CSV sequential file. The date column is nullable and is a empty string when null. The null field value is set to "", the SQL Type set for the column is Date with length 10. The date format is %yyyy-%mm-%dd. At field "dt": A fixed length field cannot...

Hi,
Thanks for you reply.

It works like charm.

Hi We have a shell script which is executed after a job successfully completed. The script is executed through "Execute Command Activity". But the problem is we have to pass the full path of the script in the "Command:". We want to parameterize the path of the script which would ...

Craig, Thanks for your response. I'm certainly not an angry man and dont have high BP, I control my diet and exercise daily for this. :D Allow me to explain my problem: We are facing problem whenwe use the Date datatype in my source-target columns. If we simply allow the stage to generate the SQL in...

Hi, Thanks for your response. I'm using oracle to_char() function. when reading and to_date() function when writting but the constaraint is I could only use the following combination otherwise I dont get the desired result. When reading to_char(column_name,"YY-MON-DD") When writting to_dat...

Hi, We are using the 8.0.1 version. We are facing problem while reading and writting from and to Oracle OCI stage. Though we can view (view button) the data from the stage but when the job runs we get the following error:ORA-01036: illegal variable name/number. But the same query runs fine from SQL ...

Thanks for your response.
No we dont have enterprise edition.
So can we classify this as datastage bug.

Hi Guys,

I have problem when I try import table defination through Plug-in metadata table defination.
The length for varchar2 and char are not imported.
While there is no problem when we import through ODBC.

Hi
In the 8.0.1 version when we login it asks for a Domain and Server.
What is the difference between the two.

Thank You