ëÏÒÏÞÅ, ËÏÍÕ ÎÁÄÏ, ×ÏÔ ÓËÒÉÐÔ. íÏÖÎÏ ÎÁÐÉÓÁÔØ ÂÁÔÎÉË, ÍÎÅ ÌÅÎØ, Õ ÍÅÎÑ ÏÎÏ
×ÓÔÒÏÅÎÏ × ÉÎÓÔÁÌÑÔÏÒ:
1) ÏÓÔÁÎÁ×ÌÉ×ÁÅÍ ÓÅÒ×ÉÓ
net stop FirebirdServerDefaultInstance
2) ËÏÐÉÒÕÅÍ ÓÉÓÔÅÍÎÕÀ ÂÁÚÕ ËÕÄÁ-ÎÉÂÕÄØ
3) ÓÔÁÒÔÕÅÍ ÓÅÒ×ÉÓ
net start FirebirdServerDefaultInstance
4) ×ÙÐÏÌÎÑÅÍ ÄÁÎÎÙÊ ÓËÒÉÐÔ ÎÁÄ ËÏÐÉÅÊ ÓÉÓÔÅÍÎÏÊ ÂÁÚÙ (× ÎÁÞÁÌÅ ÓËÒÉÐÔÁ
ÉÚÍÅÎÑÅÍ CONNECT ÎÁ Ó×ÏÊ)
5) ÏÓÔÁÎÁ×ÌÉ×ÁÅÍ ÓÅÒ×ÉÓ
net stop FirebirdServerDefaultInstance
6) ËÏÐÉÒÕÅÍ ÓÉÓÔÅÍÎÕÀ ÂÁÚÕ ÏÂÒÁÔÎÏ
7) ÓÔÁÒÔÕÅÍ ÓÅÒ×ÉÓ
net start FirebirdServerDefaultInstance
ðÏÌÕÞÁÅÍ ÓÉÓÔÅÍÎÕÀ ÂÁÚÕ, ÌÉÛÅÎÎÕÀ ÕËÁÚÁÎÎÙÈ ÎÅÄÏÓÔÁÔËÏ×. ëÏÍÕ ÎÅ ÈÏÞÅÔÓÑ,
ÞÔÏÂÙ ÌÀÂÏÊ ÍÏÇ ÐÏÌÕÞÉÔØ ÓÐÉÓÏË ÐÏÌØÚÏ×ÁÔÅÌÅÊ, ÔÏÔ ÉÚÍÅÎÑÅÔ × ÜÔÏÍ ÓËÒÉÐÔÅ
CREATE VIEW ×ÙÒÁÖÅÎÉÅ (ÍÏÖÎÏ ÐÒÏÓÔÏ ÄÏÐÉÓÁÔØ WHERE ÓÁÍÉÚÎÁÅÔÅÞÔÏ)
òÁÂÏÔÁÅÔ ÏÄÉÎÁËÏ×Ï ÕÓÐÅÛÎÏ ÎÁ 1.5 É 2.0, ×ÙÄÁ×ÁÑ 1 ÏÛÉÂËÕ ÎÁ DROP TABLE ÌÉÂÏ
DROP VIEW
ëÁË ÏÂÙÞÎÏ, ÓËÒÉÐÔ AS IS, ÐÒÉÍÅÎÑÅÔÓÑ ÎÁ Ó×ÏÊ ÓÔÒÁÈ É ÒÉÓË
begin 666 SysBaseModify.sql
M4T54($Y!3453(%=)3C$R-3$[#0I#3TY.14-4("=L;V-A;&AO<W0Z0SI<0E5<
M<V5C=7)I='DN9F1B)PT*(%5315(@)U-94T1"02<@4$%34U=/4D0@)VUA<W1E
M<FME>2<[EMAIL PROTECTED]"[EMAIL PROTECTED])3("@@(" @(" @(" @(" @
M(" @(" @( T*("!54T527TY!344@(" @("!605)#2$%2*#$R."[EMAIL PROTECTED]
M5$52(%-%5"[EMAIL PROTECTED],3"P@( T*("!365-?55-%4E].
M04U%("!605)#2$%2*#$R."[EMAIL PROTECTED](%-%5"!53DE#3T1%7T934RP@
M(" @(" @(" @( T*("!'4D]54%].04U%(" @("!605)#2$%2*#$R."[EMAIL PROTECTED]
M4D%#5$52(%-%5"!53DE#3T1%7T934RP@(" @(" @(" @( T*("!5240@(" @
M(" @(" @("!)3E1%1T52+" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" @(" @(" @(" @( T*("!'240@(" @(" @(" @("!)3E1%1T52+" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*("!005-3
M5T0@(" @(" @("!605)#2$%2*#8T*2!#2$%204-415(@4T54($]#5$544R!.
[EMAIL PROTECTED],3"P@(" @(" @( T*("!04DE624Q%1T4@(" @("!)3E1%1T52+" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*("!#
M3TU-14Y4(" @(" @("!"3$]"(%-50E]465!%([EMAIL PROTECTED]'345.5"!325I%([EMAIL
PROTECTED]
M+" @(" @(" @(" @(" @(" @( T*("!&25)35%].04U%(" @("!605)#2$%2
M*#,R*2!#2$%204-415(@4T54(%5.24-/1$5?1E-3($1%1D%53%0@)R<L( T*
M("!-241$3$5?3D%-12 @("!605)#2$%2*#,R*2!#2$%204-415(@4T54(%5.
M24-/1$5?1E-3($1%1D%53%0@)R<L( T*("!,05-47TY!344@(" @("!605)#
M2$%2*#,R*2!#2$%204-415(@4T54(%5.24-/1$5?1E-3($1%1D%53%0@)R<I
M.PT*0U)%051%(%5.25%512!)3D1%6"!365-?55-%4E].04U%7TE.1$58($].
M(%-94U]54T524R H55-%4E].04U%*3L-"FEN<V5R="!I;G1O(%-94U]54T52
M4R@@(" @(" @(" @(" @(" @(" @(" @#0H@(%5315)?3D%-12P@(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @( T*("!365-?55-%4E].04U%+" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" -"B @1U)/55!?3D%-12P@(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @#0H@(%5)1"P@(" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*("!'240L(" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -"B @4$%34U=$+" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0H@(%!2259)3$5'12P@
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*("!#3TU-14Y4+" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -"B @1DE24U1?3D%-
M12P@(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0H@($U)1$1,15].
M04U%+" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*("!,05-47TY!
M344I(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -"G-E;&5C=" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0H@(%5315)?
M3D%-12P@(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*("!365-?
M55-%4E].04U%+" @(" @(" @(" @(" @(" @(" @(" @(" @(" -"B @1U)/
M55!?3D%-12P@(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0H@(%5)
M1"P@(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*("!'
M240L(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -"B @
M4$%34U=$+" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0H@
M(%!2259)3$5'12P@(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*
M("!#3TU-14Y4+" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -
M"B @1DE24U1?3D%-12P@(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M#0H@($U)1$1,15].04U%+" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M( T*("!,05-47TY!344@(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" -"F9R;[EMAIL PROTECTED],[(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" @#0I#;VUM:70[#0ID<F]P('1A8FQE('5S97)S.PT*9')O<"!V:65W('5S
M97)S.PT*0V]M;6ET.PT*8W)E871E('9I97<@=7-E<G,@*" @(" @(" @(" @
M(" @(" @(" @(" @(" -"B @55-%4E].04U%+" @(" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @#0H@(%-94U]54T527TY!344L(" @(" @(" @(" @
M(" @(" @(" @(" @(" @( T*("!'4D]54%].04U%+" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" -"B @54E$+" @(" @(" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" @#0H@($=)1"P@(" @(" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" @( T*("!005-35T0L(" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" -"B @4%))5DE,14=%+" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" @#0H@($-/34U%3E0L(" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" @( T*("!&25)35%].04U%+" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" -"B @34E$1$Q%7TY!344L(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @#0H@($Q!4U1?3D%-12P@(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @( T*("!&54Q,7TY!344I(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" -"F%S(" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @[EMAIL PROTECTED]&ES=&EN8W0@
M(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*("!54T527TY!344L(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -"B @4UE37U5315)?3D%-
M12P@(" @(" @(" @(" @(" @(" @(" @(" @(" @#0H@($=23U507TY!344L
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*("!5240L(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -"B @1TE$+" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0H@(&-A<[EMAIL PROTECTED]
M4B @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*(" @('=H96X@
M=7-E<E]N86UE('[EMAIL PROTECTED](" @(" @(" @(" @(" -"B @("!W:&5N
M("=365-$0D$G('[EMAIL PROTECTED](" @(" @(" @(" @(" @#0H@(" @=VAE
M;B G)R!T:&5N(%!!4U-71" @(" @(" @(" @(" @(" @(" @( T*(" @(&5L
M<V4@;G5L;" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -"B @96YD
M+" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0H@(%!2
M259)3$5'12P@(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*("!#
M3TU-14Y4+" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -"B @
M1DE24U1?3D%-12P@(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0H@
M($U)1$1,15].04U%+" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*
M("!,05-47TY!344L(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -
M"B @1DE24U1?3D%-12!\?" G("<@?'[EMAIL PROTECTED]@?'P@)R G('Q\
M($Q!4U1?3D%-10T*9G)O;2!365-?55-%4E,[(" @(" @(" @(" @(" @(" @
M(" @(" @(" @(" -"D=204Y4(%-%3$5#5"[EMAIL PROTECTED]@55-%4E,@5$\@
M4%5"3$E#.PT*0V]M;6ET.PT*0U)%051%($580T505$E/3B!54T527TE.1D]?
M15A#15!424].("=#86YT('5P9&%T92!U<V5R(&EN9F\G.PT*0U)%051%($58
M0T505$E/3B!54T527U!!4U-73U)$7T580T505$E/3B G3VYL>2!O=VX@<&%S
M<W=O<F1S(&%L;&]W960G.PT*4T54([EMAIL PROTECTED] [(" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" -"D-214%412!44DE'1T52(%1"25]54T524R!&
M3U(@55-%4E,@(" @(" @(" @#0I!0U1)[EMAIL PROTECTED]&3U)%($E.4T525"!03U-)
M5$E/3B P(" @(" @(" @(" @( T*87,@(" @(" @(" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" -"F)E9VEN(" @(" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" @#0H@(&EN<V5R="!I;G1O(%-94U]54T52
M4R@@(" @(" @(" @(" @(" @(" @( T*(" @(%5315)?3D%-12P@(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" -"B @("!365-?55-%4E].04U%+" @
M(" @(" @(" @(" @(" @(" @(" @(" @#0H@(" @1U)/55!?3D%-12P@(" @
M(" @(" @(" @(" @(" @(" @(" @(" @( T*(" @(%5)1"P@(" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" -"B @("!'240L(" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @#0H@(" @4$%34U=$+" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*(" @(%!2259)3$5'12P@
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -"B @("!#3TU-14Y4+" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0H@(" @1DE24U1?3D%-
M12P@(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*(" @($U)1$1,15].
M04U%+" @(" @(" @(" @(" @(" @(" @(" @(" @(" -"B @("!,05-47TY!
M344I(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0H@('9A;'5E<R H
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*(" @(&YE=RY5
M4T527TY!344L(" @(" @(" @(" @(" @(" @(" @(" @(" -"B @("!N97<N
M4UE37U5315)?3D%-12P@(" @(" @(" @(" @(" @(" @(" @#0H@(" @;F5W
M+D=23U507TY!344L(" @(" @(" @(" @(" @(" @(" @(" @( T*(" @(&YE
M=RY5240L(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -"B @("!N
M97<N1TE$+" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0H@(" @
M;F5W+E!!4U-71"P@(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*(" @
M(&YE=RY04DE624Q%1T4L(" @(" @(" @(" @(" @(" @(" @(" @(" -"B @
M("!N97<N0T]-345.5"P@(" @(" @(" @(" @(" @(" @(" @(" @(" @#0H@
M(" @;F5W+D9)4E-47TY!344L(" @(" @(" @(" @(" @(" @(" @(" @( T*
M(" @(&YE=RY-241$3$5?3D%-12P@(" @(" @(" @(" @(" @(" @(" @(" -
M"B @("!N97<N3$%35%].04U%*3L@(" @(" @(" @(" @(" @(" @(" @(" @
M#0IE;[EMAIL PROTECTED] @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M( T*0U)%051%(%1224='15(@5$)57U5315)3($9/4B!54T524R @(" @(" @
M(" -"D%#5$E612!"149/[EMAIL PROTECTED](%!/4TE424].(# @(" @(" @(" @
M(" @#0IA<R @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" @( T*8F5G:6X@(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" @(" -"B @:[EMAIL PROTECTED]'5S97(\/B=365-$0D$G*2!T:&5N(" @(" @(" @(" @
M(" @(" @#0H@(&)E9VEN(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" @(" @( T*(" @(&EF("@H;F5W+G5S97)?;F%M93P^=7-E<BD@;W(@(" @
M(" @(" @(" -"B @(" @(" @*&]L9"YU<V5R7VYA;64\/G5S97(I*2 @(" @
M(" @(" @(" @#0H@(" @=&AE;B @(" @(" @(" @(" @(" @(" @(" @(" @
M(" @(" @(" @( T*(" @(" @97AC97!T:6]N('5S97)?<&%S<W=O<F1?97AC
M97!T:6]N.R @(" -"B @("!I9B H(" @(" @(" @(" @(" @(" @(" @(" @
M(" @(" @(" @(" @#0H@(" @(" H;F5W+F9I<G-T7VYA;64\/F]L9"YF:7)S
M=%]N86UE*2!O<B @( T*(" @(" @*&YE=RYM:61D;&5?;F%M93P^;VQD+FUI
M9&1L95]N86UE*2!O<B -"B @(" @("AN97<N;&%S=%]N86UE/#YO;&0N;&%S
M=%]N86UE*2D@(" @(" @#0H@(" @=&AE;B @(" @(" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @( T*(" @(" @97AC97!T:6]N('5S97)?:6YF;U]E
M>&-E<'1I;VX[(" @(" @(" -"B @96YD(" @(" @(" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" @#0H@('5P9&%T92!365-?55-%4E,@<V5T(" @
M(" @(" @(" @(" @(" @(" @( T*(" @(%5315)?3D%-12 @(" @/2!N97<N
M55-%4E].04U%+" @(" @(" @(" -"B @("!365-?55-%4E].04U%(#T@;F5W
M+E-94U]54T527TY!344L(" @(" @#0H@(" @1U)/55!?3D%-12 @(" ](&YE
M=RY'4D]54%].04U%+" @(" @(" @( T*(" @(%5)1" @(" @(" @(" @/2!N
M97<N54E$+" @(" @(" @(" @(" @(" -"B @("!'240@(" @(" @(" @(#T@
M;F5W+D=)1"P@(" @(" @(" @(" @(" @#0H@(" @4$%34U=$(" @(" @(" ]
M(&YE=RY005-35T0L(" @(" @(" @(" @( T*(" @(%!2259)3$5'12 @(" @
M/2!N97<N4%))5DE,14=%+" @(" @(" @(" -"B @("!#3TU-14Y4(" @(" @
M(#T@;F5W+D-/34U%3E0L(" @(" @(" @(" @#0H@(" @1DE24U1?3D%-12 @
M(" ](&YE=RY&25)35%].04U%+" @(" @(" @( T*(" @($U)1$1,15].04U%
M(" @/2!N97<N34E$1$Q%7TY!344L(" @(" @(" -"B @("!,05-47TY!344@
M(" @(#T@;F5W+DQ!4U1?3D%-12 @(" @(" @(" @#0H@('=H97)E(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*(" @(%5315)?3D%-
M12 @(" @/2!O;&0N55-%4E].04U%.R @(" @(" @(" -"F5N9"!>(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @[EMAIL PROTECTED]))
M1T=%4B!40D1?55-%4E,@1D]2(%5315)3(" @(" @(" @( T*04-4259%($)%
[EMAIL PROTECTED])3TX@," @(" @(" @(" @(" -"F%S(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0IB96=I;B @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*("!D96QE
M=&[EMAIL PROTECTED])O;2!365-?55-%4E,@(" @(" @(" @(" @(" @(" @(" -"B @=VAE
M<F4@(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0H@(" @
M55-%4E].04U%(" @(" ](&]L9"Y54T527TY!344[(" @(" @(" @( T*96YD
M(%X@(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -"E-%
M5"!415)-([EMAIL PROTECTED] @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0I'
M4D%.5"[EMAIL PROTECTED]@4UE37U5315)3(%1/(%1224='15(@5$)$7U5315)3
M.PT*1U)[EMAIL PROTECTED])4($].(%-94U]54T524R!43R!44DE'1T52(%1"25]5
M4T524SL-"D=204Y4(%501$%412!/3B!365-?55-%4E,@[EMAIL PROTECTED]))1T=%4B!4
+0E5?55-%4E,[#0H`
`
end
