| Author |
Message
|
| shammi80 |
 Posted: Mon Feb 20, 2012 2:24 pm Post subject: Userdefined Message SET problem |
 |
|
Apprentice
Joined: 17 Feb 2012
Posts: 32
|
Hi,
I have created the message set for the destination system with two atrribute Empnumber and transaction code and set the logical properties ffixed value ='E' and also for the empnumber is default.
The physical Properties I have set for both attribute.
My flow is something like this
MQINPUT(XMLNSC parser)->Compute->FileOutput
But when the message come from MQINPUT is pass through the compute node then in the output of the file it only create the fixed value variable ie Transaction code but the the value of empid that is in input XML is not comes in the output file.
OUTPUTROOT.MRM.EMPID=INPUTROOT.XMLNSC.XMLOPATH.EMPID
Please advice |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Mon Feb 20, 2012 2:26 pm Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Put two trace nodes (one) before and (second) after your compute node. Then post the output. We will be able to help you better once we see the output.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| shammi80 |
| Posted: Mon Feb 20, 2012 5:09 pm Post subject: |
|
|
Apprentice
Joined: 17 Feb 2012
Posts: 32
|
========= Message before compute node ===================
( ['MQROOT' : 0x14b079e8]
(0x01000000:Name ):Properties = ( ['MQPROPERTYPARSER' : 0x14b0c1f8]
(0x03000000:NameValue):MessageSet = '' (CHARACTER)
(0x03000000:NameValue):MessageType = '' (CHARACTER)
(0x03000000:NameValue):MessageFormat = '' (CHARACTER)
(0x03000000:NameValue):Encoding = 546 (INTEGER)
(0x03000000:NameValue):CodedCharSetId = 437 (INTEGER)
(0x03000000:NameValue):Transactional = TRUE (BOOLEAN)
(0x03000000:NameValue):Persistence = FALSE (BOOLEAN)
(0x03000000:NameValue):CreationTime = GMTTIMESTAMP '2012-02-21 00:52:45.280' (GMTTIMESTAMP)
(0x03000000:NameValue):ExpirationTime = -1 (INTEGER)
(0x03000000:NameValue):Priority = 0 (INTEGER)
(0x03000000:NameValue):ReplyIdentifier = X'000000000000000000000000000000000000000000000000' (BLOB)
(0x03000000:NameValue):ReplyProtocol = 'MQ' (CHARACTER)
(0x03000000:NameValue):Topic = NULL
(0x03000000:NameValue):ContentType = '' (CHARACTER)
(0x03000000:NameValue):IdentitySourceType = '' (CHARACTER)
(0x03000000:NameValue):IdentitySourceToken = '' (CHARACTER)
(0x03000000:NameValue):IdentitySourcePassword = '' (CHARACTER)
(0x03000000:NameValue):IdentitySourceIssuedBy = '' (CHARACTER)
(0x03000000:NameValue):IdentityMappedType = '' (CHARACTER)
(0x03000000:NameValue):IdentityMappedToken = '' (CHARACTER)
(0x03000000:NameValue):IdentityMappedPassword = '' (CHARACTER)
(0x03000000:NameValue):IdentityMappedIssuedBy = '' (CHARACTER)
)
(0x01000000:Name ):MQMD = ( ['MQHMD' : 0x19f45ee0]
(0x03000000:NameValue):SourceQueue = '1' (CHARACTER)
(0x03000000:NameValue):Transactional = TRUE (BOOLEAN)
(0x03000000:NameValue):Encoding = 546 (INTEGER)
(0x03000000:NameValue):CodedCharSetId = 437 (INTEGER)
(0x03000000:NameValue):Format = ' ' (CHARACTER)
(0x03000000:NameValue):Version = 2 (INTEGER)
(0x03000000:NameValue):Report = 0 (INTEGER)
(0x03000000:NameValue):MsgType = 8 (INTEGER)
(0x03000000:NameValue):Expiry = -1 (INTEGER)
(0x03000000:NameValue):Feedback = 0 (INTEGER)
(0x03000000:NameValue):Priority = 0 (INTEGER)
(0x03000000:NameValue):Persistence = 0 (INTEGER)
(0x03000000:NameValue):MsgId = X'414d51204d4237514d4752202020202012e4424f20003e07' (BLOB)
(0x03000000:NameValue):CorrelId = X'000000000000000000000000000000000000000000000000' (BLOB)
(0x03000000:NameValue):BackoutCount = 0 (INTEGER)
(0x03000000:NameValue):ReplyToQ = ' ' (CHARACTER)
(0x03000000:NameValue):ReplyToQMgr = 'MB7QMGR ' (CHARACTER)
(0x03000000:NameValue):UserIdentifier = 'Harish Dhima' (CHARACTER)
(0x03000000:NameValue):AccountingToken = X'1601051500000028da80e92c032252d865b3d4eb03000000000000000000000b' (BLOB)
(0x03000000:NameValue):ApplIdentityData = ' ' (CHARACTER)
(0x03000000:NameValue):PutApplType = 11 (INTEGER)
(0x03000000:NameValue):PutApplName = 'C:\HCMS\rfhutil.exe ' (CHARACTER)
(0x03000000:NameValue):PutDate = DATE '2012-02-21' (DATE)
(0x03000000:NameValue):PutTime = GMTTIME '00:52:45.280' (GMTTIME)
(0x03000000:NameValue):ApplOriginData = ' ' (CHARACTER)
(0x03000000:NameValue):GroupId = X'000000000000000000000000000000000000000000000000' (BLOB)
(0x03000000:NameValue):MsgSeqNumber = 1 (INTEGER)
(0x03000000:NameValue):Offset = 0 (INTEGER)
(0x03000000:NameValue):MsgFlags = 0 (INTEGER)
(0x03000000:NameValue):OriginalLength = -1 (INTEGER)
)
(0x01000000:Folder):XMLNSC = ( ['xmlnsc' : 0x14b077c0]
(0x01000400:NamespaceDecl):XmlDeclaration = (
(0x03000100:Attribute):Version = '1.0' (CHARACTER)
(0x03000100:Attribute):Encoding = 'UTF-8' (CHARACTER)
)
(0x01000000:Folder )urn:com.workday/picof:Payroll_Extract_Employees = (
(0x03000102:NamespaceDecl)http://www.w3.org/2000/xmlns/:pi = 'urn:com.workday/picof' (CHARACTER)
(0x01000000:Folder )urn:com.workday/picof:PayGroup = (
(0x01000000:Folder)urn:com.workday/picof:Header = (
(0x03000000:PCDataField)urn:com.workday/picof:Version = '15' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Payroll_Company_ID = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Payroll_Company_Name = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Pay_Group_Name = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Pay_Period_Start = '2012-01-30-08:00' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Pay_Period_End = '2012-02-12-08:00' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Updated_From = '2012-02-12T21:15:37.309-08:00' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Updated_To = '2012-02-12T21:18:37.809-08:00' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:All_Effective = 'false' (CHARACTER)
)
(0x01000000:Folder)urn:com.workday/picof:Employee = (
(0x01000000:Folder)urn:com.workday/picof:Summary = (
(0x03000000:PCDataField)urn:com.workday/picof:Employee_ID = '0003' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Name = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Payroll_Company_ID = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Payroll_Company_Name = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Pay_Group_Name = '' (CHARACTER)
)
(0x01000000:Folder)urn:com.workday/picof:Personal = (
(0x03000000:PCDataField)urn:com.workday/picof:First_Name = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Last_Name = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Gender = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Birth_Date = '1952-06-01' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Marital_Status = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:First_Address_Line_Data = '243 Consumers Road' (CHARACTER)
(
(0x03000100:Attribute)urn:com.workday/picof:Label = 'Address Line 1' (CHARACTER)
(0x03000100:Attribute)urn:com.workday/picof:Type = 'ADDRESS_LINE_1' (CHARACTER)
)
(0x03000000:PCDataField)urn:com.workday/picof:First_Municipality = 'Toronto' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:First_Region = 'Ontario' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:First_Postal_Code = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:First_Country = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Second_Address_Line_Data = '243 Consumers Road' (CHARACTER)
(
(0x03000100:Attribute)urn:com.workday/picof:Label = 'Address Line 1' (CHARACTER)
(0x03000100:Attribute)urn:com.workday/picof:Type = 'ADDRESS_LINE_1' (CHARACTER)
)
(0x03000000:PCDataField)urn:com.workday/picof:Second_Municipality = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Second_Region = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Second_Postal_Code = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Second_Country = 'CA' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:International_Phone_Code = '1' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Area_Code = '416' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Phone_Number = '493-1220' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:First_Email_Address = '' (CHARACTER)
)
(0x01000000:Folder)urn:com.workday/picof:Status = (
(0x03000000:PCDataField)urn:com.workday/picof:Payroll_Company = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Pay_Group = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Employee_Status = 'Active' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Active = '1' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Active_Status_Date = '1981-09-14' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Hire_Date = '1981-09-14' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Original_Hire_Date = '1981-09-14' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Hire_Reason = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:First_Day_of_Work = '1981-09-14' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Seniority_Date = '1981-09-14' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Terminated = '0' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Not_Eligible_for_Hire = '0' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Not_Returning = '0' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Return_Unknown = '0' (CHARACTER)
)
(0x01000000:Folder)urn:com.workday/picof:Position = (
(0x03000000:PCDataField)urn:com.workday/picof:Operation = 'NONE' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Position_ID = 'AUDIT,LE02' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Effective_Date = '2011-12-20' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Primary_Job = '1' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Business_Title = 'Auditor, Lease' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Worker_Type = 'Regular' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Position_Time_Type = 'Full Time' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Job_Exempt = '0' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Scheduled_Weekly_Hours = '35' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Default_Weekly_Hours = '35' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Pay_Rate_Type = 'Salary' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Compensation_Effective_Date = '2012-01-01' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Compensation_Change_Reason = 'Request_Compensation_Change_Conversion_Conversion' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Total_Annual_Base_Pay = '73019.49' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Total_Base_Pay = '2808.44' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Base_Pay_Currency = 'CAD' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Base_Pay_Frequency = 'Bi_weekly' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Job_Profile = 'ANA003SDM' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Management_Level = 'Individual Contributor' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Job_Family = 'Operations - Functional Analytic' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Business_Site = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Business_Site_Name = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Business_Site_Region = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Business_Site_Postal_Code = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Business_Site_Country = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Supervisor_ID = '1810' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Supervisor_Name = '' (CHARACTER)
)
(0x01000000:Folder)urn:com.workday/picof:Identifier = (
(0x03000000:PCDataField)urn:com.workday/picof:Operation = 'NONE' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Identifier_Type = 'CAN-SIN' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Identifier_Value = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Country = '' (CHARACTER)
)
(0x01000000:Folder)urn:com.workday/picof:Payment_Election = (
(0x03000000:PCDataField)urn:com.workday/picof:Operation = 'NONE' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Order = '1' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Country = 'CA' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Currency = 'CAD' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Bank_Account_Name = 'CIBC' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Account_Number = '0648639' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Account_Type = 'DDA' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Bank_Name = 'CIBC' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Bank_ID_Number = '010' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Branch_ID_Number = '09042' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Distribution_Balance = '1' (CHARACTER)
)
(0x01000000:Folder)urn:com.workday/picof:Additional_Information = (
(0x03000000:PCDataField)urn:com.workday/picof:SIN = '547 620 955' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Legal_First = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Legal_Last = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Cost_Center = '10007' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Hourly_Rate = '0' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Hourly_Amount_per_Week = '35' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Salary_Amount = '73019.49' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Job_Grade = '13 Individual Contributor' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Company_Code = '' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Compensation_Plans = 'Short-Term Incentive Plan - Non-Executive - SDM (Percent)' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Home_Province = 'ON' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Location_Province = 'ON' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Pay_Rate_Type = 'Salary' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Position_Time_Type = 'Full Time' (CHARACTER)
(0x03000000:PCDataField)urn:com.workday/picof:Worker_Type = 'EE' (CHARACTER)
)
)
)
)
)
)
------------------
(0x03000000:NameValue):Persistence = FALSE (BOOLEAN)
(0x03000000:NameValue):CreationTime = GMTTIMESTAMP '2012-02-21 00:52:45.280' (GMTTIMESTAMP)
(0x03000000:NameValue):ExpirationTime = -1 (INTEGER)
(0x03000000:NameValue):Priority = 0 (INTEGER)
(0x03000000:NameValue):ReplyIdentifier = X'000000000000000000000000000000000000000000000000' (BLOB)
(0x03000000:NameValue):ReplyProtocol = 'MQ' (CHARACTER)
(0x03000000:NameValue):Topic = NULL
(0x03000000:NameValue):ContentType = '' (CHARACTER)
(0x03000000:NameValue):IdentitySourceType = '' (CHARACTER)
(0x03000000:NameValue):IdentitySourceToken = '' (CHARACTER)
(0x03000000:NameValue):IdentitySourcePassword = '' (CHARACTER)
(0x03000000:NameValue):IdentitySourceIssuedBy = '' (CHARACTER)
(0x03000000:NameValue):IdentityMappedType = '' (CHARACTER)
(0x03000000:NameValue):IdentityMappedToken = '' (CHARACTER)
(0x03000000:NameValue):IdentityMappedPassword = '' (CHARACTER)
(0x03000000:NameValue):IdentityMappedIssuedBy = '' (CHARACTER)
)
(0x01000000:Name ):MQMD = ( ['MQHMD' : 0x14a74cb0]
(0x03000000:NameValue):SourceQueue = '1' (CHARACTER)
(0x03000000:NameValue):Transactional = TRUE (BOOLEAN)
(0x03000000:NameValue):Encoding = 546 (INTEGER)
(0x03000000:NameValue):CodedCharSetId = 437 (INTEGER)
(0x03000000:NameValue):Format = ' ' (CHARACTER)
(0x03000000:NameValue):Version = 2 (INTEGER)
(0x03000000:NameValue):Report = 0 (INTEGER)
(0x03000000:NameValue):MsgType = 8 (INTEGER)
(0x03000000:NameValue):Expiry = -1 (INTEGER)
(0x03000000:NameValue):Feedback = 0 (INTEGER)
(0x03000000:NameValue):Priority = 0 (INTEGER)
(0x03000000:NameValue):Persistence = 0 (INTEGER)
(0x03000000:NameValue):MsgId = X'414d51204d4237514d4752202020202012e4424f20003e07' (BLOB)
(0x03000000:NameValue):CorrelId = X'000000000000000000000000000000000000000000000000' (BLOB)
(0x03000000:NameValue):BackoutCount = 0 (INTEGER)
(0x03000000:NameValue):ReplyToQ = ' ' (CHARACTER)
(0x03000000:NameValue):ReplyToQMgr = 'MB7QMGR ' (CHARACTER)
(0x03000000:NameValue):UserIdentifier = '' (CHARACTER)
(0x03000000:NameValue):AccountingToken = X'1601051500000028da80e92c032252d865b3d4eb03000000000000000000000b' (BLOB)
(0x03000000:NameValue):ApplIdentityData = ' ' (CHARACTER)
(0x03000000:NameValue):PutApplType = 11 (INTEGER)
(0x03000000:NameValue):PutApplName = 'C:\HCMS\rfhutil.exe ' (CHARACTER)
(0x03000000:NameValue):PutDate = DATE '2012-02-21' (DATE)
(0x03000000:NameValue):PutTime = GMTTIME '00:52:45.280' (GMTTIME)
(0x03000000:NameValue):ApplOriginData = ' ' (CHARACTER)
(0x03000000:NameValue):GroupId = X'000000000000000000000000000000000000000000000000' (BLOB)
(0x03000000:NameValue):MsgSeqNumber = 1 (INTEGER)
(0x03000000:NameValue):Offset = 0 (INTEGER)
(0x03000000:NameValue):MsgFlags = 0 (INTEGER)
(0x03000000:NameValue):OriginalLength = -1 (INTEGER)
)
(0x01000021:Name+):MRM = ( ['mrm' : 0x19fdcf68]
(0x03000000:NameValue):TransactionCode = 'AB' (CHARACTER)
)
) |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Mon Feb 20, 2012 10:50 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| Code: |
| OUTPUTROOT.MRM.EMPID=INPUTROOT.XMLNSC.XMLOPATH.EMPID |
I assume that you really mean
| Code: |
set OutputRoot.MRM.empid = InputRoot.XMLNSC.xmlopath.empid
|
So:-
Where is the field/tag called XMLOPATH ( and variation thereof)?
Where is the field EMPID? Don't you mean Employee_ID?
What about the namespace ? That is part of the tree you have to navigate.
Several of the samples provided with broker have ESQL that uses NAMESPACES. If you can't (or won't) take the excellent training course that covers this then I humbly suggest you look at the samples and some of the many posts in this forum for some really excellent tips on using them.
_________________
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 |
|
|
| kimbert |
| Posted: Tue Feb 21, 2012 12:29 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
Please put in more of your own time *before* asking us to spend ours. I don't see any evidence that you have made a real effort to debug this problem yourself. For a start, as smdavies99 points out, your input message is completely different from your ( misquoted ) ESQL.
There is no point in asking questions about the output until you have checked that the first node in the flow is doing what you expected. |
|
| Back to top |
|
|
| shammi80 |
| Posted: Tue Feb 21, 2012 8:57 am Post subject: |
|
|
Apprentice
Joined: 17 Feb 2012
Posts: 32
|
Hi,
my flows now taing the values from the source XML.
But I am facing another problem , I have created the message set which will put <CR> after every record finish but now the fileoutput node created a long file.
My code is below.
| Code: |
DECLARE pi NAMESPACE 'urn:com.workday/picof';
CREATE COMPUTE MODULE testing_Compute
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
CALL CopyMessageHeaders();
--CALL CopyEntireMessage();
SET OutputRoot.Properties.MessageSet = 'IJQBNVO002001';
SET OutputRoot.Properties.MessageType = 'Launch_Payflex_Record';
SET OutputRoot.Properties.MessageFormat = 'Text' ;
------------------------Header Record----------------------------------------------------------------------------
CREATE FIELD OutputRoot.MRM.HeaderRecord;
CREATE FIELD OutputRoot.MRM.BatchRecord;
CREATE FIELD OutputRoot.MRM.Employee_Identification;
SET OutputRoot.MRM.HeaderRecord.TransactionCode= 'PCEXT.DAT' ;
SET OutputRoot.MRM.HeaderRecord.Filler = ' ';
SET OutputRoot.MRM.HeaderRecord.Marker= 'X' ;
------------------------Batch Record-----------------------------------------------------------------------------
SET OutputRoot.MRM.BatchRecord.TransactionCode = 'BATCH';
-- CALL Common.Utils.GetCompanyNumber()INTO OutputRoot.MRM.BatchRecord.CompanyNumber ;
SET OutputRoot.MRM.BatchRecord.CompanyNumber = 14208;
SET OutputRoot.MRM.BatchRecord.BatchNumber = 'HRIS' ;
SET OutputRoot.MRM.BatchRecord.NumberOfTransaction = 0;
SET OutputRoot.MRM.BatchRecord.BlankSpace = ' ';
SET OutputRoot.MRM.BatchRecord.Amount1 = 0;
SET OutputRoot.MRM.BatchRecord.Amount2 = 0;
SET OutputRoot.MRM.BatchRecord.Amount_Percent_Hash_Total = 0;
------------------------Employee Identification Record-----------------------------------------------------------------------------
SET OutputRoot.MRM.Employee_Identification.TransactionCode = 'E' ;
SET OutputRoot.MRM.Employee_Identification.EmployeeNumber = InputRoot.XMLNSC.pi:Payroll_Extract_Employees.pi:PayGroup.pi:Employee.pi:Summary.pi:Employee_ID;
SET OutputRoot.MRM.Employee_Identification.SSN = '111-111-111' ;
SET OutputRoot.MRM.Employee_Identification.PayFrequency = 2;
SET OutputRoot.MRM.Employee_Identification.PayCode = 1;
SET OutputRoot.MRM.Employee_Identification.StatusCode = 'FT';
SET OutputRoot.MRM.Employee_Identification.SexCode ='M';
SET OutputRoot.MRM.Employee_Identification.LanguagePreference = 'FR' ;
SET OutputRoot.MRM.Employee_Identification.UnionCode = ' ';
SET OutputRoot.MRM.Employee_Identification.WorkersComp = 'CR-AB';
SET OutputRoot.MRM.Employee_Identification.BirthDate = Current_Date ;
SET OutputRoot.MRM.Employee_Identification.EmploymentCode = ' ';
SET OutputRoot.MRM.Employee_Identification.EmploymentDate = Current_Date ;
SET OutputRoot.MRM.Employee_Identification.TerminationCode = 'E' ;
SET OutputRoot.MRM.Employee_Identification.TerminationDate = Current_Date ;
SET OutputRoot.MRM.Employee_Identification.NormalShift = 0 ;
SET OutputRoot.MRM.Employee_Identification.SplitMethod = 0 ;
SET OutputRoot.MRM.Employee_Identification.JobCode = ' ';
SET OutputRoot.MRM.Employee_Identification.MartialStatus = 1;
SET OutputRoot.MRM.Employee_Identification.CommissionedEmployee = ' ';
SET OutputRoot.MRM.Employee_Identification.PeriodOverride = 0;
-------------------------------EMPLOYEE NAME-----------------------------------------------------------------------------
SET OutputRoot.MRM.Employee_Name.TransactionCode = 'F1';
SET OutputRoot.MRM.Employee_Name.EmployeeNumber = '1001';
SET OutputRoot.MRM.Employee_Name.AddressCode = 001;
SET OutputRoot.MRM.Employee_Name.EmployeeName = 'Kumar_Amit' ;
SET OutputRoot.MRM.Employee_Name.AddressLine1 = 'Noida';
-------------------------------EMPLOYEE ADDRESS-----------------------------------------------------------------------------
SET OutputRoot.MRM.Employee_Address.TransactionCode = 'F3';
SET OutputRoot.MRM.Employee_Address.EmployeeNumber = '1001';
SET OutputRoot.MRM.Employee_Address.AddressCode = '001';
SET OutputRoot.MRM.Employee_Address.AddressLine2 = 'NOIDA5';
SET OutputRoot.MRM.Employee_Address.City = 'AB';
SET OutputRoot.MRM.Employee_Address.PostalCode = '110011';
---------------------------LABOUR DISTRIBUTION---------------------------------------------------------------------------
SET OutputRoot.MRM.Labour_Distribution.TransactionCode = 'G';
SET OutputRoot.MRM.Labour_Distribution.EmployeeNumber = '1001';
SET OutputRoot.MRM.Labour_Distribution.SplitNumber = '01';
SET OutputRoot.MRM.Labour_Distribution.SplitPercentage = 0 ;
SET OutputRoot.MRM.Labour_Distribution.Control3_Region = '12';
SET OutputRoot.MRM.Labour_Distribution.Control4_Div = '13';
SET OutputRoot.MRM.Labour_Distribution.Control5_CostCenter = '326';
SET OutputRoot.MRM.Labour_Distribution.Control6_PayrollSubAccountCode = '0010';
SET OutputRoot.MRM.Labour_Distribution.Function = '4273';
-------------------------------NORMAL PAY---------------------------------------------------------------------------------
SET OutputRoot.MRM.Normal_pay.TransactionCode = 'H';
SET OutputRoot.MRM.Normal_pay.EmployeeNumber = '1001';
SET OutputRoot.MRM.Normal_pay.HEDNumber = 001;
SET OutputRoot.MRM.Normal_pay.FrequencyCode = 0;
SET OutputRoot.MRM.Normal_pay.TypeCode = 0;
SET OutputRoot.MRM.Normal_pay.MethodCode = 0;
SET OutputRoot.MRM.Normal_pay.HourlyRate = 100000 ;
SET OutputRoot.MRM.Normal_pay.StartCode = 0;
SET OutputRoot.MRM.Normal_pay.StartField = ' ';
SET OutputRoot.MRM.Normal_pay.StopCode = ' ' ;
SET OutputRoot.MRM.Normal_pay.StopField = ' ';
SET OutputRoot.MRM.Normal_pay.Filler1 = 0;
SET OutputRoot.MRM.Normal_pay.Filler2 = 0;
SET OutputRoot.MRM.Normal_pay.AmountOne = 1000;
SET OutputRoot.MRM.Normal_pay.AmountTwo = 2000;
SET OutputRoot.MRM.Normal_pay.DescriptionCode = ' ';
SET OutputRoot.MRM.Normal_pay.DescriptionField = ' ';
------------------------------- EARNINGS OR DEDUCTIONS---------------------------------------------------------------------------------
SET OutputRoot.MRM.Earning_OR_Deduction.TransactionCode = 'H_';
SET OutputRoot.MRM.Earning_OR_Deduction.EmployeeNumber = '1001';
SET OutputRoot.MRM.Earning_OR_Deduction.HEDNumber = 260;
SET OutputRoot.MRM.Earning_OR_Deduction.FrequencyCode = 01;
SET OutputRoot.MRM.Earning_OR_Deduction.TypeCode = 0;
SET OutputRoot.MRM.Earning_OR_Deduction.MethodCode= ' ';
SET OutputRoot.MRM.Earning_OR_Deduction.Amount_Percent = 500000;
SET OutputRoot.MRM.Earning_OR_Deduction.StartCode = 0;
SET OutputRoot.MRM.Earning_OR_Deduction.StartField = ' ';
SET OutputRoot.MRM.Earning_OR_Deduction.StopCode = ' ' ;
SET OutputRoot.MRM.Earning_OR_Deduction.StopField = ' ';
SET OutputRoot.MRM.Earning_OR_Deduction.Filler1 = 0;
SET OutputRoot.MRM.Earning_OR_Deduction.Filler2 = 0;
SET OutputRoot.MRM.Earning_OR_Deduction.AmountOne = 0;
SET OutputRoot.MRM.Earning_OR_Deduction.AmountTwo = 0;
SET OutputRoot.MRM.Earning_OR_Deduction.DescriptionCode = ' ';
SET OutputRoot.MRM.Earning_OR_Deduction.DescriptionField = ' ';
------------------------------- Deposits ---------------------------------------------------------------------------------
SET OutputRoot.MRM.Deposits.TransactionCode = 'H_';
SET OutputRoot.MRM.Deposits.EmployeeNumber = '1001';
SET OutputRoot.MRM.Deposits.HEDNumber = 999;
SET OutputRoot.MRM.Deposits.FrequencyCode = 01;
SET OutputRoot.MRM.Deposits.TypeCode = 0;
SET OutputRoot.MRM.Deposits.MethodCode= 0;
SET OutputRoot.MRM.Deposits.Amount_Percent = 5000;
SET OutputRoot.MRM.Deposits.StartCode = 0;
SET OutputRoot.MRM.Deposits.StartField = ' ';
SET OutputRoot.MRM.Deposits.StopCode = ' ' ;
SET OutputRoot.MRM.Deposits.StopField = ' ';
SET OutputRoot.MRM.Deposits.Filler1 = 0;
SET OutputRoot.MRM.Deposits.Filler2 = 0;
SET OutputRoot.MRM.Deposits.DepositCode = 'D';
SET OutputRoot.MRM.Deposits.BankNumber = 0;
SET OutputRoot.MRM.Deposits.BranchNumber = 0;
SET OutputRoot.MRM.Deposits.Cheque_Saving_Code = ' ';
SET OutputRoot.MRM.Deposits.AccountNumber = ' ';
------------------------------- FEDERAL CLAIM AMT ---------------------------------------------------------------------------------
SET OutputRoot.MRM.Federal_Claim_Amount.BlankSpace = ' ';
SET OutputRoot.MRM.Federal_Claim_Amount.TransactionCode = 'J';
SET OutputRoot.MRM.Federal_Claim_Amount.EmployeeNumber = '1001';
SET OutputRoot.MRM.Federal_Claim_Amount.Filler1 = ' ';
SET OutputRoot.MRM.Federal_Claim_Amount.TaxID = '1';
SET OutputRoot.MRM.Federal_Claim_Amount.NetClaimAmount = 763400 ;
SET OutputRoot.MRM.Federal_Claim_Amount.NonIndexedAmount = 0;
SET OutputRoot.MRM.Federal_Claim_Amount.ProvincialOtherDeductions = 0;
------------------------------- FEDERAL TAX ---------------------------------------------------------------------------------
SET OutputRoot.MRM.Federal_Tax.TransactionCode = 'J';
SET OutputRoot.MRM.Federal_Tax.EmployeeNumber = '1001';
SET OutputRoot.MRM.Federal_Tax.Filler1 = ' ';
SET OutputRoot.MRM.Federal_Tax.TaxType = '2';
SET OutputRoot.MRM.Federal_Tax.TaxProvince = 'AB';
SET OutputRoot.MRM.Federal_Tax.EI_PREF = 'R';
SET OutputRoot.MRM.Federal_Tax.Filler2 = ' ';
SET OutputRoot.MRM.Federal_Tax.TaxMethodCode = 3;
SET OutputRoot.MRM.Federal_Tax.Filler3 = ' ';
SET OutputRoot.MRM.Federal_Tax.AdditionalFedTax = 5000;
SET OutputRoot.MRM.Federal_Tax.CPP_QPP_Code = '1';
SET OutputRoot.MRM.Federal_Tax.FederalTaxExempt = 0;
SET OutputRoot.MRM.Federal_Tax.Filler4 = ' ';
SET OutputRoot.MRM.Federal_Tax.OtherCredits = 0 ;
-----------------------J3 - PROVINCIAL TAX -------------------------------------------------------------
SET OutputRoot.MRM.Provinicial_Tax.TransactionCode = 'J_';
SET OutputRoot.MRM.Provinicial_Tax.EmployeeNumber = '1001' ;
SET OutputRoot.MRM.Provinicial_Tax.Filler1 = ' ';
SET OutputRoot.MRM.Provinicial_Tax.TaxType = 3;
SET OutputRoot.MRM.Provinicial_Tax.TaxProvince = 'AB';
SET OutputRoot.MRM.Provinicial_Tax.EI_PREF = 'R';
SET OutputRoot.MRM.Provinicial_Tax.Filler2 = 0;
SET OutputRoot.MRM.Provinicial_Tax.TaxMethodCode = '3';
SET OutputRoot.MRM.Provinicial_Tax.Filler3 = ' ';
SET OutputRoot.MRM.Provinicial_Tax.TaxProvinceCode = 12;
SET OutputRoot.MRM.Provinicial_Tax.EI_CODE = 1;
SET OutputRoot.MRM.Provinicial_Tax.ProvincialTaxExempt = 07436;
SET OutputRoot.MRM.Provinicial_Tax.Filler4 = ' ';
SET OutputRoot.MRM.Provinicial_Tax.OtherExemptions = 0;
----------------------------VACATION STATUS ----------------------------------------------------------
SET OutputRoot.MRM.Vacation_Status.TransactionCode = 'LA';
SET OutputRoot.MRM.Vacation_Status.EmployeeNumber ='1001';
SET OutputRoot.MRM.Vacation_Status.JobDescription = ' ';
SET OutputRoot.MRM.Vacation_Status.VacationPlan = ' ';
SET OutputRoot.MRM.Vacation_Status.VacationPercent = 0;
SET OutputRoot.MRM.Vacation_Status.VacationDate = Current_Date;
SET OutputRoot.MRM.Vacation_Status.PeriodChargedTo = Current_Date;
SET OutputRoot.MRM.Vacation_Status.StatusIndicator = ' ';
SET OutputRoot.MRM.Vacation_Status.VacationWeeks = 0;
SET OutputRoot.MRM.Vacation_Status.VacationONVacation = ' ';
SET OutputRoot.MRM.Vacation_Status.TelephoneNumber = '123-345-2345';
SET OutputRoot.MRM.Vacation_Status.TS_Extra_Lines = ' ';
SET OutputRoot.MRM.Vacation_Status.Pay_Greater_Than_Option = ' ';
SET OutputRoot.MRM.Vacation_Status.PG = ' ';
SET OutputRoot.MRM.Vacation_Status.StatsCanadaNumber = ' ';
----------------------------EMPLOYEE GENERAL INFORMATION (GIF) ----------------------------------------------------------
SET OutputRoot.MRM.Employee_General_Information.TransactionCode = 'LB';
SET OutputRoot.MRM.Employee_General_Information.EmployeeNumber = '1001';
SET OutputRoot.MRM.Employee_General_Information.GIF_Field1 = Current_Date;
SET OutputRoot.MRM.Employee_General_Information.GIF_Field2 = ' ';
SET OutputRoot.MRM.Employee_General_Information.GIF_Field3= ' ';
SET OutputRoot.MRM.Employee_General_Information.GIF_Field4 = Current_Date;
SET OutputRoot.MRM.Employee_General_Information.GIF_Field5 = '03';
SET OutputRoot.MRM.Employee_General_Information.GIF_Field6 = ' ';
SET OutputRoot.MRM.Employee_General_Information.GIF_Field7 = ' ';
SET OutputRoot.MRM.Employee_General_Information.GIF_Field8 = ' ';
RETURN TRUE;
END;
CREATE PROCEDURE CopyMessageHeaders() BEGIN
DECLARE I INTEGER 1;
DECLARE J INTEGER;
SET J = 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; |
|
|
| Back to top |
|
|
| kimbert |
| Posted: Tue Feb 21, 2012 9:10 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| We have no idea why you are telling us about these things. Please delete most of the code that you posted, and then take a lot of your own time to write a carefully worded question. Then we may be able to help you. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Feb 21, 2012 9:13 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| shammi80 wrote: |
| But I am facing another problem , I have created the message set which will put <CR> after every record finish but now the fileoutput node created a long file. |
So if the message set is intended to put a <CR> after each record how is posting the code supposed to help or inform us?
How have you arranged this is the message set? Why have you chosen to do this in the message set rather than the output node? Does "a long file" mean each field has a <CR> after it or the entire output is unbroken?
What have you done to diagnose the problem? What does a user trace show?
As indicated in your previous 2 threads, we're not a training resource nor are we inclined to write your solution for you one piece at a time.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| shammi80 |
| Posted: Tue Feb 21, 2012 9:17 am Post subject: |
|
|
Apprentice
Joined: 17 Feb 2012
Posts: 32
|
Hi,
My question is :
1) I hae created the message set for all the records (Header Record,Batch Record etc)
2)I want the records to be seperated by new line ex:
1 record :PCEXT.DAT X
2 record :BATCH 14208HRIS 0 0 0 0
3 record: E 0003111-111-111 21FTMFR CR-AB120221 120221E 12022100 1 0
4 record : F1 1001001Kumar_Amit Noida
------------------------------------
etc-----------------------------
3)But I am getting only one record
1 record: PCEXT.DAT XBATCH 14208HRIS 0 0 0 0E 0003111-111-111 21FTMFR CR-AB120221 120221E 12022100 1 0 F1 1001001Kumar_Amit Noida
Please advice how I can split it . Do i need to change the message set ?? |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Feb 21, 2012 9:29 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| shammi80 wrote: |
| Please advice how I can split it . Do i need to change the message set ?? |
So you've not answered my question about how you'd arranged this <CR> to be at the end of each record in the message set. And your question is better phrased:
"How do I write them out as separate records?"
indicating you'd not arranged anything but were hopeful it would just happen.
You don't want advice, you want a solution. What you need is training. This is basic, basic broker.
I doubt changing the message set will help. Unless you've done something fairly dim. Which based on the output you're getting is fairly possible.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| shammi80 |
| Posted: Tue Feb 21, 2012 9:34 am Post subject: |
|
|
Apprentice
Joined: 17 Feb 2012
Posts: 32
|
| In the message set reserved character I have put <CR><LF>" |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Feb 21, 2012 9:38 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| shammi80 wrote: |
| In the message set reserved character I have put <CR><LF>" |
How, based on the description of the field in the InfoCenter, did you determine that was the right thing to do to achieve your intended outcome?
It's not.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| shammi80 |
| Posted: Tue Feb 21, 2012 9:50 am Post subject: |
|
|
Apprentice
Joined: 17 Feb 2012
Posts: 32
|
I have tried everything but did not find any clue.
If you give me idea then I will proceed further. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Feb 21, 2012 9:57 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| shammi80 wrote: |
| I have tried everything |
Post some of the "everything" you've tried to find and resolve the problem. Don't bother to describe any random changes to the message set in the hope of hitting the lucky combination or sequence dialing through the configuration settings for the same reason.
There's no point us suggesting something which has already failed to help. Especially as you've chosen to ignore one of my earlier suggestions.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| shammi80 |
| Posted: Tue Feb 21, 2012 10:29 am Post subject: |
|
|
Apprentice
Joined: 17 Feb 2012
Posts: 32
|
| If anyone hae idea to then please share |
|
| Back to top |
|
|
|
|
