| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| HI ALL PLZ GIVE ME ESQL UPDATE Statement |
« View previous topic :: View next topic » |
| Author |
Message
|
| raghug |
 Posted: Tue Oct 31, 2006 12:21 pm Post subject: HI ALL PLZ GIVE ME ESQL UPDATE Statement |
 |
|
Acolyte
Joined: 19 Jul 2006
Posts: 60
Location: NJ
|
HI ALL PLZ GIVE ME ESQL UPDATE Statement I Enclosed my table and My Insert statement plz give me update statement for if record is not in Database insert into DB ,If record is in DataBase Update the Record ..PLZ give Me detail Answer for this ....
THIS IS MYTABLE pronum (col) is Primary Key
CREATE TABLE BBTRK (
NUM CHAR(9) NOT NULL, (PRIMARY KEY)
LINENUM CHAR(3) NOT NULL,
MOVENO CHAR(2) NOT NULL,
UPDATE_TIME TIMESTAMP,
so on......)
2) MY Insert Statement
INSERT INTO Database.{DBSource}.{DBSchema}.{DBTable}(NUM, LINENUM, MOVENO, UPDATE_TIME, NOTIFY1_TYPE, soon.......................); |
|
| Back to top |
|
 |
| madi |
| Posted: Tue Oct 31, 2006 12:24 pm Post subject: |
|
|
Chevalier
Joined: 17 Jan 2006
Posts: 475
|
|
| Back to top |
|
|
| jeevan |
| Posted: Tue Oct 31, 2006 12:26 pm Post subject: |
|
|
Grand Master
Joined: 12 Nov 2005
Posts: 1432
|
UPDATE database
SET field = value
SET field = value
SET field = value
.
.
.
optional (
WHERE field= "value "
AND field = "value"
) |
|
| 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
|
|
|
|
