The OPEN-DATABASE statement must be given as the first statement if you have not assigned the database with
/ADD-FILE-LINK LINK-NAME=DATABASE, -
FILE-NAME=[:catid:][$userid.]dbname.DBDIR[.copy-name]
If you have already issued a ADD-FILE-LINK statement, the OPEN-DATABASE statement is rejected as an error and not offered in the SDF mask.
The file link name remains in effect until it is released with the command REMOVE-FILE-LINK. The OPEN-DATABASE statement, by contrast, is effective only till the end of the BPSQLSIA run.
OPEN-DATABASE |
DATABASE-NAME = <dbname> ,COPY-NAME = *NONE / <copy-name> ,USER-IDENTIFICATION = *OWN / <userid> |
DATABASE-NAME = <dbname>
Name of the database with which you wish to work.
COPY-NAME = *NONE
Selects the database original for processing.
COPY-NAME = <copy-name>
Selects the database copy with the specified copy name for processing.
USER-IDENTIFICATION = *OWN
BPSQLSIA runs under the same user ID as the one under which the database is cataloged.
USER-IDENTIFICATION = <userid>
User ID under which the database is cataloged. The user ID is specified without the ́$ ́ character.
A database copy can be assigned explicitly with
/ADD-FILE-LINK LINK-NAME=DATABASE, -
FILE-NAME=[:catid:][$userid.]dbname.DBDIR.copy-name
but may also be specified in the OPEN-DATABASE statement.