ALter the datatype of a Table type

[sreelatha_reddy2]

Hi All,

I am trying to alter the length and datatype in a Table type but I am getting errors. Am I wrong somewhere I have used the same syntax which I use for table alteration. Please help.

alter "Sales-Product"."TT-Sales" alter (SALES_AMOUNT DOUBLE,NET_AMOUNT DOUBLE,

             SUB_REGION_NAME VARCHAR(100) , REGION_NAME VARCHAR(100))

Error: SAP DBTech JDBC: [257] (at 7): sql syntax error: incorrect syntax near "Sales-Product": line 1 col 7 (at pos 7)

[SaiKrishna_V · Accepted solution]

Hi ,

please use below syntax:

alter table "Sales-Product"."TT-Sales"(

SALES_AMOUNT DOUBLE,NET_AMOUNT DOUBLE,

             SUB_REGION_NAME VARCHAR(100) , REGION_NAME VARCHAR(100))

Regards,

sai Krishna.

[sreelatha_reddy2 · Accepted solution]

THank you .

Actually It was a type

[SaiKrishna_V · Accepted solution]

HI,

If question is answered. please close it.

I will be helpful for others.

Regards,

sai Krishna.