sql using a ddm file

Jean-Claude MONOT

unread,

Nov 18, 2003, 2:30:19 PM11/18/03

to

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

unread,

Nov 18, 2003, 3:33:54 PM11/18/03

to

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
tonyp_...@psbiz.org

"Jean-Claude MONOT" <jean-cla...@wanadoo.fr> wrote in message
news:bpdrvr$43u$1...@news-reader3.wanadoo.fr...

Jean-Philippe BALLAT

unread,

Nov 18, 2003, 3:46:58 PM11/18/03

to

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

unread,

Nov 18, 2003, 6:07:20 PM11/18/03

to

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

unread,

Nov 20, 2003, 11:31:41 AM11/20/03

to

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.

--
Kent Milligan, DB2 & BI team
PartnerWorld for Developers, iSeries
km...@us.eye-bee-m.com (spam trick) GO HAWKEYES!!
>>> www.iseries.ibm.com/db2
(opinions stated are not necessarily those of my employer)

Jean-Philippe BALLAT

unread,

Nov 21, 2003, 2:36:39 AM11/21/03

to

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

Hello,

Thanks for your response.
Friendly.

Brett

unread,

Nov 21, 2003, 9:30:18 AM11/21/03

to

"Jean-Claude MONOT" <jean-cla...@wanadoo.fr> wrote in message news:<bpdrvr$43u$1...@news-reader3.wanadoo.fr>...

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

Jean-Claude MONOT

unread,

Nov 21, 2003, 11:52:13 AM11/21/03

to

It's ok.
Thank you.

"Tony Pack" <to...@psbiz.org> a écrit dans le message de news:
qZudnbbd2ZX...@comcast.com...

Himanshu Singh

unread,

Aug 7, 2018, 11:34:02 AM8/7/18

to

This was useful to me. Thanks!