Hello,
I use db2 8.2.7 - and can't get the following SQL up to work:
$>db2 "select se.tag from ext.sesdr_server_ids se join adm.node no on se.tag
= no.tag where posstr (se.serial_number, no.name) 0"
SQL0132N A LIKE predicate or POSSTR scalar function is not valid because
the first operand is not a string expression or the second operand is not a
string. SQLSTATE=42824
Here are the appropriate table definitions:
$>db2 describe table ext.sesdr_server_ids
Column Type Type
name schema name Length Scale Nulls
-------------------------- --------- ------------------ -------- ----- ------
SERIAL_NUMBER SYSIBM CHARACTER 40 0 Yes
....
$>db2 describe table adm.node
Column Type Type
name schema name Length Scale Nulls
-------------------------- --------- ------------------ -------- ----- ------
NAME SYSIBM VARCHAR 192 0 Yes
....