Fie-AID for DB2 : Table not found

[ZeBlackRider]

Hello,
I've got a problem with File-AID for DB2, when I want to browse a table, I've the "Table not found".
If I do a request via SPUFI, I see the content of the table.
Can someone help me to solve m'y problem. Thank you.

[NicC]

You may possubly have specified the wrong DB2 susbsystem in your file-aid setup. Other than that the only people who can help are your own support people.

[ZeBlackRider]

Thank you for your response.
I've the good DB2 subsystem, with all the settings like other people, I've the message explain above and my own support people can't help me. I thought I will find more competent people like you here .

[Robert Sample]

Can someone help me to solve m'y problem.

It is not likely that anyone on this forum can help you. Your problem is something specific to YOUR site, and hence only someone working at your site will be able to assist you. The problem could be the File Aid configuration for your TSO user id (including a parameter value you changed for whatever reason), the site File Aid configuration, the way DB2 is running at your site, or many other possible causes. You need to work with your site support group, coworkers, and/or team leader to identify the problem and resolve it.

[ZeBlackRider]

OK, I understand, thank you.

[Sithal]

This post might be old. But I am just replying to this as it would help many others who come across this problem.

Sometimes table not found can occur because of "Invalid table name".

Place the cursor on the space where we specify the table name and then press SHIFT+F1 key, in the screen that appears, if there is any junk character already present, then clear out that and enter the correct table name here.

Press F3 key and then ENTER.

Hope this might be one of the solutions for 'Table not found'.

[pranav283]

Hi,

Please share the SQLCODE for the query. I think it might be -204 which (object not defined).

The reason for such an anomaly is that:
when you use IKJEFT01 or Fileiad for DB2 to process a SQL query, you have to suffix the table name with a suitable qualifier (which in most of the cases in the schema of the database).
Eg:

If our intention is somewhat like: SELECT * FROM EMP_TABLE;
then you have to code like this : SELECT * FROM <QUALIFIER>.EMP_TABLE;

But querying it through SPUFI or QMF, you are extempted from using this qualifier.

Thanks,
Pranav