All Questions
11 questions
0
votes
2
answers
636
views
-567 Rebind Authorization error for Auth ID IBM Db2 native stored procedure
A user is unable to create a native stored procedure via IBM data studio and faces -567 rebind authorization error for a particular auth id say DBAXXYY.The schema name is also same as the authid
But I ...
0
votes
0
answers
283
views
Calling Package from Stored Procedure - Db2 z/OS
I´ve been trying to call a Package from a Stored Procedure, but I'm not able to.
I tried to create it as below:
CREATE PROCEDURE DGOWNDB.ZHG0002I
(IN col1 ...
- 373
0
votes
1
answer
451
views
DB2-12 (Z/OS) - Create Alias for Stored Procedure
it's possible to define an alias for a stored procedure (sql-native)?
In the documentation, reference is made only to: SEQUENCE and TABLES
1) CREATE PROCEDURE OWXXCOLL.STORED1()
2) CREATE ALIAS DB2C....
- 11
0
votes
1
answer
941
views
SQuirrel Call Stored Procedure
I am trying to call a DB2 stored procedure from Squirrel.
I can call the stored procedure successfully from the DB2 command line
processor.
CALL PIPPOOWN.PIPPO
('04','prov','0001','provprov')
I ...
- 11
1
vote
1
answer
383
views
ATOMIC INSERT in STORED PROCEDURE
I'm fairly new to stored procedure. I have to design a stored procedure for ATOMIC insert (Mass insert). I'm using COBOL program to call the stored procedure in DB2. I will store values in array and ...
- 81
0
votes
1
answer
429
views
How to get an array as output using rexx
I'm testing some functions of Db2 for z/OS, and right now I'm having troubles when I try to call a Stored Procedure through REXX.
Below is the code to create the Data Type that I need to return in my ...
- 373
1
vote
1
answer
78
views
Using only subset of updatable table fields in INSERT or UPDATE record stored procedure?
Consider simple commands:
INSERT INTO TABLE table_name (fldX) VALUES (valueX)
UPDATE table_name SET fldX = valueX WHERE table_id = ? AND version_id = ?
More often we insert or update only some of ...
- 19
0
votes
1
answer
86
views
Evaluating datetime register during trigger event
I was testing the following behaviour for datetime special register (stated here)
If the SQL statement in which a datetime special register is used is
in a user-defined function or stored ...
- 87
0
votes
1
answer
518
views
How to reflect changes made to a cobol DB2 stored procedure?
I'm getting a -805 when trying to run the changed stored procedure. The bind process that is done is: stop stored procedure, compile and bind stored proc, start stored procedure, refresh wlm area.
I ...
- 157
-1
votes
1
answer
1k
views
DB2 Z/OS native stored procedures, Restful WebService ,JSON
I am thinking to create a DB2 Z/OS native stored procedures that calls Restful service with JSON as interchangeable format. Is it possible to consume Restful/JSON ? If yes can you provide some ...
- 11
0
votes
1
answer
2k
views
How to invoke json_val function in db2 json?
I'm trying to index a particular value from stored DB2 nosql, for that I'm using json_val but I need to invoke UDF SYSTOOLS.BSON2JSON to the json_val and need to point the table from where I required ...
