Problem solve Get help with specific problems with your technologies, process and projects.

Do DB2 UDB servers support a library list?

I connected through to DB2 on OS/390 for the first time with the iSeries using connect statement. I then issued a connect reset. Now when I issue SQL in STRSQL, I get the error "TABLEXXX in USERID *N not found." Instead of searching for the table within *LIBL, it's as if I issued a SET CURRENT SQLID. I can't find a way to reset it. Do you have any ideas?
The other DB2 UDB servers don't support the concept of a library list. They always use the iSeries *SQL naming format that doesn't search a library list -- instead they only look for unqualified tables in the schema/library matching the user ID. The only way to get around this would be to qualify table names or use the SET PATH or SET CURRENT SQLID statements to tell DB2 what schema contains the unqualified table and view references.


Visit the ITKnowledge Exchange and get answers to your DB2 questions fast.

Check out this Search400.com Featured Topic: Expert advice on DB2

Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: Tips, tutorials and more.

Dig Deeper on Oracle on iSeries

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.