SAP Knowledge Base Article - Preview

2562245 - DB6: SQL0104N An unexpected token "DECFLOAT ROUNDING MODE ROUND_HALF_UP" was found following "SET CURRENT".

Symptom

You get the following error during upgrade of SAP system to NW740 SP8 or higher with Db2 V9.1 database.

4EETQ399 1 [/bas/749_R,12976]: Running with UTF-8 Unicode
4EETQ399 1 [/bas/749_R,13147]: Running with CLI driver.
4EETQ399 1 [/bas/749_R, 1961]: Connected to DB server type 'DB2/LINUXX8664'
4EETQ399 1 [/bas/749_R, 1997]: Connected to DB server version '09.01.0012'
4EETQ399 1 [/bas/749_R, 1675]: *** ERROR in ExecuteDirect[/bas/749_REL/src/dbs/db6/dbdb6.c, 6941] CON = 0 (BEGIN)
4EETQ399 1 [/bas/749_R, 1675]: &+     DbSlConnectDB6( SQLExecDirect ): [IBM][CLI Driver][DB2/LINUXX8664]
SQL0104N  An unexpected token "DECFLOAT ROUNDING MODE ROUND_HALF_UP" was found following "SET CURRENT ".  Expected tokens may include:  "<space>".

This could happen in either of the following upgrade phases.

  • PREP_INPUT_CHECK/SQLSELEXE_CHECK_CLIENT_SFW
  • PREP_INPUT_CHECK/READCVERS_DUMP

Read more...

Environment

  • SAP on IBM Db2 for Linux, UNIX, and Windows
  • Db2 V9.1

Keywords

SQL0104N, DECFLOAT ROUNDING MODE ROUND_HALF_UP, SET CURRENT, 9.1, PREP_INPUT_CHECK, SQLSELEXE_CHECK_CLIENT_SFW, READCVERS_DUMP, , KBA , BC-DB-DB6-UPG , Upgrade SAP System with DB2 Universal Database , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.