SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-63
CREATE PROCEDURE Statement
INOUT
specifies a parameter that passes data to and accepts data from an
SPJ.
OUT
specifies a parameter that accepts data from an SPJ.
sql-identifier
specifies an SQL identifier that describes the parameter. For more
information, see Identifiers on page 6-53.
sql-datatype
specifies an SQL data type that corresponds to the Java parameter of the
SPJ method. sql-datatype can be:
SQL/MX Data Type Maps to Java Data Type...
CHAR[ACTER]*
CHAR[ACTER] VARYING *
VARCHAR*
PIC[TURE] X *
NCHAR
NCHAR VARYING
NATIONAL CHAR[ACTER]
NATIONAL CHAR[ACTER]
VARYING
java.lang.String
DATE java.sql.Date
TIME java.sql.Time
TIMESTAMP java.sql.Timestamp
NUMERIC **
DEC[IMAL]**
PIC[TURE] S9
java.math.BigDecimal
SMALLINT** short
INT[EGER]** int (or java.lang.Integer if
specified)***
LARGEINT long (or java.lang.Long if
specified)***
* The character set for character string data types can be ISO88591 or UCS2.
** Numeric data types can be only SIGNED, which is the default in NonStop SQL/MX.
*** By default, the SQL/MX data type maps to a Java primitive data type. The SQL/MX
data type maps to a Java wrapper class only if you specify the wrapper class in the
Java signature of the EXTERNAL NAME clause.
Ext
Ext