SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-63
CREATE PROCEDURE Statement
sql-identifier
specifies an SQL identifier that describes the parameter. For more
information, see Identifiers on page 6-54.
sql-datatype
specifies an SQL data type that corresponds to the Java parameter of the
SPJ method. sql-datatype can be:
For more information, see Data Types on page 6-16.
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.
This icon indicates an SQL data type that is an SQL/MX extension to
the ANSI standard. All other SQL data types in this table conform to
the ANSI standard.
Ext
Ext
Ext