| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| need ur inputs... please |
« View previous topic :: View next topic » |
| Author |
Message
|
| asr2002 |
 Posted: Thu Oct 10, 2002 8:09 am Post subject: need ur inputs... please |
 |
|
Novice
Joined: 09 Sep 2002
Posts: 13
|
Hello!!!
I'm trying to send a BLOB msg and then convert into MRM and do a insert in DB2 database...
MY MRM MSG SET: FNAME - STRING 10
TIME - TIMESTAMP
ID - INTEGER
My DB table FNAME CHARACTER 10, TIME TIMESTAMP, ID INTEGER
infact, i tried with both compute node and database node i'm unable to insert the record...
My doubt is in msg set i have not created any value to timestamp... if i'm right i guess if we input BLOB msg we need to know the exact length of the blow msg, so that we create a msg. set with that lengths... so in for datatypes TIMESTAMP and INTEGER how can we know the length in advance?how can we create a value to TIMESTAMP?Is it possible to give different datatypes in BLOB msg and insert a record in db? ..please correct me...
i'm able to insert if all my elements are string....
I appreciate your suggestions.... |
|
| Back to top |
|
 |
| maxis |
| Posted: Thu Oct 10, 2002 12:11 pm Post subject: |
|
|
Centurion
Joined: 25 Jun 2002
Posts: 144
|
asr2002
ref 56 of 168 of Working with Messages pdf - of MQSI
And also check the schema of data base where your inserting, make sure its format like yyddmmhhmmss or something like that. |
|
| Back to top |
|
|
| asr2002 |
| Posted: Thu Oct 10, 2002 2:49 pm Post subject: |
|
|
Novice
Joined: 09 Sep 2002
Posts: 13
|
| thanks, pvmk i have referred that docs, but still i'm unable to get more info... anyhow i will once again refer the docs... please let me know if you have any more information ie. convert bolb to mrm (datetime and integer data types)and insert in a DB2 database.. |
|
| 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
|
|
|
|
