Stack Overflow
Stack Overflow

Questions tagged [db2-zos]

Use this tag for questions about DB2 for z/OS, the IBM mainframe operating system. Please also tag such questions with the more generic [db2] tag. There are enough differences between DB2 for z/OS and DB2 for other platforms to warrant a separate tag.

175 questions
-1
votes
1 answer

DB2 Z/OS - Rename Tablespace

I use DB2 Z/OS 11.01. It's possible to rename a tablespace already defined on DB2 z/OS? From the documentation I don't see any constraints but I can't. Below I show you my test case: I create a TS, a table and an index. -- CREATE TABLESPACE…
killer
  • 11
  • 6
-1
votes
1 answer

how to retrieve JSON data stored in CLOB Datatype in DB2?

I have JSON data stored in CLOB in DB2 database. I want to query this JSON data and retrieve some data . I tried with JSON_VAL and get this error DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=JSON_VAL. can anyone please let me know if I…
Raj anand
  • 1
  • 1
  • 1
-1
votes
2 answers

Is there any way in DB2 to find temp table from the session?

Is there any way in DB2 to find temp table from the session ? I have created a temp table pertaining to session DECLARE GLOBAL TEMPORARY TABLE SESSION.TEMP_TABLE_NAME ( COL_1 VARCHAR(11) NOT NULL, COL_2 VARCHAR(10) ) ON COMMIT…
user1993412
  • 802
  • 2
  • 15
  • 29
-1
votes
1 answer

oracle sql to db2 sql

I have to change an Oracle SQL DDL to use it in zOS/DB2. Now I'm stuck in this part: ... ATTRIBUTE1 char check (IS_FINISHED in (0,1)), ATTRIBUTE2 char check (HAS_ERROR in (0,1)),... I have never used a 'check' in oracle, neither in DB2. Can…
dandelion
  • 3
  • 2
-1
votes
1 answer

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 documentation or info. Thanks
VenkataK
  • 11
  • 2
-2
votes
1 answer

Alternative to IBM Data Studio

I use IBM Data Studio (4.1.3 and 4.1.4) to develop stored procedures (native) and functions on DB2 Z/OS (V12) and DB2 LUW. Unfortunately Data Studio is slow and keeps crashing. Do you know valid alternatives that can be used on both Z / OS and LUW…
killer
  • 11
  • 6
-2
votes
1 answer

Connect to db2 from java8

How to connect to db2 database from java8, I need to connect to db2 database from java8 as jdbc/odbc drivers has been deprecated, I tried using the ibm driver but still not able to connect. In the below bloc ive added the exception stack which I…
dean
  • 79
  • 1
  • 2
  • 9
-2
votes
1 answer

DB2 Z/OS V10 Mainframe : How to create jobs

Which language can I use in z/OS to create a job in DB2 Z/OS V10? In Z/OS Mainframe, please provide example script to create or SUBMIT a JOB which executes stored procedures.
Vivek Harry
  • 419
  • 3
  • 11
  • 25
-4
votes
1 answer

How to migrate DB2 z/OS data to MySQL?

As part of the data migration from DB2 z/OS (Mainframe) to Google cloud SQL, I don't see the direct service/connector provided by google or IBM. So, I am exploring the option to move the data to MySQL first and then to Cloud SQL. I could see the…
Sekhar
  • 627
  • 4
  • 14
  • 34
1 2 3
…
11
12