DSXchange

Yes, I am referring to Datastage Logs. The Logs which appear as warning in director should be stored somewhere on the datastage server as files. I want to know if we can access these files and where it will be stored(just like logs are stored in metadata table when it comes to oracle....)

I am getting the Warnings in the Log, but is there any file in which it is also logged which I can access.
I know I can get the log by using DSGetLogSummary function, but that will consume a lot of memory.
I want to know if there is any place where the log will get stored....

Wanted to know about the way Log files are maintained in DB2 similar to Oracle where we have Metadata table which stores the Log entries. Is there anything similar in DB2 which stores the Log files....
Any info on this will be very helpful..

Where do i use this UPDATE statement?

Is thos a built in function?? I am not able to use this function..

I am declaring different stage variables for each key column.
But, how do I use these stage variables in the Output derivation...

Is there any function similar to RowProcGetPreviousValue which can be used for multiple fields or if i have to use stage variables?
In case of stage variables how do i reset the sequence based on the 3 keys(3 stage variables)..

I am using Stage Variables. I have declared 2 stage variables. One for A and one for B. StageVar1: If DSLink5.A = RowProcGetPreviousValue(DSLink5.A) or @INROWNUM = 1 then StageVar1+1 else 1 Var1:DSLink5.A = RowProcGetPreviousValue(DSLink5.A) In the Output derivation for A, I am giving StageVar1. But...

My Problem is i do not know how to reset the value of d (which will be a sequence) once the combination of my primary keys changes.

Sorry for the post. I did a search and was able to find the answer.

My table has 3 keys a,b,c.
d is a column in which i have to generate a sequence(1,2,3,...)
The sequence has to be reset when the surrogate keys (combination of keys) change.
I am able to generate the sequence but do not know how to reset it.
Any suggestions regarding this would be very helpful.

Thanks DSguru, I will contact my DBA regarding this..
thanks a lot for the information...

Any Idea why these error messages are coming..

Hi, I am getting 2 different error messages in my datastage job. My target database is DB2. First Error Message ================ Job Name..DB2_UDB_API_0: [IBM][CLI Driver][DB2] SQL0443N Routine "SQLTABLES" (specific name "SQLTABLES") has returned an error SQLSTATE with diagnostic...

I think I am doing something seriously wrong...
It is still not working...