ipskey
ipskey
table:MATCHDETAILS field:3 file:teams addmissing:SOCCER|NEWTEAM|\ZK|\ZD
table:MATCHDETAILS field:4 file:teams default:BING
table:COMPETITIONS field:2 file:comps
table:COMPETITIONS field:7 lookup:sels
lookup:sels Div*1=D1 Div*2=D2 Div*3=D3 Div*4=D4
file:teams keylen:5 keytype:u
table: (tablename) (list of table entries ..) (eoln)
subkeywords for 'table' are :
field: fieldnumber starting at 3 for the first field as the first two
are DATABASE|TABLE eg:
database| table| field3 field4
SOCCER|MATCHDETAILS|30-9-95|Stirling|Ayr|GOAL|Taggart|18|||
file: name of file in tables/skey containing a list of keys and searches
lookup: name of a lookup table specified in this parameter file somewhere
There can be either a 'file' or a 'lookup' per table but not both.
The following are what to do if the field has no match. If nothing is
specified, the original data is left.
addmissing: add an extra record
a (unique) key is determined
an entry is added to the file
if there is a subparam, it is used to create a output
record before this one.
addmissing:SOCCER|TMP_TEAM|\ZK|\ZD
where ZK is the key and ZD is the data and ZO is the original
remember to add dbl quotes if spaces are to be embedded
zap: ignore this whole line !
default: make this the default
default:**MissingKey**
remember to add dbl quotes if spaces are to be embedded
default:"** Missing Key **"
again field \ZO is available
Note that fields ZK, ZD and ZO must NOT have any HASHES (#) as this
chr terminates the field.
The 'lookup' keyword is specified by :
lookup: (tablename) (list of table entries ..) (eoln)
eg lookup:abc 1=a 2=b 3=c 4=d 5=e 6=f
The list of lookup table entries are a number of entries delimitied by spaces
and/or tabs. If embedded spaces/tabs are needed, double quote the entry. The
condition is considered passed (or failed if the "!=" is used) if at least one
of the entries is matched.
The 'file' keyword is used to specify a maximum size and type of key :
file: (name of file) keylen: (size) keytype: (type)
file is the name of a file in tables/stat/key
and has the format
(opt spcs) (key) (spcs) (search text) (opt spcs)
LIVER Liv*pool
- wild cards can be specified using a '*' or a '?'.
- embedded spaces and control chrs - use double quotes and/or FipSeq for both
key and text
- lines may be commented by a leading ';'
- The search is assumed to START with the first chr, but the remainder is
wildcarded :
ALBI Albion
will find :
Albion Rovers
Albion United
Albion City
but NOT
Perfidious Albion
- keys can be sized and typed using 'keylen:' and 'keytype:'
- size can be 0 for no checking on size
- Valid types are :
u - uppercase (any lowercase is forced uppercase)
l - lowercase (any uppercase is forced lowercase)
a - alphabatic
x - alphanumeric
n - numbers only
p - printables (anything above SPC and NOT accented)
b - binary anything goes.
Other parameters - all optional - are :
sep:| Character to use as a field separator default: '|'
before: FipSeq string to add BEFORE any data default: none
after: FipSeq string to add AFTER any data default: none
befline: FipSeq string to add BEFORE each line default: none
aftline: FipSeq string to add AFTER each line default: none
script: Script to run on the output file. default: none
dest: FIP Destination to sent to for spooled default: 'skey'
queues. (not that single shot files stay
where they are)
doneq: For spooled queues, a done queue def: file deleted
for the input file.
chrset: Chrset for the output file.
filename: New filename for output file default: as input
fiphdr: Additional FipHdr information default: none
Where sections of FipHdr fields are required or changes to the output style,
use keywords : fixed, partial, combie, optional, repeat, newdate and/or style.
(see The SysAdmin manual for more information).
They are normally specified :
fixed:QZ 1234543
partial:QT ST,3,2,U,<,>
combie:QY ep|na,(0000000)a
option:QE ep,11,7,s
repeat:QK XK,-,3
or repeat:QP PK,,4,#X
style:QS XN,%.03d
Where the data lines have the similar information and often the same key, to
make things faster, you can cache the results. Beware however if you have
similar data - CHESTER and COLCHESTER for example - in this case we recommend
you do NOT cache. The default is NO caching.
Input Parameters are :
EITHER
-i : input queue default: spool/statkey
If this does NOT start with a '/', it is assumed under spool.
OR -1 : name of a single file (complete path pls) default: spooled queue
This will run the program once for that file only
The input file is NOT deleted.
-o : output or done queue for output file. default: spool/2go
If this does NOT start with a '/', it is assumed under spool.
Any original file in the output queue is overwritten.
-z : default parameter file in tables/stat. def: STAT_KEY
-w : file wait for files arriving across a network. def: 0 secs
-u : owner if not that of the logon default: logon at start
-l : do NOT log files in default: log
-C : cache results default: no
-x : display results default: no
-X : display results and prompt on a missing default: no
-v : print version number and exit
(copyright) 2025 and previous years FingerPost Ltd.