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 » ESQL HELP REQUIRED

Post new topic  Reply to topic
 ESQL HELP REQUIRED « View previous topic :: View next topic » 
Author Message
sarbajit
PostPosted: Thu Apr 13, 2006 4:33 am    Post subject: ESQL HELP REQUIRED Reply with quote

Acolyte

Joined: 22 May 2003
Posts: 53
My input message (Partial)

<?xml version="1.0" encoding="UTF-8"?>
<Arakas_Peoplesoft_HAM_ArakasComCntlEvent:Arakas_Peoplesoft_HAM_ArakasComCntlEvent xmlns:Arakas_Peoplesoft_HAM_ArakasComCntlEvent="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/Arakas_Peoplesoft_HAM_ArakasComCntlEvent" xmlns:Arakas_Peoplesoft_ariba_integration_custom_HCCtl_Request_Arakas_Peoplesoft="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/Arakas_Peoplesoft_ariba_integration_custom_HCCtl_Request_Arakas_Peoplesoft" xmlns:Arakas_Peoplesoft_ariba_core_ArakasComCntl_Export="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/Arakas_Peoplesoft_ariba_core_ArakasComCntl_Export" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/Arakas_Peoplesoft_HAM_ArakasComCntlEvent file:Arakas_Peoplesoft_HAM_ArakasComCntlEvent.xsd" version="3.0.0" verb="Create" locale="en_US" delta="false">
<Arakas_Peoplesoft_HAM_ArakasComCntlEvent:RequestSchema>
<Arakas_Peoplesoft_ariba_integration_custom_HCCtl_Request_Arakas_Peoplesoft:Arakas_Peoplesoft_ariba_integration_custom_HCCtl_Request_Arakas_Peoplesoft version="3.0.0" verb="Create" locale="en_US" delta="false">
<Arakas_Peoplesoft_ariba_integration_custom_HCCtl_Request_Arakas_Peoplesoft:Variant>Arakas_Peoplesoft</Arakas_Peoplesoft_ariba_integration_custom_HCCtl_Request_Arakas_Peoplesoft:Variant>
<Arakas_Peoplesoft_ariba_integration_custom_HCCtl_Request_Arakas_Peoplesoft:ArakasKK>
<Arakas_Peoplesoft_ariba_core_ArakasComCntl_Export:Arakas_Peoplesoft_ariba_core_ArakasComCntl_Export version="3.0.0" verb="Create" locale="en_US" delta="false">
<Arakas_Peoplesoft_ariba_core_ArakasComCntl_Export:TimeCreated>Apr 6, 2006 11:28:10 AM</Arakas_Peoplesoft_ariba_core_ArakasComCntl_Export:TimeCreated>
<Arakas_Peoplesoft_ariba_core_ArakasComCntl_Export:TimeUpdated>Apr 6, 2006 11:28:10 AM</Arakas_Peoplesoft_ariba_core_ArakasComCntl_Export:TimeUpdated>




MY ESQL is

DECLARE Q1 NAMESPACE 'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/Arakas_Peoplesoft_HAM_ArakasComCntlEvent';

DECLARE Q2 NAMESPACE 'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/Arakas_Peoplesoft_ariba_integration_custom_HCCtl_Request_Arakas_Peoplesoft';

DECLARE Q3 NAMESPACE 'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/Arakas_Peoplesoft_ariba_core_ArakasComCntl_Export';

DECLARE REFI REFERENCE TO InputBody.MRM.Q1:RequestSchema.Q2:ArakasKK.Q3;


I want to set reference till Arakas_Peoplesoft_ariba_core_ArakasComCntl_Export:Arakas_Peoplesoft_ariba_core_ArakasComCntl_Export version.

What I am doing wrong? Please help.
Back to top
View user's profile Send private message
fazz
PostPosted: Thu Apr 13, 2006 4:37 am    Post subject: Reply with quote

Centurion

Joined: 20 Feb 2004
Posts: 144
Location: England
If you use InputBody, you do not need to specify MRM.

either

InputBody.Q1:RequestSchema.Q2:ArakasKK.Q3;

or

InputRoot.MRM.Q1:RequestSchema.Q2:ArakasKK.Q3;

Also, you are not pointing to the full element, think it should be

InputBody.Q1:RequestSchema.Q2:ArakasKK.Q3:Arakas_Peoplesoft_ariba_core_ArakasComCntl_Export.(XML.XMLAttribute)version[/b]
Back to top
View user's profile Send private message
sarbajit
PostPosted: Mon Apr 17, 2006 12:55 am    Post subject: Reply with quote

Acolyte

Joined: 22 May 2003
Posts: 53
Hi Thanks,

This is my partial input message

<?xml version="1.0" encoding="UTF-8"?>
<TCS_Peoplesoft_HAM_TCSComCntlEvent:TCS_Peoplesoft_HAM_TCSComCntlEvent xmlns:TCS_Peoplesoft_HAM_TCSComCntlEvent="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/TCS_Peoplesoft_HAM_TCSComCntlEvent" xmlns:TCS_Peoplesoft_ariba_integration_custom_HCCtl_Request_TCS_Peoplesoft="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/TCS_Peoplesoft_ariba_integration_custom_HCCtl_Request_TCS_Peoplesoft" xmlns:TCS_Peoplesoft_ariba_core_TCSComCntl_Export="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/TCS_Peoplesoft_ariba_core_TCSComCntl_Export" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/TCS_Peoplesoft_HAM_TCSComCntlEvent file:TCS_Peoplesoft_HAM_TCSComCntlEvent.xsd" version="3.0.0" verb="Create" locale="en_US" delta="false">
<TCS_Peoplesoft_HAM_TCSComCntlEvent:RequestSchema>
<TCS_Peoplesoft_ariba_integration_custom_HCCtl_Request_TCS_Peoplesoft:TCS_Peoplesoft_ariba_integration_custom_HCCtl_Request_TCS_Peoplesoft version="3.0.0" verb="Create" locale="en_US" delta="false">
<TCS_Peoplesoft_ariba_integration_custom_HCCtl_Request_TCS_Peoplesoft:Variant>TCS_Peoplesoft</TCS_Peoplesoft_ariba_integration_custom_HCCtl_Request_TCS_Peoplesoft:Variant>
<TCS_Peoplesoft_ariba_integration_custom_HCCtl_Request_TCS_Peoplesoft:TCSKK>
<TCS_Peoplesoft_ariba_core_TCSComCntl_Export:TCS_Peoplesoft_ariba_core_TCSComCntl_Export version="3.0.0" verb="Create" locale="en_US" delta="false">
<TCS_Peoplesoft_ariba_core_TCSComCntl_Export:TimeCreated>Apr 6, 2006 11:28:10 AM</TCS_Peoplesoft_ariba_core_TCSComCntl_Export:TimeCreated>
<TCS_Peoplesoft_ariba_core_TCSComCntl_Export:TimeUpdated>Apr 6, 2006 11:28:10 AM</TCS_Peoplesoft_ariba_core_TCSComCntl_Export:TimeUpdated>
<TCS_Peoplesoft_ariba_core_TCSComCntl_Export:UniqueName>PR00207932-1-1-1</TCS_Peoplesoft_ariba_core_TCSComCntl_Export:UniqueName>
<TCS_Peoplesoft_ariba_core_TCSComCntl_Export:TCSComCntlPRNumber>PR00207932</TCS_Peoplesoft_ariba_core_TCSComCntl_Export:TCSComCntlPRNumber>
<TCS_Peoplesoft_ariba_core_TCSComCntl_Export:TCSComCntlReqLineNumber>1</TCS_Peoplesoft_ariba_core_TCSComCntl_Export:TCSComCntlReqLineNumber>
<TCS_Peoplesoft_ariba_core_TCSComCntl_Export:TCSComCntlSALineNumber>1</TCS_Peoplesoft_ariba_core_TCSComCntl_Export:TCSComCntlSALineNumber>
<TCS_Peoplesoft_ariba_core_TCSComCntl_Export:TCSComCntlHdrBusUnit>HAM</TCS_Peoplesoft_ariba_core_TCSComCntl_Export:TCSComCntlHdrBusUnit>




My ESQL partial is like

DECLARE REFT REFERENCE TO "OutputRoot"."XML"."HNA_COMMITMENT_CONTROL"."MsgData"."Transaction";

DECLARE Q1 NAMESPACE 'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/TCS_Peoplesoft_HAM_TCSComCntlEvent';

DECLARE Q2 NAMESPACE 'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/TCS_Peoplesoft_ariba_integration_custom_HCCtl_Request_TCS_Peoplesoft';

DECLARE Q3 NAMESPACE 'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/TCS_Peoplesoft_ariba_core_TCSComCntl_Export';

--DECLARE REFI REFERENCE TO InputBody.Q1:RequestSchema.Q2:TCSKK.Q3;


DECLARE REFI REFERENCE TO InputRoot.MRM.Q1:RequestSchema.Q2:TCSKK.Q3.TCS_Peoplesoft_ariba_core_TCSComCntl_Export;

DECLARE BUS_UN1 CHARACTER;
DECLARE TRAN_NBR1 CHARACTER;
SET BUS_UN1 = REFI."TCSComCntlHdrBusUnit";
SET TRAN_NBR1 = REFI."TCSComCntlHdrTransNbr";



Problem is that I am not getting any values in BUS_UNI or TRAN_NBR1 variable eventhough in input message corresponding values are there. What I am doing wrong?
Back to top
View user's profile Send private message
sarbajit
PostPosted: Mon Apr 17, 2006 8:27 pm    Post subject: Reply with quote

Acolyte

Joined: 22 May 2003
Posts: 53
Thanks for all the help. I figured out the problem.
Back to top
View user's profile Send private message
smdavies99
PostPosted: Mon Apr 17, 2006 9:45 pm    Post subject: What was wrong? Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
sarbajit,
To help others in the future please explain what you did to fix the problem.
steve
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
Back to top
View user's profile Send private message
sarbajit
PostPosted: Tue Apr 18, 2006 11:32 pm    Post subject: Reply with quote

Acolyte

Joined: 22 May 2003
Posts: 53
Sorry..Missed the solution i previous post..

Changed the reference

DECLARE REFI REFERENCE TO InputRoot.MRM.Q1:RequestSchema.Q2:TCS_Peoplesoft_ariba_integration_custom_HCCtl_Request_TCS_Peoplesoft.Q2:TCSKK.Q3:TCS_Peoplesoft_ariba_core_TCSComCntl_Export;

DECLARE BUS_UN1 CHARACTER;
DECLARE TRAN_NBR1 CHARACTER;
SET BUS_UN1 = REFI.Q3:"TCSComCntlHdrBusUnit";
SET TRAN_NBR1 = REFI.Q3:"TCSComCntlHdrTransNbr";
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 » ESQL HELP REQUIRED
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.