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:
- 1822 – Failed to add the foreign key constraint. Missing index for constraint ‘tb_emp_ibfk_1’ in the
- javax.persistence.EntityNotFoundException : unable to find error
- MySQL creates tables and sets auto increment of primary keys
- Modification method of starting value of MySQL auto increment ID
- MySQL error: can’t create table ‘..’( errno:150 )Solutions
- About error 1005 (HY000) in MySQL: can’t create table ‘_______ ‘(errno: 150) fool’s plan
- MySQL partitions the existing tables of the data table
- Failed to add the foreign key constraint. Missing index for constraint ‘stu_ibfk_1’ in the reference
- ERROR 1406 (22001): Data Too Long, field len 30, data len 48
- django.db.utils .IntegrityError: NOT NULL constraint failed: blog_ blog.author_ ID error resolution
- How to make the import complete smoothly!
- ORA-00907:missing right parenthesis
- MySQL failed to add foreign key error 1452
- Solution of duplicate entry ‘value’ for key ‘field name’ in MySQL
- DB2, create stored procedure error, sqlcode = – 104, sqlstate = 42601, PSM_ semicolon
- The solution of Hibernate query returning all null lists
- MySQL:Foreign key fails with error Error Code: 1452.
- Perfectly solve the 1366 error of saving Chinese in MySQL
- Arithmetic overflow error converting identity to data type int