IBM Support

DB2 client V10.5 FP4 calling Sotred procedure to server type "LINUX64PPCLE" may fail with syntax error.

Technical Blog Post


Abstract

DB2 client V10.5 FP4 calling Sotred procedure to server type "LINUX64PPCLE" may fail with syntax error.

Body

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.

E.g.
>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>".
SQLSTATE=42601

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
this behaviour.

As Support is introduced for server type "LINUX64PPCLE"  upgrade to V10.5 FP5 or above
to avoid this issue.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

UID

ibm13285981