Invoking rislod without any command line arguments displays interactive prompts.
Accepting Default Values. Most prompts have default values indicated in square brackets ([]). Press the ENTER key to select these default values.
Selecting Nondefault Values. To select a nondefault value choose the character in parentheses corresponding to the option you want. Key in that character and press ENTER.
Specifying Other Information. Some prompts ask you to enter information, such as filenames. Key in the information requested and press ENTER.
The following list discusses the interactive prompts in detail.
1. Set mode ansi ON(y/n) :[y] >
The default is set ANSI mode on. See the RIS SQL User’s Guide for 32-Bit Applications for more information.
Do one of the following:
Press ENTER to accept the default.
Selectnto turn off ANSI mode.
2. Preserve blanks? (y/n) :[n] >
This prompt lets you set the blankstrip mode. By default rislod strips trailing blanks from character data.
Do one of the following:
Press ENTER to accept the default if you do not want to preserve trailing blanks.
Selectyif you want to preserve trailing blanks.
3. Set mode enable databases?
all(a) specific(s) :[a] >
This prompt lets you enable databases during the loading of a schema.
Do one of the following:
Press ENTER to enable all RIS-supported databases.
Selectsand rislod prompts you for a database type:
Enter DBMS type (ex. informix) :[return] >
Enter the RIS-supported database type, such as informix, ingres, or oracle. This prompt repeats until you press ENTER without entering a database name.
4. File mode of all output files? overwrite(w) append(a) error out if exists(e) :[e] >
This prompt lets you set the file mode for log and bad files. The file mode affects the log and bad files only. The default ise, error outmode.
Do one of the following:
Press ENTER to accept the default; when you are prompted for the log and bad filenames, rislod prompts you to quit if the files you specify already exist.
8 - 12 rislod
Selectwto overwrite the existing log and bad files.
Selectato append to the existing log and bad files.
5. Main file for loading :[ris.dmp] >
This prompt lets you specify the name of the main file for loading. The default name for the main file is ris.dmp.
Do one of the following:
Press ENTER to accept the default filename.
Enter another filename for the main file.
6. Log file :[ris.log] >
This prompt lets you specify the name of the log file for loading. The default name for the log file is ris.log.
Do one of the following:
Press ENTER to accept the default filename.
Enter another filename for the log file.
If you selectedefor error outmode at the promptFile mode of all output files?, and a file with the name you specify exists, the messageLog File already existsis displayed. You are prompted:
Quit risload? (y/n):[n] >
Do one of the following:
Press ENTER to accept the default. You are again prompted to enter a name for the log file; key in a new filename.
Selectyto quit rislod.
7. Bad file :[ris.bad] >
This prompt lets you specify the name of the bad file for loading. The default name for the bad file is ris.bad.
Do one of the following:
Press ENTER to accept the default filename.
Enter another filename for the bad file.
If you selectedefor error outmode at the promptFile mode of all output files?, and a file with the name you specify exists, the messageBad File already existsis displayed. You are prompted:
Quit risload? (y/n):[n] >
Do one of the following:
Press ENTER to accept the default. You are again prompted to enter a name for the bad file; key in a new filename.
Selectyto quit rislod.
8. Enter delimitation used in the files for loading: [’] >
This prompt lets you specify the delimiter to use for enclosing character values of variable lengths to use in the main and data files.
You cannot use the space character as a delimiter.
The files generated by risunlod use single quotation marks (’) for delimitation. This feature of rislod lets you use files not prepared by risunlod for loading as long as the other parts of the files comply with the file format used by rislod.
Do one of the following:
Press ENTER to accept the default.
Enter another delimitation character.
9. Enter commit interval :[25] >
The commit interval lets you commit the insertion of rows in a table after the specified commit interval value. The default is 25 (commit after inserting 25 rows in a table).
Do one of the following:
Press ENTER to accept the default.
Enter another commit interval.
10. Which schemas should be loaded?
all(a)
prompted - optionally transfer into existing schema(p) :[a] >
This prompt lets you choose between loading all the schemas or only selected schemas from the main file. The default isafor all schemas.
8 - 14 rislod
Do one of the following:
Press ENTER to load all the schemas from the main file.
Prompts let you choose how to load tables, indexes, views, and privilege definitions. These prompts appear once, after the prompt for the schema, if you choose to load all the schemas in the main file.
Selectpand rislod generates a list of schemas and prompts you before loading each schema. (After each schema is selected, you are prompted for how to load tables, indexes, views, and privilege definitions for that schema.)
Load schema <schname>(y/n) :[y] >
Do one of the following:
— Selectyto load the specified schema. If you selectpat the promptWhich schemas should be loaded?and you selectyat this prompt, you are prompted to optionally load into another existing schema:
To Transfer <schema>’s items into another existing schema...
Enter an existing schema name :[<return>]
Do one of the following:
– Press ENTER if you do not want to use another existing schema;
rislod loads the schema into the schema name specified in the main file.
– Enter the name of an existing schema. rislod then prompts for the username, user password, and schema password, if necessary, for the specified schema.
— Selectnif you do not want to load the specified schema.
rislod lets you rename schemas only if the prompted(p)selection was made at theWhich schemas should be loaded?prompt.
If the schema is a secure schema, you are prompted for the database username, the database username password, the operating system username, and the operating system username password. If the schema has a password, you are prompted for the schema password.
Passwords are not echoed to the screen.
11. Which tables should be loaded?
all(a) prompted(p) none(n) :[a] >
Do one of the following:
Press ENTER to accept the default and load all the tables in the schema.
Selectpif you want to be prompted for each table.
Selectnif you do not want to load any tables.
If you selectaorpat the promptWhich tables should be loaded?the following prompt appears next:
Both definitions and data(b) definitions only(o):[b] >
This prompt lets you decide whether to load both the definitions and data of the tables in the schema or load only the definitions.
Do one of the following:
Press ENTER to accept the default and load both table definitions and data.
Selectoto load table definitions only.
rislod loads either fixed or variable formatted table data.
If only the definitions exist for some or all of the tables in a schema, choosing to load both definitions and data does not cause any problem to rislod. These tables are created without data in them. Similarly, if both the definitions and data exist for some or all of the tables in a schema, choosing the second selection does not cause problems. These table data are
discarded and the string only definitions is placed in the log file.
Selectnif you do not want to load any tables.
If you selectbat the promptBoth definitions and data(b) definitions only(o)the following prompt appears:
Continue loading into a table even though that table exists (y/n):[n] >
When loading a table definition of a table that already exists, an error message is generated stating that a table/view with this name already exists. Whether or not the data is loaded into the existing table depends on the answer to this prompt.
Do one of the following:
— Press ENTER to accept the default and data are not loaded into an existing table.
— Selectyto load data into an existing table.
8 - 16 rislod
Ifyis selected for the previous prompt, the following prompt is displayed:
Clear existing data from table before loading(y/n) :[n] >
Do one of the following:
– Press ENTER to accept the default and keep existing data.
– Selectyto delete all rows from this table before loading data from the main file.
12. Which index definitions should be loaded?
all(a) prompted(p) none(n): [a] >
Do one of the following:
Press ENTER to accept the default and load all index definitions.
Selectpand rislod generates a list of indexes and prompts for each index definition:
Load definition <definition>(y/n):[y] >
Do one of the following:
— Press ENTER to load the specified definition.
— Selectnif you do not want to load the index definition.
Selectnand no index definitions are loaded.
13. Which views should be loaded?
all(a) prompted(p) none(n):[a] >
Do one of the following:
Press ENTER to accept the default and load all views.
Selectpand rislod prompts for each view:
Load view <view>(y/n):[y]:
Do one of the following:
— Press ENTER to load the specified view.
— Selectnand the specified view is not loaded.
Selectnand no views are loaded.
14. Which privilege definitions should be loaded?
all(a) prompted(p) none(n):[a] >
Do one of the following:
Press ENTER to accept the default and load all privilege definitions.
Selectpand rislod prompts for each table or view on which one or more privileges are defined:
Load access privilege on <relation>(y/n):[y]
Do one of the following:
— Press ENTER to load the specified privilege definition.
— Selectnif you do not want to load the privilege definition.
Selectnand no privilege definitions are loaded.
If you selectedpat the promptWhich table should be loaded?the following prompt is displayed.
Load table <table>(y/n):[y]
Do one of the following:
Press ENTER to accept the default and load the specified table.
Selectnand the specified table is not loaded.
When all the necessary information has been specified, rislod processes the schema(s) selected.