Top "Mainframe" questions

Compare two files and write it to "match" and "nomatch" files

I have two input files, each with length of 5200 bytes. A seven byte key is used to compare both files, …

mainframe syncsort dfsort easytrieve

DB2 database in Oracle SQL developer

I've heard it's possible to connect to a mainframe DB2 database with a client like Oracle SQL developer. I've looked …

database oracle db2 mainframe oracle-sqldeveloper

JCL SYNCSORT: OMIT and INCLUDE are not interchangeable?

I'm getting different output for these two sort cards, can someone tell me why? 1. INCLUDE COND=((1,3,CH,NE,C'ABC',AND,5,3,…

sorting include mainframe jcl syncsort

"COPY" statement with "REPLACING" in COBOL

I am getting compilation error as, A "COPY" statement with "REPLACING" phrase was found within a nested "COPY". This is …

cobol mainframe

DB2 SQL code to extract stored procedures

My colleagues and I have several hundred SQL stored procedures sitting on a hosted DB2/z database (version 8.1). We have …

sql db2 mainframe zos

jcl sort to divide Mainframe Dataset

I am trying to divide MF PS into several datasets. e.g. If I have a Dataset containg 600 recs, I …

sorting mainframe jcl

How to display the actual value of a comp variable in cobol

I have the following variable in COBOL program which gets its value from a file, when it is read: 01 Employee-number …

cobol mainframe ebcdic

How to create a member in an existing pds using jcl

I've used the below jcl: //STEP1 EXEC PGM=IEBGENER //SYSUT1 DD DUMMY,RECFM=FB,LRECL=80 //SYSUT2 DD DSN=RK.MYDIR.…

mainframe jcl

Pass JCL symbol to in-stream data sets

I'm trying to create and delete a dataset with a JCL symbol in the dataset name this way: // SET DATE=20110809 //* …

mainframe jcl

How to write DB2 SELECT statement in unload job for delimiters

I have been over this... seems silly but couldnt figure out! I wanna UNLOAD a table but with a delimiter …

select db2 mainframe jcl