|
From: David C. <dl...@wi...> - 2025-05-30 23:21:47
|
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...> 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 lis...@li...https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
