|
View previous topic :: View next topic
|
| Author |
Message |
arunpvarier
New User
Joined: 07 Nov 2006
Posts: 16
Location: banglore
|
|
|
|
SLECT C1,C2,C3,C4 FROM EMPLOYEE > But wht will happen when when C4 is not present in the EMPLOYEE table
thanks |
|
| Back to top |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hi Arun,
It will give u following message.
| Code: |
SQLCODE = -206, ERROR: C4 IS NOT A COLUMN OF AN INSERTED
TABLE, UPDATED TABLE, OR ANY TABLE IDENTIFIED IN A FROM CLAUSE, OR IS
NOT A COLUMN OF THE TRIGGERING TABLE OF A TRIGGER |
|
|
| Back to top |
|
|
Sreedhar.P
New User
Joined: 08 Dec 2006
Posts: 2
Location: bangalore
|
|
|
|
When u run the query in QMF u will get the following message.
QUERY MESSAGES:
Column IHSIMID is not in any table named in the query.
Thanks
Sreedhar |
|
| Back to top |
|
|
ravi17s
Warnings : 1
New User
Joined: 15 Aug 2003
Posts: 57
|
|
|
|
Adding Batch execution .......
Compilation Error: Host variable not found (if you include the DCLGEN generated by DB2 in the program)
IF not at BIND time -206, ERROR: C4 IS NOT A COLUMN OF AN INSERTED ....as stated by Arun
Thx,
Ravi |
|
| Back to top |
|
|
|
|
