Re: DECS Error message

[Scott Johnson <sjohnson@xxxxxxxxxxxxx>]

I actually found a simpler solution.  When creating the connection,
the "Data Journaling:" option should be set to yes.  This will create
the needed packages on the fly.  I then went back into the connection
and turned it off.  Connection is working great now.

Thanks,
    Scott

mandy.shaw@uk.catalyst-solutions.com wrote:
> 
> I spent ages trying to find the answer to this problem - eventually I got
> it here:
> 
> http://www.as400.ibm.com/developer/jdbc/Faqs/JDBCFAQ.html
> 
> (section F15, right at the end).
> 
> That was for JDBC but if you run the Java class they mention it will create
> the right SQL packages for DRDA in general, so they'll work for DECS as
> well. Specify the remote system using the DRDA name from WRKRDBDIRE (sorry,
> that was probably obvious). You will need 5769-JV1 lic pgm on your AS/400
> but as it's free of charge you probably have it. Let me know if you have
> problems.
> 
> Regards,
> Mandy Shaw
> Principal Solutions Architect
> Catalyst Solutions plc
> Kingfisher House
> Frimley Business Park
> Camberley
> Surrey
> GU16 5SG
> UK
> 
> http://www.catalyst-solutions.com
> Email: Mandy.Shaw@uk.catalyst-solutions.com
> 
> Telephone: +44 (0)870 166 1000
> DDI: +44 870 166 1324
> Facsimile: +44 870 168 3920
> Mobile: +44 410 447966
> Email to mobile 'phone: mandyshaw@sms.genie.co.uk
> 
> I am trying to set up a DECS connection from one AS/400 running the
> Domino server to another AS/400 with our production data.  I get
> the following error:
> 
> Error: SQL package QSQCLIPKGN in QGPL not found at DRDA Server.,
> Connector 'db2', Method -Connect- (-805)
> 
> Is there something that I have to get installed on the production
> AS/400 in order to access it from the Domino AS/400?  Or am I missing
> something else?
> 
> --  THANKS
> ------------------------------------------------------
> Scott P. Johnson
> Microcomputer Development Specialist
> IBM Certified Specialist - AS/400 RPG Programmer
> Highsmith Inc.
> W5527 Hwy 106, PO BOX 800
> Fort Atkinson, WI 53538-0800
> TEL:  920-563-9571                FAX:  920-563-7395
> sjohnson@highsmith.com
> www.highsmith.com
> ------------------------------------------------------
+---
| This is the Domino/400 Mailing List!
| To submit a new message, send your mail to DOMINO400@midrange.com.
| To subscribe to this list send email to DOMINO400-SUB@midrange.com.
| To unsubscribe from this list send email to DOMINO400-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: meechamw@ptd.net
+---