hello friends,
i am new to db2 and i have a project to do in db2 so first i created a database and a table but when i need to insert data into that it is showing sql error code 7,
this is my table

CREATE TABLE SHIVA.USR_JOBSEEKER (
ID BIGINT GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1),
USERNAME VARCHAR(25) NOT NULL UNIQUE,
EMAIL VARCHAR(45) NOT NULL UNIQUE,
PASSWORD VARCHAR(45) NOT NULL,
FULLNAME VARCHAR(25),
DOB DATE,
GENDER VARCHAR(50),
LOCATION VARCHAR(45),
MOBILE BIGINT NOT NULL,
EXP_YRS VARCHAR(25),
EXP_MNTS VARCHAR(25),
CURR_SAL VARCHAR(25),
EDU_DET VARCHAR(25),
SKILLS LONG VARCHAR,
FUNC_AREA LONG VARCHAR,
RESUME_TIT VARCHAR(75),
RES_PASTE VARCHAR(300),
DATE DATE,
ALERTS VARCHAR(5),
STATUS VARCHAR(3) NOT NULL DEFAULT 0
)




and this is my inserting code


INSERT INTO SHIVA.USR_JOBSEEKER(USERNAME,EMAIL,PASSWORD) VALUES('SHIVA','SJSUS','DFHF')


is there any mistake in syntax or cant we send data to only particular fields or what is the prob i cant understand please help me!!!
i use ems sql manager is there any problem with that and my db2 works very slow even to execute create table and insert one row from table!!!
can some one help me regarding that..
thank u!!!

Mobile bigint not null,

thank friend so i must remove not null in mobile...thanks friend...but how to make db2 work faster???

You could tune the system and applications.

you could use append on if u don't have cluster index on it

regds
paul