The below insert command does not update my database. Can you tell me where the error is?
Code:
DESCRIBE TABLE names;
------------------------------------------------------------------------------
DESCRIBE TABLE names
DATA type COLUMN
COLUMN name schema DATA type name Length Scale Nulls
------------------------------- --------- ------------------- ---------- ----- ------
NAME SYSIBM CHARACTER 10 0 Yes
NUMBER SYSIBM CHARACTER 10 0 Yes
------------------------------ Commands Entered ------------------------------
INSERT INTO NAMES (name, number) VALUES (eeeeee, ed);
------------------------------------------------------------------------------
INSERT INTO NAMES (name, number) VALUES (eeeeee, ed)
DB21034E The command was processed AS an SQL statement because it was NOT a
valid Command Line Processor command. During SQL processing it returned:
SQL0206N "EEEEEE" IS NOT valid IN the context WHERE it IS used.
SQLSTATE=42703
Bookmarks