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 Accessing first bit of PD value rajatbagga DFSORT/ICETOOL 11 Wed May 03, 2017 6:03 am
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
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


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