session

Syntax

session [parameter_name [parameter_value]]

Parameters

• parameter_name – the name of a session parameter with optional wildcards.
• parameter_value – the parameter value to set.

  Parameters

  Name	Description
  check_column_options	When set to true, DA server that checks each comparison's selected column options are legal for the columns types found in the database. If any illegal column options are found, a warning is issued. Applicable only to create job. Key columns must always use the literal option to compare column literal values. DA enforces this option for key columns. Valid values: true or false. Default value: true.
  max_rows	The maximum number of rows to show in the result. Valid values: 1 to 2147483647. Default: 100.
  show_duration	When set to true, the monitor job, show history, and show reconcile commands show a duration column in place of a finish time or an end time column. Valid values: true or false. Default: false.
  wildcard_ignore_case	Determines whether wildcard matching should be case-insensitive. Valid values: true or false. Default: false.

Examples

• Example 1 – shows the first three jobs:

  session max_rows 3
  go
  
  (1 row affected)
  
  show job
  go
  
  NAME    ACTIVE DESCRIPTION
  ------  ------ -----------
  a_job1  true
  a_job2  true
  a_job3  true
  
  [#101] Warning: showing the first 3 row(s) only.
  
  (0 rows affected)

• Example 2 – shows the first three jobs with names beginning with "m":

  session max_rows 3
  go
  
  (1 row affected)
  
  
  show job m*
  go
  
  NAME    ACTIVE DESCRIPTION
  ------  ------ -----------
  myjob1  true
  myjob2  true
  myjob3  true
  
  [#101] Warning: showing the first 3 row(s) only.
  
  (0 rows affected)