While updating the table in Aqua Data Studio 4.7 for a DB2 database, TechieDan faced an error which doesn’t allow him to proceed.
This was the SQL Script written.
ALTER TABLE “REF”.”CARD_BIN_SEGMENT”
ADD COLUMN “CARD_TYPE_CD” VARCHAR(3);
Then there was an error which shows this code.
DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: ;;_TYPE_CD” VARCHAR(3);END-OF-STATEMENT
Message: An unexpected token “” was found following “”. Expected tokens may include: “_TYPE_CD” VARCHAR(3)”
Looking through the web didn’t bring much help at all. Thus he looked upon as to what is wrong with the SQL syntax. Perhaps it was a typo or some escape key being typed on it.
It had been a headache for TechieDan but alas, the solution was found after much tinkering. It was actually in fact a simple solution. I just have to take out that annoying little semicolon.