Application Development and DB2 (10)

Featured Discussions

DB2 LUW Platform - Replace LOAD statement with a cursor

Hello All, I have got an ETL stored procedure which performs the following steps and takes in the following input parameters: Input Paramet…

Started by Gaurav ChauhanLatest Reply

Discussions Replies Latest Activity

Db2 LUW 11.1 - GET_LINE procedure - NO_DATA_FOUND exception SQLSTATE

Hi there,I am testing this stored procedure using Db2 11.1 on Windows 10 64-bit.Informational tokens are "DB2 v11.1.4050.859", "s1911120100…

Started by Gagan Kakkar

1 Jan 6
Reply by Douglas J. Partch, Jr.

Export Data from DB2 5.0 Database from a Laptop

Dear All,    I've to Export Data out from DB2 5.0 Database from a Laptop. I've installed Toad for DB2 on that Laptop. Now going to Install…

Started by Rakesh

0 Oct 8, 2019

MSSQL linked server attaching to DB2 LUW

I am trying to create a linked server from MSSQL 2014  to DB2 11.1  I am able to create one linked server and get it to work with one DB. …

Started by Mike Jett

2 Sep 20, 2019
Reply by Mike Jett

QMF Governor

Hi, We are using QMF Governor to limit the QMF queries of users. We have configured correctly and it is working OK. We want to get statis…

Started by Maitena Gallastegi Ginea

0 May 15, 2019

Reorg with dicard records and dependent table

Hi guys, we deleted records from a parent table with reorg - discard and WHEN condition (V12)and hoped, the records in the dependent table…

Started by Sabine Weisenbach

0 Apr 2, 2019

MANASYS Jazz now supports DB2 for CICS and CICS Web Services

Adding to the Batch DB2 support previously available, with Build 191 MANASYS Jazz now supports DB2 for classical CICS and CICS Web Services…

Started by Robert Barnes

0 Mar 23, 2019

How to increase the DSSIZE of partition in PBG and PBR

Hello Everyone, Please can somebody tell me the correct procedure to do this activity like how to increase the DSSIZE of specific partiti…

Started by VINAYKUMAR KANATHALA

0 Feb 5, 2019

5 Benefits of Writing Research Papers

Often, students are asked to write a research paper in the college. But sometimes you have thought that why you are asked to write a resear…

Started by ashley gill

0 Oct 2, 2018

DB2 LUW Platform - Replace LOAD statement with a cursor

Hello All, I have got an ETL stored procedure which performs the following steps and takes in the following input parameters: Input Paramet…

Started by Gaurav Chauhan

1 Feb 14, 2018
Reply by Michael Hannan

SQL CODE -804 SQLSTATE 7002

I want to share one of mine recent experience on SQL -804 with SQLSTATE 7002. It a standalone COBOL/DB2 program with simple select from sin…

Started by ASHISH KUMAR SAHOO

0 Mar 24, 2017

RSS

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

Forum

z/OS DB2 V11 to V12 and CICS?

Started by Tom Burkholder in What's hot ? on Friday. 0 Replies

Hello DB2 users...I apologize in advance if this is not the place to post this question; however, I thought I would sign up and give it a try.  My background is with systems support and middleware (z/OS, MQ, WebSphere, distributed DB2 jdbc configs)…Continue

Db2 LUW 11.1 - GET_LINE procedure - NO_DATA_FOUND exception SQLSTATE

Started by Gagan Kakkar in Application Development and DB2. Last reply by Douglas J. Partch, Jr. Jan 6. 1 Reply

Hi there,I am testing this stored procedure using Db2 11.1 on Windows 10 64-bit.Informational tokens are "DB2 v11.1.4050.859", "s1911120100","DYN1911120100WIN64", and Fix Pack "5".For NO_DATA_FOUND exception I am getting SQLSTATE = 'ORANF' but in…Continue

Tags: modules, Built-in, LUW, Db2

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service