|
View previous topic :: View next topic
|
| Author |
Message |
CICS fan
New User
Joined: 03 Apr 2008
Posts: 82
Location: United States
|
|
|
|
Hi All,
We are using DB2 V9.1 and trying to use RID function by using a select query like this
| Code: |
SELECT RID(TABLE1) FROM TABLE1
WHERE COL1 = '1234567'; |
However we are getting this response:
| Code: |
SQLCODE = -206, ERROR: TABLE1 IS NOT VALID IN THE CONTEXT WHERE
IT IS USED |
We are aware that RID can be used in this version, but unsure where we are getting it wrong. Any ideas? |
|
| Back to top |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
| Back to top |
|
|
T-Rex
New User
.jpg)
Joined: 26 Oct 2007
Posts: 1
Location: Bonn
|
|
|
|
I tried the Sample from the SQL Reference:
SELECT RID(DSN8910.EMP), LASTNAME
FROM DSN8910.EMP
WHERE EMPNO = '000020';
This works. |
|
| Back to top |
|
|
|
|
