|
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. ==================================
MORE INFORMATION ON THIS TOPIC
==================================
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.
|
