Multi-Thread on ESQL/C 7.24UC7
Posted in 2000
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
Hi all I have a question hwo to make my program with "Multi-Thread" by using ESQL/C 7.24UC7. The attached files are "DB.ec", "current.ec", "version.txt", and "error.txt". DB.ec contains functions about db connection. current.ec contails functions about main and child threads. version.txt indicates Informix Dynamic Server and ESQL/C version information. and error.txt shows error messages when i compile DB.ec and current.ec with esql/c I had use INFORMIXC=cc. I don't know what's the problem and what shall i do for it. -- ------------- Yeonjung, Kim begin 666 DB.ec M(VEN8VQU9&4@/'-T9&EO+F@^#0HC:6YC;'5D92 \\;6%T:"YH/@T*#0HC:69N M9&5F($1%1D%53%1-14T-"B-D969I;F4@1$5&055,5$U%32 @,3 P, T*(V1E M9FEN92!44E5%(" Q#0HC9&5F:6YE($9!3%-%(# -"B-E;F1I9@T*#0IE>'1E M<FX):6YT"6QO9V9P.PT*8VAA<@EM97-S86=E6T1%1D%53%1-14U=.PT*#0I% M6$5#"5-13 E"14=)3@E$14-,05)%"5-%0U1)3TX[#0IC:&%R"6-O;C%;72 ] M(")Y<B([#0I%6$5#("!344P@14Y$($1%0TQ!4D4@4T5#5$E/3CL-"@T*:6YT M"41"7T-O;FYE8W0H*0T*>PT*"45814,)4U%,"4)%1TE."41%0TQ!4D4)4T5# M5$E/3CL-"@EC:&%R"75I9%LR,%T[#0H)8VAA<@EP87-S=V1;,C!=.PT*"458 M14,)4U%,"45.1 E$14-,05)%"5-%0U1)3TX[#0H-"@ES<')I;G1F*'5I9"P@ M(FEN9F]R;6EX(BD[#0H)<W!R:6YT9BAP87-S=V0L(")I;F9O<FUI>"(I.PT* M#0H@(" @(" @($5814,@(" @4U%,(" @("!#;VYN96-T('1O("=D<F5A;31 M9VES)R!A<R G>7(G('5S97(@.G5I9"!U<VEN9R Z<&%S<W=D(%=)5$@@0T]. M0U524D5.5"!44D%.4T%#5$E/3CL-"@T*(" @(" @("!I9BA344Q#3T1%("$] M(# I(" @(" @("![#0H)"6UE;7-E="AM97-S86=E+" P+"!$149!54Q4345- M*3L-"@D)<W!R:6YT9BAM97-S86=E+" B1$(@0V]N;F5C="!%<G)O<B!7:71H M(%-13$-/1$4@/2 E9%QN(BP@4U%,0T]$12D[#0H@(" @(" @(" @(" @(" O M*B!,;V=0<FEN="AL;V=F<"P@;65S<V%G92D[("HO#0H)"7)E='5R;@E&04Q3 M13L-"B @(" @(" @?0T*(" @(" @("!E;'-E(" @('L-"B @(" @(" @(" @ M(" @("\\J($QO9U!R:6YT*&QO9V9P+" B4W5C8V5S<V9U;&QY($-O;FYE8W0@ M=&\\@1&%T86)A<V5<;B(I.R J+PT*"0ER971U<FX)5%)513L-"B @(" @(" @ M?0T*?0T*#0II;G0)1$)?1&]R;6%N="@I#0I[#0H)15A%0PE344P)<V5T"6-O M;FYE8W1I;VX).F-O;C$)9&]R;6%N=#L-"@T*"6EF*%-13$-/1$4@(3T@,"D) M>PT*"0EM96US970H;65S<V%G92P@,"P@1$5&055,5$U%32D[#0H)"7-P<FEN M=&8H;65S<V%G92P@(D1"($1O<FUA;G0@17)R;W(@4U%,0T]$12 ]("5D7&XB M+"!344Q#3T1%*3L-"B @(" @(" @(" @(" @(" O*DQO9U!R:6YT*&QO9V9P M+"!M97-S86=E*3L@*B\\-"@D)<F5T=7)N"49!3%-%.PT*"7T-"@EE;'-E"7L- M"B @(" @(" @(" @(" @(" O*DQO9U!R:6YT*&QO9V9P+" B1$(@1&]R;6%N M="!3=6-C97-S7&XB*3L@*B\\-"@D)<F5T=7)N"512544[#0H)?0T*?0T*#0II M;G0)1$)?4F5#;VYN96-T*"D-"GL-"@ED;PE[#0H)"45814,)4U%,"7-E= EC M;VYN96-T:6]N"3IC;VXQ.PT*(" @('!T:')E861?>6EE;&0H*3L@#0H)?0EW M:&EL92A344Q#3T1%(#T]("TQ.# R*3L-"@T*"6EF*%-13$-/1$4@/3T@,"D) M>PT*"0DO*DQO9U!R:6YT*&QO9V9P+" B1$(@4F5C;VYN96-T:6]N(%-U8V-E M<W-<;B(I.R J+PT*"0ER971U<FX)5%)513L-"@E]#0H)96QS90EI9BA344Q# M3T1%(#T]("TQ.# S*0E[#0H)"6UE;7-E="AM97-S86=E+" P+"!$149!54Q4 M345-*3L-"@D)<W!R:6YT9BAM97-S86=E+" B1$(@4F5#;VYN96-T($5R<F]R M(%-13$-/1$4@/2 E9"P@1$(@0V]N;F5C=&EO;B!,;V]S+BY<;B(L(%-13$-/ M1$4I.PT*(" @(" @(" @(" @(" @("\\J3&]G4')I;G0H;&]G9G L(&UE<W-A M9V4I.R J+PT*"0ER971U<FX)1D%,4T4[#0H)?0T*"65L<V4)>PT*"0EM96US M970H;65S<V%G92P@,"P@1$5&055,5$U%32D[#0H)"7-P<FEN=&8H;65S<V%G M92P@(D1"(%)E0V]N;F5C="!%<G)O<B!344Q#3T1%(#T@)61<;B(L(%-13$-/ M1$4I.PT*(" @(" @(" @(" @(" @("\\J3&]G4')I;G0H;&]G9G L(&UE<W-A C9V4I.R J+PT*"0ER971U<FX)1D%,4T4[#0H)?0T*?0T*#0H` ` end begin 666 current.ec M(VEN8VQU9&4@/&1C92]P=&AR96%D+F@^#0HC:6YC;'5D92 \\<W1D:6\\N:#X- M"@T*:6YT"6QO9V9P.PT*15A%0R @("!344P@(" @(&EN8VQU9&4@<W%L8V$[ M#0IP=&AR96%D7W0@(" @(" @=&AR96%D7VED.PT*=F]I9 ES:6=?:&%N9&QE M<BAI;G0@<V5G;F\\I.PT*:6YT"51E<W0H*3L-"@T*;6%I;B@I#0I[#0H@(" @ M(" @('!I9%]T(" @<&ED.PT*(" @(" @("!U;G-I9VYE9"!L;VYG(" @<W1A M='5S.PT*(" @(" @("!P=&AR96%D7W0@(" @(" @<'1H<F5A9%]I9#L-"@E$ M0E]#;VYN96-T*"D[#0H)1$)?1&]R;6%N="@I.PT*#0HO*@T*(" @(" @("!I M9BAS:6=N86PH4TE'5$5232P@<VEG7VAA;F1L97(I(#P@,"D-"B @(" @(" @ M(" @(" @("!P<FEN=&8H(G-I9VYA;"!E<G)O<EQN(BD[#0H@(" @(" @(&EF M*'-I9VYA;"A324=)3E0L('-I9U]H86YD;&5R*2 \\(# I#0H@(" @(" @(" @ M(" @(" @<')I;G1F*")S:6=N86P@97)R;W(B*3L-"B @(" @(" @:68H<VEG M;F%L*%-)1TE.5"P@<VEG7VAA;F1L97(I(#P@,"D-"B @(" @(" @(" @(" @ M("!P<FEN=&8H(G-I9VYA;"!E<G)O<B(I.PT*#0H@(" @(" @(&QO9V9P(#T@ M3&]G3W!E;B@B65(N;&]G(BD[#0HJ+PT*(" @(" @(&EF*"AS=&%T=7,@/2!P M=&AR96%D7V-R96%T92@F<'1H<F5A9%]I9"P@<'1H<F5A9%]A='1R7V1E9F%U M;'0L("AP=&AR96%D7W-T87)T<F]U=&EN95]T*2!497-T+"!.54Q,*2D@(3T@ M,"D@("![#0H@(" @(" @+RH@5&AR96%D($5R<F]R(%)O=71I;F4@*B\\-"B @ M(" @(" )"6EF*'-T871U<R ]/2!%04=!24XI#0H@(" @(" @"0D)<')I;G1F M*")3>7-T96TM:6UP;W-E9"!L:6UI="!O;B!T:&4@=&]T86P@(&YU;6)E<B!O M9B @=&AR96%D<R!I;B!A('!R;V-E<W,@:&%S(&)E96X@97AC965D960@7&XB M*3L-"@D):68H<W1A='5S(#T]($5)3E9!3"D-"B @(" @(" )"0EP<FEN=&8H M(E1H92!V86QU92!S<&5C:69I960@8GD@871T<B!I<R!I;G9A;&ED+EQN(BD[ M#0H@(" @(" @"0EI9BAS=&%T=7,@/3T@14Y/345-*0T*(" @(" @( D)"7!R M:6YT9B@B3F]T(&5N;W5G:"!M96UO<GD@=V%S(&%V86EL86)L92!T;R!C<F5A M=&4@=&AE(&YE=R!T:')E860N7&XB*3L-"B @(" @(" )"6EF*'-T871U<R ] M/2!%24Y604PI#0H@(" @(" @"0D)<')I;G1F*")S=&%C:U]B87-E(&ES(&YO M="!.54Q,(&%N9"!S=&%C:U]S:7IE(&ES(&QE<W,@=&AA;B!T:&4@=F%L=64@ M<F5T=7)N960@8GD@=&AR7VUI;E]S=&%C:UQN(BD[#0H@(" @(" @"0EP<FEN M=&8H(E1H<F5A9"!#<F5A=&4@17)R;W(N+BY<;B(I.PT*(" @(" @( D)97AI M="@Q*3L-"B @(" @(" @?0T*#0H@(" @(" @('!T:')E861?:F]I;BAP=&AR M96%D7VED+"!.54Q,*3L-"@EP<FEN=&8H(DA!2$%!2%QN(BD[#0I]#0H-"FEN M= E497-T*"D-"GL-"@E%6$5#"5-13 E"14=)3@E$14-,05)%"5-%0U1)3TX[ M#0H):6YT"5))1#L-"@EI;G0)3$E&15]2240[#0H)15A%0PE344P)14Y$"41% M0TQ!4D4)4T5#5$E/3CL-"@T*"41"7U)E0V]N;F5C="@I.PT*"45814,)4U%, M"7-E;&5C= EL:69E7W)I9"!I;G1O(#I,249%7U))1"!F<F]M(&QI9F5S:7-U M;"!W:&5R92!R:60@/2 Z4DE$.PT*#0H):68H4U%,0T]$12 A/2 P*0E[#0H) M"7!R:6YT9B@B4U%,15)23U(@0T]$12 ]("5D7&XB+"!344Q#3T1%*3L-"@E] M#0H)96QS90E[( T*"0EP<FEN=&8H(E))1" ]("5D+"!,249%7U))1" ]("5D M7&XB+"!2240L($Q)1D5?4DE$*3L-"@E]#0H)1$)?1&]R;6%N="@I.PT*?0T* M=F]I9" @("!S:6=?:&%N9&QE<BAI;G0@<V5G;F\\I#0I[#0H@(" @(" @('!R M:6YT9B@B4VEG;F%L(&-A=&-H960N+BY<;B(I.PT*(" @(" @("!P<FEN=&8H M(E-E<G9E<B!%>&ET+BXN7&XB*3L-@@DQ@
Change that -ldce to -lposix to match the THREADLIB environment var.
Art S. Kagel
"Yeonjung, Kim" wrote:
>
> Hi all
>
> I have a question hwo to make my program with "Multi-Thread" by using ESQL/C
> 7.24UC7.
>
> The attached files are "DB.ec", "current.ec", "version.txt", and
> "error.txt".
> DB.ec contains functions about db connection.
> current.ec contails functions about main and child threads.
> version.txt indicates Informix Dynamic Server and ESQL/C version
> information.
> and error.txt shows error messages when i compile DB.ec and current.ec with
> esql/c
>
> I had use INFORMIXC=cc.
>
> I don't know what's the problem and what shall i do for it.
>
> --
> -------------
> Yeonjung, Kim
>
> Name: DB.ec
> DB.ec Type: unspecified type (application/octet-stream)
> Encoding: x-uuencode
>
> Name: current.ec
> current.ec Type: unspecified type (application/octet-stream)
> Encoding: x-uuencode
>
> DSystem% esql -o CT DB.ec current.ec -thread -ldce -lpthread
> esql: When using -thread, the THREADLIB environment variable
> must be set to a supported thread library. Currently
> supporting: DCE, POSIX(Solaris 2.5 and higher only) and
> SOL (Solaris Kernel Threads).
> DSystem% setenv THREADLIB POSIX
> DSystem% esql -o CT DB.ec current.ec -thread -ldce -lpthread> esql: When using -thread, the THREADLIB environment variable
> must be set to a supported thread library. Currently
> supporting: DCE, POSIX(Solaris 2.5 and higher only) and
> SOL (Solaris Kernel Threads).
> DSystem% setenv THREADLIB DCE
> DSystem% esql -o CT DB.ec current.ec -thread -ldce -lpthread
> DB.c:
> current.c:> Undefined first referenced
> symbol in file
> pthread_mutexattr_create /informix/lib/esql/libtos.so
> pthread_mutexattr_delete /informix/lib/esql/libtos.so
> pthread_condattr_delete /informix/lib/esql/libtos.so
> pthread_keycreate /informix/lib/esql/libtgen.so
> pthread_Fork /informix/lib/libtasf.so
> pthread_mutexattr_setkind_np /informix/lib/esql/libtos.so
> pthread_condattr_create /informix/lib/esql/libtos.so
> ld: Ä¡¸íÀû: ±âÈ£ ÂüÁ¶ ¿À·ù. CT¿¡ Ãâ·ÂÀÌ ±â·ÏµÇÁö ¾ÊÀ½
>
> DSystem% cat ESQL-cr> INFORMIX EMBEDDED SQL for C Version 7.24.UC7
> Copyright (C) 1991-1998 Informix Software, Inc.
> DSystem% cat IDS-cr> Informix Dynamic Server Version 7.31.UC3
> Copyright (C) 1986-1999 Informix Software, Inc.
> DSystem%