Skip to main content

Purpose of prefixed variables associated with cookie field

  • February 15, 2013
  • 0 replies
  • 0 views

Problem:

If a cookie (e.g. mycookie pic x(6)) is placed in a HTML page, Net Express's Form Designer will generate a copybook for the web application as follows:

        ...

             03 gmycookie.

                 05 pmycookie          pic x(5).

                 05 mycookie           pic x(06).

                 05 smycookie          pic xx.

             03 hmycookie redefines gmycookie pic x(13).

             03 mycookie-exp           pic x(32).

        ...

Resolution:

The "p" and "s" fields are generated for SQL date/time columns. These are used to wrap the actual data in ODBC escape sequences to ensure they are handled correctly by the server. The "h" field is used as the SQL host variable, allowing the data ODBC escape characters to be treated as a single pic x. The "g" field is there to provide a group which can be redefined by the "h" field.

Old KB# 6926