|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
May 14th, 2007, 08:06 PM
|
|||
|
|||
|
What was the last row inserted
If you dont have a timestamp in a table how can you tell where the last row was inserted? Is there a hidden rowid? or numid?
I can use? I need to find out where rows are being inserted. Append 'NO' is set in sysibm.systables so I know there not being appended like a programmer said they are.
|
|
#2
May 14th, 2007, 09:11 PM
|
|||
|
|||
|
Does the table have a column with a charactoristic of being an identity value? Look at the table definition or DDL using whatever tools you have
to see if this is the case. If so, search on the use of the identity_val_local function. fv Quote:
__________________
...because that is the way we have always done it. We've been doing it like that for 80 Years! (How do we change that mindset?)
|
|
| Viewing: Dev Shed Forums > Databases > DB2 Development > What was the last row inserted |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
