Re: RNMOBJ of *LIB fails with CPF2136

Don't create SQL Data Bases or Schemas on the 400.  Use CRTLIB.  There are
many reasons why SQL is a second rate solution.

Al

Al Barsa, Jr.
Barsa Consulting Group, LLC

400>390

914-251-1234
914-251-9406 fax

http://www.barsaconsulting.com
http://www.taatool.com






                    rob@dekko.com
                    Sent by:                  To:     midrange-l@midrange.com
                    midrange-l-admin@mi       cc:
                    drange.com                Subject:     RNMOBJ of *LIB fails 
with CPF2136


                    02/04/02 01:50 PM
                    Please respond to
                    midrange-l







I tried to rename a library but it failed with CPF2136
 Message . . . . :   Renaming library &1 failed.
 Cause . . . . . :   Library &1 cannot be renamed because it contains one
of
   the following object types.
     -- CRG
     -- DTADCT
     -- JRN
     -- JRNRCV
     -- SQLPKG
     -- SQLUDT

Pointing to:
Object      Type
MSQRY32FBA  *SQLPKG

I am not sure how I created this object.

I did a save to a savf and restored to a different name.  The only object
not restored was the aforementioned *SQLPKG.  This is the only *SQLPKG in
the library.

Creating a library with SQL's CREATE COLLECTION creates a journal, a
journal receiver and a plethora of files - but no *SQLPKG.  Does this bad
boy sound familiar?

I tried playing with the Excel option to get data from the 400.  Got it to
work but that did not create this package.

I searched
http://www.google.com
I got a hit, but in Italian.  Google offered to translate but many words
failed to translate.
http://www.iseries.it/nwire/mesi/free/nw-9804/9804055.htm
It looks like something out of iSeries magazine though.  I tried going to:
http://www.iseriesnetwork.com/
But got the usual "The page cannot be displayed"

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.