DSXchange

Please provide your inputs on the following:- Source Column:- Varchar (Null) [Converted to varchar while reading from Database] Target Column:- Date (Null) Source Column can contain value less than '1753-01-01', which we have to set as '1753-01-01'. Error getting:- Target Column is getting ***** in ...

Please post the solution for this. How it get resolved?

Hi, The issue with the job got resolved. I re-started the jobs again after some time, with the expectation that SIGBUS is an operating system error and it is not related to any of the Job logic. The job ran fine. Which clearly shows the issue with the resource contention. Please post any other issue...

Hi, I have a server shared container used in Parallel job. This job was running fine. The Parallel Job flow of job is as below:- Seq_File_Stage ---> ServerSharedContainer ---> Output Flow of Server Shared Container:- ----> Transformer [One lookup link on Basic Transformer] ---> Three Out put link. T...

All files/directories in the project that have names of the form DS_namennn or RT_namennn are the Repository tables in which information about job number nnn are stored. [/b] Hi Ray, Thanks for the info. From where i can get more details about these? How we can view the repository contents in V 7.5...

The main reason of using was, it was implemented from start like this, and just want to keep the uniformity in handling all the Datastage jobs. Or in other words, i cann't force this change for one single module. Just want to confirm what you are saying about -jobstatus, is it something related to D...

Hi Chulett, The return code will be zero only when the sequencer will have finished without warnings. We are using this return value to store in a Table, which is getting used by other Java code for further buisness logic execution. This logic is in place from long time in my application, but for th...

We are trying to capture the status of job with the help of following routine:- -------------------------------- $INCLUDE DSINCLUDE JOBCONTROL.H Call DSSetUserStatus (Arg1) Ans = Arg1 -------------------------------- If Agr1 has Value as 0 then Success or 100 then Failure.This value we are getting w...

I am trying to utilize this multiple readers per node option in the sequential file stage. My parallel environment is SMP. My APT Configuration File has two logical nodes on the same physical box (SMP env). If i am choosing 2 readers per node option, then how many readers will be generated to read t...