I would suggest you build your connection string through a .udl file, then use that as a datasource in your macro code. In my experience with AS400 - the connection strings normally contained Catalog= or Library= parameters.
If you are unfamilar with UDL's this should help
http://msdn.microsoft.com/library/de...aLinkFiles.asp
.02
Stan