File-Aid for DB2 - How to solve Table Not Found error

Some times you may receive “Table not found” error in file-aid for Db2 as shown below.

 File-AID for DB2 ----------------- Browse Options ------------ Table not found

 COMMAND ===>                                                  SCROLL ===> CSR 

                                                                 SSID ===> DB0T

 Specify DB2 Table (* or pattern for list)                                     

   Location ID ===>                        Optional:                           

   Creator     ===> MYTESTDB                  Database    ===>                 

   Table Name  ===> *                         Tablespace  ===>                 

                                                                               

 Specify Selection Criteria Information:                                       

   Selection Criteria usage ===> T   (T-Temporary, M-Modify, E-Existing, N-None)

   Criteria Display Format  ===> T   (T-Template, S-SQL)                       

   Criteria Dataset Name    ===>                                                

   Member                   ===> S1       (Blank or Pattern for list)          

                                                                               

 Specify Browse Options:                                                        

   Initial Display Mode   ===> 1           (1 - Table, Multiple rows per screen

                                            2 - Row, One row per screen)       

   Use Uncommitted Read   ===> YES         (Yes or No)                          

   Maximum Rows To Select ===> 2000        (* for all rows)                    

   Relationship File      ===>                                                 

                                                                               

                                                                                

To solve the error, type the work ‘EXPAND’ on the COMMAND LINE, put the cursor on the Table Name field, and press Enter.

                                                                                

 File-AID for DB2 ----------------- Browse Options ------------ Table not found

 COMMAND ===> expand                                           SCROLL ===> CSR 

                                                                 SSID ===> DB0T

 Specify DB2 Table (* or pattern for list)                                     

   Location ID ===>                        Optional:                           

   Creator     ===> MYTESTDB                  Database    ===>                 

   Table Name  ===> *                         Tablespace  ===>                 

                                                                               

 Specify Selection Criteria Information:                                       

   Selection Criteria usage ===> T   (T-Temporary, M-Modify, E-Existing, N-None)

   Criteria Display Format  ===> T   (T-Template, S-SQL)                       

   Criteria Dataset Name    ===>                                               

   Member                   ===> S1       (Blank or Pattern for list)          

                                                                               

 Specify Browse Options:                                                       

   Initial Display Mode   ===> 1           (1 - Table, Multiple rows per screen

                                            2 - Row, One row per screen)       

   Use Uncommitted Read   ===> YES         (Yes or No)                         

   Maximum Rows To Select ===> 2000        (* for all rows)                    

   Relationship File      ===>                                                 

                                                                               

                                                                                

                                                                               

                                                                               

A new panel is shown. Note that you now see the characters that were in the Table Name Field that you couldn’t see before. Clear out the extra characters and continue. This should solve the issue.

 Essssssssssssssssssssssssssssssss RETAINTN+0 sssssssssssssssssssssssssssssssssN

 e                                                          Line   1 of      2 e

 e Command ===>                                             Scroll ===> PAGE   e

 e                                                                             e

 e *                                           XXXXX                           e

 e                                                                             e

 e                                                                             e

 e                                                                             e

 e                                                                             e

 e                                                                             e

 e                                                                             e

 e                                                                             e

 e                                                                             e

 e                                                                             e

 e                                                                             e

 e                                                                             e

 e                                                                             e

 e                                                                             e

 e                                                                             e

 e                                                                             e

 e                                                                             e

 e                                                                             e

 e                                                                             e

 DsssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssM

Second work-around is, type the work ‘ZCLRSFLD’ on the COMMAND LINE, put the cursor on the Table Name field, and press Enter.

 File-AID for DB2 ----------------- Browse Options ------------ Table not found

 COMMAND ===> ZCLRSFLD                                         SCROLL ===> CSR 

                                                                 SSID ===> DB0T

 Specify DB2 Table (* or pattern for list)                                     

   Location ID ===>                        Optional:                           

   Creator     ===> MYTESTDB                  Database    ===>                 

   Table Name  ===> *                         Tablespace  ===>                 

                                                                                

 Specify Selection Criteria Information:                                       

   Selection Criteria usage ===> T   (T-Temporary, M-Modify, E-Existing, N-None)

   Criteria Display Format  ===> T   (T-Template, S-SQL)                        

   Criteria Dataset Name    ===>                                               

   Member                   ===> S1       (Blank or Pattern for list)          

                                                                               

 Specify Browse Options:                                                       

   Initial Display Mode   ===> 1           (1 - Table, Multiple rows per screen

                                            2 - Row, One row per screen)       

   Use Uncommitted Read   ===> YES         (Yes or No)                         

   Maximum Rows To Select ===> 2000        (* for all rows)                    

   Relationship File      ===>