You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(7) |
Dec
(4) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
(9) |
Feb
(4) |
Mar
(20) |
Apr
(10) |
May
(5) |
Jun
(2) |
Jul
(10) |
Aug
(4) |
Sep
(15) |
Oct
(5) |
Nov
(8) |
Dec
(2) |
| 2003 |
Jan
(11) |
Feb
(5) |
Mar
(10) |
Apr
(20) |
May
(24) |
Jun
(13) |
Jul
(6) |
Aug
(5) |
Sep
(10) |
Oct
(10) |
Nov
(9) |
Dec
(7) |
| 2004 |
Jan
(4) |
Feb
(10) |
Mar
(5) |
Apr
(18) |
May
(18) |
Jun
(14) |
Jul
(24) |
Aug
(14) |
Sep
(6) |
Oct
(18) |
Nov
(5) |
Dec
(3) |
| 2005 |
Jan
(5) |
Feb
(1) |
Mar
(5) |
Apr
(10) |
May
(10) |
Jun
(16) |
Jul
(46) |
Aug
(36) |
Sep
(16) |
Oct
(11) |
Nov
(12) |
Dec
(29) |
| 2006 |
Jan
(33) |
Feb
(45) |
Mar
(42) |
Apr
(23) |
May
(23) |
Jun
(21) |
Jul
(19) |
Aug
(23) |
Sep
(17) |
Oct
(50) |
Nov
(74) |
Dec
(44) |
| 2007 |
Jan
(35) |
Feb
(18) |
Mar
(46) |
Apr
(25) |
May
(26) |
Jun
(24) |
Jul
(33) |
Aug
(4) |
Sep
(41) |
Oct
(43) |
Nov
(23) |
Dec
(42) |
| 2008 |
Jan
(26) |
Feb
(20) |
Mar
(21) |
Apr
(18) |
May
(28) |
Jun
(32) |
Jul
(25) |
Aug
(28) |
Sep
(27) |
Oct
(34) |
Nov
(16) |
Dec
(42) |
| 2009 |
Jan
(21) |
Feb
(36) |
Mar
(40) |
Apr
(51) |
May
(27) |
Jun
(13) |
Jul
(38) |
Aug
(40) |
Sep
(5) |
Oct
(14) |
Nov
(4) |
Dec
(7) |
| 2010 |
Jan
(16) |
Feb
(10) |
Mar
(38) |
Apr
(83) |
May
(27) |
Jun
(41) |
Jul
(57) |
Aug
(24) |
Sep
(14) |
Oct
(22) |
Nov
(28) |
Dec
(42) |
| 2011 |
Jan
(52) |
Feb
(13) |
Mar
(41) |
Apr
(14) |
May
(24) |
Jun
(14) |
Jul
(16) |
Aug
(15) |
Sep
(19) |
Oct
(20) |
Nov
(35) |
Dec
(48) |
| 2012 |
Jan
(30) |
Feb
(9) |
Mar
(33) |
Apr
(15) |
May
(13) |
Jun
(13) |
Jul
(57) |
Aug
(20) |
Sep
(18) |
Oct
(29) |
Nov
(28) |
Dec
(9) |
| 2013 |
Jan
(19) |
Feb
(26) |
Mar
(44) |
Apr
(13) |
May
(38) |
Jun
(6) |
Jul
(24) |
Aug
(8) |
Sep
(7) |
Oct
(10) |
Nov
(12) |
Dec
(6) |
| 2014 |
Jan
(13) |
Feb
(6) |
Mar
(41) |
Apr
(5) |
May
(4) |
Jun
(3) |
Jul
(13) |
Aug
(9) |
Sep
(35) |
Oct
(36) |
Nov
(16) |
Dec
(4) |
| 2015 |
Jan
(6) |
Feb
(4) |
Mar
(7) |
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
(2) |
Sep
(10) |
Oct
(4) |
Nov
(13) |
Dec
(3) |
| 2016 |
Jan
(6) |
Feb
(12) |
Mar
(6) |
Apr
(21) |
May
(9) |
Jun
(16) |
Jul
(13) |
Aug
(13) |
Sep
(11) |
Oct
(9) |
Nov
(20) |
Dec
(18) |
| 2017 |
Jan
(7) |
Feb
(19) |
Mar
(9) |
Apr
(12) |
May
(12) |
Jun
(35) |
Jul
(7) |
Aug
(3) |
Sep
|
Oct
(1) |
Nov
(4) |
Dec
|
| 2018 |
Jan
(4) |
Feb
(1) |
Mar
(3) |
Apr
(8) |
May
(9) |
Jun
(8) |
Jul
(6) |
Aug
(7) |
Sep
(8) |
Oct
(1) |
Nov
(6) |
Dec
|
| 2019 |
Jan
(6) |
Feb
(9) |
Mar
(3) |
Apr
(3) |
May
(4) |
Jun
|
Jul
|
Aug
(4) |
Sep
(3) |
Oct
(3) |
Nov
(3) |
Dec
(1) |
| 2020 |
Jan
(4) |
Feb
(4) |
Mar
(22) |
Apr
(1) |
May
(16) |
Jun
(12) |
Jul
(3) |
Aug
(10) |
Sep
(5) |
Oct
(1) |
Nov
(24) |
Dec
(1) |
| 2021 |
Jan
(2) |
Feb
(10) |
Mar
(9) |
Apr
(7) |
May
(8) |
Jun
(10) |
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
(2) |
Dec
|
| 2022 |
Jan
(3) |
Feb
(4) |
Mar
(5) |
Apr
(2) |
May
|
Jun
|
Jul
|
Aug
(6) |
Sep
(1) |
Oct
(2) |
Nov
(2) |
Dec
|
| 2023 |
Jan
(2) |
Feb
(6) |
Mar
|
Apr
|
May
(13) |
Jun
|
Jul
|
Aug
(6) |
Sep
|
Oct
|
Nov
(1) |
Dec
(4) |
| 2024 |
Jan
(3) |
Feb
|
Mar
(5) |
Apr
(1) |
May
(5) |
Jun
(1) |
Jul
(1) |
Aug
|
Sep
|
Oct
(3) |
Nov
(3) |
Dec
|
| 2025 |
Jan
|
Feb
(5) |
Mar
(33) |
Apr
(8) |
May
(10) |
Jun
(7) |
Jul
|
Aug
|
Sep
(12) |
Oct
|
Nov
|
Dec
|
|
From: Gerd W. <ger...@t-...> - 2025-09-14 19:23:33
|
On 9/14/25 18:15, John Hardin wrote: > On Sat, 13 Sep 2025, Gerd Wagner wrote: >> On 9/11/25 19:51, info wrote: >>> SquirrelSQL 4.8.0 displays bit(n) fields where n>1 as true/false, >>> whereas >>> they should be displayed as integers of the corresponding width as for >>> example MySQL Workbench does. >>> >> >> Sorry, I can't reproduce you problem. >> My MYSQL DB does not allow values other than 0, 1, true, false in >> columns of type BIT. I'm using MySQL version 8.0.17 and JDBC-Driver >> "MySQL Connector/J" version mysql-connector-java-8.0.15 >> >> Gerd > > That sounds incorrect (or at least _incomplete_) per the documentation: > > https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/bit-type.html > > "bit(n)" is not a single bit, it's an array of n bits. > > Squirrel should be aware of "bit" vs. "bit(n)" and should not display > data in a column of type "bit(n>1)" as just true/false. That is (badly) > mininterpreting the data. > > I'd suggest the best default is the native "b'value'" notation from the > documentation, but that might not be easily platform-portable. Does > Squirrel support other platform-specific display formatting for > platform-specific data types? > > https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/bit-value- > literals.html > > The alternative would be to display them as integers as the OP says > MySQL Workbench does. > > "In numeric contexts, MySQL treats a bit literal like an integer. To > ensure numeric treatment of a bit literal, use it in numeric context. > Ways to do this include adding 0 or using CAST(... AS UNSIGNED)." > > OP: For the moment you can probably work around this by querying > "CAST(bitn_col AS UNSIGNED)", "(bitn_col + 0)" or "BIN(bitn_col)" as > noted in the MySQL bit-value-literals documentation, rather than > querying just raw "bitn_col". > > OP: I suggest opening a bug for this in the bug tracker referenced from > the Squirrel home page: > > https://github.com/squirrel-sql-client/squirrel-sql-code/issues > Ups, sorry, I didn't pay intention to the (n) of bit(n). I checked it out now. The problem is that bit(n) is not a common SQL data type, at least there seems no appropriate representation in the JDK class java.sql.Types. This might be the reason why the implementers of the MySQL JDBC driver decided to deliver the type BIT(=-7) for columns of type bit(n). A probably better choice would have been INTEGER(=4). I attach a short Java program that reproduces the problem. You may want to contact the JDCB driver implementers about this issue. Gerd P.S.: Your workaround CAST(bitArrayTestValue AS UNSIGNED) works for me, too. |
|
From: John H. <jh...@im...> - 2025-09-14 16:46:54
|
On Sat, 13 Sep 2025, Gerd Wagner wrote: > On 9/11/25 19:51, info wrote: >> SquirrelSQL 4.8.0 displays bit(n) fields where n>1 as true/false, whereas >> they should be displayed as integers of the corresponding width as for >> example MySQL Workbench does. >> > > Sorry, I can't reproduce you problem. > My MYSQL DB does not allow values other than 0, 1, true, false in columns of > type BIT. I'm using MySQL version 8.0.17 and JDBC-Driver "MySQL Connector/J" > version mysql-connector-java-8.0.15 > > Gerd That sounds incorrect (or at least _incomplete_) per the documentation: https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/bit-type.html "bit(n)" is not a single bit, it's an array of n bits. Squirrel should be aware of "bit" vs. "bit(n)" and should not display data in a column of type "bit(n>1)" as just true/false. That is (badly) mininterpreting the data. I'd suggest the best default is the native "b'value'" notation from the documentation, but that might not be easily platform-portable. Does Squirrel support other platform-specific display formatting for platform-specific data types? https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/bit-value-literals.html The alternative would be to display them as integers as the OP says MySQL Workbench does. "In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of a bit literal, use it in numeric context. Ways to do this include adding 0 or using CAST(... AS UNSIGNED)." OP: For the moment you can probably work around this by querying "CAST(bitn_col AS UNSIGNED)", "(bitn_col + 0)" or "BIN(bitn_col)" as noted in the MySQL bit-value-literals documentation, rather than querying just raw "bitn_col". OP: I suggest opening a bug for this in the bug tracker referenced from the Squirrel home page: https://github.com/squirrel-sql-client/squirrel-sql-code/issues -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- Gun Control laws aren't enacted to control guns, they are enacted to control people: catholics (1500s), japanese peasants (1600s), blacks (1860s), italian immigrants (1911), armenians (1911), the irish (1920s), jews (1930s), blacks (1960s), the poor (always) ----------------------------------------------------------------------- 3 days until the 238th anniversary of the signing of the U.S. Constitution |
|
From: Gerd W. <ger...@t-...> - 2025-09-13 19:06:48
|
On 9/11/25 19:51, info wrote: > SquirrelSQL 4.8.0 displays bit(n) fields where n>1 as true/false, > whereas they should be displayed as integers of the corresponding width > as for example MySQL Workbench does. > Sorry, I can't reproduce you problem. My MYSQL DB does not allow values other than 0, 1, true, false in columns of type BIT. I'm using MySQL version 8.0.17 and JDBC-Driver "MySQL Connector/J" version mysql-connector-java-8.0.15 Gerd |
|
From: Gerd W. <ger...@t-...> - 2025-09-13 17:45:51
|
Another option can be found at menu File --> Global Preferences --> tab General --> radio button at the right named "Save Aliases and Drivers immediately" Gerd On 9/11/25 01:59, Roger Hill wrote: > File/Save preferences > > Roger > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: info <in...@dr...> - 2025-09-11 17:51:42
|
SquirrelSQL 4.8.0 displays bit(n) fields where n>1 as true/false, whereas they should be displayed as integers of the corresponding width as for example MySQL Workbench does. |
|
From: Roger H. <rh...@hi...> - 2025-09-11 00:00:13
|
File/Save preferences Roger |
|
From: info <in...@dr...> - 2025-09-10 23:57:33
|
Does anyone know who is the developer who decided that it is a good idea to introduce a separate menu item for the saving of the settings? On 2025-09-10 07:53 PM, Roger Hill wrote: > There is a 'save preferences' button that is clickable. I am not near > my computer at the moment, but it is there in the menu structure. > > Roger > > Get BlueMail for Mobile <https://bluemail.me/download/> > On 10 September 2025, at 7:38 pm, info <in...@dr... > <mailto:in...@dr...>> wrote: > > >> What are you referring to as 'Save preferences'? >> >> On 2025-09-10 07:35 PM, Roger Hill wrote: >>> You never said that you clicked on 'Save preferences'. >>> >>> That has worked for me for many years. >>> >>> Regards >>> Roger >>> >>> Get BlueMail for Mobile <https://bluemail.me/download/> >>> On 10 September 2025, at 7:32 pm, info <in...@dr... >>> <mailto:in...@dr...>> wrote: >>> >>> >>>> I described the contrary in enough detail. >>>> >>>> >>>> >>>> On 2025-09-10 06:04 PM, Roger Hill wrote: >>>>> If you save preferences after the changes, they will be retained. >>>>> >>>>> Roger >>>>> >>>>> Get BlueMail for Mobile <https://bluemail.me/download/> >>>>> On 10 September 2025, at 6:03 pm, info <in...@dr... >>>>> <mailto:in...@dr...>> wrote: >>>>> >>>>> >>>>>> I edited aliases: cloned one, edited values, saved, and renamed >>>>>> the old one. Then I did some work within the new alias: created >>>>>> tables, ran queries. >>>>>> A few hours later, while the same instance Squirrel 4.8.0 was >>>>>> still running, the OS hung, and the kernel panicked. >>>>>> After the reboot, there was no new alias in the list, and the old >>>>>> one had the earlier name, so none of the changed have been committed. >>>>>> In the ideal world, they should be committed immediately, not >>>>>> when the application exits, which seems to be the case. >>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Squirrel-sql-users mailing list >>>>>> Squ...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >>>> >>>> >>>> I described the contrary in enough detail. >>>> >>>> >>>> >>>> On 2025-09-10 06:04 PM, Roger Hill wrote: >>>>> If you save preferences after the changes, they will be retained. >>>>> >>>>> Roger >>>>> >>>>> Get BlueMail for Mobile <https://bluemail.me/download/> >>>>> On 10 September 2025, at 6:03 pm, info <in...@dr... >>>>> <mailto:in...@dr...>> wrote: >>>>> >>>>> >>>>>> I edited aliases: cloned one, edited values, saved, and renamed >>>>>> the old one. Then I did some work within the new alias: created >>>>>> tables, ran queries. >>>>>> A few hours later, while the same instance Squirrel 4.8.0 was >>>>>> still running, the OS hung, and the kernel panicked. >>>>>> After the reboot, there was no new alias in the list, and the old >>>>>> one had the earlier name, so none of the changed have been committed. >>>>>> In the ideal world, they should be committed immediately, not >>>>>> when the application exits, which seems to be the case. >>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Squirrel-sql-users mailing list >>>>>> Squ...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >>>> >>>> >>>> I described the contrary in enough detail. >>>> >>>> >>>> >>>> On 2025-09-10 06:04 PM, Roger Hill wrote: >>>>> If you save preferences after the changes, they will be retained. >>>>> >>>>> Roger >>>>> >>>>> Get BlueMail for Mobile <https://bluemail.me/download/> >>>>> On 10 September 2025, at 6:03 pm, info <in...@dr... >>>>> <mailto:in...@dr...>> wrote: >>>>> >>>>> >>>>>> I edited aliases: cloned one, edited values, saved, and renamed >>>>>> the old one. Then I did some work within the new alias: created >>>>>> tables, ran queries. >>>>>> A few hours later, while the same instance Squirrel 4.8.0 was >>>>>> still running, the OS hung, and the kernel panicked. >>>>>> After the reboot, there was no new alias in the list, and the old >>>>>> one had the earlier name, so none of the changed have been committed. >>>>>> In the ideal world, they should be committed immediately, not >>>>>> when the application exits, which seems to be the case. >>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Squirrel-sql-users mailing list >>>>>> Squ...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >>>> >>>> >> >> What are you referring to as 'Save preferences'? >> >> On 2025-09-10 07:35 PM, Roger Hill wrote: >>> You never said that you clicked on 'Save preferences'. >>> >>> That has worked for me for many years. >>> >>> Regards >>> Roger >>> >>> Get BlueMail for Mobile <https://bluemail.me/download/> >>> On 10 September 2025, at 7:32 pm, info <in...@dr... >>> <mailto:in...@dr...>> wrote: >>> >>> >>>> I described the contrary in enough detail. >>>> >>>> >>>> >>>> On 2025-09-10 06:04 PM, Roger Hill wrote: >>>>> If you save preferences after the changes, they will be retained. >>>>> >>>>> Roger >>>>> >>>>> Get BlueMail for Mobile <https://bluemail.me/download/> >>>>> On 10 September 2025, at 6:03 pm, info <in...@dr... >>>>> <mailto:in...@dr...>> wrote: >>>>> >>>>> >>>>>> I edited aliases: cloned one, edited values, saved, and renamed >>>>>> the old one. Then I did some work within the new alias: created >>>>>> tables, ran queries. >>>>>> A few hours later, while the same instance Squirrel 4.8.0 was >>>>>> still running, the OS hung, and the kernel panicked. >>>>>> After the reboot, there was no new alias in the list, and the old >>>>>> one had the earlier name, so none of the changed have been committed. >>>>>> In the ideal world, they should be committed immediately, not >>>>>> when the application exits, which seems to be the case. >>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Squirrel-sql-users mailing list >>>>>> Squ...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >>>> >>>> >>>> I described the contrary in enough detail. >>>> >>>> >>>> >>>> On 2025-09-10 06:04 PM, Roger Hill wrote: >>>>> If you save preferences after the changes, they will be retained. >>>>> >>>>> Roger >>>>> >>>>> Get BlueMail for Mobile <https://bluemail.me/download/> >>>>> On 10 September 2025, at 6:03 pm, info <in...@dr... >>>>> <mailto:in...@dr...>> wrote: >>>>> >>>>> >>>>>> I edited aliases: cloned one, edited values, saved, and renamed >>>>>> the old one. Then I did some work within the new alias: created >>>>>> tables, ran queries. >>>>>> A few hours later, while the same instance Squirrel 4.8.0 was >>>>>> still running, the OS hung, and the kernel panicked. >>>>>> After the reboot, there was no new alias in the list, and the old >>>>>> one had the earlier name, so none of the changed have been committed. >>>>>> In the ideal world, they should be committed immediately, not >>>>>> when the application exits, which seems to be the case. >>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Squirrel-sql-users mailing list >>>>>> Squ...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >>>> >>>> >>>> I described the contrary in enough detail. >>>> >>>> >>>> >>>> On 2025-09-10 06:04 PM, Roger Hill wrote: >>>>> If you save preferences after the changes, they will be retained. >>>>> >>>>> Roger >>>>> >>>>> Get BlueMail for Mobile <https://bluemail.me/download/> >>>>> On 10 September 2025, at 6:03 pm, info <in...@dr... >>>>> <mailto:in...@dr...>> wrote: >>>>> >>>>> >>>>>> I edited aliases: cloned one, edited values, saved, and renamed >>>>>> the old one. Then I did some work within the new alias: created >>>>>> tables, ran queries. >>>>>> A few hours later, while the same instance Squirrel 4.8.0 was >>>>>> still running, the OS hung, and the kernel panicked. >>>>>> After the reboot, there was no new alias in the list, and the old >>>>>> one had the earlier name, so none of the changed have been committed. >>>>>> In the ideal world, they should be committed immediately, not >>>>>> when the application exits, which seems to be the case. >>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Squirrel-sql-users mailing list >>>>>> Squ...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >>>> >>>> >> >> What are you referring to as 'Save preferences'? >> >> On 2025-09-10 07:35 PM, Roger Hill wrote: >>> You never said that you clicked on 'Save preferences'. >>> >>> That has worked for me for many years. >>> >>> Regards >>> Roger >>> >>> Get BlueMail for Mobile <https://bluemail.me/download/> >>> On 10 September 2025, at 7:32 pm, info <in...@dr... >>> <mailto:in...@dr...>> wrote: >>> >>> >>>> I described the contrary in enough detail. >>>> >>>> >>>> >>>> On 2025-09-10 06:04 PM, Roger Hill wrote: >>>>> If you save preferences after the changes, they will be retained. >>>>> >>>>> Roger >>>>> >>>>> Get BlueMail for Mobile <https://bluemail.me/download/> >>>>> On 10 September 2025, at 6:03 pm, info <in...@dr... >>>>> <mailto:in...@dr...>> wrote: >>>>> >>>>> >>>>>> I edited aliases: cloned one, edited values, saved, and renamed >>>>>> the old one. Then I did some work within the new alias: created >>>>>> tables, ran queries. >>>>>> A few hours later, while the same instance Squirrel 4.8.0 was >>>>>> still running, the OS hung, and the kernel panicked. >>>>>> After the reboot, there was no new alias in the list, and the old >>>>>> one had the earlier name, so none of the changed have been committed. >>>>>> In the ideal world, they should be committed immediately, not >>>>>> when the application exits, which seems to be the case. >>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Squirrel-sql-users mailing list >>>>>> Squ...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >>>> >>>> >>>> I described the contrary in enough detail. >>>> >>>> >>>> >>>> On 2025-09-10 06:04 PM, Roger Hill wrote: >>>>> If you save preferences after the changes, they will be retained. >>>>> >>>>> Roger >>>>> >>>>> Get BlueMail for Mobile <https://bluemail.me/download/> >>>>> On 10 September 2025, at 6:03 pm, info <in...@dr... >>>>> <mailto:in...@dr...>> wrote: >>>>> >>>>> >>>>>> I edited aliases: cloned one, edited values, saved, and renamed >>>>>> the old one. Then I did some work within the new alias: created >>>>>> tables, ran queries. >>>>>> A few hours later, while the same instance Squirrel 4.8.0 was >>>>>> still running, the OS hung, and the kernel panicked. >>>>>> After the reboot, there was no new alias in the list, and the old >>>>>> one had the earlier name, so none of the changed have been committed. >>>>>> In the ideal world, they should be committed immediately, not >>>>>> when the application exits, which seems to be the case. >>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Squirrel-sql-users mailing list >>>>>> Squ...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >>>> >>>> >>>> I described the contrary in enough detail. >>>> >>>> >>>> >>>> On 2025-09-10 06:04 PM, Roger Hill wrote: >>>>> If you save preferences after the changes, they will be retained. >>>>> >>>>> Roger >>>>> >>>>> Get BlueMail for Mobile <https://bluemail.me/download/> >>>>> On 10 September 2025, at 6:03 pm, info <in...@dr... >>>>> <mailto:in...@dr...>> wrote: >>>>> >>>>> >>>>>> I edited aliases: cloned one, edited values, saved, and renamed >>>>>> the old one. Then I did some work within the new alias: created >>>>>> tables, ran queries. >>>>>> A few hours later, while the same instance Squirrel 4.8.0 was >>>>>> still running, the OS hung, and the kernel panicked. >>>>>> After the reboot, there was no new alias in the list, and the old >>>>>> one had the earlier name, so none of the changed have been committed. >>>>>> In the ideal world, they should be committed immediately, not >>>>>> when the application exits, which seems to be the case. >>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Squirrel-sql-users mailing list >>>>>> Squ...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >>>> >>>> >> |
|
From: info <in...@dr...> - 2025-09-10 23:37:56
|
What are you referring to as 'Save preferences'? On 2025-09-10 07:35 PM, Roger Hill wrote: > You never said that you clicked on 'Save preferences'. > > That has worked for me for many years. > > Regards > Roger > > Get BlueMail for Mobile <https://bluemail.me/download/> > On 10 September 2025, at 7:32 pm, info <in...@dr... > <mailto:in...@dr...>> wrote: > > >> I described the contrary in enough detail. >> >> >> >> On 2025-09-10 06:04 PM, Roger Hill wrote: >>> If you save preferences after the changes, they will be retained. >>> >>> Roger >>> >>> Get BlueMail for Mobile <https://bluemail.me/download/> >>> On 10 September 2025, at 6:03 pm, info <in...@dr... >>> <mailto:in...@dr...>> wrote: >>> >>> >>>> I edited aliases: cloned one, edited values, saved, and renamed the >>>> old one. Then I did some work within the new alias: created tables, >>>> ran queries. >>>> A few hours later, while the same instance Squirrel 4.8.0 was still >>>> running, the OS hung, and the kernel panicked. >>>> After the reboot, there was no new alias in the list, and the old >>>> one had the earlier name, so none of the changed have been committed. >>>> In the ideal world, they should be committed immediately, not when >>>> the application exits, which seems to be the case. >>>> >>>> >>>> >>>> _______________________________________________ >>>> Squirrel-sql-users mailing list >>>> Squ...@li... >>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> >> >> I described the contrary in enough detail. >> >> >> >> On 2025-09-10 06:04 PM, Roger Hill wrote: >>> If you save preferences after the changes, they will be retained. >>> >>> Roger >>> >>> Get BlueMail for Mobile <https://bluemail.me/download/> >>> On 10 September 2025, at 6:03 pm, info <in...@dr... >>> <mailto:in...@dr...>> wrote: >>> >>> >>>> I edited aliases: cloned one, edited values, saved, and renamed the >>>> old one. Then I did some work within the new alias: created tables, >>>> ran queries. >>>> A few hours later, while the same instance Squirrel 4.8.0 was still >>>> running, the OS hung, and the kernel panicked. >>>> After the reboot, there was no new alias in the list, and the old >>>> one had the earlier name, so none of the changed have been committed. >>>> In the ideal world, they should be committed immediately, not when >>>> the application exits, which seems to be the case. >>>> >>>> >>>> >>>> _______________________________________________ >>>> Squirrel-sql-users mailing list >>>> Squ...@li... >>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> >> >> I described the contrary in enough detail. >> >> >> >> On 2025-09-10 06:04 PM, Roger Hill wrote: >>> If you save preferences after the changes, they will be retained. >>> >>> Roger >>> >>> Get BlueMail for Mobile <https://bluemail.me/download/> >>> On 10 September 2025, at 6:03 pm, info <in...@dr... >>> <mailto:in...@dr...>> wrote: >>> >>> >>>> I edited aliases: cloned one, edited values, saved, and renamed the >>>> old one. Then I did some work within the new alias: created tables, >>>> ran queries. >>>> A few hours later, while the same instance Squirrel 4.8.0 was still >>>> running, the OS hung, and the kernel panicked. >>>> After the reboot, there was no new alias in the list, and the old >>>> one had the earlier name, so none of the changed have been committed. >>>> In the ideal world, they should be committed immediately, not when >>>> the application exits, which seems to be the case. >>>> >>>> >>>> >>>> _______________________________________________ >>>> Squirrel-sql-users mailing list >>>> Squ...@li... >>>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> >> |
|
From: Roger H. <rh...@hi...> - 2025-09-10 23:35:42
|
You never said that you clicked on 'Save preferences'.
That has worked for me for many years.
Regards
Roger
If you save preferences after the changes,
they will be retained.
Roger
I edited aliases: cloned one, edited values, saved, and
renamed the old one. Then I did some work within the new
alias: created tables, ran queries.
A few hours later, while the same instance Squirrel
4.8.0 was still running, the OS hung, and the kernel
panicked.
After the reboot, there was no new alias in the list,
and the old one had the earlier name, so none of the
changed have been committed.
In the ideal world, they should be committed
immediately, not when the application exits, which seems
to be the case.
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
If you save preferences after the changes,
they will be retained.
Roger
I edited aliases: cloned one, edited values, saved, and
renamed the old one. Then I did some work within the new
alias: created tables, ran queries.
A few hours later, while the same instance Squirrel
4.8.0 was still running, the OS hung, and the kernel
panicked.
After the reboot, there was no new alias in the list,
and the old one had the earlier name, so none of the
changed have been committed.
In the ideal world, they should be committed
immediately, not when the application exits, which seems
to be the case.
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
If you save preferences after the changes,
they will be retained.
Roger
I edited aliases: cloned one, edited values, saved, and
renamed the old one. Then I did some work within the new
alias: created tables, ran queries.
A few hours later, while the same instance Squirrel
4.8.0 was still running, the OS hung, and the kernel
panicked.
After the reboot, there was no new alias in the list,
and the old one had the earlier name, so none of the
changed have been committed.
In the ideal world, they should be committed
immediately, not when the application exits, which seems
to be the case.
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: info <in...@dr...> - 2025-09-10 23:32:34
|
I described the contrary in enough detail. On 2025-09-10 06:04 PM, Roger Hill wrote: > If you save preferences after the changes, they will be retained. > > Roger > > Get BlueMail for Mobile <https://bluemail.me/download/> > On 10 September 2025, at 6:03 pm, info <in...@dr... > <mailto:in...@dr...>> wrote: > > >> I edited aliases: cloned one, edited values, saved, and renamed the >> old one. Then I did some work within the new alias: created tables, >> ran queries. >> A few hours later, while the same instance Squirrel 4.8.0 was still >> running, the OS hung, and the kernel panicked. >> After the reboot, there was no new alias in the list, and the old one >> had the earlier name, so none of the changed have been committed. >> In the ideal world, they should be committed immediately, not when >> the application exits, which seems to be the case. >> >> >> >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Roger H. <rh...@hi...> - 2025-09-10 23:00:52
|
If you save preferences after the changes, they will be retained. Roger I edited aliases: cloned one, edited values, saved, and renamed the old one. Then I did some work within the new alias: created tables, ran queries. A few hours later, while the same instance Squirrel 4.8.0 was still running, the OS hung, and the kernel panicked. After the reboot, there was no new alias in the list, and the old one had the earlier name, so none of the changed have been committed. In the ideal world, they should be committed immediately, not when the application exits, which seems to be the case. _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: info <in...@dr...> - 2025-09-10 22:03:24
|
I edited aliases: cloned one, edited values, saved, and renamed the old one. Then I did some work within the new alias: created tables, ran queries. A few hours later, while the same instance Squirrel 4.8.0 was still running, the OS hung, and the kernel panicked. After the reboot, there was no new alias in the list, and the old one had the earlier name, so none of the changed have been committed. In the ideal world, they should be committed immediately, not when the application exits, which seems to be the case. |
|
From: David C. <dl...@wi...> - 2025-06-23 13:12:16
|
Well, I've found that I can run a custom query for it. Seems this could be
built in. But, I do understand that the system table names may change
depending upon the connected DBMS.
Select trim(con.tabschema) || '.' || trim(con.tabname) as table
, con.constname as constraint_name
, case tab.enforced
when 'N' then 'Disabled'
when 'Y' then 'Active'
end as status
, col.colname as column_name
, cast(con.text as varchar(255)) as text
from syscat.checks as con
Join syscat.colchecks as col
on col.constname = con.constname
and col.tabschema = con.tabschema
and col.tabname = con.tabname
Join syscat.tabconst as tab
on tab.constname = con.constname
and tab.tabschema = con.tabschema
and tab.tabname = con.tabname
order by con.tabschema, con.tabname, col.colname;
Thanks,
Dave Clark
--
Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331
On Sun, Jun 22, 2025 at 4:37 PM Gerd Wagner <ger...@t-...> wrote:
>
>
> On 11.06.25 16:26, David Clark wrote:
> > I have found where to view indexes and foreign key constraints, but not
> > where to view check constraints. Is this available in SQuirrel 4.8?
> >
>
> No it's not.
>
> To my knowledge the JDBC-API does not offer access to check constraints
> and there isn't any other SQL standard way to access check constraints,
> either.
>
> Gerd
>
|
|
From: Gerd W. <ger...@t-...> - 2025-06-22 20:37:22
|
On 11.06.25 16:26, David Clark wrote: > I have found where to view indexes and foreign key constraints, but not > where to view check constraints. Is this available in SQuirrel 4.8? > No it's not. To my knowledge the JDBC-API does not offer access to check constraints and there isn't any other SQL standard way to access check constraints, either. Gerd |
|
From: Stanimir S. <s7...@ne...> - 2025-06-11 17:10:26
|
Wed, 11 Jun 2025 14:58:26 +0000, /Kevin Beard/: > To: "squ...@li..." > <squ...@li...> > List-Unsubscribe: <https://lists.sourceforge.net/lists/options/squirrel-sql-users>, > <mailto:squ...@li...?subject=unsubscribe> > > Unsubscribe I guess you need to send this to <squ...@li...>, instead. -- Stanimir |
|
From: Kevin B. <Kev...@ph...> - 2025-06-11 15:14:32
|
Unsubscribe This message and any attachments are confidential, may contain privileged information, and are intended solely for the recipient named above. If you are not the intended recipient, or a person responsible for delivery to the named recipient, you are notified that any review, distribution, dissemination or copying is prohibited. If you have received this message in error, you should notify the sender by return email and delete the message from your computer system. |
|
From: David C. <dl...@wi...> - 2025-06-11 14:27:41
|
I have found where to view indexes and foreign key constraints, but not where to view check constraints. Is this available in SQuirrel 4.8? Sincerely, Dave Clark -- Winsupply Group Services 3110 Kettering Boulevard Dayton, Ohio 45439 USA (937) 294-5331 |
|
From: Gerd W. <ger...@t-...> - 2025-06-07 01:36:05
|
On 30.05.25 21:14, 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
>
As SQuirreL's default statement separator is ; (semicolon) and DB2 uses
; as an internal separator you might first want to adjust SQuirreL's
statement separator at menu File --> New Session Properties --> tab SQL
--> section "Statement" separator.
As stored procedures often contain empty lines, make sure the complete
procedure is selected in SQUirreL's editor before you click the run
button or hit Ctrl+Enter.
Below you find an example of a stored procedure that I could create and
execute from within SQuirreL.
To call the procedure from within SQuirreL you must use the JDBC format
{call READ_MYTABLE(42)}
although I noticed that for me
call READ_MYTABLE(42)
works as well.
Gerd
-- Example Stored Procedure for DB2/LINUXX8664 version SQL110550
--
CREATE OR REPLACE PROCEDURE READ_MYTABLE(IN MYTABLEIDVAR INTEGER)
LANGUAGE SQL
DYNAMIC RESULT SETS 1
BEGIN
DECLARE cursor1 CURSOR WITH RETURN TO CALLER
FOR (SELECT * FROM MYTABLE WHERE MYTABLEID = MYTABLEIDVAR);
OPEN cursor1;
END
|
|
From: David C. <dl...@wi...> - 2025-06-04 15:13:08
|
Note that I have successfully compiled my Linux DB2 stored procedure through SQuirrel. Yes, it is difficult having only the DB2 error messages to go by (i.e., no interactive debugger is possible), but once I got used to them I was able to figure things out. I also had to do a lot of reading of the IBM online documentation. It was helpful that I have had a lot of experience with writing stored procedures on other platforms--particularly, DB2 for iSeries. 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 >> > > |
|
From: info <in...@dr...> - 2025-05-31 13:45:29
|
https://www.ibm.com/docs/en/db2/11.1.0?topic=clp-db2-invocation https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=commands-db2-command-line-processor On 2025-05-31 09:28 AM, David Clark wrote: > How is the command line processor accessed? > |
|
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 >> > > |
|
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 > |
|
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 > |
|
From: info <in...@dr...> - 2025-05-30 22:29:00
|
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... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: David C. <dl...@wi...> - 2025-05-30 21:07:49
|
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 |
