If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > insert values rare

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-10-03, 13:32
zarconja zarconja is offline
Registered User
 
Join Date: Dec 2002
Posts: 25
Question insert values rare

when I execute the following sentence...

INSERT INTO TABLEREP (IN_ID, VC_NAME) VALUES (1, '>>\eh31cAF$i$')

..from the command to center... the result that I obtain is...

DB21007E End of file reached while reading the command

as I can correct this problem to manage to insert these values

thanks
Reply With Quote
  #2 (permalink)  
Old 03-10-03, 13:48
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,473
My guess is that you have the "Statement Termination Character" set to something in the Tools>Tool Settings (General tab). This mean that you need to terminate the statements with that character. It is usually set to a semicolon (, so your statement should be like:

Insert into table (col1,col2) values (value1,value2);

HTH
Andy
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On