Text columns

text Data in text columns are represented by integer values. Before you can use these in your program you must convert them to characters in character variables. The subroutine strasc@"STRASC"  <"CALL STRASC(" <string>, <tuple> "("<pos>")", <len> ")" converts a text column at <tuple>"("pos")" of length <len> characters into a character string in <string>, type CHARACTER.

To move characters back into the tuple use the inverse subroutine asctxt@"ASCTXT"  <"CALL ASCTXT(" <tuple>"("<pos>")," <len>, <string> ")" which moves the characters in <string> into the tuple at <pos>, length <len>.