|
From: info <in...@dr...> - 2025-05-30 23:47:12
|
I had little luck compiling DB2 SPs through Squirrel. Usually they compile successfully through IBM Data Studio or command line processor. On 2025-05-30 07:20 PM, David Clark wrote: > Sorry, I should have mentioned that this is for DB2 for Linux. But, > by CLP, are you referring to Command Line Processing? I don't think I > have access to that. I'm just using SQuirrel v4.8 from the Windows > Desktop. I'm saving my source in a separate TXT file and copying it > into SQuirrel when I'm ready to test it. > > Sincerely, > > Dave Clark > -- > Winsupply Group Services > 3110 Kettering Boulevard > Dayton, Ohio 45439 USA > (937) 294-5331 > > > On Fri, May 30, 2025 at 6:29 PM info <in...@dr... > <mailto:in...@dr...>> wrote: > > David, > > Does your SP compile in CLP? > > Regards > > On 2025-05-30 03:14 PM, David Clark wrote: >> This is my first time using the Squirrel SQL Client (v8.4). I'm >> trying to create a DB2 stored procedure and getting the following >> error message. I'm not completely sure what it is trying to tell >> me. I know that the state indicates a syntax error, and I'm >> guessing that the SQLERRMC indicates the failing statement. Does >> the string after that indicate the previous characters in my >> source? ...leading up to that statement? And why does it say >> "TRUNCATE"? I know the ALTER statement is good, though; because >> I can execute it by itself elsewhere. So, I'm confused. Help?!? >> >> Error: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, >> SQLERRMC=ALTER;OP' Then Begin >> ;TRUNCATE, DRIVER=4.33.31 >> >> Sincerely, >> >> Dave Clark >> -- >> Winsupply Group Services >> 3110 Kettering Boulevard >> Dayton, Ohio 45439 USA >> (937) 294-5331 >> >> >> >> >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> <mailto:Squ...@li...> >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > <mailto:Squ...@li...> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
