Call SP from a Cobol-Db2-Cics program

I have a Cobol-DB2-Cics program that Invokes a DB2 Stored procedure in cobol in another DB2 subsytem. I am getting a sqlcode - 471 on the SQL CALL SP statement.-471 INVOCATION OF FUNCTION OR PROCEDURE name FAILED DUE TO REASON rcCan anyone please throw some light on this issue ? This has become a sh ...

Error in buildserver for IBM COBOL - DB2 program with ATMI calls

Am using IBM COBOL for AIX version 5.3..I have installed Oracle Tuxedo 10g R3 on AIX and IBM DB2 V9.5 on AIX..I have written a sample Cobol-DB2 program with ATMI calls for client and server..I have precompiled the programs with the command..db2 prep COBDBCL.sqb bindfile target ibmcob CALL_RESOLUTION ...

How DCLGEN can be used to create Host variables in COBOL-DB2 program

A very good morning to the members. I am very new to DB2 and wanted to know how DCLGEN is used in COBOL-DB2 program.If anyone can explain with a reference program, kindly help. ...

DFHEIBLK in RDz 7.6 CICS COBOL program.

I'm using RDz 7.6. How can I get it to recognize DFHEIBLK in a COBOL program. I'm getting an "Unable to resolve reference to DFHEIBLK" in the LPex editor while working on a CICS COBOL program. According to the RDz 7.6 release notes ftp://public.dhe.ibm.com/common/ssi/sa/wh/n/ral14017usen/RAL14017USE ...

Systables 'obid' Z/os Cobol-db2 ??

We are running DB2 version 7, in Z/OS - and this question pertains to the COBOL-DB2 program I am writing.If I issue a particular SQL action against an unqualified DB2 table, does that table's 'OBID' (object identifier value located in SYSIBM.SYSTABLES) get generated and stored anywhere apart from SY ...

COBOL DB2 Stored procedures

I am quiet new to COBOL DB2 stored procedures and had a couple of questions on how it works...1. In a COBOL DB2 stored proc do we have to minimize the number of sql's within the program ? I'm asking this 'coz i've seen a couple of stored procs with huge sql's ( with more than 700 lines etc..).. will ...

Returning result set from COBOL/DB2 Stored Procedure to java

This is my first exercise in using DB2 stored procedures. I'm using good old COBOL... This is the scenario.Java client is calling my COBOL DB2 stored Procedure. I have to send back result set.This what I have so far...Stored procedure is in COBOL pgm ... WORKING STORAGE 01 SPO-MED-NAME PIC X(30). 01 ...

Cobol-DB2 SP using result set

I need your suggestion.Scenario: Calling a Cobol-DB2 ( V8) on z/OS Stored procedure from .NET application.The stored procedure using result set option.Hence, in the SP, I am opening the Cursor with-Return option. Now, the SP is called from .NET application. So, it will invoke the open cursor stateme ...

Migrating the cobol-db2 from Z/OS Subsystem to AIX

We had a batch cobol-db2 program running successfully in a Z/OS Mainframe environment, The new requirement is that we need to port this code on to a AIX box and execute it against a DB2 database there. On mainframe we did setup all the needed steps like Compile/Precompile/Bind as JCL job steps and e ...

Problem on creating sample database in DB2 - reg

From SOFTWARE WARRIORS'2010 we have got a problem on DB2 when trying to create the sample database i gave the command like in command windowE:\Program Files\IBM\SQLLIB\BIN>db2 create database mydb1SQL1092N "KAVI " does not have the authority to perform the requested command.and also we tried in " ...

Cobol DB2 Exit routine for Optim

I have worked on Cobol DB2 programs but am new to Optim.I want to use an exit routine to access a DB2 table .Could someone please help me understand what will be the process for it and How is it different from normal Cobol DB2 program?I will be using this Exit routine in one of the column maps . ...

Need some help creating a CICS/cobol web service

Hello, we are attmpting to use RDz to create a web service from a CICS/cobol program, but are having some trouble generating the web service. We are following the steps lined out in this document: http://download.boulder.ibm.com/ibmdl/pub/software/dw/rational/emz/Wrap_existing_COBOL_program_as_Web_S ...

Host-variables in SQL statement wrong in CICS-Cobol generation.....

I have a number of SQL statements that are generated wrong in CICS-Cobol. They all contain host variables in not-commenly used places like case statements and date/time conversions. One example is the one below. The host variable marker - the : - has been replaced by a set of "This example has been ...

Problems calling EGL (vs. 6.0.1) from CICS/COBOL

We have recently implemented a number of web service transactions. These are triggered by another application and execute a standard CICS COBOL program that runs in the CICS region under its own transaction. However, what is being proposed now is to expand this to call an EGL program and utilise the ...

Cobol DB2 Stored Proc Java as client

Anyone has example of stored proc written in COBOL/DB2 and Java as client. Also if you have step by step set up process. If you can guide me some place where i can get this also ok. Help is greatly appreciated. ...

S04E for COBOL/DB2 stored procedure

I am getting S04E message in WLM for one of my cobol/db2 stored procedure. Does anybody know what could be the reason? ...

Accesing from Z/OS (Cobol-DB2) to Oracle database (UNIX)

I have a doubt about connection between two systems.System1: Z/OS mainframe, Cobol/DB2.System2: AIX server, Oracle 9iIn system1 I need data from system2 (Oracle database). I need data from three tables (three sql’s) one of the table has 5 millions records, and my sql will ask for 1 million (aprox). ...

Fujitsu Cobol & DB2 personal edition

- my 1st post. I have been using the old Fuji Cobol V3 for several years and find it quite adequate for my purposes, all 'batch' programs nothing too fancy. Now I would like to access a DB2 database on my PC, create a cursor and do some further analysis on the retrieved rows. So - has anyone done th ...

DB2 10 LUW

Does anybody know if and when shall DB2 10 for LUW be GA ?Thanks in advance, BRGDS,Raul Baron ...

Sessions at IOD Conference related to temporal support in DB2 10 for z/OS

IBM's 2010 Information on Demand conference starts next week and one of the sessions will be presented by two of our key software engineers for temporal support in DB2 10 for z/OS, Jerry Mukai and Anil Varkhedi. It is session 3015 - Health and Life Insurance Management with IBM DB2 10 for z/OS Bitem ...

Is COBOL or RPG program is faster than SQL program on iSeries platform ?

I heard from IBM local partner said thet the performance of COBOL or RPG program is better than SQL prrgram, because COLBOL or RPG is the native language on iSeries. And is it true ? ...

COBOL DB2 stored procedure using federated tables

Using asp.net 2.0 to exec; my COBOL DB2 stored procedure using federated tables does not bring back the DB2 column headings/schema field names. Dynamic SQL using identical sql does bring back the DB2 column headings. Does anyone know how to return column headings using a COBOL DB2 stored procedure w ...

Passing an Array from Java to a COBOL DB2 Stored Procedure

I have a Java application that needs to call the COBOL DB2 Stored Procedure. I am trying to figure out if I can send an Array or a Struct to the COBOL DB2 Stored procedure, so I don't have to call the stored procedure a number of times.In the past I was able to achieve a similar functionality using ...

Accesing a Oracle database (UNIX) from Z/OS (Cobol-DB2)

I have a doubt about connection between two systems.System1: Z/OS mainframe, Cobol/DB2.System2: AIX server, Oracle 9iIn system1 I need data from system2 (Oracle database). I need data from three tables (three sql’s) one of the table has 5 millions records, and my sql will ask for 1 million (aprox). ...

Does Z Optim support DB2 10?

Looking for any documentation or release notes that mentions that Optim supports DB2 10 on Z. ...

Is Rational COBOL Runtime required for connection between WAS/EGL and native CICS/COBOL ?

One client is evaluating RBD v7.1 to re-develop its 3270 UI client programs into JSF/EGL web applications running on WAS to call its existing native CICS/COBOL programs. In this scenario, do we need to install Rational COBOL Runtime for z/OS ? L.H. Chao IBM Taiwan ...

Accesing a Oracle database (UNIX) from Z/OS (Cobol-DB2)

I have a doubt about connection between two systems.System1: Z/OS mainframe, Cobol/DB2.System2: UNIX server, Oracle 9iIn system1 I need data from system2 (Oracle database). I need data from three tables (three sql’s) one of the table has 5 millions records, and my sql will ask for 1 million (aprox ...

Accesing a Oracle database (UNIX) from Z/OS (Cobol-DB2)

I have a doubt about connection between two systems.System1: Z/OS mainframe, Cobol/DB2.System2: AIX server, Oracle 9iIn system1 I need data from system2 (Oracle database). I need data from three tables (three sql’s) one of the table has 5 millions records, and my sql will ask for 1 million (aprox) ...

Receving 878-10 errors on cobol generated DS program doing joins

Hi, I have a team that has utilized datastage to generate COBOL programs on z/OS. During unit test (with 10 records), program runs fine. However, moved to system test & with anything above that (from 551 to 6000), we are getting the 878-10 message, even with REGION=0M coded in the step. We are d ...

AIX Cobol + DB2+ CICS

Is anyone using IBM Cobol with DB2 on AIX? If you're using CICS too, that would be even better!I'm interested to discuss the sequence required to get a good compile run. ie. Do you need to run the DB2 precompiler (DB2 prep ....) and/or use -qSQL for the compile statement (cob2 ....)?I'm using Cobol ...

Designing a CICS COBOL Program as both a call-able subroutine and Web Service

From Dennis Weiand - CICS/Web Services L2 Support <hr /> The person asks, "Can you call a COBOL CICS program that is the target for a CICS service just like any other COBOL CICS program? I want to be able to use a CICS Service from another one and I figured I should be able to simply call the ...

CICS/COBOL Handle hard io errors problem again?

CICS TUI environment, RBD is 7.5.1.5 with up to date cobol runtime. All CICS user transactions are installed as threadsafe (thank you Mark Evans). Before 9 months APAR PK97784 solved problems with handlehardioerrors=no for programs that didn't abend on that kind of errors. Now we are facing the simi ...

Need sample Enterprise COBOL Program to implement multithreading(z/OS)

I am trying implement multithreading using Entreprise COBOL on z/OS. When i searched in the net ,i am able to get sample multithreading prgm on COBOL for AIX and system i. But these examples are not compatible with Enterprise COBOl on z/OS . Kindly help me out to get a sample multi threading prgm fo ...

Using The Include Statement In Z/os Cobol-db2 ??

I have 1400 lines of COBOL code that contains embedded SQL statements.The code needs to be re-used in at least two programs, and I therefore made it into a procedural copybook.Because of the embedded SQL, a basic COPY statement would not compile, so I had to use the INCLUDE statement to get it to co ...

Returning values from Cobol DB2 Stored Procedure

I have a program running on Windows NT calling a Stotred Procedure written in Cobol running on z/OS 1.2 with DB2 7.1I cannot get the Cobol stored procedure to return any values. The equivalent C program does return values...The DISPLAY staements show up okay in the WLM app env JES output. CREATE PRO ...

Unicode / EBCDIC conversions on Java w CICS, MQ, DB2

I am designing a Java program to run as a CICS transaction in an OS/390 USS environment. It receives XML UTF-8 input via MQ series, parses the XML (using the XML Toolkit's DOM parser, or maybe DB2 XML Extender, Collections?), and applies the data to DB2. The database and its tables were created with ...

How to invoke CICS transaction from VB program?

G’day,I need to have a VB application running on Windows 95 invoke a CICS transaction on a mainframe. I have a DB2Connect installed on my system that lets my VB program talk to the DB2, but I am wondering what is required on my PC to enable communication between a Windows application and a CICS tra ...

CICS (Cobol) How to use DFHLS2WS to generate more than one operation in Wbs

I have a question concerning the usage of DFHLS2WS on a CICS environment (COBOL language).I'm building a webservice provider simulator that will communicate witha requester. This requester originally connected to a remote Webserice which hadtwo operations, which this simulator will replace for testi ...

Sqlcode -973 sqlstate 57011 drda_heap_sz cobol-db2 error

all, i get the error written in the subject. I run, on a AIX platform, some cobol batches that go on a remote OS/390 Db2 v7, via Db2 connect v7.The problem arises obviously on AIX, in which runs the cobol batch, and the message, besides the error codes, tells the tokens:SQL ERROR MESSAGE DRDA_HEAP_S ...

OS/390 COBOL DB2 stored procedures

HiAre there any special rules and statements which have to be followed in cobol, if it is being used as a coding language in a DB2 stored procedure.If so, could anyone let me know the location of such rules. My emailid dnivara11@yahoo.com ...

DB2 userexit program

OS: NTDB: DB2 UDB V7 FP9When enabling userexit in db configuration we simply set it to ON but how does DB2 knows whats the name of the program or does it specifically look for a file with default name? My questions now:1. What is the default name of the file and2. If we can (change the userexit file ...

How to avoid Database contention in COBOL-DB2 Programs

I am getting a return code og -911 and -913 when two different batch application executing as IMS-DB2 program. I am commiting the DB after about 1000 transactions. Is there any way out of this problem.I could think of using the same IEFRDER file for both the applications. Is this a good practice? ...

help - errors compiling db2 userexit program

DB2 version 8.1 fixpak 4Redhat 8 LinuxI'm trying to compile a userexit program (db2uext2.c) and I get the following errors:db2uext2.c: In function `ArchiveFile':db2uext2.c:732: `offset_t' undeclared (first use in this function)db2uext2.c:732: (Each undeclared identifier is reported only oncedb2uext2 ...

COBOl DB2 connectivity on windows

I want to connect cobol with Db2 on windows .some helpful details are:COBOL compiler:Fujitsu 3.0(student version)DB2:Windows VersionOS:Windows XP professional with SP2Please provide me steps and some simple example to do this.-MS ...

DB2 abnormal program termination

I recently installed DB2 Data Warehouse Center Version 8.1 with Fixpak2onto a Windows 2000 server. I attempt to sign onto the Data WarehouseCenter and logon as "db2admin" and the correct password and I get thefollowing error: "Program =C:\PROGRA~1\IBM\SQLLIB\java\jdk\bin\javaw.exe, abnormalprogram t ...

Sample Code: J2ME & DB2 EveryPlace

I need a Java sample code (J2ME) to access data on Db2 EveryPlace (Palm Device). ...

Java Sample Code to Db2 EveryPlace

I need a Java sample code to access data in Db2 EveryPlace (Palm Device). ...

Sample C# or VB.NET program to access a table on Z/OS

I am trying to find a simple few line console program that can select some data from a DB2 table on Z/OS.Does anyone have one? ...

cobol/db2

new to this forum. i've downloaded ibm's db2 PE but it's java with embedded sql. anyone know where i can get the same type of product to teach myself cobol w/embedded sql on windows?i've searched the world over but not stumbled upon it as yet.in the meantime i'm learning java- might as well given th ...

Cognos Sample Data for DB2 Import Error SQL3006C I/O

I'm trying to restore the Sample Data to a DB2 Database and I'm receiving this error during the import, its the only table that gets it.* IMPORT: table "GOSALESDW"."SLS_SALES_ORDER_DIM" ***ERROR -3006. Check message file tab27.msg! *** SQLCODE: -3006 - SQLSTATE: *** SQL3006C An I ...