I have a issue with DB2.
I have two libraries with the same structure database. The only one difference is the data.
When i try this sql request for the first library, it’s work
SELECT * FROM Z24FR.CLIENT, Z24FR.EMPLOYE WHERE CLIENT.CLINUM = EMPLOYE.CLINUM
but when i try with the other library, i have this error.
SELECT * FROM Z24UK.CLIENT, Z24UK.EMPLOYE WHERE CLIENT.CLINUM = EMPLOYE.CLINUM
Column or global variable CLINUM not found. CLINUM was not found as a column of table *N in *N and was not found as a global variable in *N. If the table is *N, CLINUM is not a column of any table or view that can be referenced.
I check the CLIENT and EMPLOYE tables and they have the column with data.
Thank you in advance for your answer
Advertisement
Answer
The way you qualify columns depends on the way tables are “declared”
So if you want something common you can code
SELECT * FROM Z24xx.CLIENT CLIENT, Z24xx.EMPLOYE EMPLOYE WHERE CLIENT.CLINUM = EMPLOYE.CLINUM
Or because comma notation is old and not really readable
SELECT * FROM Z24xx.CLIENT CLIENT inner join Z24xx.EMPLOYE EMPLOYE on CLIENT.CLINUM = EMPLOYE.CLINUM