SAP Knowledge Base Article - Preview

2218188 - Invalid DEFAULT value near sequence.currval SQLCODE=-1709

Symptom

Creating a table with a column which includes a default with SEQUENCE.currval will create an error e.g:
Invalid DEFAULT value near '(seq_example.currval)' on line 3
SQLCODE=-1709, ODBC 3 State="42000"


Read more...

Environment

SAP SQL Anywhere - all versions on all supported platforms.

Product

SAP SQL Anywhere all versions

Keywords

KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , 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.