Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Arrays in DB2?
- Thread starter julen
- Start date
Julen,
Like Dan, I believe that SQL does not provide the functionality of an array. The only way that I can see to do this would be to write an SQL procedure in a language that does support arrays and call it from SQL. Be aware though that you cannot pass an array to a stored procedure and if you wanted to do this you would have to pass the array as a varchar and parse it correctly from within the stored proc.
Hope this helps,
Marc
Like Dan, I believe that SQL does not provide the functionality of an array. The only way that I can see to do this would be to write an SQL procedure in a language that does support arrays and call it from SQL. Be aware though that you cannot pass an array to a stored procedure and if you wanted to do this you would have to pass the array as a varchar and parse it correctly from within the stored proc.
Hope this helps,
Marc
Truusvlugindewind
Programmer
Well, DB2 supports multi-row fetch. This means that the result of your query is brought to the client/host language as an array.
sathyarams
IS-IT--Management
An alternate to parsing the input string in a stored proc (MarcLodge's post) is to use Declared Global temp tables
there may be other options depending on what your exact need is
Sathyaram
For db2 resoruces visit More DB2 questions answered at &
there may be other options depending on what your exact need is
Sathyaram
For db2 resoruces visit More DB2 questions answered at &
- Status
Similar threads
- Locked
- Question