DSXchange

Hi, I have similar requirement as explained in this link. I did the same procedure for passing one run time value as parameter for 'where' clause the job 2. Steps followed: a. Created a routine "GetDate" with Arg1 and with code "Ans = Arg1" b. Created Job-1 to fetch the Data valu...

ArndW , I am sorry for the confusion, this is a issue with IIS Datastage 8.5 and its installed in unix. Yes, I am able to view that path via Datastage. Ray, I am not able to view your entire reply as I am not a premium member :( Can you please send me again in a format such that non-premium members ...

Hi, I have a routine which opens a file if it exists else it creates one. Note: This is only a part of actual routine If NOT(Initialized) Then * Not initialized. Attempt to open the file. Initialized = 1 Open "EndDateFile" TO StopDateFile Else * Open failed. Create the sequence file. EXECU...

Hi,

Thanks. But heard there is a Windows XP option on Win 7, will that work ??

Or what is the other ways to do it apart from uninstalling the OS.

Thanks,
dxk9

Hi,

Just wanted to know if Datastage 7.5.2 Server Edition is supported by Windows 7.

Few blogs say the client is supported & the others say it might cause some issue while the jobs are run.

Please let me know. Thanks.

Regards,
dxk9

Zulfi,

Thanks !! Your suggestion worked

Ray,

As of now its working, will also know the Teradata default date format from DBAs for future reference.

Thanks,
dxk9

Hi, I have a input sequential file with a field value '2010-05-16'. Need to convert this into Date & load it into a Teradata table. Based on Dsxchange suggestions, I tried different combinations of oconv & iconv. But it doesn't work. The error says: Value treated as NULL Attempt to convert S...

How to check on the 'interprocess row buffering' and what kind of impact does it hold on the behaviour..

I read through this, but since I couldn't test it to really understand the flow, felt your thoughts might be more helpful in understanding the concept.

Thanks,
dxk9

Very true Ray.. !! I agree to ur point..

Its not free.. so its not easy

Thanks Craig !!

But I got only your 1st statement, wasn't able to read the rest of them as its a 'premium content'

Thanks,
dxk9

To add on.. The array size & Transaction size of both are (1,200).

Thanks,
dxk9

We don't have any delay in the processing of records in Link1 (insert else update) & Link2 (update). Especially don't want Link 2 to be faster than Link1. But since the logic of both the links are different, we thought it might be an issue. So since you say that Link1 processes first before the ...

Hi, I have a job which reads data from DB2.. Upserts them into DB2 (link 1) & update a flag in DB2(link 2). How this works ?? Will the 1st record sent to Link 1 gets processed before its being sent to link 2 ?? Or the transformer link ordering doesn't have any impact on this & the records fl...

Hi, Thanks for your response. The issue here is, we fetch rows from X where flag = 'N', and when it loads into Y, we also update the flag = 'Y' in X. The update cannot be done in different job cause everytime we have to run the File to update X job as well. So if the actual job fails, then the updat...