Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Invoking the procedure through a schema name

When connecting to the iSeries through an application such as PowerBuilder, the SQL path on the iSeries doesn't contain those schemas that I would like to use to resolve unqualified procedure names. As a result, I keep getting the "*N name not defined" error. Invoking the procedure by qualifying it with the schema name from the PowerBuilder application is not an option. How do I get around this?
You would need to execute a SET PATH statement prior to the procedure call.


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 DB2 UDB (universal databases)

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.