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.
The error has also been encountered during a a system export using the SWPM as the system copy option.

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>".

 The error can happen in any of the following upgrade phases or system copy task.

  • PREP_INPUT_CHECK/SQLSELEXE_CHECK_CLIENT_SFW
  • PREP_INPUT_CHECK/READCVERS_DUMP
  • With System copy, the error occurs with R3load export


Read more...

Environment

  • SAP on IBM Db2 for Linux, UNIX, and Windows
  • Db2 10.1 or lower version

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 , 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 for Me (Login required).

Search for additional results

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