SAP Knowledge Base Article - Preview

3233084 - SAP DBTech JDBC: [336]: invalid default value: default function cannot be created on column of data type NVARCHAR: CURRENT_TIMESTAMP

Symptom

There are some SQL scripts not working any more after HANA upgrade.

Could not execute 'CREATE TABLE T11(A NVARCHAR(40) DEFAULT CURRENT_TIMESTAMP)'
SAP DBTech JDBC: [336]: invalid default value: default function cannot be created on column of data type NVARCHAR: CURRENT_TIMESTAMP


Read more...

Environment

  • HANA database 2.0 SPS 05 and higher

Product

SAP HANA, platform edition 2.0

Keywords

invalid default value, NVARCHAR, CURRENT_TIMESTAMP, TIMESTAMP , KBA , HAN-DB-SCR , SAP HANA SQL Script , HAN-DB , SAP HANA Database , 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.