Universe Training Notes

Below are some Universe training notes

LIST BOOK_TITLES STOCK_POSITION CONV "MD00," STOCK_POS_VALUE CONV "MD22,"
LIST BOOK_SALES SALE_DATE CONV "DWADMAYA"
LIST BOOK_SALES SALE_DATE CONV "D-YMD[4,2,2]"
LIST BOOK_SALES SALE_DATE CONV "DJ"
LIST BOOK_SALES SALE_TIME CONV "MTHS" FMT "40R"
LIST BOOK_TITLES GENRE WITH GENRE NE "FICTION"
LIST BOOK_TITLES  SHORT_TITLE WITH UNITS  <= ALLOCATED
LIST BOOK_TITLES  SHORT_TITLE WITH SALE_TIME AFTER "17:00"
LIST BOOK_TITLES  SHORT_TITLE WITH UNITS  <= ALLOCATED
LIST BOOK_TITLES  SHORT_TITLE  WITH SHORT_TITLE = "[Spud Murphy]"
LIST BOOK_TITLES  SHORT_TITLE  WITH SHORT_TITLE SAID "fpud"
LIST BOOK_AUTHORS NAME with SURNAME said Smith
LIST BOOK_AUTHORS WITH SURNAME SAID "BROWN"
LIST BOOK_SALES WITH SALE_ITEMS LIKE "...Artemis Foul..."
LIST BOOK_SALES WITH SALE_ITEMS = "...Artemis Fowl..."
LIST BOOK_SALES SALE_ITEMS
LIST DICT BOOK_SALES WITH SALE_ITEMS = "Artemis Fowl"
LIST BOOK_SALES WITH SALE_ITEMS = "Artemis Foul"
LIST BOOK_SALES WITH SALE_ITEMS LIKE "...A..."
LIST BOOK_SALES SALE_ITEMS
LIST BOOK_SALES WHEN AUTHOR_NAME EQ "Eoin Colfer"
LIST BOOK_TITLES WITH DEPT BY GENRE="FICTION" OR GENRE="FANTASY") AND (PUBLISHER = "HarperCollins" OR PUBLISHER = "BBC Audiobooks"))
LIST BOOK_SALES WITH SALE_DATE AFTER "01/06/2005" AND WITH BEFORE "31/06/2005"
LIST BOOK_SUPPLIES WHEN DELIV_DATE EQ "01/08/2005"
LIST BOOK_SALES WITH EVERY TITLE_NAME LIKE "...Harry Potter..."
LIST BOOK_SUPPLIES WHEN (DELIV_DATE EQ "01/08/2005" AND DELIV_TIME EQ "09:00")
LIST DICT BOOK_SUPPLIES
LIST BOOK_TITLES DEPT GENRE BY.DSND DEPT BY GENRE
SORT BOOK_TITLES BY DEPT BREAK.ON DEPT_GENRE "TOTAL FOR 'pv'" TOTAL UNITS TOTAL ALLOCATED
Total number of units sold
SORT BOOK_SALES BREAK.ON SALE_DATE "TOTAL:" TOTAL QTY
SORT BOOK_SUPPLIES BREAK.ON @ID "TOTAL:" TOTAL QTY
SORT BOOK_SUPPLIES BREAK.ON @ID "TOTAL:" TOTAL QTY
SORT BOOK_TITLES BY DEPT BREAK.ON DEPT_GENRE TOTAL UNITS  AVG UNITS  MAX UNITS  MIN UNITS PCT UNITS
SORT BOOK_TITLES BY DEPT BREAK.ON DEPT_GENRE TOTAL UNITS AVG UNITS COL.HDG "Avg"  MAX UNITS COL.HDG "Max"  MIN UNITS COL.HDG "Min" PCT UNITS COL.HDG "%" ID.SUP DET.SUP HDR.SUP
SORT BOOK_SALES BREAK.ON SALE_DATE TOTAL QTY AVG QTY COL.HDG "Avg"  MAX QTY COL.HDG "Max"  MIN QTY COL.HDG "Min" PCT QTY COL.HDG "%" ID.SUP DET.SUP HDR.SUP HEADING "'C'--===00 BB SUPER REPORT 00===---" FOOTING "'C'--===00 THE END OF PAGE:  'P' DATE:'D'' 00===--"
SORT BOOK_SALES BY.EXP AUTHOR_NAME BREAK.ON AUTHOR_NAME FMT "70L" TOTAL QTY  ID.SUP DET.SUP HDR.SUP HEADING "'C'--===00 BB SUPER REPORT 00===---" FOOTING "'C'--===00 THE END OF PAGE:  'P' DATE:'D'' 00===--" BY QTY
SETPTR ,,,,,, AT MWPR15,FORM 150
COUNT BOOK_TITLES WITH DEPT ="JUNIOR"
SUM BOOK_TITLES UNITS  WITH DEPT = "JUNIOR"
STAT BOOK_TITLES UNITS  WITH DEPT = "JUNIOR"
SORT BOOK_TITLES TOXML ELEMENTS TO "titles" WITHSCHEMA
SELECT BOOK_TITLES SAVING AUTHOR_ID
SELECT BOOK_TITLES SAVING UNIQUE AUTHOR_ID WITH DEPT = "JUNIOR"
LIST BOOK_TITLES EVAL "'HELLO'"
LIST BOOK_TITLES EVAL "QTY*UNITS"
LIST BOOK_TITLES EVAL "12*13"
LIST BOOK_TITLES EVAL "PRICE*UNITS" COL.HDG "STOCK VALUE" PRICE UNITS
LIST BOOK_TITLES PRICE UNITS EVAL "PRICE*UNITS" COL.HDG "STOCK VALUE" EVAL "PRICE*UNITS*0.175" COL.HDG "STOCK TAX"
LIST BOOK_SALES EVAL "FORENAME[1,1]:' ':SURNAME" COL.HDG "FULLNAME"
LIST BOOK_TITLES EVAL "SHORT_TITLE[1,30]:'... ':TYPE:' ':FORMAT" FMT "50L" COL.HDG "FULL DESCRIPTION"
LIST BOOK_SALES EVAL "OCONV(SALE_DATE,'D'):' ':OCONV(SALE_TIME,'MTS')" FMT "40L" COL.HDG "FULLDATE"
SORT BOOK_SUPPLIES BREAK.ON SUPPLIER_NAME "TOTAL:" TOTAL QTY COL.HDG "TOTAL" PCT QTY COL.HDG "PERCENT" ID.SUP DET.SUP HDR.SUP HEADING "'C'--===00 BB SUPER REPORT 00===---" FOOTING "'C'--===00 THE END OF PAGE:  'P' DATE:'D'' 00===--" BY QTY
LIST BOOK_TITLES EVAL "SHORT_TITLE:' read by ':READER_NAME" FMT "70L"
LIST BOOK_TITLES EVAL (SHORT_TITLE : ' read by ' : READER_NAME) FMT "70L"
LIST BOOK_TITLES SHORT_TITLE FMT "60L" EVAL "STR('_',10)"  COL.HDG "REMARKS"
LIST BOOK_TITLES SHORT_TITLE FMT "40L" EVAL "STR('*',UNITS)" FMT "30L"  COL.HDG "UNITS"
LIST BOOK_TITLES EVAL "TRIM(SHORT_TITLE[1,30]:'... ':TYPE:' ':FORMAT)" FMT "50L" COL.HDG "FULL DESCRIPTION"
LIST BOOK_SALES EVAL "OCONV(FIELD(@ID,'*', 1),'D4')"
LIST BOOK_TITLES EVAL "FIELD(SHORT_TITLE,'(', 1)" EVAL "FIELD(FIELD(SHORT_TITLE,'(', 2),')',1)"
LIST BOOK_SALES EVAL "@DATE - SALE_DATE" CONV "MD0"
LIST BOOK_SALES EVAL "@RECORD<3,1>"
LIST BOOK_SALES EVAL "COUNT(@RECORD<3>,@VM) + 1"  EVAL "@RECORD<3>" WITH EVAL "COUNT(@RECORD<3>,@VM) + 1" = 4
LIST BOOK_SALES EVAL "DCOUNT(@RECORD<3>,@VM)"  EVAL "@RECORD<3>" WITH EVAL "DCOUNT(@RECORD<3>,@VM)" = 4
LIST BOOK_SALES EVAL "@RECORD<3,DCOUNT(@RECORD<3>,@VM),1>"  EVAL "@RECORD<3>" WITH EVAL "DCOUNT(@RECORD<3>,@VM)" = 4
LIST BOOK_SUPPLIES PRICE QTY EVAL "PRICE * QTY * REUSE(0.175)" CONV "MD2" EVAL "SUM(PRICE * QTY)"#
LIST BOOK_SUPPLIES EVAL "ORDER_DATE - DELIV_DATE" CONV "MD0"  EVAL "SUM(ORDER_DATE - DELIV_DATE)" CONV "MD0"
LIST BOOK_SALES EVAL "XLATE('BOOK_TITLES',TITLE_ID,8,'X')"
LIST BOOK_SUPPLIES EVAL "TRANS(BOOK_TITLES,TITLE_ID,ISBN,'X')" EVAL "XLATE('BOOK_TITLES',TITLE_ID,12,'X')"
LIST BOOK_TITLES PRICE DEPT SHORT_TITLE EVAL "IF DEPT = 'JUNIOR' THEN '*': OCONV((PRICE * 0.9),'MD2') ELSE OCONV(PRICE,'MD2')"

Powered by BlogEngine.NET 1.3.1.0
Theme by Mads Kristensen

About the author

Name of author Author name
Something about me and what I do.

E-mail me Send mail

Calendar

<<  August 2008  >>
MoTuWeThFrSaSu
28293031123
45678910
11121314151617
18192021222324
25262728293031
1234567

View posts in large calendar

Recent posts

Recent comments

Authors

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2008

Sign in