| Author |
Message
|
| pereira.allan1992 |
 Posted: Wed Oct 21, 2015 9:00 am Post subject: How to put a XML file into a XML field |
 |
|
Novice
Joined: 21 Oct 2015
Posts: 12
|
Hi all,
I'm starting to learn by my own Websphere Integration Bus, and I trying to do this but no success...
I have one XML file like this:
<CSV2XMLXSD>
<record>
<employee>Nome</employee>
<tel>Telefone</tel>
</record>
</CSV2XMLXSD>
and I would like to put all this content ( including '<CSV2XMLXSD>',<record>,<employee>,<tel>,</CSV2XMLXSD>,</record>, in a field inside other XML field (string 4000))
if possible converting < to %lt/ %gt (sorry, I dont know the exactly name)
EX:
<messageData><doc_type>P</doc_type><order_no>2201
</order_no><order_type>N/B</order_type><order_type
_desc>PrimDia</order_type_desc><supplier>101</supplier
><qc_ind>N</qc_ind><not_before_date>2012-01-
17T00:00:00.000-
02:00</not_before_date><not_after_date>2012-01-
17T00:00:00.000-02:00</not_after_date><otb_eow_date>2012-
01-21T00:00:00.000-
02:00</otb_eow_date><earliest_ship_date>2012-01-
22T00:00:00.000-
02:00</earliest_ship_date><latest_ship_date>2012-02-
21T00:00:00.000-
02:00</latest_ship_date><terms>1</terms><terms_code
>1</terms_code><freight_terms>03</freight_terms><
cust_order>N</cust_order><payment_method>WT</payme
nt_method><payment_method_desc>Transfer魣ia
Eletr.</payment_method_desc><ship_method>30</ship_meth
od><ship_method_desc>Caminh⭬ Sem cont騮
er</ship_method_desc><status>A</status><exchange_r
ate>1</exchange_rate><bill_to_id>1000</bill_to_id><
po_type>1</po_type><po_type_desc>Compra para
Revenda</po_type_desc><pre_mark_ind>N</pre_mark_ind&
gt;<currency_code>BRL</currency_code><pickup_date>20
12-01-17T00:00:00.000-
02:00</pickup_date><PODtl><item>100020033</item>
;<physical_location_type>S</physical_location_type><physica
l_location>11002</physical_location><physical_qty_ordered>
10</physical_qty_ordered><unit_cost>500</unit_cost><o
rigin_country_id>BR</origin_country_id><supp_pack_size>1&
lt;/supp_pack_size><earliest_ship_date>2012-01-
22T00:00:00.000-
02:00</earliest_ship_date><latest_ship_date>2012-02-
21T00:00:00.000-
02:00</latest_ship_date><packing_method>HANG</packing_
method><round_lvl>C</round_lvl><POVirtualDtl><loca
tion_type>S</location_type><location>11002</location>
<qty_ordered>10</qty_ordered></POVirtualDtl><est_in_
stock_date>2012-01-22T00:00:00.000-
02:00</est_in_stock_date></PODtl><ns1:ExtOfPODesc
xmlns:ns1="gt;<ns1:start_bill_date>2012-02-17T00:00:00.000-
02:00</ns1:start_bill_date><ns1:bill_type>P</ns1:bill_type>
;</ns1:ExtOfPODesc></PODesc></messageData>
Im trying using InputFile Node, Mapping and OutputFile Node, No ESQL Custom, How can i do this please?
Thank you for the attention
Regards |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Wed Oct 21, 2015 9:21 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You need to map a string version of the input data into the appropriate type of XML field.
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| pereira.allan1992 |
| Posted: Wed Oct 21, 2015 10:26 am Post subject: |
|
|
Novice
Joined: 21 Oct 2015
Posts: 12
|
Thank you for your help.
I'm trying to do this for 2 weeks, but until today nothing...
Can you explain in detail to me how can i do this? Im trying to use the cast and this command too, but i cannot find any positive result
CREATE PROCEDURE CopyEntireMessage() BEGIN
DECLARE InputMessageData BLOB;
SET InputMessageData = ASBITSTREAM(InputRoot.XMLNSC);
SET OutputRoot = InputRoot;
Using a mapping with Blob input and messageData XSD (String) output |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Oct 21, 2015 10:35 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
The asbitstream is almost right. You probably want a CCSID.
The rest of it doesn't make any sense.
Where are you tyring to assign the result of the asbitstream to the message tree?
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| pereira.allan1992 |
| Posted: Wed Oct 21, 2015 11:14 am Post subject: |
|
|
Novice
Joined: 21 Oct 2015
Posts: 12
|
Currently, Im trying to find what is my CCSID...
in My Compute Node, im trying to do this
DECLARE InputMessageData BLOB;
DECLARE decoded2 blob;
SET InputMessageData = ASBITSTREAM(InputRoot.XMLNSC);
SET decoded2 = CAST(InputMessageData as blob ccsid 1208);
--INSERT INTO Database.sys.aps_iit(teste) VALUES (InputMessageData);
--CALL CopyEntireMessage();
SET OutputRoot = decoded2;
I created a output file after this ComputeNode, but the file there is no data...i Dont know why....
I tried do this:
SET InputMessageData = ASBITSTREAM(InputRoot.XMLNSC);
SET OutputRoot = InputRoot;
and this,
SET InputMessageData = ASBITSTREAM(InputRoot.XMLNSC);
SET OutputRoot =InputMessageData;
but no success...
Thank you |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Oct 21, 2015 11:23 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
As Jeff told you, you need to look up your ASBITSTREM function and include the target CCSID into it.
You have then a BLOB in a known CCSID that you can cast to CHAR...
Insert the char at the right place in your output XML tree.
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Oct 21, 2015 11:52 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| pereira.allan1992 wrote: |
| Code: |
SET InputMessageData = ASBITSTREAM(InputRoot.XMLNSC);
SET decoded2 = CAST(InputMessageData as blob ccsid 1208);
|
|
The CCSID goes on the ASBITSTREAM. The result of an ASBITSTREAM is a BLOB so you don't need to cast it.
| pereira.allan1992 wrote: |
| Code: |
CALL CopyEntireMessage();
SET OutputRoot = decoded2;
|
I created a output file after this ComputeNode, but the file there is no data...i Dont know why....
|
The OutputRoot tree has a specific structure. If you just assign a BLOB to it, you'll corrupt it.
| pereira.allan1992 wrote: |
| Code: |
SET InputMessageData = ASBITSTREAM(InputRoot.XMLNSC);
SET OutputRoot = InputRoot;
and this,
SET InputMessageData = ASBITSTREAM(InputRoot.XMLNSC);
SET OutputRoot =InputMessageData;
|
but no success...
|
See my comments above.
To obtain output, you need to have your data as the last child of the OutputRoot tree and you have to assign a domain (such as XMLNSC) so broker knows how to serialize it.
So you're better off sticking with your original plan and inserting it into an XML document.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| pereira.allan1992 |
| Posted: Wed Oct 21, 2015 12:17 pm Post subject: |
|
|
Novice
Joined: 21 Oct 2015
Posts: 12
|
I believe that i have to back some steps, to learn how to configure the OutputRoot tree first...
I ll try to do this, and I return with a position
Thanks!!! |
|
| Back to top |
|
|
| pereira.allan1992 |
| Posted: Thu Oct 22, 2015 4:00 am Post subject: |
|
|
Novice
Joined: 21 Oct 2015
Posts: 12
|
Morning All,
Please, i tried to do this, but I keep generate a file with no data. what I doing wrong?
I just have this in my compute node, when my compute node is making a connection with a outputFile
CREATE PROCEDURE CopyEntireMessage() BEGIN
SET OutputRoot.BLOB.BLOB=CAST (ASBITSTREAM(InputRoot.XMLNSC) AS BLOB CCSID 1208);
PS: My InputFile, is with Parser Option XMLNSC (is that correct)?
"So you're better off sticking with your original plan and inserting it into an XML document."
That is exactly what i trying to do, but nothing until now =(
Thank you |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Oct 22, 2015 4:19 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| pereira.allan1992 wrote: |
| Code: |
CREATE PROCEDURE CopyEntireMessage() BEGIN
SET OutputRoot.BLOB.BLOB=CAST (ASBITSTREAM(InputRoot.XMLNSC) AS BLOB CCSID 1208);
|
|
ASBITSTREAM is already returning a BLOB so don't cast it.
As well you need to add the CCSID to the ASBITSREAM function call.
And don't use canned IBM procedures for that... have something like: (check it for correctness as it is from memory)
| Code: |
CREATE FUNCTION MAIN RETURNS BOOLEAN
BEGIN
CALL CopyHeaders();
SET OutputRoot.BLOB.BLOB = ASBITSTREAM( InputRoot.XMLNSC.<roottagname>, options, ccsid,...);
RETURN TRUE; |
And make the options be something like RootBitStream (look it up in the infocenter)...
Have fun
_________________
MQ & Broker admin
Last edited by fjb_saper on Thu Oct 22, 2015 4:38 am; edited 2 times in total |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Oct 22, 2015 4:22 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| pereira.allan1992 wrote: |
| Please, i tried to do this, but I keep generate a file with no data. what I doing wrong? |
Well:
| pereira.allan1992 wrote: |
| Code: |
CREATE PROCEDURE CopyEntireMessage() BEGIN
SET OutputRoot.BLOB.BLOB=CAST (ASBITSTREAM(InputRoot.XMLNSC) AS BLOB CCSID 1208);
|
|
You've edited the IBM supplied procedure CopyEntireMessage (never a good idea) and you're removed the line copying the InputRoot to the OutputRoot. So once again you don't have an OutputRoot with the required structure, you have a OutputRoot with nothing but your data.
| pereira.allan1992 wrote: |
PS: My InputFile, is with Parser Option XMLNSC (is that correct)? |
That's the correct option to parse an XML document.
| pereira.allan1992 wrote: |
| Vitor wrote: |
| So you're better off sticking with your original plan and inserting it into an XML document." |
That is exactly what i trying to do, but nothing until now =( |
That is absolutely NOT what your code does. Your code takes a BLOB value and tries to output it. There's not one line about an output XML document, containing the input or nothing.
You're now at the point in learning IIB where you need to learn how to diagnose code problems. Okay, first you need to get your code out of the IBM supplied procedure - you'll be well served thinking very clearly about why IBM supplies them and how they can help you, because they can.
Your next step (if that doesn't fix your problem) is to run a user trace and determine what happens when you run your flow. Even if it works, a user trace will be informative and interesting, and is a skill you should develop.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| pereira.allan1992 |
| Posted: Thu Oct 22, 2015 4:39 am Post subject: |
|
|
Novice
Joined: 21 Oct 2015
Posts: 12
|
| Vitor wrote: |
| "That is absolutely NOT what your code does. Your code takes a BLOB value and tries to output it. There's not one line about an output XML document, containing the input or nothing. " |
I know that, but m friend can do the XML file to a CLOB field in a oracle database, so I tried do the same...but putting in a XML Field this time....
| Vitor wrote: |
| "There's not one line about an output XML document, containing the input or nothing. " |
Because I dont know the syntax, I researched, and just find how to manipulate namespaces, fields, etc...but i want the Whole File, this i cannot find anything about that...
If possible, please, send me a link with i can learn about code manipulating XMLNSC whole files...
Thank you... |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Oct 22, 2015 4:43 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Oct 22, 2015 5:10 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| pereira.allan1992 wrote: |
| Vitor wrote: |
| "That is absolutely NOT what your code does. Your code takes a BLOB value and tries to output it. There's not one line about an output XML document, containing the input or nothing. " |
I know that, but m friend can do the XML file to a CLOB field in a oracle database, so I tried do the same...but putting in a XML Field this time.... |
What?
So an Oracle database can hold an XML document as a CLOB. An F5 can distribute an XML document as IP packets and that's as relevant to this. Also your original intent as stated was:
| pereira.allan1992 wrote: |
| I would like to put all this content ( including '<CSV2XMLXSD>',<record>,<employee>,<tel>,</CSV2XMLXSD>,</record>, in a field inside other XML field (string 4000)) |
There's no reference to "other XML field" in your code.
| pereira.allan1992 wrote: |
| If possible, please, send me a link with i can learn about code manipulating XMLNSC whole files... |
That's most of the product documentation. All the product does is manipulate data, XML or otherwise, as an entire file or otherwise. There's no difference syntactically between manipulating all or part of an XML document; the ASBITREAM function is an example.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| pereira.allan1992 |
| Posted: Thu Oct 22, 2015 5:44 am Post subject: |
|
|
Novice
Joined: 21 Oct 2015
Posts: 12
|
"There's no reference to "other XML field" in your code."
The reference is in the mapping...
"That's most of the product documentation. All the product does is manipulate data, XML or otherwise, as an entire file or otherwise. There's no difference syntactically between manipulating all or part of an XML document; the ASBITREAM function is an example."
ASBITSTREAM returns a BLOB,
"That is absolutely NOT what your code does. Your code takes a BLOB value and tries to output it. There's not one line about an output XML document, containing the input or nothing. "
Is it to use a BLOB or Not?
I readed the documentation, but I cannot develop reading the documentation, doesn't explain with details the example, is hard to learn this way...
SET OutputRoot = InputRoot;
-- CALL CopyMessageHeaders();
-- CALL CopyEntireMessage();
DECLARE InputMessageData BLOB;
SET InputMessageData = CAST(ASBITSTREAM(InputRoot.XMLNSC) AS BLOB CCSID 1208);
--SET OutputRoot.XMLNSC.MessageData = InputMessageData;
SET OutputRoot.XMLNSC.MESSAGEDATA = InputMessageData;
returning a BLOB now, but how can i convert BLOB , I tried ENCODE64 e DECODE64, but no success indeed... |
|
| Back to top |
|
|
|
|
