The Defaults window
You can change the server name, machine type, and data code set from the Defaults window.
The following figure shows the Defaults window.
The ipload utility saves the information from
the Defaults window in the defaults table
of the onpload database. For more information about the defaults table,
see The defaults table in the onpload database.
Tip: You
can use DB-Acess to examine the default values. The following tables
in the onpload database contain default values: defaults, delimiters, driver,
and machines.
Display option | Header |
---|---|
Server Name | The Server Name text
box specifies the database server with which the settings are associated.
The information provided for the special server name default applies
to all database servers for which no explicit information is provided.
For example, if most the database servers on your network (that will
be using the HPL) are BrandX computers, default should describe
the BrandX computers. To describe the computing environment of the
other database servers on the network, specify the database server
name. The selection list that is associated with the Server Name text box lists the database servers that are identified in the sqlhosts information. |
Machine Type | The Machine Type text box describes fixed-length, binary-format records. It defines the sizes and byte order of data in data files that the specified database server produces. The selection list that is associated with the Machine Type text box provides descriptions of several computers. You can use the Machines option on the Configure menu to add descriptions of other computers to this list (see Modify the machine description). |
Data Code Set | The Data Code Set text
box specifies the character set of the data file. When you load data
into a database, you can convert the character set of the data file
into the character set of the database. For example, you can convert
EBCDIC to ASCII, or any other character set that your system supports.
Conversely, you can convert the data from a database into a selected
character set when you unload data. You can select the GLS code set you want from this selection list. The character set of the database is determined by the DB_LOCALE environment variable. For information about locales and code sets, see the Informix® GLS User's Guide. |