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

• First SQL parameter:
— Name: empnum
— Direction: IN
— SQL Data Type: NUMERIC
◦ Precision: 4
◦ Scale: 0
— Java Data Type: java.math.BigDecimal
• Second SQL parameter:
— Name: suppname
— Direction: OUT
— SQL Data Type: CHARACTER
◦ Length: 18
◦ Varying: not selected
◦ Upshift: not selected
◦ Character set: ISO88591
— Java Data Type: java.lang.String[]
• Third SQL parameter:
— Name: address
— Direction: OUT
— SQL Data Type: CHARACTER
◦ Length: 22
◦ Varying: not selected
◦ Upshift: not selected
◦ Character set: ISO88591
— Java Data Type: java.lang.String[]
• Fourth SQL parameter:
— Name: city
— Direction: OUT
— SQL Data Type: CHARACTER
◦ Length: 14
◦ Varying: not selected
◦ Upshift: not selected
◦ Character set: ISO88591
— Java Data Type: java.lang.String[]
• Fifth SQL parameter:
— Name: state
— Direction: OUT
— SQL Data Type: CHARACTER
◦ Length: 12
◦ Varying: not selected
◦ Upshift: not selected
◦ Character set: ISO88591
— Java Data Type: java.lang.String[]
• Sixth SQL parameter:
— Name: zipcode
— Direction: OUT
— SQL Data Type: CHARACTER
◦ Length: 10
◦ Varying: not selected
◦ Upshift: not selected
◦ Character set: ISO88591
— Java Data Type: java.lang.String[]
Parameters:
• Dynamic result sets: 0
• Accesses Database: selected
Attributes:
Procedures in the INVENT Schema 95