Re: Insert statement syntax error

This is a discussion on Re: Insert statement syntax error within the db2-udb forums in Other Databases category; Hi srparsi, Your operating system shell is interpretinging the braces as shell characters. The easiest way is to double quote the sql statement: in most shells double quote means do not interpret what is inside. Another option is to cut-n-paste the sql statement into a file, and (without double quote) have the db2 command line processer read commands from that file, e.g.: db2 -tvf commands.txt Where t means default terminator, which is semicolon (put a semicolon after each statement) v means verbose, echo the command back to the shell, and f followed by filename commands.txt , ...

Go Back   Database Forum > Other Databases > db2-udb

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 12-14-2005, 10:13 AM
Default Re: Insert statement syntax error

Hi srparsi,
Your operating system shell is "interpretinging" the braces as shell
characters.
The easiest way is to double quote the sql statement: in most shells
double quote means do not interpret what is inside.
Another option is to cut-n-paste the sql statement into a file, and
(without double quote) have the db2 command line processer read commands
from that file, e.g.:
db2 -tvf commands.txt

Where "t" means default terminator, which is semicolon (put a semicolon
after each statement)
"v" means verbose, echo the command back to the shell, and
"f" followed by filename "commands.txt", or whatever filename is the file
to read commands/sql from.

Hope this helps,
Dave.
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 05:43 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Integrated by bbpixel2009 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.