Please enable JavaScript to view this site.

The DSTAPI database resides in the CPPD library on the server.

Note: All fields are Alphanumeric unless otherwise stated and the Key is UNIQUE.

Length

Type

Name

Description

Key

40

A

DAID

Record Unique ID


10

A

DAFILEID

File ID– Calling program identifier


1

A

DASTATUS

Record Status e.g.: Q = Queued, C = Complete, F= Failed etc.


10

Date

DACDATE

Record Creation Date (*ISO)


8

Time

DACTIME

Record Creation Time (*ISO)


10

A

DASNAME

Spool file Name – of the spool file you wish to process

1

6

A

DASNUM

Spool file Number – of the spool file # 1

2

10

A

DAJNAME

Job Name – of the spool file

3

10

A

DAJUSER

Job User – of the spool file

4

6

A

DAJNUM

Job Number – of the spool file # 1

5

10

A

DAPPDNAME

CPPD Design Name – this is the name of the PPD file that you wish to use to process the spool file


60

A

DARCPTYP

Recipient Type – Values TO, CC or BCC [20 * 3]

This is an array of 20 elements each of 3 characters holding the Type of recipient.


5120

A

DARCPADR

Recipient Address [20 * 256]

This is an array of 20 elements each of 256 characters holding the email address relating to the type specified in the previous field.


1000

A

DARCPNAM

Recipient Name [20 * 50]

This is an array of 20 elements each of 50 characters holding the name of the recipient relating to the address specified in the previous field.


256

A

DASNDADR

Sender Address – The email address of the Sender


50

A

DASNDNAM

Sender Name – The name of the sender


256

A

DAEMLSUBJ

Email Subject – the subject of the email


1

A

DAEMLBDFMT

Email Body Format (1=HTML, any other =Plain Text)


1024

A

DAEMLBODY

Email Body – the main message text in the format defined in the previous field


68

A

DAEMLATTN

Email PPD Attachment Name


6400

A

DAEMLATT

Email File Attachment Path [25 * 256] See # 2


80

A

DAEMLFLIST

Email Fail List [20 * 4]

This is an array of 20 elements each of 4 characters holding the Email Return Codes for each recipient.


1,0

N

DAEMLRETRY

Email Retry Count


10

A

DAPROUTQ

Print Output Queue – Print distribution


10

A

DAPROUTQL

Print Output Library – Print distribution


256

A

DAFILEPATH

File Output Path – File distribution


50

A

DAFILETMP

Temporary FILE output Folder


50

A

DAEMLTMP

Temporary EMAIL output Folder


# 1        These fields are alpha but contain numeric information and must be right justified with leading zeros included e.g.001234.

# 2        Email File Attachment Path only caters for 25 elements as the 26th element will be the actual attachment created by CPPD.