Re: [Squirrel-sql-users] extended error msgs when using DB2

[Marcin K. <mr...@gm...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


I do have it loaded, it is marked in column Load at startup as well.
Version 0.04.

Db2: 10.1 GA (no fixpacks), platform: win7 x64.

Thanks!


Robert Manning wrote:
> If you have the DB2 plugin loaded, it will attempt get "human-readable"
> messages using DB2-specific classes in the JDBC driver.  Check to see
> that you have the DB2 plugin loaded (Plugins -> Summary -> Internal Name
> == db2)
> 
> Rob
> 
> On Fri, Feb 15, 2013 at 7:43 AM, Marcin Krol <mr...@gm...
> <mailto:mr...@gm...>> wrote:
> 
> Hello everyone,
> 
> I have specified "errors=full" in Driver properties tab in Alias
> properties, but I still get only typical error code:
> 
> 
> Error: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=OWNER,
> DRIVER=4.13.127
> SQLState:  42703
> ErrorCode: -206
> 
> 
> The same query when ran in db2 cmdline tool:
> 
> db2 => select * from sysibm.systables  where owner = 'SAM'  and type
> = 'T';
> SQL0206N  "OWNER" is not valid in the context where it is used.
> SQLSTATE=42703
> 
> 
> Is there a way of getting a message accompanying error code in Squirrel?
> 
> 
> Regards,
> Marcin Krol

-
------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
<mailto:Squ...@li...>
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.14 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJRH4JKAAoJEFMgHzhQQ7hO2x8H/Rnb8YWR4jw4IzQIcEY0lS1P
xT3c48dZFql0iuL4fKNPdYYhBJVBH9aBjFCt6aiSe1rXbJjRs+tAcH1FwdwjtuqG
R5Ylz4LdBVv0uFL6V1AWbUeNul9Y/AHIG6kAhfFjOYRhoBAK0G4eNxcYHE4CqeDJ
+G0OWiD7qJaMp1TaXDe6SrIL/czG5Brskx2w0f9IpHXgJRRp7ZdKobZws7nssh+J
vUDG46Oogiwc4Dcmi4BYvpn17L2JC9CFk23X/4BOz2fLptxo2LJXstBHqv585hRG
NOCMHKjQ10PDPs1rgmSmF5w7JqJ9ZnZXd1W67cJ6/th9o0ewWskw+eSA/pi9s1o=
=1uHH
-----END PGP SIGNATURE-----