nls_read_delimited()

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Indra
Participant
Posts: 8
Joined: Fri Aug 25, 2006 7:58 am

nls_read_delimited()

Post by Indra »

Hi all,

Iam trying to read xml doc as i/p to sequential file. i have specified as " as delimiter. my sample i/p looks

<Record Identifier="V0" DateModified="1899-12-30" TimeModified="00.00.01" Type="ContainerView" Readonly="0">
<Property Name="Name">Job</Property>
<Property Name="NextID">1</Property>


now in i/p row 1: field 1:<Record Identifier=
field2:V0...
row2; filed1;<Property name
But i do get an error like "nls_read_delimited() - row 1, column field6, required column missing' and i dont understand how some values goes to next row.

Can anyone give me a solution .

Thankx
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What is your delimiter character? Does this character appear anywhere in the data? How, precisely, is field6 defined? Is what you've posted on one line or three lines in the source file?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply