|
Not Sure. Message description for SQL0901 "DSPMSGD RANGE(SQL0901) MSGF(QSQLMSG)" just says "SQL System Error". You could try and track down the server database job to find the specific error. There should be a QZDASOINIT job in QUSRWRK than did the database access for that request, so look for one running under your userid, and look at the job log. Sometimes its easier to track these down via ops nav, as that will display the current user. cheers Colin.W http://as400blog.blogspot.com -----Original Message----- From: Dijk, Bas v [mailto:bvdijk@xxxxxxxxx] Sent: 08 April 2005 11:28 To: Websphere Development Studio Client for iSeries Subject: RE: [WDSCI-L] Quantum DB perspective Thanks ! That worked great. But, let me be so free to ask another thing.... I would like to compare the Quantum DB perspective with the Data perspective. Unfortunately I cannot get a connection to work in my data perspective. I am using the same settings as within the Quantum perspective but instead of setting up a bookmark for my DIJKBV library I am now using a filter to set the SCHEMA to DIJKBV. Now, when I try to connect I get this: One or more problems were reported while accessing the database. Problem reading tables for schema 'DIJKBV'. [SQL0901] SQL-systeemfout. Problem reading database 'Sligro20'. [SQL0901] SQL-systeemfout. When I omit the DIJKBV filter it gives the same error for all my schema's. The strange thing is that I used this perspective several months ago (version 5.1.2 clean from CD). Any ideas? -----Oorspronkelijk bericht----- Van: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] Namens Colin Williams Verzonden: vrijdag 8 april 2005 12:08 Aan: 'Websphere Development Studio Client for iSeries' Onderwerp: RE: [WDSCI-L] Quantum DB perspective Try jdbc:as400://10.1.0.2;libraries=DIJKBV,*LIBL;naming=system cheers Colin.W http://as400blog.blogspot.com -----Original Message----- From: Dijk, Bas v [mailto:bvdijk@xxxxxxxxx] Sent: 08 April 2005 10:19 To: Websphere Development Studio Client for iSeries Subject: RE: [WDSCI-L] Quantum DB perspective Thanks for the info. I tried the following url's: jdbc:as400://10.1.0.2 libraries=DIJKBV jdbc:as400://10.1.0.2 libraries = DIJKBV jdbc:as400://10.1.0.2 libraries=*LIBL jdbc:as400://10.1.0.2 libraries = *LIBL My driver: AS/400 Toolbox for Java JDBC Driver com.ibm.as400.access.AS400JDBCDriver 5.0 C:\Program Files\IBM\Client Access\jt400\lib\jt400.jar DB2 for AS400 But when I try: SELECT * FROM SOMETBL (instead of SELECT * FROM DIJKBV.SOMETABLE) it won't work. Are there any documents on the possible syntax on the URL line? Or is my mistake so obvious that someone could point it out to me? -----Oorspronkelijk bericht----- Van: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] Namens Colin Williams Verzonden: vrijdag 8 april 2005 10:44 Aan: 'Websphere Development Studio Client for iSeries' Onderwerp: RE: [WDSCI-L] Quantum DB perspective - Where can I setup my Quantum DB so that it uses a standard bookmark (library) or my library list (so I can omit the bookmarkname in my statements)? *Setup your library list on the driver url: libraries = mylib1,mylib2,*libl - Can I setup the returned list with info in a way like 'strsql' does (so it only shows the first page and shows the next 'page' when I start to scroll)? *It does only show the first page, you need to click the down arrow to see the next page, but I think the page length is quite long - Are there any analysing options like in the iSeries Navigator? *Quantum DB is basically a gui for the java database driver, if you want any more functionality than that you will probably need to contact the developers, or code something up yourself Another happy QuantumDB user. Cheers Colin.W http://as400blog.blogspot.com This e-mail has been sent by a company of Bertram Group Ltd, whose registered office is 1 Broadland Business Park, Norwich, NR7 0WF. This message, and any attachments, are intended solely for the addressee and may contain privileged or confidential information. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email in error, please contact the sender immediately. Opinions, conclusions and statements of intent in this e-mail are those of the sender and will not bind a Bertram Group Ltd company unless confirmed in writing by a director independently of this message. Although we have taken steps to ensure that this email and any attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free. -- This is the Websphere Development Studio Client for iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/wdsci-l or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/wdsci-l. ****************************************************************** Deze e-mail is gecontroleerd op virussen. Aan de inhoud van dit bericht kunnen geen rechten ontleend worden. ****************************************************************** -- This is the Websphere Development Studio Client for iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/wdsci-l or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/wdsci-l. This e-mail has been sent by a company of Bertram Group Ltd, whose registered office is 1 Broadland Business Park, Norwich, NR7 0WF. This message, and any attachments, are intended solely for the addressee and may contain privileged or confidential information. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email in error, please contact the sender immediately. Opinions, conclusions and statements of intent in this e-mail are those of the sender and will not bind a Bertram Group Ltd company unless confirmed in writing by a director independently of this message. Although we have taken steps to ensure that this email and any attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free. -- This is the Websphere Development Studio Client for iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/wdsci-l or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/wdsci-l. ****************************************************************** Deze e-mail is gecontroleerd op virussen. Aan de inhoud van dit bericht kunnen geen rechten ontleend worden. ****************************************************************** -- This is the Websphere Development Studio Client for iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/wdsci-l or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/wdsci-l. This e-mail has been sent by a company of Bertram Group Ltd, whose registered office is 1 Broadland Business Park, Norwich, NR7 0WF. This message, and any attachments, are intended solely for the addressee and may contain privileged or confidential information. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email in error, please contact the sender immediately. Opinions, conclusions and statements of intent in this e-mail are those of the sender and will not bind a Bertram Group Ltd company unless confirmed in writing by a director independently of this message. Although we have taken steps to ensure that this email and any attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
