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

Collection on ado request

I'm new to the iSeries and I'm trying to get a handle on the parameters for IBMDA400. Specifically, Catalog Library List and Default Collection. I'm having trouble using the same ADO connect string to open and write to a data queue (works), and to SELECT against files (doesn't work - - requires a lib. prefix). I'd like to avoid hard-coding the lib. prefix.

When using unqualified SQL statements the property 'Default Collection' is used to determine the current schema (library).

If not specified, or not set, then the SQL request uses the connecting user profile name as the schema name most of the time on the iSeries -- this is not useful.

This property is not used during tables record level access, data queues, CL commands, and program call processing (those are using library list).


Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.

The Best Web Links: Tips, tutorials and more.

Check out this Search400.com Featured Topic: Networking and the iSeries

PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.

Dig Deeper on FTP

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.