You will also need to know the CREATOR ID of the table as the table will need to be prefixed by this qualifier. For example, if userid BOB created a table named CUSTOMER, then in order to access the table you would referenced it as BOB.CUSTOMER (unless BOB created the table under a different CREATOR name).
Dig Deeper on IBM DB2 management
Related Q&A from Craig S. Mullins
Our expert suggests that the best way to pass the SAP BW exam is to have hands-on job experience. But that's not all he has to say about ... Continue Reading
To export data from a DB2 table to a flat file, you need to run an export specifying the proper file format. The export utility exports data from a ... Continue Reading
Craig Mullins recommends two specific resources for learning how to create and support Binary Large Objects (BLOB) in DB2. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.