Use PowerDesigner to design the database table, put the SQL statement generated by it into DB2 for execution, and report an error: an invalid symbol was encountered in the 104 42601 SQL statement
Some SQL statements are as follows:
create table user
(
UserId int the not null,
The username varchar null,
Hobby varchar null,
Constraint PK_USER primary key clustered (userId)
);
Upon verification, it was found that the above SQL statement set the field to NULL, which cannot be written in DB2.
Some SQL statements are as follows:
create table user
(
UserId int the not null,
The username varchar null,
Hobby varchar null,
Constraint PK_USER primary key clustered (userId)
);
Upon verification, it was found that the above SQL statement set the field to NULL, which cannot be written in DB2.
Read More:
- DB2 encountered the problem of sqlcode = 911 lock table when updating record update
- DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=;;,?,?,?,?,?,?,?,?);END-OF-STATEMENT
- In the SQL query statement, add the column that does not exist in the table and set the fixed value of the column
- SQL exception handling – MySQL error 1005 (HY000): can’t create table ‘TMP’ (errno: 13)
- About error 1005 (HY000) in MySQL: can’t create table ‘_______ ‘(errno: 150) fool’s plan
- BarTender operation encountered the problem of “OLE DB encountered error 0x80004005”
- An error occurred when opensips started the service“ ERROR:core :db_ check_ table_ Version: invalid version 7 for Table dialog found “
- DB2 SQL ERROR: SQLCODE=-803, SQLSTATE=23505, SQL
- MySQL error: can’t create table ‘..’（ errno:150 ）Solutions
- SAP SQL error “SQL code: -10692“ occurred while accessing table “ZTXXXX“.
- DB2, create stored procedure error, sqlcode = – 104, sqlstate = 42601, PSM_ semicolon
- DB2 table annotation pull
- DB2 SQL error: sqlcode = – 803, sqlstate = 23505, sqlerrmc = 2 [solution]
- Django. DB. Utils. Programmingerror: (1146, “table * doesn’t exist”) causes and Solutions
- SQL Error (3621): String or binary data would be truncated The statement has been terminated. */
- DB: the solution of table already exist when migrating
- A case diagnosis and solution of DB2 error code 1639 and SQL state 08001 is described in detail
- DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703
- A series of errors encountered in connecting to the database using Oracle SQL developer
- Invalid bound statement (not found) of custom SQL in mybatisplus