The Proc-text-buffer is part of the schema holder, making this result set option independent of the foreign data source.

This technique:

  • Allows you to access result sets available through a pseudo table for which each row is a long character string
  • Requires you to parse each long string to access specific fields
  • Referencing Proc-text-buffer with the -q extension enables you to access the character-converted results in quoted text (" ") from a data source. That is, proc-text-buffer-q causes quoted values in the character string and retains embedded quotes within the character result.

You can also override the default behavior of proc-text-buffer so that it behaves like proc-text-buffer-q with the help of a connection time DataServer option PRGRS_QUOTE_PROCTEXT. For more information on the PRGRS_QUOTE_PROCTEXT (-Dsrv) option, see Setting the data-source result set retrieval option.