Thread: [Squirrel-sql-develop] SQuirreL -> Objects -> SEQUENCE
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Domen D. <dom...@zp...> - 2011-01-31 12:26:08
|
Hello, We have problem browsing SEQUENCES in your tool. The problem is because the information of sequences is stored in other table than that you specify in the tool. Other browsing (tables, views, .) is working OK. Error: SEQUENCE: com.ibm.db2.jcc.a.nn: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SYSCAT.SEQUENCES, DRIVER=3.52.95 The target database is DB2 (version 9.1) which is running on zOS. The table where information of sequences is stored is located in SYSIBM.SYSSEQUENCES. Is it possible to change these settings somewhere? Best regards Domen Dolar ---------------------------------------------------------------------------- Msc. Domen Dolar Head of Application Development The institute of pension and invalidity insurance of Slovenia Kolodvorska 15, 1518 Ljubljana, Slovenija E: Dom...@zp... Tel: +386 1 474 5105 |
From: Robert M. <rob...@gm...> - 2011-01-31 19:49:42
|
At the moment no. But considering that there are at least 5 different flavors of DB2 (LUW, OS/400, zOS) and not to mention versions, I am considering it. I have access to LUW, someone else contributed OS/400 and recently we had an offer to provide the similar schema information and testing for zOS. I just have not had the time to implement it. I will let everyone know when there is a candidate version of the DB2 plugin that supports zOS available for testing. Rob On Mon, Jan 31, 2011 at 6:49 AM, Domen Dolar <dom...@zp...> wrote: > Hello, > > > > We have problem browsing SEQUENCES in your tool. The problem is because the > information of sequences is stored in other table than that you specify in > the tool. Other browsing (tables, views, .) is working OK. > > > > Error: SEQUENCE: com.ibm.db2.jcc.a.nn: DB2 SQL Error: SQLCODE=-204, > SQLSTATE=42704, SQLERRMC=SYSCAT.SEQUENCES, DRIVER=3.52.95 > > > > The target database is DB2 (version 9.1) which is running on zOS. The table > where information of sequences is stored is located in SYSIBM.SYSSEQUENCES. > > > > Is it possible to change these settings somewhere? > > > > Best regards Domen Dolar > > > > > > > ---------------------------------------------------------------------------- > > Msc. Domen Dolar > > Head of Application Development > > The institute of pension and invalidity insurance of Slovenia > > Kolodvorska 15, 1518 Ljubljana, Slovenija > > E: Dom...@zp... > > Tel: +386 1 474 5105 > > > > > ------------------------------------------------------------------------------ > Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! > Finally, a world-class log management solution at an even better > price-free! > Download using promo code Free_Logger_4_Dev2Dev. Offer expires > February 28th, so secure your free ArcSight Logger TODAY! > http://p.sf.net/sfu/arcsight-sfd2d > _______________________________________________ > Squirrel-sql-develop mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > |