Search found 33 matches
- Tue Oct 20, 2015 6:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Leading Question Mark Appears on First row of data
- Replies: 6
- Views: 5328
Hi Guys, We found a workaround for the problem w/ the following way. 1.) Added the column names on first line, increased field length to conform to this. The first line with the column names now contains the question mark character. 2.) Set the Target Sequential File to First Line Column Names = Fal...
- Tue Oct 20, 2015 2:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Leading Question Mark Appears on First row of data
- Replies: 6
- Views: 5328
Hi, We copied the file to the FTP Server without any suspicious characters (20150615), format is in UTF - 8. Then when the FTP Stage reads it the question mark appears. So we tried to copy the file again from FTP to local path. And the result becomes like this 20150615 (there is a dot on the middle...
- Tue Oct 20, 2015 12:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Leading Question Mark Appears on First row of data
- Replies: 6
- Views: 5328
- Mon Oct 19, 2015 7:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Leading Question Mark Appears on First row of data
- Replies: 6
- Views: 5328
Leading Question Mark Appears on First row of data
Hi, I have a file which is encoded in UTF-8 and has EOL = CR/LF. When we are reading this file on the FTP server, the first row, first column data has a leading question mark. Can anyone help what is causing this problem. Sample Data: ?2015061 abcdefg 20150616 efghijkl 20150617 mnopqr Other info. NL...
- Wed Aug 12, 2015 9:55 am
- Forum: General
- Topic: Increment Date on a Sequential File.
- Replies: 10
- Views: 4292
- Wed Aug 12, 2015 9:22 am
- Forum: General
- Topic: Increment Date on a Sequential File.
- Replies: 10
- Views: 4292
- Wed Aug 12, 2015 8:53 am
- Forum: General
- Topic: Increment Date on a Sequential File.
- Replies: 10
- Views: 4292
- Wed Aug 12, 2015 8:25 am
- Forum: General
- Topic: Increment Date on a Sequential File.
- Replies: 10
- Views: 4292
Increment Date on a Sequential File.
Hi, I have a sequential file which contains a date 20150812 We read it on a sequence job using execute command and pass it on to a user variable activity then to our sequence job so that our job can get its value. My question is it is possible to increment this date and taking to account valid dates...
- Mon Jul 20, 2015 10:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help with Logic on Rejecting Records.
- Replies: 5
- Views: 2864
- Mon Jul 20, 2015 9:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help with Logic on Rejecting Records.
- Replies: 5
- Views: 2864
Help with Logic on Rejecting Records.
Hi Everyone, I have a stream of data that looks like this col1|col2|col3|col4|col5 Null|Inconsistent|Valid|Valid|Valid Valid|Valid|Valid|Valid|Valid Null|Valid|Valid|Valid|Valid Valid|Inconsistent|Valid|Valid|Valid Now our problem is on the transformer stage we do a constraint which when Column is n...
- Wed Jul 15, 2015 9:37 pm
- Forum: General
- Topic: Null Handling Function on Environment Variable.
- Replies: 7
- Views: 3439
- Wed Jul 15, 2015 2:04 am
- Forum: General
- Topic: Null Handling Function on Environment Variable.
- Replies: 7
- Views: 3439
Null Handling Function on Environment Variable.
Hi Everyone,
Is it possible to check if an environment variable or a parameter is null? Because on job properties variables dont have nullability option.
Hope you can help me.
Thanks.
Is it possible to check if an environment variable or a parameter is null? Because on job properties variables dont have nullability option.
Hope you can help me.
Thanks.
- Mon Jul 13, 2015 6:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp To Numeric
- Replies: 4
- Views: 2876
- Mon Jul 13, 2015 5:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp To Numeric
- Replies: 4
- Views: 2876
- Mon Jul 13, 2015 5:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp To Numeric
- Replies: 4
- Views: 2876
Timestamp To Numeric
Hi Everyone,
I have a timestamp column and I wanted it to become a number with format yyyymmdd on the output of a transformer stage. Can anyone suggest method on obtaining this.
Thank you very much.
I have a timestamp column and I wanted it to become a number with format yyyymmdd on the output of a transformer stage. Can anyone suggest method on obtaining this.
Thank you very much.