extract

Creates a text file containing object definitions extracted from the database.

Authorization

You must have display access to the objects being copied and, if you want to use the ;lock keyword, also the modify access.

Syntax

{create | cr | extract | ex} filename from
{[calendars | calendar | cal=calname] |
[eventrule | erule | er=eventrulename] |
[parms | parm | vb=[tablename.]variablename] |
[vartable | vt=tablename] |
[prompts | prom=promptname] |
[resources | resource | res=[workstationame#]resourcename] |
[cpu={workstationame | workstationclassname | domainame}] |
[workstation | ws=workstationame] |
[workstationclass | wscl=workstationclassname] |
[domain | dom=domainame] |
[jobs | jobdefinition | jd=[workstationame#]jobname] |
[sched | jobstream | js= [workstationame#]jstreamname
   [valid from date|valid to date |valid in date date]
   [;full]] |
[users | user=[workstationame#]username]}
[;lock]

Arguments

filename

Specifies the name of the file to contain the object definitions.

calendars | calendar | cal

If no argument follows, copies all calendar definitions into the file.

If argument calname follows, copies the calname calendar into the file. Wildcard characters are permitted.

eventrule | erule | er

If no argument follows, copies all event rule definitions into the XML file.

If argument eventrulename follows, copies the eventrulename event rule into the file. Wildcard characters are permitted.

parms | parm | vb

If no argument follows, copies all global variable definitions found in the default variable table into the file.

If argument tablename.variablename follows, copies the variablename variable of the specified tablename variable table into the file. If the tablename variable table is omitted, composer looks for the variable definition in the default variable table. Wildcard characters are permitted on both tablename variable table and variablename variable.

For example:

create parmfile from parms=@.@

Copies all variables from all tables.

create parmfile from parms=@

Copies all variables from the default table.

create parmfile from parms=@.acct@

Copies all the variables whose name starts with acct from all the existing tables.

Remember: Using the ;lock option on a variable locks the variable table that contains it. This implies that, while the table is locked, no other user can run any other locking commands on it or on the variables it contains.

vartable | vt

If no argument follows, copies all variable table definitions into the file.

If argument tablename variable table follows, copies the tablename variable table into the file. Wildcard characters are permitted.

prompts | prom

If no argument follows, copies all prompt definitions into the file.

If argument promptname follows, copies the promptname prompt into the file. Wildcard characters are permitted.

resources | resource | res

If no argument follows, copies all resource definitions into the file.

If argument workstationame#resourcename follows, copies the resourcename resource of the workstationame workstation on which the resource is defined into the file. If workstationame is omitted, the default is the workstation on which composer is running. Wildcard characters are permitted for both workstationame and resourcename.

cpu

Copies workstations, workstation classes, or domains into the file.

workstation

The name of the workstation. Wildcard characters are permitted.

workstationclass

The name of the workstation class. Wildcard characters are permitted.

domain

The name of the domain. Wildcard characters are permitted.

workstation | ws

If no argument follows, copies all workstation definitions into the file.

If argument workstationname follows, copies the workstationname workstation into the file. Wildcard characters are permitted.

domain | dom

If no argument follows, copies all domain definitions into the file.

If argument domainname follows, copies the domainname domain into the file. Wildcard characters are permitted.

workstationclass | wscl

If no argument follows, copies all workstation class definitions into the file.

If argument workstationclassname follows, copies the workstationclassname workstation class into the file. Wildcard characters are permitted.

jobs | jobdefinition | jd

If no argument follows, copies all job definitions into the file.

If argument workstationame#jobname follows, copies the jobname job of the workstationame workstation on which the job runs into the file. If workstationame is omitted, the default is the workstation on which composer is running. Wildcard characters are permitted for both workstationame and jobname.

sched | jobstream | js

If no argument follows, copies all job stream definitions into the file.

If argument workstationame#jstreamname follows, copies the jstreamname job stream of the workstationame workstation on which the job stream is defined into the file. If workstationame is omitted, the default is the workstation on which composer is running. Wildcard characters are permitted for both workstationame and jstreamname.

valid from

date Restricts the selection to job streams that have a valid from date equal to the indicated value. The format is mm⁄dd⁄yyyy.

valid to

date Restricts the selection to job streams that have a valid to date equal to the indicated value. The format is mm⁄dd⁄yyyy.

valid in

date date The time frame during which the job stream can run. The format is mm⁄dd⁄yyyy - mm⁄dd⁄yyyy. One of the two dates can be represented by @.

full

Copies also all job definitions contained in the job stream.

users | user

If no argument follows, copies all user definitions into the file.

If argument workstationame#username follows, copies the username user of the workstationame workstation on which the user is defined into the file. If workstationame is omitted, the default is the workstation on which composer is running. Wildcard characters are permitted for both workstationame and username. The password field is not copied for security reasons.

;lock

Specifies to keep locked the selected object.

Comments

You can use this command to create a file containing parameter definitions to be imported into the parameter database defined locally on a workstation. For more information on how to import parameter definitions locally, refer to parms.

You can invoke the command with the old name “create” or the new name “extract”. Without the lock option, database locking is not checked and all matching objects are extracted to the file. After you create a file, you can use the edit command to make changes to the file and the add or replace command to add or update the database.

You can specify with the lock option, if the objects that respond to the selected criteria, must remain locked by the user in the database. If composer, during the extraction, find some of these objects already locked by someone else, these objects are not inserted into the file and a message to stdout is presented for each locked object.