What's the Abend when accessing a table which is deleted

sudhee_rb · New User Joined: 29 Mar 2006 Posts: 34

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

guptae · Posted: Mon Sep 11, 2006 10:21 am

I believe it should abend at compilation time only.

twissi · Posted: Mon Sep 11, 2006 10:42 am

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.

guptae · Posted: Mon Sep 11, 2006 11:18 am

Ya twissi is right it will give u error at run time.

ankitsaxena17 · New User Joined: 22 Feb 2006 Posts: 2 Location: Pune

It will abend during bind because during bind it will perform the checking for the table.