ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » help needed urgently

Post new topic  Reply to topic
 help needed urgently « View previous topic :: View next topic » 
Author Message
kishoreMuthyala
PostPosted: Sun Apr 04, 2004 11:05 pm    Post subject: help needed urgently Reply with quote

Apprentice

Joined: 24 Mar 2004
Posts: 35
Location: singapore
Hi,
This is the XML file which is being generated from SAP into the Q when retrievng the data From SAP using SAP Adapter.Now iam trying to pass this data to the DB2 and inser it.In themessage flo0w which i have created for the insertion into DB2 in the I/P node i have given the Qwhich i got the data from SAP as Input Q.But iam unable to get the message flow processed after the Comput node.Iam getting Empty file into Input Q
Can anyone give me an solution.Iam sending the XML file. and also the Compute node esql code which i have written to insert the XML file into the DB2.




<?xml version="1.0" encoding="UTF-8"?>
<?CWRSD status="1" description="null"?>
<Q1:sap_bapi_companycode_getlist

xmlns:Q1="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_bapi_companycode_getlis

t" version="3.0.0" verb="Retrieve" locale="en_US" delta="false">
<Q1:sap_return>
<Q3:sap_return

xmlns:Q3="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_return" version="3.0.0"

verb="" locale="en_US" delta="false">


<Q3:Message_type__S_Success__E_Error__W_Warning__I_Info__A_Abort></Q3:Message_type__S_Succes

s__E_Error__W_Warning__I_Info__A_Abort>
<Q3:Message_code></Q3:Message_code>
<Q3:Message_Text></Q3:Message_Text>
<Q3:Application_log__log_number></Q3:Application_log__log_number>


<Q3:Application_log__Internal_message_serial_number>000000</Q3:Application_log__Internal_mes

sage_serial_number>
<Q3:Messages__Message_Variable></Q3:Messages__Message_Variable>
<Q3:Messages__Message_Variable1></Q3:Messages__Message_Variable1>
<Q3:Messages__Message_Variable2></Q3:Messages__Message_Variable2>
<Q3:Messages__Message_Variable3></Q3:Messages__Message_Variable3>
</Q3:sap_return>
</Q1:sap_return>
<Q1:sap_companycode_list size="57">
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>0001</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>SAP A.G.</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>0MB1</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>IS-B Musterbank

Deutschl.</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>AR01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

AR</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>AT01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

AT</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>AU01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

AU</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>BE01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

BE</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>BR01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

BR</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>CA01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

CA</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>CH01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

CH</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>CL01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

CL</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>CN01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

CN</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>CO01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

CO</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>COPY</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Copy from

CC.0001</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>CZ01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

CZ</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>DE01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

DE</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>DE02</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

DE</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>DK01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

DK</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>ES01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

ES</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>FI01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

FI</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>FR01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

FR</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>GB01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

GB</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>HK01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

HK</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>HK10</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>SMHK</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>HK20</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>T&amp;S Technology

Limited</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>HU01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

HU</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>ID01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

ID</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>IE01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

IE</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>IN01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>India Model Company,

IN</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>IT01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

IT</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>JP01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

JP</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>KR01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

KR</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>KR10</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>TBT</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>KR20</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Sangsoo Co.,

Ltd</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>KZ01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

KZ</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>LU01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

LU</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>MX01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

MX</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>MY01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

MY</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>NL01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

NL</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>NO01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

NO</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>NZ01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

NZ</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>PE01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

PE</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>PH01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

PH</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>PL01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

PL</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>PT01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

PT</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>RU01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

RU</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>SE01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

SE</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>SG01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>SAP Asia</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>SG10</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>SSL</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>SG20</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>SMPL</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>SK01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

SK</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>TH01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

TH</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>TR01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

TR</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>TW01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

TW</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>UA01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

UA</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>US01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

US</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>VE01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

VE</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
<Q2:sap_companycode_list

xmlns:Q2="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list"

version="3.0.0" verb="" locale="en_US" delta="false">
<Q2:Company_Code>ZA01</Q2:Company_Code>
<Q2:Name_of_the_company_code_or_company>Country Template

ZA</Q2:Name_of_the_company_code_or_company>
</Q2:sap_companycode_list>
</Q1:sap_companycode_list>
</Q1:sap_bapi_companycode_getlist>





CREATE COMPUTE MODULE cardinalityfun_Compute
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
DECLARE I INTEGER 1;
Declare count integer ;
DECLARE J INTEGER CARDINALITY(InputRoot.*[]);
WHILE I < J DO
SET OutputRoot.*[I] = InputRoot.*[I];
SET I = I + 1;
END WHILE;


Declare q1 namespace

'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_bapi_companycode_getlist';
Declare q2 namespace

'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/sap_companycode_list';
declare str1 char;
declare str2 char;


declare a integer 1;

set

count=cardinality(InputRoot.XMLNS.q1:sap_bapi_companycode_getlist.q1:sap_companycode_list.q2

:sap_companycode_list[]);
while a<=count
do



set str1 =

InputRoot.XMLNS.q1:sap_bapi_companycode_getlist.q1:sap_companycode_list.q2:sap_companycode_l

ist[a].q2:Company_Code;
set str2 =

InputRoot.XMLNS.q1:sap_bapi_companycode_getlist.q1:sap_companycode_list.q2:sap_companycode_l

ist[a].q2:Name_of_the_company_code_or_company;

--set

OutputRoot.XMLNS.q1:sap_bapi_companycode_getlist.rrr.Company_Code=str1;
--set

OutputRoot.XMLNS.q1:sap_bapi_companycode_getlist.rrr.Names_company=str2;
insert into Database.DB2ADMIN.SAP_BAPI_COMPANYCODE_GETLIST

values(str1,str2);
set a=a+1;
end while;

set OutputRoot.Properties.MessageDomain = 'XMLNS';
set OutputRoot.XMLNS.q1:sap_bapi_companycode_getlist.count=count;
--SET OutputRoot=InputRoot;
RETURN TRUE;
END;

END MODULE;
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger MSN Messenger
jefflowrey
PostPosted: Mon Apr 05, 2004 3:05 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981
Your code never copies body fields(only headers) from the InputRoot to the OutputRoot, so the message tree for XMLNS will be empty after this node.

Also, it is possible that you are getting a NULL value for str1 or str2.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » help needed urgently
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.