Star - Installation & Build Scripts

The following installation and build scripts are one of many installation scripts used for the Star database. The installation varies depending on the types of queries that will be run against the database.

Install Script

star.env
I
DIVISIONS << Beginning of MDK >>
DESCRIPTION;KW
/
DEPTS
DESCRIPTION;KW
/
CATEGORIES
DESCRIPTION;KW
/
MFRS
DESCRIPTION;KW
/
PRODUCTS
PRODUCT_NO
DESCRIPTION;KW
DIVISION
DEPT
CATEGORY
MFR
MARGIN
WHOLESALE
DISCOUNT_RT
/
REGIONS
DESCRIPTION;KW
/
STATES
DESCRIPTION;KW
REGION
/
ZIPCODES
ZIP
CITY;KW
COUNTY_CODE
STATE
REGION;BM
COUNTRY
LATITUDE
LONGITUDE
TYPE;CI
AREACODES
TIME_ZONE;BM
/
COMPANIES
COMPANY;KW
CITY;KW
STATE
ZIP
PHONE
/
MAILFLAGS
DESCRIPTION;KW
/
MAILINGS
DESCRIPTION;KW
/
PROFESSIONS
DESCRIPTION;KW
/
PROFILES
DESCRIPTION;KW
/
INCOMES
DESCRIPTION
/
GENDERS
DESCRIPTION;KW
/
DATES
DT
YR
MO
DY_OF_MO
QTR
FYR
/
PROSPECTS
ACCT
COMPANY;KW
CONTACT;KW
CITY;KW
STATE
ZIP
REGION
PHONE
GENDER
MAILFLAG
MAILING
PROFESSION
INCOME
PROFILE
PREFERRED
CR_LIMIT
DISCOUNT_RT
CUST_SINCE
LAST_ORDER
SEARCH_KEY
/
TICKLERS
TICKLER
DESCRIPTION;KW
/
INITIALS
DESCRIPTION;KW
/
STATUSES
DESCRIPTION;KW
/
PMT_METHODS
DESCRIPTION;KW
/
SOURCES
DESCRIPTION;CI;EW
/
ACTIVITY
ACCT
$DR
/
/
ACCT
DT
TICKLER
INITIALS
/
ORDERS
ACCT
PRODUCT_NO
$DR
/
/
/
ACCT
PRODUCT_NO
ORDER_DATE
TAX_STATE
PMT_METHOD
DISCOUNT
QUANTITY
AMOUNT
TOTAL
/
ORDERS_SVW
/
ACCT
STATE
ZIP
REGION;BM
COUNTRY;BM
GENDER;BM
MAILFLAG;BM
MAILING;BM
PROFESSION;BM
INCOME;BM
PROFILE;BM
PREFERRED;BM
FRQ_BUY_MBR;BM
CR_LIMIT;BM
DISCOUNT_RT;BM
CUST_SINCE;BM
LAST_ORDER
PRODUCT_NO
ORDER_DATE
STATUS;BM
TAX_STATE
SOURCE;BM
PMT_METHOD;BM
DISCOUNT
QUANTITY
SALES_TAX
AMOUNT
TOTAL
/
/ << End of MDK indexes >>
DEPTS << Beginning of ASK >>
DPT!;RK
DEPT
/
/
CATEGORIES
CAT!;RK
CATEGORY
/
/
MFRS
MR!;RK
MFR
/
/
PRODUCTS
PNO!;RK
PRODUCT_NO
/
/
STATES
ST!;RK
STATE
/
/
ZIPCODES
ZP!;RK
ZIP
/
/
DATES
DTC!;RK
DT
/
/
PROSPECTS
ACCT_NO!;RK
ACCT
/
CUST_SINCE
LAST_ORDER
PI!
PROFESSION
INCOME
/
/
TICKLERS
TICK!;RK
TICKLER
/
/
ORDERS
AT!
ACCT
TOTAL
/
PT!
PRODUCT_NO
TOTAL
/
OT!
ORDER_DATE
TOTAL
/
APOSTDQSAT!
ACCT
PRODUCT_NO
ORDER_DATE
STATUS
TAX_STATE
DISCOUNT
QUANTITY
SALES_TAX
AMOUNT
TOTAL
/
OPASTDQSAT!
ORDER_DATE
PRODUCT_NO
ACCT
STATUS
TAX_STATE
DISCOUNT
QUANTITY
SALES_TAX
AMOUNT
TOTAL
/
/
ORDERS_SVW
RSZQAST!
REGION
STATE
ZIP
QUANTITY
SALES_TAX
TOTAL
/
PPICQAST!
PROFESSION
PROFILE
INCOME
CUST_SINCE
QUANTITY
SALES_TAX
TOTAL
/
MPSQAST!
OR_YR
OR_MO
PMT_METHOD
SOURCE
QUANTITY
SALES_TAX
TOTAL
/
RSCQAST!
REGION
STATE
CUST_SINCE
QUANTITY
TOTAL
/
RSMQAST!
REGION
STATE
OR_YR
OR_MO
QUANTITY
SALES_TAX
TOTAL
/
DDCPYQQST!
DIVISION
DEPT
CATEGORY
PRODUCT_NO
OR_FYR
OR_FQTR
QUANTITY
SALES_TAX
TOTAL
/
APYMQQT!
ACCT
PRODUCT_NO
OR_YR
OR_QTR
OR_MO
STATUS
QUANTITY
AMOUNT
TOTAL
/
/
/ << End of ASK indexes >>
QUIT

Build Script

star << Environment name >>
B;STATUS << B;STATUSuild MDK indexes >>
DIVISIONS;@@
B;STATUS
DEPTS;@@
B;STATUS
CATEGORIES;@@
B;STATUS
MFRS;@@
B;STATUS
PRODUCTS;@@
B;STATUS
REGIONS
B;STATUS
STATES;@@
B;STATUS
ZIPCODES;@@
B;STATUS
COMPANIES
B;STATUS
MAILFLAGS
B;STATUS
MAILINGS
B;STATUS
PROFESSIONS
B;STATUS
INCOMES
B;STATUS
PROFILES
B;STATUS
GENDERS
B;STATUS
DATES;@@
B;STATUS
PROSPECTS;@@
B;STATUS
TICKLERS;@@
B;STATUS
INITIALS
B;STATUS
ACTIVITY
B;STATUS
STATUSES
B;STATUS
PMT_METHODS
B;STATUS
SOURCES
B;STATUS
ORDERS;@@
B;STATUS
ORDERS_SVW;@@
QUIT
eof

Top