Cool sample about error "create view ..."
Posted in 1998
Topics: General Discussion
INFORMIX 7.22 for NT and INFORMIX 7.23 for UNIX After run skript run SQL command: "select * from w_valstis" and see second column title. Could anyone comment this case? begin 600 muitammm.sql M8W)E871E(&1A=&%B87-E(&UU:71A;6UM.PT*#0IG<F%N="!D8F$@=&\\@(FEN M9F]R;6EX(CL-"F=R86YT(&1B82!T;R B<FEG97)T<R([#0IG<F%N="!D8F$@ M=&\\@(GIU;&ES(CL-"F=R86YT(&-O;FYE8W0@=&\\@(F]L96=S(CL-"F=R86YT M(&-O;FYE8W0@=&\\@(F1A;F]S<R([#0IG<F%N="!C;VYN96-T('1O(")T=7)A M;F]V82([#0IG<F%N="!C;VYN96-T('1O(")L875R:7-B(CL-"F=R86YT(&-O M;FYE8W0@=&\\@(FIA;FES:R([#0IG<F%N="!C;VYN96-T('1O(")K87)L:7-G M(CL-"F=R86YT(&-O;FYE8W0@=&\\@(FQA=7)I<VQA(CL-"F=R86YT(&-O;FYE M8W0@=&\\@(FEN971A9&TB.PT*9W)A;G0@8V]N;F5C="!T;R B:6YE='5S,3 B M.PT*9W)A;G0@8V]N;F5C="!T;R B:6YE='5S<C$B.PT*9W)A;G0@8V]N;F5C M="!T;R B:6YE='5S<C,B.PT*9W)A;G0@8V]N;F5C="!T;R B:6YE='5S<C@B M.PT*9W)A;G0@9&)A('1O(")A;&5K<R([#0IG<F%N="!D8F$@=&\\@(G9I97-T M=7)S(CL-"F=R86YT(&1B82!T;R B=FED=7-E<B([#0IG<F%N="!D8F$@=&\\@ M(G1A=&$B.PT*9W)A;G0@9&)A('1O(")E:6YS=&5I;B([#0IG<F%N="!D8F$@ M=&\\@(F=R86YD<&$B.PT*9W)A;G0@9&)A('1O(")E9V]N<R([#0IG<F%N="!D M8F$@=&\\@(FQA=7)I<R([#0H-"F-R96%T92!R;VQE(")K;&%S:68B(#L-"F-R M96%T92!R;VQE(")T=6MS82(@.PT*8W)E871E(')O;&4@(G1S="(@.PT*8W)E M871E(')O;&4@(FEZ8G)A=6,B(#L-"F-R96%T92!R;VQE(")V:7-S(B [#0IC M<F5A=&4@<F]L92 B=W=W(B [#0IC<F5A=&4@<F]L92 B=&ER8V%R;B(@.PT* M8W)E871E(')O;&4@(F%D;6EN(B [#0IC<F5A=&4@<F]L92 B875D:71S(B [ M#0IC<F5A=&4@<F]L92 B:W)A=FMU<W0B(#L-"F-R96%T92!R;VQE(")A='-K M86ET92(@.PT*8W)E871E(')O;&4@(F1M(B [#0IC<F5A=&4@<F]L92 B=F%D M(B [#0IC<F5A=&4@<F]L92 B:6YE=#@B(#L-"F-R96%T92!R;VQE(")I;F5T M,2(@.PT*8W)E871E(')O;&4@(F%A83(B(#L-"F-R96%T92!R;VQE(")A86$Q M(B [#0IC<F5A=&4@<F]L92 B:6YE=#$P(B [#0IC<F5A=&4@<F]L92 B<7%Q M<2(@.PT*#0IG<F%N=" B=FES<R(@=&\\@(F%L96MS(B [#0IG<F%N=" B:7IB M<F%U8R(@=&\\@(F%L96MS(B [#0IG<F%N=" B=FES<R(@=&\\@(G)I9V5R=',B M(#L-"F=R86YT(")V:7-S(B!T;R B9&%N;W-S(B [#0IG<F%N=" B=FES<R(@ M=&\\@(FMA<FQI<V<B(#L-"F=R86YT(")K<F%V:W5S="(@=&\\@(FQA=7)I<R(@ M.PT*9W)A;G0@(G1S="(@=&\\@(F1A;F]S<R(@.PT*9W)A;G0@(G9I<W,B('1O M(")L875R:7,B(#L-"F=R86YT(")A=61I=',B('1O(")L875R:7,B(#L-"F=R M86YT(")T:7)C87)N(B!T;R B;&%U<FES(B [#0IG<F%N=" B:W)A=FMU<W0B M('1O(")R:6=E<G1S(B [#0IG<F%N=" B='-T(B!T;R B:6YE=&%D;2(@.PT* M9W)A;G0@(FEN970Q,"(@=&\\@(FEN971U<S$P(B [#0IG<F%N=" B='-T(B!T M;R B:6YE='5S<C$B(#L-"F=R86YT(")T<W0B('1O(")I;F5T=7-R,R(@.PT* M9W)A;G0@(G1S="(@=&\\@(FEN971U<W(X(B [#0IG<F%N=" B:7IB<F%U8R(@ M=&\\@(F1A;F]S<R(@.PT*9W)A;G0@(FEZ8G)A=6,B('1O(")I;F5T861M(B [ M#0IG<F%N=" B:7IB<F%U8R(@=&\\@(FEN971U<W(Q(B [#0IG<F%N=" B:7IB M<F%U8R(@=&\\@(FEN971U<W(S(B [#0IG<F%N=" B='5K<V$B('1O(")R:6=E M<G1S(B [#0IG<F%N=" B='5K<V$B('1O(")T=7)A;F]V82(@.PT*9W)A;G0@ M(FEZ8G)A=6,B('1O(")Z=6QI<R(@.PT*9W)A;G0@(FEZ8G)A=6,B('1O(")I M;F5T=7-R."(@.PT*9W)A;G0@(FEZ8G)A=6,B('1O(")J86YI<VLB(#L-"F=R M86YT(")I>F)R875C(B!T;R B:V%R;&ES9R(@.PT*9W)A;G0@(FEZ8G)A=6,B M('1O(")L875R:7,B(#L-"F=R86YT(")I>F)R875C(B!T;R B;&%U<FES8B(@ M.PT*9W)A;G0@(FEZ8G)A=6,B('1O(")O;&5G<R(@.PT*9W)A;G0@(FEZ8G)A M=6,B('1O(")R:6=E<G1S(B [#0IG<F%N=" B:7IB<F%U8R(@=&\\@(G1U<F%N M;W9A(B [#0IG<F%N=" B:7IB<F%U8R(@=&\\@(G9I97-T=7)S(B [#0IG<F%N M=" B=FES<R(@=&\\@(F5G;VYS(B [#0IG<F%N=" B=FES<R(@=&\\@(G9I97-T M=7)S(B [#0IG<F%N=" B=FES<R(@=&\\@(GIU;&ES(B [#0IG<F%N=" B=FES M<R(@=&\\@(F]L96=S(B [#0IG<F%N=" B861M:6XB('1O(")A;&5K<R(@.PT* M9W)A;G0@(F%D;6EN(B!T;R B;&%U<FES(B [#0IG<F%N=" B='-T(B!T;R B M;&%U<FES(B [#0IG<F%N=" B=FES<R(@=&\\@(G1U<F%N;W9A(B [#0IG<F%N M=" B=FES<R(@=&\\@(FQA=7)I<V(B(#L-"F=R86YT(")V:7-S(B!T;R B:F%N M:7-K(B [#0H-"F-R96%T92!T86)L92 B:6YF;W)M:7@B+G9A;'-T:7,@#0H@ M("@-"B @("!I9%]V86QS=',@:6YT96=E<B!N;W0@;G5L;"!C;VYS=')A:6YT M(")I;F9O<FUI>"(N;C$T.%\\Q-#,L#0H@(" @=FMO9',@;F-H87(H,BD@;F]T M(&YU;&P@8V]N<W1R86EN=" B:6YF;W)M:7@B+FXQ-#A?,30T+ T*(" @(&ED M7V5K<F5G(&EN=&5G97(L#0H@(" @=FYO<V%U:W5M<R!N=F%R8VAA<B@R-2DL M#0H@(" @:V]N=&EN96YT<R!N8VAA<B@Q*2P-"B @("!I;G-D870@9&%T971I M;64@>65A<B!T;R!F<F%C=&EO;B@U*2 -"B @(" @(" @9&5F875L="!C=7)R M96YT('EE87(@=&\\@9G)A8W1I;VXH-2DL#0H@(" @9&5L9&%T(&1A=&4L#0H@ M(" @9&5R:6=S;F\\@9&%T92 -"B @(" @(" @9&5F875L="!T;V1A>2P-"B @ M("!P<FEM87)Y(&ME>2 H:61?=F%L<W1S*2!C;VYS=')A:6YT(")I;F9O<FUI M>"(N=3$T.%\\Q-#4-"B @*3L-"@T*:6YS97)T(&EN=&\\@=F%L<W1I<R H:61? M=F%L<W1S+'9K;V1S+&ED7V5K<F5G+'9N;W-A=6MU;7,L:V]N=&EN96YT<RQI M;G-D870L9&5L9&%T+&1E<FEG<VYO*2 -"@EV86QU97,@*#0Y,#<L)TQ6)RPT M,# Q+"=,871V:6IA(" @(" @(" @(" @(" @(" @)RPG,2<L#0H)9&%T971I M;64H,3DY."TP,BTP,B P,#HP,#HP,"XP,# P,"D@>65A<B!T;R!F<F%C=&EO M;B@U*2P-"@ED871E=&EM92@R-3 P+3 Q+3 Q*2!Y96%R('1O(&1A>2P-"@ED M871E=&EM92@Q.3DX+3 R+3 R*2!Y96%R('1O(&1A>2D[#0H-"G)E=F]K92!A M;&P@;VX@(FEN9F]R;6EX(BYV86QS=&ES(&9R;VT@(G!U8FQI8R([#0H-"@T* M#0IG<F%N="!A;&P@;VX@(FEN9F]R;6EX(BYV86QS=&ES('1O(")A;&5K<R(@ M=VET:"!G<F%N="!O<'1I;VX@87,@(FEN9F]R;6EX(CL-"F=R86YT('-E;&5C M="!O;B B:6YF;W)M:7@B+G9A;'-T:7,@=&\\@(F1M(B!A<R B:6YF;W)M:7@B M.PT*9W)A;G0@86QL(&]N(")I;F9O<FUI>"(N=F%L<W1I<R!T;R B96=O;G,B M('=I=&@@9W)A;G0@;W!T:6]N(&%S(")I;F9O<FUI>"([#0IG<F%N="!A;&P@ M;VX@(FEN9F]R;6EX(BYV86QS=&ES('1O(")E:6YS=&5I;B(@=VET:"!G<F%N M="!O<'1I;VX@87,@(FEN9F]R;6EX(CL-"F=R86YT(&%L;"!O;B B:6YF;W)M M:7@B+G9A;'-T:7,@=&\\@(F=R86YD<&$B('=I=&@@9W)A;G0@;W!T:6]N(&%S M(")I;F9O<FUI>"([#0IG<F%N="!S96QE8W0@;VX@(FEN9F]R;6EX(BYV86QS M=&ES('1O(")I>F)R875C(B!A<R B:6YF;W)M:7@B.PT*9W)A;G0@<V5L96-T M(&]N(")I;F9O<FUI>"(N=F%L<W1I<R!T;R B:VQA<VEF(B!A<R B:6YF;W)M M:7@B.PT*9W)A;G0@=7!D871E(&]N(")I;F9O<FUI>"(N=F%L<W1I<R!T;R B M:VQA<VEF(B!A<R B:6YF;W)M:7@B.PT*9W)A;G0@:6YS97)T(&]N(")I;F9O M<FUI>"(N=F%L<W1I<R!T;R B:VQA<VEF(B!A<R B:6YF;W)M:7@B.PT*9W)A M;G0@9&5L971E(&]N(")I;F9O<FUI>"(N=F%L<W1I<R!T;R B:VQA<VEF(B!A M<R B:6YF;W)M:7@B.PT*9W)A;G0@<V5L96-T(&]N(")I;F9O<FUI>"(N=F%L M<W1I<R!T;R B:W)A=FMU<W0B(&%S(")I;F9O<FUI>"([#0IG<F%N="!A;&P@ M;VX@(FEN9F]R;6EX(BYV86QS=&ES('1O(")L875R:7,B('=I=&@@9W)A;G0@ M;W!T:6]N(&%S(")I;F9O<FUI>"([#0IG<F%N="!S96QE8W0@;VX@(FEN9F]R M;6EX(BYV86QS=&ES('1O(")D;2(@87,@(FQA=7)I<R([#0IG<F%N="!S96QE M8W0@;VX@(FEN9F]R;6EX(BYV86QS=&ES('1O(")T<W0B(&%S(")L875R:7,B M.PT*9W)A;G0@86QL(&]N(")I;F9O<FUI>"(N=F%L<W1I<R!T;R B<FEG97)T M<R(@=VET:"!G<F%N="!O<'1I;VX@87,@(FEN9F]R;6EX(CL-"F=R86YT('-E M;&5C="!O;B B:6YF;W)M:7@B+G9A;'-T:7,@=&\\@(G9I<W,B(&%S(")R:6=E M<G1S(CL-"F=R86YT('5P9&%T92!O;B B:6YF;W)M:7@B+G9A;'-T:7,@=&\\@ M(G9I<W,B(&%S(")R:6=E<G1S(CL-"F=R86YT(&EN<V5R="!O;B B:6YF;W)M M:7@B+G9A;'-T:7,@=&\\@(G9I<W,B(&%S(")R:6=E<G1S(CL-"F=R86YT(&1E M;&5T92!O;B B:6YF;W)M:7@B+G9A;'-T:7,@=&\\@(G9I<W,B(&%S(")R:6=E M<G1S(CL-"F=R86YT(&%L;"!O;B B:6YF;W)M:7@B+G9A;'-T:7,@=&\\@(G1A M=&$B('=I=&@@9W)A;G0@;W!T:6]N(&%S