DSXchange

May be not. Atleast not for all the nodes. Has the Config file been configured for DB2?

Hi Welcome aboard :D !!! Its most likely the connection problem. Make sure you have passing the correct user id and password for the specified instance in the DB2INSTANCE variable. Try connecting from command line with the same user / password has access. If you are passing it as parameter, there ar...

srinath wrote:As per Datastage "StageName is the name of the active stage to be interrogated".. May be you are not giving active stage

He tested in Manager which gave out some value, so we believe correct value is been passes.

Perhaps, you can process the reject file in separate job. Read it as varchar and "deconstruct" as you wish. But still the records which got reject might be due to metadata mismatch, hence you may not parse correctly.

Sainath.Srinivasan wrote:In that case, you can try the 'echo' command to confirm that all parameters are being passed correct.

My first request was to check this. May be the second option could also be used to confirm that.

I think Swathi might have tried to view data from the Sequential stage.
Though it is mentioned as Varbinary datatype, the reject records are stored fully. Try to check the data of the rejected file from unix using cat.

And Return(Ans) at the end.
Also add Call DSLogInfo(Ans,"Return value is :" ) and check the log in Director.

I have faced this in AIX. And not in HP-UX. But as per Dinesh, it occurs in Solaris as well. So I need to check with my end on next time.

Hi Kenneth, One option of yours is to use trigger, which will log the records that are Inserted / Updated / Deleted within specific period. Using the log only those specific records can be extracted and can be used to update the Dimension tables. The other suggestion is the normal CDC which is what ...

If you are referring to the topic that I have linked, its issue with the Job Monitor not been turned on. Which is not your case. What was the answer to my questions? Where are you looking for the result? In log? Are you returning the "Ans" the variable where you consolidate the values? Have you trie...

Calling StoredProcedure is possible from Datastage. Is it possible to Call Java code from Stored Procedure. Perhaps you can answer for this.

What is the value of dsdlockd.config that avialble in $DSHOME? Try configure the Timerto 900, it should pretty much take care automatically. If that was set properly and if you still find many process left orphaned, close all the Datastage session and ensure there is not locks held by any clients. T...

Where are you looking for the output?
Are you RETURNing the "Ans"?
Try to write the Ans into a sequential file.
Even if that value found in Sequential file didn't give you expected result, for testing purpose, hard code all the parameters like job name, SrcStgName,SrcLnkName etc., and try a run.

Ok, Date of Oracle is different from Date of Datastage. Oracle Data dataype has time component in it. Where as Datastage has two seperate datatypes as Date and Timestamp. So you need to convert it into char while extraction using TO_CHAR() function and convert it back to date using TO_DATE() functio...

Hi Sathish, Server forum would be more appropriate. As noted in other thread, using ExecuteCommand activity you can call the OS level commands. If its just an executable, you can directly call it using Execute comman activity stage. Else you can write the Batch file and execute it. Btw, how you call...