DSXchange

Thnks for the solution... just one more concern...as per the solution we have to do the following - Create a stage variable called NewID and set as current row ID. - Evaluate OldID against NewID. - Create a stage variable called OldID and set as current row ID. How to set stage Variable NewID with c...

Yes I am sure that it does noe allow more than one output link.Gives error source does not support reject link.

Hi all,
In my parallel job I am passing some sorted data to reomove duplicate stage.I have to capture the rejected data(i.e.duplicate data) from this reomove duplicate stage for some further processing.But reomove duplicate stage does not support reject link. So how can I do this?

Thnx........ :D

Hi In my sequential file (Source) there are more than 1000 records I want to get first 500 records from it for further processing. and wants to pass rest all records to another temporary file. so my query is , In parallel job how can I count and get first 500 records from sequential file? tried with...

when I am trying to extract data from IDOC using DS SAP plugin getting error "ds_loadlibrary: Win32 error in LoadLibrary of dsidoc.dll - The specified module could not be found."

what this error is?

checked for the dsidoc.dll it in system 32 directory.
how to resolve this error.

hi ray , as m new to this tool can you tell me how to caputre the error return by querry or use link var, or routine that inspects the log....... Is anyway it is possible to include / import log generated by DS Director to a text file so that I can attach that in mail.Though I am including job statu...

hi
the job is of parallel type..........

HI ALL m CREATING A JOB WHICH WILL ACCESS A STORED PROCEDURE BUT BEFORE ACCESSING STORED PROCEDURE HAVE TO CHECK WHETHER CONEECTION WITH DATBASE IS SUCCESSFUL OR NOT ? CURRENTLY I HAD IMPLEMENTED THE JOB AS STORED PROCEDURE STAGE -------->SEQUETIAL FILE STAGE THE SEQUENTIAL FILE STAGE IS TO CAPTURE ...

hi how to access parameters returned by stored procedure in DataStage for eg. wwprt.calculateREAL(OUT int, OUT varchar(50)) is the signature of stored procedure and i hv t dev job which will do the following 1.2.1. If the call to DB2 stored procedure fails, write error details to application log, an...

hi
how to create a job just to check whether the connection with datbase is established or failed.........?
is there any routine or macro available if yes hoew to use it.........?

hi
thx for reply
i had done the same but confused about how to check the connection with database is established or fialed .How to create a job that will check the connection status?

1. Connect to database 1.1. If connection fails, write error details to application log, and send e-mail to Operations 1.2. If connection succeeds, invoke DB2 stored procedure: 1.2.1. If the call to DB2 stored procedure fails, write error details to application log, and send e-mail to Operations 2. ...