extract

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

Authorization

To extract scheduling object, you must have display access to the objects being copied and, if you want to use the ;lock keyword, also the modify access. If you do not have the required access composer is unable to find the objects.

To extract security objects, you must have permission for the modify action on the object type file with attribute name=security.

Syntax

{create | cr | extract | ext} 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] |
[runcyclegroup | rcg=runcyclegroupname] |
[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  [;password]] |
[accesscontrollist | acl for securitydomainname] |
[securitydomain | sdom=securitydomainname] |
[securityrole | srol=securityrolename]}
[;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.

runcyclegroup | rcg

If no argument follows, copies all run cycle group definitions into the file.

If argument runcyclegroupname follows, copies the runcyclegroupname run cycle group into the file. Wildcard characters are permitted.

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.

If you do not add the ;password option, the password defined for the user is saved in the output file as a sequence of 10 asterisks (*) and cannot be reused.

If you do add the ;password option, the password defined for the user is encrypted and saved in the output file. It can thus be re-imported and used again.

accesscontrollist | acl

If no securitydomainname argument follows, copies the access control list definitions for all the security domains into the file.

If argument securitydomainname follows, copies the access control list definitions for the securitydomainname security domain into the file. Wildcard characters are permitted for securitydomainname .

securitydomain | sdom

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

If argument securitydomainname follows, copies the securitydomainname security domain definition into the file. Wildcard characters are permitted for securitydomainname .

securityrole | srol

If no securityrolename argument follows, copies all the security role definitions into the file.

If argument securityrolename follows, copies the securityrolename security role definition into the file. Wildcard characters are permitted for securityrolename .

;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.