Search found 3 matches

by devanathan_82
Wed Oct 15, 2008 12:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading " from a sequential file with quotes double set
Replies: 2
Views: 661

I tried this option of doubling the quotes. But it reads the Hello in the first field and after seeing the double double quotes skips to next field and reads World"" as the next field. The " are read in the World string but for the wrong field.
by devanathan_82
Wed Oct 15, 2008 8:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading " from a sequential file with quotes double set
Replies: 2
Views: 661

Reading " from a sequential file with quotes double set

Hi, I am trying to write " as a literal in the file. The sequential file stage to read this has Quotes=double specified in the format. This is a common job so I cannot remove the quote or change it as some other jobs might be impacted. Is there a way that I can pass the double quotes in my data as a...
by devanathan_82
Wed Oct 15, 2008 8:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with reading Date value from Mainframe using API stage
Replies: 1
Views: 710

Issue with reading Date value from Mainframe using API stage

Using API stage to ready from IBM DB2 (Z/OS). When there are date values of 0001-01-01 the records are skipped by Datastage saying the minimum date value should be 0001-01-03. Is there a patch or some setting to get datastage to read this data properly.