All Questions
6 questions
0
votes
1
answer
692
views
How to handle an array in a stored procedure on DB2?
I'm developing an app which store data in DB2, and I should be able to 'delete' data in bulk in a table of a DB. Actually the way to 'delete' the data is by changing its 'deleted' value to 'Y'.
The ...
0
votes
1
answer
1k
views
Call DB2 stored proc with array parameter using ibm_db_dbi in Python
Is it possible to call a stored proc with ibm_db or ibm_db_dbi in python and pass array variables as parameters?
arr1 = ['a','b','c']
arr2 = ['x','y','z']
test = curDB2.callproc('subsystem....
0
votes
1
answer
944
views
Creating a stored procedure with ARRAY input argument in AS400
I'm currently working on an AS400 machine to create a stored procedure which accepts a string array as an input argument. My code is as follow:
CREATE TYPE stringArray as VARCHAR(100) array[100]
...
- 883
0
votes
1
answer
1k
views
How to access a Row Type within an Array Type in DB2 SQL PL
I have a java front end that has a table of data. We need to save this data to the Database via stored procedure. If the passed parameter is a just an array, I am able to access the contents easily. ...
- 3
0
votes
1
answer
3k
views
Unable to pass array to a Stored Procedure in DB2 - SQL PL - Windows
I am unable to call a stored procedure which has an input parameter as an integer array.
The stored procedure declaration is as follows
CREATE OR REPLACE PROCEDURE TESTSCHEMA.TESTARRAY
(...
- 3
0
votes
1
answer
2k
views
Create table from Array in DB2
I need to get a script running that creates tables from an array of numbers I get from a select statement.
Here is what I got so far, however it is not working for some reason and normal PL SQL is ...
- 323