Search found 5 matches

by anshulroy
Thu Apr 11, 2013 1:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: String to Timestamp Conversion having Null in Source
Replies: 4
Views: 4236

Hi, I have done the above code. But got warning. APT_CombinedOperatorController(0),0: Conversion error calling conversion routine timestamp_from_string data may have been lost My Source value is Null or ''. I did implement handing both the cases. Whatever change i am doing, but i am getting this war...
by anshulroy
Thu Apr 11, 2013 12:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: String to Timestamp Conversion having Null in Source
Replies: 4
Views: 4236

String to Timestamp Conversion having Null in Source

Hi, We are reading the source file in VarChar Format & performing the column metadata conversion in transformer as per the target metadata. In one of the file, a column is Null in Source file. The target for this column is Timestamp. I have tried all ways of Null Handling, assigning default and ...
by anshulroy
Wed Apr 03, 2013 12:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using CFF Stage for Mainframe Files
Replies: 1
Views: 1487

Using CFF Stage for Mainframe Files

Hi, I am using CFF Stage to read the Mainframe files. Till now , we were getting fixed width Binary file and we were able to read them. When i say fixed width, we used to get files with a dot(mainframe tab) between two columns & we used to add a filler in between of one charachter length to read...
by anshulroy
Sun Jun 20, 2010 11:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in Reject file
Replies: 4
Views: 2533

One more important point is the errors are coming only in the reject files associated with lookup rejects. Is there any particular setting that we need to implement in this new server for lookup to resolve this issue.
by anshulroy
Sun Jun 20, 2010 11:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in Reject file
Replies: 4
Views: 2533

Error in Reject file

We have a new server. The jobs have been moved to this server. While executing the jobs, we are getting erro in reject files These errors are not coming when the same job is executing in the previous server. The errors are like columns input into the reject files are not available."Could not fi...