90 Cobol/DB2 Performance and Tuning TIPS

90 Cobol/DB2 Performance and Tuning TIPS

This document presents a set of rules and simple tips to improve the performance of Cobol/DB2 programs It contains many examples of SQL queries and COBOL constructs and presents some advanced concepts of DB2 (V9 and V10)

Continue reading

A Cobol IBM Mainframe syntax lexer for Pygments

A Cobol IBM Mainframe syntax lexer for Pygments

This package contains a Pygments Lexer for mainframe cobol.

The lexer parses the Enterprise Cobol dialect (V3R4) for z/OS, including utilizing embedded Db2/Sql, Cics and DLi

mainframe cobol coding form

Many early programming languages, including PL/1, Fortran, Cobol and the various ...

Continue reading

A python FTP subclass for Mainframe z/OS

A python FTP subclass for Mainframe z/OS

A FTP subclass which adds some Mainframe z/OS features like job submission, execution of sql/DB2 queries, ...

Usage

import zosftplib
Myzftp = zosftplib.Zftp(mvshost, mvsuser, passwd,
                        timeout=500.0, sbdataconn='(ibm-1147,iso8859-1)')

Features

submitting

with open('/tmp/systables.csv', 'w') as outfile:
    for line in Myzftp.exec_sql("SELECT * FROM SYSIBM.SYSTABLES WITH UR"):
        outfile ...

Continue reading

Yearly archives