AS/400 Toolbox for Java -- Beta 1 Readme

Workstation Requirements

OS/400 Requirements

Client Setup

Configuration

  1. Download tb400.exe. This is the self-extracting zip file that contains the client code.
  2. Run tb400.exe to copy the class files to the workstation. When prompted, specify the location of the files. The default is c:\tb400.
  3. Add AS/400 Toolbox for Java to your classpath. For example, add the following to your classpath: c:\tb400\classes\ibmtb400.zip
  4. Class documentation is in javadoc output and an API Reference. The starting point for this information is c:\tb400\doc\api_users_guide.html.

Java Applications

The only requirement is to change the classpath environment variable so it also points to the AS/400 Toolbox for Java classes.

Java Applets

Restrictions

National Language Enabling

JDBC

The following methods on the DatabaseMetaData class are not supported in this beta version:

  getBestRowIdentifier(String, String, String, int, boolean)
  getColumnPrivileges(String, String, String, String)
  getCrossReference(String, String, String, String, String, String)
  getExportedKeys(String, String, String)
  getImportedKeys(String, String, String)
  getIndexInfo(String, String, String, boolean, boolean)
  getPrimaryKeys(String, String, String)
  getProcedureColumns(String, String, String, String)
  getProcedures(String, String, String)
  getTablesPrivileges(String, String, String)
  getTypeInfo()
  getVersionColumns(String, String, String)

DatabaseMetaData.getColumns() returns a value for every parameter, but in some cases the returned value is an empty string or a 0. These values are returned as specified by the JDBC API:

     
  TABLE_CAT - returns the table catalog                                        
  TABLE_SCHEMA - returns the table schema                                      
  TABLE_NAME - returns the table name                                          
  COLUMN_NAME - returns the column name                                        
  TYPE_NAME - returns the data source type name                                
  COLUMN_SIZE - returns the column size                                        
  BUFFER_LENGTH - per API, not used, returns 0                                 
  DECIMAL_DIGITS - returns the number of fractional digits                     
  NUM_PREC_RADIX - returns the radix                                           
  SQL_DATA_TYPE - per API, not used, returns 0                             
  SQL_DATATIME_SUB - per API, not used, returns 0                          
These values are always returned as follows:
  DATA_TYPE - returns 0                                                    
  NULLABLE - returns 0                                                     
  REMARKS - returns empty string                                           
  COLUMN_DEF - returns empty string                                        
  CHAR_OCTET_LENGTH - returns 0                                            
  ORDINAL_POSITION  - returns 0                                            
  IS_NULLABLE - returns empty string                                       

The following are not supported in the JDBC driver at this time:

Known Problems

OS/400 Configuration Notes