ASQ> List Brief from Filename // List out description of
the file
ASQ> List Double // list brief but show mask and code prefix
ASQ> Show Source // show current
ASQ> Set Source enrdata,
stdhist via studentID
//main: enrdata , suppl: stdhist
ASQ> Display grade , firstname
, lastname // No NEED to via studentID
|
ASQ> Set Source enrdata,
stdhist //main: enrdata , suppl: stdhist
2 datafile
ASQ> Display grade , firstname
via studentid, lastname
via
studentid //need via studenttID
|
ASQ> Set Source Customer, DKB100:[slim]Customer //CAN'T
set two same file wif diff location
ASQ> Set Source Customer, DKB100:[slim]Customer
Alias Oldfile
ASQ> Define Oldfile
DKB100:[slim]Customer // Define logical name
ASQ> Find Current where lastname ="smith" ordered
by .firstname .lastname //2
level sorting
ASQ> Find Student Where studentid is between A and B //generate
pointer file
ASQ> Find Common_File where lastname
eq " smith" // 521 recs
ASQ> Find Common_File FOLLOWING
Current where state eq "AR" // 501 rec
ASQ> Find Common_File Where lastname eq "smith"
AND state eq "
AR" // 501 rec
ASQ> Display #31 Total
#22 Average from Current
ASQ> Display studentid fullname credithours sum(1)
grouped by studentid
ASQ >Save ken
// save pointer file as ken.ptr ,
but ken is not current
ASQ> Recall
ken // recall ken.ptr as current pointer file
ASQ>Spawn dir
*.log // list out all file without exiting ASQ session
pls : Save file.asq contain ASQ commands and execute
it by @file.asq
Back
|