| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| I prepared ESQL in compute node for insert data into DB2 |
« View previous topic :: View next topic » |
| Author |
Message
|
| raghug |
 Posted: Tue Oct 17, 2006 4:40 pm Post subject: I prepared ESQL in compute node for insert data into DB2 |
 |
|
Acolyte
Joined: 19 Jul 2006
Posts: 60
Location: NJ
|
I prepared ESQL for insert data into DATA base (DB2) like below
1)
DECLARE PRO_NUM CHARACTER;
DECLARE LE_NUM INTEGER;
DECLARE MVE_NUM INTEGER;
so .....on..............60 fields
2)
SET PRO_NUM = InputRoot.MRM.WTRK_TRAN.WTRK_HDR.STATUS_UPD_REC.PRONUM;
SET LE_NUM = InputRoot.MRM.WTRK_TRAN.WTRK_HDR.STATUS_UPD_REC.NENUM;
SET MOVE_NUM = InputRoot.MRM.WTRK_TRAN.TTTRK_HDR.STATUS_UPD_REC.MNO;
so...on...............60 fields
3)
INSERT INTO Database.{DBSource}.{DBSchema}.{DBTTTRKTable}
(NUM, NENUM, MNO so on....)
4)
VALUES(InputRoot.MRM.TTTRK_TRAN.TRK_HDR.STATUS_UPD_REC.NUM,
InputRoot.MRM.TRK_TRAN.TTTRK_HDR.STATUS_UPD_REC.NENUM,
InputRoot.MRM.WTRK_TRAN.WTRK_HDR.STATUS_UPD_REC.MNO, so on.....
But after this code the date will not insert into Data Base what I need code ... give me exmpl atlest two lines |
|
| Back to top |
|
 |
| bindu |
| Posted: Tue Oct 17, 2006 8:57 pm Post subject: |
|
|
Voyager
Joined: 07 May 2004
Posts: 97
|
DECLARE TIMEOF_UPDATE DATETIME;
then it will insert into database |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Tue Oct 17, 2006 9:24 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi bindu,
| bindu wrote: |
DECLARE TIMEOF_UPDATE DATETIME;
then it will insert into database |
Where in the code, did you figure that out from ?
Regards. |
|
| Back to top |
|
|
| bindu |
| Posted: Tue Oct 17, 2006 10:12 pm Post subject: |
|
|
Voyager
Joined: 07 May 2004
Posts: 97
|
Hi,
i got Variable declaration so based on that i suggested to declare all Date variables like DATETIME instead of char.
Thank you,
Bindu |
|
| 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
|
|
|
|
