Physical Database DDL Statements › FILE Statements › Entity Currency › Examples

Examples

Defining a Preallocated File

The CREATE FILE statement below defines the database file INS_FILE. The file must be defined in the JCL used to execute CA IDMS/DB because no dynamic allocation information was provided.

create file demoseg.ins_file
   assign to insfile;

Defining File to Be Dynamically Allocated

The CREATE FILE statement below defines a database file to be allocated dynamically under z/OS. Since a ddname was specified, execution JCL can be used to override the dataset name at runtime.

create file syspub.public4
   assign to syspub04
   dsname 'corp.syspub.public4';

Dropping a Database File

The following DROP FILE statement deletes the definition of the INS_FILE file from the dictionary and from all DMCLs with which it is associated:

drop file demoseg.ins_file;