Troubleshooting
Problem
Prior to release 7.1.0 SQL statements attempting to access data from a DDM file would fail with message SQL7011 as this was not supported. Function was added at R710 to allow SQL statements to work with DDM files, this document provides details.
Resolving The Problem
The new function depends on enhance 3 part naming support. You can read more about 3 part name support at the URLs below.
https://www.ibm.com/docs/en/i/7.4?topic=request-three-part-names
https://www.ibm.com/docs/en/i/7.4?topic=elements-aliases
Here's what you need to do to create a DDM file that allows SQL access.
CRTDDMF FILE(Library_name/ddm_file_name) RMTFILE(remote Library/remoteFile) RMTLOCNAME(*RDB) RDB(remotedatabasename)
The key to making this work is the Parm RMTLOCNAME. The parm must be *RDB. If you use a 'remote database name' for RMTLOCNAME, you will continue to get SQL7011 when selecting from the DDM file.
Also, note that Access Client Solutions does not show the DDM file as an alias or any other relational database type.
[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"}]
Was this topic helpful?
Document Information
Modified date:
20 September 2023
UID
nas8N1019757