Neoview Guide to Stored Procedures in Java (R2.5)

java.sql.PreparedStatement ps3 = conn.prepareStatement(s);
ps3.setString(1, onOrAfter);
detail[0] = ps3.executeQuery();
}
Creating the Procedure: ORDERSUMMARY
To create this procedure in the SALES schema, upload the Sales.jar file to the Neoview
platform, navigate to the SALES schema in HPDM, and then enter or select these values in the
Create Procedure dialog box of HPDM. For more information, see the HP Database Manager
(HPDM) User Guide.
ordersummaryName:
Sales.jar > Sales > orderSummaryCode:
• First SQL parameter:
— Name: on_or_after_date
— Direction: IN
— SQL Data Type: VARCHAR
◦ Length: 20
◦ Upshift: not selected
◦ Character set: ISO88591
— Java Data Type: java.lang.String
• Second SQL parameter:
— Name: num_orders
— Direction: OUT
— SQL Data Type: LARGEINT
— Java Data Type: long[]
Parameters:
• Dynamic result sets: 2
• Accesses Database: selected
Attributes:
Calling the Procedure: ORDERSUMMARY
To invoke the ORDERSUMMARY procedure in NCI:
SQL>call sales.ordersummary('01-01-2001', ?);
The ORDERSUMMARY procedure returns this information about the orders on or after the
specified date, 01–01–2001:
NUM_ORDERS
--------------------
13
ORDERNUM NUM_PARTS AMOUNT ORDER_DATE LAST_NAME
-------- -------------------- -------------------- ---------- --------------------
100210 4 19020.00 2003-04-10 HUGHES
100250 4 22625.00 2003-01-23 HUGHES
101220 4 45525.00 2003-07-21 SCHNABL
... ... ... ... ...
--- 13 row(s) selected.
ORDERNUM PARTNUM UNIT_PRICE QTY_ORDERED PARTDESC
-------- ------- ---------- ----------- ------------------
100210 244 3500.00 3 PC GOLD, 30 MB
100210 2001 1100.00 3 GRAPHIC PRINTER,M1
100210 2403 620.00 6 DAISY PRINTER,T2
... ... ... ... ...
--- 70 row(s) selected.
--- SQL operation complete.
82 Sample SPJs