Testing Long File Names on the IBM i

Before running Installation Workbench, you may need to rebuild the cross-reference table. This table enables tables of long (more than 10 characters) file names to be created on the IBM i. Rebuilding the table causes your system to be in a restrictive state. Coordinate this activity with the system administrator.

To test long file names on the IBM i:

1. Log on to the IBM i as QSECOFR.

2. On the command line, enter STRSQL.

   This command will start a SQL session on the IBM i.

3. To test a long file name, enter this SQL statement:

   CREATE TABLE QGPL\LONGFILENAME (FIELD CHAR(10))

   where LONGFILENAME is the name of your file.

   Your system is ready if the file is created in the QGPL library. You can ignore the journal setting.

4. To remove the file that you just created in the QGPL library, enter the following SQL statement:

   DROP TABLE QGPL\LONGFILENAME

   Note: If you are unable to create the table with a long name, likely your system cross reference tables are corrupt. You must rebuild them before proceeding. Refer to Rebuilding Cross Reference Tables on the.