Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
What's the Abend when accessing a table which is deleted

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sudhee_rb

New User


Joined: 29 Mar 2006
Posts: 34

PostPosted: Sun Sep 10, 2006 5:29 pm    Post subject: What's the Abend when accessing a table which is deleted
Reply with quote

Hi this is sudheer

please any body clarify my doubt?

1)we are inclded a table in progra that was physically deleted.

when the program abends while at compile time or runtime?why?

Thanks in advance


Sudheer
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Mon Sep 11, 2006 10:21 am    Post subject:
Reply with quote

I believe it should abend at compilation time only.
Back to top
View user's profile Send private message
twissi

Active User


Joined: 01 Aug 2005
Posts: 105
Location: Somerset, NJ

PostPosted: Mon Sep 11, 2006 10:42 am    Post subject:
Reply with quote

Sudheer,

Your program will abend at run time!

The pre-compiler only checks the field name (basically to figure out any typo), if you've included the table structure (DCLGEN) in the program.
Otherwise, pre-compiler just replaces the SQL statements with the host language call statements.

At the run time, when the SQL statement you mentioned is executed, I guess, you'll get a -204 (not too sure about this).

Cheers, Twissi.
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Mon Sep 11, 2006 11:18 am    Post subject:
Reply with quote

Ya twissi is right it will give u error at run time.
Back to top
View user's profile Send private message
ankitsaxena17

New User


Joined: 22 Feb 2006
Posts: 2
Location: Pune

PostPosted: Thu Oct 05, 2006 3:30 pm    Post subject:
Reply with quote

It will abend during bind because during bind it will perform the checking for the table.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Insert a Row_number into table useit DB2 1 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
No new posts PC (UTF-8) -> z/OS (EBCDIC) -> ... prino All Other Mainframe Topics 4 Fri Sep 01, 2017 1:47 am
No new posts Adding a userid to SMTP Security table Yolanda Harvey JCL & VSAM 1 Sun Aug 13, 2017 6:16 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm

Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us