facebook
  1. MyEclipse IDE
    2.  > 
  2. Installation, Configuration & Updates

MyEclipse DB Explorer is not displaying the DB2 tables

💡
Our Forums Have Moved

For help with installation, bugs reports or feature requests, please head over to our new forums.
Genuitec Community on GitHub

  1. MyEclipse IDE
    2.  > 
  2. Installation, Configuration & Updates
Viewing 9 posts - 16 through 24 (of 24 total)
1 2
  • Author
    Posts
  • March 10, 2006 at 12:43 pm #248311

    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

    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

    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

    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

    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

    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

    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

    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

    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
Reply To: MyEclipse DB Explorer is not displaying the DB2 tables

You must be logged in to post in the forum log in