|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
|
|||
|
|||
|
Define Array Data Type In Stored Proc
Hi,
I'm trying to define a passing parm as ARRAY but could not get any luck. Please Help! Here is what I have: CREATE PROCEDURE NCSS_SEL_P100N ( IN p_startdate DATE, IN p_enddate DATE, IN p_user VARCHAR(32) ) LANGUAGE SQL RESULT SETS 1 P1: BEGIN ... ... END P1; And I'm trying to do: CREATE PROCEDURE NCSS_SEL_P100N ( IN p_startdate DATE, IN p_enddate DATE, IN p_user[100] VARCHAR(32) -- ???? WANT p_user an ARRAY but could Not find a way ????? ) LANGUAGE SQL RESULT SETS 1 P1: BEGIN ... ... END P1; |
![]() |
| Viewing: Dev Shed Forums > Databases > DB2 Development > Define Array Data Type In Stored Proc |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|