The following is a list of objects— user space objects (views, reports, tables, and so on), commands, and programs—added to the SEQUELEX example library during the installation of Sequel.

Object

Type

Attribute

Size

Text

SQDATE

*CMD

 

8192

Add/remove records from SQDATE conversion file

SQXRELMOD

*DTAARA

 

8192

 

ARFILE

*FILE

PF

385024

Acc - Accounts Receivable

BS_RULES

*FILE

PF

40960

Acc - Consolidated Income Statement

BUDVACTPCT

*FILE

PF

49152

Acc - Income Statement Budget

CHAR2NUM

*FILE

PF

36864

Char/Numeric Conversion File

CUSTCOPY

*FILE

PF

57344

Customer Master With CHAR Cusno Field

CUSTMAST

*FILE

PF

135168

Customer Master

CUSTMAST2

*FILE

PF

98304

Create Step2 File for COLROW12R Report

CVTDATE

*FILE

PF38

102400

Date - Julian offset - Month - Day

CVTDATEL1

*FILE

LF38

53248

Date - Julian offset - Month - Day

DATAMART

*FILE

PF

6328320

Management Summary Level Information

DSPFFD

*FILE

PF

57344

Output file for DSPFFD

DSPOBJD

*FILE

PF

65536

Output file for DSPOBJD

GLMAST

*FILE

PF

1089536

Acc - Balance Sheet

INVDTOFSET

*FILE

PF

36864

Year Offset for INVMAST Aging

INVMAST

*FILE

PF

36864

Invoice Master

IS_RULES

*FILE

PF

36864

Acc - Consolidated Income Statement

KPW01

*FILE

PF

69632

Acc- generl ledger

OPTFILE

*FILE

PF

299008

Option File - drilldown

ORDHEAD

*FILE

PF

57344

Order Header

ORDHEADADV

*FILE

PF

49152

Copy of ORDHEAD for Aging

ORDLINE

*FILE

PF

69632

Open Orders - Order line items

ORDTEOFSET

*FILE

PF

36864

Offset Value for ORDHEADADV Aging

PARTMAST

*FILE

PF

65536

Product master

PERIODS

*FILE

PF

94208

Sales - Yearly Information

PHONELOG

*FILE

PF

86016

Customer Call Information

PRODUCTS

*FILE

PF

77824

Sales - Product Category

REGIONLIST

*FILE

PF

53248

Outfile from view SQLEXEC

REGMAST

*FILE

PF

36864

Region Master

REGMGRLST

*FILE

PF

36864

Region Manager List

RUNTIME

*FILE

DSPF

8192

 

SALESFACT

*FILE

PF

430080

Sales - product sale information

SALESHIST

*FILE

PF

1875968

Sales History

SALMAST

*FILE

PF

36864

Sales Rep Master

SOURCE

*FILE

PF38

204800

Example Source Information

SPLOGOFSET

*FILE

PF

61440

Offset for SUPLOG Aging

SQDATE

*FILE

PF

57344

Date data - work file

SQXPOL

*FILE

PF

126976

 

STATEREF

*FILE

PF

53248

State references

STORES

*FILE

PF

53248

Sales - Store id and location

TRIANGLES

*FILE

PF38

53248

Leg lengths for triangles

TRW4B_5

*FILE

PF

36864

Customer with more than one order

VENDMAST

*FILE

PF

49152

Vendor Master

ZIPLIST

*FILE

PF

36864

File for CUSTADDR DBList

RUNTIME

*MSGF

 

20480

 

AGE1

*PGM

CLP

36864

Age Advanced Training Files

DATECALC

*PGM

RPG

73728

 

RUNTIME1

*PGM

CLP

36864

Runtime SQL statement substitution (CHGVAR)

RUNTIME2

*PGM

CLP

40960

Runtime SQL statement substitution

RUNTIME3

*PGM

CLP

36864

Runtime SQL statement substitution (MSGF)

RUNTIME4

*PGM

CLP

36864

EXECUTE & PRINT examples with SETVAR

RUNTIME5

*PGM

CLP

45056

Example using SEQRTRNP API to return prompt values

SQDATEC

*PGM

CLP

40960

Date conversion

QRYCVT1

*QRYDFN

QRY

45056

 

ACCUM

*USRSPC

SQLVIEW

1232896

Accumulate AMTDU for Cstte, Ctype, and rowset

ADV_DOTST

*USRSPC

SQLSCRIPTP

4096

Advance Script of DOWHILE and DOLOOP

ADV_VARTST

*USRSPC

SQLSCRIPTP

4096

Advance Script to test Variable Input

ADVTRRPT1

*USRSPC

SQLVIEW

12288

Current Month and YTD Sales by Item with CVTDATE

ADVTRRPT1R

*USRSPC

SQLRPT

12288

Current Month and Year-to-Date Sales by Item

ADVTRRPT2

*USRSPC

SQLVIEWP

12288

Aging Report with Variable Summarization Levels

ADVTRRPT2R

*USRSPC

SQLRPT

12288

Aging Report with Variable summarization Levels

ADVUPINVMS

*USRSPC

SQLVIEW

12288

INVMAST File Dates

ADVUPOHEAD

*USRSPC

SQLVIEW

12288

ORDHEADADV File Dates

ADVUPSPLOG

*USRSPC

SQLVIEW

12288

SUPLOG File dates

AGEINV

*USRSPC

SQLVIEW

12288

Update INVMAST File Dates

AGEORDER

*USRSPC

SQLVIEW

20480

Order Placement Age Information for 2002 - day cnt

AGEORDERR

*USRSPC

SQLRPT

8192

Order Placement Count Report

AGESCRIPT

*USRSPC

SQLSCRIPT

4096

Script to age SEQUELEX training files

AGINGCASE

*USRSPC

SQLTBLV

12288

Aging Case Table 30-60-90-Over

AGINGSTEP

*USRSPC

SQLTBLV

8192

Aging Step Table 30-60-90-Over

AGINGSTEP2

*USRSPC

SQLVIEWP

12288

View to drill into - from AGINGSTEP Table - DBLIST

AGINGSTEP3

*USRSPC

SQLTBLV

8192

Table to drill into from AGINGSTEP Table

AGINGTBLAP

*USRSPC

SQLAPP

8192

AGING DrillDown - Table to View or Table - APP

APP1

*USRSPC

SQLAPP

8192

Customer Mapquest Search

APP2

*USRSPC

SQLAPP

8192

Drill Down Training Example

AR

*USRSPC

SQLVIEW

1261568

Aging of AR - Group by Region with KPI’s

AUTOJOINEX

*USRSPC

SQLVIEW

12288

Auto Join Template

BAL_SHEET

*USRSPC

SQLVIEW

77824

Consolidated Balance Sheet view

BAL_SHEETR

*USRSPC

SQLRPTC

1544192


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: April 21, 2017