Search code examples
sqlteradata

ERROR [HY000] [Teradata][ODBC] (10001) General error: invalid vector subscript ALTER Command Failed

While trying to add a column in Teradata with the following query

ALTER TABLE DB121.CUSTOMER_OPTION ADD (OPTION_CODE VARCHAR(4000) CHARACTER SET LATIN NOT CASESPECIFIC)

I get the following error

"ERROR [HY000] [Teradata][ODBC] (10001) General error: invalid vector subscript ALTER Command Failed."

I am using TTU 17.xx ODBC drivers

I have tried ADD COLUMN and column_name with and without parentheses. Not sure what I am doing wrong...

Solution

  • Nevermind, there was a connectivity issue in the backend. Sorry for the trouble. I closed the application (Nexus) and came back after half an hour or so and tried again and it was working. Not sure if it was application issue or VPN or my network.