How to convert Db2 query result set to an XML file based on a given XSL using IBM DataStage?Expose DB2 data as XML / Query DB2via XMLIBM DB2 tb1 tb2 tb3 tb… strange filesExport SQL query results as XML in DB2 scriptImporting .sql file into IBM DB2 Express-Clist registered XML schemas in DB2 for IBM iDatastage: set web server trasformer stage url from queryHow to store the result of a select query into a variable(IBM DB2)?Inserting into mysql table based on results from a db2 query in php scriptDatastage v9.1 - run user defined sql query file using odbc connectorZero not returning in DB2 when select query yields no result
when is out of tune ok?
Implement the Thanos sorting algorithm
Fastening aluminum fascia to wooden subfascia
A particular customize with green line and letters for subfloat
I'm in charge of equipment buying but no one's ever happy with what I choose. How to fix this?
Trouble understanding the speech of overseas colleagues
Go Pregnant or Go Home
How does Loki do this?
What is the difference between "behavior" and "behaviour"?
How to run a prison with the smallest amount of guards?
You cannot touch me, but I can touch you, who am I?
Anatomically Correct Strange Women In Ponds Distributing Swords
Large drywall patch supports
Is `x >> pure y` equivalent to `liftM (const y) x`
Short story about space worker geeks who zone out by 'listening' to radiation from stars
Balance Issues for a Custom Sorcerer Variant
Class Action - which options I have?
Customer Requests (Sometimes) Drive Me Bonkers!
How do I rename a Linux host without needing to reboot for the rename to take effect?
How can we prove that any integral in the set of non-elementary integrals cannot be expressed in the form of elementary functions?
Was Spock the First Vulcan in Starfleet?
How can a function with a hole (removable discontinuity) equal a function with no hole?
Why not increase contact surface when reentering the atmosphere?
Valid Badminton Score?
How to convert Db2 query result set to an XML file based on a given XSL using IBM DataStage?
Expose DB2 data as XML / Query DB2via XMLIBM DB2 tb1 tb2 tb3 tb… strange filesExport SQL query results as XML in DB2 scriptImporting .sql file into IBM DB2 Express-Clist registered XML schemas in DB2 for IBM iDatastage: set web server trasformer stage url from queryHow to store the result of a select query into a variable(IBM DB2)?Inserting into mysql table based on results from a db2 query in php scriptDatastage v9.1 - run user defined sql query file using odbc connectorZero not returning in DB2 when select query yields no result
Trying to covert a Db2 query result set to an xml file based on xsl. Can we use the below pattern?
DB2 Connector -> XML_Transformer Stage (imported xsl) - XML _Output Stage.
Thanks...R
xml-parsing db2 datastage
edited Mar 21 at 19:00
probitaille
581523
asked Mar 21 at 15:55
Rahul KRahul K
31
New contributor
Rahul K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Trying to covert a Db2 query result set to an xml file based on xsl. Can we use the below pattern?
DB2 Connector -> XML_Transformer Stage (imported xsl) - XML _Output Stage.
Thanks...R
xml-parsing db2 datastage
edited Mar 21 at 19:00
probitaille
581523
asked Mar 21 at 15:55
Rahul KRahul K
31
New contributor
Rahul K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Trying to covert a Db2 query result set to an xml file based on xsl. Can we use the below pattern?
DB2 Connector -> XML_Transformer Stage (imported xsl) - XML _Output Stage.
Thanks...R
xml-parsing db2 datastage
edited Mar 21 at 19:00
probitaille
581523
asked Mar 21 at 15:55
Rahul KRahul K
31
New contributor
Rahul K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Trying to covert a Db2 query result set to an xml file based on xsl. Can we use the below pattern?
DB2 Connector -> XML_Transformer Stage (imported xsl) - XML _Output Stage.
Thanks...R
xml-parsing db2 datastage
xml-parsing db2 datastage
edited Mar 21 at 19:00
probitaille
581523
asked Mar 21 at 15:55
Rahul KRahul K
31
New contributor
Rahul K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Mar 21 at 19:00
probitaille
581523
asked Mar 21 at 15:55
Rahul KRahul K
31
New contributor
Rahul K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Mar 21 at 19:00
probitaille
581523
edited Mar 21 at 19:00
probitaille
581523
edited Mar 21 at 19:00
probitaille
581523
581523
asked Mar 21 at 15:55
Rahul KRahul K
31
New contributor
Rahul K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Mar 21 at 15:55
Rahul KRahul K
31
asked Mar 21 at 15:55
Rahul KRahul K
31
31
New contributor
Rahul K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Rahul K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Rahul K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
There are multiple options assuming you do not have XML already in your Db2 table,
you do not need the XML Transformer.
I strongly suggest you use the modern Hierarchical stage (also known as XML stage depending on the version of DataStage) so I would go for following structure if you want a file or files as a target.
Db2 Connect -> Hierarchical stage -> Sequential File stage
In addition, Db2 offers lots of XML functionality to generate XML by using SQL or XQuery.
edited Mar 21 at 19:49
computersciencestudent
231
answered Mar 21 at 19:42
MichaelTiefenbacherMichaelTiefenbacher
2,3072715
Thank you Michael. Our DataStage version is V11.5, we do have stages "Hierarchical Data", "XML_Input", "XML_Output" and "XML_Transform" stages. While using Hierarchical Data Stage its throwing an error "CDIUW2002E DataStage did not provide the XML stage with a context". Hence I used "XML Output" stage to write the result set in the XML format. "Document Settings - "Generate XML chunk" is checked, Namespace declaration loaded from the xsl from metadata explorer. "Nested Chunk" not sure about it , so included XSL as Text. Job is currently failing to write any sort of XML output. Any leads?
– Rahul K
Mar 21 at 21:28
add a comment |
Hierarchical Stage fixed the issue. Thanks.
answered Mar 22 at 19:48
Rahul KRahul K
31
New contributor
Rahul K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Rahul K is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55284442%2fhow-to-convert-db2-query-result-set-to-an-xml-file-based-on-a-given-xsl-using-ib%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
There are multiple options assuming you do not have XML already in your Db2 table,
you do not need the XML Transformer.
I strongly suggest you use the modern Hierarchical stage (also known as XML stage depending on the version of DataStage) so I would go for following structure if you want a file or files as a target.
Db2 Connect -> Hierarchical stage -> Sequential File stage
In addition, Db2 offers lots of XML functionality to generate XML by using SQL or XQuery.
edited Mar 21 at 19:49
computersciencestudent
231
answered Mar 21 at 19:42
MichaelTiefenbacherMichaelTiefenbacher
2,3072715
Thank you Michael. Our DataStage version is V11.5, we do have stages "Hierarchical Data", "XML_Input", "XML_Output" and "XML_Transform" stages. While using Hierarchical Data Stage its throwing an error "CDIUW2002E DataStage did not provide the XML stage with a context". Hence I used "XML Output" stage to write the result set in the XML format. "Document Settings - "Generate XML chunk" is checked, Namespace declaration loaded from the xsl from metadata explorer. "Nested Chunk" not sure about it , so included XSL as Text. Job is currently failing to write any sort of XML output. Any leads?
– Rahul K
Mar 21 at 21:28
add a comment |
There are multiple options assuming you do not have XML already in your Db2 table,
you do not need the XML Transformer.
I strongly suggest you use the modern Hierarchical stage (also known as XML stage depending on the version of DataStage) so I would go for following structure if you want a file or files as a target.
Db2 Connect -> Hierarchical stage -> Sequential File stage
In addition, Db2 offers lots of XML functionality to generate XML by using SQL or XQuery.
edited Mar 21 at 19:49
computersciencestudent
231
answered Mar 21 at 19:42
MichaelTiefenbacherMichaelTiefenbacher
2,3072715
Thank you Michael. Our DataStage version is V11.5, we do have stages "Hierarchical Data", "XML_Input", "XML_Output" and "XML_Transform" stages. While using Hierarchical Data Stage its throwing an error "CDIUW2002E DataStage did not provide the XML stage with a context". Hence I used "XML Output" stage to write the result set in the XML format. "Document Settings - "Generate XML chunk" is checked, Namespace declaration loaded from the xsl from metadata explorer. "Nested Chunk" not sure about it , so included XSL as Text. Job is currently failing to write any sort of XML output. Any leads?
– Rahul K
Mar 21 at 21:28
add a comment |
There are multiple options assuming you do not have XML already in your Db2 table,
you do not need the XML Transformer.
I strongly suggest you use the modern Hierarchical stage (also known as XML stage depending on the version of DataStage) so I would go for following structure if you want a file or files as a target.
Db2 Connect -> Hierarchical stage -> Sequential File stage
In addition, Db2 offers lots of XML functionality to generate XML by using SQL or XQuery.
edited Mar 21 at 19:49
computersciencestudent
231
answered Mar 21 at 19:42
MichaelTiefenbacherMichaelTiefenbacher
2,3072715
There are multiple options assuming you do not have XML already in your Db2 table,
you do not need the XML Transformer.
I strongly suggest you use the modern Hierarchical stage (also known as XML stage depending on the version of DataStage) so I would go for following structure if you want a file or files as a target.
Db2 Connect -> Hierarchical stage -> Sequential File stage
In addition, Db2 offers lots of XML functionality to generate XML by using SQL or XQuery.
edited Mar 21 at 19:49
computersciencestudent
231
answered Mar 21 at 19:42
MichaelTiefenbacherMichaelTiefenbacher
2,3072715
edited Mar 21 at 19:49
computersciencestudent
231
edited Mar 21 at 19:49
computersciencestudent
231
edited Mar 21 at 19:49
computersciencestudent
231
231
answered Mar 21 at 19:42
MichaelTiefenbacherMichaelTiefenbacher
2,3072715
answered Mar 21 at 19:42
MichaelTiefenbacherMichaelTiefenbacher
2,3072715
answered Mar 21 at 19:42
MichaelTiefenbacherMichaelTiefenbacher
2,3072715
2,3072715
Thank you Michael. Our DataStage version is V11.5, we do have stages "Hierarchical Data", "XML_Input", "XML_Output" and "XML_Transform" stages. While using Hierarchical Data Stage its throwing an error "CDIUW2002E DataStage did not provide the XML stage with a context". Hence I used "XML Output" stage to write the result set in the XML format. "Document Settings - "Generate XML chunk" is checked, Namespace declaration loaded from the xsl from metadata explorer. "Nested Chunk" not sure about it , so included XSL as Text. Job is currently failing to write any sort of XML output. Any leads?
– Rahul K
Mar 21 at 21:28
add a comment |
Thank you Michael. Our DataStage version is V11.5, we do have stages "Hierarchical Data", "XML_Input", "XML_Output" and "XML_Transform" stages. While using Hierarchical Data Stage its throwing an error "CDIUW2002E DataStage did not provide the XML stage with a context". Hence I used "XML Output" stage to write the result set in the XML format. "Document Settings - "Generate XML chunk" is checked, Namespace declaration loaded from the xsl from metadata explorer. "Nested Chunk" not sure about it , so included XSL as Text. Job is currently failing to write any sort of XML output. Any leads?
– Rahul K
Mar 21 at 21:28
Thank you Michael. Our DataStage version is V11.5, we do have stages "Hierarchical Data", "XML_Input", "XML_Output" and "XML_Transform" stages. While using Hierarchical Data Stage its throwing an error "CDIUW2002E DataStage did not provide the XML stage with a context". Hence I used "XML Output" stage to write the result set in the XML format. "Document Settings - "Generate XML chunk" is checked, Namespace declaration loaded from the xsl from metadata explorer. "Nested Chunk" not sure about it , so included XSL as Text. Job is currently failing to write any sort of XML output. Any leads?
– Rahul K
Mar 21 at 21:28
Thank you Michael. Our DataStage version is V11.5, we do have stages "Hierarchical Data", "XML_Input", "XML_Output" and "XML_Transform" stages. While using Hierarchical Data Stage its throwing an error "CDIUW2002E DataStage did not provide the XML stage with a context". Hence I used "XML Output" stage to write the result set in the XML format. "Document Settings - "Generate XML chunk" is checked, Namespace declaration loaded from the xsl from metadata explorer. "Nested Chunk" not sure about it , so included XSL as Text. Job is currently failing to write any sort of XML output. Any leads?
– Rahul K
Mar 21 at 21:28
add a comment |
Hierarchical Stage fixed the issue. Thanks.
answered Mar 22 at 19:48
Rahul KRahul K
31
New contributor
Rahul K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Hierarchical Stage fixed the issue. Thanks.
answered Mar 22 at 19:48
Rahul KRahul K
31
New contributor
Rahul K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Hierarchical Stage fixed the issue. Thanks.
answered Mar 22 at 19:48
Rahul KRahul K
31
New contributor
Rahul K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Hierarchical Stage fixed the issue. Thanks.
answered Mar 22 at 19:48
Rahul KRahul K
31
New contributor
Rahul K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered Mar 22 at 19:48
Rahul KRahul K
31
New contributor
Rahul K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered Mar 22 at 19:48
Rahul KRahul K
31
answered Mar 22 at 19:48
Rahul KRahul K
31
31
New contributor
Rahul K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Rahul K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Rahul K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
Rahul K is a new contributor. Be nice, and check out our Code of Conduct.
Rahul K is a new contributor. Be nice, and check out our Code of Conduct.
Rahul K is a new contributor. Be nice, and check out our Code of Conduct.
Rahul K is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55284442%2fhow-to-convert-db2-query-result-set-to-an-xml-file-based-on-a-given-xsl-using-ib%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
