Filter
Top Products
Considerations
• In the Neoview Script interface, you must enter the command on one line. The command
does not require an SQL terminator.
• If you execute this command in a script file, it affects the session in which the script file runs.
You can specify this command in PRUN script files. However, running this command from
a PRUN script file does not affect the idle timeout value for the current session.
• To reset the default timeout value, enter this command:
SET IDLETIMEOUT 30
Examples
• This command sets the idle timeout value to four hours:
SQL>set idletimeout 240
• This command sets the idle timeout value to an infinite amount of time so that the session
never expires:
SQL>set idletimeout 0
• To reset the idle timeout to the default, enter this command:
SQL>set idletimeout 30
SQL>
For more information, see “Setting and Showing the Idle Timeout Value for the Session” (page 53).
SET MARKUP Command
The SET MARKUP command sets the markup format and controls how results are displayed by
Neoview Script.
Syntax
SET MARKUP [RAW|HTML|XML|CSV]
The supported options enable results to be displayed in XML, HTML, and CSV (Comma Separated
Values) format. The default format is RAW.
Considerations
In the Neoview Script interface, you must enter the command on one line.
Examples
• This SET MARKUP command specifies results be displayed in HTML:
SQL>set markup html
SQL>select c.custnum, c.custnum, ordernum, order_date
+>from customer c, orders o where c.custnum=o.custnum;
<TABLE>
<!--select c.custnum, c.custname,ordernum,order_date
from customer c, orders o where c.custnum=o.custnum;-->
<tr>
<th>CUSTNUM</th>
<th>CUSTNAME</th>
<th>ORDERNUM</th>
<th>ORDER_DATE</th>
</tr>
<tr>
<td>143</td>
104 Neoview Script Interface Commands