User`s guide

ManualsBrandsSiemens ManualsComputer equipmentBS2000/OSD

Specifying the Search Path for SQL*Plus Command Files

3-4 Oracle Database User's Guide

You can also use the

EDIT

command to edit a SQL file by specifying the SQL file in the

EDIT

command. For example, if you enter the following command, then the editor

EDT is called to edit the

file. Note that you can omit the default file name

extension

.SQL

SQL> EDIT login[.SQL]

Refer to the SQL*Plus User's Guide and Reference for more details about the

SQL EDIT

command.

3.1.6 The SQL ASCII Function

The ASCII function takes a character (under BS2000/OSD, this will be an EBCDIC

character) and returns the numerical representation of that character in the given

character set. The ASCII function does not convert an EBCDIC character into its ASCII

equivalent. For example, the ASCII function returns the value 193 for the character A.

The inverse function is CHR, for example, CHR(193)='A'.

3.1.7 Spooling SQL*Plus Output

When using the SQL*Plus

SPOOL

command, SQL*Plus uses the default output-file

suffix,

.LST

When you issue a SPOOL OUT request, the program issues the BS2000

/PRINT

command:

/PRINT tempfile,ERASE

where

tempfile

is a temporary copy of the spool file. This routes the file to the central

printer. If you need to specify any

/PRINT

command options, such as character sets, or

routing to a remote printer, then do so by adding the following line to the

ORAENV

file:

PRINTPAR=options

Where

options

is any sequence of

/PRINT

command options (refer to the BS2000

OSD

manual, Benutzerkommandos (ISP-Format) for more information about these options).

The program then issues a

/PRINT

command, which includes these options.

3.1.8 Using SQL*Plus Symbols

The SQL symbol used for negation is the exclamation point (!). The use of exclamation

point is recommended when specifying "not equal," especially for applications that

may be run in different environments.

If no exclamation point is available on your keyboard, then you can use left and right

angle brackets (<>) for "not equal."

The SQL*Plus symbol used for concatenation is the vertical bar, "|" (X'4F'). For users

with German keyboards, any key that transmits a X'4F' (for example, "ö"), can be used.

3.2 Specifying the Search Path for SQL*Plus Command Files

When you use the following command, SQL*Plus searches for a file called

filename.SQL

under the current BS2000 user ID:

Note: The output generated by BS2000/OSD operating system

commands will not be spooled.