ascii char conversion

IDS 10.00.FC9 on HPUX B.11.23 (11iv2) Itanium server Just making sure I'm not overlooking something on IDS 10; there is no built in function in sql to convert between ascii and character, like ascii() & char()/chr(). You would have to write your own or use the ascii package on the iiug software repository. Do I got this correct? John

There is an ASCII() function but no equivalent of the Basic CHR() function, no. > select ascii('A') from systables where tabid = 1; (constant) 65 1 row(s) retrieved. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Aug 19, 2009 at 2:00 PM, John Adamski <adamski@graceland.edu> wrote: > IDS 10.00.FC9 on HPUX B.11.23 (11iv2) Itanium server > > Just making sure I'm not overlooking something on IDS 10; there is no built > in > function in sql to convert between ascii and character, like ascii() & > char()/chr(). > > You would have to write your own or use the ascii package on the iiug > software > repository. > > Do I got this correct? > > John > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0015173ff2e013fb77047182dba3