We have a concern on the CHECKSUM attribute in DB2 programming.This is an attribute in DB2 which is used to allow the applications to detect the changes made to the contents of a database or if the contents of the database have been corrupted.Can we use this to keep track of the changes done to the ...
I 'm working on Euro banknote validation, where I'm using authentication of the serial number of Euro banknotes by the calculation of the "checksum". Basically what this algorithm does is to replace the first letter of the serial number by a number (each letter represents where the banknot ...
We have just went to V6.1 of DB2 on OS/390 and would liketo use user-defined functions (UDF) but the examples providedby IBM are in C and C++. Would someone be willing to share a simple UDF that is Cobol?TIA ...
How to get the NEXTVAL of a Sequence in COBOL program. Please give me sample code. ...
everybody, i am installing ltsp 4-1-3 on my machine and i get the following error:"File /opt/ltsp/pkg_cache/ltsp-ltsptree-1.11-0-i386.tgz failed the checksum test"after the installer has downloaded packages from: http://ltsp.mirrors.tds.net/pub/ltsp/ltsp-4.1/ ...can anyone help me knowing ...
We created WLM stored procedures in Cobol in Db2 on MVS and compiled and promoted properly. After that we checked all the input and output parameters for the call still it is givindg the access I checked in SYSIBM.SYSpackages for the access it is granted. So some one told me that it is access issue ...
Please clarify whether AIX support Micro Focus COBOL ? If so, where can I find details like supported version etc ...
The problem we have is that we want to use the same COBOL code,locally for UDB v7(fix 9) and on mainframe for DB2 7.2(it works OK on mainframe) to fetch a result set from a target SQL procedure.ALLOCATE CURSORASSOCIATE LOCATORSQL TYPE IS RESULT-SET-LOCATORIs this not possible?/uffe ...
Any one have information about Converting Mainframe Cobol to AS400 Cobol ...
Can anyone tell me how a COBOL program on OS390 can access a SQL2000 database on Win2K platform? ...
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. ...
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 ...
I've downloaded the Linux9i*.gz files and found that I didn't need to unzip them and I cpio'd them fine.During the CPIO I got messages about skipping bits in the file. Does anyone know if that is OK? Disk 1,2,3 directories seemed to be created OK.I'm now having problems with getting the runInstaller ...
I work with one iseries model 830 with db2/400 database.We use delphi/400 program for enveronment clientserver aplications and we use cobol program for the batch application and in the some situations Stored Procedure.I've got a question about when do use stored procedure.When's better use Stored Pr ...
Is there any considerations to migrate MF (micro focus) cobols to IBM COBOL for AIX ? One of my customer uses MF cobol and he wants to migrate their applications to IBM. He uses IBM AIX 5.1 / MF COBOL server express 2.2 / Oracle 9204 / CICS 5.0. Any comments will be appreceiated. ...
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 ...
When I start my computer, I get an error stating CMOS checksum error. Press F1 to contine. But this happens only some times. WHat is the problem? ...
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 ...
I downloaded Fujitsu cobol but it is not working with SQL as I have a student version...I came to know that I can get a cobol compiler with sql if i buy a book "Db2 for Cobol Programmer"...Is there any other way, I can download free cobol compiler with features of sql? ...
Does anyone know how to refresh (update) a COBOL stored procedure without doing a DB2 restart?The database restart is required to update fenced stored procedures which are running as threads in the db2fmp processes.We are unable to get authority for the outage of a db2 restart. ...
As i am new to AIX please give me detailed information on how to compile and execute a db2 cobol program on AIX, Please dont give me the stuff which is there in AIX documents i need actual examples along with all the options available. ...
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 ...
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 ...
We currently have many stored procs written in cobol and residing on a vm system. They are successfully called from windows based clients. I am now attempting to migrate the db from vm to windows. I am compiling the stored procs on windows using IBM's VA Cobol and following all of the (sometimes con ...
what i'm trying to do is to implement a (very) high-level checksum for my TCP client app written in C...here's the data format for the packets i'm sending out from the client:packet1-1033452719-878475\what i want to do is to do a sum of the ASCII values of each indivual character (using ord())...so ...
We have a COBOL DB2 v7.x stored proc in mainframe DB2 that takes an input parameter and has four other out params. It also returns a cursor. It is called via a Java client via JDBC and DB2 Connect.CallableStatement cs = connDB2.prepareCall("{CALL XXXXX.CPSP0006(?,?,?,?,?)}");The problem is ...
Today I got a big problem: my query needed a varying-list select statement what requires the use of COBOL pointers.I've got all the problems in the include (I'm following the steps of the IBM redbook "Squeezing the most out of Dynamic SQL").First problem: it says that all the variables ins ...
We have a web application which calls a stored proc (external COBOL) program which runs horrendously slow. Database is 7.2 on OS390. The idea of the procedure is.....EXEC SQL DECLARE C1 CURSOR WITH RETURN FOR select column2 from table where col1 = :ws-host-var <-- 30 CHARACTER FIELD -- we are ind ...
I'd like to write a C++ app program that would store a list of files (by relative path/location) plus it's CRC32 or checksum. Then it would also store more CRC32/checksums for the same file, for each snapshot in time.The main usage of the app would be to help identify which versions of the current f ...
I need to exit a *cobol* stored procedure with an error code.My first idea was to write in the SQLCA but it doesn't work.In others databases, i could use raiseerror to 'raise the error' but how to do in COBOL db2 ?Thx.Olivier ...
I want to access ISAM file (embedd in ACU-COBOL) with PHP code.Is it possible ? if possile, pls let me knowwhat i do.Many ...
I want to add a checksum over static arrays as a security to prevent the array being altered in the .exe file.how do I do this? since the checksum must be generated on compile timepseudo:static int arr[] = { -5, 1, 95, 23, 4, 59, 13, 44, 87, 91, 2, 93, 52, 64 };...void checkArrayValid(){DWORD tmp = ...
Running on AIX 5.3 TL12 - Looking to disable checksum_offload permanently on our network interface. Is the only way to do this through a startup script? chdev -l en0 -a checksum_offload=no -P Method error (/usr/lib/methods/chgif): 0514-018 The values specified for the following attributes are not va ...
Running on AIX 5.3 TL12 - Looking to disable checksum_offload permanently on our network interface. Is the only way to do this through a startup script? chdev -l en0 -a checksum_offload=no -P Method error (/usr/lib/methods/chgif): 0514-018 The values specified for the following attributes are not va ...
Running on AIX 5.3 TL12 - Looking to disable checksum_offload permanently on our network interface. Is the only way to do this through a startup script? chdev -l en0 -a checksum_offload=no -P Method error (/usr/lib/methods/chgif): 0514-018 The values specified for the following attributes are not va ...
Running on AIX 5.3 TL12 - Looking to disable checksum_offload permanently on our network interface. Is the only way to do this through a startup script? chdev -l en0 -a checksum_offload=no -P Method error (/usr/lib/methods/chgif): 0514-018 The values specified for the following attributes are not va ...
We plan to migrate our applications from mainframe (OS/390 V2R5 with DB2 5.1) to AIX server with DB2 and MicroFocus Cobol. We are doing the initial study now and are trying to compile some sample programs in the AIX environment. We have been able to compile simple cobol programs (with no embedded SQ ...
Can someone point me to a page/thread that will explain how to use a checksum?I use it to verify my binary software packages, but have never used it with Ubuntu software. ...
does anyone know if we can pass a repeating group (group item) out of a cobol stored procedure . I know I can pass out a result set(i.e. a cursor) .Can I pass out something like:01 OUTGROUP OCCURS 5 TIMES.03 IFIN1-PLANNED-PYT05 PP-DUE-DATE PIC X(8).05 PP-AMT PIC S9(12).03 IFIN1-PC05 PC-OS-AMT PIC S9 ...
Is there any considerations to migrate MF (micro focus) cobols to IBM COBOL for AIX ? One of my customer uses MF cobol and he wants to migrate their applications to IBM. He uses IBM AIX 5.1 / MF COBOL server express 2.2 / Oracle 9204 / CICS 5.0. Any comments will be appreceiated. ...
I have in a AIX machine (oslevel 5300-08-01-0819) IBM Cobol Version 2.0 and DB2 version 8.2. The DB2 sample program advsql.sql is compiled (using the supplied makefile)and executed. The program runs displaying the extracted data from the database until the STOP RUN. The command STOP RUN is not execu ...
Is it possible to connect/open - MQ using a DB2 Cobol Store procedure similar to what we do from a CObol batch program? Any pointers while be highly appreciated? ...
I am running two cobol program simultaneously which are using one flat file for processing. So i want to lock flat file to program1 and unlock after completion of program1 and no other program should access this file after locking. In mainframe this has been internally handled by the system but in A ...
I compiling large COBOL program (Embedded SQL) on AIX UNIX using IBM COBOL compiler with –g option for debugger for AIX but I am getting following warning IGYPG3036-W 65535 1500-042: (W) WARNING in UBPCALC: Debug linenumbers >65535 discarded. Reduce file size and recompileto allow full debuggin ...
I need to check if two tables on different databases contains the same data.I wish to calculate a checksum at table level and if they are different calculate it at row level in order to locate the differences.Anyone knows if there is a DB2 function to accomplish this task? ...
I'm getting below error when executing the cobol program using the shell script.IWZ9942 Cannot find message catalog cobol2run.cat in NLSPATH. Message number is 200.Called from location 0xe14dc0IWZ901S Program exits due to severe or critical error.If anyone can help to resolve this, greatly appreciat ...
I am trying to call a DB2 stored procedure from a cobol program. Up to this point, I have been calling them from ASP pages. I want to get this to work so that the host programmers can test the stored procedures on their own, in an environment thats comfortable.I have found the correct syntax to make ...
Need ability for mainframe cobol program to read a federated database.Current environmentMainframe ZOS DB2 V7.1 DRDA TCP/IPFederated server:Windows 2003DB2UDB V8.2Information Intergrator DB2 Connect ESEI currently have several federated databases that are accessed via QMF and it works fine. ...
I am working Mainframe DB2. I have a DB2 COBOL program running on IBM Mainframe. I need to capture its associated DB2 Plan with in this COBOL program under which it is running. Depending upon the DB2 plan that thisprogram is running under, I need to do some process. How can I capture it in my progra ...
Db2 v7Cobol 3.2z/OS 1.4I have a table defined as UNICODE containing graphic field.Good news - after appliying some PTFs I'm able to select from the table using SPUFI,DSNTEP2 & DSNTIAUL. The data is shown in unreadable chars. + I get warnings 0 and 8 in sqlca.Bad news - I'm unable to select the g ...