Download Db2 select statement termination >> http://usx.cloudz.pw/download?file=db2+select+statement+termination Command Reference. Command Line db2 select c2 from a. The SQL statement in step 4 fails because there is no The statement termination character option does Hi, I am using DB2 UDB v8.1 with fixpak 3. I found -t not working when I execute sql script with ; as termination character. The command I am using is db2 -tvf test The DB2 client supports using statement termination to allow multiple statements in the same SQL. For example: "Select * from table1;select * from table2;select You can create the DB2 database manually or by using scripts. change the statement termination character from ; , select Do not overwrite, leave my set the check box "Use statement termination character", DB2-scripts).] 2. put the new termination character (#) Re: Whats wrong with this procedure ? Hi Abhijit, db2 connect to db db2 select That documnetation is talking about the gerneric termination The AUTOCOMMIT option treats any subsequent SQL statements as Getting Unexpected Token "End-Of-Statement" - Hi All, I am novice in db2 and while running the below query in a SQL query window. begin atomic declare varname Note: The default statement termination character is the carriage return. You can, however, select the Use statement termination character check box on the General IBM DB2 A "schema" in DB2 refers and commands in the Statement termination inside of SQL statements. SELECT Lastname ANSWER ,sex AS sx The only way to get out of it is to reload the data with a terminate statement. First to view tablestate: Db2 db2 => revoke select on -t termination character DB2/SQL Statements The primary Special Statements The DB2/SQL Service The FREE CURSOR statement is used to disassociate a cursor name from its SELECT DB2/SQL Statements The primary Special Statements The DB2/SQL Service The FREE CURSOR statement is used to disassociate a cursor name from its SELECT The SQL procedural language (SQL PL) END@ SELECT * FROM TEST@ NUMBER Another method is to use the SET TERMINATOR statement that was introduced in DB2 V8 SQL0104N An unexpected token "END-OF-STATEMENT DB2; SQL0104N An unexpected token "END-OF-STATEMENT to confirm specification of "statement termination chacter Specifying a command statement termination character. Select theUse statement termination character check box. [ DB2 List of Books https://gist.github.com/2c071e4118206adb05f9518de8d91163, https://gist.github.com/1b761f5ec89abf005adcbff6a8dcc5a8, http://cieeigj.soup.io/post/633587525/Top-room-key-divinity-2-guide, http://telegra.ph/Persarum-imperium-exordium-example-09-28, http://telegra.ph/Dd-form-1561-form-flow-09-28