΢ͻӦ
WEIXINGJI YU YINGYONG
2000Vol.19No.5P.47-49




຺ϲѯĲѯģʽ

ժ Ҫ຺ϲѯFIMSFINDĲѯģʽ췽й⡣Բѯģʽ졢ѯģʽΪ˼ġϢĲѯϵͳԭͷɹ䣬ԽűFimsScript﷨ѯԪøȹؼϸۡ
ؼʣѯŻ ѯ ݿ⼼ ģʽӿ ѯ
ԲѯͼΪҪҵϢϵͳISģͨԼΪ14Ԫ飬
IS DBSQLAS
УݿϵͳDBSΪжʵļϣѯQLʾвѯϣϵͳASʾвѯļϣѯ㺯Ϊƫӳ亯
DBSQLAS
ڹϵݿϢϵͳDBSҪɱںݿģʽ͹ϵݿӶֹɣΪ޵ϢϣQLͨΪûѡָĲѯʽDBMSѯϵͳɲѯƫӳ̣ѯASQLDBSݿ⣨Իݿ⺯޶ԹɵĿϲѯϵȣ߼ϵANDORЧѯֵΪ޼Ȱһ϶ɵЧ޼ϣASΪQLʽġDBSĳһйϵһֻйϵعݣϵͼȻASҲӦΪ޼ϡնûΪʹöġڿϲѯνѯһֱϵĽ޵Ĳѯе޵ĲѯһЧ֮һ1ݣ2ݣ3ݡ
רõĲѯƻ߼ɹ֧ḻĲѯѳΪνĵ4ԣ4GLPowerBuilderInformixsȣɫйDBMSϲѯƵԭָ꼰ʵֵרһֱǴϢϵͳCIS۵ص㡢ĵȵͿѵ㡣ѷ֣еʵлΧƹCISνġѯĹܣȡһЧǣ൱CISԣνѯƻٴ⣺
1նûҪϤϵͳݿṹãݿѯʽSQLĹ죬Ȼǲġ
2ϽĿ⡣ɿؼʵֵڣȱʽ˳ľȷơֶѡԼơѯֵЧ顢ѯֶѯֵƥʱжȣӶӰŲѯϵͳС
3ûʽԡЧ޷ύDBMSִвѯǰм飬ҪնûиDBMSʾ¹ѯʽڰ칫ҵķǼרҵûԣҪȻǹˡ
4ʽĹ⡣ʽʹţѯûFIMSKITSOFfice Information System KitsǱƿľйܼɻǹ̻ǶκοԵܻ䣨ܻľ䣩У򷺹ϵӿڵġ຺ְ֧﷽ʽбʽϵĲѯɲѯģʽάFFINDKITģʽFIMSFIND׹ʹáҪFIMSFINDնûӿڵ຺ﻯ桢ѯģʽFIMSKITSűFimsScriptѯģʽȷ⡣
1 ຺ϲѯû
FFINDKITҪǰϵͳԱʹýűFimsScriptıѯģʽTQOSɿFIMSFINDֱеĲѯģʽQOSQOS߼϶һWindowsϵͳĿִгļϣFIMSFINDضFFINDKITͼ1ʾ

ͼ1 FIMSFINDѯģʽάFFINDKITʾͼ
ѯģʽQOS߼ϿԶѯ̣ʵʹУ1ǧѯܵCISֻͨ1QOSģʽļɡFIMSFINDΪͻصΪնûṩ຺ﻯѯĹڣͼ2ʾ

ͼ2 FFINDKITѯ
ͼ2ԿFIMSFINDʵֲѯ຺ﻯϵĲѯϵ߼ϵȶ෽຺ﻯѯ຺ﻯĹFIMSFINDʵ֣ݡƵȷۺͨѯģʽĹɡ
2 ѯģʽԪFimsScript
QOSҪɲѯѯԪݲѯԴͼϢϵİPACKAGEɣ1QOS԰صTQOSűɼ£
1ѯTQOSԲѯΪ߼Ԫ1ɾۼѯԪFIMSFIND԰ʵַװڿԶȫֶ󡢾ֲȡ1QOSļ԰ѯʽΪ 
PACKAGE ѯ IS QUERY
ѯ壾
END PACKAGE
2ݲѯԴͼĶ塣Ϊʵݿʵ޹Ժ߼޹ԣFIMSKITSʹ˷ϵģʽĸ[2][3]ṩ˷ϵģʽ䣬ûڶݿģʽķϵģʽUROSUROSѯģʽõݿԼϿΪΨһϵģʽϵĵһϵԴݲѯԴͼͨUROSж壬TQOSá磺
INPUT RELATION IS rminrel ָѯԪ
ȱʡݲѯԴ
OUTPUT VIEW IS rmoutview ָѯԪȱ
ʡͼ
3ֶκƴֶĶ塣FIMSKITSĴֶεĺ뻷Ķ߳е4ݣ5ݣTQOSֻΪüɡ
STATIC CODEOBJECT IS rmcode ̬ȱ
ʡ
DYNAMIC FIELDOBJECT IS rmfield 
ݿֶε
4̬ѯSQIĶ塣̬ѯΪ1κδЧѯʽSQIڰڿΪȫֳʹãҪϾ̬̬ϲѯԪTQOSѶSQIΪ1̬ѯ壨SQIB1SQIB԰SQI1ѯڿ԰SQIB1TQIBֽɶTQIBϲ޲ֻΪ˱дűѡ߼ϣTQIBΪ1TQIB
5̬ѯDQIĶ塣̬ѯΪ1ұЧѯʽбָͺͳ⣬DQI̬ѯ壨DQIBĶ塢SQISQIBơ
6ϲѯCQIĶ塣CQIԷϵԶĿ
3 ѯģʽĹ
QOSͬһSQIDQICDIΪȫֱΪѯԪĹFIMSFINDĲѯԪɲѯ߶ѯ߼ϵANDORɵĲѯʽʽ򡢲ѯ⡢ѯԴͼñʶϢɵ߼ϡѯԪָ߼ָĲѯʽĲѯֻSQIʱΪ̬ѯԪSQUSQIDSIٰ1DQIʱΪ̬ѯԪDQUٰ1CQIʱ֮ΪϲѯԪCQU1򻯵Ĳѯűűиעͣڲ׸
PACKAGE GBRMQUERY IS QUERY
ڶ󡢿ͼ󡢴ȶ壨ԣ
DYNAMIC WINDOWS IS dywin ָ̬ѯ
Ԫȱʡ
COMPOSE WINDOWS IS cowin ָϲѯ
Ԫȱʡ
INPUT RELATION IS rminrel ָѯԪȱ
ʡϵ
OUTPUT VIEW IS rmoutview ָѯԪȱ
ʡͼ
STATIC CODEOBJECT IS rmcode ѯ
صľ̬ȱʡ
DYNAMIC FIELDOBJECT IS rmfield 
ݿֶε
STATIC CONDITION ITEMS ARE DEFINED AS
徲̬ѯ
S010٣FOR JGW1
S040FOR ZWD04
S490FORZWD04ݣANDZWD05ݣ
ORZWD54ݣANDZWD55ݣ
END STATIC
嶯̬ѯ
DYNAMIC CONDITION ITEMS ARE DEFINED AS
D100ʼ£DATE7 FOR RWSt
D110ֹ£DATE7 FOR RWSt
D850ξε£DATE7 FORJXW
33ݣADNWHC3ݣANDAGEtJXS 3
 ORJXW33ݣANDWHC3ݣANDAGEt
JXS 2ORJXW32ݣANDJXW22ݣ
ANDAGEtJXS 4
END DYNAMIC
COMPOSE CONDITION ITEMS ARE DEFINED AS
ϲѯ
C410ְȼCHAR2 HELP19壬rmcode
TAILHEADSTATIC FOR ZWDt
C420λƣCHAR40 HELPdwm壬rmfield
DYNAMIC
C430ְʱ䣩DATE7 FOR ZWSt
C450CHAR2 HELP37壬rmcodeTAIL
HEADSTATIC FOR JSJt
C470ʱ䣩DATE7 FOR JSSt
C710ڱCHAR1 HELP28壬rmcode
TAILHEADSTATIC FOR ZBQt
C720Ƿ쵼CHAR1 HELP54壬rmcode
TAILHEADSTATIC FOR SLDt
END COMPOSE
QUERY SET IS DEFINED AS 涨ѯ
CREATE QUERY 131 AS һ̬ѯԪ
롢ͼʹȱʡ
TITLE IS ְѯ
WHERE S010ANDS040 ѯʽ
END CREATE
CREATE QUERY 132 AS һ̬ѯ
Ԫڡ롢ͼȾʹȱʡָ
TITLE IS 尴ʱѯ
WHERE S010andS040andD100andD110
END CREATE
CREATE QUERY 133 AS ͬѯԪ132
TITLE IS ξپεѯ
WHERE S010andD850andD900andD910
END CREATE
CREATE QUERY 1A WITH COMPOSE AS 
һϵĲѯԪڡ
롢ͼʹȱʡָ
TITLE IS ְѯ
PREFIX EXPRESS IS S010andD100andD110
ǰñʽ
WHERE C410C430C450C470C710C720
ָ
END CREATE
END QUERY SET
END PACKAGE
VMĸFIMSKITS˷ϵģʽURS1ݣ2ݣ3ݵĻƣڶ๦ܲѯFIMSFINDURS൱1ݿϵͳVDBMSݿûǶȿVDBMSݿԵļϹ1ϵģʽݶΨһϵģʽϵĽṹݼϹɣFIMSFINDϵݿ⸴ӵĲѯ㶼תΪURSаѡļ򵥲FIMSFINDΪҪFIMSKITS䣬TurboCԼ150ܻľɣVCWindowsϵͳֲתѻɣУFIMSFINDýѧϰܣȡ˽ΪЧ
㣨ľҽѧҽѧϵ710032
ο
1Kifer MLozinskii E LOn compiletime optimization in deductive database by means of static filteringACM Tran on database systems199015(3):385
2Atzeni PUpdating relational database through weak instance interfaceACM Tran on Database Systems199217(4)718
3Llee DDocument ranking on weightpartitioned signature filesACM Tran on information systems199614(2):109
4㣮ıѯԼ㣮С΢ͼϵͳ199516(7):26
5㣬ԣҽѧݿģͣľҽѧѧ1999203228
ոڣ19991210
