Symptom
SUM shows below error while running during an Upgrade.
DB6REGIS.LOG:
==========
1 ETQ000 ==================================================
1 ETQ399 Executing SQL script '../var/DB6REGIS.TQL'.
2 ETQ399 Connecting to database 'db6'.
4 ETQ393 START DB6REGIS
4 ETQ010 Date & Time: *****************
3 ETQ398 SQL: SELECT distinct REG_VAR_NAME NAME, REG_VAR_VALUE VALUE, AGGREGATE_NAME AGGNAME
3 ETQ398XSQL: FROM TABLE(REG_LIST_VARIABLES()) WITH UR
4 ETQ010 Date & Time: *****************
1EETQ008 Error message: DBSL error 99 (db code -104):
1EETQ009XSQL0104N An unexpected token "UR" was found following "T_VARIABLES()) WITH".
1EETQ009XExpected tokens may include: "END-OF-STATEMENT". SQLSTATE=42601
1EETQ003 exit code: "20"
4 ETQ399 Rollback.
Read more...
Environment
DB2 LUW (Linux,Unix and Windows), DB6 Database versions 9.1 and 9.5.
Product
Keywords
DB6REGIS.TQL, REG_LIST_VARIABLES, END-OF-STATEMENT, CHK_DB6_REG_PRE , PREP_INIT, SUM, UPGRADE , KBA , 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.