XML Extraction from Sequential Stage ?
Moderators: chulett, rschirm, roy
XML Extraction from Sequential Stage ?
Hi !
My Job Structure is as follows:
<b>
Seq Stage ---> XML input ---> TX Stage----> Lookup File set
</b>
The problem is in the
Seq stage, the parameters are as follows:
File Pattern : acential/datastage/folder/xml/data/*.xml
Read Method: File Pattern
Other Parameters are default
XML Input stage,the parameters are as follows:
XML source column: FileContent
Column Content: XML Document
Validate input XML : yes
level: strict
after I run my job, the following error comes:
<b>
sq_Stage_File,0: Source subproc: cat: 0652-050 Cannot open /ascential/datastage//folder/xml/data/*.XML.
sq_Stage_File,0: Filter status 512
Filter process failed: 2
Import error at record 0
Please let me know where Am I wrong ?
Thanks,
Nitin
My Job Structure is as follows:
<b>
Seq Stage ---> XML input ---> TX Stage----> Lookup File set
</b>
The problem is in the
Seq stage, the parameters are as follows:
File Pattern : acential/datastage/folder/xml/data/*.xml
Read Method: File Pattern
Other Parameters are default
XML Input stage,the parameters are as follows:
XML source column: FileContent
Column Content: XML Document
Validate input XML : yes
level: strict
after I run my job, the following error comes:
<b>
sq_Stage_File,0: Source subproc: cat: 0652-050 Cannot open /ascential/datastage//folder/xml/data/*.XML.
sq_Stage_File,0: Filter status 512
Filter process failed: 2
Import error at record 0
Please let me know where Am I wrong ?
Thanks,
Nitin
Your biggest problem is the fact that the Sequential stage cannot deliver the entire contents of the XML file in one record/field like the Folder stage can in Server.
You need to see if it can pass in the fully qualified path to the XML file and then switch the XML Input stage to use the 'URL' option.
You need to see if it can pass in the fully qualified path to the XML file and then switch the XML Input stage to use the 'URL' option.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Please explain me what do you mean by fully qualified path?chulett wrote:Your biggest problem is the fact that the Sequential stage cannot deliver the entire contents of the XML file in one record/field like the Folder stage can in Server.
You need to see if it can pass in the fully qualified path to the XML file and then switch the XML Input stage to use the 'URL' option.
How do I get through this problem ?
thanks,
nitin
A fully qualified path is a path which has an absolute path that begins with the root directory on unix, i.e. /tmp/DataStage/Data/Test/DSXChange/test.seq
The other type of path is relative, which starts at some other point, usually the CWD (Current Working Directory) and this type of path looks like "./DSXChange/test.seq" or "test.seq" or "../OtherPath/test.seq"
The other type of path is relative, which starts at some other point, usually the CWD (Current Working Directory) and this type of path looks like "./DSXChange/test.seq" or "test.seq" or "../OtherPath/test.seq"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A fully-qualified pathname begins with a slash character (on UNIX) or a drive letter or backslash character (on Windows).
A relative pathname does not begin thus, and is considered to be relative to the current attach point.
A relative pathname does not begin thus, and is considered to be relative to the current attach point.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: XML Extraction from Sequential Stage ?
Hi,nitin376 wrote:Hi !
My Job Structure is as follows:
<b>
Seq Stage ---> XML input ---> TX Stage----> Lookup File set
</b>
The problem is in the
Seq stage, the parameters are as follows:
File Pattern : acential/datastage/folder/xml/data/*.xml
Read Method: File Pattern
Other Parameters are default
XML Input stage,the parameters are as follows:
XML source column: FileContent
Column Content: XML Document
Validate input XML : yes
level: strict
after I run my job, the following error comes:
<b>
sq_Stage_File,0: Source subproc: cat: 0652-050 Cannot open /ascential/datastage//folder/xml/data/*.XML.
sq_Stage_File,0: Filter status 512
Filter process failed: 2
Import error at record 0
Please let me know where Am I wrong ?
Thanks,
Nitin
I have to extract all the xml files from the particular directory in Unix, So when I use wildcards *.xml in that directory using seq stage , I get above error. Also, what format setting should be there in sequential stage for xml files.
Please advise me , How to use sequential stage with same functions as Folder stage (server) ?
The job structure is listed above,
thanks,
Nitin
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: XML Extraction from Sequential Stage ?
hi , am not that much expert to ans this..but i have some thing to share with u, i can see ur path is "/ascential/datastage//folder/xml/data/*.XML."
ok , before folder ans after datastage specify only one one "/"
for ex:"/ascential/datastage/folder/xml/data/*.XML" dont know whether this works or not but jst i want to sahre with u.
thnx
ok , before folder ans after datastage specify only one one "/"
for ex:"/ascential/datastage/folder/xml/data/*.XML" dont know whether this works or not but jst i want to sahre with u.
thnx
nitin376 wrote:Hi !
My Job Structure is as follows:
<b>
Seq Stage ---> XML input ---> TX Stage----> Lookup File set
</b>
The problem is in the
Seq stage, the parameters are as follows:
File Pattern : acential/datastage/folder/xml/data/*.xml
Read Method: File Pattern
Other Parameters are default
XML Input stage,the parameters are as follows:
XML source column: FileContent
Column Content: XML Document
Validate input XML : yes
level: strict
after I run my job, the following error comes:
<b>
sq_Stage_File,0: Source subproc: cat: 0652-050 Cannot open /ascential/datastage//folder/xml/data/*.XML.
sq_Stage_File,0: Filter status 512
Filter process failed: 2
Import error at record 0
Please let me know where Am I wrong ?
Thanks,
Nitin
Re: XML Extraction from Sequential Stage ?
Rajan.n had a good idea, try changing yournitin376 wrote: File Pattern : acential/datastage/folder/xml/data/*.xml
Read Method: File Pattern
file pattern to be absolute, e.g. start with a leading slash.
Unix might be: /acential/datastage/folder/xml/data/*.xml
Windows might be:
C:/acential/datastage/folder/xml/data/*.xml