|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
Rowlock in insert for DB2 Version8
Hello all,
I am new to DB2, Currently i am using DB2 version 8.02 personal edition on Windows XP Professional. And Facing problem with rowlock in insert query. I have created a sample database as CREATE TABLE SCEMANAME.LOG ( Sequence DECIMAL(9 ,0) NOT NULL , SubSequence DECIMAL(9 ,0) NOT NULL , RecordType DECIMAL(9 ,0) , LogDate TIMESTAMP , Name char (30) , Action char (80) , usertype DECIMAL(1) , sourceapp DECIMAL(1) ) And now trying to fire queries on DB2 INSERT INTO SCEMANAME.LOG WITH (ROWLOCK) (SEQUENCE,SUBSEQUENCE,RECORDTYPE,LOGDATE, NAME,ACTION,USERTYPE,SOURCEAPP) VALUES(1,12,123,'2007-04-03 15:51:47.333','SANS','test',0,0); but the query results in an error as , DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0104N An unexpected token "WITH" was found following "','SANS','test',0, 0)". Expected tokens may include: ",". SQLSTATE=42601 SQL0104N An unexpected token "WITH" was found following "','SANS','test',0,0)". Expected tokens may include: ", ". Thanks Santosh |
![]() |
| Viewing: Dev Shed Forums > Databases > DB2 Development > Rowlock in insert for DB2 Version8 |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|