SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-61
CREATE PROCEDURE Statement
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-52.
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)***
FLOAT double (or java.lang.Double
if specified)***
REAL float (or java.lang.Float if
specified)***
DOUBLE PRECISION double (or java.lang.Double
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