Fie-AID for DB2 : Table not found



Compuware's data management products: File-AID for IMS, File-AID/MVS, File-AID for DB2 and DBA-XPERT for DB2

Fie-AID for DB2 : Table not found

Postby ZeBlackRider » Wed Feb 15, 2012 5:44 am

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.
ZeBlackRider
 
Posts: 3
Joined: Wed Feb 15, 2012 5:35 am
Has thanked: 0 time
Been thanked: 0 time

Re: Fie-AID for DB2 : Table not found

Postby NicC » Wed Feb 15, 2012 1:47 pm

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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Fie-AID for DB2 : Table not found

Postby ZeBlackRider » Wed Feb 15, 2012 11:51 pm

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 ;) .
ZeBlackRider
 
Posts: 3
Joined: Wed Feb 15, 2012 5:35 am
Has thanked: 0 time
Been thanked: 0 time

Re: Fie-AID for DB2 : Table not found

Postby Robert Sample » Thu Feb 16, 2012 12:36 am

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.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: Fie-AID for DB2 : Table not found

Postby ZeBlackRider » Thu Feb 16, 2012 12:39 am

OK, I understand, thank you.
ZeBlackRider
 
Posts: 3
Joined: Wed Feb 15, 2012 5:35 am
Has thanked: 0 time
Been thanked: 0 time

Re: Fie-AID for DB2 : Table not found

Postby Sithal » Thu Jan 02, 2014 9:18 pm

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'.
Sithal
 
Posts: 1
Joined: Thu Jan 02, 2014 9:04 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Fie-AID for DB2 : Table not found

Postby pranav283 » Mon Mar 23, 2015 1:57 am

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
pranav283
 
Posts: 47
Joined: Sat Aug 30, 2014 3:52 pm
Has thanked: 2 times
Been thanked: 0 time


Return to File-AID