[IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL] SQL 0113 Name "*N" Not allowed

Problem

Impromptpu 5.0, 6.x, and 7.0 Description: Unable to start Impromptu. Clicked Catalog, Tables and noticed an extra schema level with the name *N on the catalog tables side which is not in the database. Can this extra level be removed from the catalog? Error Message - [IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL] SQL 0113 Name "*N" Not allowed Solution: To remove the extra schema level follow these steps - 1. Make a backup of your current catalog. 2. Locate the Impromptu.ini that should be located in one of the following locations - Impromptu 5.0 \Cognos\Impromptu 5.0\User Workspace\impromptu.ini Impromptu 6.x \Cognos\cer1\bin\impromptu.ini Impromptu 7.0 \Cognos\cer2\bin\impromptu.ini 3. Open this file in your favorite text editor and add the following to the [Startup Options] section - Schema Leveling Mode=1 4. Save the file. 5. Start Impromptu and open the catalog. 6. Connect to the database if prompted. Click Catalog, Tables. 7. Select the level you want to remove and click the Remove Level button. 8. Close Impromptu. Open the Impromptu.ini file and remove the line you added in Step 3 (Schema Leveling Mode=1). Save the file. 9. Start Impromptu and open the catalog. Click Catalog, Tables and retrieve the tables from the database. The Add and Alias buttons should work for the database tables.