DSXchange

hi, It is not at all the DataStage issue. I can assume that you have not given proper link condition in sequence. :) By default the link condition is "Unconditional" and hence it will trigger the second Job Activity irrespective of the 1st Job Activity (Job) status. If you want to terminat...

ray.wurlod wrote:Welcome aboard.

There's nothing automatic, but you can design recovery.

As noted, designing recovery will require that you keep track of how far the job has got before it fails. ...

Ray, are you reffering to the other new post with subject line "Disigning Recovery handling" :D

Neeraj, Are you sure that the file systems are getting full only if you run the sequences? If your answer is yes, then by any chance are your sequences/jobs creating the FlatFiles? If you are loading the files with large amount of data, the size might exceeds its capacity. Just cross check the size ...

sagar, You will get the delete rows and its corresponding delete code. Of course this depends upon the property value for "Drop output for delete". The other field value is simillar to as it is in the Before link. Reason is, the delete record obviously will not be present in the After data...

I assume that the (In_Amex_Chnt1_Demo.CHN_STAT_DTE) field is of timestamp and your target field is of string type. Try out this: If (IsNotNull(In_Amex_Chnt1_Demo.MERCH_PRNT_CHN_NBR) And (In_Amex_Chnt1_Demo.MCT_STAT_COD = 'C') And IsNotNull(In_Amex_Chnt1_Demo.CHN_STAT_DTE) ) Then TimestampToString(In...

Hi all, I have a requirement to develop some jobs (to read SAP data) in DS V7.5.1. But after some month down the line, I have to use these jobs in DS V8.0. As per my knowledge, DS V8 will support only SAP PACk V6.0. If I simply import the DS V7.5 jobs (which uses Pack V5.2) to DS V8.0 will not serve...

Have you installed Oracle client on your machine

Try to dump the records in DataSet rather than the peek and view the data->for debug purpose.

Try to dump the records in DataSet rather than the peek and view the data->for debug purpose.

I think you have not mentioned the field length along with the data type as CHAR. For fixed width file, you have to qoute the field length along with data type as CHAR.
I believe the warning is not because of the original table definition.

Try with an escape character.

Will get the category name with the hierarchy. Guess you will have to run it using DSExcute().

Define the file path parameter as a job parameters. And give the parameter name in the value expression.

I think the routine name and the function inside the routine should be the same. in your case both of them should be "replace". I got this error sometime back and i think this solved it.

Concatenate is same ":" in parallel as well. You can do it in a transformer stage. Not sure about Modify though.