| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Upload the data from file into oracle using MQSI |
« View previous topic :: View next topic » |
| Author |
Message
|
| navpav |
 Posted: Tue Apr 01, 2003 10:54 pm Post subject: Upload the data from file into oracle using MQSI |
 |
|
Novice
Joined: 01 Apr 2003
Posts: 12
|
We are working on MQSI V2.0.2 version.
As per our requirement we have to upload the data from the flat file to oracle database.
Here is the step by step procedure what we have followed.
Step1: Created Message Set= MsgSet
Step2: Created Element Names= CODE STRING,DESC STRING
Step3: Created Elements Length= 10,100
Step4: Created Types= CMT (Compound Type)
Step5: Created Message= Msg_Test
Step6: Noted the Identifier in the message set "DQQ3UHC074001"
Step7: Ceated Message flow using MQInput node and DataInsert node.
Step8: For MQInput node selected the default option and given
Domain = MRM
Message Set = DQQ3UHC074001
Message Type = Msg_Test
Message Format=CWF
Step9: In DataInsert node Using Input ADD button we have given values for Message Set and MRM.
Step10: In DataInsert node Using Output ADD button we have given values for the database Name,table name and we have mapped the elements with the columns of the table.
Step11: We have created oracle driver and established a ODBC connection also.
Step12: We have excuted the following command
c:> amqsput TESTQ MQSIV2 < abc.txt
But the data is going to failure queue.
As per our project requirement we have to upload the data into the oracle database.
So could you please send an example which will upload the data from flat file to Oracle database. Please send step by step procedure.
Regards, |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Apr 02, 2003 6:27 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
The procedure you listed should be fine.
Are you catching an errors when the message goes to the failure queue? Can you post those? Is there anything in your system log? |
|
| Back to top |
|
|
| navpav |
| Posted: Wed Apr 02, 2003 8:31 pm Post subject: example |
|
|
Novice
Joined: 01 Apr 2003
Posts: 12
|
| Anyone can please send an exercise to upload the data from flat file to Oracle using MQSI.......(we want step by step procedure so that the same exercise we can replicate over here.....This is very urgent.) |
|
| Back to top |
|
|
| navpav |
| Posted: Wed Apr 02, 2003 9:44 pm Post subject: help |
|
|
Novice
Joined: 01 Apr 2003
Posts: 12
|
rtderror file shows:
RTD Extractor Trace File
========================
Extracting Project Info
Extracting Field
Extracting Structures
Extracting Messages
Extracting Transactions
Extracting Tags
Extracting CStruct Element Info
Extracting Valid Values
Cross Referencing Valid Values
Indexing Valid Values
Cross Referencing Tags
Indexing Transaction Paths
Indexing Structures
Indexing Messages
Indexing Message Paths
Indexing Structures Paths
Indexing Transactions
RTD Info has been extracted
Building Bitstream..
Building Project Info
Building Tags
Building Fields
Building Structures
Building Messages
Building Transactions
Building Valid Values
Building Path Based Info
Building Tag Paths
Building CStructInfo
Building Tag Cross Referencing
Building cStruct Element Info
Building Structure Indexing
Building Message Indexing
Building Transaction Indexing
RTD Bitstream has been built and saved to file
RTD Identification is: DQQ3UHC07C001
Extraction Complete
===================
cwferror file shows:
********************************************************
* Message Translation Interface : MTI 3.00 *
* Standard Message Dictionary: SMD/GOLD 98 R02 M06 *
********************************************************
Message Body:
1 SelfDefiningStructure (Id: [1])
1.1 SelfDefiningField (Id: [101], Type [CStringType])
1.1.1 SelfDefiningField (Id: [101], Len: [3], Val: [CWF])
1.2 SelfDefiningField (Id: [102], Type [CStringType])
1.2.1 SelfDefiningField (Id: [102], Len: [13], Val: [DQQ3UHC07C001])
1.3 SelfDefiningField (Id: [104], Type [CStringType])
1.3.1 SelfDefiningField (Id: [104], Len: [0], Val: [])
1.4 SelfDefiningField (Id: [105], Type [CStringType])
1.4.1 SelfDefiningField (Id: [105], Len: [1], Val: [I])
1.5 SelfDefiningField (Id: [106], Type [LongType])
1.5.1 SelfDefiningField (Id: [106], Len: [4], Val: [1252])
1.6 SelfDefiningField (Id: [107], Type [CStringType])
1.6.1 SelfDefiningField (Id: [107], Len: [1], Val: [L])
1.7 SelfDefiningField (Id: [108], Type [BinaryType], Format: [0], ContextLen: [1], Context: [T])
1.7.1 SelfDefiningField (Id: [108], Len: [4], Val: [])
1.8 SelfDefiningField (Id: [109], Type [BinaryType], Format: [0], ContextLen: [1], Context: [F])
1.8.1 SelfDefiningField (Id: [109], Len: [4], Val: [])
1.9 SelfDefiningField (Id: [110], Type [CStringType])
1.9.1 SelfDefiningField (Id: [110], Len: [0], Val: [])
1.10 SelfDefiningField (Id: [111], Type [CStringType])
1.10.1 SelfDefiningField (Id: [111], Len: [0], Val: [])
1.11 SelfDefiningField (Id: [112], Type [CStringType])
1.11.1 SelfDefiningField (Id: [112], Len: [0], Val: [])
1.12 SelfDefiningField (Id: [113], Type [CStringType])
1.12.1 SelfDefiningField (Id: [113], Len: [0], Val: [])
1.13 SelfDefiningField (Id: [114], Type [CStringType])
1.13.1 SelfDefiningField (Id: [114], Len: [5], Val: [TEST1])
1.14 SelfDefiningField (Id: [115], Type [ShortType])
1.14.1 SelfDefiningField (Id: [115], Len: [4], Val: [1])
1.15 SelfDefiningField (Id: [116], Type [CStringType])
1.15.1 SelfDefiningField (Id: [116], Len: [1], Val: [L])
2 SelfDefiningStructure (Id: [2])
2.1 SelfDefiningField (Id: [3], Type [LongType])
2.1.1 SelfDefiningField (Id: [3], Len: [4], Val: [100005])
2.2 SelfDefiningStructure (Id: [4])
2.2.1 SelfDefiningField (Id: [401], Type [LongType], Occurs: [2])
2.2.1.1 SelfDefiningField (Id: [401], Len: [4], Val: [1], Occur: [1/2])
2.2.1.2 SelfDefiningField (Id: [401], Len: [4], Val: [2], Occur: [2/2])
2.2.2 SelfDefiningField (Id: [402], Type [LongType], Occurs: [2])
2.2.2.1 SelfDefiningField (Id: [402], Len: [4], Val: [100002], Occur: [1/2])
2.2.2.2 SelfDefiningField (Id: [402], Len: [4], Val: [100000], Occur: [2/2])
2.2.3 SelfDefiningField (Id: [403], Type [LongType], Occurs: [2])
2.2.3.1 SelfDefiningField (Id: [403], Len: [4], Val: [8], Occur: [1/2])
2.2.3.2 SelfDefiningField (Id: [403], Len: [4], Val: [1], Occur: [2/2])
2.2.4 SelfDefiningField (Id: [404], Type [LongType], Occurs: [2])
2.2.4.1 SelfDefiningField (Id: [404], Len: [4], Val: [2], Occur: [1/2])
2.2.4.2 SelfDefiningField (Id: [404], Len: [4], Val: [4], Occur: [2/2])
2.2.5 SelfDefiningField (Id: [405], Type [LongType], Occurs: [2])
2.2.5.1 SelfDefiningField (Id: [405], Len: [4], Val: [0], Occur: [1/2])
2.2.5.2 SelfDefiningField (Id: [405], Len: [4], Val: [0], Occur: [2/2])
2.2.6 SelfDefiningField (Id: [406], Type [LongType], Occurs: [2])
2.2.6.1 SelfDefiningField (Id: [406], Len: [4], Val: [10], Occur: [1/2])
2.2.6.2 SelfDefiningField (Id: [406], Len: [4], Val: [4], Occur: [2/2])
2.2.7 SelfDefiningField (Id: [407], Type [LongType], Occurs: [2])
2.2.7.1 SelfDefiningField (Id: [407], Len: [4], Val: [0], Occur: [1/2])
2.2.7.2 SelfDefiningField (Id: [407], Len: [4], Val: [0], Occur: [2/2])
2.2.8 SelfDefiningField (Id: [408], Type [LongType], Occurs: [2])
2.2.8.1 SelfDefiningField (Id: [408], Len: [4], Val: [0], Occur: [1/2])
2.2.8.2 SelfDefiningField (Id: [408], Len: [4], Val: [0], Occur: [2/2])
2.2.9 SelfDefiningField (Id: [409], Type [LongType], Occurs: [2])
2.2.9.1 SelfDefiningField (Id: [409], Len: [4], Val: [0], Occur: [1/2])
2.2.9.2 SelfDefiningField (Id: [409], Len: [4], Val: [0], Occur: [2/2])
2.2.10 SelfDefiningField (Id: [410], Type [CStringType], Occurs: [2])
2.2.10.1 SelfDefiningField (Id: [410], Len: [1], Val: [L], Occur: [1/2])
2.2.10.2 SelfDefiningField (Id: [410], Len: [1], Val: [N], Occur: [2/2])
2.2.11 SelfDefiningField (Id: [411], Type [CStringType], Occurs: [2])
2.2.11.1 SelfDefiningField (Id: [411], Len: [1], Val: [], Occur: [1/2])
2.2.11.2 SelfDefiningField (Id: [411], Len: [1], Val: [ ], Occur: [2/2])
2.2.12 SelfDefiningField (Id: [412], Type [LongType], Occurs: [2])
2.2.12.1 SelfDefiningField (Id: [412], Len: [4], Val: [1], Occur: [1/2])
2.2.12.2 SelfDefiningField (Id: [412], Len: [4], Val: [1], Occur: [2/2])
2.2.13 SelfDefiningField (Id: [413], Type [CStringType], Occurs: [2])
2.2.13.1 SelfDefiningField (Id: [413], Len: [0], Val: [], Occur: [1/2])
2.2.13.2 SelfDefiningField (Id: [413], Len: [0], Val: [], Occur: [2/2])
2.2.14 SelfDefiningField (Id: [414], Type [LongType], Occurs: [2])
2.2.14.1 SelfDefiningField (Id: [414], Len: [4], Val: [0], Occur: [1/2])
2.2.14.2 SelfDefiningField (Id: [414], Len: [4], Val: [0], Occur: [2/2])
3 SelfDefiningField (Id: [5], Type [LongType])
3.1 SelfDefiningField (Id: [5], Len: [4], Val: [2]) |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
