<div>
<br />
why not just do:<br />
<br />
INSERT INTO TBL_AAA VALUES( 'P1' )<br />
<br />
?
</div>



why not just do:

INSERT INTO TBL_AAA VALUES( 'P1' )

?

<div>
Obviously, you need to close the statement, catch the exceptions, etc...
</div>


Obviously, you need to close the statement, catch the exceptions, etc...

<div>
Actually the table contains more than 3 column, therefore I cannot use INSERT INTO TBL_AAA VALUES( 'P1' )<br />

</div>


Actually the table contains more than 3 column, therefore I cannot use INSERT INTO TBL_AAA VALUES( 'P1' )


<div>
You can do:<br />
<br />
&nbsp; &nbsp;INSERT INTO TBL_AAA ( COLUMNNAME ) VALUES ( 'P1' )<br />
<br />
to just insert into a single column :-)<br />
<br />
Good luck!!<br />
<br />
Tim
</div>


You can do:

   INSERT INTO TBL_AAA ( COLUMNNAME ) VALUES ( 'P1' )

to just insert into a single column :-)

Good luck!!

Tim

<div>
<div class="content wysiwyg-content">
I am using DB2. I want to insert a record using JSP.<br />
<br />
The table is as follow : <br />
COLUMN NAME: A (primary key) , B ,C<br />
DATA TYPE: TIMESTAMP, DATE<br />
<br />
<br />
I am using JSP to insert a record.<br />
<br />
my sql statement is as follow :<br />
INSERT INTO TBL_AAA VALUES ('P1','','')<br />
<br />
however I get the follow error:<br />
com.ibm.db2.jcc.c.SqlExcep<wbr />tion: The syntax of the string representation of a datetime value is incorrect.<br />
<br />
THE DATA SAMPLE IS AS FOLLOW:<br />
<br />
P2, FEB 3,2005 2:40:03 PM 218000 , DEC 14, 2004<br />
<br />
Would somebody please help me ?
</div>
</div>


I am using DB2. I want to insert a record using JSP.

The table is as follow : 
COLUMN NAME: A (primary key) , B ,C
DATA TYPE: TIMESTAMP, DATE


I am using JSP to insert a record.

my sql statement is as follow :
INSERT INTO TBL_AAA VALUES ('P1','','')

however I get the follow error:
com.ibm.db2.jcc.c.SqlException: The syntax of the string representation of a datetime value is incorrect.

THE DATA SAMPLE IS AS FOLLOW:

P2, FEB 3,2005 2:40:03 PM 218000 , DEC 14, 2004

Would somebody please help me ?

insert empty timestamp into db2 using jsp

JavaServer Pages (JSP) allow the development of dynamically generated web pages. It uses the Java programming language; JSP pages are translated into servlets at runtime, with each servlet being cached and reused until the JSP is modified. JSP allows Java code to be interleaved with static web markup content, so the resulting page can be compiled and executed on the server to deliver the content.