Data Processing Technical FAQ

Dedicated to mainframe, legacy programming FAQ topics including COBOL, JCL, CICS, DB2, SAS, SQL and IDMS. Meant to be a source and resource for interview ...

db2

DB2. Q1. What is a DB2 bind? A1. A DB2 bind is a process that builds an access path to DB2 tables. Q2. What is a DB2 access path? ...

vsam

Q1. What are the types of VSAM datasets? A1. Entry sequenced datasets (ESDS), key sequenced datasets (KSDS) and relative record dataset (RRDS). ...

idms

IDMS. Q1. What is the difference between a schema and a subschema? A1. The schema is the physical arrangement of the data as it appears in the DBMS. ...

cics

CICS. 3/1/00 48 questions and a tentative answer key for a Tech Test for CICS/COBOL Programmers. 1. Which of the following does multithreading allow? ...

Data Processing Technical Interview

NEWS. 12/5/01 Frankie Adamo: 'I recently had an interview, and the interviewer asked me a question that I thought would be useful on your site: Using this ...

sql

sql. Q1. What is the basic difference between a join and a union? A1. A join selects columns from 2 or more tables. A union selects rows. ...

Cobol

COBOL & COBOL II. 11/14/99: Karl Haynes: 'Can you use the INSPECT (with TALLYING option) Cobol verb in a CICS COBOL program? My program abends as soon as it ...

jcl

JCL. Q1. What are the kinds of job control statements? A1. The JOB, EXEC and DD statement. Q2. What is the meaning of keyword in JCL? What is its opposite? ...

sas

SAS. Q1. SAS is a series of steps made up of statements. What are the two types of SAS steps? What do they mean? A1. The two steps are the DATA and PROC ...