Error 42601 Ibm Db2 Sql0104n
Contents |
(troubleshooting) Problem(Abstract) Error DMS-E-GENERAL, A
Error 42601 Ibm Db2 Sql0104n An Unexpected Token
general exception has occurred during operation 'prepare request'. [IBM][CLI sqlstate 42601 sql0104n an unexpected token DB2][DB2 for MVS]SQL0104N An unexpected token"." was found following "". Expected tokens may
Db2 Sql0104n An Unexpected Token
include: "+-AS ,
the FAQ by clicking the link above. You may have to register before you can post: click the http://www.dbforums.com/showthread.php?1673738-SQLSTATE-42601-error register link above to proceed. To start viewing messages, select the https://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=21408 forum that you want to visit from the selection below. Results 1 to 8 of 8 Thread: SQLSTATE=42601 error Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode an unexpected 01-20-12,10:29 #1 aarjay View Profile View Forum Posts Registered User Join Date Jan 2012 Posts 4 Unanswered: SQLSTATE=42601 error I am using DB2 9.7.0.441 version on a Windows XP 2002 SP3 I have a few .SQL files that are given to me. I have created a database (COGOPS) and using the command editor I am trying to an unexpected token create tables, views, triggers in the COGOPS database. I was able to create the tables using one of the .sql files. However when running the following: BEGIN DECLARE Rec_Count, v_curr_category_num, v_dept_compl_ind, v_curr_dept_compl_ind, v_station_compl_ind, v_curr_station_compl_ind INTEGER; it gives me the following error: 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 "END-OF-STATEMENT" was found following "_compl_ind INTEGER". Expected tokens may include: "
"SELECT " Page:1/1 Poster Message dazedorconfused User Location: Atlanta, GA USA Joined on: 06-Apr-2006 22:59:26 Posted: 80 posts # Posted on: 10-Oct-2012 15:47:24. I am using LLBLGen Pro 3.1 to create a Self Service LLBLGen Pro Framework Project in C# Targeting .Net Framework. The database is DB2 9.7 on 64 bit AIX. Actually, its been working for years. Yesterday, I deployed a build (with no changes to my persistence layer) to my QA server and I started receiving this error. I pointed my development environment at the production DB2 server (don't tell the DBA) and verified that I receive the same error. Code: ERROR [42601] [IBM][DB2/AIX64] SQL0104N An unexpected token """" was found following "SELECT ". Expected tokens may include: "
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: IBM.Data.DB2.DB2Exception: ERROR [42601] [IBM][DB2/AIX64] SQL0104N An unexpected token """" was found following "SELECT ". Expected tokens may include: "
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[DB2Exception (0x80004005): ERROR [42601] [IBM][DB2/AIX64] SQL0104N An unexpected token """" was found following "SELECT ". Expected tokens may include: "
]
IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method, DB2CursorType reqCursorType, Boolean abortOnOptValueChg, Boolean skipDeleted, Boolean isResultSet, Int32 maxRows, Boolean skipInitialValidation) +2378
IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method) +22
IBM.Data.DB2.DB2Command.ExecuteReader(CommandBehavior behavior) +133
IBM.Data.DB2.DB2Command.ExecuteDbDataReader(CommandBehavior behavior) +4
System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
SD.LLBLGen.Pro.ORMSupportClasses.RetrievalQuery.Execute(CommandBehavior behavior) in c:\Myprojects\VS.NET Projects\LLBLGen Pro v3.1\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\Query\RetrievalQuery.cs:94
[ORMQueryExecutionException: An exception was caught during the execution of a retrieval query: ERROR [42601] [IBM][DB2/AIX64] SQL0104N An unexpected token """" was found following "SELECT ". Expected tokens may include: "