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 he installation ShowCase 10.

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

Consolidated Balance Sheet Report

BAL_YEAR

*USRSPC

SQLVIEW

12288

Historical Total Balance by admit year

CENTER

*USRSPC

SQLVIEW

12288

Center a string

CHAR2NUM

*USRSPC

SQLVIEW

12288

Convert left-justified character value to numeric

COLROW

*USRSPC

SQLVIEWP

12288

Create multi-column (down then across) report

COLROW1

*USRSPC

SQLVIEW

12288

Create Step1 file for COLROW12R Report

COLROW12R

*USRSPC

SQLRPT

36864

12 cpi multi-up labels with blank row compression

COLROW2

*USRSPC

SQLVIEWP

12288

Create Step2 File for COLROW12R Report

COLROWSCPT

*USRSPC

SQLSCRIPTP

36864

Script to Run COLROW12R Report

COLROWVIEW

*USRSPC

SQLVIEWP

12288

Create multi-column (down then across) report

COMPYEAR

*USRSPC

SQLVIEW

12288

1998/1999 Order Dollar Comparison

COMPYEARR

*USRSPC

SQLRPT

8192

1998/1999 Sales Comparison MTD

CONSOL_BS

*USRSPC

SQLVIEW

225280

Balance sheet 2006, 2007, 2008 colored

CONSOL_IS

*USRSPC

SQLVIEW

40960

Income Statement for 2 years with Variance - SUM

COVERPAGE

*USRSPC

SQLVIEW

12288

View for Coverpage Report

COVERPAGER

*USRSPC

SQLRPT

8192

Example of a Report With a Cover Page

CRLIMCOMP

*USRSPC

SQLVIEW

12288

Credit Limit versus Total Amount On Order

CROREP

*USRSPC

SQLRPTC

36864

Customer Credit Limit - graphics included

CROVIEW

*USRSPC

SQLVIEW

245760

cro charts Report

CTVIEW

*USRSPC

SQLVIEW

487424

Sales Detail for Client Table

CTVIEWL

*USRSPC

SQLTBLC

12288

Business Sales Detail Table

CUMMAMTDU

*USRSPC

SQLVIEW

12288

Cummulative sum of amtdu

CUSTADDR

*USRSPC

SQLVIEWP

12288

View for Mapquest Application - SUBSTRING

CUSTLIST

*USRSPC

SQLVIEW

446464

Customer Inquiry

CUSTLISTP

*USRSPC

SQLVIEWP

12288

Customer Inquiry with MULTIPLE state selection

CUSTLISTP1

*USRSPC

SQLVIEWP

12288

Customer Inquiry - OMIT Leading and Trailing Text

CUSTLISTR

*USRSPC

SQLRPT

12288

Customer A/R Amounts

CUSTORD

*USRSPC

SQLVIEWP

12288

Customer Order Summary

CUSTORDD

*USRSPC

SQLVIEWP

12288

Customer Order Detail

CUSTORDDR

*USRSPC

SQLRPT

8192

Customer Order Detail for &&date1 and &&date2

CUSTORDER

*USRSPC

SQLVIEW

12288

Customer Order Summary

CUSTORDERR

*USRSPC

SQLRPT

8192

Customer Order Summary

CUSTORDR

*USRSPC

SQLRPT

8192

Customer Order Summary - &&date1 to &&date2

CUSTORDS

*USRSPC

SQLSCRIPTP

4096

Customer info, orders, and report

CUSTYPE

*USRSPC

SQLVIEW

12288

Customer state, type, region and amount

CUSTYPETBL

*USRSPC

SQLTBLV

8192

Customer table -- Amount by type & state

CYPY

*USRSPC

SQLVIEW

69632

Current Year-Prior Year Analysis

DASHBOARD1

*USRSPC

SQLDASH

8192

Dashboard - KPI - Sales Example 1

DASHBOARD2

*USRSPC

SQLDASH

8192

Dashboard - KPI - Sales Example 2

DATAMART

*USRSPC

SQLVIEW

12288

Summary Level Information with CASE - IF/THEN

DATEEX

*USRSPC

SQLVIEWP

12288

Date Variable Example to View Calendar *MDY

DATEEX2

*USRSPC

SQLVIEWP

12288

Date Variable Example to View Calendar *EUR Format

DATEVALID1

*USRSPC

SQLVIEW

12288

Use VALID DATE operator to find bad date records.

DATEVALID2

*USRSPC

SQLVIEW

16384

Use VALID DATE single and multi field examples.

DBLISTV

*USRSPC

SQLVIEWP

12288

DBLIST with Filter based on second variable

DDBEGIN

*USRSPC

SQLVIEW

20480

Initial View for Drill Down Process

DDCUSNO

*USRSPC

SQLVIEWP

12288

Customers within a region - number type variable

DDORDHEAD

*USRSPC

SQLVIEWP

12288

Orders for a customer

DDORDLINE

*USRSPC

SQLVIEWP

12288

Line items for a specific order

DDPRDNO1

*USRSPC

SQLVIEWP

12288

Product Variance Within a Region

DDPRDNO2

*USRSPC

SQLVIEWP

12288

Line items for a specific product

DDREGON

*USRSPC

SQLVIEW

1232896

Customer summary by region

DIST_INSRT

*USRSPC

SQLSCRIPTP

36864

Insert single record into SCSERVER10/DISTANCE file.

DISTINSRT

*USRSPC

SQLVIEWP

12288

View used by DIST INSRT Script.

DUPLEX

*USRSPC

SQLVIEW

16384

Order Acknowledgements

DUPLEXR

*USRSPC

SQLRPT

8192

Forced Page Breaks for Duplex Printing

EDIT

*USRSPC

SQLVIEW

12288

Edit a numeric value and return a string

EMAILFROM

*USRSPC

SQLSCRIPTP

36864

Dynamically change the from address on an e-mail

FIELDICT

*USRSPC

SQLVIEW

12288

External Field Dictionary

GENERIC

*USRSPC

SQLVIEWP

12288

Generic file query

GHBEXER1

*USRSPC

SQLVIEW

16384

Customers in name order - Order Only example

GHBEXER1A

*USRSPC

SQLVIEW

12288

Customer credit available

GHBEXER2

*USRSPC

SQLVIEW

12288

Selected Products - Cost, Price, Margin

GHBEXER3

*USRSPC

SQLVIEW

12288

Products on order for customers in CA, AZ, TX

GHBEXER4

*USRSPC

SQLVIEW

12288

Summary of customer orders

GHBEXER5

*USRSPC

SQLVIEW

12288

Customer order summary - Selling vs. List price

GHBEXER5R

*USRSPC

SQLRPT

12288

Total retail value Vs. Total selling price

GHBEXER6R

*USRSPC

SQLRPT

12288

Order summary by customer

HREF1

*USRSPC

SQLVIEW

12288

SWI Drill Down Step 1

HREF2

*USRSPC

SQLVIEWP

12288

SWI Drill Down Step 2

HREF3

*USRSPC

SQLVIEWP

12288

SWI Drill Down Step 3

IMG

*USRSPC

SQLVIEW

12288

Create HTML IMG tag for a graphic & size value

IS_B2A

*USRSPC

SQLVIEW

53248

Income statement actual and next year budget

KPI_01

*USRSPC

SQLVIEWP

86016

Income statement for a rolling year

LABELLAS10

*USRSPC

SQLRPT

36864

10 cpi multi-up laser labels

LABELRPT10

*USRSPC

SQLRPT

36864

10 cpi multi-up labels with blank row compression

LABELRPT15

*USRSPC

SQLRPT

36864

15 cpi multi-up labels with blank row compression

LABELS

*USRSPC

SQLVIEWP

12288

Create multi-column (across then down) report

LABELSCPT

*USRSPC

SQLSCRIPTP

36864

Script to Run LABELSR Report

LABELSR

*USRSPC

SQLRPT

36864

10 cpi multi-up labels with blank row compression

LABELVIEW

*USRSPC

SQLVIEWP

12288

Create multi-column (across then down) report

LSTPAYMNT

*USRSPC

SQLVIEWP

12288

Last Payments by State & Month

LSTPAYMNTT

*USRSPC

SQLTBLV

12288

Last Payment Totals by State & Month

OBJCRTDATE

*USRSPC

SQLSCRIPTP

4096

Library objects in creation date order

OBJSIZE

*USRSPC

SQLVIEW

16384

Object list in descending size order

ORDERACK

*USRSPC

SQLVIEW

20480

Order Acknowledgements

ORDERAMT

*USRSPC

SQLVIEW

12288

Sum of customer orders by customer

ORDERINQ

*USRSPC

SQLVIEW

16384

Order inquiry (a 4 file join)

ORDERLIST

*USRSPC

SQLVIEW

16384

Order Acknowledgement

ORDERLISTR

*USRSPC

SQLRPT

8192

Order Acknowledgment w/PDF Overlay

ORDERPRINT

*USRSPC

SQLRPT

12288

Order Acknowledgement

ORDERPRNT

*USRSPC

SQLVIEW

311296

Order Acknowledgement Laser View

ORDERPRNTC

*USRSPC

SQLRPTC

245760

Order Acknowledgement Laser Report

ORDERS

*USRSPC

SQLVIEW

20480

Open Order Template

ORDERSUM

*USRSPC

SQLVIEW

20480

Order summary - header info for each order by cust

ORDERSUMP

*USRSPC

SQLVIEWP

12288

Order summary - header info for each order by cust

ORDHIST

*USRSPC

SQLVIEWP

12288

Prior Year and YTD Order Information

ORDHISTR

*USRSPC

SQLRPT

12288

Monthly Order Dollar Totals for Prior and YTD

PAYMENTS

*USRSPC

SQLVIEW

20480

Monthly Payment Summary

PCTCHG

*USRSPC

SQLVIEW

12288

Calculate percent change between two numbers

PICKLIST

*USRSPC

SQLVIEW

12288

Picking list for Customer Orders

PMBALANCE

*USRSPC

SQLVIEW

12288

Product Status

PROPER

*USRSPC

SQLVIEW

12288

Proper case (1st char of each word)

RECEIVABLE

*USRSPC

SQLVIEW

12288

Sum of Customer Balance

REGIADR

*USRSPC

SQLSCRIPTP

4096

Insert a New Unique Email Recipient

REGIONLIST

*USRSPC

SQLVIEW

12288

Display Region Managers - List of Email Recipients

REGIONSCRP

*USRSPC

SQLSCRIPT

4096

Script To Email Customized Excel Files to Managers

REGIONTAB

*USRSPC

SQLTBLV

8192

Table Creates a Spreadsheet-Column for Each Month

REGIONVIEW

*USRSPC

SQLVIEWP

12288

Retrieve Sales Data

REGUADR

*USRSPC

SQLVIEWP

12288

Update Region Manager Email Addresses

REGUAX

*USRSPC

SQLSCRIPTP

4096

Script to Update Email Addresses

REPORTOVR

*USRSPC

SQLSCRIPTP

4096

Print Host Reports in non Duplex

ROLLING6

*USRSPC

SQLVIEWP

12288

Rolling 6 Month Information

ROLLING6R

*USRSPC

SQLRPT

12288

Calls from &start to &finish

ROLLING6T

*USRSPC

SQLTBLV

12288

Rolling 6 month

RUNTIME

*USRSPC

SQLVIEW

12288

IL customers owing more than 0

SALES

*USRSPC

SQLVIEW

122880

Sales Analysis Template

SALESDET

*USRSPC

SQLVIEW

12288

Business Sales Detail

SALESINFO

*USRSPC

SQLVIEW

12288

Sales Information - Revenue, Cost, Units, Margin

SALESMN

*USRSPC

SQLVIEWP

12288

Sales with Variable Month Comparison View

SALESMONTH

*USRSPC

SQLVIEW

12288

Sales Month Comparison View

SALESQTR

*USRSPC

SQLVIEW

12288

Sales Quarter Comparison View

SPLIT

*USRSPC

SQLVIEW

12288

Split string using a delimiter

SQUSERS

*USRSPC

 

36864

Current Interactive/ViewPoint users

STATECOUNT

*USRSPC

SQLVIEW

12288

Number of customers in each state

STRIPX

*USRSPC

SQLVIEW

12288

Strip character from a string

TOPAMTDU

*USRSPC

SQLVIEWP

12288

Choose Top Customers Based on Amtdu

TOPTEN

*USRSPC

SQLVIEW

12288

Top Ten Customers Based on Amount Due

TOPTENR

*USRSPC

SQLRPT

12288

Top Ten Customers by Amount Due

TRIANGLES

*USRSPC

SQLVIEW

12288

Triangle measurements

TRW4B5

*USRSPC

SQLVIEW

12288

Customer with more than one order

TRW4B6

*USRSPC

SQLVIEW

12288

Order Information for Customer with > one order

TRW4B6R

*USRSPC

SQLRPT

8192

Order Infromation for Customer with > one order

UDFDATE

*USRSPC

SQLVIEW

12288

Convert date data type to various packed formats

UNPACK

*USRSPC

SQLVIEW

12288

Unpack decimal and binary values

URLSTRING

*USRSPC

SQLVIEW

12288

Convert Invalid Char to STD URL String

USERCPUVW

*USRSPC

SQLVIEW

12288

CPU usage by user

WEEKLYVW

*USRSPC

SQLVIEW

12288

Weekly totals for last 200 weeks

WTVIEW

*USRSPC

SQLVIEW

12288

Walk Through View


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

Last Modified On: November 20, 2018