Commands (YCLRMDL - YDLTOBJTBL) › YCRTSQLLIB (Create SQL Library) Command › Example

Example

To create a library containing an SQL/400 collection for use by CA 2E to associate with a model:

YCRTSQLLIB  SQLLIB(TESTSQL) + MDLLIB(TESTMDL) + SYSTEXT('My test SQL/400 Library')

YCRTWS (Create Web Service Instance) Command

Creates a web service instance. The instance can be modeled within a CA 2E model, deployed to an application server, or both. The deployed web service instance exposes a number of operations that correspond to exposed procedures, within modules, within the target Service Program.

Notes:

• If the command fails, detailed errors are written to the YQSHLOG log file in library QTEMP.
• This command requires the user issuing this command to have special authorities *ALLOBJ and *IOSYSCFG. This is due to the underlying IBM IWS scripts requiring those special authorities.

Required

MDLFIL

MDLFUN

SERVER

SERVICE

Optional

UPDMDL

INSTALL

MACHINE

PGMOBJ

USRPRF

RTLIBL

Parameters

The following parameters are for the YCRTWS command:

UPDMDL

Determines whether the CA 2E model information should be updated.

*ADD

The web service instance definition is added to the CA 2E model. The combination of Web Services Server and Web Service (name) must be unique within a model.

Note: If a Server/Service combination (case insensitive) is already modeled in this model the command will fail.

*NO

The web service instance definition is not added to the CA model.

*UPDINSSTS

The installed status of the web service instance, defined within the model, is updated.

Note: If the definition does not already exist in the model, the command will fail.

INSTALL

Determines whether the web service instance is deployed to the application server.

*NO

The web service instance is not deployed to the application server.

*YES

The web service instance is deployed to the application server.

MDLFIL

Specifies the name of the CA 2E model file over which the CA 2E model function is defined.

name

Specify the CA 2E model file name.

MDLFUN

Specifies the name of the CA 2E WS model function under which the web service instance is defined in the model.

name

Specify the CA 2E model function name.

MACHINE

Specifies the name of the machine onto which the web service instance is deployed.

*CURRENT

Refers to the local machine.

name

Specify the machine name. This can be the local machine or a remote machine. The machine name is not validated and the machine need not exist on the local, or any, network.

SERVER

Specifies the name of the application server to which the web service instance will be deployed.

Notes:

• Server name must match (case sensitive) with the name of the actual application server.
• Server/Service/Machine combination (case insensitive) must be unique within a model.

name

Specify the application server name.

SERVICE

Specifies the name of the web service to be deployed.

Note: Server/Service/Machine combination (case insensitive) must be unique within a model.

name

Specify the web service name.

PGMOBJ

Specifies the name of the target service program.

name

Specify the target service program name.

USRPRF

Specifies the name of the user profile under which the web services will run when invoked.

name

Specify the user profile name.

*USRPRF

The user profile invoking the YCRTWS command will be used to run the web service.

Note: If the service user ID specified here, is different from the server user ID (e.g. QWSERVICE), the server user ID must be given *USE authority to the service user ID.

*SRVID

The Web services server user ID (e.g. QWSERVICE), is used to run the service.

RTLIBL

Specifies the runtime library list that the web service instance will use when invoked.

name

Specify the list of libraries to be added to the runtime library list.

*NOCHG

A default library list is used. See the application server documentation for details.