RE: Program fails CRTSQLPKG when program has DDM files

To update my question:

From a lot of testing, this is what I've found:

The SQL Statements are using file names that on the local system are DDM
files.
But, since SQL can't use DDM files, I'm connecting to the database of
those files' origin.
When I create the SQL package myself, or via CL, it works fine.  When I
create it via an rpg program (bound or not), it fails. 

Kurt Anderson
Application Developer
Highsmith Inc

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Kurt Anderson
Sent: Friday, November 17, 2006 10:57 AM
To: RPG programming on the AS400 / iSeries
Subject: Program fails CRTSQLPKG when program has DDM files

Hey all,
 
I have an SQLRPGLE program that is calling a service program to create
an SQL Package, but when it issues the CRTSQLPKG command, I get some
allocation and DDM errors (see below).  When I copy the command it is
issuing and issue it myself, the package creates successfully.  From
within debug I also issued the command, I was thinking that I'd be in
the same state as the program, but for some reason it was successful.
 
So, here's what I got:
v5r2
SQLRPGLE compiled with *SQL and RDB(system)  - note, I tried using *SYS
as well and had the same problem.  Program uses a DDM file.
Service program compiled with *SYS and RDB(*LOCAL) - note, I've used
this service program for other programs that use no DDM files.
CPD83EA - Allocation error received for location XXXXX device XXXXX.
CPF4734 - Evoke function for file QCNDDMF in library QSYS for device
DDMDEVICE rejected.
CPF9162 - Cannot establish DDM connection with remote system.
SQ30080 - Communication error occurred during distributed database
processing
 
I did a search but only found one hit from Rob Berendt (2002) that
essentially asked the same question and didn't seem to get any response.
 
Any thoughts?
 
Kurt Anderson
Application Developer
Highsmith Inc.
W5527 State Road 106, P.O. Box 800
Fort Atkinson, WI 53538-0800
TEL (920) 563-9571  FAX (920) 563-7395
EMAIL kjanderson@xxxxxxxxxxxxx
 
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.