| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| 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. |
![]() |
| Thread Tools | |
| Display Modes | |