Screen | Scope | Describe | Sort/Print | Key | Compare | Transfer | Pointer | Save | Delete | Batch| Purge| Create .key /.dta | Recall | Blank |

RUN DMS:SCREEN (screen name: datafile_formatname.fmt Eg : 053scourse_add.fmt )

Choose Datafile ? eg. Student
Choose Available Formats or define new screen name. eg.Input, Retrieve
Choose option [add | delete | modify | page | order | create | display | print | file ]
1.Add - field , comment , page
2.modify -field, comment, all
3.order - order the field

Add comment
Description: Enter New Student Information
->Add Comment
->shift to attribute mode with prompt [ enter attribute with slash]
->Add Field ,for attribute-> use /BOLD/NOBOLD-> yellow field, blink/noblink->blink field
->Enter description and place into right position
->Use FIELD QUALIFIER to set constraint on data , Hit End to highlight, then hit ENTER

* PLS: If format can't be displayed by Scope, check field order, primary key must be in 1st order.

Back

2 . Four operation options to chooose [ADD|UPDATE|DELTE|INQUIRE]

UPD/ABB/KEY=FULLNAME
ADD/ABB/ ....
DEL/ABB/ ....
INQ/ABB/ ....

MCR vs RUN : MCR allows filename followed by it
eg. $MCR DMS:SCOPE STUDENT/FORMAT=WORKSHOP/OPTION=INQUIRE

ED MAIN.MCF (CONNECT MENU FILE=>SCREEN=>DATABASE)

ITEM ENTER_STUDENT
Description" Enter Student Information"
Mcr Command " DMS:SCOPE STUDENT/FORMAT=WORKSHOP/OPTION=ADD"
END ITEM ENTER_STUDENT

/REP/DEL/NOPRINT/QUE

/rep = replace the .com file each time that option is run
/del = delete the previous version of the .com file each time the option is run
/noprint = do not print the .log file when run
/que = uses default batch que

Remark: Two different screens (full editable/semi editable ) share same datafile. Click Here

Back

RUN DMS:DESCRIBE

Choose datafile? eg.student
Describe Option? [add | allocate | create | delete |list | modify | name | file | show | key ]
OR type HELP

ADD (CREATE TABLE) ITEM 9. EDIT MASK<NONE>? /SSN
ITEM 1. LENGTH ? /VIRTUAL
ITEM 1. FOREIGN DATA FILE?STUDENT
Field in current file to key on ? studentid
foreign field identifier? FIRSTNAME

ALLOCATE (.DTA .KEY) //FOR DATA ENTRY VIA SCREEN

NAME ->NAME SUBOPTION? MODIFY // MODIFY FIELD NAME

MODIFY //Modify filelds in the .DSC file

/DATE=MDY
/SSN
/MONEY

Note: Extending length of DMS datafile

Back

RUN DMS:SORT / PRINT

Data File Name? filename/Qualifier

low? @@07@@//MATCH // ANY 6 DIGIT RECORD WITH 07 (3,4) POSITION
low? ex/ANY //MATCH ANY EX RECORD
low? swrngn/SCAN
low? 45/ ONLY

SORT SELECTION QUALIFIERS

Level 1 ...field? .lastname/extract=20 //len=20
Level 1...field? .date/extract="-2,4" /* default =MMDDYY , -2(right 2=YY) in front,
4( left 4=MMDD) placed follow above=> YYMMDD
low? 82/14/NQ/only // 82/14 is data, but NOT /14 qualifier

DMS:SORT (USE POINTER FILE)
Datafile name? /POINTER=OKLAHOMA //USE .OKLAHOMA (ptr file) for SORT

Studentid/TR1=SEX/HEAD=SEX/LEN=3/BR // SEX is Common Field,
Studentid/TR1=STATE, 2=TRANSLATION

/* USE STUDENTID connect to STUDENT(F) TOFIND STATE AND USE STATE TO CONNECT TO
CODE(F) TO FIND TRANSLATION
(STATE=CODES),PRINT TRANSLATION
*/

RUN DMS:PRINT

DATAFIEL?GLDETAIL/TRANSLATE/NH /* no header shown in report*/

Count /Total || /Average
/head=AcctNo/BREAK /* display 1 times of each group record , must have Group By*/

field? .price /total
total length? 12
edit mask? /money/nod

field? PAYROLLID/TR1=FULLNAME /* Payrollid is linked filed, fullname is col in tr file1

Back

RUN DMS:KEY ( if datafile experiences corruption, do REBUID .KEY file)

Data File Name? 053SCOURSE
Are You Sure? YES

Back

$ RUN DMS:COMPARE ( Compare .dta against .dta)
COMPARE V6.8-01 - Data File Comparison Program 02:44 PM
Copyright (c) 2000, Campus America, Inc.
Data File Name <DKB200:[DEBRA.COURSEFILES]053SCOURSE>? /pointer=wynnepointer
Number of pointers in the Pointer file: 47
Does that seem correct <NO>? y
Data File to Compare Against? catalog
Field in "DKB200:[DEBRA.COURSEFILES]053SCOURSE" to key on <1>? /which field to compare

Enter field comparison commands
Command 1 <Key Only>? field TO field
Build pointers to Matched records <NO>? y // build pointer file to either Match & Unmatch
Pointer file will be built to Matched records

Back

RUN DMS:TRANSFER .DTA (Transfer content from one file to another file)

Greg's example

PLS: Create pointer file using Sort, Pointer (Rand) or ASQ, then transfer pointer to FileA

left side datafile? Student/ALL // ALL only work on all records, NOT PTR FILE
right side datafile? FileA

Key Field Load<NO>? NO

FIELD TO TRANSFER (.PTR)

command1? .* TO .* // transfer all data from student to fileA
command2? STUDENTID TO STUDENTID //transfer from source to destination
command 3? FIRSTNAME FROM FIRSTNAME //transfer from destination to source

Back

RUN DMS:BLANK (Fill data into specified col)

Data File Name <FILEA>?
Number of pointers in the Pointer file: 480
Does that seem correct <NO>? y

Fields to Blank? okwebreg/put="y" /* /put/fill/list/display */
Proceed with Blanking <NO>? y

Back

STUDENT IDENTIFIER? 40-85-1002

search user with having BYPASS privilege
: $ pipe mcr authorize show */full | searchit sys$input username:,bypass

Search who is using regcode.dsc
$ cd regsys_files:[reg.files]
$ pipe show device/files/nosystem | searchit sys$input "regcode.dsc"

Back

RUN DMS:POINTER (save a pointer file with choices)

DATAFILE? ENRTMP/ALTERNATE=ABC.PTR // SAVE SUBSET .PTR

Option?

Back

RUN DMS:SAVE (save and recall pointer file)
Option? Save
SAV: POINTER FILE NAME? OKLAHOMA // OKLAHOME.PTR
Option? Recall
REC: POINTER FILE NAME?OKLAHOMA

Option ? Name
Associate Pointer File with its Data file

Back

@DMS:BATCH (Only DMS Program Starts @)
Batch File Name? GAP_REPORT
Brief Purpose? REPORT OF STUDENT WITH SPECIFIC GPA
!FIND STUDENT WITH SPECIFIC GAP , PRINT REPORT OF THOSE STUDENT
CTRL-Z

1 >RUN DMS:SORT
LEVEL 1,2,3 SELECTION

/* SAVE RESPOND TO PROGRAM */

2 >RUN DMS:PRINT
COLUMN 1,2,3,4

/* REPONSES TO THIS PROGRAM IS SAVED */

DMS:QUEBATCH is command to run the BATCH FILE

Back

Create .Key & .Dta

1. Use Run DMS:describe
use Option : List
Fill up the field name
2 Use Run DMS:describe
use Option : Allocate
Fill up the code and explaination

Back

Recall File

Create Recall File
1. Use Run DMS:Sort
DATA FILE NAME? filename/SAVE=recallfile
// save as filename.SRF (S=sort)

Use Run DMS:print
DATA FILE NAME? filename/SAVE=recallfile
// save as filename.PRF (P=Print)

Call Recall File

Run DMS:SORT

DATA FILE NAME? recallfile/recall // it is recallfile, NOT datafile (needless to type .srf)

recallfile/recall=verify //list recall file on screen

Back

RUN DMS:DELETE

OPTION? ALL // DELETE ALL RECORD IN FILE
OPTION? Pointer // delete record based on pointer file

ALL to delete all records from the file
KEY [keyid] to delete records by key
MAXIMUM to delete all allocated records
POINTER to delete records by Pointer file

Back

DMS:PURGE

Compress the .dta file by eliminated the deleted record ( NOT shown )
ReBuild .KEY file .Save space occupied by deleted record

Back