DSXchange

I have a very simple job with source and target sequential file stages. I have a 100 character Unix file with just 1 line. The columns are: A 10 B 10 C 50 D 30 On the Format tab of the source sequential file stage, I have: Record Level: Final Delimiter: None Record Deliiter: UNIX Newline Field Defau...

I am using a compare stage to compare 2 identical files except for one value in one row. I have a promote subrecord after the compare stage and a sequential file stage after that. However, I cannot get the data that is output by the compare stage into the promote subrecord stage. I looked in the Dev...

Ray, the stage before the sequential file stage is a lookup stage. There is no way to set these properties in the output tab on the lookup stage because the output link is a reject link.

Yes, I did that already. I was looking for a solution without the transformer for performance reasons.

How do you prevent warnings in a reject output file from a lookup? The properties "Null field value" and "Field width" are not editable in this situation.

I would like to append lines to the same sequential file from 2 different stages in the same job. In my current job, the second stage does not write eventhough I have set the update mode append. If the first stage writes 5 lines, I would like the second one to append, for example, another 3 lines so...

Thanks Ray. It worked. Can you tell me if there is a way in PX jobs to only keep alphanumeric characters and strip everything else including non-printable characters without using a routine and Ascii codes?

DSGuru2B, thank you for your response. Yes, I am aware that Convert requires 3 arguments. I made a mistake in my first post. I was already doing the exact same thing that you posted. The error happens because of the 2 double quotes. If I put in a double quote as follows: Convert("~!@#$%^&*(...

I am trying to remove all non-alphanumeric characters from a string. Two questions: 1)How do you do: Convert("""", MyString)? This does not compile. Gives a validation error. 2)Is there any way to do it in PX without writing a routine? I went through all the posts here but I don'...

I have derivation code and I would like to explain it as well within the derivation. How do I do it?

I don't think it is a permission issue. I can write looggin in with this ID using iSeries Navigator directly.

I can write to AS400 DB2 tables directly using iSeries navigator. So, permission is NOT an issue. I can also read using the same stage. However, I cannot write from Datastage using Oracle Enterprise stage. The error I get is: ODBC,0: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries an...

I am trying to connect to an AS400 system and retrieve data from DB2 tables using the DB2 UDB API stage. After going through the posts in this forum, I have concluded that I need to do the following. I would appreciate it if anybody could correct/help me in this regard: 1)I need DB2 Connect installe...

If you look for help on CurrentDate and CurrentTime, you won't find it.

Every now and then, when I am looking for help on a function,
I cannot find it with a search in Help or any of the PDF files.
An example, would be CurrentDate or CurrentTime. Does anybody have
a solution for this?