A column in a HANA database have been NVARCHAR and we have expanded it to max but have no realized that we need to replace it with a TEXT (NCLOB) field.

I know that this isn't possible with a simple alter table, so i'm using the Add column, copy data, drop column, rename column pattern to do this.

In the second step though i run into problem. I get the infamous: SAP DBTech JDBC: [7]: feature not supported: cannot support non-constant types

Searching gave me this answer .

So i tried to do it like this:

UPDATE "DLN1" as "T1" SET "U_ITCO_OGPID_A" = ( SELECT TO_NCLOB("U_ITCO_OGPID") as "U_ITCO_OGPID_A" FROM "DLN1" as "T2" WHERE "T1"."DocEntry" = "T2"."DocEntry" AND "T1"."LineNum" = "T2"."LineNum" );

But it errors out with the same error message.

Is there something else that i can try?

Best Regards,

You can find column descriptions here: https://pastebin.com/MpM7axT2

Both have IS_NULLABLE as True, could this be a problem with the TO_NCLOB function?

I have tried with Coalesce to get past this also, but it continues to give me: SAP DBTech JDBC: [7]: feature not supported: cannot support non-constant expression: __typecast__

Thanks for your help!

//Leif