- Session, Special User Library, Row Collection, Current Application & Operation

Session Parameters

??;<session attribute key>

Session parameters are a more advanced parameter type and are only really used when doing custom programming.

Two question marks followed by a semi-colon “;” and a key name is the sequence used to indicate a Session parameter.

An example of a session parameter looks like this:

??;myParm

Using the above parameter as an example, WOW would look in the session for the key "myParm" and use the value

stored in the session for that particular key as the value for the parameter.

Special User Library Parameter

WOW supports the ability to store metadata in any number of user libraries or schema's.

The default is "PJUSERxx" where "xx" is the release id. You can specify the following to

use the current user library.

examples: "<library name>release_id"

WOW Release 6.5 example

PJUSER65

WOW Release 7.0 example

PJUSER70

example SQL:

SELECT * FROM PLANETJ_USR.SQLOPS

"PLANETJ_USR" will be replaced by the actual default user library at runtime.

"PLANETJ_SYS" can be used for the current WOW System library.

NOTE: Changing WOW System data can result in a corrupt environment which is not

covered by WOW Support agreements. It is recommended that this only be used for

read only purposes.

RowCollection Parameters

[Minimum Version: WOW 7.0]

RowCollection parameters are parameters which get their values from the current RowCollection

(1 or more Rows displayed by an operation). RowCollection parameters can be used to show

attributes of the current rowcollection in your operation results, such as in the operation title or

instructions. A RowCollection parameter typically is not for use in your SQL Statement, because

the RowCollection is created after the SQL is run. Below are the supported RowCollection

parameters:

• • ??!WOW_RC_SIZE - Substitutes in the number of rows currently displayed on the page.

  • ??!WOW_SQL - Substitutes in the SQL used to generate the results currently displayed.

    • Useful when debugging a problem with the operation.

For example, if an operation displays 10 rows of data and the title = "Data for ??!WOW_RC_SIZE Employees",

the title would look like:

Data for 10 Employees

Current Application & Operation Parameters

Current application and operation parameters which get their value from current application and operation id:

• ??!WOW_OP_ID - substitutes it’s value of current operation id

• ??!WOW_APP_ID - substitutes it’s value of current application id