Need Help

[unknown45]

I'm relatively new to db2 so this may be a simple question.... We are trying to get a barcode system up adn running. We have 2 sorces of data one for a as400 and another from a db2 server, i got the as400 one to work but on the db2 from within the label program you pick a table on the server and pick what feilds you want then when you go to print your suposed to be able to hit a browse button and view all the records in the table but i get an error message saying the tabel or feild could not be found it says... misjai.location notfound misjai is my sign on to the system and location is the tabel... i tested i t who ever signes on it inserts there name in front of the location i think thats why it can't find it so how can i get it to now insert my userid ... also if you an tips on setting up my connection i might have did somehting wrong . Any help is much apperciated..
Thanks

 

[nostricon]

The insertion of the user name in front of the table name is the 'schema' that you are accessing within the database: when you logon, by default, SQL statements not explicitly provided with a schema (in the form 'schema_name.table_name') will attempt to use the schema associated with your user name whether one exists or not. You can work around this by coding explicitly for the schema name for this table. When you provide the schema, it doesn't take your username.

If you don't know the schema, you can find out by connecting to the database and running the command 'list tables for all' from the command line: this will list all tables and their associated schemas.