Previous Topic Next topic Print topic


mfhco create command

Syntax

mfhco create db=databasename [coll=collsequence] [log=logfilename] 
   [drv=driveletter] [id=logon-id] [pass=password] [srvr=nodename] [lctn={L | R}]

Syntax Rules

  1. At least one space must occur before each parameter in the command.
  2. There must be an equals sign (=) between parameters and their values.
  3. If you omit parameters that have a default value, Host Compatibility Option uses the default value.

Parameters

databasename Specifies the name of the new database.
collsequence Specifies the collating sequence to use. The default value is MFD, which is the EBCDIC collating sequence installed by Enterprise Developer.
logfilename The name of the logfile to capture output information. The default value is createdb.log.
driveletter The drive letter to create local database on.
logon-id The logon ID required to connect to the server where the database is to reside.
password The password required to connect to the server where the database is to reside.
nodename For databases on a remote server, the cataloged DB2 node name for that server.
L Indicates that the database location is a local server. Default.
R Indicates that the database location is a remote server.

Example

The following command:
mfhco create db=test drv=e
creates a database named test on drive e using the default Enterprise Server EBCDIC collating sequence.
Previous Topic Next topic Print topic