Re: Help With BLOBs, General Informix Comments
Posted in 1994
Quoting Brian G.... } } > } > In article <2llck1$fa6@access3.digex.net> you write: } > } } > } 3) It seems that the only way to manipulate a BLOB other than having } > } the user type it in in an INPUT statement is to LOCATE it in a } > } disk file, and work on it from there. } > } } > } LET stringvar = blobvar[1,20] } > } } > I have a C function that will do this if anyone is interested. } > } } I am. } Here 'tis... this syntax is: LET charvar = blob_to_char(blobvar, nbr_bytes) Here --------- Snip Here --------- Snip Here --------- Snip Here --------- Snip #!/bin/sh # This is a shell archive (produced by shar 3.50) # To extract the files from this archive, save it to a file, remove # everything above the "!/bin/sh" line above, and type "sh file_name". # # Made 03/11/1994 12:52 EST by dave@das13.snide.com # # Existing files will NOT be overwritten unless -c is specified # # This shar contains: # length mode name # ------ ---------- ------------------------------------------ # 25265 -r--r--r-- COPYING.LIB # 1297 -rw-r--r-- blob_to_char.c # # ============= COPYING.LIB ============== if test -f 'COPYING.LIB' -a X"$1" != X"-c"; then echo 'x - skipping COPYING.LIB (File already exists)' else echo 'x - extracting COPYING.LIB (Gzipped)' sed 's/^X//' << 'SHAR_EOF' | uudecode && begin 600 _shar_cmp_.tmp M'XL(`+VO@"T``Y5=;7,;N9'^O*C[$3A]L51%<V,GV=RN4UM%2[3-1)842K+C MNKJJ&W)`<N+A#'=>Q.7]^NNGNX'!\\$5VMC99DYP!&HU^>?H%\\`\\_6/O^YM%> M3]Y.1],O]OWX9CP=7=N[Q[?7DTOZ^G)\\<S\\V/]!C_,\\G5]596=C7`_NWMG#V MU<\\_OS+&7I:;794M5XT]O[S@+^V[RCE[7RZ:;5(Y^ZYLBS1IZ-6!G13SH;%' M_OGI+W^V'Y.ZMJ,G-["7R7I69>F2_OAQ9/_P^M4??Q[8Q_N1L>,G5^U*FCVK M[<95ZZQI7&J;TLZ)#)L4J4VSNJFR6=LX2\\_.:.(U?LQ<;6RYL,V*WLRSN2MJ M9]-RWJY=T0PL/6_GJZ189L729@V&+\\K&)GE>;ETZ-.:_'_`B_=NLG%UD5=W8 MRN4NJ6GZ)^4,#^]H]%F55#O[_NYZ:.T$@QE;M.N9J^CAUW;FYDE+L],TR]+5 M=ILUJS#&:S]*6:59X8?Y'T/[P!MQ5SEB3NZ(\\_:!)^.EU'915G9=$EFU9SS^ ME[HZ6Q;"HB;Y2E]NDYW=E6UE%K1+:;G&+_6*GR?N,0]`&E'^=D>,*YHJJ8E! M(`G2\\MX5KDIR>]?.:&IS[:?'`%G1N"*5R99M4B7TV?%D]IG)F)!`]<N7],@: ME-8M/89IPX*(^_PLEDH[0U36EAA9U4/A1K>S0N^UWX@>S?;:/Y-L-CG)!1-5 MKIVI-VZ>T<`[95L"V3HES(&L`:^%QDB*G2EIWDHE`$-O5R7M=-(VJ[*J:=AY MECH\\*_M/3/Y2MG:>%/H%EF:886$(6DI9\\@(_KUQAM\\2/C4N^0DQZC!O@)Y!8 MN86K*L@QS:-\\'T":S::BE=.<MS3^<9[4!T(3;T728#/-*GF2C8DV-=(Z4;8# M^NRY;GFUY!TTK(FT>T\\TM<T6&)I4H5Y=#,)4M):YRYXP2%O-,70*Q6"&+1TI M5F/\\BR1K]#%Z%<^H-/>$B%X'KXG&N5")00I;N*W0NZG*996LZS>RK7ZXKT6Y M#>.F)<:L,3+Q6<6OQ*N-FS<B\\6P3:]Z5PD6\\K!PX-8<(U3(\\,6.6I8;$!X8- MS'0%ZZA.(B.!<`A9_55^*K$K%?2MX@7*4T/S(._T9B%-K'.29C:4KFH26C`] ML:$?LUF69TVF!@0C9PM(X/$=C<S;``0I]]=EFBUV$&APXAW]X'Y/UIN<A%*? M^/9HVY5CW2'F-V0P:0Q6<[MP-`I/TI)Q6V8J>R09&8U3$&-@"CH."$^)ZTL2 M4ZQ$E8Q?WY-F>FO'^C4(DA9)EX@-!,]`\\&#+93%Y5GPERE12Q'[WUA+(I4>> M2./I?7"#%E_._@4)662YV)V]I=1E1QC303X&D]'GM3F<)UDTQ#%:%+1=A#V, MZKT0I)AF(`)HHXNE8:LSHB\\#D?6*1!LS>*$FOZJD$!4L^/2GK`HB9L2$K&G# MRA0;J8(/*B+9MZN$J-F2H#9N4_]BSU]=L)OF7TU_(43/^>L+&HMLEXI^Y*>W MJVR^XKVO90/<,LD-^_^:O:8"@$$L9S3FC^P363:CZ7@!H[RF78>(N83&#N^5 MU8LZK`>0A22)C8O77]4?P_OD/!QIH8=U0W/680?%8Q4EO5_!%^YX.EX8+(WQ MY+!<Q5M&#S#5&9F-V8Y]$^9P>2U^<T-`B7X2ZHR:OCJ6(R)6]PVZ$"2*+;=" M&\\$8&0$>8J6BCT$00#)&X`(!#1(%\\NM5F;9S(8=='%`+J1T&(G^30Z;+PL1C M>J?W@A[8M`W[3)*=_X"!P.\\Y;_NN9W0%7Q'"(1Q!DQ'Z`$L;<LC,!K'@9H.? M20[)(SKV&&P7G\\HLY46E4(-*E@&Q3PJ8F[#!$%)F?_`(O)*L2#-2U9;=?SEC M$RD3!8@%Y]*"&]:1F,Y)A&%7:4_7[&Q7T3**AKT!.5S78$?]7$/U$R0W$"D2 MA8$A`>-]62<I0X`YH<HJV@4A@C5U%O!>*J*KXO>B%A`%QT9?8U?"<PFC6);Y MCX"'`'$=9LB*>=ZFH!]2%J,.VHIY^<20=;;K(5)SB`,[3"6JNDWJ#D6`4N([ MN9E=\\*Y#P6NFA]<X&OE^S.8U,0)K@?YA'P]B-;^U&5D%4BLR,>#HHBK7_741 M)]^`Q^(@2A+<).5@H+"+-L_%3*5E\\8)86M<4.81=8AR`YSAT8#VH$_H]87'I MP7FE:.@!/$U2EXSK6`H2@D0;@LY$ZD:6[I<`-O8W2=0E85M**I*W@@0@ZK2O M#%*W$`H1:K9>,]=L'<%(L8H@&DXV314N)L:+,)9:9^2U=C2`!$7$TVMR1OBP MY_R2R(W3Y[)M3`BF>G8^8W[P*FI>5&^*`Y=`K$S(5)3+LN4=K]JBD.GWY(E7 M`<F8"S;7KXGB#Q2_D11#TDU"KNWWIH5MHL'9B0@9`YVZ^$HRY'YW<[)79/I` M;@(;,LL@Q]NR^DITD;Q5V1/-`[2PZ-G1/O7]*.ZH/),)(6-70VQ(5.IVOF*Y M>*L1HH]7L;50Q&AG!Q'/]B<Q_4E8<CJA2<E.PD*($:-5Y,S&-;F\\SL8B2*/A M!R%8Y=`R)5;FY0;FWX_2UB[:-]&\\SP`\\;%A<ZN$8"5\\%@YYF@DG7G#((\\\\IT M$$]"'\\R#L'%MX<$L*[@(('&F*(N7/<1.&]3FQ"1'9E=0HN'H4-B(."P\\2=\\` M-<Z(7XLL,@42L9"S:CU`-1WC`)%JES]UUN5Y8R72'D)BP2L])AY=A4:'_&5D MC\\FP4M1/KH-#)H^T?`B60%*Q6HP).>J-%\\5!$?*0-<&`<>P^+ZM-6;$9%9L% M]3G_K'8)>UW#<C!8)$LQ7V6T$(GB$H"/95(1^/$HE(98D?DD@ACK2H8E&#EY M.56YUW=-]"Y(3>:LJXNVT#A&M4VY/KP0`[HB7GI+R.IBV*'G,-Z(@),:(%FY MCFQ/"$T[F?7&>`,,%2`P!ZR=R$*-@#)9+SH\\0>:&'C2"V-3^+$HDCHA_=PGA M^)QS``W\\N()5,=/BB>:=54[,&8R,G26"[V*+>,;D)%:>X,6VM4AE>(3ETAE` M$M$V^,=:PF:V6O#&7M:CR(MV2+X"D21"1;XSF`;"LY2P;#_X8);=0'>9%$F9 M;4J"XS"<$KIY/$L+GKG3:.*X\\I`DK@3&%?(*L@62H"$"'9#D#]^7P;3$E?'T MX[T=W5S9R]N;J\\G#Y/;FWKZ[G=+'NR^3F_<#>S6Y?YA.WC[B)W[PX^W5Y-WD M<H0OL-8_#+W."WVC)8D0BU,$20#8`J[TRV=(9,)N)-`EY#PV>3+O^!$B(Q+H M''I#+)1LD@#I[/]<2M"W(J=7)SM-4ZY)O&8NBGI2B41X1!%B[T-4:TZQ^SRA M@(A"SCRG,<Z::*5G%R168P1)BD0<^^4T)5/$`+.V9V2+SB2LLF=!7M<N*<2! MYKE$4VR</'LZO=9(+4T:X`_`'QJV1JXCB$Y!@!FA3;[S;EJ`QZ'/K\\VY8%`8 M448:P?SW9N3I+MA"D+I$7K^S!F?*LS.X0=+G@>36NIV&G3W8;EH)=,<(%8B! M9]#MHWOD3<V0.7>@^^:ZSTN7J4YTN4TH6K&S$2;A47@&T\\E4GFQ_44V5?&<" MD"+/JF1Z-!&/;,@C^(U#=DT)"(GU4@U#;/S"?H:T4VIHZ0GH(%83KU+:10Z1 MDD+SI63WVV2)\\.C\\`QD),@S(;`S"$""!A"[SH$)1)O&</*K^7`2AMV<Q/6?# M"VSHV7V70SQ3`\\7+%]9*^,:I4PE9UM[=\\$-(6&J>I;]66@4CXW>QQ1O8D/") M,Y<\\D_'IJO@7G]&FL5MDAA`&JKT8D)UH:]YD"CI*LG]@*'!%M2#[03N_H+T3 MKR.>EI_G&>95MI$<N=9($,CG5I)!O`##,!MA=JYL[N?E1*D!$R5)6'9&^:0K M['&(P062SSWSWUF7-Y*9X,QLV]09Q\\!DZ6ET)^X,.("H,AWX]Z"_0\\#77>9$ M4A(>,`H2IY$WK<`\\PTJ;Q!D'3QG<'O*5F!^LXDP*YR"RAA-*ME-0H\\[93WR> MD<)M`/4$7^"W@.`C^H@?R#?F+%#;*FO$D,/$?M8$:-#2JL7N8M`:]L"G<<)@ M:>EJWK_PBU]4'QW$SZ/Z1O^^&DI.%.CDVX6SO56\\J,U1\\4[J7LX>]@+K)<%= MNS1KUP.?#I6@@+/,8.\\FF[<4X.5"!IET3IR0F",P@9>J5U@_Y^F46A,]%7E. M=:RZFGF>9&M!Q#X#]\\9^=6X#XT-"%3117E,$R39`,%KD[;7$P[!T5C-H0PQ1 M$$X*0^\\Q,1%B._^K(^4E;;F'4]["LYZ%+9$B">>^-6=(>[O:U:13N:J#F$9? MZ9&Y!BP-.QTET4)$N5&]QKI"*K)+<7)"ZW<-$=@0&9I7,G6O.SG1/"H/*0NK MCHN'=TGJ.HRZ#LZ=^619K$JVKTH#A=TBE29B*&MNW_JJKST&>NYU=:],,BM1 M5.X)'W.)(<_:.<Z0Z2IJ%T'^7PP7JPDFP`Z%G*RX#23DR%2X?`&(DAP`@:&\\ M/+OHR@\\22DL%&68^C`CC3#LC@7A6P(BH4/(8B$C%U/GB%N]6&@WE$PXI-$)$ M4Y]2.N9'Z=@2V'0]3R>(*TX?%J4,(%()M\\UZDU7(1%?L%DZ#SB[996UZ@4PW MB74RE^R-^NS`!B]!$<P*H$WP"(:1W`Q-`02G]-8M@W!V+^2;CN#"SBC*(."< MTC&(W1HB:7BM)7<&^%S[%K77^!T>A`/\\I_(K_$R#)W:]0E-BEV5)8"*!LKL% M"3^7$8@CO@(UD&%D:$D*[U$/HRW!-U:HF#/B2<>108\\^DAE$P<@SD$34HE7T M`1I8L\\=`=H4W$,Z5R2!WMVFK3<GUPS4'*X`L)'F+-M<]/.]5]Z+M8=<617QP M$:RUO[5<E2Y+J0B)1H6)O+=#;%S!XF]=GK]D4,.)B'VO*J]W#!*,0`)3(IU] MWY)Q%GI>H^SU6TN#^BQ'L=M_^640FUC*1+X8-'FP$G[&YHI:.S6L2?X+0`-[ MAF?V+=,>"F$'#P&6]$?633O&.H!87]KE5:VE]LF#JV?J&RA.";%^<X7)9.`B M_<ZK4RZIIB)#QZ\\(5CO,%7C;S`X&=<F93US3:-PF`N16[>T8YY!]-EOR"5PX M\\VDT59K84FC>%R4L&)(!2NW<B-.MDZ3&!/*W7NLB/\\&E3*13>U.CH04I*'W! M]%^0='T8EMY6S?`\\U,(&9X1/PL!!R+\\'/.Q-*X_ABSAET;.5IL\\!Z1GIJIN2 M>?*=)1*"D\\+\\CLRB;KT1]9%I?/99<N8,F_`%%XMD69)P([?!^T\\OV2W@@.$" M_@.].(AZH$`IIS&;8-:]CD'-`;*B%@4&SG5CXCHP/<8L`]ZE<3I=GS&>>*.Y MGD$