|
From: David C. <dl...@wi...> - 2025-05-31 13:29:22
|
How is the command line processor accessed? Thanks, Dave Clark -- Winsupply Group Services 3110 Kettering Boulevard Dayton, Ohio 45439 USA (937) 294-5331 On Fri, May 30, 2025 at 7:47 PM info <in...@dr...> wrote: > 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...> 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 >> > > |
