TYPO ERROR OF TABLE NAME

Johore · Specialist Joined: 12 Sep 2003 Posts: 19

Hello,

When an SQL query is written in a program with a typo error of the table name , when can we know the error.

Is it while compilation or while executing the program. Can we see the message in the JCL output.

Thanks in advance,
johore

mmwife · Super Moderator Joined: 30 May 2003 Posts: 1592

Hi johore,

If I'm not mistaken, the DB2 preprocessor should detect the error. If not then, the compiler should pick it up.

Regards, Jack.

Johore · Specialist Joined: 12 Sep 2003 Posts: 19

Hi MMWIFE,

Yes ur right , I also checked the same.
The error appears when the BIND process is done . The system searched for the TABLE and the user access details. It gives the error at this point.

Thanks again.
johore