sql using a ddm file

[Jean-Claude MONOT]

Is there any way to run a sql SELECT on a DDM file ?
If I do it, I have a message like ' it is not a databse file ' .

Thanks.

JCM

[Tony Pack]

You will have to create a RDB entry for the remote machine, using the
WRKRDBDIRE command (if you have not already performed this). Also, set the
DDM password required values in the CHGDDMTCPA command to either require a
password or not. Thirdly, use the SQL "connect to" clause to connect to the
remote database, then execute SQL commands remotely against the database
file.

Hope this helps..
Tony Pack

Post by Jean-Claude MONOT
Is there any way to run a sql SELECT on a DDM file ?
If I do it, I have a message like ' it is not a databse file ' .
Thanks.
JCM

[Jean-Claude MONOT]

It's ok.
Thank you.

Post by Tony Pack
You will have to create a RDB entry for the remote machine, using the
WRKRDBDIRE command (if you have not already performed this). Also, set the
DDM password required values in the CHGDDMTCPA command to either require a
password or not. Thirdly, use the SQL "connect to" clause to connect to the
remote database, then execute SQL commands remotely against the database
file.
Hope this helps..
Tony Pack

Post by Jean-Claude MONOT
Is there any way to run a sql SELECT on a DDM file ?
If I do it, I have a message like ' it is not a databse file ' .
Thanks.
JCM

[Jean-Philippe BALLAT]

Hello,

I'm french.
Now I haved do one test for understand your explain :
my conf : DDMF with connection SNA,
Yes, I have the same msg in french :

The Message : with More on the message :

Message . . . . : Le fichier REGU de JPB n'est pas un fichier base de
données.
Cause . . . . . : Un traitement SQL n'est possible que sur un fichier base
de
données. Les autres types de fichiers ne sont pas acceptés.
Que faire . . . : Vérifiez que les noms de fichiers et de bibliothèques sont
corrects.

I see the first time, and with more test (ovr) now, it's impossible.
Limitation of SQL400. It's possible !

But I'm interesting of solution !


Thanks.

Friendly.

Jean-Philippe Ballat

[Jean-Philippe BALLAT]

Thanks,

I try but I have some problems with configuration with WRKRDBDIRE :
Machine A my physical file

Machine B my ddmf file

It's OK when i use dsppfm on my DDMF, I see data.
It's no necessary addrdb for read (by dsppfm) data on ddmf. ok

I try WRKRDBDIRE and ADDRDB (SNA) whith ref Machine A
But I have problem with connect sql ( différents errors :
aut after no find database ....)

So I try addrdb (on machine a) and the same thing with sql connect on rdb
(local but réf eloigned name local)

Thanks more !

Friendly.

[Kent Milligan]

No, SQL does not support DDM files. Actually SQL does not need DDM files - you
add an ADDRDBDIRE to the server that you want to access and then just run the
SQL directly against the DB2 objects on the target server. See the Distributed
Database Programming manual.

[Jean-Philippe BALLAT]

For Kent Milligan <***@us.eye-bee-m.com>

Hello,

Thanks for your response.
Friendly.

[Brett]

Post by Jean-Claude MONOT
Is there any way to run a sql SELECT on a DDM file ?
If I do it, I have a message like ' it is not a databse file ' .
Thanks.
JCM

JCM,
I have run into this problem and it is not supported by SQL. Utilize
the SQL CONNECT keyword to connect to the data base you wish to query.
Where "data base" refers to what 400 you want to connect. I hope this
helps.

Brett

[Himanshu Singh]

This was useful to me. Thanks!