Hello,
I'm new to sybase and have been given the task of trying to fix up an old database that was written several years ago. It runs under PowerBuilder 7.0

So far I have been able to get a list of the tables using interactive SQL

select id, name, type from sysobjects;

Give a long table that looks like

100199,'TRANS_TYP','U'
100200,'STF_NME','U'
100201,'STF','U'
100202,'PRNT_PHN','U'
100203,'PRNT_NME','U'
100204,'AGE_CAT','U'
100205,'FEES','U'
100206,'rev_temp','U'
100207,'AR_PROCESSED','U'

I understand that U stands for User Tables and should be the ones I am interested in.

For instance
select * from FEES;

Gives me an error "Error at line 1 Table 'FEES' not found"

I have tried a few variations and haven't had much luck. Was I incorrect on the table name? Any help would be appreciated.

-----------------------------------------------------------------------------------------------------
Found the fault! It seems the dba account I was given didn't have the correct permissions. I found the correct one and now it works.
Thanks!

You also need to consider the uid
user_name(uid)
assuming the database uid belongs to mark then
then select * from mark.FEES