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

[Robert M. <rob...@gm...>]

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...> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> 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
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.14 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iQEcBAEBAgAGBQJRHi1oAAoJEFMgHzhQQ7hO0S4H/jI5M0+mCqE8UGvaZsc6xnP2
> DgEhDejEt6RmhtfbwniuYU1pDafFC+2149meTA3DuUc6gZoEk7rTXHXail4PTRnM
> wYdHi8Vpoo/3l+gEGHM8WZJ2DajNSPw0zmBDp5AC4VMZbb0uvUi8NTprQ9foyJV3
> OEPtFu1IGK1k9Yzm2fE3iMC9tDKTNge0xkrXUwmKCWJQxMDDY4fep3lzlzRAgcVX
> EnkGq7LWpLd16p5L5uomtq0F/SsafXbmK/zs+2WpjW4G1RvmuQ+rT2Vs0v5gwafL
> rARiMbxShBg9fWvFXCKgf7Rdan61csKm4TOmq3Wu5AuFFVncQcxomFmnRn1x2Ds=
> =8B0M
> -----END PGP SIGNATURE-----
>
>
> ------------------------------------------------------------------------------
> 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...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>