MVSFORUMS.com

Thanks for your response. The single thread did work, currently we are setup for Single Thread for particular Transactions only. Worried if it will slow down the Training environment if a blanket com ...

We have a created a smaller version (less data) of our Production database of 170+ tables for the purpose of training new users. This is our Training environment. In a class of 15+ students, when the ...

Sorry I did it reverse last time

In a sql how do I join these 2 types of columns ?

Table A : Col-A is defined CHAR (6) NOT NULL
Table B : Col-B is defined DECIMAL ( 6, 0) NOT NULL

Is this ...

In a sql how do I join these 2 types of columns ?

Table A : Col-A is defined DECIMAL ( 6, 0) NOT NULL
Table B : Col-B is defined CHAR (6) NOT NULL

Is this correct?

DECIMAL(B.COL-A,6,0,',' ...

Sorry about not being more clear.
Whatever is easier - 2 new output files by removing the matching keys.
Below is the sysout. The LRECL=935, RECFM=FB. The position is 1, for length of 3.

Here i ...

Output as below

File 1

Z01
Z02
Z03

File 2

Z05
Z06
Z07
Z08
Z09

You notice that the duplicates got removed from File 1. We use PGM=SORT in all our jcls.

I have 2 input files with duplicate records among them

File 1

Z01
Z02
Z03
Z06 *
Z08 *

File 2

Z05
Z06 *
Z07
Z08 *
Z09

I want to get rid of the duplicates from File 1. ...

Thanks.

I am using a cursor in my Cobol program and it's gathering all the right records. What I would like to do is update some of the records that I have fetched from that cursor. How can I do update at the ...

Did anyone face the same problem I am having. Cursor FETCH keeps returning the same record again and again. If I use SPUFI it returns 19 records, but in the Application program it does not work. The a ...

I have 2 tables Parent table A & Child table B

Parent has 1 row per employee, child can have multiple rows, there are amount fields in both tables. If I try to join the tables and
use SUM f ...

Thank you.

Are you comparing record-by-record, that is, compare record1 of file1 to record1 of file2, compare record2 of file1 to record2 of file2, etc. Or are you comparing by key, that is, if any record in fil ...

Ok, this is my situation.

DCB=(RECFM=VB,LRECL=4030,BLKSIZE=0)

The first 32 bytes is fixed (shown in bold below), rest is variable length.

Here is a picture of the file for the first 84 bytes. ...

I have 2 files - A & B, need to compare these files to see if a particular field in each of these files are same. If same then I need to just write out file B. Is there any tool that can do this o ...