Previous Topic: OTHERS Statement—Pass Keyword Parameters to SBMJOBNext Topic: OUTDESTPATH Statement—Specify an Output Path for a PeopleSoft Job

C-LANG Statements › OUTDESTFORMAT Statement—Specify the Output Format for a PeopleSoft Report

OUTDESTFORMAT Statement—Specify the Output Format for a PeopleSoft Report

The OUTDESTFORMAT statement specifies the output format for the PeopleSoft report.

Supported Job Type

This statement is optional for the PeopleSoft job type.

Syntax

This statement has the following format:

OUTDESTFORMAT output_format
output_format

Specifies the field name of the output destination format. PeopleSoft stores the list of output destination formats in the PSXLATITEM table. This value corresponds to the Format field in PeopleSoft.

Limits: Up to 8 characters; case-sensitive; it cannot contain delimiters (such as spaces)

Note: Do not use the following special characters: left parenthesis ( ( ), right parenthesis ( ) ), and apostrophe ('). Use caution when using other special characters, such as backslash (\) and at (@).

Format options are the following:

Field Number

Field Name

Description

0

Any

Any

1

None

(None)

2

PDF

Acrobat (*.pdf)

3

CSV

Comma delimited (*.csv)

4

HP

HP Format (*.lis)

5

HTM

HTML Documents (*.htm)

6

LP

Line printer format (*.lis)

7

WKS

Lotus 1-2-3 files

8

XLS

Microsoft Excel Files (*.xls)

9

DOC

Microsoft Word (*.doc)

10

PS

Postscript (*.lis)

11

RPT

Crystal Report (*.rpt)

12

RTF

Rich Text File (*.rtf)

13

SPF

SQR Portable Format (*.spf)

14

TXT

Text Files (*.txt)

15

OTHER

Other

16

Default

Default

17

XML

XML Format (*.xml)

18

DAT

Data Mover Data File (*.dat)

Notes:

Example: Specify the Output Format

This example runs the PAYROLL process that has the Application Engine process type and PS_ALL run control ID. The PAYROLL process output is formatted as a text file.

AGENT PS_NY
OUTDESTTYPE FILE
OUTDESTFORMAT TXT
PROCESSNAME PAYROLL
PROCESSTYPE 'Application Engine'
RUNCONTROLID PS_ALL