Host Variables
HP NonStop SQL/MP Programming Manual for C—429847-008
2-13
Date-Time and INTERVAL Data Types
When you use the INVOKE directive for a column with a scaled data type, the
C compiler generates a comment that shows the scale of the column. For example,
for
price
with data type NUMERIC (8,2), INVOKE generates the following:
long price; /* scale is 2 */
These examples use the
=parts
DEFINE to represent the PARTS table. The first
example inserts a new row with the value 98.34 in the PARTS.PRICE column after
storing the value in the host variable
host_var1
. The value is multiplied by 100 for
storing as a whole number.
host_var1 = 9835;
EXEC SQL INSERT INTO =parts (price)
VALUES ( SETSCALE (:host_var1, 2) ) ;
The next example updates the PARTS.PRICE column for a disk controller to 158.34.
The value is multiplied by 100 and stored in the host variable
host_var2
.
host_var2 = 15834;
EXEC SQL UPDATE =parts
SET price = SETSCALE (:host_var2, 2)
WHERE parts.partdesc = "disk controller" ;
The next example retrieves the value in the PARTS.PRICE column for a disk controller
and stores the value in the host variable
host_var3
. The value has a scale of 2.
EXEC SQL SELECT parts.price INTO SETSCALE ( :host_var3, 2 )
FROM =parts
WHERE parts.partdesc = "disk controller" ;
The next example retrieves the part description for the part with a price of 999.50. The
PARTS.PRICE value is stored in the host variable
host_var4
and passed to NonStop
SQL/MP in the search condition. The retrieved value is stored in the host variable
host_varstore
.
host_var4 = 99950;
EXEC SQL SELECT parts.partdesc INTO :host_varstore
FROM =parts
WHERE parts.price = SETSCALE (:host_var4,2);
Date-Time and INTERVAL Data Types
Table 2-3
describes the SQL/MP date-time and INTERVAL data types you can use for
host variables.
Table 2-3. Date-Time and INTERVAL Data Types
(page 1 of 2)
Data Type
Description
DATETIME
Represents a date and time from year to microsecond (logical subsets,
such as MONTH TO DAY, are allowed)
DATE
Represents a date and is a synonym for DATETIME YEAR TO DAY
Summary of Contents for NonStop SQL/MP
Page 4: ......
Page 14: ...Contents HP NonStop SQL MP Programming Manual for C 429847 008 x ...
Page 60: ...Host Variables HP NonStop SQL MP Programming Manual for C 429847 008 2 26 VARCHAR Data Type ...
Page 294: ...SQL MP Sample Database HP NonStop SQL MP Programming Manual for C 429847 008 A 6 ...