| Author |
Message
|
| nathanw |
 Posted: Fri Jan 13, 2006 4:22 am Post subject: Cardinality Problems NOT THE NORM! |
 |
|
Knight
Joined: 14 Jul 2004
Posts: 550
|
Ok have an incoming message with multiple entries via the MRM
Whilst transforming the message I am using Cardinality to ensure that all entries on input are repeated on output.
Input message as follows
| Code: |
<?xml version="1.0" encoding="UTF-8"?>
<MessageFrom3r>
<SYSTEMDATA>
<SOURCESYSTEM>**</SOURCESYSTEM>
<TARGETSYSTEM>***</TARGETSYSTEM>
<SYSTEMDATA3R>
<MIDDLETIER3R>*</MIDDLETIER3R>
<USERID3R>*</USERID3R>
</SYSTEMDATA3R>
<SYSTEMDATACLOAS>
<DATABASE-ID>*</DATABASE-ID>
<USERID>*</USERID>
<MONITOR>*</MONITOR>
</SYSTEMDATACLOAS>
<VER>'1.0'</VER>
</SYSTEMDATA>
<BUSINESS-DATA>
<MESSAGE_3R attempt="">
<TRANSACTION>
<MASTER_GROUP>Multi-Channel</MASTER_GROUP>
<CRITERIA>
<MC_TXN>POST_3R_MESSAGE</MC_TXN>
</CRITERIA>
</TRANSACTION>
<INPUT>
<POST_ADDRESS>
<ADDRESSES>
<ADDRESS_INFO>
<ADDRESS_ID>166373025667002</ADDRESS_ID>
<CLIENT_ID>166373025667001</CLIENT_ID>
<CLIENT_PRODUCT_ID/>
<LINE1>Flat One</LINE1>
<LINE2>Stamford Bridge</LINE2>
<LINE3>Chelsea</LINE3>
<LINE4>UK</LINE4>
<LINE5/>
<POST_CODE>RH45 6YG</POST_CODE>
<TYPE>1</TYPE>
<EFF_TO_DATE>20051028000000</EFF_TO_DATE>
<EFF_FROM_DATE>20051027000000</EFF_FROM_DATE>
<OVERSEAS_INDICATOR>0</OVERSEAS_INDICATOR>
<BUSINESS_CONTACT_NAME>ID1</BUSINESS_CONTACT_NAME>
</ADDRESS_INFO>
<ADDRESS_INFO>
<ADDRESS_ID>166373026950000</ADDRESS_ID>
<CLIENT_ID>166373025667001</CLIENT_ID>
<CLIENT_PRODUCT_ID/><LINE1>13, Ruff Street</LINE1>
<LINE2>Pompey</LINE2>
<LINE3>Ampshire</LINE3>
<LINE4/>
<LINE5/>
<POST_CODE/>
<TYPE>1</TYPE>
<EFF_TO_DATE>20051101000000</EFF_TO_DATE>
<EFF_FROM_DATE>20051029000000</EFF_FROM_DATE>
<OVERSEAS_INDICATOR>0</OVERSEAS_INDICATOR>
<BUSINESS_CONTACT_NAME/>
</ADDRESS_INFO>
<ADDRESS_INFO>
<ADDRESS_ID>166379431656040</ADDRESS_ID>
<CLIENT_ID>166373025667001</CLIENT_ID>
<CLIENT_PRODUCT_ID/><LINE1>The New Address</LINE1>
<LINE2>Added On 10/01/2006</LINE2>
<LINE3>For Mr Drogba</LINE3>
<LINE4/>
<LINE5/>
<POST_CODE/>
<TYPE>1</TYPE>
<EFF_TO_DATE>20060110000000</EFF_TO_DATE>
<EFF_FROM_DATE>20060110000000</EFF_FROM_DATE>
<OVERSEAS_INDICATOR>0</OVERSEAS_INDICATOR>
<BUSINESS_CONTACT_NAME/>
</ADDRESS_INFO>
<ADDRESS_INFO>
<ADDRESS_ID>166379433497040</ADDRESS_ID>
<CLIENT_ID>166373025667001</CLIENT_ID>
<CLIENT_PRODUCT_ID/>
<LINE1>The 2nd New Address</LINE1>
<LINE2>On The 11/01/2006</LINE2>
<LINE3>Should Send 2</LINE3>
<LINE4/>
<LINE5/>
<POST_CODE/>
<TYPE>1</TYPE>
<EFF_TO_DATE>20060112000000</EFF_TO_DATE>
<EFF_FROM_DATE>20060111000000</EFF_FROM_DATE>
<OVERSEAS_INDICATOR>0</OVERSEAS_INDICATOR>
<BUSINESS_CONTACT_NAME/>
</ADDRESS_INFO>
<ADDRESS_INFO>
<ADDRESS_ID>166379435963040</ADDRESS_ID>
<CLIENT_ID>166373025667001</CLIENT_ID>
<CLIENT_PRODUCT_ID/>
<LINE1>The 3rd New Address</LINE1>
<LINE2>Now</LINE2>
<LINE3/>
<LINE4/>
<LINE5/>
<POST_CODE/>
<TYPE>1</TYPE>
<EFF_TO_DATE>20060113000000</EFF_TO_DATE>
<EFF_FROM_DATE>20060113000000</EFF_FROM_DATE>
<OVERSEAS_INDICATOR>0</OVERSEAS_INDICATOR>
<BUSINESS_CONTACT_NAME/>
</ADDRESS_INFO>
<ADDRESS_INFO>
<ADDRESS_ID>166379437732040</ADDRESS_ID>
<CLIENT_ID>166373025667001</CLIENT_ID>
<CLIENT_PRODUCT_ID/>
<LINE1>The 4th New Address</LINE1>
<LINE2>At 15:21</LINE2>
<LINE3/>
<LINE4/>
<LINE5/>
<POST_CODE/>
<TYPE>1</TYPE>
<EFF_TO_DATE>20060114000000</EFF_TO_DATE>
<EFF_FROM_DATE>20060114000000</EFF_FROM_DATE>
<OVERSEAS_INDICATOR>0</OVERSEAS_INDICATOR>
<BUSINESS_CONTACT_NAME/>
</ADDRESS_INFO>
<ADDRESS_INFO>
<ADDRESS_ID>166379440044040</ADDRESS_ID>
<CLIENT_ID>166373025667001</CLIENT_ID>
<CLIENT_PRODUCT_ID/>
<LINE1>The 5th Address</LINE1>
<LINE2>At 16:00</LINE2>
<LINE3/>
<LINE4/>
<LINE5/>
<POST_CODE/>
<TYPE>1</TYPE>
<EFF_TO_DATE/>
<EFF_FROM_DATE>20060115000000</EFF_FROM_DATE>
<OVERSEAS_INDICATOR>0</OVERSEAS_INDICATOR>
<BUSINESS_CONTACT_NAME/>
</ADDRESS_INFO>
</ADDRESSES>
</POST_ADDRESS>
</INPUT>
<OUTPUT/>
</MESSAGE_3R>
</BUSINESS-DATA>
</MessageFrom3r> |
Cardinality is bassed on the ADDRESSES child so i get the correct number of repeats (for want of a better word)
Output message is as follows
| Code: |
<?xml version="1.0"?>
<MESSAGE>
<SYSTEMDATA>
<SOURCESYSTEM>*</SOURCESYSTEM>
<TARGETSYSTEM>*</TARGETSYSTEM>
<SYSTEMDATA3R>
<MIDDLETIER3R>*</MIDDLETIER3R>
<USERID3R>*</USERID3R>
</SYSTEMDATA3R>
<SYSTEMDATACLOAS>
<DATABASE-ID>*</DATABASE-ID>
<USERID>*</USERID>
<MONITOR>*</MONITOR>
</SYSTEMDATACLOAS>
<VER>'1.0'</VER>
<BUSINESSMETHOD>
<CLASS>CLIENT</CLASS>
<METHOD>ALL ADDRESSES</METHOD>
</BUSINESSMETHOD>
</SYSTEMDATA>
<BUSINESS-DATA>
<ALL-ADDRESSES>
<ADDRESSES>
<ADDRESS-ID>166373025667002</ADDRESS-ID>
<ADDRESS-TYPE>1</ADDRESS-TYPE>
<LINE1>Flat One</LINE1>
<LINE2>Stamford Bridge</LINE2>
<LINE3>Chelsea</LINE3>
<LINE4>UK</LINE4>
<LINE5></LINE5>
<POST-CODE>RH45 6YG</POST-CODE>
<EFF-TO-DATE>20051028000000</EFF-TO-DATE>
<EFF-FROM-DATE>20051027000000</EFF-FROM-DATE>
<ADDRESS-ID>166373026950000</ADDRESS-ID>
<ADDRESS-TYPE>1</ADDRESS-TYPE>
<LINE1>13, Ruff Street</LINE1>
<LINE2>Pompey</LINE2>
<LINE3>Ampshire</LINE3>
<LINE4></LINE4>
<LINE5></LINE5>
<POST-CODE></POST-CODE>
<EFF-TO-DATE>20051101000000</EFF-TO-DATE>
<EFF-FROM-DATE>20051029000000</EFF-FROM-DATE>
<ADDRESS-ID>166379431656040</ADDRESS-ID>
<ADDRESS-TYPE>1</ADDRESS-TYPE>
<LINE1>The New Address</LINE1>
<LINE2>Added On 10/01/2006</LINE2>
<LINE3>For Mr Drogba</LINE3>
<LINE4></LINE4>
<LINE5></LINE5>
<POST-CODE></POST-CODE>
<EFF-TO-DATE>20060110000000</EFF-TO-DATE>
<EFF-FROM-DATE>20060110000000</EFF-FROM-DATE>
<ADDRESS-ID>166379433497040</ADDRESS-ID>
<ADDRESS-TYPE>1</ADDRESS-TYPE>
<LINE1>The 2nd New Address</LINE1>
<LINE2>On The 11/01/2006</LINE2>
<LINE3>Should Send 2</LINE3>
<LINE4></LINE4>
<LINE5></LINE5>
<POST-CODE></POST-CODE>
<EFF-TO-DATE>20060112000000</EFF-TO-DATE>
<EFF-FROM-DATE>20060111000000</EFF-FROM-DATE>
<ADDRESS-ID>166379435963040</ADDRESS-ID>
<ADDRESS-TYPE>1</ADDRESS-TYPE>
<LINE1>The 3rd New Address</LINE1>
<LINE2>Now</LINE2>
<LINE3></LINE3>
<LINE4></LINE4>
<LINE5></LINE5>
<POST-CODE></POST-CODE>
<EFF-TO-DATE>20060113000000</EFF-TO-DATE>
<EFF-FROM-DATE>20060113000000</EFF-FROM-DATE>
<ADDRESS-ID>166379437732040</ADDRESS-ID>
<ADDRESS-TYPE>1</ADDRESS-TYPE>
<LINE1>The 4th New Address</LINE1>
<LINE2>At 15:21</LINE2>
<LINE3></LINE3>
<LINE4></LINE4>
<LINE5></LINE5>
<POST-CODE></POST-CODE>
<EFF-TO-DATE>20060114000000</EFF-TO-DATE>
<EFF-FROM-DATE>20060114000000</EFF-FROM-DATE>
</ADDRESSES>
</ALL-ADDRESSES>
</BUSINESS-DATA>
</MESSAGE>
|
As you can the cardinality is working fine EXCEPT that each section from <ADDRESS-ID> to <EFF-FROM-DATE>20060114000000</EFF-FROM-DATE> should be surrounded by ADDRESSES ie the output should look like this
| Code: |
<?xml version="1.0" ?>
- <MESSAGE>
- <SYSTEMDATA>
<SOURCESYSTEM>*</SOURCESYSTEM>
<TARGETSYSTEM>*</TARGETSYSTEM>
- <SYSTEMDATA3R>
<MIDDLETIER3R>*</MIDDLETIER3R>
<USERID3R>*</USERID3R>
</SYSTEMDATA3R>
- <SYSTEMDATACLOAS>
<DATABASE-ID>*</DATABASE-ID>
<USERID>*</USERID>
<MONITOR>*</MONITOR>
</SYSTEMDATACLOAS>
<VER>'1.0'</VER>
- <BUSINESSMETHOD>
<CLASS>CLIENT</CLASS>
<METHOD>ALL ADDRESSES</METHOD>
</BUSINESSMETHOD>
</SYSTEMDATA>
- <BUSINESS-DATA>
- <ALL-ADDRESSES>
- <ADDRESSES>
<ADDRESS-ID>166373025667002</ADDRESS-ID>
<CLIENT-ID>0008224</CLIENT-ID>
<ADDRESS-TYPE>1</ADDRESS-TYPE>
<LINE1>Flat One</LINE1>
<LINE2>Stamford Bridge</LINE2>
<LINE3>Chelsea</LINE3>
<LINE4>UK</LINE4>
<LINE5 />
<POST-CODE>RH45 6YG</POST-CODE>
<EFF-TO-DATE>20051028</EFF-TO-DATE>
<EFF-FROM-DATE>20051027</EFF-FROM-DATE>
- </ADDRESSES>
- <ADDRESSES>
<ADDRESS-ID>166373026950000</ADDRESS-ID>
<CLIENT-ID>0008224</CLIENT-ID>
<ADDRESS-TYPE>1</ADDRESS-TYPE>
<LINE1>13, Ruff Street</LINE1>
<LINE2>Pompey</LINE2>
<LINE3>Ampshire</LINE3>
<LINE4 />
<LINE5 />
<POST-CODE />
<EFF-TO-DATE>20051101</EFF-TO-DATE>
<EFF-FROM-DATE>20051029</EFF-FROM-DATE>
- </ADDRESSES>
- <ADDRESSES>
<ADDRESS-ID>166379431656040</ADDRESS-ID>
<CLIENT-ID>0008224</CLIENT-ID>
<ADDRESS-TYPE>1</ADDRESS-TYPE>
<LINE1>The New Address</LINE1>
<LINE2>Added On 10/01/2006</LINE2>
<LINE3>For Mr Drogba</LINE3>
<LINE4 />
<LINE5 />
<POST-CODE />
<EFF-TO-DATE>20060110</EFF-TO-DATE>
<EFF-FROM-DATE>20060110</EFF-FROM-DATE>
- </ADDRESSES>
- <ADDRESSES>
<ADDRESS-ID>166379433497040</ADDRESS-ID>
<CLIENT-ID>0008224</CLIENT-ID>
<ADDRESS-TYPE>1</ADDRESS-TYPE>
<LINE1>The 2nd New Address</LINE1>
<LINE2>On The 11/01/2006</LINE2>
<LINE3>Should Send 2</LINE3>
<LINE4 />
<LINE5 />
<POST-CODE />
<EFF-TO-DATE>20060112</EFF-TO-DATE>
<EFF-FROM-DATE>20060111</EFF-FROM-DATE>
- </ADDRESSES>
- <ADDRESSES>
<ADDRESS-ID>166379435963040</ADDRESS-ID>
<CLIENT-ID>0008224</CLIENT-ID>
<ADDRESS-TYPE>1</ADDRESS-TYPE>
<LINE1>The 3rd New Address</LINE1>
<LINE2>Now</LINE2>
<LINE3 />
<LINE4 />
<LINE5 />
<POST-CODE />
<EFF-TO-DATE>20060113</EFF-TO-DATE>
<EFF-FROM-DATE>20060113</EFF-FROM-DATE>
- </ADDRESSES>
- <ADDRESSES>
<ADDRESS-ID>166379437732040</ADDRESS-ID>
<CLIENT-ID>0008224</CLIENT-ID>
<ADDRESS-TYPE>1</ADDRESS-TYPE>
<LINE1>The 4th New Address</LINE1>
<LINE2>At 15:21</LINE2>
<LINE3 />
<LINE4 />
<LINE5 />
<POST-CODE />
<EFF-TO-DATE>20060114</EFF-TO-DATE>
<EFF-FROM-DATE>20060114</EFF-FROM-DATE>
- </ADDRESSES>
- <ADDRESSES>
<ADDRESS-ID>166379440044040</ADDRESS-ID>
<CLIENT-ID>0008224</CLIENT-ID>
<ADDRESS-TYPE>1</ADDRESS-TYPE>
<LINE1>The 6th Address</LINE1>
<LINE2>At 12:00</LINE2>
<LINE3 />
<LINE4 />
<LINE5 />
<POST-CODE />
<EFF-TO-DATE>20060115</EFF-TO-DATE>
<EFF-FROM-DATE>20060115</EFF-FROM-DATE>
- </ADDRESSES>
- <ADDRESSES>
<ADDRESS-ID>166379598365080</ADDRESS-ID>
<CLIENT-ID>0008224</CLIENT-ID>
<ADDRESS-TYPE>1</ADDRESS-TYPE>
<LINE1>The All Brand New Address</LINE1>
<LINE2>Called Number 5</LINE2>
<LINE3>Even Though 6 Is There Huh</LINE3>
<LINE4 />
<LINE5 />
<POST-CODE />
<EFF-TO-DATE>20060116</EFF-TO-DATE>
<EFF-FROM-DATE>20060116</EFF-FROM-DATE>
- </ADDRESSES>
- <ADDRESSES>
<ADDRESS-ID>166379600081080</ADDRESS-ID>
<CLIENT-ID>0008224</CLIENT-ID>
<ADDRESS-TYPE>1</ADDRESS-TYPE>
<LINE1>Ben New Address</LINE1>
<LINE2>Buck Palace</LINE2>
<LINE3>London</LINE3>
<LINE4>UK</LINE4>
<LINE5 />
<POST-CODE />
<EFF-TO-DATE>20060117</EFF-TO-DATE>
<EFF-FROM-DATE>20060117</EFF-FROM-DATE>
</ADDRESSES>
</ALL-ADDRESSES>
</BUSINESS-DATA>
</MESSAGE>
|
Apologies foir length of post BUt i wanted to ensure that the messages were listed correctedly. I have removed sensitive data the rest is test data.
All the code required to carry out the transformations is included within the cardinality but for some reason it only writes the ADDRESSES field once.
I am using CREATE FIELD to create the ADDRESSES field but have tried FIRSTCHILD and LASTCHILD etc
Any ideas |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Jan 13, 2006 4:44 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Could you post your ESQL as well?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| nathanw |
| Posted: Fri Jan 13, 2006 4:57 am Post subject: |
|
|
Knight
Joined: 14 Jul 2004
Posts: 550
|
Bloody typical really
5 minutes after posting this I had a brainwave and solved the problem
It was a matter of teh right combination of FIELD, FIRSTCHILD and LASTCHILD.
Seems to be coming out correctly now.
Thanks anyway Jeff (BTW was expecting a cutting reply from you but I didnt get one am happy now)  |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Jan 13, 2006 6:45 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| nathanw wrote: |
| Thanks anyway Jeff (BTW was expecting a cutting reply from you but I didnt get one am happy now) |
You know, if you're feeling that you've missed out...
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| nathanw |
| Posted: Fri Jan 13, 2006 8:59 am Post subject: |
|
|
Knight
Joined: 14 Jul 2004
Posts: 550
|
OK thought I had sorted BUT
For some reason it is missing one of the entries in the Cardinality ie 6 come in 5 go out any ideas
| Code: |
CREATE COMPUTE MODULE PostAddress_Compute
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
CALL CopyMessageHeaders();
SET OutputRoot.MQMD.ApplOriginData = "InputRoot"."MRM"."SYSTEMDATA"."SYSTEMDATACLOAS"."DATABASE-ID";
SET OutputRoot.Properties.MessageDomain = 'XML';
SET OutputRoot.Properties.MessageFormat = '';
SET OutputRoot.Properties.MessageSet = '';
SET OutputRoot.Properties.MessageType = '';
-- Create an XML Declaration
SET OutputRoot.XML.(XML.XmlDecl) = '';
-- Set the Version within the XML Declaration
SET OutputRoot.XML.(XML.XmlDecl).(XML.Version) = '1.0';
DECLARE A INTEGER 1;
DECLARE B INTEGER CARDINALITY(InputRoot.MRM."BUSINESS-DATA".MESSAGE_3R.INPUT.POST_ADDRESS.ADDRESSES.*[]);
WHILE A < B DO
SET OutputRoot.XML.MESSAGE.SYSTEMDATA = InputRoot.MRM.SYSTEMDATA;
SET OutputRoot.XML.MESSAGE.SYSTEMDATA.BUSINESSMETHOD.CLASS = 'CLIENT';
SET OutputRoot.XML.MESSAGE.SYSTEMDATA.BUSINESSMETHOD.METHOD = 'ALL ADDRESSES';
CREATE FIELD OutputLocalEnvironment.Variables;
DECLARE VarRef REFERENCE TO OutputLocalEnvironment.Variables;
DECLARE OutRef REFERENCE TO OutputRoot.XML.MESSAGE;
DECLARE InRef REFERENCE TO InputRoot.MRM."BUSINESS-DATA".MESSAGE_3R.INPUT.POST_ADDRESS.ADDRESSES.*[A];
CREATE FIELD OutRef."BUSINESS-DATA"."ALL-ADDRESSES" As OutRef;
CREATE FIRSTCHILD OF OutRef NAME 'ADDRESSES';
CREATE LASTCHILD OF OutRef.ADDRESSES NAME 'ADDRESS-ID' VALUE InRef.ADDRESS_ID;
-- DECLARE CLOASID CHAR;
-- DECLARE THREERID CHAR;
-- SET THREERID = InputRoot.MRM."BUSINESS-DATA".MESSAGE_3R.INPUT.POST_ADDRESS.ADDRESSES.ADDRESS_INFO.CLIENT_ID;
-- SET Environment.RESULTSET.*[] = (SELECT A.UNIQUE_CLOAS_CLIENT_ID from Database.CROSSREF AS A WHERE A.UNIQUE_3R_CLIENT_ID = THREERID);
-- SET CLOASID = TRIM(TRAILING ' ' FROM Environment.RESULTSET.[1].UNIQUE_CLOAS_CLIENT_ID);
-- CREATE LASTCHILD OF OutRef NAME 'CLIENT-ID' VALUE CLOASID;
--DECLARE BCNAME CHAR;
--DECLARE BNAME CHAR;
--SET BCNAME = InputRoot.MRM."BUSINESS-DATA".MESSAGE_3R.INPUT.POST_ADDRESS.ADDRESSES.ADDRESS_INFO.BUSINESS_CONTACT_NAME;
--SET BNAME = InputRoot.MRM."BUSINESS-DATA".MESSAGE_3R.INPUT.POST_ADDRESS.ADDRESSES.ADDRESS_INFO.BUSINESS_NAME;
--IF BCNAME <> ''
-- THEN CREATE LASTCHILD OF OutRef NAME 'ADDRESSEE' VALUE BCNAME;
-- ELSE
-- CREATE LASTCHILD OF OutRef NAME 'ADDRESSEE' VALUE BNAME;
--END IF;
CREATE LASTCHILD OF OutRef.ADDRESSES NAME 'ADDRESS-TYPE' VALUE InRef.TYPE;
CREATE LASTCHILD OF OutRef.ADDRESSES NAME 'LINE1' VALUE InRef.LINE1;
CREATE LASTCHILD OF OutRef.ADDRESSES NAME 'LINE2' VALUE InRef.LINE2;
CREATE LASTCHILD OF OutRef.ADDRESSES NAME 'LINE3' VALUE InRef.LINE3;
CREATE LASTCHILD OF OutRef.ADDRESSES NAME 'LINE4' VALUE InRef.LINE4;
CREATE LASTCHILD OF OutRef.ADDRESSES NAME 'LINE5' VALUE InRef.LINE5;
CREATE LASTCHILD OF OutRef.ADDRESSES NAME 'POST-CODE' VALUE InRef.POST_CODE;
CREATE LASTCHILD OF OutRef.ADDRESSES NAME 'EFF-TO-DATE' VALUE InRef.EFF_TO_DATE;
CREATE LASTCHILD OF OutRef.ADDRESSES NAME 'EFF-FROM-DATE' VALUE InRef.EFF_FROM_DATE;
SET A = A + 1;
END WHILE;
RETURN TRUE;
END;
CREATE PROCEDURE CopyMessageHeaders() BEGIN
DECLARE I INTEGER 1;
DECLARE J INTEGER CARDINALITY(InputRoot.*[]);
WHILE I < J DO
SET OutputRoot.*[I] = InputRoot.*[I];
SET I = I + 1;
END WHILE;
END;
CREATE PROCEDURE CopyEntireMessage() BEGIN
SET OutputRoot = InputRoot;
END;
END MODULE;
|
Jeff oh know i dont feel that at all! |
|
| Back to top |
|
|
| mgk |
| Posted: Fri Jan 13, 2006 9:07 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Shouldn't
This:
be
Regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| nathanw |
| Posted: Fri Jan 13, 2006 9:10 am Post subject: |
|
|
Knight
Joined: 14 Jul 2004
Posts: 550
|
|
| Back to top |
|
|
|
|
