All Questions
7 questions
0
votes
0
answers
143
views
Stored procedure for writing back to db2 database
Im new to db2 stored procedure, im approaching here for some help/guidance.
I have users who access cognos for reporting.
Recently I got a requirement from one of our clients for writing back to the ...
- 43
-1
votes
1
answer
112
views
Convert Procedure from Oracle to DB2, Error when try to update table on runtime
Hello DB2 Experts I need your assistance in converting below Procedure to something more dynamic.
We have to update multiple sequences with max of id column for each table.
CREATE PROCEDURE mySchema....
0
votes
1
answer
2k
views
Error executing dynamic select query inside a stored procedure in IBM DB2
What is wrong with the below code? I am trying to execute a dynamic query inside a stored procedure in DB2. My procedure is getting created
CREATE PROCEDURE get_users( in offsetValue integer,
...
- 232
1
vote
0
answers
116
views
sql%bulk_exception implementation in db2
Basically i am trying to convert stored procedures written in oracle to DB2.
I have referred lot of sites and tried lot of migration tools like ibm dcw, sqllines, etc.
I am stuck in converting ...
- 21
0
votes
1
answer
1k
views
Overload stored procedure in DB2
I know, it is possible to overload PLSQL functions and procedures in ORACLE.
I tried to overload a procedure in DB2 but was throwing error. Does DB2 restrict this or am I doing something wrong.
Pro ...
- 422
0
votes
1
answer
1k
views
How to populate a single-dimension array with result of a query FOR DB2?
I need to populate a single-dimension array with a result set from a select query.
I have created the array type using:
create or replace type UR.array_traveler_id as BIGINT array[];
and in the ...
- 97
1
vote
1
answer
2k
views
How to call a DB2 stored procedure from C#?
I use DB2 9.7 for Linux. The stored procedure is implemented in PL/SQL (Oracle's programming language), so, the record set is an output parameter (SYS_REFCURSOR).
CREATE OR REPLACE PROCEDURE ...
- 155
