DSXchange

Hello, I have to insert number of rows in to DB table, At the same time I want to know , If Insert was a success then I want to write in one file else I want to write in another File. Is there any way, I can check about the status of insert, may be link status etc.? input---xformer--> insert | | IF ...

Thanks for your help. We were having problem with Configuration. Batch User was not added into Project, Hence we were getting error. But this is surprising, Instead of generating message like "insufficient previledge", we are getting -99 etc.

Once again, Thanks for your help

We are getting following set of problems in executing a job. Error running job Status code = -99 DSJE_REPERROR Error running job Status code = -14 DSJE_TIMEOUT Error running job Status code = -14 DSJE_TIMEOUT Any suggestion??? I am getting above error when execute the job in Batch mode, I am able to...

I am eager to know how to handle exception raised by Oracle. We are using a file and then looking a database for some additional fields. We are experienceing a probelm in lookup. We are using RDB on VAX as lookup. We have problem with date field. Date field in RDB is having a date with year as 5 Dig...

I am eager to know, is there any way to handle exceptions raised by any SQL statement. For example. I am reading a file and inserting into ORACLE Table. I have used INSERT ROWS WITHOUT CLEARING. Now I want to trap the error due to UNIQUE CONSTRAINT Voilation. IN this case I want to go ahead and cont...

I am eager to know, is there any way to handle exceptions raised by any SQL statement. For example. I am reading a file and inserting into ORACLE Table. I have used INSERT ROWS WITHOUT CLEARING. Now I want to trap the error due to UNIQUE CONSTRAINT Voilation. IN this case I want to go ahead and cont...

We are running a job in server and getting following error code.
Status code = -14 DSJE_TIMEOUT

We have tested this job in other environment and worked.

Any idea why we are getting this error.
We are getting this error during RESET of job and also during execution.


Thanks,

I am trying to read a line from file and then generate 2-6 rows from same line. I have two fields Begin Date and end-Date, For each month between Begin Date and end Date, I have to generate a row. I have written this procedure, and calling from after stage of Transfarmer. This component execution is...

I figred out that I need an exit and modified code as per below. DEBUG ErrorCode = 0 ; * set this to non-zero to stop the stage/job infilename = Field(TmpFileDirectory_PHSCO, ",",1,1):"/MMR_XREF_S1.DAT":Field(TmpFileDirectory_PHSCO, ",",2,1) outfilename = Field(TmpFileD...

Ray, Thanks for your reply. I have written following code. DEBUG ErrorCode = 0 ; * set this to non-zero to stop the stage/job infilename = Field(TmpFileDirectory_PHSCO, ",",1,1):"/MMR_XREF_S1.DAT":Field(TmpFileDirectory_PHSCO, ",",2,1) outfilename = Field(TmpFileDirecto...

Hi, I am new to writing routine in Datastage. I created the one, logic looks fine to me, But I want to know how to Debug this routine. I checked the manual and they say use DEBUG statement. I am not sure where to use this statement. Any help on this will be highly appreciated.

Thanks,
Gulshan

I have created a job, which accepts parameters and based upon that it retrieve data from Oracle Table. Now I want to know how Can I handle no_data_found exception... Currently it is executing succesfully but I want to abort the job when it is unable to find the data based upon parameters.. Any help ...

Thanks for your reply. I want to knwo how to use this stage. I have create aInput File stage which is input to Transformation stage and then it is input to ORABULK stage. I am wondering, How will it load the data directly to table. As per Documentation, I need to go SQLLDR... is it true?? If yes the...

I am new to Datstage, Can anyone help me in using ORABULK stage. I have to load file in to Oracle Database (9.x). Any help on this will be highly appreciated.