All Questions
9 questions
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
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
0
votes
1
answer
1k
views
external stored procedure db2 on cobol
I would ask about calling external stored procedure on cobol z/os
This is my code , the stored procedure code
*----------------------------------------------------------------*
IDENTIFICATION ...
-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
4
answers
2k
views
Error while creating a simple DB2 sql procedure
I am trying to create a db2 procedure on DB2 z/OS 10.1.5. The code I am using is :
CREATE PROCEDURE WSDIWW16.CALCULATE_SALARY()
LANGUAGE SQL
BEGIN ATOMIC
update wsdiww16.emptable
set dailywage = ...
- 91
-1
votes
1
answer
3k
views
How to delete the millions of records from a db2 table
I am using DB2 9.7 for Z/oS. I have a table with 10+ million rows and I want to delete about 9 million rows. I have tried with below stored procedure, but without success.
CREATE PROCEDURE ...
- 320
0
votes
0
answers
582
views
Using NORMALIZE_STRING inside of a UDF --> "VARIABLE ... IS NOT DEFINED OR NOT USABLE"
I am trying to use NORMALIZE_STRING inside a stored function under DB2,:
CREATE FUNCTION foo(INSTR VARCHAR(4000) CCSID UNICODE)
RETURNS VARCHAR(4000) CCSID UNICODE
READS SQL DATA
...
- 12.3k
0
votes
1
answer
2k
views
DB2 Z/os Native SQL Procedures -- Updated
I'm implementing a DB2 Native SQL procedure. It's the first we've tried this in this shop. I've attached the code below. What this routine does is keep track of the number of new records added to a ...
- 1
0
votes
1
answer
3k
views
String literals not supported in stored procedure calls to DB2 for z/OS
I'm getting the error below when calling a simple SP from the Rational Application Developer Data Perspective when connecting to a DB2 DB instance running on z/OS. Also when calling from SQuirreL. ...
- 2,323