MyEclipse DB Explorer is not displaying the DB2 tables

MyEclipse IDE

Installation, Configuration & Updates

This topic has 23 replies, 3 voices, and was last updated 18 years, 10 months ago by dkirvan.

Viewing 9 posts - 16 through 24 (of 24 total)

← 1 2

Author

Posts
March 10, 2006 at 12:43 pm #248311 Reply

Haris Peco
Member

dkirvan,

Im’ sorry, but can you try this (stiil), please

ResultSet tableRs = md.getTables(null,”DKIRVAN1″,”%”,new String[] { “TABLE” });
and
ResultSet tableRs = md.getTables(“DKIRVAN1″,null,”%”,new String[] { “TABLE” });

Is it throw exception ?

Thanks

March 10, 2006 at 1:05 pm #248315 Reply

dkirvan
Member

ResultSet tableRs = md.getTables(null,”DKIRVAN1″,”%”,new String[] { “TABLE” });

RETURNS:
java.sql.SQLException: [SQL0901] SQL system error.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:485)
at com.ibm.as400.access.AS400JDBCDatabaseMetaData.getTables(AS400JDBCDatabaseMetaData.java:4134)
at HelloJavaPkg.As400Test.testGetTables(As400Test.java:55)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:478)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
productName=DB2 UDB for AS/400
supportCatalogs=false
supportSchemas=true
Catalogs :
AGRI400
Schemas :
#COBLIB
#LIBRARY
#RPGLIB
ACTIVEXSDK
AGLIB
ASCC
ASCCTOOLS
ASN
CANEMI
CGIDEV2
CRTPLFLIB
CVTSPLV4R1
DBFEXE
DBUINSTALL
DBU60
DIRECTORY
DKIRVAN1
DKIRVAN2
DOUG
EGGEMAIL
EMLIB
EMTRKY
EMTST
ET111317
ET171017
FMOSS
GDESS
GNLIB
IFSLIB
IFSLIB2
IFSTOOL
JATKINSO
LCONSTAN
LCPGMR
LKSAGLIB
LKSEGGS
LKSEGGS2
LKSEGGS3
LKSEGGS4
LKSHELL
LKSSALES
LS155454
LYNNJRN
MBPFR
MMAIL
MMOFFITT
MPGLIB
NETSEND
PDSQLCOL
PKZ560
QADMBKUP
QADMDISTP
QAFP
QAFPLIB1
QAFPLIB2
QAFPLIB3
QBRM
QCAEXP
QCAP3
QCA400W
QCBL
QCBLLE
QCBLLEP
QCE3
QCLE
QCPPLE
QDEVTOOLS
QDIRSRV2
QDNS
QDOC
QDP4
QDSNX
QFAX
QFNTCPL
QFPNTWE
QGPL
QGPLTEMP
QGY
QHLPSYS
QHTTP
QHTTPSVR
QICSS
QICU
QIJS
QINMEDIA
QINPRIOR
QINSYS
QIWA
QIWA2
QIWS
QIXWSA
QJAVA
QJT400
QLBL
QMGTC
QMGTC2
QMPGDATA
QMSE
QPASE
QPC5250K
QPC5250P
QPC5250T
QPDA
QPFR
QPFRDATA
QPFRD52001
QPFRD53001
QQALIB
QQFTEMP
QQRYLIB
QRCL
QRDARS
QRECOVERY
QRJE
QRPG
QRPGLE
QRPGLEP
QRPG38
QRPLOBJ
QSHELL
QSPL
QSPTLIB
QSQL
QSRV
QSRVAGT
QSYS
QSYSCGI
QSYSDIR
QSYSINC
QSYS2
QSYS2924
QTCP
QTEMP
QTILIB
QTMELCF
QUSRBRM
QUSRDIRDB
QUSRIJS
QUSRINFSKR
QUSRRDARS
QUSRSYS
QUSRTEMP
QWIN16
QWIN16D
QWIN16S
QWIN32
Q1ABRMSF
Q1ABRMSF01
RESTORE
SASINPDEV
SASINPUT
SASJUNK
SASMITH
SASMITHX
SASPMS
SHLIB
SQLINSTALL
SQLPRO
SUPPLYMGR
SYSIBM
TEMP_SQL
TMAIL
TULIB
TWINTER
WHLIB
supportCatalogsInDataManipulation=false
supportCatalogsInTableDefinitions=false
supportCatalogsInDataProcedureCalls=false

*********************************
ResultSet tableRs = md.getTables(“DKIRVAN1″,null,”%”,new String[] { “TABLE” });

RETURNS:

productName=DB2 UDB for AS/400
supportCatalogs=false
supportSchemas=true
Catalogs :
AGRI400
Schemas :
#COBLIB
#LIBRARY
#RPGLIB
ACTIVEXSDK
AGLIB
ASCC
ASCCTOOLS
ASN
CANEMI
CGIDEV2
CRTPLFLIB
CVTSPLV4R1
DBFEXE
DBUINSTALL
DBU60
DIRECTORY
DKIRVAN1
DKIRVAN2
DOUG
EGGEMAIL
EMLIB
EMTRKY
EMTST
ET111317
ET171017
FMOSS
GDESS
GNLIB
IFSLIB
IFSLIB2
IFSTOOL
JATKINSO
LCONSTAN
LCPGMR
LKSAGLIB
LKSEGGS
LKSEGGS2
LKSEGGS3
LKSEGGS4
LKSHELL
LKSSALES
LS155454
LYNNJRN
MBPFR
MMAIL
MMOFFITT
MPGLIB
NETSEND
PDSQLCOL
PKZ560
QADMBKUP
QADMDISTP
QAFP
QAFPLIB1
QAFPLIB2
QAFPLIB3
QBRM
QCAEXP
QCAP3
QCA400W
QCBL
QCBLLE
QCBLLEP
QCE3
QCLE
QCPPLE
QDEVTOOLS
QDIRSRV2
QDNS
QDOC
QDP4
QDSNX
QFAX
QFNTCPL
QFPNTWE
QGPL
QGPLTEMP
QGY
QHLPSYS
QHTTP
QHTTPSVR
QICSS
QICU
QIJS
QINMEDIA
QINPRIOR
QINSYS
QIWA
QIWA2
QIWS
QIXWSA
QJAVA
QJT400
QLBL
QMGTC
QMGTC2
QMPGDATA
QMSE
QPASE
QPC5250K
QPC5250P
QPC5250T
QPDA
QPFR
QPFRDATA
QPFRD52001
QPFRD53001
QQALIB
QQFTEMP
QQRYLIB
QRCL
QRDARS
QRECOVERY
QRJE
QRPG
QRPGLE
QRPGLEP
QRPG38
QRPLOBJ
QSHELL
QSPL
QSPTLIB
QSQL
QSRV
QSRVAGT
QSYS
QSYSCGI
QSYSDIR
QSYSINC
QSYS2
QSYS2924
QTCP
QTEMP
QTILIB
QTMELCF
QUSRBRM
QUSRDIRDB
QUSRIJS
QUSRINFSKR
QUSRRDARS
QUSRSYS
QUSRTEMP
QWIN16
QWIN16D
QWIN16S
QWIN32
Q1ABRMSF
Q1ABRMSF01
RESTORE
SASINPDEV
SASINPUT
SASJUNK
SASMITH
SASMITHX
SASPMS
SHLIB
SQLINSTALL
SQLPRO
SUPPLYMGR
SYSIBM
TEMP_SQL
TMAIL
TULIB
TWINTER
WHLIB
supportCatalogsInDataManipulation=false
supportCatalogsInTableDefinitions=false
supportCatalogsInDataProcedureCalls=false

Let me know if I can do anything else. Thank you.

March 10, 2006 at 1:38 pm #248319 Reply
Haris Peco
Member
David,

Please, is it correct ?

ResultSet tableRs = md.getTables(null,”DKIRVAN1″,”%”,new String[] { “TABLE” });

throw exception

and

ResultSet tableRs = md.getTables(“DKIRVAN1″,null,”%”,new String[] { “TABLE” });

no ?

yet one test, too :
```
public void testGetCatalogsSchemasTables() {
        Connection connection = null;
        try {
            connection = getConnection();
            DatabaseMetaData md = connection.getMetaData();
            ResultSet catalogRs = md.getCatalogs();
            System.out.println("Catalogs :");
            while(catalogRs.next()) {
                String name = catalogRs.getString(1);
                System.out.println(name);
            }
            ResultSet schemaRs = md.getSchemas();
            System.out.println("Schemas :");
            while(schemaRs.next()) {
                String schemaName = schemaRs.getString(1);
                System.out.println(schemaName);
                ResultSet tableRs = md.getTables(null,schemaName,"%",new String[] { "TABLE" });
                while(tableRs.next()) {
                    String tableName = tableRs.getString("TABLE_NAME");
                    System.out.println("  " + tableName);
                }
            }
            
        } catch (SQLException e) {
            e.printStackTrace();
            fail();
        } finally {
            try {
                if (connection != null)
                    connection.close();
            } catch (SQLException e) {}
        }
    }
```
Thanks
March 14, 2006 at 7:37 am #248513 Reply

dkirvan
Member

Yes, what I said is correct in that

ResultSet tableRs = md.getTables(null,”DKIRVAN”,”%”,new String[] { “TABLE” });
THROWS EXCEPTION

ResultSet tableRs = md.getTables(“DKIRVAN”,null,”%”,new String[] { “TABLE” });
DOES NOT THROW EXCEPTION

ResultSet tableRs = md.getTables(null,null,”%”,new String[] { “TABLE” });
DOES NOT THROW EXCEPTION

ResultSet tableRs = md.getTables(“null”,”DKIRVAN”,”%”,new String[] { “TABLE” });
DOES NOT THROW EXCEPTION – notice quotes around null

Here are the results from the last code added per your request. I added to the existing code so you have all of the output.
ResultSet tableRs = md.getTables(null,null,”%”,new String[] { “TABLE” });
Was used for the following test output.
ACCESLST
AGLPRDBAD1
AGMASTERCM
AGPAGBMHST
AGPAGBOM
AGPAGBOMH
AGPAGBOMHS
AGPAG34W
AGPAUDWK
AGPAUTHRTY
AGPAU06BW
AGPAVGPR
AGPAVGPRW
AGPBADCOD
AGPBADDEF
AGPBADPRD
AGPBCKDT
AGPBCKDTHH
AGPBCKDTLS
AGPBCKID
AGPBIZTY
AGPBLDWKWK
AGPBOMHLBL
AGPBOMLVL
AGPBOMPLT
AGPBOMRULE
AGPBOMVAL
AGPCLOSED
AGPCNTAC
AGPCRYC1H
AGPCRYC2H
AGPCRYC3H
AGPCRYSC1
AGPCRYSC2
AGPCRYSC3
AGPCRYS100
AGPCRYS101
AGPCRYZ102
AGPCRY100H
AGPCRY101H
AGPCRY102H
AGPCRZ101H
AGPCRZ102H
AGPCUSTGRP
AGPCUSTWRK
AGPDATSEL
AGPDONE
AGPEGGCUST
AGPEGGFLK
AGPEGGREQ
AGPEMAILS
AGPEMFLAT
AGPEMIC2H
AGPEMINATL
AGPEMIREGN
AGPERR01W
AGPEXECSUM
AGPEXPXREF
AGPEXSUMFG
AGPEXSUMRQ
AGPFLREF
AGPFRMXF
AGPFSAUDW
AGPFSBKFD
AGPFSDTAW
AGPFSFD
AGPFSFDHS
AGPFSFDS
AGPFSFDWK
AGPFSFH
AGPFSFHWK
AGPFSFMLR
AGPFSFMLW
AGPFSFTYP
AGPFSIA
AGPFSINPT
AGPFSIP
AGPFSIPHS
AGPFSL01
AGPFSL02
AGPFSL03
AGPFSMSCYR
AGPFSMSCYW
AGPFSND
AGPFSRQST
AGPFSRT
AGPFSTAGIW
AGPFSTFMLW
AGPFSTHOLD
AGPFSTXRFW
AGPFSWCING
AGPFSWFEED
AGPFSWFMLA
AGPFSWIPW
AGPFSXRF
AGPISAFP
AGPISAFPB
AGPISAUD
AGPISAUDB
AGPISAUDBK
AGPISAUDB2
AGPISAUD3
AGPISBCLW1
AGPISBCLW2
AGPISBCLW3
AGPISBCLW4
AGPISBSTFW
AGPISCALC
AGPISCLD
AGPISCLK
AGPISCLKB
AGPISCLKBK
AGPISCLP
AGPISCMBUW
AGPISCMSW
AGPISCNTP
AGPISCPYDW
AGPISCRSBW
AGPISCRSRW
AGPISCRSW2
AGPISCSVP
AGPISCSV1
AGPISCSV2
AGPISCUP
AGPISDAT
AGPISDATB
AGPISDAUD
AGPISDCD
AGPISDCH
AGPISDCP
AGPISDDA
AGPISDDD
AGPISDDH
AGPISDDHB
AGPISDDH1
AGPISDEF
AGPISDEFB
AGPISDLTDW
AGPISDSC
AGPISDSECW
AGPISD0001
AGPISENTRW
AGPISLDEF
AGPISMEM
AGPISMET
AGPISMETB
AGPISNEW
AGPISNEWB
AGPISOVR
AGPISPDL
AGPISPDLB
AGPISPDLBK
AGPISPDLDK
AGPISPLST
AGPISRLD
AGPISROL
AGPISRSN
AGPISSCD
AGPISSEC
AGPISSECB
AGPISSORT
AGPISSPTP
AGPISSRPT
AGPISSYNBW
AGPISSYNC
AGPISSYNCB
AGPISTMC
AGPISTRF
AGPISUA
AGPISUF
AGPISUTCW1
AGPISUTCW2
AGPISXRF
AGPITEM
AGPITEMHS
AGPITEMTST
AGPITEM603
AGPLCPARM
AGPLSCR
AGPLSJP
AGPLSUS
AGPMAJMAS
AGPMAJTYP
AGPMETH
AGPMETHMS
AGPNOMERAD
AGPNOMQRAD
AGPNOM0001
AGPNOM0002
AGPNONDEF
AGPOLDNEW
AGPPARTC
AGPPCPXF
AGPPGRPD
AGPPGRPDH
AGPPGRPDW
AGPPGRPH
AGPPGRPHH
AGPPGRPHW
AGPPGRPR
AGPPGRPRH
AGPPGRPRW
AGPPLANT
AGPPLRVW
AGPPLRVWB
AGPPLRVWB2
AGPPLRVWX
AGPPLTAL
AGPPLTAUD
AGPPLTGRP
AGPPLTLST
AGPPLTMAS
AGPPLTPF
AGPPLTPF06
AGPPMACCW
AGPPMACCW1
AGPPMACCW2
AGPPMACCW3
AGPPMACCW4
AGPPMACCW5
AGPPMACCW6
AGPPMACCW7
AGPPMACMX
AGPPMACRU
AGPPMAUDW
AGPPMDUP
AGPPMERR
AGPPMSPMX
AGPPMTITM
AGPPMTOTAL
AGPPRDCHG
AGPPRDERR
AGPPRDHST
AGPPRDMIX
AGPPRDMIXT
AGPPRDMXF
AGPPRDMX2
AGPPRDMX40
AGPPRMIXT
AGPPWRPT
AGPQRYC2H
AGPRANK
AGPRAWBOM
AGPREB75AD
AGPREB75NA
AGPRENUNIV
AGPREPMXSW
AGPRERUNIV
AGPRETCUST
AGPRETNAGR
AGPRETPAGR
AGPRETQRAD
AGPRETQRNA
AGPRETRAGR
AGPRET25AD
AGPRET25NA
AGPRGRPD
AGPRGRPR
AGPRNCDC
AGPRNCDCH
AGPRNCDCW
AGPRNCDD
AGPRNCDDA
AGPRNCDDH
AGPRNCDDW
AGPRNCDH
AGPRNCDHH
AGPRNCDHS
AGPRNCDHW
AGPRNCDP
AGPRNCDPZ
AGPRNCDR
AGPRNCDRH
AGPRNCDRW
AGPRNCDS
AGPRNCDSH
AGPRNCDSW
AGPRPACIN
AGPRPACRL
AGPRPARMS
AGPRPBOMS
AGPRPB75AD
AGPRPB75AG
AGPRPB75NA
AGPRPCC
AGPRPCLCP
AGPRPCOLD
AGPRPCOLGV
AGPRPCOLX
AGPRPCOVER
AGPRPCQRNA
AGPRPELOG
AGPRPEXP
AGPRPFLDS
AGPRPFLDT
AGPRPFRT
AGPRPNTLOM
AGPRPNUNIV
AGPRPPCKG
AGPRPPGWK
AGPRPPKG
AGPRPPLTNO
AGPRPPLTRG
AGPRPPLTRO
AGPRPPMXS
AGPRPPMXSW
AGPRPPMXY
AGPRPPRTP
AGPRPRQAC
AGPRPRUCOL
AGPRPRUNIV
AGPRPSEL
AGPRPST
AGPRPSYRG
AGPRPTCMPC
AGPRPTCUST
AGPRPTC1A
AGPRPTC2
AGPRPTC3
AGPRPTID
AGPRPTNAGR
AGPRPTPAGR
AGPRPTQA10
AGPRPTQA20
AGPRPTQN10
AGPRPTQN20
AGPRPTQRAD
AGPRPTQRNA
AGPRPTRAGR
AGPRPTR0
AGPRPTSBM
AGPRPTSPW
AGPRPTSPWH
AGPRPTW101
AGPRPT100
AGPRPT101A
AGPRPT102
AGPRPT102H
AGPRPT103
AGPRPT25AD
AGPRPT25AG
AGPRPT25NA
AGPRQS01
AGPRVCPY
AGPRVSBM
AGPRVSCH
AGPRVSCHB
AGPRVSCHX
AGPR101S
AGPR101SH
AGPR101SW
AGPSACUST
AGPSALETY
AGPSECTN
AGPSELRNCD
AGPSELSP
AGPSEL08
AGPSEL12
AGPSEL16
AGPSEL20
AGPSEL21
AGPSEL22
AGPSLSPARM
AGPSRTOPT
AGPSTATE
AGPSUMPGRP
AGPSYSTY
AGPTBLDS
AGPTBLFAC
AGPTBLGRP
AGPTBLID
AGPTBLLN
AGPTBLSL
AGPTBLTY
AGPTRNTYP
AGPUNITS
AGPUSRLIB
AGPVARSEL
AGPWKDP1
AGPWKDP2
AGPWKMN5A
AGPWKMN5B
AGPWKMN6
AGPWKPCPN
AGPWKRQS01
AGPXAAD
AGPXAAP
AGPXAAPD
AGPXAAPOL2
AGPXAAVL
AGPXABM
AGPXABMW
AGPXACAP
AGPXACC
AGPXACD
AGPXACT
AGPXACV
AGPXACVQ
AGPXADCNV
AGPXAEM
AGPXAFRT
AGPXAHFRT
AGPXAIID
AGPXAPC
AGPXAPCH
AGPXAPC06
AGPXAPLERR
AGPXAPLEXC
AGPXAPM
AGPXAPN
AGPXAPTRN
AGPXAQRT
AGPXAQRTD
AGPXARQ
AGPXASP
AGPXAWKM
AGPXAWKS
AGPXAXD
AGPXAXF
AGPXAXP
AGPXAXS
AGP202IDTL
AGQBADPMX1
AGQBADPMX2
AGQBADPMX3
AGQBADPMX6
AGQBADPMX7
AGQBADPMX8
AGQBADPMX9
AGQBRLZ998
AGQCRTMIXT
AGQCRYC1A
AGQCRYC1C
AGQCRYC1H
AGQCRYC1W
AGQCRYC2H
AGQCRYC2H1
AGQCRYC2H2
AGQCRYC2W
AGQCRYC3H
AGQCRYC3W
AGQCRYR0H
AGQCRYR0W
AGQCRYSC1
AGQCRYSC1C
AGQCRYSC2
AGQCRYSC3
AGQCRYSR0
AGQCRYS100
AGQCRYS101
AGQCRYS102
AGQCRYZ101
AGQCRYZ102
AGQCRY100H
AGQCRY100W
AGQCRY101A
AGQCRY101C
AGQCRY101H
AGQCRY101W
AGQCRY102H
AGQCRY102W
AGQCRY103
AGQCRY103A
AGQCRY103B
AGQCRY103C
AGQCRY103W
AGQCRZ101H
AGQCRZ101W
AGQCRZ1011
AGQCRZ102H
AGQCRZ102W
AGQCRZ1020
AGQCRZ1021
AGQCRZ103
AGQCRZ103A
AGQCRZ103B
AGQCRZ103C
AGQCRZ103W
AGQCR103AH
AGQCR103AW
AGQCR103BH
AGQCR103BW
AGQCR103CH
AGQCR103CW
AGQCR103H
AGQCZ103AH
AGQCZ103AW
AGQCZ103BH
AGQCZ103BW
AGQCZ103CH
AGQCZ103CW
AGQCZ103H
AGQDC103AH
AGQDC103BH
AGQDC103CH
AGQDC103H
AGQDLTC1H
AGQDLTC100
AGQDLTC101
AGQDLTC102
AGQDLTC2H
AGQDLTC3H
AGQDLTPGRD
AGQDLTPGRH
AGQDLTPGRR
AGQDLTRNCH
AGQDLTRNDH
AGQDLTRNHH
AGQDLTRNRH
AGQDLTRNSH
AGQDLTR0H
AGQDLTR1SH
AGQDLTR102
AGQDLTZ101
AGQDLTZ102
AGQDZ103AH
AGQDZ103BH
AGQDZ103CH
AGQDZ103H
AGQEGGZ998
AGQEMIREGN
AGQLBADPM1
AGQLCRYC1H
AGQLCR101H
AGQLC103AH
AGQLC103BH
AGQLC103CH
AGQLC103H
AGQLPMXSW
AGQLPMXSW2
AGQLPMXSW3
AGQLRECQRA
AGQLRECQRN
AGQLRENAGR
AGQLREPQRA
AGQLREPQRN
AGQLRPCQRA
AGQLRPCQRN
AGQLRPC1A
AGQLRPC1B
AGQLRPPQNA
AGQLRPPQRA
AGQLRPPQRN
AGQLRPTC1B
AGQLRP101A
AGQLRP101B
AGQLRP102H
AGQLTEP25N
AGQLZ103AH
AGQLZ103BH
AGQLZ103CH
AGQLZ103H
AGQMDLTPWN
AGQMDLTPWO
AGQMFSMSCY
AGQMIFS1
AGQMIFS2
AGQMRPADJS
AGQMRPNALF
AGQMRPNATL
AGQMRPNTLO
AGQMRPPLLF
AGQMRPPLNL
AGQMRPPLNO
AGQMRPPLNT
AGQMRPPLR0
AGQMRPPTRG
AGQMRPREGI
AGQMRPRELF
AGQMSETMBR
AGQMSETPWR
AGQMTBLDS
AGQMTBLLN
AGQMTBLSL
AGQMTRNUSG
AGQPGRPDH
AGQPGRPHH
AGQPGRPRH
AGQPMXSW
AGQQRYPMX5
AGQRECQAPR
AGQRECQNPR
AGQRECQRAD
AGQRECQRAH
AGQRECQRNA
AGQRECQRNH
AGQRECUST1
AGQRENQNPR
AGQRENQRNA
AGQRENQRNH
AGQRENTOTN
AGQREPMADJ
AGQREPQAPR
AGQREPQNPR
AGQREPQRAD
AGQREPQRAH
AGQREPQRA1
AGQREPQRNA
AGQREPQRNH
AGQREPQRN1
AGQREPTA1
AGQREPTN1
AGQREPTOTA
AGQREPTOTN
AGQRERQAPR
AGQRERQNPR
AGQRERQRAD
AGQRERQRAH
AGQRERQRNA
AGQRERQRNH
AGQRERTA1
AGQRERTN1
AGQRERTOTA
AGQRERTOTN
AGQRERUNI1
AGQRETCUST
AGQRETNAGR
AGQRETPAGR
AGQRETQAPR
AGQRETQA10
AGQRETQA20
AGQRETQNPR
AGQRETQN10
AGQRETQN20
AGQRETQRAD
AGQRETQRAH
AGQRETQRNA
AGQRETQRNH
AGQRETRAGR
AGQRETZ998
AGQRET25AG
AGQRE25TN
AGQRNCDCH
AGQRNCDDH
AGQRNCDHH
AGQRNCDR
AGQRNCDRH
AGQRNCDRW
AGQRNCDSH
AGQRPARM
AGQRPBOMS
AGQRPCOVER
AGQRPCQAPR
AGQRPCQNPR
AGQRPCQRAD
AGQRPCQRAH
AGQRPCQRNA
AGQRPCQRNH
AGQRPCUST1
AGQRPNQAPR
AGQRPNQNPR
AGQRPNQRAD
AGQRPNQRAH
AGQRPNQRA1
AGQRPNQRNA
AGQRPNQRNH
AGQRPNQRN1
AGQRPNTA1
AGQRPNTN1
AGQRPNTOTA
AGQRPNTOTN
AGQRPNUNI1
AGQRPPMADJ
AGQRPPMXSW
AGQRPPMXS1
AGQRPPQAPR
AGQRPPQNPR
AGQRPPQRAD
AGQRPPQRAH
AGQRPPQRA1
AGQRPPQRNA
AGQRPPQRNH
AGQRPPQRN1
AGQRPPTA1
AGQRPPTN1
AGQRPPTOTA
AGQRPPTOTN
AGQRPRQAPR
AGQRPRQNPR
AGQRPRQRAD
AGQRPRQRAH
AGQRPRQRNA
AGQRPRQRNH
AGQRPRTA1
AGQRPRTN1
AGQRPRTOTA
AGQRPRTOTN
AGQRPRUNI1
AGQRPTADJ
AGQRPTCMPC
AGQRPTCUST
AGQRPTC1A
AGQRPTC1B
AGQRPTC3A
AGQRPTC3A1
AGQRPTC3B
AGQRPTNAGR
AGQRPTPAGR
AGQRPTQAPR
AGQRPTQA10
AGQRPTQA20
AGQRPTQNPR
AGQRPTQN10
AGQRPTQN20
AGQRPTQRAD
AGQRPTQRAH
AGQRPTQRNA
AGQRPTQRNH
AGQRPTRAGR
AGQRPT101A
AGQRPT101B
AGQRPT102H
AGQRPT25AG
AGQRPZCNT
AGQRPZCOV
AGQRP25TA
AGQRP25TN
AGQRP75BA
AGQRP75BN
AGQRTVC1
AGQRTVC2
AGQRTVC3
AGQRTV100
AGQRTV101
AGQRTV102
AGQRTV103
AGQRTV103A
AGQRTV103B
AGQRTV103C
AGQRTZ101
AGQRTZ102
AGQRTZ103
AGQRTZ103A
AGQRTZ103B
AGQRTZ103C
AGQR101SH
AGQSEPMXSW
AGQSLSPARM
AGQSLSYTDC
AGQSLSYTDD
AGQSLSYTDH
AGQTOP25AD
AGQTOP25NA
AGQTURZ998
AGQUPDREPS
AGQUPDRPPS
AGQUREPMXS
AGQXAPCPN
AGQZ103
AGQZ103A
AGQZ103A2
AGQZ103B
AGQZ103B2
AGQZ103C
AGQZ103C2
AGQZ1032
AGQZ998
AGQ100W
AGRPARMS
AGSQLCOMP
AGSQLSPLCM
AGT100DES
AGT101DES
ARCHSRC
A1REQUEST
BCUSTNAME
CALCDNLD
CALCERRS
CALCULAT
CHECKBOMH
CHECKBOMH2
COMPCDEG
COMPCDWK
COMPWORK
COMPWRK
COMPWRKZZZ
CONSDNLD
CPMIX
CPMIXDL
CPMIXFL
CPMIXHST
CPMIXRQ
CPMIXUT
CRITLOCK
CRTBOMPLTQ
CSTXREF
CUSTMAST
CUSTNAME
CUSTNAMT
DATACOMP
DATACONS
DATADNLD
DATAERRS
DATALOCK
DEFICOMP
DEFIDNLD
DEFIERRS
EGGXXXX
EXECSUM400
GROUPS
GROUPVAL
INGRED
INPADNLD
INPAUDIT
INPDATA
ITEMDATA
LISTCOMP
LISTDEFI
MARPNDSA
MEAT
MEMODATA
MEMODNLD
MEMOERRS
METRICS
NEWDATA
OLDRPPQRAD
OLDRPPQRNA
PEXPWEEK
PLANTDATA
PLANTFILE
PMSPMIX
PROGDEFI
QCLSRC
QCMDSRC
QCPYSRC
QCSRC
QDDSLFSRC
QDDSSRC
QDDSSRCW
QDDSSRCW2
QFTPSRC
QRPGLESRC
QSQLSCR
QSQLSRC
QTXTSRC
REASONS
SALES
SECTDNLD
SECTIONS
SPOOLFILE
SUMMPMIX
SVPRETCUST
TCUSTNAME
TRNAGPXAPC
YRWK0002
CS_CCSIDS
CS_FNTDTA
CS_FNTGLP
CS_FNTMET
CS_FNTNAM
CS_FNTTBL
CS_PATPAG
CS_PATWRK
DDSSRC
AFF0106041
AGRICODE
ARCHSRC
Copy of EMPCNTAC
COMPANY
COMPCODE
COMPCODEHS
DS075606EC
EMIBUSRUL
EMICLODTE
EMIGRDCDE
EMILIVCDE
EMILOCIDS
EMILOCIDSB
EMIPCKCDE
EMIPLTOMT
EMIPROD627
EMIUSRBUS
EMIUSREML
EMIUSRIDS
EMPBEEFWKY
EMPBRCON
EMPBRDOL
EMPBRDPM
EMPBRMNQ
EMPBRNOP
EMPBRPAC
EMPBRPRP
EMPBRTRL
EMPBRWOU
EMPCLOSED
EMPCMPOSIT
EMPCNTAC
EMPCONTRL
EMPDAVPR
EMPEMIUSR
EMPEOD
EMPFLAGS
EMPFTPDIR
EMPGS
EMPGSCAN
EMPGSCAN1
EMPGSUSA
EMPGS0001
EMPMESSUP
EMPPARPT
EMPPARTC
EMPPMXPC
EMPPOSDSP
EMPPOSDY
EMPPOSDYWK
EMPPOSHS
EMPPOSHSWK
EMPPOSHSXC
EMPPOSWK
EMPPRCHS
EMPPRCINW1
EMPPRCINW2
EMPPRCTN
EMPPRCTST
EMPPTEDW
EMPPTERR
EMPQLASTF
EMPQWFLAG
EMPRCVER
EMPSCNOP
EMPSEL02
EMPSEL04
EMPSEL08
EMPSKPLT
EMPSMCX
EMPSMEM
EMPSMINV
EMPSMLG
EMPSMLGI
EMPSMPL
EMPSMPO
EMPSMPR
EMPSMPRPF
EMPSMRL
EMPSMTR
EMPSMTRA
EMPSMTRI
EMPSMTRJ
EMPSMUD
EMPSMUS
EMPSMUSI
EMPSMUSTMP
EMPSUBSCR
EMPTBLDS
EMPUSDADT
EMPUSDAGR
EMPUSDAHD
EMPVARCAP
EMPVARCU
EMPVARCUA
EMPWAVPR
EMPWKDP1
EMPWKDP2
EMPWKDP3
EMPWKMNT08
EMPWKMNT09
EMPWKPRCTN
EMPWKRP1
EMPWKSUBSC
EMPWKVARC2
EMPWKVARC3
EMPWKVARC4
EMPWKVARC5
EMPWKVARD1
EMPWKVARD2
EMPWKVARD3
EMPWKVARPF
EMPWKVARPR
EMPXRFPR
EMP1220
EMQADDSMUB
EMQADDSMUS
EMQANNGRPH
EMQCRTSMCM
EMQCRTSMCX
EMQCRTSMFQ
EMQCRTSMLG
EMQCRTSMMN
EMQCRTSMPR
EMQCRTSMTR
EMQDTLHS
EMQDTLHSS
EMQLSTTRN
EMQMBEEFAN
EMQMBEEFWK
EMQMBIZWIP
EMQMCKVAR
EMQMCKVARA
EMQMCKVARC
EMQMCKVARG
EMQMCMPITE
EMQMCMPWRK
EMQMCUSTF1
EMQMCUSTF2
EMQMCUSTF3
EMQMCUSTP
EMQMCUSTPD
EMQMDAVMO
EMQMDLTBIZ
EMQMDLTBLA
EMQMDLTBLK
EMQMDLTCMP
EMQMDLTPER
EMQMDLTTST
EMQMDLTWKD
EMQMDTLHS
EMQMDTLWIP
EMQMFOBXFR
EMQMFTRNG
EMQMHISTY
EMQMINDEX
EMQMLAMBAN
EMQMLSTSNT
EMQMNODATA
EMQMPMERRF
EMQMPMERRP
EMQMPORKAN
EMQMPOSDUW
EMQMPOSDY
EMQMPOSDYU
EMQMPOSDYW
EMQMPOSTB
EMQMPOSUM
EMQMSHPID
EMQMTBLDS
EMQMTPBT
EMQMUSDA
EMQMUSDAHD
EMQMVARNO
EMQMVCAPE
EMQMWFLAGP
EMQMWFLGSF
EMQMWFLGSP
EMQMWGTPRC
EMQMWKDATA
EMQMWKRP1
EMQMYSDATF
EMQMYSDATP
EMQPUTCLOA
EMQPUTEML
EMQPUTEMLA
EMQPUTGRD
EMQPUTGRDA
EMQPUTLIV
EMQPUTLIVA
EMQPUTLOC
EMQPUTLOCA
EMQPUTPCK
EMQPUTPCKA
EMQPUTPLO
EMQPUTPLOA
EMQPUTPRC1
EMQPUTPRC2
EMQPUTPRC3
EMQPUTPRC4
EMQPUTPRC5
EMQPUTPRC6
EMQPUTPRD
EMQPUTPRDA
EMQPUTPR3A
EMQPUTRULA
EMQPUTSHP
EMQPUTSHPA
EMQPUTUSB
EMQPUTUSB2
EMQPUTUSR
EMQPUTUSRA
EMQPUTUSRE
EMQRNGWK1
EMQSUMUSRE
EMQUPDEML
EMQUPDITM
EMQUPDLOC
EMQUPDPLO
EMQUPDPRD
EMQUPDRUL
EMQUPDSMUB
EMQUPDUID
EMQUPDUSR
EMQWEEKGR
EMSQLANNUL
GK15200422
GRASDFD1ET
LKSUSDADT
LSPUSDADT
MOUNTAIRE_
QCLSRC
QCMDSRC
QDDSSRC
QFTPSRC
QRPGLESRC
QSQLSRC
QTXTSRC
SFIECSV107
TESTMEETXT
TESTYOUETX
ARCHSRC
COUNT
CPYTRANS
EGGSAL
EMI
GNPBKUP
GNPCKSN
GNPCPREQ
GNPCRTWK
GNPDBROR
GNPDLQUE
GNPDOORCPY
GNPDORSN
GNPDPTMS
GNPDSPFFD
GNPEMPMS
GNPEMPTY
GNPEQPTHS
GNPEQUIP
GNPEXEC
GNPFDACCP
GNPFDSELO
GNPFILEX
GNPFTPST
GNPFTPUT
GNPGRTUS
GNPIFS
GNPIFSLIB
GNPISASCI
GNPJBACT
GNPJBADT
GNPJBAMM
GNPJBCTL
GNPJBDTL
GNPJBSUMMY
GNPJOBQ
GNPJOBSCDE
GNPLWFLD
GNPMENU
GNPMNUSR
GNPMNUSRB
GNPMNUSRWK
GNPNVEND
GNPOBUSG
GNPPCIMP
GNPPCMON
GNPPRDLB
GNPPRJDT
GNPPRJREA
GNPPRODSEC
GNPSAVLIB
GNPSBMREF
GNPSBMXRF
GNPSBUMS
GNPSQLPRO
GNPTAPDV
GNPUSMSG
GNPWEBWRD
GNPWKPRJ
GNPWKSELCM
GNPWKSELOB
GNPWKSELPJ
GNPWKS01
GNPWORKF3
GNPXASEQ
GNQMALLPRJ
GNQMEMPJ
GNQMEMSBU
GNQMOPNPRJ
GNQMPJEM
GNQMPJEM1
IFSTOOLSRC
LEGQTRS
MESSFILE
MKPBDIR
MKPDBR
MKPDTAI
MKPFLIST
MKPFLNM
MKPLFATR
MKPMBR
MKPMODL
MKPOBJD
MKPPFATR
MKPPGMS
MKPPLIST
MKPPREF
MKPSRVC
MKPTRG
QCLSRC
QCMDSRC
QCPYSRC
QDDSSRC
QDDSSRCW
QFTPSRC
QQMQRYSRC
QRNCVTLG
QRPGLESRC
QRPGSRC
QSQLSRC
QSRVSRC
QTXTSRC
ARCHSRC
BACKUP
FOLDERS
GETTR
LW
MULTITABLE
NN
QAAPFILE$
QAAPFILE#
QAAPFILE@
QADSPFFD
QAFCPFDDTA
QAFCTUTDBF
QAFCTUTOR
QAFCXMPAI2
QAFCXMPAI3
QAFCXMPAI4
QAFCXMPAI5
QAFCXMPEIA
QAOEFFVL
QASMLSYM$
QASMLSYM#
QASMLSYM@
QASUUSRPMT
QAUOOPT
QAYPEASM
QAYPEASPI
QAYPEBASE
QAYPECFGI
QAYPECMN
QAYPEDASD
QAYPEDSRV
QAYPEEVENT
QAYPEFILSV
QAYPEFQCFG
QAYPEFTRI
QAYPEHEAP
QAYPEHMON
QAYPEHTOT
QAYPEIAD
QAYPEJVA
QAYPEJVCI
QAYPEJVMI
QAYPEJVNI
QAYPELBRKT
QAYPELCPLX
QAYPELJOB
QAYPELLIC
QAYPELMET
QAYPELMI
QAYPELNAMT
QAYPELNUMT
QAYPEMBRKT
QAYPEMICPX
QAYPEMIPTR
QAYPEMIUSR
QAYPEPASE
QAYPEPGFLT
QAYPEPPANE
QAYPEPROCI
QAYPERLS
QAYPERMPM
QAYPERMSL
QAYPERUNI
QAYPESAR
QAYPESEGI
QAYPESTATS
QAYPESYNC
QAYPETASKI
QAYPETBRKT
QAYPETIDX
QAYPETSKSW
QAYPEUSRDF
QCBLLESRC
QCBLSRC
QCLSRC
QCMDSRC
QCSRC
QDDSSRC
QDNDHLDR
QDNDHMRD
QEWCKBDMAP
QEWCSCNFMT
QEWCSRC
QEWLSRC
QFMTSRC
QINVREC
QLBLSRC
QMNUSRC
QORDDTL
QORDHDR
QPFDBR
QPNLSRC
QREXSRC
QRJXSRC
QRPGLESRC
QRPGSRC
QSALEREC
QSRVSRC
QTBLSRC
QTXTSRC
TR
USERS
AGPISAFP
AGPISAUD
AGPISCALC
AGPISCLD
AGPISCLK
AGPISCLP
AGPISCMSW
AGPISCNTP
AGPISCPYDW
AGPISCRSBW
AGPISCRSW2
AGPISCUP
AGPISDAT
AGPISDAUD
AGPISDCD
AGPISDCH
AGPISDCP
AGPISDDA
AGPISDDD
AGPISDDH
AGPISDDHB
AGPISDDHBK
AGPISDEF
AGPISDLTDW
AGPISDSC
AGPISENTRW
AGPISLDEF
AGPISMEM
AGPISMET
AGPISNEW
AGPISNEWB
AGPISOVR
AGPISPDL
AGPISPLST
AGPISRLD
AGPISROL
AGPISRSN
AGPISSCD
AGPISSEC
AGPISSORT
AGPISSPTP
AGPISSRPT
AGPISSYNBW
AGPISSYNC
AGPISTMC
AGPISTRF
AGPISUF
AGPISUTCW1
AGPISUTCW2
AGPISXCL
AGPISXRF
AGPLSUS
AGPXAAP
AGPXAAPD
AGPXACAP
AGPXADCNV
AGPXAPM
AGPXARQ
AGPXAWKM
AGPXAWKS
CALCULAT
CALCULATE
CLDNO630M
CRITLOCK
DATACOMP
DATACOMPB
DATALOCK
DEFICOMP
GNPEMPMS
GNPISASCI
GNPJOBQ
GNPPCIMP
GNPPCMON
GNPXASEQ
INPAUDIT
LISTCOMP
LISTDEFI
LOGFILE
MEMODATA
METRICS
NEWDATA
PROGDEFI
QAQQINI
QCLSRC
QCMDSRC
QCPYSRC
QDDSSRC
QFTPSRC
QRPGLESRC
QTXTSRC
REASONS
SECTIONS
TESTTHIS
BVPFLDDS
BVPFLDKY
BVPFREF
BVPMAST
CFGDTA
DFLTFORM
H
KEPFREF
KEYWRDS
MEMBEX
MEMFREF
MEPFLDDS
MEPFLDKY
MESOURCE
OVPFILE
OVPFLDDS
OVPFLDKY
OVPFREF
OVSOURCE
QMFORM
QMF001PF
QMQRY
QPFS91
QQMFORMSRC
QQMQRYSRC
SQLFREF
SQLJLOG
SQLUSERS
SQL4LFRF
SQL4LHQ
SQL4LSQ
SQPFLDDS
SQPFLDKY
AGPCRYS101
AGPCRYS102
ARCHSRC
BUCKET
BUCKNUM
CATNUM
CCODENUM
CGBC
CODECAT
CODENUM
COMPANY
COMPCODE
COMPCODERC
COMPCODESV
COMPNUM
DELNUM
FPNUM
FPPLANT
GROUPNUM
GROUPS
GROUPVAL
INGRED
INGRNUM
KILLNUM
KPLANT
MAINCAT
MARIN
MARINNUM
MCNUM
MEAT
MEATNUM
QCLSRC
QDDSSRC
QRPGLESRC
QTXTSRC
TUQMCCSETC
agri400.emlib.friday_egg_index
AAAA
AGPBADPMIX
AGPBADPMX
AGPBADPMX1
AGPBADPMX4
AGPBADPMX6
AGPBADPMX8
AGPBET75NA
AGPBOT75AD
AGPBOT75NA
AGPCOVER
AGPCRYR0H
AGPCRYSR0
AGPCRYS102
AGPCRYZ101
AGPCRY103
AGPCRY103A
AGPCRY103B
AGPCRY103C
AGPCRZ103
AGPCRZ103A
AGPCRZ103B
AGPCRZ103C
AGPCR103AH
AGPCR103BH
AGPCR103CH
AGPCR103H
AGPCUSTRAD
AGPCZ103AH
AGPCZ103BH
AGPCZ103CH
AGPCZ103H
AGPQRYC2H1
AGPQRYC2H2
AGPQRYPMX3
AGPRECQRAD
AGPRECQRNA
AGPRENQRNA
AGPRENTOTN
AGPREPADJ
AGPREPQRAD
AGPREPQRNA
AGPREPTOTA
AGPREPTOTN
AGPRERQRAD
AGPRERQRNA
AGPRERTOTA
AGPRERTOTN
AGPRETQA10
AGPRETQA20
AGPRETQN10
AGPRETQN20
AGPRPADJS
AGPRPCQRAD
AGPRPNQRAD
AGPRPNQRNA
AGPRPNTOTA
AGPRPNTOTN
AGPRPPQRAD
AGPRPPQRNA
AGPRPPTOTA
AGPRPPTOTN
AGPRPRQRAD
AGPRPRQRNA
AGPRPRTOTA
AGPRPRTOTN
AGPRPTC1B
AGPRPT101B
AGPTEP25NA
AGPTOP25AD
AGPTOP25NA
AGPTOT25AD
AGP100W
GPRPCQRAD
MIKETST
SILVIATEST1
SILVIATEST2
TESTDETL
TESTMAST
TESTMYMASTER12CHARACTERSTOTHELEFT
BENCHMARK
BROILER_CATEGORY
BROILER_INDEX
BROILER_INDEX_CATEGORY
BROILER_INDEX_GRAPH_PAGE
BUSINESS_GROUP
Copy of EMPAG002
COMMODITY_CATEGORY_TYPE
COMMODITY_GROUP_REPORT_LINE
COMMODITY_REPORT
COMMODITY_REPORT_GROUP
COMMODITY_REPORT_LINE_DESCRIPTION
EGG_FRIDAY_INDEX
EGG_NATIONAL_PRICE
EMI_REPORT_LINE
EMIPRDMST
EMIPRDPRC1
EMIPRDPRC2
EMIPRDPRC3
EMIPRDPRC4
EMISHPCDE
EMIUSER1
EMPAGCAN
EMPAGCAN1
EMPAGUSA
EMPAG001
EMPAG002
EMPANNGR
EMPBEEFANN
EMPCMPSIT
EMPCMPSITW
EMPINDEX
EMPLAMBANN
EMPLSTTRN
EMPPORKANN
EMPQCUSTF
EMPQNODAT1
EMPQPMERR
EMPQSLDLB
EMPQWFLAGS
EMPQYSDATA
EMPSMCM
EMPSMFQ
EMPSMNN
EMPTPAVGPR
EMPTY_NEW_IDS
EMPWGCAN
EMPWGCAN1
EMPWG001
EMPWG002
EMPWKDATA
INSANITY
PPT_EMI_AS_XREF
REPORTWEEK
TEMP1
US_BROILER_WEEKLY_POUNDS
WOG_COMPOSITE_CATEGORY
WOG_COMPOSITE_EMPLNID
GNPATHS
GNPBACKUP
GNPPATHS
CONVRATES
productName=DB2 UDB for AS/400
supportCatalogs=false
supportSchemas=true
Catalogs :
AGRI400
Schemas :
#COBLIB
#LIBRARY
#RPGLIB
ACTIVEXSDK
AGLIB
ASCC
ASCCTOOLS
ASN
CANEMI
CGIDEV2
CRTPLFLIB
CVTSPLV4R1
DBFEXE
DBUINSTALL
DBU60
DIRECTORY
DKIRVAN1
DKIRVAN2
DOUG
EGGEMAIL
EMLIB
EMTRKY
EMTST
ET124133
ET144041
FMOSS
GDESS
GNLIB
IFSLIB
IFSLIB2
IFSTOOL
JATKINSO
LCONSTAN
LCPGMR
LKSAGLIB
LKSEGGS
LKSEGGS2
LKSEGGS3
LKSEGGS4
LKSHELL
LKSSALES
LS112025
LS141452
LYNNJRN
MBPFR
MMAIL
MMOFFITT
MPGLIB
NETSEND
PDSQLCOL
PKZ560
QADMBKUP
QADMDISTP
QAFP
QAFPLIB1
QAFPLIB2
QAFPLIB3
QBRM
QCAEXP
QCAP3
QCA400W
QCBL
QCBLLE
QCBLLEP
QCE3
QCLE
QCPPLE
QDEVTOOLS
QDIRSRV2
QDNS
QDOC
QDP4
QDSNX
QFAX
QFNTCPL
QFPNTWE
QGPL
QGPLTEMP
QGY
QHLPSYS
QHTTP
QHTTPSVR
QICSS
QICU
QIJS
QINMEDIA
QINPRIOR
QINSYS
QIWA
QIWA2
QIWS
QIXWSA
QJAVA
QJT400
QLBL
QMGTC
QMGTC2
QMPGDATA
QMSE
QPASE
QPC5250K
QPC5250P
QPC5250T
QPDA
QPFR
QPFRDATA
QPFRD52001
QPFRD53001
QQALIB
QQFTEMP
QQRYLIB
QRCL
QRDARS
QRECOVERY
QRJE
QRPG
QRPGLE
QRPGLEP
QRPG38
QRPLOBJ
QSHELL
QSPL
QSPTLIB
QSQL
QSRV
QSRVAGT
QSYS
QSYSCGI
QSYSDIR
QSYSINC
QSYS2
QSYS2924
QTCP
QTEMP
QTILIB
QTMELCF
QUSRBRM
QUSRDIRDB
QUSRIJS
QUSRINFSKR
QUSRRDARS
QUSRSYS
QUSRTEMP
QWIN16
QWIN16D
QWIN16S
QWIN32
Q1ABRMSF
Q1ABRMSF01
RESTORE
SASINPDEV
SASINPUT
SASJUNK
SASMITH
SASMITHX
SASPMS
SHLIB
SQLINSTALL
SQLPRO
SUPPLYMGR
SYSIBM
TEMP_SQL
TMAIL
TULIB
TWINTER
WHLIB
supportCatalogsInDataManipulation=false
supportCatalogsInTableDefinitions=false
supportCatalogsInDataProcedureCalls=false
Catalogs :
AGRI400
Schemas :
#COBLIB
java.sql.SQLException: [SQL0901] SQL system error.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:485)
at com.ibm.as400.access.AS400JDBCDatabaseMetaData.getTables(AS400JDBCDatabaseMetaData.java:4134)
at HelloJavaPkg.As400Test.testGetCatalogsSchemasTables(As400Test.java:122)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:478)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)

March 14, 2006 at 9:22 am #248533 Reply
Haris Peco
Member
Yes, what I said is correct in that

ResultSet tableRs = md.getTables(null,”DKIRVAN”,”%”,new String[] { “TABLE” });
THROWS EXCEPTION

ResultSet tableRs = md.getTables(“DKIRVAN”,null,”%”,new String[] { “TABLE” });
DOES NOT THROW EXCEPTION

ResultSet tableRs = md.getTables(null,null,”%”,new String[] { “TABLE” });
DOES NOT THROW EXCEPTION

ResultSet tableRs = md.getTables(“null”,”DKIRVAN”,”%”,new String[] { “TABLE” });
DOES NOT THROW EXCEPTION – notice quotes around null

This is your jdbc driver problem (i suppose that you use existing schema DKIRVAN1, but no DKIRVAN)
This is getTables description from JDBC API
```
ResultSet getTables(String catalog,
                    String schemaPattern,
                    String tableNamePattern,
                    String[] types)
                    throws SQLException
```
first parameter is catalog and this :

ResultSet tableRs = md.getTables(null,null,”%”,new String[] { “TABLE” });

is ok – it return all tables

ResultSet tableRs = md.getTables(“DKIRVAN”,null,”%”,new String[] { “TABLE” });

isn’t good – it have to throw exception (catalog DKIRVAN doesn’t exists) or return no one tables

ResultSet tableRs = md.getTables(null,”DKIRVAN1″,”%”,new String[] { “TABLE” });

this mustn’t throw exception – if schema DKIRVAN doesn’t exists then it have to return no one table, and
with DKIRVAN1 must return tables from schemas DKIRVAN1 (getSchemas claim that DKIRVAN1 exists)

Your JDBC driver is broken – getSchemas or getTables is wrong.I advice you that you find latest driver or if you have latest driver then you ask for this problem on IBM forum or support – just send getSchemas output
and ResultSet tableRs = md.getTables(null,”DKIRVAN1″,”%”,new String[] { “TABLE” }); where DKIRVAN1 is some name form getSchemas list

You are welcome for further help.

Best
March 14, 2006 at 3:00 pm #248575 Reply

dkirvan
Member

Thank you for your help. I have found the problem. In the Database Explorer Preferences screen there is a check box “Load all database metadata when connection establised”. This was not checked. I checked it and then restablished a connection and all tables were shown and table information was provided in the Table Info screen. The information shown looks great.

March 14, 2006 at 4:04 pm #248583 Reply

Haris Peco
Member

Can you try next, please

– select one concrete table, right click and call Refresh

Do you throw exception in error log ?

Thanks

March 15, 2006 at 7:23 am #248612 Reply

dkirvan
Member

No exception was thrown. I cleared the log file first then checked it after the refresh and the log file was empty.

Thank you for the follow up.

March 15, 2006 at 7:23 am #248613 Reply

dkirvan
Member

No exception was thrown. I cleared the log file first then checked it after the refresh and the log file was empty.

Thank you for the follow up.
Author

Posts

Viewing 9 posts - 16 through 24 (of 24 total)

← 1 2