Alter Table in Aqua Data Studio 4.7

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.

HeadAche Using SQL

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.

PROBLEM SOLVED!

One Response

  1. danielctw January 11, 2011

Leave a Reply to danielctw Cancel reply