Re: C UDR : Text to Char or reverse

So your example is useless, if you don't document this interface. I can't rely on the functionallity of this routines. Are there no other ways to access TEXT- or BYTE-Fields ? Sven "Madison Pruet" <mpruet@tx.rr.com> schrieb im Newsbeitrag news:458BF502.2050804@tx.rr.com... > Sven Radtke wrote: >> Hi Madison, >> >> >> great script .. >> >> >> i have compiled your project successfully. >> >> >> >> my Script : >> ------------------------ >> create table rtrt ( >> rt1 TEXT >> );>> >> load from rtrt.unl insert into rtrt;>> >> >> select checksum(rt1,0) from rtrt >> ------------------------ >> >> is getting the error : >> >> ------------------------ >> (expression) >> >> >> (U0001) - Illegal cmd passed to cdrcmd >> Error in line 10>> Near character position 33 >> ------------------------ >> >> >> I found that i am using ids10.0FC3 on this server. Do i need FC4 really >> to access TEXT-Fields ? (I am upgrading at the moment). >> >> >> I cant get any information about, what your are doing with "cdrcmd_4" and >> how it works. >> >> Do you have any more informations ? > > The document from the web site mentions that this only works in v10.00.xC4 > and above. We're not documenting the cdrcmd interfaces. >> >> >> >> >> >> >> >> >> >> >> "Madison Pruet" <mpruet@tx.rr.com> schrieb im Newsbeitrag >> news:458AA633.3060209@tx.rr.com... >>> news.hansenet.de wrote: >>>> Hi all, >>>> >>>> >>>> >>>> i implented some c-udr's in ids 10 successfully. >>>> >>>> The new request is to cast text-fields (simple large objetcs) and/or >>>> reverse. >>>> >>>> Main-problem is to cast TEXT-Field to the lvarchar-type. >>>> >>>> >>>> IBM-Doc and IDN says : you can't use text-fields in udr's but as >>>> arguments to routines you can. (this i need) >>>> >>>> IIUG-Archives gives only 1 example in ESQL/C (loc_t & Co.). Nothing in >>>> C which demonstrates handling with TEXT-Fields. >>>> >>>> CDI says : It works ! Write a C-UDR-Routine ! >>>> >>>> Google says : look at CDI, IIUG or IBM >>>> >>>> >>>> >>>> Question : Is there any stuff, wich shows this TEXT-Field-Handling in >>>> C-UDR ? Are there whole routines or examples ? >>>> >>>> >>> You might want to check out the entry in developer works which I entered >>> concerning the using of "cdr check". >>> >>> http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0604pruet/ >>> >>> I'm pretty sure that the routine for classicBlob_checksum is reading a >>> byte/text. You'll need to be on v.10, for this, however. >>> >>> >>>> >>>> regards >>>> >>>> Sven >>>> >>>> >>>> IDS 10FC5 Sol.5.9 64Bit >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>