| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Updating DB2 database table that have BLOBS |
« View previous topic :: View next topic » |
| Author |
Message
|
| neo_revolution |
 Posted: Mon Jan 12, 2004 7:02 pm Post subject: Updating DB2 database table that have BLOBS |
 |
|
Voyager
Joined: 21 Oct 2003
Posts: 80
Location: NJ
|
Hi,
I am getting input message as XML format and depending upon a field condition I need to update, delete or read databse.
One of the fields have BOLB data type. I wish to know how can I get "unique rowid" and "unique id" that the DB2 generates.
Thanks in advance. |
|
| Back to top |
|
 |
| neo_revolution |
| Posted: Tue Jan 13, 2004 5:56 am Post subject: DB2 ROWID |
|
|
Voyager
Joined: 21 Oct 2003
Posts: 80
Location: NJ
|
Hi,
I myself got confused...
I wish to know, anyone have an idea about DB2 ROWID. Will they be automatically created? How can I access them? Are they unique?
Thanks |
|
| Back to top |
|
|
| dhincali |
| Posted: Tue Jan 13, 2004 9:39 am Post subject: |
|
|
Novice
Joined: 29 Dec 2003
Posts: 22
|
Hi neo,
Regarding to ROWID, DB2 always automatically generates a sequentially incremented number and assigns that to the column when data is inserted to the table. The rows are not necessarily stored contiguously on disk but is is actually stored in the rows of the DB2 table.
Regarding a Unique ID generation, a unique RowID or an ID for every update,delete or insert based on the field condition in XML input format can be created. You can use this code snippet and incorporate it.
SET Environment.SEQ[] = PASSTHRU('select nextval for xxx.vseq from sysibm.sysdummy1');
where 'xxx' is schema name and 'vseq' is a stored procedure name.
'nextval' gives the next available number.
_________________
learning traveller |
|
| Back to top |
|
|
| neo_revolution |
| Posted: Tue Jan 13, 2004 9:46 am Post subject: Updating DB2 database table that have BLOBS |
|
|
Voyager
Joined: 21 Oct 2003
Posts: 80
Location: NJ
|
Thanks for the reply ...
I did some research regarding ROWID... Rightnow its supported on Z os. |
|
| 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
|
|
|
|
