DSXchange

Hi TPQ, As I mentioned earlier do not use the job parameter which you picked from the environment variables list ($Server_Name) to be used in the DB2 API stage. Create a parameter which is unique to the job say Server_NAME. Create a job sequence and add the environment variable $Server_Name in the j...

Hi, Are you using the DB2 Enterprise Stage or DB2 API stage? Try connecting to DB2 using these 2 stages. Dont use the environment variable for now. Just create a job parameter say server and try to use the parameter. I have had the same issue with Teradata Multiload stage. It does not accept paramet...

Hi,

Even I have faced some weird issues with StringtoDecimal Conversion.

Just trim the string before doing the conversion.

HTH
--Rich

Hi Kumar, Pls frame your question properly in order to get a quick and correct reply. What I understand is that if the 3rd job got aborted, the next time you run the sequence you want to continue with the 3rd job. Is that so? If that is the case use the checkpoint option available in the job propert...

Hi aaikat,

After join stage have a copy stage to branch the records to a transformer and an aggregator(in sequential mode) to get the record count.

HTH
--Rich

Hi John, We are facing the same issue that you have mentioned. We have a Teradata API stage which works fine. But if it is pulled into a shared container the osh script generates DSCAPIOP_ before all the parameter names and causes a connect failure. We are running Datastage 7.5.2 on Linux Suse. Can ...

Hi, By default the stage operators can be combined. If you want to override for a specfic stage you can set the combinability mode for the stage to Dont Combine. For Fault analysis you have to use the environment variable APT_DISABLE_COMBINATION to True and run the job. The job log will show exactly...

Aoccdrnig to a rscheearch at an Elingsh uinervtisy, it deosn't mttaer in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht frist and lsat ltteer is at the rghit pclae. The rset can be a toatl mses and you can sitll raed it wouthit porbelm. Tihs is bcuseae we do not raed ervey lt...

Hi, Do list_readu $DSHOME/bin/list_readu This will show the list of open jobs and who is working on that. If you want to release the lock on the job do this 1) Login in into the Datastage server box from the command line as datastage adminstrator 2) goto Home directory i.e DSEngine directory 3) ente...

Hi,

We had a similar issue.

Follow this link. It should be resolved soon.

HTH
--Rich

Excellent Work!!

--Rich

Hi Seanc, From the CDC take the output to the transformer. In the tranformer have 2 constraints. 1. change_code=1 or change_code=3 (New Inserts) 2. change_code=3 (Old record Updates) The output from the constraint 2 should go to a join stage where you join with the old records. Now you have 2 stream...

Hi, Code 132 means that the dataset is not available. Code 1 means the File path is incorrect. Code 134?? Are you using $APT_CONFILE_FILE. The Datatype should be FilePath and it should point to the right Configuration file. But Iam not sure whether I got Code 138 or Code 134. Kumar, You dont get any...

Hi Amit,

Do a search on Modify stage. Modify stage uses direct orchestrate functions. Search the Orchestrate manuals and you will find the orchestrate functions to be used in Modify stage.

In this case it will Date_From_String

HTH
--Rich

Hi Sam,

If you intent to do this within DataStage use 2 column import stages one for detail and other for trailer. The outputs of the 2 column import stages will be 1 varchar column with a fixed width. Use the funnel to merge both these outputs and load it into sequential file.

HTH
--Rich