Technical Blog Post
DB2 client V10.5 FP4 calling Sotred procedure to server type "LINUX64PPCLE" may fail with syntax error.
User may receive syntax error when calling a stored procedure from a db2 10.5 fp4 and
below client on Windows to DB2 11.1 server on linux PPCLE.
>db2 connect to DBNAME
Database Connection Information
Database server = DB2/LINUXPPC64LE 11.1.1
Local database alias = DBNAME
<C:\DB2 Client\IBM\SQLLIB\BIN>db2 ' call procedure_Name(?)'
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "' call procedure_Name(?)'" was found following
"BEGIN-OF-STATEMENT". Expected tokens may include: "<values>".
When executing the procedure on the server, the following works fine:
db2 ' call procedure_Name(?)'
This is caused by DB2 clients fixpack level support to the server type "LINUX64PPCLE"
In DB2 v10.5 FP4 and below the server type "LINUX64PPCLE" is missing,
support was added in 10.5 FP5
As support was missing in v10.5 FP4 and below we entered into incorrect handling and return
As Support is introduced for server type "LINUX64PPCLE" upgrade to V10.5 FP5 or above
to avoid this issue.