CREATE DATABASE (Was: RNMOBJ of *LIB fails with CPF2136)

["Simon Coulter" <shc@xxxxxxxxxxxxxxxxx>]

Hello Martin,

You wrote:
>My only complaint would be why IBM couldn't have used CREATE DATABASE
>(which I think is ANSI standard SQL, though ICBW) instead of CREATE
>COLLECTION.  That would be very helpful when you are writing a
>database-independent creation script, as I was doing recently.

But it does support that syntax.  Type CREATE DATABASE FREDNURK into ISQL
(i.e., STRSQL) and watch what happens.

DROP DATABASE FREDNURK works too.

It also works from a source file processed by RUNSQLSTM.  This is at 440
but I'm sure that support has been around for ages.

Regards,
Simon Coulter.

--------------------------------------------------------------------
   FlyByNight Software         AS/400 Technical Specialists
   http://www.flybynight.com.au/

   Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
   Fax:   +61 3 9419 0175   mailto: shc@flybynight.com.au   \ /
                                                             X
                 ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------