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 Usergroups 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 IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm


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