Blog Posts - Mainframe



Mainframe tip editing IMS DB database with File Aid

DB2 Date and Time formats for Software developers

5 Top Data warehousing Skills in the age of Big data and Analytics http://t.co/oYjpD79EPi #datawarehousing — ApplyBigAnalytics (@applyanalytics) August 21, 2015 International Organization for Standardization (ISO) YYYY-MM-DD HH.MM.SS IBM USA St...

COBOL Different Error Handling Phrases

AT END NOT AT END END-OF-PAGE NOT END-OF-PAGE INVALID KEY NOT INVALID KEY NO DATA WITH DATA ON EXCEPTION NOT ON EXCEPTION ON OVERFLOW NOT ON OVERFLOW ON SIZE ERROR NOT ON SIZE ERROR Filed under: COBOL, Mainframe Tagged: cobol, COBOL Different Error H...

2 Top ideas to Copy or Load a Data set in Mainframe

You must load a VSAM data set by writing it sequentially. Entry-sequenced and linear- space data sets are in whatever sequence you want. Key-sequenced and relative- record data sets must be ordered on the record keys. Idea-1: You can load the data se...

DB2- MAX Column function- best example

The MAX function returns the largest value in the specified column or expression. The following SQL statement determines the project with the latest end date: SELECT MAX(ACENDATE) FROM DSN81010.PROJACT; The result of the MAX function is of the same d...

DB2- AVG Column function – Best example

The AVG function computes the average of the values for the column or expression specified as an argument. We should not give AVG function on CHAR arguments. This function operates only on numeric arguments. The following example calculates the avera...

5 Top ideas on JCL Checkpoint and Restart (1 of 2)

RD in JCL exec statement: There are two methods of restarting a job: restarting from a step (step restart) and restarting from a checkpoint (checkpoint restart). Step restart is simpler and doesn’t require the system to take a checkpoint. You s...

DB2 Questions on Primary Key, View , Static SQL and Dynamic SQL

What’s the advantage of using a view? By using views, you can set up different presentations of the same data. Each view is derived from the actual table data, but each user will see a subset of the data. The main benefit to using views is that...

Calling Stored Procedure in DB2- best example

What is the role of stored procedure in DB2 Workloads in a client/server environment can be moved from the client to the sever by creating one or more stored procedures. Once a stored procedure has been created and registered with a database (by exec...

DB2 Numeric, String, Date, Time Data types

Numeric Data types: SMALLINT: As the name suggests, the smallest numeric data type that DB2 supports. These values use 2 bytes of storage (16 bits) and are interpreted as 2s-complement signed numbers, providing a range between -32768 and 32767. INTEG...

Mainframe: DB2 Tutorial For Software Developers (5 of 5)

Read my Part-4 post on DB2 tutorial. Indexes: What is an Index ? ‘An index is an ordered set of pointers to rows of a base table’. Or ‘An Index is a balanced B-tree structure that orders the values of columns in a table’ Why an Index ? One...

All about Mainframe DB2 VARCHAR Field

VARCHAR(n): Varying-length character strings with a maximum length of n bytes. n must be greater than 0 and less than a number that depends on the page size of the table space. The maximum length is 32704. Handling additional data in VARCHAR fileds...

Mainframe JCL- DD Statements for Tape data sets

DD statement parameters that you can use for tape data sets. Here, the only parameters that are new are the RETPD, EXPDT, and LABEL parameters. RETPD and EXPDT let you set a time limit for how long a data set should be kept, and LABEL is the paramet...

Mainframe: DB2 Catalog tables in accessing Remote Data

The following system catalog  tables being updated while accessing data from remote systems: SYSIBM.LOCATIONS SYSIBM.LUNAMES SYSIBM.IPNAMES SYSIBM.MODESELECT SYSIBM.USERNAMES SYSIBM.LULIST SYSIBM.LUMODES Buffer pools in DB2 Buffer pools are database...

JCL- ICETOOL to Copy a data set to multiple data sets

Combining ICETOOL with DFSORT in Mainframe JCL. Best DFSORT examples so you can simplify your JCL code. Continue reading →...

ICETOOL in Job control Language (JCL) of Mainframe (1 of 4)

What is ICETOOL ICETOOL, a versatile data set processing and reporting utility, provides an easy-to-use batch front-end for DFSORT. How to use ICETOOL ICETOOL combines new features with previously available DFSORT features to perform complex sorting,...

DB2- Split Predicates to improve SQL Performance

Best rewriting SQL query methods to improve Query performance. First write Split predicates out if possible: SELECT DEPTNO, DEPTNAME FROM DEPT WHERE (ADMRDEPT = ‘E01′ AND DEPTNAME LIKE ‘BRANCH%’) OR (DEPTNO = ‘D01′...

DB2- Different SQL Queries for Creating Index (1 of 2)

Provide a fast, efficient method for locating specific rows of data in very large tables. (In some cases, all the information needed to resolve a query may be found in the index itself, in which case the actual table data does not have to be accessed...

Best ways to handle unrecoverable errors in CICS programs

Method-1 Best one method is to call error program, by passing error parameters. WORKING-STORAGE SECTION. * COPY ERRPARM. C 01 ERROR-PARAMETERS. C * C 05 ERR-RESP PIC S9(8) COMP. C 05 ERR-RESP2 PIC S9(8) COMP. C 05 ERR-TRNID PIC X(4). C 05 ERR-RSRCE P...

COBOL- Alternative Key vs Alternative Index

The concept of Index, Primary key and Alternative key and Alternative index creates many questions, much confusion in the mind of COBOL programmers. There are many simple and powerful solutions for Alternative Key and Alternative index files. Alterna...


Trending Topics

Close