Generating Data Extract Views

The gen_views utility performs the same operations as the Maintain Data Extract Views batch job within Oracle Clinical (under Conduct select Data Extract and then Data Extract Views) for all accounts in FULL maintenance mode.

Use the gen_views utility to regenerate views for all accounts in one or all studies. For example, if a change is made to a key template, all views based on that template in that study must be regenerated for all the study access accounts.

The general sequence for this task is:

• run opa_setup, which defines the RXC_TOOLS directory

• change to the RXC_TOOLS directory

• run gen_views.

Variables include:

• study enter either the name of a study or ALL for all studies

• sas_queue enter the name of the queue where SAS jobs execute or NULL (on Windows only)

• view_creation_mode valid values are: DATA_ONLY, COMBINED_VIEW, or SEPARATE_VIEW.

Operating system-specific instructions follow:

• Running gen_views on UNIX Platforms
  
• Running gen_views on Windows
  

Running gen_views on UNIX Platforms

To run gen_views on a UNIX platform:

1. Log on to the server in your user account.

2. Set environment variables for the database name and code environment; see Setting Environment Variables on the Command Line

3. Change directories to $RXC_TOOLS.

4. Set the output directory:

   • C Shell command: setenv RXC_LOG usr_log_dir

   • Bourne Shell command:

     RXC_LOG = usr_log_dir

     export = code_env

5. Run the script:

   gen_views study UNIX view_creation_mode

   For example:

   gen_views ALL UNIX DATA_ONLY 
   

   The script prompts for:

   • Database name

   • Username for user who can submit the DX job

   • Password for the user

Running gen_views on Windows

To run gen_views on Windows:

1. Log on to the server using your local account.

2. In an MS-DOS window, set the server environment:

   set p1=db_name set p2=code_env opa_setup

   where db_name is a database instance name and code_env is a code environment designation.

3. Change directories to %RXC_TOOLS%

4. Set the output directory:

   set  rxc_log=user_log_folder

5. Run the command file.

   gen_views study NULL view_creation_mode

   For example:

   gen_views ALL NULL DATA_ONLY
   

   The script prompts for:

   • Database name

   • Username for user who can submit the DX job

   • Password for the user