database - How to load Indexes to Teradata Server using BTEQ -

i'm trying load table has unique index teradata server using bteq utility. , following error: failure 3706 syntax error: expecting between word 'id' , 'asc' keyword. seems bteq doesn't accept 'asc' , 'desc' keywords. syntax valid, , if run in teradata studio works, index created.

create unique index idx_unique_test_index

(id asc) on test_index;

could please me find solution. appreciated.

as there's no asc or desc in teradata index teradata studio removes before running query :-)

you might check dbql what's submitted.