IQ
User
Manual
Table
of contents
1. Introduction..................................................................................................................................................................................... 3
1.1. Start DMS.IQ.................................................................................................................................................................................. 4
1.2. Selecting fields............................................................................................................................................................................... 4
1.2.1. Example of screen lay‑outs.......................................................................................................................................................... 5
1.3. Change of program........................................................................................................................................................................ 5
1.4. Command structure....................................................................................................................................................................... 6
1.5. Retrievel of data with IQ............................................................................................................................................................... 6
1.6. ON‑LINE manual............................................................................................................................................................................ 6
1.7. END ‑ Ending/change of program............................................................................................................................................... 7
1.7.1. SPR ‑ Return to TAMOS‑Menu................................................................................................................................................. 7
1.7.2. Implementing IQ‑programs in TAMOS..................................................................................................................................... 7
1.8. UPP/DOWN/ALL Screencontrol FROM‑TO............................................................................................................................. 7
1.9. Superindex. Text retrievel ‑
capital letters.................................................................................................................................. 8
1.9.1. Superindex ‑ Text retrievel ‑
Mixed letters................................................................................................................................. 8
1.9.2. Superindex ‑ working method..................................................................................................................................................... 8
1.10. SELECTION ‑ SEL/#..................................................................................................................................................................... 8
1.10.1. SELECTION ‑ DATE‑fields........................................................................................................................................................ 8
1.11. SAVE‑command Saving
programdefinitions............................................................................................................................ 9
1.11.1. Copying a program...................................................................................................................................................................... 9
1.11.2. Change of programname............................................................................................................................................................. 9
1.11.3. Commands as programs.............................................................................................................................................................. 9
1.12. KILL‑command ‑
Deleting a program....................................................................................................................................... 9
1.13. @ ‑ Roll forward in records......................................................................................................................................................... 9
1.13.1. ‑ Roll backwards in
records.................................................................................................................................................... 9
2. Inquiries ‑ transactions
(postings)............................................................................................................................................. 10
2.1. FIRST/LAST/THIS ‑
transaction............................................................................................................................................. 10
2.2. ‑ Transactions ‑
change of direction..................................................................................................................................... 10
2.3. Eg. of an transaction‑IQ.............................................................................................................................................................. 10
2.4. AMOUNT and TEXT‑SELECTION......................................................................................................................................... 10
2.5. Total of the amount‑fields.......................................................................................................................................................... 11
2.5.1. Opening‑total (balance)............................................................................................................................................................. 11
2.6. Stored transaction....................................................................................................................................................................... 11
2.7. Change of transaction ‑ IQ with RAPGEN............................................................................................................................... 11
3. Helpfunctions................................................................................................................................................................................ 12
3.1. HLP ‑ Online manual help........................................................................................................................................................... 12
3.1.1. MAN ‑ changing the manual.................................................................................................................................................... 12
3.2. ? ‑ Command‑overview............................................................................................................................................................... 12
3.3. DOC ‑ Program‑documentation................................................................................................................................................. 13
3.4. FILE ‑ File‑view and index‑view................................................................................................................................................. 13
3.5. FLD ‑ Field‑view and
fieldformat‑view..................................................................................................................................... 13
3.6. CAL ‑ calculator........................................................................................................................................................................... 14
3.7. HOW ‑ search‑definition
view................................................................................................................................................... 14
3.7.1. Searching in DMS.IQ................................................................................................................................................................. 15
3.7.2. How DMS.IQ search.................................................................................................................................................................. 15
3.8. TEST ‑ Testprint of
searching/keybuilding............................................................................................................................. 15
3.9. DEMO ‑ Demonstration‑mode................................................................................................................................................... 16
3.9.1. DEMODEF ‑ create a demonstration‑textfile.......................................................................................................................... 16
3.9.2. DEMOOUT ‑ Formation of program‑demonstration............................................................................................................. 16
3.9.3. DEMO ‑ textfilenames................................................................................................................................................................ 17
3.10. PRINTDOC ‑ printout of manual.............................................................................................................................................. 17
3.10.1. Manualstructure and filenames............................................................................................................................................... 17
4. Users and permissions................................................................................................................................................................. 18
4.1. User‑classes................................................................................................................................................................................. 18
4.2. User groups.................................................................................................................................................................................. 19
4.3. BYE - end and changing of passwords.................................................................................................................................... 19
4.4. PROGRAMS - program permissions......................................................................................................................................... 20
4.5. FILES - file permissions.............................................................................................................................................................. 20
4.6. USERS - Maintenance of the user
definitions......................................................................................................................... 21
4.6.1. USER options............................................................................................................................................................................ 21
5. Keys and commands.................................................................................................................................................................... 22
5.1. KEY ‑ definition of function
keys.............................................................................................................................................. 22
5.2. Start ‑ Define commands for
start of report............................................................................................................................. 23
5.2.1. START DATAMASTER programs......................................................................................................................................... 23
5.2.2. START ‑ other programs........................................................................................................................................................... 23
5.3. SET ‑ Definition of a new
command.......................................................................................................................................... 23
5.3.1. Help for userdefined commands............................................................................................................................................... 24
5.4. Commands as program‑numbers............................................................................................................................................... 24
5.4.1. Several commands combined.................................................................................................................................................... 24
5.5. EDIT ‑ Free edit of commands................................................................................................................................................... 24
5.5.1. Command numbers..................................................................................................................................................................... 25
5.5.2. Commands with user‑statement............................................................................................................................................... 26
5.5.3. Commands with screen statement............................................................................................................................................ 26
5.5.4. EDIT other text files.................................................................................................................................................................... 26
5.6. DMS.IQ's intern command structur.......................................................................................................................................... 26
6. Extern programs as commands................................................................................................................................................... 28
6.1. RAPGEN ‑ DMS.RAPGEN
reportgenerator............................................................................................................................. 28
6.2. Start of reports............................................................................................................................................................................. 28
6.3. Q ‑ DMS.JOBQUEUE.................................................................................................................................................................. 28
6.4. DATA ‑ DATAMASTER file
maintenance............................................................................................................................. 29
6.5. Start of DATAMASTER programs........................................................................................................................................... 29
6.6. Start of other programs............................................................................................................................................................... 29
7. Generated programs..................................................................................................................................................................... 30
7.1. Calculation and generating........................................................................................................................................................ 30
7.1.1. Reading of other files................................................................................................................................................................. 31
7.2. Function 15 ‑ standard program
parameters............................................................................................................................ 31
7.3. Changes without generating...................................................................................................................................................... 32
7.4. RAP ‑ DMS.RAPGEN ‑ IQ generator........................................................................................................................................ 33
7.4.1. New facilities in function 7........................................................................................................................................................ 33
7.5. NORMAL/AFTER/FIRST/LAST calculations........................................................................................................................ 34
7.5.1. Normal inquiry............................................................................................................................................................................. 34
7.5.2. List‑inquiryes.............................................................................................................................................................................. 34
7.5.3. Posting‑inquiry........................................................................................................................................................................... 34
7.6. LKY‑Lampfunctions.................................................................................................................................................................... 35
7.7. Subfunctions................................................................................................................................................................................ 35
7.7.1. MESS ‑ Message on the screen............................................................................................................................................... 35
7.7.2. INPUT ‑ Input of a functioncode............................................................................................................................................. 35
7.7.3. LINK ‑ activate another program.............................................................................................................................................. 35
7.7.3.1. Inquiryes dependent on a type code...................................................................................................................................... 35
7.7.3.2. Inquiries on more sides............................................................................................................................................................. 36
7.7.4. LINK ‑ carry out a command‑stringht...................................................................................................................................... 36
8. Installation and file‑definition..................................................................................................................................................... 37
8.1. Operatingsystem and space
requierements............................................................................................................................. 37
8.2. TAMOS selector.......................................................................................................................................................................... 37
8.3. DRN ‑ Definition of files............................................................................................................................................................. 37
8.3.1. DMS.IQ installation of files....................................................................................................................................................... 37
Figures.......................................................................................................................................................................................................... 38
Keyword index............................................................................................................................................................................................ 39
1.
Introduction
DMS.IQ enables
users with no programming experience to define inquiry functions with screen
lay‑outs and retrievel functions.
In the next
chapter we shall learn that the users just select the fields from the files
they wish on the screen. Then IQ creates a screen with this contents and built
relations between the files involved.
A quick
retrievel of data is importent to all inquiery functions. DMS.IQ selects the
correct indexes of the files.
If a field is
not an index of a file ‑ the superindex will be used to retrieve the
data.
The superindex
method is descriped together with Selections.
A very quick
change from one inquiry function to another is an importent feature.
Furthermore it
is possible to hold more than one inquery on the screen at the same time. The
UPP/DOWN/ALL commands will control this.
Inquiries of
posting files like ‑ Salesledger ‑ Postings ‑ Orderdetails
are supported by several functions of retrievel by:
‑ text
‑ date
‑ no.
‑ code
‑
amount
and scroll the posting forward or backwards. All these
possibilities are descriped in chapter 2.
DMS.IQ allow the
user to create his own user interface with programs, commands and functionkeys.
These functions are descriped in chapter 5.
The
Systemadministrator may restrict these possibilities, so that an user only are
able to select programs relevant to his function.
IQ has no
limitation in the number of users ‑ chapter 4.
Programs from
DMS.RAPGEN or DMS.DATAMASTER may be used as commands in IQ ‑ chapter 7.
DMS.IQ may be
used in two different ways:
‑ The
user type in the number of the selected fields and IQ create a screen lay‑out
automatic.
SAVE the
definitions and the IQ ‑ standard functions will make the inquieries
work.
‑ If
DMS.RAPGEN is installed the user may redesign the IQ and lay‑out,
and
define all calculations, selections, file‑relations allowed in
DMS.RAPGEN.
These functions
are descriped in chapter 6. A basic knowledge of DMS.RAPGEN is necessary.
DMS.IQ may be
used on Quattro/8870 and Targon 31‑35.
IQ allowes
inquiries on records locked by other users.
IQ may be used
on both index‑seq. and relative files.
If DMS.RAPGEN is
installed the installation of DMS.IQ is very easy, as the file definitions are
common.
IQ needs 1500
sectors of discspace.
Installationprocedure is descriped in chapter 8.
2.1. Start
DMS.IQ
When IQ is
selected from TAMOS a password is requested (username).
The password
restricts which programs and files the user is allowed to use ‑ or if the
user is allowed to define programs/files.
IQ is installed
with the following users:
N = May
use programs and files
Y = May
define programs
FILE =
May define files
DMS = Systemadministrator may
maintain other users passwords
When the user
has typed in his password his program menu is shown or if he has not yet
defined a program ‑ the screen shows the files implemented.
You may now
select a program or define a new program and select a numbers of fields from
one or more files. The program may be saved with a number and a name.
2.3. Selecting
fields
FI#1‑5,40 Creates
a horizontal screen with these fields
KU#1‑3,7L Creates
a vertical screen. (List lay‑out)
VA#1‑3,LE#5‑10 Two
files may be related
KU#1‑10/KP#1‑10 With
a / an transaction inquiery is created
VA#1‑10/LE#1‑10/OL#1‑10,OS#2 Multiple
files may be used
KU#1,3,7/KP#1‑10L The
list lay‑out may be used with transaction files
SAVE Saves
the inquiery program
SAVE:10 Saves
the program as no. 10
SAVE:10,Customers Saves
the program with a name
SAVE:10,Suppliers! The !
replaces an existing program
SAVE:Customers Saves
the program as next free number
DMS.IQ remembers
the fields last used in a file.
KU Select
the same fields last used from the file ‑ KU
KU# Shows
the fields in KU and you may edit
17# Shows
fields in program 17
The user do not
have to care about relations between files.
When you type in
SAVE the IQ will request: programno. and name. I.e. you use SAVE:.........
there are no request. Generally commands in IQ can be given directly or given
at requests.
A saved program
may be worked on in the DMS.RAPGEN.IQ, i.e. screen lay‑outs may be
changed and all types of calculations may be amended.
RAP select
DMS.RAPGEN in the IQ version.
Additional fields
from the files may be used:
#K = KEY Key
when reading a file
#P = Packed
key Key
packed out before shown
#R =
Recordno. No.
of the last read record
#N =
Relativno. As R,
but first data record
Example: LE#1‑5,K,R/VA#K,1‑3,N
2.4.1. Example of
screen lay‑outs
Figure 1 FI#1‑5,40
screen layout
01
Accountno.
02
Accounttype
03
Accountname
04
Accesscode
05
V.A.T.‑code
40
Opening bal.
KU#1‑3,7L
creates the screen ‑ vertical. Lines are numbered at the right side of
the screen.
Figure 2 KU#1‑3,7L
screen layout.
01 02 03 07
CUSTNO. GROUP
NAME PHONE
5001 3 FOX Ltd. 719324911 1
5002 3 WAX & WAX 718329310 1
5003 3 FUTURE 719427891 1
FI#1‑7,40/FP#6,8,4,3,9
creates the screen shown below. Note the selection‑fields and the total
field.
Figure 3 FI#1‑7,40/FP#6,7,4,3,9
screen layout.
01
Accountno. 250109 06 Budgetcode 2
02
Accounttype 1 07 Amountcode 3
03
Accountname SALARIES 40 Openingbal. 0,00
04
Accesscode 0
05
V.A.T.‑code 0
06
Trans 08 date 04tc
03 09 amount
TRANS.NO. DATE TR.C
TEXT AMOUNT TOTAL
NR.
15 88.07.10 1
Salary 23561.00 23.561.00
1
22 88.07.31 1
Salary 24007.83 47.568.83
2
42 88.08.10 1
Salary 9852.00 57.420.83
3
Figure 4 FI#1‑7,40/FP#6,7,4,3,9L
screen layout.
01 02
03 04 05
06 07 40
ACC.NO. A.T.
ACC.NAME ACC. VAT
B.C. AC. OP.BALANCE
06
Trans 08 date 04tc
03 09 amount
TRANS.NO. DATE TR.C
TEXT AMOUNT TOTAL
NR.
2.5. Change of
program
The END command
aborts a program and return to the IQ‑menu, which shows programs
available.
The FIL command
shows files implemented and by typing the two letter fileshortname, you get a
view of the fields in the file.
It is possible
to select a program directly eg. END:7 or 7END.
You may select a
file by typing in eg. VA#1‑10 without using the END command (KEY).
If you type VA
the IQ look up into the file after the key, VA if this key is not available ‑
the last used fields from the file VA are shown.
By change from
programs/files DMS.IQ tries to find relations between the files involved or the
files prior used. If relations exists the related record will be shown.
Programs and
files may be activated by keys (KEY‑command chapter 5.1).
The SPR‑command
return to TAMOS‑menu. If a program is selected from the TAMOS‑menu
the END command will do the same.
Figure 5 IQ program
menu.
1.
Sales‑orders
2.
Suppliers‑orders
3.
Articles‑orders
4.
Customers‑orders
5.
Sales‑ledger
6.
Bought‑ledger
Figure 6 IQ FILE menu
GM
GENEREL LEDGER M.FILE
AM ARTICLE MASTER FILE
GT
GENEREL LEdGER TRANS
SL STOCK LOCATION FILE
GB
BUDGET FILES
ST STOCK TRANSACTION FILE
DC
DEBTOR/CREDITOR MASTER FILE
DT
D/C TRANSACTION FILE
2.7. Command
structure
In generel all
IQ commands may be activated by softkeys or by typing in the 3 letter command
eg. END or FIL.
The name of the
commands may be changed with the SET command.
Eg.
SET:CALCULATOR = CAL gives the user a new command CALCULATOR.
Hereafter both
CAL and CALCULATOR gives the same function.
2.9. Retrievel
of data with IQ
If you per eg.
have selected a customerfile as the mainfile in an inquery and this file has
two indexes, eg. customerno. and matchcode ‑ you may type in the customerno. or the
matchcode.
IQ will examine
both indexes for a matching key.
The command
SUPER or the SUPER softkey will activate the superindex function ‑ a free
text retrievel possibility.
If you wish to
retrieve BROWN you may type in BROWN ‑ if you wish to retrieve the Browns
too ‑ you type &&BROWN. This function is not as fast as the first
one.
If you wish to
decide which index to search in, then just type in eg. 3:BROWN and IQ searches
only in index 3.
2.11. ON‑LINE
manual
This usermanual
is online available on your system and is activated by the HLP command, or may
be printed with the PRINTDOC command.
In order to
combine the on‑line help as well as a written documentation, the chapters
are grouped after commands:
‑
END/SPR Ends
a program/change to a new program
‑
UPP/DOWN/ALL Splitscreen
commands
‑
SUPERINDEX/SEL Retrievel
and selection of data
‑
SAVE/KILL Store
and delete of screen
‑
@/ Scroll
functions
2.13. END ‑
Ending/change of program
The END ‑
command (key) returns to DMS.IQ menu, or from IQ menu to TAMOS. In connection
with the END‑command a new program or a new file may be selected.
7
END Program
7 is started
CM
END CM‑file
is selected
BALANCE
END First
program containing the word BALANCE in the programname is selected
2.14.1. SPR ‑
Return to TAMOS‑Menu.
The SPR‑command
returns to Tamos.
2.14.3. Implementing
IQ‑programs in TAMOS
DMS.IQ is
implemented in TAMOS under eg. the programname 00/DMS.IQ.
When you use eg.
the programname 00/DMS.IQ, STAR may be started directly under user STAR without
any password protection.
If a programno.
is used in TAMOS ‑ this program will start directly and the END and the
SPR ‑ without any programno. will return to TAMOS.
All programs
generated in IQ may in this way be integrated in other usermenues.
2.15.
UPP/DOWN/ALL Screencontrol FROM‑TO
These commands
defines where the user wish the inquiries positioned on the screen ‑ UPP
upper part ‑ DOWN lower part ‑ ALL full screen.
Eg. DOWN the
next inquiery will be showed on the lower part and the upper part remain
unchanged.
The commands may
be used in connection with:
‑
Help‑functions
‑
Calculator
‑
File‑overviews
‑
Field‑overviews
If you type in a
programno. or a fileshortname continued by UPP/DOWN/ALL the commands will work
as the END‑command and select a new program or file and use screen
following your command.
Figure 7 Screen
picture by use of UPP/DOWN
01 Customerno. 5001
02 Customertype 3
03 Name 1
04 Name 2
05 Adress 1
06 Adress 2
07 Phoneno.
27 Actual balance 174304,57
01 Accountno. 250109 07 Amountcode 3
02 Accounttype 1 41 Last amountdate 88.08.10
03 Accountname salaries 42 Date last accountprint 0
04 Accesscode 0 40 Op.balance 0,00
05 V.A.T.‑code 0
06 Budgetcode 2
06 07Date
04pk 03 09amount
Transno. Pr.date Pos Text Amount Total
15 88.09.15
0 Salary ‑23561,00 ‑23.561,00
22 88.09.15
0 Salary ‑24007,83 ‑47.568,83
42 88.09.15
0 Salary ‑9852,00 ‑57.420,83
2.17.
Superindex. Text retrievel ‑ capital letters
If eg. the text
"Brown" is not in any index of a customerfile ‑
"Brown" may be retrieved with the Superindex‑function.
The command
SUPER is typed in (eg. function‑key) after "BROWN" or if you
have got the message: "This record is not found".
In order to find
the next record with "BROWN" just press CR‑key.
Figure 8 SUPERINDEX
retrival of BROWN
01 02 07
Phoneno. NAME RAPGEN
42138844 Cook & Brown 01.06.87
42311387 Brownequy Ltd. 10.11.86
31578211 K.E.BROWN 01.03.82
42160777 Father & Browns 15.05.86
2.18.1. Superindex ‑
Text retrievel ‑ Mixed letters
If you wish to
find BROWN and the name is typed in Brown ‑ you shall not find this
record unless you type &&BROWN.
Retrievel with
&& is a little slower than without, as all letters are converted to
capital letters before the retrievel.
2.18.3. Superindex ‑
working method
The Superindex
reads an indexfile without using the index. It reads as many records at a time
(eg.100) that memory space allows.
After the
reading, the block of records (eg.100) is retrieved of ex. BROWN.
BROWN can in
this way be found in any text‑field (eg. adress, contactperson etc.).
The Superindex
retrieves information at a speed of ap. 2000 records per minute.
Superindex may
only be used on text‑fields, but may be combined with selections on
numeric fields (SEL command).
During a
retrievel information of the % of the file, retrievel are shown in the lower
right corner of the screen.
2.19. SELECTION ‑
SEL/#
A selection may
be activated on any field in a mainfile eg. #15=1. DMS.IQ will now only show
records where fieldno. 15=1.
A selection is
deactivated by typing # or pressing the ESC‑key. After the reading, the
last record in a file ‑ selections, are automatically deactivated.
You may use
several selection criterias at the same time.
#15>0
#15>‑3, #15<5
#15<>0, #27>1000,47
#15=3
#1(3,4)="07"
2.20.1.
1.10.1. SELECTION ‑
DATE‑fields
If date fields
is defined DD.MM.YY (format ,6,) selections will be simple to define, as the IQ
converts the date to YY.MM.DD. If a field is not defined as a date‑field
a D mut be added to the field. Eg.
#24D>310390.
2.21.
1.11. SAVE‑command
Saving programdefinitions
When an IQ‑screen
with fields from one or more files has been defined, eg. FI#1‑20, the definitions
may be changed with the RAP‑command and saved with the SAVE‑command.
SAVE ‑ save IQ definitions
SAVE:10 ‑ save IQ definitions as no. 10
SAVE:10,ARTICLE‑IQ ‑ as above with a programname attached
SAVE:10,ARTICLE‑IQ ‑ replaces existing definitions
SAVE:ARTICLE‑IQ ‑ next free no. is used
2.22.1. Copying a
program
When you select
programno. 10 and give the SAVE‑command a copy of no. 8 will be saved
under a free no.
Function no. 10
of DMS.RAPGEN‑IQ may do the same.
2.22.3. Change of
programname
The programname
may be changed just by saving the program with the new name eg. SAVE:10,NEW ART‑LIST
2.22.5. Commands as
programs
eg. SAVE:11,END
OF IQ=SPR (SPR is a command!)
When you select
program 11 the SPR command will be executed. In this way all commands may be
programs in the menu.
2.23. KILL‑command ‑
Deleting a program
The KILL‑command
delete a program saved with the SAVE‑command.
eg. KILL:10
Programno. 10
will be deleted.
2.25.
1.13. @ ‑
Roll forward in records.
This function
may be used in connection with stored records. DMS.IQ store from files used in
the last 100 records ‑ even if you have used multible files.
The no. of these
records may be seen on a "List form" right on the screen.
If you type in @
the last used record from a file is showed ‑ even if you have
interchanged programs.
2.26.1. ‑ Roll backwards in records.
If you type in
the previous inquiry is repeated on the screen. After you have used the to go backwards ‑ you may use the @ to
go forward again.
If you are
inquiring of "Transactions" the
may be used to go backwards and show the previous screen of transactions
‑ instead of going forward with the CR to a new screen.
3.
Inquiries ‑ transactions (postings)
You may define
an inquiry on a customerfile and a transactionfile
CU#1‑10/CT#1‑10
The fields from
CU (customerfile) 1 to 10 and the fields from CT (transactions) 1 to 10 will be
shown. The / indicates that the CT‑files is a transactionfile belonging
to the CU‑file.
4.1.
FIRST/LAST/THIS ‑ transaction
FIRST ‑ Start with the first page of transactions.
LAST ‑ Start with the last page of transactions.
THIS:10 ‑ Start from transaction no. 10.
4.3. ‑ Transactions ‑ change of direction
The
changes direction in which the transactions are shown on the screen.
4.5. Eg. of an
transaction‑IQ
When you define:
GL#1,3,40/GT#6,8,4,3,9L (L‑listform)
Figure 9 Transaction
inquery with GL#1,3,40/GT#6,8,4,3,9L
01 03 40
ACC.NO. ACC.NAME OP.BALANCE
06trans 08date
04tc 03 09amount
TRANS.NO. DATE CODE
SALARY TEXT SALARY AMOUNT TOTAL
where the fields 6, 8, 4 and 9 are defined as
transactionno, date, transactioncode and amount.
When you are
asked: "PRESS CR FOR NEW PAGE" you may select on the transaction
fields in various ways.
4.7. AMOUNT
and TEXT‑SELECTION
It is possible
to select transactions on the above mentioned criteria and based on the entered
value IQ decide (or try to decide) which field you wish to select on.
Transactionno. 5 ‑
x digits eg. 47111 Starts
from transaction 47111 and forward.
DATE Valid
date eg. 310390 or 900331 Shows
only trans. after this date.
TC 1‑4
digits eg. 47 Shows
only trans with TC=47.
Amount 9.99
digit eg. ‑100,00 Shows
only trans. with this amount.
Text xxxxx
alpha/num. eg. VAT Shows
only trans. with this text.
DMS.IQ selects
the fields after the field definitions.
The selections
may be changed in DMS.RAPGEN ‑ IQ calculations.
If more than 100
records are read before a transaction is found then note the counter in the
lower right area of the screen.
Some of the
selections may conflict eg. if you enter 1 and wish to find transactionno. 1
then all transactions with TC=1 will be shown. So in order to avoid this enter
the field with the correct length i.e. 00001.
If two fields
have the same length then you have to use the DMS.RAPGEN‑IQ calculations.
4.9. Total of
the amount‑fields
If the last
field in a transaction‑line is an amount (in our eg. field 9) a total
field calculated and shown ‑ if the required space is available on the
screen.
The total is sum
of ALL transactions and not only of the transactions you may see on the screen.
The total‑field
is defined as the first free‑field and named TOTAL.
You may use this
piece of information if you wish to change the program in DMS.RAPGEN.IQ.
The total‑field
will be komma‑edited if space is available.
4.10.1. Opening‑total
(balance)
If the last
field from a mainfile eg. CU#40 is an amount‑field this will be added to
the total field.
4.11. Stored
transaction
Each transaction
is numbered in the right side of the screen and an inquiry may be started by
refering to this number:
THIS:10
The IQ stores
information of the last 100 transactions in all files used. If you make a
inquiry on a salesorderfile, eg. which orders do we have on this articleno.,
the screen will show the orderlines. If you then change to an inquiry of some
customers the IQ remembers the orderlines and show customer information related
to the customers.
In order to make
it possible to roll forward/backward IQ built a table consisting on records the
first time they are read. Furthermore a table of TOTAL‑amounts are built.
If a mainfile‑record
has more than 1000 transactionfile‑records the text:
SWAP 500
may be noticed. This means that 500 transactions have
been read and that it will only be possible to roll backwards 500 transactions.
4.13. Change of
transaction ‑ IQ with RAPGEN
DMS.RAPGEN
function 7 ‑ change of a screen‑image ‑ the LINE command will
help you to show a transaction on multible lines. Furthermore may calculations
as eg. IF.....PRINT (L=7‑8) show transactions on more than one line.
In the special
function 15 ‑ standard program parameter ‑ IQ marks, which fields have
been used for selections/totals. Here you may change the standard suggested by
IQ.
Function 15 MUST
be used in order to generate a transaction inquiry ‑ even if you have no
changes ‑ because if not the program will not be run.
5.
Helpfunctions
DMS.IQ have a
long queue of help‑ and view‑functions, which are descriped in the
following.
6.1. HLP ‑
Online manual help
By help af HLP
command you may get a short description of the different functions in DMS.IQ.
If you set in
HLP you will get the documentation for the program, you use right now (see DOC
command), if you don't have this, DMS.IQ's generel help will be shown.
Key in HLP:CAL
or CAL followed by HLP‑key, you will get a closer instruction how to use
the CAL command. Key in HLP:1.9.2 or HLP:1,9,2 you will get section 1.9.2 from
the manual. HLP:0 specially, causes that the contents is shown.
When you is
being asked to PRESS CR. or PRESS CR FOR NEW PAGE in the HLP function, you may
key in a command or press a commandkey, and help for this function will be
shown. You may also key in a programno., eg. 20, and the help will be shown.
If you for a
program in DMS.RAPGEN‑IQ have made a documentation with function 11 for
the program you use in IQ, it will be this help which is shown, if you press
HLP.
6.2.1. MAN ‑
changing the manual
This command is
(naturly) for SUPER‑SUPER users and may normally not be used on a
finished installation. In certain cases the manual has to be translated to
other lanquages, why the command is mentioned here.
When you have a
help‑screenpicture and is asked to press cr. you may give the command
MAN. Hereby you activate the text‑editor on the belonging textfile and go
directly to the relevant line in this.
After changing
the manual this should be written out with PRINTDOC command (see later) so the
contents may be build to use for eg. HLP:1,9,2 references.
The MAN command
is special and the name can't be changed, exactly as the command can't be
permitted except under user 1.
6.3. ? ‑
Command‑overview
By help of ? you
will get a view over the command, which you may use (these may change from user
to user and from program to program).
In contrast to
the normal TAMOS ? function, where only one single messageline come through,
will be shown one or several screenpages with explanatory text and eg.
functionkeyno. for each command.
One single line
won't tell much about help to IQ's functions, while you may have several
commands and because the names of these are unlimited to 3 characters.
Figure 10 ? Function overview.
END Finish this function (Press:13)
SPR Tamos menu (Press:4)
? Command‑view (Press:6)
HLP Usermanual (Press:2)
HOW Search‑definition view
KEY Definition of functionkeys
CAL Calculator (Press:3)
UPP Screenpicture from‑to
(DOWN/ALL) (Press:17/14/11)
THIS Postings first/last (FIRST/LAST) (Press:16/15)
DOC Maintain programdocumentation
RAP DMS.RAPGEN‑IQ (Press:7)
BYE New password
RAPGEN DMS.RAPGEN‑reports
Q DMS.Jobqueue
SET Define a command
SUPER SUPERINDEX (Y) (Press:8)
SEL Define SELECTIONS
FIL File‑view (Press:9)
FLD Field‑view (Press:10)
DEMO Demonstration
SAVE SAVE program (Press:12)
START Define command for report‑start
6.5. DOC ‑
Program‑documentation
With this
function you may maintain the program‑documentation in exactly the same
way as in DMS.RAPGEN‑IQ function 11.
Here you have
200 lines of free text available and may write an explanation of the program
functions or the single fields origin.
This
documentation is shown when pressing HLP in the mentioned program.
To maintain the
documentation you choose the mentioned program and gives the DOC command.
Figure 11 DOC ‑ Entering program documentation.
This program is used to debtor‑posts inquiry, but normally only posts
with
balance over 1000, because the others are considered uninterested.
If you turn on lamp 1 (R1) you may be permitted to see these posts, with
lamp (R2) you may see more specifications regarding the posts.
This is done with a special trick in calculations, IF LKY(2) PRINT (L=8‑9),
see the chapter regarding DMS.RAPGEN‑IQ in the manual.
6.7. FILE ‑
File‑view and index‑view
With the FILE
command you get a view regarding those files you are permitted to use.
The command may
eg. be used in the menu to change the programmenu to a filemenu. (You may
return to programmenu by pressing cr).
If you haven't
defined any programs in the system, DMS.IQ itself will change to filemenu. It
is the same if you don't have permission to use any programs at all.
With FIL:VA you
give a filename as parameter to the FILE command, and instead you get a view
regarding index/fileconnection definitions for this file:
Figure 12 FIL:VA index/file connection overview.
VA DEMO‑STOCKFILE
01 STOCKNO 1,S
02 SUPPLIERNO 6,1,S
GR ==> STOCKGROUP 7
LE ==> SUPPLIER 6,S
6.9. FLD ‑
Field‑view and fieldformat‑view
With the FLD
command you get a view over the fields in a file. If any file is mentioned you
get a view over the last chosen files fields, eg. the programs mainfile.
With FLD:VA you
give a filename as parameter to the FLD command, and instead you get a view
over the fields in this file.
FLD:KU, if you
put comma after the filename you get a bigger view over the fields, where you
may see, how the fields are defined (fieldformats).
Figure 13 FLD field and format overview.
01 CUSTOMERNO. 4 12 LINE DISCOUNTCODE 1,
23 GIROCODE 1,
02 CUSTOMERSTATUS 1 13 K/V RELATION L 1,
24 REMINDERCODE 1,
03 NAME 1 25 14 TOTAL DISCOUNT CODE 1,
25 INTERESTCODE 1,
04 NAME 2 25 15 TOTAL DISCOUNT SAT ‑3,2
26 KREDIT LIMIT 3
05 ADRESS 1 25 16 TAX CODE ‑1, 27 CURRENT BAL. ‑8,2
06 ADRESS 2 18 17 CURRENCY CODE 2,
28 PAYMENT DATE ‑8,2
07 PHONENO. 10 18 WHOLESALE SOCIETY 1,
29 LAST PAYMENT 6,
08 DELIVERY CODE 1, 19 SALESNO. 3, 30 FREE ‑8,2
09 PAYMENT CODE 1, 20 CUSTOMERGROUP 3,
31 FREE ‑8,2
10 REMAIN ORDER COD 1, 21 VIKA‑REFERENCE 2,
32 FREE ‑8,2
11 SALESPRICE CODE 1, 22 DELIVERYADR. 1,
33 FREE ‑8,2
FLD:VA,2 if you
also give a fieldnumber one line per field is shown and eg. extra field‑description.
This filedescription may be made with TXT command in the file‑definition‑module
(DRN). It starts from the field you gave.
Figure 14 FLD:VA,2 extended field description.
02 NAME
20
03 SALESPRICE
6,2
SUGGESTED SALESPRICE IN DANISH KR.
04 BARGAIN PRICE
6,2
BARGAIN PRICE IN SUPPLIERS
CURRENCY
05 LAST BARGAINDATE
,6,
UPDATED BY REGISTRATION OF STOCKSUPPLY.
06 SUPPLYNO.
3
3 NUMBERED REFERENCE TO THE
SUPPLYFILE.
ENTER AS KEY 2 IN THE STOCKFILE.
07 GROUPNO.
2,
6.11. CAL ‑
calculator
With this
command a calculator will be available, and may eg. only press a queue of
numbers and these are sum up on the extreme right.
You may also
write more complicated calculations on the single lines, eg. 2 *
4711,01+100/33, and this expression is calculated and sum up.
If you only have
to make just one calculation in connection with the inquiry,the expression may
be put in instead of searchkey, eg. instead of customerno. If the customer
can't be found DMS.IQ checks if there is used only one of the operators +‑*/.
If this is the
case the result of the calculation is shown on the bottom line without
disturbing the rest of the screenpicture.
The CAL function
may be changed UPP/DOWN on the screen, if you use the hole screen to inquiry,
CAL will start at the bottom as standard, meaning from line 15 to line 22.
Figure 15 CAL pocket calculator.
NO CALCULATION RESULT TOTAL
1:1000
1.000,00 1.000,00
2:2000
2.000,00 3.000,00
3:3000,45 3.000,45 6.000,45
4:1+2+3+4+4
14,00 6.014,45
5:123,45*2
246,90 6.261,35
6:
6.13. HOW ‑
search‑definition view
When you use the
HOW‑command you get the following screenpicture:
Figure 16 HOW search definitions.
Search‑definition:
N5=5 numbers, N3‑5=3 to 5
numbers, A5=5 characters, X=characters/numbers
N3,N1‑7=eg. 100,1234567
several split input, N2)N6=eg.31)248340
1:STOCKNUMBER (Input:X1‑4)
2:MATCHCODE (Input:X1‑11,X1‑4)
The first 3
lines are explanatory text, after that a view over the different index
(searchkeys) for the file is shown.
On the extreme
right is shown, how input may look to get DMS.IQ to try and find a key in the
mentioned index. On the top shown case may be put in from 1‑4 characters,
to try index 1, STOCKNUMBER. If you put in 5 or more
characters, you will try index 2, MATCHCODE.
6.14.1. Searching in
DMS.IQ
When you put in
a number/searchkey in DMS.IQ the mentioned record will be found in the file
through this index.
In contrast to
other programs DMS.IQ don't give up that easy if it doesn't find the number
first time. If the key is not found in index 1 it will try index 2, then index
3 etc.
Hereby you may
by inquiry on a customerfile with 2 index, customerno. and matchcode, key in
one of these without concerning, if the fields are found in 2 different index.
If you key in HANSEN this text will not be found as customerno. but propably in
the searchkey.
If you get the
message THIS RECORD IS NOT FOUND, you may try SUPERINDEX which is a search
through the hole file without having to find a index‑key for the text
(see SUPER command).
6.14.3. How DMS.IQ
search
DMS.IQ is very
energetic if a key can't be found first time, each index may be searched
several times in different ways.
By installation
of the file the programmer has defined, which index is found here. DMS.IQ will,
first time an inquiry is chosen, check if he has got all index with and eg.
define the rest.
From these index‑definitions
IQ may decide, how a input matches a index, while field‑length and types
are known. DMS.IQ will try in the mentioned queue:
1. All
index in order 1‑...., where input matches completely, eg. all fields are
keyed in.
2. All
index, where input matches partly, eg. fieldtypes/length matches defintions to
a limit.
The searchkey is
built up under these searchings refering to the definition, meaning the fields
collocations/packed as mentioned in the file.
If the key isn't
found during these 2 searchings, another 2 is made:
1. All
index is searched through, the keyed in is used as key directly without using
the definitions.
2. All
index is searched through the same way again, while the key is packed.
Now DMS.IQ give
up and says RECORD NOT FOUND. When you have a file with 4 index IQ may try 16
times before giving up.
6.15. TEST ‑
Testprint of searching/keybuilding
If you have
problems with index‑definitions for a file you may with advantage give
the TEST command to DMS.IQ.
After that you
put in a number/searchkey, which you expect to find in the file. DMS.IQ will
now show in details how this input will be understand and which searchkeys,
will be tryed in which index.
TEST only works
for one searching, if you wish testprint again you may give the TEST command
one time more. See the HOW command for explanation on DMS.IQ's search‑metodic.
Testprint by
searching in the stockfile:
Figure 17 TEST tesprint during the search.
SEARCH PASS 1
TEST NO. 1 > ARTICELNUMBER
X1‑4 INPUTCHECK: 0
CHANNEL: # 1( 0:VA) IX:1 SEARCH ON 1 ( 0:VA)
1X4 KEYBUILD: 0 "4711"
SEARCH: 0 "4711"
TEST NO. 2 > MATCHCODE
X1‑11,X1‑4 INPUTCHECK: ‑1
CHANNEL: # 1( 0:VA) IX: 2 SEARCH ON 1 ( 0:VA)
1X11,2X4 KEYBUILD: 0 "4711"
SEARCH: 0 "4711"
6.17. DEMO ‑
Demonstration‑mode.
By help of DEMO
command you run a demonstration of DMS.IQ.
If you key in
DEMO:STAR, DMS.IQ will now be controlled from a textfile and all input made
from here.
You may always
interrupt such a DEMO by pressing ESC, and then again use DMS.IQ normally.
If you then
press DEMO again the demonstration will be resumed again.
On STAR and
COMET systems are delivered DEMO:STAR and DEMO:COMET containing definitions of
different programs. By run of one of these the programs 1‑15 are made
(bevare of eg. overwriting existing) and may be used right after the installation.
6.18.1. DEMODEF ‑
create a demonstration‑textfile
This command is
normally only for SUPER‑users.
By help of
DEMODEF:A you may 'take up' all input in a textfile. With DEMODEF:A! you
overwrite eg. remaining textfiles.
After that you
use DMS.IQ normally, the taking up is only left by leaving DMS.IQ completely.
In connection
with this DEMO‑taking you may use:
DEMO:A Placing
a DEMO command in the textfile, the demonstration will continue with this.
Specially
the demonstration will restart if it is the same filename used.
DEMO:@ Restarts
with the same demonstration.
DEMO:10 Every
letter in input is showed with 1 sec. delay.
DEMO:‑1 Input
is showed once, not letter by letter.
REM
text This
text is showed on the message line and stay here for 5 sec.
REM Break
in 5 sec., messageline unchanged.
6.18.3. DEMOOUT ‑
Formation of program‑demonstration
This command is
normally used for the SUPER‑user.
With DEMOOUT:A
is made a demonstrationfile, containing all programs with fields, 2 times cr
and then SAVE:xx,NAME! At last is put in DEMO:@ so the demonstration is
repeated until escape is put in.
If you run this
demonstration all programs will be defined again. But be aware that eg.
arrangements in DMS.RAPGEN‑IQ NOT is contained here!!!
Eg. DEMO:STAR
made with DEMOOUT:STAR!
Figure 18 DEMOOUT demonstration file.
VA#1,4,6‑8,25‑28,LE#3,7/OL#1‑2,13‑15,21
SAVE:03,STOCK‑ORDERS!
VA#1,4,6‑8,25‑28,LE#3,7/BL#1‑2,4,8,14,17,19
SAVE:04,STOCK‑RESERVATIONS!
DEMO:@
6.18.5. DEMO ‑
textfilenames
A
demonstrationfile is taken up with DEMODEF:A or DEMOOUT:A get the name 03/DMS‑IQ‑D‑A.
Here 03/ is the
logic unit for DMS.IQ itself, DMS‑IQ marks with ‑ that the file is
not a standard IQ file, D‑ gives danish demo (DE=english, DY=german) and
A the demo‑name. This name may be max. 5 characters.
DEMO:A reads
this file, or 03/DMS.IQ‑D‑A, where . in DMS.IQ mention that the
file is fast and is copied with by installation of IQ.
While these
textfiles are very small, programdefinitions may be copied from system to
system by copying these.
The textfiles
may be maintained with other text‑editors as eg. PAID or others if
wished.
6.19. PRINTDOC ‑
printout of manual
With the
PRINTDOC command you may have printed out this manual on the printer.
The print out
will normally be on $LPT standard‑printer, with
PRINTDOC:$RPL0
you may choose another printer.
The pagehigh of
the printout is made automatically according to TAMOS printerration. There
isn't used any special printer facilities, the printout may be made on all
types of printers.
The printout is
made in the lanquage (danish/english/german), you work in.
With
PRINTDOC:$LPT,10,16 you may get a print out of the pages 10‑16 alone.
Considering the pagenumbers etc., the hole manual is read through during the
printout procedure.
By run of
PRINTDOC is build a content. This content is used when refering to eg.
HLP:1,9,2 to get a certain section of the manual. After changing in the manual
this should be written out.
6.20.1.
3.10.1.
Manualstructure and filenames
The manual is
found in several numbers of textfiles with the names 03/DMS.IQ‑H‑x.x.x
on the same disc as DMS.IQ itself. x.x.x refering to the intern commandnumber
in IQ. For other lanquage the names are eg.
03/DMS.IQ‑HEx.x.x.
If you don't
won't the manual online, eg. of space limit concerning, these textfiles may be
removed. Then the HLP‑function will be deactivated.
DMS.IQ don't use
the special 8870 helpsystem (call 92) and the help may be used on UNIX‑machines.
Also the showing of helpscreenpictures is faster and don't demands special
threatment in SYSMOD.
7.
4. Users
and permissions
Depending on
what is required, DMS.IQ can be installed without any kind of control over the
user and user permissions. Provided that
there is a general password within TAMOS, DMS.IQ can be called without input of
any other passwords.
It is however
possible with DMS.IQ to set up advanced user control by using passwords,
thereby determining which user has access to which files, programs and
commands, and which class of user is responsible for definitions and/or
amendments.
Four different
user types are defined after a new installation:
DMS SUPERUSER
with user number 1
FILE Permission
to define programs and files
Y Permission
to define programs
N Normal
user with access to defined programs
If user control is to be implemented, this
is done immediately after initial
installation under password DMS. It is
here that appropriate passwords and permissions can be set up and amended.
8.1. User‑classes.
DMS.IQ works
with three different types of user class:
1. SUPER-SUPERUSER
There is only
SUPER-SUPERUSER on the system and this is always user no. 1.
Only this user
can maintain the passwords of the other user, and amend the operator manual by
using the MAN command.
2. SUPERUSER.
The SUPERUSER
can authorize program and file access permissions, as well as command
permissions for users
in the same user
group.
The SUPERUSER is
defined by the SUPER-SUPERUSER by inputting CLASS=SUPER.
3. Normal user.
This user can
only access those programs, files and commands for which they have been given
permission
by a higher
user.
The SUPERUSER
controls the permissions of the other users by logging on under their password
(e.g. DMS). By using the command BYE, he can easily switch to the password of a
normal user (e.g. NORMAL). He can then run exactly as the normal user but will
still have access to his SUPERUSER commands.
For example, by
using the command PROGRAMS, he can set up program permissions for the
particular user.
The SUPER‑users
can by use of the commands:
KEY,
EDIT,SET, START, PROGRAMS and FILES
define permission for:
0 = this
user only
1 = all
users in the same group
2 = this
file only
3 = this
program only
The range of permissions can be defined in detail in this
way.
8.3. User
groups.
On the other
hand, normal users can be divided into three groups, each with different rages
of permissions. The user groups are
determined by the SUPER-SUPERUSER with the USER definitions, e.g.
GROUP=PROGRAM.
1. GROUP=
Users in this
group can only use the programs and files that have been defined for them,
i.e. existing
programs and/or files.
2. GROUP=PROGRAM
A user in
this group has access to all functions which are connected with the definition
and maintenance of programs,
these being
SAVE, KILL, RAP, DOC, RAPGEN, Q and START.
3. GROUP=FILE
In this
group, a user has access to all functions concerning the definition and
maintenance of programs and files,
SAVE, KILL,
RAP, DOC, RAPGEN, Q, and START, as DRN, DATA, and TEST.
By use of the
commands SET and EDIT, the SUPERUSER can define and amend the commands which
the separate user groups are permitted to use.
In addition, the
SUPER-SUPERUSER can define new groups, for example by inputting GROUP=MIN. The new group will be set up as soon as an
appropriate user logs in for the first time in DMS.IQ. In every case, a user group is defined by the
initial letter,i.e. GROUP=PROGRAM, GROUP=PROG and GROUP=P are the same.
8.5. BYE - end
and changing of passwords.
The command BYE
terminates the DMS.IQ inquiry procedure, and returns the user to the IQ
password input without leaving IQ.
The SUPERUSER
can also use this function, whilst under the password of another user, to amend
the command permissions for that user/user group (see above).
For instance, by
using BYE:DMS the user can be changed to DMS directly. This feature can be used
to advantage amongst other things in demonstrations (DEMO).
8.7. PROGRAMS -
program permissions.
This command,
available only to the SUPERUSER, first asks the question of whether the
function is applicable to one user only, or to a user group.
The programs
which are to be allowed are then input. DMS.IQ proposes programs numbers 1-99
as standard, e.g.
Figure 19 PROGRAMS - Program permission.
5 Sales orders
6 Purchase orders
7 Debtors
1 Customer orders
10 Chart of accounts
Only the
programs which are permitted for the current user are shown in the program
menu, in the sequence in which they were
input.
If a text, for
example SALDO, is input instead of a program number, the program name will be
searched for in the sequence.
If the SUPERUSER
uses the formula PROGRAMS:5-7,1,10, these programs will be valid for the
particular user.
8.9. FILES -
file permissions.
This command is
reserved for the SUPERUSER.
The first
question after the input of the command is whether the function is for a single
user, og for a user group.
Which files are
permitted is then input. DMS.IQ proposes as standard the files AA-ZZ.
Figure 20 FILES - File permissions.
FI Financial master file
FP Financial posting file
KP Debtor postings file
KU Debtor master file
OH Order header file
OL Order item file
Only the files
permitted for the current user will be displayed in the file menu, in the
sequence in which they were input.
However the user
can call up a permitted program which is using a file which is not permitted.
If the formula FILES:FI,FP,KA-KZ is used,
this input will be valid for the particular user.
8.11. USERS -
Maintenance of the user definitions.
With this
command, which is restricted to the SUPER-SUPERUSER, the user definitions can
be set up and amended.
The USERS
command accesses a text editor similar to Function 11 in DMS.RAPGEN. Each line
in the text file corresponds to a user.
A user is
defined with PASSWORD, NAME, OPTIONS
The password
must be input at the start of DMS.IQ. The name of the user will then be
displayed on the screen.
Under OPTIONS can be input which SYSTEM is to be used,
and/or which TAMOS company is to be worked with, if this is not determinded by
the TAMOS selectors.
If there is only
one user on the system, no password needs to be input.
The user name
can form part of the TAMOS program selector. In this case, likewise, no
password needs to be input at the start of DMS.IQ.
On a newly installed system, the USER text file looks
like this:
Figure 21 USERS on a new installed system.
DMS,****DMS.IQ****,CLASS=SUPER,GROUP=FILE
FILE,file
definitions,GROUP=FILE,SYSTEM=00
Y,Program
definitions,GROUP=PROG,SYSTEM=00
N,Normal IQ user,SYSTEM=00
8.12.1. USER
options.
The following is
an example of a valid user definition:
MIKKEL,PETER
MIKKELSEN,SYSTEM=23,TAMOS=001
System 23 and
TAMOS company number 001 have been chosen for this user.
SYSTEM=23 Set
the system to 23 (CHSYSTEM) - ses DMS.RAP.SYS.
All users would normally use the same system.
If no system is specified, the system that was last
called from the TAMOS selectors will be used.
PROGRAMS=2/XX The
prefix for DMS.IQ programs is now 2/XX (instead of 0/IQ).
This corresponds to the list file prefix in DMS.RAPGEN.
Each user can have his own programs.
The necessary program file x/XXREPORT will be created
automatically.
TAMOS=001 The
TAMOS company number is set to 001.
LU=3 The
first program LU in the TAMOS selectors is set to 03 (ST.PARAMxxx lu).
START=47 The
program with this number will be called when DMS.IQ is started.
The start program number can also be set up in the TAMOS
program selector.
GROUP=PROG User
group for this user.
CLASS=SUPER User
class for this user.
LUS=0 (Only
for DMS program - all LUs are set to 0).
ME=03/DMS.IQ Start
this program after the password has been input.
All options can
be shortened to the smallest meaningful abbreviation.
For example,
CLASS=SUPER and GROUP=PROGRAM can be input as C=S,G=P.
9. Keys and
commands
This chapter
descripes, how you define your commands and key‑functions.
The commands
KEY, START, SET and EDIT will be mentioned in this chapter.
With KEY you may
define which functions the different keys may have.
With START you
may put a extern program eg. a normal report or a datamasterprogram, to a
command in IQ.
With SET you may
change the commands, you already have permission to use.
With EDIT
command you may change all commands totally, and this demands more knowlidge to
the system structure, while the description of this command is more technic.
At last you may
by help of USERNAME for a program in DMS.RAPGEN.IQ put a command to a certain
program.
The rools for
all commands in this chapter is that the SUPER‑user have opportunity to
choose if the change may work for only one user, the hole usergroup or one
file/program. Functionkeys/commands may in that way be used to change, compared
to which function you run.
10.1. KEY ‑
definition of function keys
With the KEY
command you get a view over the 17 function keys (see bottom) and may place a
certain commands on one of these.
You press the
wanted function‑key and write after that the command. This is repeated
untill you is satisfied, then you end by pressing cr.
You may place a
program on a functionkey by pressing the programno. instead of a command. In
the same way a file may be put in by giving the file shortness.
Instead of
pressing the function key you may put in the number of wanted keys.
Any kind of text
may be equal a function key, it don't have to be a command.
The SUPER‑user
get the possibility to define keys for one user, one hole usergroup, only one
file or only one program.
Figure 22 KEY function keys.
Functionkeys:
2 7 12 17
6 11 16
1 5 10 15
4 9 14
cr 3 8 13
1 @ Hold last input
2 HLP Usermanual
3 CAL Calculator
4 SPR Tamos menu
5 Back
6 ? Command‑view
7 RAP DMS.RAPGEN ‑ IQ
8 CRE
9 FILE File‑view
10 FLD Field‑view
11 ALL = Screenpicture from ‑
to
12 SAVE SAVE program
13 END End this function
14 DOWN = Screenpicture from ‑
to
15 LAST Postings first/last
16 FIRST Postings first/last
17 UPP = Screenpicture from ‑
to
Press one functionkey
New function:SUPER
MESSAGE:Press number 8 Function:CRE
10.3. Start ‑
Define commands for start of report
START command is
for SUPER‑users, and you may choose, if the command may work for one user
alone, or all users in the same group. If you give the parameters directly,
eg:START:5,LIST, the command may work for only this user, if you only press
START you will be asked.
With START‑command
you may define a new command, which causes call of DMS.RAPGEN for start of a
certain report.
START:5,LIST put a
new command LIST.
When you press LIST you go to DMS.RAPGEN function 9,
start of reportno. 5.
When DMS.RAPGEN is left you return to IQ.
10.4.1. START
DATAMASTER programs
START command
may be used to connect DATAMASTER programs to commands in DMS.IQ.
START:1,PROG,D
connect DATAMASTER programno. 1 to the command PROG.
,D gets DMS.IQ
to see the program as a DATAMASTER program.
START:KU,PROG,D
connect DATAMASTER program for file KU with automatic screenpicture to function
PROG.
If file KU isn't
a DATAMASTER file, you will when the concerned command is issued, get the
message: THIS PROGRAM CAN'T BE CHOSEN.
10.4.3. START ‑
other programs.
START:0/ST00,STAR defined the command STAR. When this is called DMS.IQ
will call the program 0/ST00. If this ends with DMSE you will return to IQ, or
TAMOS.
10.5. SET ‑ Definition of a new command
SET command is
only for SUPER‑users, and you may choose, if the command may work for one
user alone or all users in the same group. If you set the parameters directly,
eg:SET:FINISH=END, the command will work for this user alone, if SET you will
be asked.
With the SET
command you may define/change or cancel an existing command. These definitions
only work for the USER you use, but anyhow use the SET function with
carefullnes.
SET:FINISH=END Puts
a new command FINISH which will work exactly as END.
If
the command FINISH already exist the old function will be cancelled.
SET:FINISH=3 Puts
also a new command but with functionnumber 3. Functionnumber 3 is END in
DMS.IQ.
You
may put in commands with numbers, which you don't already have.
SET:FINISH=‑ Remove
the command FINISH.
SET:ORDERS Make
a command with the name ORDERS.
When
this command is given you choose the program running.
If you is a
SUPER‑user, you may choose, if the command may work for one user alone or
for all users in the same group.
If you choose
parameters directly, eg: SET:FINISH=END the command will work for this user
alone, if you press just SET you will be asked.
10.6.1. Help for
userdefined commands
When you key in
eg. HLP:ORDERS you will see the following screenpicture:
With SET:ORDERS
you may define a new command ‑ ORDERS, see also SET.
If you then use
the command ORDERS you choose the program/files, which you were in, when SET
command was given.
10.7. Commands
as program‑numbers
In certain cases
you may wish to put in commands in DMS.IQ's programmenu.
Eg. you may
define the command PROG, by START:3,PROG,D, which activate DATAMASTER maintain‑program
3.
While the menu
exist of programs defined with RAP‑command in IQ, you may define such a
program, eg. by help of function 6.
As USERNAME you
choose =PROG and may press END for the rest of the screenpicture definition.
DMS.IQ will see
a username starting with = as a "camouflaged" command, which is put
in automatically as soon as this program is chosen. The program is now picked
up (screenpicture is shown etc.), PROG command is activated and DATAMASTER
program is called.
All kind of
commands may be connected to programs in this way, but only max. 15 characters
is available for one command.
10.8.1. Several
commands combined
Normally you
finish a input with cr, eg:
END
10
42004
to end the running program, pick program 10 and the
customer 42004.
This could be
written as only 2 lines, while the parameter is given together with the
command:
END:10
42004
To connect such
a command to a programnumber, you must write this in one line, and IQ accept
instead of cr.
You may write:
END:10_42004 or END_10_42004
10.9. EDIT ‑
Free edit of commands
This command is
for SUPER‑users, you may with this put in all kinds of new commands. If
you call EDIT alone, you will be asked if you wish to edit the commands for the
user, the hole usergroup, one file or one program.
With EDIT you
may maintain the textfile which contains the users commandstringth, see command
structure under USERS.
When you use the
EDIT command you will get into a textthreatmentprogram, which is used in
exactly the same way as eg. function 11, maintenance of dokumentation, in
DMS.RAPGEN. The different functions are descriped in rapgen usermanual chapter
16.
Shortly
mentioned:
10 you
go to line 10
END end
edit
INS/DEL put
in/cancel
GET copy
lines from another textfile
PRT write
out text on the printer
Figure 23 EDIT command editor
....,....!....,....!....,....!....,....!....,....!....,....!....,....!...
1 REM DMS‑IQ‑ALLF ‑
FILE‑DEFINITION USERS
2
3 @=1
4
=2
5 END=3
6 SPR=4
7 KEY=5,1
8 HOW=5,2
9 ?=5,3
10 HLP=5,4
11 CAL=7
12 UPP=8(1,11,,,23,0,24)
....,....!....,....!....,....!....,....!....,....!....,....!....,....!...
The command file
exist of a row of lines eg. END=3, meaning each command is given a certain
functioncode which is known by DMS.IQ. IQ know no commands, only numbers.
By edit you may
change as you wish and choose others/longers/shortere names as wished, eg.
"danish" these if wanted.
10.10.1. Command
numbers
Numbers of the
different commands may easyest be found from already existing commands. A menu
follows:
Figure 24 Command numbers.
1
=@ Hold last input
2
= Back
3
=END, End this function
4
=SPR, Tamos menu
5,3
=?, Command‑view
5,4
=HLP, Usermanual
5,2
=HOW, Search‑definition
view
5,1
=KEY, Definition of
functionkeys this user *1
6
=TEST, Testprint during
search
7
=CAL, Calculator
8
=UPP Screenpicture from‑to (ALL/DOWN)
9
= Userdefined
function (START)
10 =FIRST, Posting first/last (LAST/THIS)
11 =EDIT, Edit commands this user *1
11,5 =DOC, Maintain programdocumentation
11,6 =USERS, Maintain users, only SUPER‑SUPER
user
14 = Extern program (START)
14,1 =RAP, DMS.RAPGEN ‑ IQ
14,2 =BYE, New password
14,3 =DRN, File definition
14,4 =RAPGEN, DMS.RAPGEN ‑ reports
14,5 =DATA, DATAMASTER
14,6 =Q, DMS.JOBQUEUE
14,9 = Start of report
15 =SET, Define a command
16 =SUPER, SUPERINDEX
17 =#, Define SELECTION
18 =FILE, File‑view
19 =FLD, Field‑view
20 =DEMO, Demonstration,20,1=DEMODEF,20,2=DEMOOUT
21 =SAVE, SAVE program,21,1=KILL program
22 =PROGRAMS, Permitted programs *1
23 =FILES, Permitted files *1
24 =PRINTDOC, Write out usermanual
25 =START, Define commands for report start *1
10.10.3. Commands
with user‑statement
Those with *1
marked commands may be enlarged to use for SUPER‑users with the question
if the command may work for one user/group, one file/program: eg. EDIT=11 work
for this user, EDIT=11,1 ask if user/group and EDIT=11,2 ask if
user/group/file/program.
10.10.5. Commands
with screen statement
All commands in
DMS.IQ are defined with a commandno. eg. END=3.
Second all
commands may be defined with a screen statement, eg:
END=3(1,22,1,22,23,0,24)
a b c d e f g───── Message line
│ │ │ │ │ └─────── Heading
│ │ │ │ └────────── Input‑line
│ │ │ └───────────── Program (report) line from
│ │ └─────────────── Program (report) line to
│ └────────────────── Screenline to
└──────────────────── Screenline from
UPP is eg.
defined as UPP=8(1,11) because the other lines can't be changed.
With the EDIT
command you make commands, which move around in other ways, eg.
MID=8(6,14,,,15,5,16) which shows the picture in the middle of the screen.
The parameters
c. and d. are not free in this release of DMS.IQ and may always be left out.
10.10.7. EDIT other
text files
SUPER‑SUPER
user may use the EDIT command to edit any kind of textfile. If you call edit as
eg:
EDIT:0/A
meaning lu/filename is given as parameter, the editor
will be called on this file. The file will be made if it is not already
available.
10.11. DMS.IQ's
intern command structur
The commands for
an IQ program are hidded in a long stringth, which eg. may contain:
@=1 =2 END=3 SPR=4 HLP=5 KEYS=@/ /END/SPR/HLP...
When the user
keys END, IQ will search in this commandstringth after the text END, if this is
found function 3 will be made (END=3).
All functions in
DMS.IQ is given numbers, the programs react in connection to these numbers and
don't know the real commandtext.
You may in the commandstring find both END=3
and FINISH=3. Hereby DMS.IQ will react exactly the same if you put END or
FINISH (all commands may be put in with both great and small capital letters).
The commandstringth is built up/changed during running of
IQ and contain:
‑
Program Normally
no commands from here
‑
File Defines
how to search in the file
‑
Userclass Superuser
commands
‑
User Specific
for this user
‑
Usergroup Defines
the groups permissions
‑
TAMOS functionkeys Keys
if no other are defined
When a user
starts DMS.IQ the last 4 of these are read. When a file is chosen the file
search definitions are read, when a program is chosen both the file and program
definitions. If you choose another program/file these definitions are replaced.
DMS.IQ will
always search in the total commandstringth from the start, the same command may
in this way be defined several times, it will be the one who come first, which
will be used.
For the
usergroup eg. END=3 may be defined for normal END. For the user may be defined
END=4, meaning the same as SPR, back to TAMOS menu. For this user alone END
will go to TAMOS.
Program 10 may
be defined END=5. If the user run program 10 END will function as HLP, if other
programs are run END will function as mentioned on top.
Specially you
may with the KEY command define functionkeys, which fit the users need, these
may then be changed per program if function is used here.
11. Extern
programs as commands
You may
integrate DMS.IQ with other program systems, in this chapter RAPGEN, Q and DATA
commands are descriped in connection with START command.
12.1. RAPGEN ‑
DMS.RAPGEN reportgenerator
With the command
RAPGEN in DMS.IQ you may choose the reportgenerator as normal reportgenerator
unline RAP command, where IQ functions are activate.
If you leave
DMS.RAPGEN you return to DMS.IQ again.
12.3. Start of
reports
With the START
command (see this) you may define new commands, which causes start of a certain
report.
The command
START:5,LIST will define a new command, LIST, which is combined to reportno. 5.
Then a user only
call LIST (or press a functionkey), and DMS.RAPGEN is called to start the
report.
When this is
done the user return to DMS.IQ and have no chance to define/change reports in
DMS.RAPGEN.
12.5. Q ‑
DMS.JOBQUEUE
If you have
bought DMS.JOBQUEUE this may be chosen directly from DMS.IQ by pressing Q.
DMS.JOBQUEUE may
be used to run a number of programs without any operator,eg. nightruns.
Here are all
kinds of functions for priority of jobs, deleting and switching of the order.
Besides you may built FAST jobqueues, so you eg. only one time a month will run
this queue without speculating on which programs and in which order these may
be run to get the monthend done.
12.7. DATA ‑
DATAMASTER file maintenance
With DATA you
choose DATAMASTER, which demands that this is bought and installed on the
system.
With DATAMASTER
you may define new files and state, which fields/index to put in. Hereby is
automaticly built a new file and you get a setup/changing‑programs which
you may maintain records in.
Such files may
without any trouble be enlarged with extra fields/index and are normal files,
which may be used in your own programs.
DATAMASTER files
are automatically installed in DMS.RAPGEN and may be built/updated in the
reportgenerator, eg. on basis of other files in the system.
DATAMASTER files
are installed in DMS.IQ and all kinds of search may be used.
12.9. Start of
DATAMASTER programs
With the START
command (see this) you may define new commands, which make start of a
DATAMASTER file program.
The command
START:5,PROG,D will define a new command, PROG, which is combined to
DATAMASTER's programno. 5. START:KU,PROG,D combine a DATAMASTER program with
automatic screenpicture for the file KU to function PROG.
Then a user just
call PROG (or press a functionkey), and DATAMASTER activates the program.
When you in this
program put in END you return to DMS.IQ and have no possibility to
define/change files in DATAMASTER.
12.11. Start of
other programs
The command
START:0/ST00,STAR defines a new command, STAR, which is connected to program
ST00.
Then a user just
call STAR (or press a functionkey), this program is now activated.
The user will
return to DMS.IQ if the program ends with CHAIN "DMSE".
13. Generated
programs
With the RAP‑command
you activate DMS.RAPGEN in the special IQ‑version, which you may see in
RAPGEN's menu, while point 3 and 13 for sorting/totalling are missing, together
with point 15 ‑ standard program parameters is put on.
Figure 25 DMS.RAPGEN's IQ menu.
DMS.IQ
1... Define new report
2... Define selections
3...
4... Define calculations
5... Delete report
6... Define new letter
7... Amendment to a
report/letter
8... Print of definitions
9... Start and generate report
10... Copy report
11... Documentation
12... Edit selections
13...
14... Edit calculations
15... Standard program
parameters
Enter code:.........
A program in
DMS.IQ may function in 2 principle different ways:
1. Parameter‑driven,
not generated.
When you
define a program with eg. KU#1‑10/KP#1‑10 and SAVE this,
the program
will be stored exactly as a report in DMS.RAPGEN.
DMS.IQ will
drive this program from these definitions, without having generated a
independent BASIC‑program.
2. Generated,
means started by function 9 in DMS.RAPGEN.
If you choose
RAP and function 9, a BASIC program will be made, exactly as in RAPGEN.
This program
is hidden on the disc and will exist untill you change the definitions.
If such a
program exist DMS.IQ will use this instead of the normal IQ‑program.
14.1.
Calculation and generating
Immediatly you
cant see any difference, if it is one or another kind of program, being used by
IQ. Regarding speed, the two programs will be the same.
The difference
is, that you can't put any calculations or selections in the parameter‑driven
programs.
But you may use
all facilities in RAPGEN, which are relevant for the INQUIRY‑program, if
you generate in a IQ‑program. Calculations are defined in normal way with
function 4 or 14, eg. a free field is equal total of other fields with
#50=#10+#15. To make these calculations active, choose function 9 ‑ start
and generate report, and the program is generated and started in IQ.
If you choose
function 9 the program is generated directly without any kind of starting‑screenpicture
with dates, start from etc. All these informations are not relevant for a
online inquiry‑program.
Eg. an inquiry
shown from the customer, on the total of this order. Calculations are shown
with LET‑command.
Figure 26 Calculations in an inquery program.
01
CUSTOMERNO. 5001
03
NAME 1
07
PHONE
26
KREDIT LIMIT (1000)
999 TOTAL ORDER 146.296,39
27
ACC. BALANCE
174304,57 TOTAL DISCOUNT ‑40.419,00
28
PAYD THIS MONTH 0,00
29
LAST PAYMENT DATE
0 TOTAL COSTPRICE 88.478,00
‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
LET(#44‑46=0) /* ZERO TOTAL‑ORDER,DISCOUNT,COST
START (OH)
NEXT (OH)
LET (#44‑46+=OH#38,45,46) /* ADD TOTAL‑ORDER,DISCOUNT,COST
OM (OH)
14.2.1. Reading of
other files
In calculations
you may read other files with eg. READ (LE) or START (KP) ‑ NEXT (KP) -
REPEAT (KP).
If you define a
program in IQ like: VA#1‑10,
LE#1‑10
IQ will make the connection between VA‑stockfile
and LE‑supplier, if you by installation have defined a automatic
connection between these files.
Even if you
don't generate the program, IQ will use this connection between the files. Any
kind of AUTOMATIC connection is immidiatly activ in a IQ‑program.
If saving this
program with eg. SAVE:STOCKINQUIRY and hereafter starting RAP, and moving into
the calculations with eg. 14, (14 can be used to choose function 14 on the last
used program/report), IQ have already put in an calculationline, READ (LE).
Using SAVE you
transfer as many informations as possible to RAP using calculationlines, then you
have something to look after, when you define more calculations.
After SAVE you
may go to RAP and then directly to function 9 ‑ START, to see that this
reading of LE, NOT is being generated. IQ itself don't generate the BASIC‑code
for READ (LE), only something that match the input of this line. To activate
IQ's calculations you have to go to function 4, 14 or 15, meaning DMS.RAPGEN's
calculating module.
On the other
hand there is no reason to generate an IQ‑program unless you put in
calculations.
14.3. Function
15 ‑ standard program parameters
When you in IQ,
SAVE a program, especially a inquiry program for postings, eg. KU#1‑10/KP#1‑10,
this gives quite a lot of complicated calculations in rapgen. You may control
START/NEXT in connection with forwards/backwards in the files, total of the accounts and selections,
and the balance will still be correct.
These
calculations takes several hundred lines, why IQ won't put these in as normal
lines in function 4, but instead use a STANDARD PROGRAM. In this IQ you only
have to put CHANGES to this standard programs as calculationlines.
If a program
like KU#1‑10/KP#7‑8,4,3,13 gives the following screenpicture:
Figure 27 KU#1‑10/KP#7‑8,4,3,13 screen layout.
01
CUSTOMERNO.
07 PHONENO.
02
CUSTOMERTYPE
08 DELIVERY CODE
03
NAME 1 09
PAYMENT CODE
04
NAME 2
10 BALANCE ORDER CODE
05
ADRESS 1
06
ADRESS 2
07 Transno. 08 Date 04TC 03
13 Amount
TRANS FILES
CODE SALARY TEXT BALANCE
AMOUNT TOTAL
and after SAVING the program choose function 15 in RAP,
you will get the following screenpicture:
Figure 28 Function 15 in RAPGEN.
1 ‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
POSTING INQUIRY ‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
2 Fieldnumbers used: KU#1‑10/KP#7‑8,4,3,13
3 Posting‑files : KP
4
5 ‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
Selection‑fields ‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
6 Posting‑date :
KP#8
7 Posting‑fileno. : KP#7
8 Posting‑code :
KP#4
9 Posting‑text :
HP#3
10
11 ‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
Amount‑fields ‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
12 Posting‑amount :
KP#13
13 Transferr balance:
14 Running balance : #44
15
16 ‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
Other parameters ‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
17 Show lineno. (0=N, 1=RIGHT, 2=LEFT) :1
18 Start (0=FORWARDS, 1=FROM BEHIND, 2=FIRST
CR) :0
IQ have chosen
the fields for selection and amount‑SUM from the field definitions, and
put in as parameters. Now you may change fieldnumbers as you wish. But changes
in the first line, fieldnumbers used, may be of no meaning, while this is pure
information about how the program was made.
When you leave
function 15 DMS.RAPGEN will go through function 4 ‑ calculations, as if
you have changed the calculations with function 14. The following parameters
will result in a number of calculationlines, which you will see if you use
function 14:
Figure 29 Calculations from the standard program.
1 XON.‑‑‑‑‑
* CALCULATIONS FROM STANDARD‑PROGRAM * ‑‑‑‑‑‑‑‑‑‑‑‑‑
3 3080 LET #44=0
4 3112 LET T2$=KP#3
5 3150 IF KO=1 IF FNQ(KP#8)<
FNQ(KO(1)) RETURN
6 3155 IF KO=2 IF
KP#7<>KO(2) RETURN
7 3160 IF KO=3 IF
KP#13<>KO(3) RETURN
8 3165 IF KO=4 IF
KP#4<>KO(4) RETURN
9 3230 LET #44=#44+KP#13
10 3310 LET J3(J2)=#44
11 3410 LET #44=J3(J3)
12 3500 START (KP)
13 3600 NEXT (KP)
14 XOF.‑‑‑‑‑
* START OF NORMAL USER CALCULATIONS * ‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
15 NORMAL
The calculations
starts with the specialcommand XON and ends with XOF. These 2 new commands in
DMS.RAPGEN runs in the same way as NORMAL/AFTER/LAST and tells that inside
these lines are a number of calculations where the basic‑linenumbers are
named and special basic‑variables may occur.
You may
recognize the chosen fields in the mentioned calculations, but to write exactly
the nessesary lines with numbers, would be a very complicated thing even for a
programmer. Function 15 is used as help to place the few calculationlines,
which are nessesary to make a complicated inquiry in the program.
You are not
supposed to change in these lines manually, but instead add lines after these,
that means after the last NORMAL command. Theoretic you may change in the
XON/XOF block and it will function, but it is a lot easyer to change these
parameters by use of function 15. This function do not touch any lines, outside
the XON/XOF block.
14.5. Changes
without generating
You only have to
generate a program, if you put in calculations or selections.
You may be free
to change in the screenpicture with function 7 or in parameters in function 15,
without generating the program. IQ will use the new parameters instead of those
IQ suggested first.
Function 7 with
use of LINE command may change the lines which may be shown for posting
inquiryes as KU#1‑10/KP#1‑10 or list‑inquiryes as KU#1‑10L,
and then you may see more lines per transaction.
Writing a steady
text in function 7 on one of the postinglines, this line will (with
backgroundtext) come through for each posting line, not just only the first
line. In the following program you see an extra line per post, in this way the
program is not generated.
Figure 30 Amendments without generation.
01
CUSTOMERNO. 5001
07 PHONENO.
02
CUSTOMERTYPE 3
08 DELIVERY CODE 1
03
NAME 1
09 PAYMENT CODE 5
04
NAME 2
10 BALANCE ORDER CODE 1
05
ADRESS 1
06
ADRESS 2
07 TRANS 08 DATE 04 TC 03 13 AMOUNT
TRANS FILES
CODE POSTINGTEXT BALANCE AMOUNT TOTAL
9951 88.07.31 0 INVOICE 70038,37 70.038,37
CASH
DISCOUNT 100,00 PER 880810
9956 88.08.30 0 INVOICE 35059,75 105.098,12
CASH
DISCOUNT 0,00 PER 880909
9957 88.08.30 0 INVOICE 15013,69 120.111,81
CASH
DISCOUNT 15,00 PER 880909
─────────────────────────────────────────────────────────────────────────
ZERO PRINTOUT (J/N)? J
PAGESHIFT NO. OF LINES BEFORE
BOTTOM ? 3
HEADING PRINT LINES : 1‑8
NORMAL PRINT LINES : 9‑10
14.7. RAP ‑
DMS.RAPGEN ‑ IQ generator
With RAP command
you activate DMS.RAPGEN in the special IQ version. When you leave the rapgen
again, by using cr. in the menu or by generating a program with function 9, you
return to IQ and the program you have made.
The detailed
description of DMS.RAPGEN's many functions may be found in the rapgen manual.
DMS.RAPGEN.IQ version seperate itself from the normal rapgen by:
1. Function 3 and
13, sorting and totalling, don't exist.
2. By definition
of a new list with function 1, there are made no headlines with
dates/pagenumbers and totals.
3. Function 15,
standard program parameter is new, and is used in connection with posting
inquiryes.
Function 15
gives opportunity to the new XON/XOF calculations ‑ selections.
4. A new inquiry
may be defined with function 6 or function 1, meaning a normal inquiry or a
list.
On the other
hand a posting inquiry may be defined by SAVING a program in IQ, and hereafter
prepared with RAP.
5. Certain
calculations are not relevent in connection with inquiries,
eg. WHEN,
READH and EXPORT/IMPORT subfunctions.
In princip
these functions may be used in IQ, but have no relevance combined to an
inquiry.
6. Function 8 ‑
documentation ‑ is enlarged to have printlines and the named parameters
in function 15.
7. Screenpictures
are reduced to 80 characters per line, if you define more wide lines these will
be missing.
8. The LINE
command in function 7 may be used to show posting lines in more lines on the
screen.
PRINT (L=...)
in calculations may be used to show different lines, dependent on the posting
informations, eg:
PRINT (L=8)
/* Normal posting
IF
#38<>0 PRINT (L=8‑9)
/* Ekstra line with amount
But PRINT
calculations won't be relevant, while these are easy run by PRINT (L=...).
9. When you use
function 9 ‑ start ‑ don't put in any parameters, these are given
to you as you use the program.
14.8.1. New
facilities in function 7
To make the
definition of screenpictures for DMS.IQ more easy, the following new functions
are put in in connection with function 7 ‑ changing a report/letter. The
commands are given when you stand in LINE, POS: and may also be used in the
normal rapgen:
1. NAME
With this command you may change the programname.
2. USER
With this command you may change the USERNAME.
You
are not asked about username by definition of IQ‑programs,
while
this is used to special commands.
USER
command may be used in connection with IQ.
3. INS/DEL
may be used instead of IL/DL or LI/LD to put in/cancel
lines.
You
are asked how many lines you wish to put in/cancel for these commands.
4. GET/PUT
Get/put screenpicture (reportlayout) in a textfile.
GET With
GET you may get a text from a textfile into a arbitrary place in the
screenpicture.
This
text may be made by PUT by another program or by PRT‑copy of a screen‑picture
by
help of spool‑system. (Any kind of screen‑steercharacters from
NIROS 7.0 are removed).
PUT With
this command you may put the screenpicture in a textfile.
Of
security reasons this textfile will always have the firstname xx/DMS-
A
textfile like this may be GET into another program by giving the hole name.
14.9.
NORMAL/AFTER/FIRST/LAST calculations
These commands
are used in DMS.RAPGEN to control when certain calculations may be made. This
is the same in DMS.IQ, but the timeschedules are adjusted to the inquiry
programs.
There are some
difference in the programtypes, but the same for all are, that the mainfiles
are found with IQ's searching, and read before calculations are made.
14.10.1. Normal
inquiry
Defined as eg.
OH#1‑10,KU1‑10 or with function 6.
FIRST
calculations are made, then
NORMAL
calculations, then
SELECTION
AFTER
calculations
the post
is shown (with PRINT calculations)
LAST
calculations
If there is put
in a selection and the selection‑kriteria is not fullfilled, the next
post is searched with search procedure. If it is a SIMPEL searching, meaning
the next in the chosen index, it is the generated program which finds the next
post. If it is a COMPLEX searching, meaning SUPER‑index or #‑SELECTION,
the generated program is left and IQ's searchmodule is asked to find the next
post. This have a special meaning for the next programtype:
14.10.3. List‑inquiryes
Defined as eg.
KU#1‑10L or with function 1.
The calculations
are made as above mentioned.
When NEXT record
is found ALT is made again for this, meaning ALSO first calculations. You can't
as in the rapgen, count on that values of freefields are found when the next
record is calculated, if it is DMS.IQ's searchmodule who have found the record
this is not the case.
14.10.5. Posting‑inquiry
Defined as eg.
KU#1‑10/KP#1‑10 or KU#1‑10/KP#1‑10L.
The mainfiles is
read first, then:
FIRST
calculations are made.
The
head is shown regarding those lines, which are defined as headlines.
The
posts are read, and the following are done per transaction:
NORMAL
calculations
SELECTION
AFTER
calculations
The
posts are shown with PRINT‑calculations, meaning both backwards and
forwards in the posts.
LAST
calculations are done when you print cr. for last page.
Calculations on
mainfiles are made as FIRST calculations, calculations/selections on posts as
NORMAL calculations.
14.11. LKY‑Lampfunctions
In certain inquiries
you may wish to see different informations, dependent on what you may use the
inquiry for. You may have two different programs, but you may also use the 4
lamp‑functions (or latching‑keys in another word).
If you put in
calculationlines in a posting‑inquiry eg:
PRINT
(L=7)
IF
LKY(1) PRINT (L=8)
IF
LKY(2) PRINT (L=7‑8)
you will see different things, dependent on which lamps
(R1‑R4) you switch on. LKY(1), LKY(2), LKY(3) and LKY(4) matches lamps
R1,R2,R3 and R4. DMS.IQ don't use any of these functions.
Normally you
will see line 7, if lamp R1 is switched on you will see other informations
according to line 8, if you switch on lamp 2 you will see both line 7 and 8,
meaning 2 lines per post.
14.13.
Subfunctions
Using the same
subfunctions in IQ programs as in reportprograms, eg. NUMBER to number‑conversion,
see the details in the rapgen manual.
Not all are
relevant for the inquiryprograms, because some are specially pointing against
reports.
In IQ are some
extra subfunctions: MESS, INPUT and LINK. These are specially pointing at
screenprograms and descriped in the following.
14.14.1. MESS ‑
Message on the screen
With MESS
("HERE AM I") you may write out a line on the messageline, the
program runs on after showing the text.
14.14.3. INPUT ‑
Input of a functioncode
#50=INPUT("FUNCTION:") will show the text FUNCTION: on the
inputline (line 23) in position 40, after that you may put in a value. This
value can be read in field 50, which may be a freefield, and used to eg.
stearing of which postings/calculations there have to be shown.
Field 50 may be
a numeric field or a textfield.
#50=INPUT("FUNCTION:","0=NORMAL,1=SPECIAL") will
show the last text on the messageline before input, but otherwise function
normally.
14.14.5. LINK ‑
activate another program
LINK(10) will
switch of this program and call programno. 10. If program 10 now use the same
mainfile as this program, the already found record will be shown immidiatly.
14.14.6.1. Inquiryes
dependent on a type code
In certain cases
you may wish different inquiries dependent on a code in the file. It may be a
article‑typecode, showing complete other informations if this is 1 or if
it was 0.
If program 10 is
defined as inquiries on articles with type 0, and you put in a calculation:
IF#15<>0 LINK (11)
and program 11 are defined as inquiries on articles with
type 1, and you put in a calculation:
IF#15=0
LINK (10)
program 10/11 may change dependent on the type of the
found article.
14.14.6.3. Inquiries on
more sides
If program 31
and 32 are defined as inquiries on eg. customerfile with different
informations, may in these two programs be put:
program 31: LAST
#50=INPUT("SHOW
PAGE 2?")
IF
#50="Y" LINK (32)
program 32: LAST
#50=INPUT("SHOW
PAGE 1?")
IF
#50="Y" LINK (31)
such a link of inquiries may in princip continue with
endless many programs.
14.14.7. LINK ‑
carry out a command‑stringht
LINK subfunction
may be used to carry out a command‑stringht, but it shall not be a
programno. which is put on.
LINK (10) is
exactly the same as LINK ("END:10")
LINK
("DOWN",#1) will change the running program to bottom screenhalf and
then use field 1 as input to the searchkey, eg. customerno.
You may put up
to 9 different parameters to the LINK function, these may all be textfields. In
one LINK may be carried out several things, eg. LINK
("UPP:10",#1,"DOWN:11",#2) may link program 10 first, then
search for the number in field 1 and show this record up, hereafter choose
programno. 11 and the record find according to field 2 is shown bottom.
15.
Installation and file‑definition
DMS.IQ is
selfinstalling, if you already have DMS.RAPGEN installed, meaning all nessesary
working files, report files etc. are made automatic gradually as you may need
them.
By installation
all the files are copied with prefix DMS.IQ to the system, and then DMS.IQ.INS
is called from scope to put in a controlcode.
To use RAP to
programdefinitions in IQ you need the new version of DMS.RAPGEN (17.01 per
01/11‑90). It is possible to use all other functions in IQ without having
DMS.RAPGEN.
If you haven't
installed DMS.RAPGEN you do need the modules DMS.RAP.SYS, FIL and DRN together
with DMS.R and DMSE for system setup and filedefinitions.
16.1.
Operatingsystem and space requierements
DMS.IQ may be
used from NIROS 5.1/03 and forwards, also on UNIX systems.
You need at
least 32KB partitionsize (28KB version may be delivered).
Discspace for
programs, incl. online manual, app. 1000 blocks, in emergency cases you may put
out the manual (DMS.IQ‑files), and then save eg. 300 blocks.
On each screen
IQ uses a workfile of 77 blocks.
The program‑(report)
file is stated per user, normally only one is nessesary. This is made automatic
as 512 blocks with room for 99 programs, each program takes also about 3 blocks
as textfile and 25 blocks as generated.
Totally count on
2500‑3000 blocks for the installation.
16.3. TAMOS
selector
DMS.IQ is put in
TAMOS selector as eg. 03/DMS.IQ.STAR and then started directly on this user.
If you in the
selector put more than one programno. this program is started in IQ.
16.5. DRN ‑
Definition of files
With the DRN‑command
you call the file‑definitionprogram.
This module,
DMS.RAP.DRN, is mentioned in DMS.RAPGEN installationguide chapter 13.
DMS.IQ use
exactly the same filedefinitions as DMS.RAPGEN. To get full credit of DMS.IQ
you may have as many automatic file connection and index definitions as
possible.
DMS.IQ itself
defines eg. non‑defined index when a inquiry file is chosen first time in
an inquiry, you may then have permission to all searchkeys even if they are not
defined.
If you change a
file‑definition DMS.IQ will install the file next time an inquiry is chosen.
16.6.1. DMS.IQ
installation of files.
DMS.IQ need a
quick permission to the file index and the file connection to built up an index
key from a certain record.
To obtain this
DMS.IQ automatic extend recordlength for file‑definition DMFILES and use
this. After this there will be space for translation of index fields, while
instead of fieldnumbers (eg. 1,2,P) you make a string containing bytenumbers
and fieldtypes. Hereby all nessesary information are put in one place when keys
are built up.
Changing in a
file definition you delete this area and DMS.IQ will install the file again
next time.
Figures
Figure 1 FI#1‑5,40
screen layout............................................................................................................................................................... 5
Figure 2 KU#1‑3,7L screen layout............................................................................................................................................................. 5
Figure 3 FI#1‑7,40/FP#6,7,4,3,9 screen layout......................................................................................................................................... 5
Figure 4 FI#1‑7,40/FP#6,7,4,3,9L screen layout....................................................................................................................................... 5
Figure 5 IQ program menu.......................................................................................................................................................................... 6
Figure 6 IQ FILE menu................................................................................................................................................................................ 6
Figure 7 Screen picture by use of UPP/DOWN...................................................................................................................................... 7
Figure 8 SUPERINDEX retrival of BROWN............................................................................................................................................. 8
Figure 9 Transaction inquery with
GL#1,3,40/GT#6,8,4,3,9L.............................................................................................................. 10
Figure 10 ? Function
overview................................................................................................................................................................. 12
Figure 11 DOC ‑
Entering program documentation............................................................................................................................... 13
Figure 12 FIL:VA
index/file connection overview................................................................................................................................. 13
Figure 13 FLD field and
format overview................................................................................................................................................ 13
Figure 14 FLD:VA,2
extended field description..................................................................................................................................... 14
Figure 15 CAL pocket
calculator.............................................................................................................................................................. 14
Figure 16 HOW search
definitions........................................................................................................................................................... 14
Figure 17 TEST tesprint
during the search............................................................................................................................................. 15
Figure 18 DEMOOUT
demonstration file................................................................................................................................................ 16
Figure 19 PROGRAMS -
Program permission........................................................................................................................................ 20
Figure 20 FILES - File
permissions........................................................................................................................................................... 20
Figure 21 USERS on a new
installed system.......................................................................................................................................... 21
Figure 22 KEY function
keys.................................................................................................................................................................... 22
Figure 23 EDIT command
editor............................................................................................................................................................... 25
Figure 24 Command
numbers.................................................................................................................................................................... 25
Figure 25 DMS.RAPGEN's
IQ menu........................................................................................................................................................ 30
Figure 26 Calculations
in an inquery program........................................................................................................................................ 30
Figure 27 KU#1‑10/KP#7‑8,4,3,13
screen layout.................................................................................................................................... 31
Figure 28 Function 15 in
RAPGEN........................................................................................................................................................... 31
Figure 29 Calculations
from the standard program................................................................................................................................ 32
Figure 30 Amendments
without generation........................................................................................................................................... 32
Keyword index
Checks..................................................................................... 14
CHSYSTEM............................................................................ 21
Cost.......................................................................................... 30
DATAMASTER..................................................... 3,
23‑25, 29
DL............................................................................................. 33
DMFILES................................................................................ 37
DRN....................................................................... 14,
19, 25, 37
ESCape.................................................................................... 16
export....................................................................................... 33
fil........................................................................... 5,
6, 12, 13, 37
Format.................................................................................. 8,
13
IL.............................................................................................. 33
Layout................................................................................. 5,
31
LD............................................................................................. 33
LI.............................................................................................. 33
LPT........................................................................................... 17
LU....................................................................................... 21,
26
MODE...................................................................................... 16
NIROS................................................................................ 33,
37
NOT............................... 3‑6, 8, 11, 12, 15‑17,
20, 21, 26, 30‑37
over......................................................................... 12‑14,
18, 22
Pass.......................................................................................... 15
Password................................................. 4,
7, 12, 18, 19, 21, 25
POS...................................................................................... 7,
33
Protection.................................................................................. 7
QUICK................................................................................. 3,
37
REM................................................................................... 16,
25
SAVE............................. 3, 4, 6, 9, 12, 16, 19, 22, 25,
30, 31, 37
SCOPE..................................................................................... 37
Search......................................... 6, 12, 14, 15, 25‑27,
29, 34, 36
STAR................................................................. 7,
16, 23, 29, 37
SYSMOD................................................................................. 17
T2$........................................................................................... 32
TAMOS.............................. 4, 5, 7, 12, 17, 18, 21‑23,
25‑27, 37
Testprint............................................................................ 15,
25
VIKA........................................................................................ 13