Sure!
I'm using this in a Transform stage:
If IsNull(LNK_EXEC_TASK.DESCRIPTION) THEN "-1" ELSE Convert(char(13)|char(10)," ", LNK_EXEC_TASK.DESCRIPTION)
Search found 3 matches
- Thu Jun 25, 2009 9:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Line breaking in sequential file
- Replies: 5
- Views: 1211
- Thu Jun 25, 2009 2:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Line breaking in sequential file
- Replies: 5
- Views: 1211
hi Chullet! Yeah, I thought like that! Removing the pairs. But I had not success on doing that in DataStage. I've tryed to use Convert() function in a Tranform stage, changing every char(13) and char(10) for a simple white space, but it continues creating that breaking lines in the description field...
- Wed Jun 24, 2009 7:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Line breaking in sequential file
- Replies: 5
- Views: 1211
Line breaking in sequential file
Hi everybody! As I'm new here at this community, maybe I haven't see all the topics for this question. Even so, I'm facing this problem in a sequential file. I've created two jobs, one to query a table in a DB2 database and creates a sequential file with some records. The other reads this file. Ther...