PowerExchange Interfaces for PowerCenter

10.4.0 HotFix 1
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

Creating Empty Files in a PowerCenter Session

You can create an empty flat file, a new generation of a GDG, or a sequential data set in a PowerCenter session.

In Workflow Manager, right-click the appropriate task in the Task Developer or the workflow in Workflow Designer.

Click

Tasks

Edit

The

Edit Tasks

dialog box appears.

Click the

Mapping

tab and select the source or target.

In the

Pre SQL

Post SQL

attribute under

Session-Level Properties

, enter the CREATEFILE command. Use the following syntax:

<CMD>CREATEFILE FN=file_name parameter2parameter3...

The following table describes the parameters that you can enter for the command:

Parameter	Operating System	Description
BS	z/OS	Block size. Valid values are 1 to 32760. If RECFM=VB, PowerExchange might add up to 4 bytes to the value that you specify to determine the actual block size. For more information, see Block Size and Record Size in Variable-Blocked Data Sets.
CLOSEDEALLOC	z/OS	Controls whether to deallocate the data set at CLOSE rather than at step termination (FREE=CLOSE). Valid value is Y.
DATACLASS	z/OS	The SMS DATACLAS value to use when you are creating an SMS-managed data set on z/OS and do not want to use the default class that is determined by ACS routines.
EPWD	z/OS or i5/OS	An encrypted password for the specified user ID in the UID parameter. Alternatively if you are creating a file on z/OS, you can enter an encrypted PowerExchange passphrase. Do not encrypt a passphrase that contains invalid characters, such single quotation marks ('), double quotation marks ("), or currency symbols. Do not also specify the PWD parameter.
FN	All	Required. File or data set name to be created. You must enclose file names that include parentheses in double quotes (“). To create a new generation of a GDG, code: FN=”gdg_base_name (+1)” Restriction: If you create a new generation, the GDG base name must exist. The PowerExchange Listener on z/OS that creates the new generation must specify Y for the GDGLOCATE parameter in the DBMOVER configuration file on z/OS.
LRECL	z/OS or i5/OS	Logical record length. Valid values are 1 through 32756. If RECFM=VB, specify the maximum number of data bytes in a logical record. PowerExchange adds 4 to this value for the record descriptor word (RDW). For more information, see Block Size and Record Size in Variable-Blocked Data Sets.
PWD	z/OS or i5/OS	A password for the specified user ID in the UID parameter. If you are creating a file on i5/OS or z/OS, you can enter a valid PowerExchange passphrase instead of a password. An i5/OS passphrase can be from 9 to 31 characters in length. A z/OS passphrase can up to 128 characters in length if you use a PWXPC connection or up to 79 characters in length if you use an ODBC connection. A passphrase can contain the following characters: Uppercase and lowercase letters The numbers 0 to 9 Spaces The following special characters: ’ - ; # \ , . / ! % & * ( ) _ + { } : @ \| < > ? The first character is an apostrophe. Passphrases cannot include single quotation marks (‘), double quotation marks (“), or currency symbols. A valid RACF passphrase can be up to 100 characters in length. PowerExchange truncates passphrases longer than 100 characters when passing them to RACF for validation. Do not also specify the EPWD parameter.
MODELDCB	z/OS	Model DCB to be used for the file creation. Generally, this is only required for GDG data sets that are not SMS-managed.
RECFM	z/OS or i5/OS	Record format.
RELEASE	z/OS	Release unused, allocated space on CLOSE. Valid value is Y.
RELPOS	z/OS	Relative position of the data set on a tape volume, or data set sequence number. Valid values are 1 to 512.
SPACE	z/OS	Space allocation parameters. Use the following syntax: SPACE=(U ,P ,S ) Where: U is unit type. Valid values are: T for tracks or C for cylinders. P is primary space. Valid values are 1 through 16777215 tracks or the equivalent in cylinders. S is secondary space. Valid values are 1 through 16777215 tracks or the equivalent in cylinders. If you enter a primary or secondary space value greater than 65535 tracks, coordinate with the space management team for the target system to verify that such a large allocation is supported.
STORCLASS	z/OS	The SMS STORCLAS value to use when you are creating an SMS-managed data set on z/OS and do not want to use the default class that is determined by ACS routines.
UID	z/OS or i5/OS	User ID. This parameter is required if the PowerExchange Listener is configured for security (SECURITY=1 or 2). Also specify either PWD or EPWD, but not both.
UNIT	z/OS	Unit type.
VOLSER	z/OS	Volume serial.