class TestIbmDb2 < Test::Unit::TestCase

  def test_048
    assert_expect do
      conn = DB2::connect database, username, password
      
      prepare_blob conn
      
      if !conn
       throw "Could not make a connection."
      end
      
      result = DB2::exec(conn, "SELECT picture, LENGTH(picture)
        FROM animal_pics
        WHERE name = 'Spook'")
      
      if !result
       throw "Could not execute SELECT statement."
      end
      
      row = DB2::fetch_array result
      
      if row
        print row[0]
      else
        print DB2::stmt_errormsg
      end
      next
    end
  end

end

__END__
PNG

   IHDR   j      g   PLTE     3  f       3  33 3f 3 3 3 f  f3 ff f f f   3 f      3 f ̙     3 f   3  3 33 f3 3 3 33 33333f3333333f 3f33ff3f3f3f3 333f3333 333f3̙333 333f333f  f 3f ff f f f3 f33f3ff3f3f3ff ff3ffffffffff f3ffffff f3fff̙fff f3fffff   3 f  ̙ 3 333f33̙3f f3ffff̙f 3f̙ 3f̙̙ 3f̙   3 f   3 333f333f f3fffff̙ ̙3̙f̙̙̙ 3f̙ 3f   3 f   3 333f333f f3fffff 3f 3f̙ 3f                                                                                                                        ez|    IDATxu|=ʒ,4B1PpĻsgt&r]c@4qHW\X#9GCng"" [ȬȬv\oﷁv/S}G׷Ͷiw~އǀ;O'hwِ,5⯳a.uoӓoxV Ǝ;ҭ>]bm>CoWX\;mW'+ocQ w;?}v>nEz!ҟ~؝njkG{x%bv0~	"w˯K5vqf bq-D[pgM3p[Z|:
SbHnt}MKck7}^=ny1{~AiGuЮ ^KVE˰ r.
ca~}8	irJՈ [XS ,Ue¦KxG ?FD6ӫ}}|]5vvQƌ^U+@}kP@; a
$<b\x%h i;%Ϯ-Ak:$pCU1}
pCAċ_zlŋn#BU.g bш<-\Ӊ-~sd'EE,G\1
pIQ1
UMV`C71ƃE0+ĺUI0*c;A`'XI`#!ftҥbw|Mfp[sQ\d(ZJaZ<1.C7cP_.fW߸;:E1nd`'üWw!%,>E%8G7Bfl7F0QV0U$dw\%eT^>vұÝy(X"n
mw`FEC|;r.#(o3sb]N˭[_pla'&0y!$Rb»ź=ąV]⫈oۭ!Rf
 {xyW_,`NnO\^fUD P.˲pVը+-@j h˗`$'9OFߔek)B<76KzV{׊^!\!.4vZ1d&beS($5+|l"TF`_u@`l !k<_Di3VC"³]-R2MUDЖHQTŸpϙ:S!pH/<Mא,_iL/@?)X
M>3*&	YKfln7D̗;:g2Jrrsզ
ӚȉY%kSŸ1:,<|Í+iի-օDW^CϵP.OhjvN<{{f|4sdM-Z啼h	ƃC\U8 PaKx74<aI%ޒnRYxI<20Ta,pS.ؕcsAyW Ҡ菗\MCQiAl)zHT2hPFHřL$@|KzC!hFs0./}V䞻eR+4\TK[W+ ~^]B&;ܥ%2y*%l%CbH葠
Sa(bY"l\6p;yJ;,rG	!2ȸ$"hlNZݣjG!)ro|e4]EU:չ#Eku!vbZ O`E]3]YWݮ_֫PZ񷻎EG;cZD燇nU!ci\CYvK	jXYQjtLU
 yp%[ v <Q{=;=Ϲi4w%iu]NX5UDy
ԵV	c+@%vKE}?`123p,E3#	oUfj
 ash~bjMVDXkqAӑWv]DJ̞,yB1Apż'.7#yug.4`Y{	?P5F˧:?-&u>PR/1X\R(I֬v)u6򄌨	kaԒbbc'kPh9=@ӱDs4[ bU5e1GVjcV2-U0z.`(vtmJRɌlOjI~gf:b/
uIR4@GCXJa_+D+)i7sO|KCWF:z%SCT8.$	W$&-bZcI].Q@%Д)܀[|[)qqr`<
 ^E[9 8*Ů[$$2^gos70_Kbʘ
ԅ@ސo<e^v*<L?e@W|99#3u6(W֊B{媴p[3W	VL6"gE'Z>@haf4wgw.|*#12#p i= ċ _?-,M-,8{v[![+08sXn1~+)@x?,~啦,3)ό 3^Gr#qm&b~L3zq6'cP^c@yt5ACYJȗ.]ѼOB+.,20 5ֺ1	`I-Tm_lFsA]^Q[!D쓜V)If<xԶEAdGҘE"v۳xuLn'H[:`3u4s'vϽ/ai-[kO;+wXylp;"hMEq@[[&LUSn1PL0ODA.+pE5Q.W&1oiY)f_|F&뒦,'L-\n%X w+RsoWUD1d/6dq(}%0
PIx\\(eTY;GnT(^R#?SyX0QbI>RXF1hlk"
OyJRkhSJKp9GL$bXZb;<ѬvaQl[qDX%)ۤ9jQ|EK/BQٹ*XHGL7i$dlQά
jrOa^,2Ÿd]&E!bnQynhqD"bKfҏ#\nj_%y+'wdH)tYW/Yp&+;	xINcE*5/u[^C  v< @biPeSA紕E]mL0q`xIXR©zUeA7&>|rË;G)|/#FP k& &]	6Pxeowle]-|VIộ4iv?s%s#a5Xq$9<l$V2<uq`򡅏c	Z&#3,쵃]Ta%D&|cC)kZ%\sy𒾟yRZU|a&7A6=g2FDJa1Ock	TxЊC
vE 42v4^Н>ۋ}j7ªU5!&Ã, @%Y(iuaת(#AnKH)+8ƪZ}ՈYBW1Q`im%+ªir/Da~A놈E*XJϖ̃5M$!Yfϥ$Niw&:,5jtxgIvY?W,x#ȅd`k>}yzkr4[`L)ɷʘt,?E%Wu.$ر7%O5KvUWրpZL+؛.#Teu8OHߠZfu17	g2[EvqyfZzmIIYLPLwƯ4ek/d,	N:'g+)~Im"ѧB҂4G*믬ѭf蚦^J#bJ5a3А
VDW+S1NhWqLN36"M?*B0b ^yC;VS0S/z"Iysoe)ftW뒝=HM{ȃPODe'e5B7j揝&
lmڥYЦpC"wDg&XhRK:c.H[_!3N :]I/~GljW@97:ŝc(8*jϼ,Y5MgC'blqLĖ`^hRiLff^)gܸ}"R
l)e:nP	~2fNsM\KΏ4K $bE?GPjfSsflf_pLML^ ae{S.IUVmR+A}4ia56.,<<X,8_hŔ`|STXϸh1%f]=(/RV&
N*m$mj}jPߴ SG
/ƛT]<I,sس҄Xy2v"=C=£D0blUZ_팦2+qeuմ==p|Zp3Yp[ê4sa/(X1.+L[؈9irBEgnyd!<s2dJt{Q
bsg9?u3fOphIeihm[3A֚DVEp9'R2wyZ>P-;WU}w6WT5*K0Ht.~'7\4O!٪0mKfu)>{fA-`FjojSUҢvs{*J:ur`*5ј}CS8iMh,\C<ixW'1G9ɴ֊bHR9dj!:aY"ܧ^;9,_.XW,!H++\Ze%,iv{quElXk9bՒ,DV1...4έꗲ+'ya2ib~$Sӽ0)ٌXI3{훫=_4ŭY6`MH_n!(9Y7M8K&`s&4"qYz.bq9W)ۊ,R/[68%U&0r['Z'|ݘnp&pZk>BIg扪fiZ\ӘiD1mFdE6vRmnݼ5-I^n/bAaꑶPVwa6-*0Cyctv/ۦ4nO]OX/=D;r*ÌdP5>U,e5.l慉(}(&w)Ajq~WӼ2KqVe^y;ϭK+8YO{]-M/$#%%(Y{jmV#	cYǛ ^&<=OT=,v[Jg`*ż$}X>2E.]edb
`RjA4PJ{Y
+21K-EG?o^Wq9Vna@y.z۰Si3}4!6	;[($=h::ieꪃ4Rs.BzNc9 jڗeYҖΐQX/\xʧ8ΒW>e3)OE!u=m	OGs:*V'&K&y)~&rB'epr*WjF)!ֵ	=qJH7
:5Ks!{AEk-qWmy.t8)Y4VNsKyu}Mj),Od+ļ0Uq140nSEC_(o:4=&"#Z){C-_f^2]*,T=npFERUS ɩu;}tUeOǩ +ZVXN*IGԮXW[j'n\=)G/QvL9.P~iKO9#y<tBN;l(AA^m lf&mlO@Q *̀<eK*"q3QL#_j܆s]TExV%<S0H6Cv@6}76=tZ*NIX%ӰeJi0_
2nsa϶.}ܐf3\ƿR-."EbJCk&Nt=)ZiK(?	}]27ł5rzn,J,tYEд[\"Z%$iݴn5` oH<!m1jy'qi<gA4>VRmwASg|fb,(m:8%-,eSR<}DL2܇@<TGYEm>vl߮q=VF꜀ib@n{bDh!>7 Kdq>pvpY7K{4a'u5zfvPvjnWmMunvdפNQ1Ks)!N"9=+|b۝)8.vV)ПfaH%&Mgzԩ4(|+Qj';1x62Zr^f{־[Gا3q|jJ+eO7fЉ~!֐en tCJ`<m!}@YBqCv^CS,SyX#83Y\XxƏ6ֹDs`3A#6Jf5LROQkYi>,IvBKέxUb~!j]gdqfG08UގI߀O.=%:>==%rgr)lEsK\fÍ<5ˣLMg(;2u!=û@g;?mBsnƠ!'EMjĿ4Oղ̊jyrI<V`X5Lu|JMS!XKflGB_+ǪFjm<COxWd3~2=sOLw**Hb3;B=t#:~=[|=~oqbaN	uTLL2
؎o?n[+7~wVkWUwEϣ<xܹڶDcnmڮ==k[կ=$ƽ%?e.i#w?mgeF{>?)ƹK~I3&PanA}@[XkZ;:=*_r]mO]{EVnis=% <;GgcwQ|1)Tχ2^2?$ykÞ^jkǶy F,=xz3@.A"f\=_al"ʟÔgtU?\?	cfmߴ~lKc?=uWzG*B/ f~kO,{^rI}CXT>rϰ|s˔V'۳jyM{o׷+l7orrR   IDATf8ToIjrp~Uu`^g~Oo[hK>g#o@T=%`j㺪Uj]g!"gO+A|_'C=[$ >}6ur^e
c4nn2xLo7{mx!D`!/\P-
|~6S2yn3J%/}bʷo_H}?~@4v8 Yd2-n>WkܚGUЊaҍ|?1{%'fGpK+EF`p#^wҶ3E5cXX^,BX[3|aծ_^-[
1;!3	(E$$3q{{qeV85~rlJ8vվhru=gi~L1fNY>xoǿr T#FtTyv6_6L5X)ppގ5M\dDbL,2:9etHUoo
>|~W[KQ0in!sI}_ad~V,0JzVQ{#)+'x۩Urc烌FW~`nX93ܠZW+grJD$QjkHr}]2` |Fu%?ilJgW%YOlԌ$jHG\|[^΍`Oֳ`D$roV]n6E^Tnj'\Z,a4y'8LFDμQ/Ii`+2z +T~EbckȉwԜ6NNke}+ywXsK";$JqWL1m@NoM c*0yS澃f8{]ʹf7#b`kP
ɵ#&)-',::U;;H*ocXrŶE 'S	}ǅ=P:XefT@itaL"{pbVpi}?(8Zu7њg&{3%{s	GPs/K}`}?yIWIʗ볼Z'1y:Y٫8;pѰpTO~B 7md4 *9bv    IENDB`
