I am needing to access files on remote systems thru DDM files using an SQL RPGLE program, but I recieve an sqlcod error SQLCOD = -000000501 that says the file I want to access is not a view, table or physical file. It's right because it is a DDM file, my question is their a compiling option I need to do to make it work? i have tried a few things but it get the message. Thanks for your time.
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
SQLRPGLE with DDM files
Collapse
X
-
SQLRPGLE with DDM files
Hi jimh, I don't believe you can open a DDM file with SQL, as I know you cannot use normal AS/400 Query over a DDM file either. I believe you have to use the SQL CONNECT command to directly open a connection to the remote database and file you want to query. As I have not done this myself, I don't have any explicit examples but I have seen some code where the SQL CONNECT commands were used in imbedded RPG for a program that was set for DRDA. (Distributed Relational Database) You can scan IBM manuals for DRDA, there'll be lots of topics for retrieving remote data. Good luck.
Comment