IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

When non-existing recode updated, will it be created


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Lord.of.Wind

New User


Joined: 17 Nov 2005
Posts: 60

PostPosted: Wed May 31, 2006 1:52 pm
Reply with quote

A non-existing recode, when it is updated, will it be created ?
Back to top
View user's profile Send private message
rajandhla

Active User


Joined: 18 Oct 2005
Posts: 182
Location: Luton UK

PostPosted: Wed May 31, 2006 2:11 pm
Reply with quote

According to your query ,

you want to update a record using where condition..........

if the record not exist the record won't be created when you update......


correct me if iam wrong.......

regards
jai
Back to top
View user's profile Send private message
Lord.of.Wind

New User


Joined: 17 Nov 2005
Posts: 60

PostPosted: Wed May 31, 2006 2:27 pm
Reply with quote

THANK YOU.
Back to top
View user's profile Send private message
parikshit123

Active User


Joined: 01 Jul 2005
Posts: 269
Location: India

PostPosted: Thu Jun 01, 2006 2:25 pm
Reply with quote

Hi,
I think, if you try to update a record which is not existing, it will give you SQLCODE of -806

You might like to insert a record in that case.

Thanks,
Parikshit
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Adding first / last acct numerber to ... DFSORT/ICETOOL 7
No new posts I want to append a record in an exist... CLIST & REXX 17
No new posts Read file names from existing file th... DFSORT/ICETOOL 6
No new posts How to read unpacked field created in... DFSORT/ICETOOL 12
No new posts Add column to existing records using ... JCL & VSAM 2
Search our Forums:

Back to Top