Re: Embedded SQL to a DDM file.

Actually, I'm working on a system where 90% of the SQL statements are using DDM files, which are defined on a v7r3 system and point to a v5r4 system.

The problem is getting the pieces set up correctly.

Start with WRKRDBDIRE and get the remote system set up:

Display Relational Database Entry Detail

Relational database  . . . . . . :   S102867C
  Relational database alias  . . :   DEV
Remote location:
  Remote location  . . . . . . . :   S102867C
    Type . . . . . . . . . . . . :   *IP
  Port number or service name  . :   *DRDA
  Remote authentication method:
    Preferred method . . . . . . :   *USRENCPWD
    Allow lower authentication . :   *ALWLOWER
  Secure connection  . . . . . . :   *NONE
  Encryption algorithm . . . . . :   *AES
Text . . . . . . . . . . . . . . :


Relational database type . . . . :   *REMOTE

Then create a DDM file:

                         Display Details of DDM File

Local file:
File . . . . . . . . . . . . . . . . . . . . . . :   DDMF
  Library  . . . . . . . . . . . . . . . . . . . :     PDOW

Remote file  . . . . . . . . . . . . . . . . . . :   PDOW/SOURCE

Remote location:
  Name or address  . . . . . . . . . . . . . . . :   *RDB
    Relational Data Base . . . . . . . . . . . . :   DEV

Access method:
  Remote file attribute  . . . . . . . . . . . . :   *RMTFILE
  Local access method  . . . . . . . . . . . . . :

Share open data path . . . . . . . . . . . . . . :   *NO
Protected conversation . . . . . . . . . . . . . :   *NO
Check record format level ID . . . . . . . . . . :   *RMTFILE
Text . . . . . . . . . . . . . . . . . . . . . . :

And create a server authorization entry with

CHGSVRAUTE USRPRF(PDOW) SERVER(DEV) USRID(PDOW)PASSWORD(yourpswd)


Then you can do SQL:

select * from pdow/ddmf
SELECT statement run complete.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /


On 3/11/2021 12:49 PM, Rob Berendt wrote:

Basically you cannot do sql on a ddm file.