-
What are the parts of a SR document(short)?
- title page
- table of contents
- revision log
- purpose (of document)
- background
- scope: in and out
- business requirements(sources, additions)
- Tracability Matrix
- proposed solution
- component list
- testing considerations
- Implementation
- Post Implementation
- Appendix
-
What are the section of SR(details)?
- Title page(project name, project number, document verion, original date, version date, number of pages, document authors)
- Table of Contents
- Revision Log(version, version date, summary of changes, version date), Purpose (of document)
- Background
- Scope (In Scope, Out of Scope)
- Business Requirement (from BRD, recieved separately)
- Tracability Matrix(BR from BRD, BR in SR, Addressed in Proposed Solution)
- Proposed Solution (give brief describe of the purpose of each component that is being changed, describe how each component is being changed, implementation date, effective date, end date,…)
- Testing Considerations(eGCTM table)
- Component List
- Post Implementation Steps
- Appendix (Change reports/listings, components not needing updates,…)
-
parts of test plan
- title page
- table of contents
- revision log
- purpose (of document)
- background
- business requirements(sources, additions)
- reference documents
- objectives
- scope: in and out
- Test Strategy
- Test Scenarios
-
parts of implementation plan
- Create Prod CRQ
- update eGCTM table
- Create Endevor Package
- Submit package for approvals
- Implement package
- Verify implementation
- Client verification
- Announce success/unsuccessful implementation
- Endevor background procedure
-
Status reporting – informing MT
Agile like-conversations between me and testers regarding test scenarios and results
Mention dba’s
Debug – review
-include syscharts
Don’t use general terms – be specific
Control files - balancing
-
Db2 SUM
CREATE TABLE sum_demo(c1 INT);
INSERT INTO sum_demo(c1) VALUES(1),(2),(3),(3),(NULL);
sum all
sum but don't include duplicates
SUM(ALL | DISTINCT expression)
- SELECT SUM(c1) FROM sum_demo;
- SELECT SUM(DISTINCT c1) total_distinctFROM sum_demo;
-
Db2 UPPER()
- SELECT author_id, first_name, last_name
- FROM authors
- WHERE UPPER(last_name) = 'ANDERSON';
-
DB2 concatenate
- SELECT CONCAT(FIRSTNME, LASTNAME)
- FROM DSN8A10.EMP;
-
sort in increasing order records based on the letters in columns 1, 2, 3, 9, 10,11
sort field=(1,3,CH,A,9,3,CH,A)
-
sort in increasing order records based on the letters in columns 1, 2, 3,BUT NO DUPLICATES
- sort field=(1,3,CH,A)
- SUM FIELDS=NONE
-
How to copy data set in DFSORT
- SORT FIELDS=COPY
- FIELDS - The input data set is copied to the output data set
- without sorting or merging.
-
Analysis Techniques
- collect information
- select pertinent parts
- analyze information
- observing
- research
- develop solutions
- communication
-
Testing Types in job spec
- system testing
- iteration testing
- acceptance testing
- regression testing
- volume testing
- performance testing
- post implementation testing
- user acceptance testing re-testing
-
other testing types
boundary testing
-
batch sql query
- SELECT WORKDEPT, AVG(SALARY)
- FROM DSN8A10.EMP
- GROUP BY WORKDEPT
- ORDER BY 2;
-
sql with function
- SELECT SUM(column_name)
- FROM table_name
- WHERE CONDITION
- GROUP BY column_name
- HAVING (arithematic function condition);
-
query unique
- SELECT DISTINCT column1, column2....columnN
- FROM table_name;
-
query in range
- SELECT column1, column2....columnN
- FROM table_name
- WHERE column_name BETWEEN val-1 AND val-2;
-
query when something belongs to a set
- SELECT column1, column2....columnN
- FROM table_name
- WHERE column_name IN (val-1, val-2,...val-N);
-
assign columns as index
- CREATE UNIQUE INDEX index_name
- ON table_name ( column1, column2,...columnN);
-
update values of a record
- UPDATE table_name
- SET column1 = value1, column2 = value2....columnN=valueN
- [ WHERE CONDITION ];
-
add rows to table
- INSERT INTO table_name( column1, column2....columnN)
- VALUES ( value1, value2....valueN);
-
remove rows
- DELETE FROM table_name
- WHERE {CONDITION};
-
Populate one table using another table
- INSERT INTO first_table_name [(column1, column2, ... columnN)]
- SELECT column1, column2, ...columnN
- FROM second_table_name
- [WHERE condition];
-
-
basic query
- SELECT column1, column2....columnN
- FROM table_name
- WHERE CONDITION
- ORDER BY column_name {ASC|DESC};
-
DELETE VSAM FILE
- //IDCAMS1 EXEC PGM=IDCAMS
- //SYSPRINT DD SYSOUT=*
- //PRINTDD DD SYSOUT=*
- //SYSIN DD *
- DELETE (QUALVSAM.QUAL1.QUAL2) -
- CLUSTER PURGE NOERASE
- /*
- //
-
create vsam
- //IDCAMS1 EXEC PGM=IDCAMS
- //SYSPRINT DD SYSOUT=*
- //PRINTDD DD SYSOUT=*
- //SYSIN DD *
- DEFINE CLUSTER -
- (NAME (qualVSAM.qual1.qual2.TEST)-
- VOL(VSAMT3) -
- CYL(1,5) -
- MODEL(qualVSAM.qual1.qual2.model))-
- DATA (NAME (qualVSAM.qual1.qual2.DATA))
- /*
- //*
-
copy vsam
- //STEP02 EXEC PGM=IDCAMS
- //INTAPE DD DSN=qualVSAM.qual1.qual2,DISP=SHR
- //OUTFSM DD DSN=qualVSAM.qual1.qual2.TEST,DISP=OLD
- //SYSIN DD *
- REPRO INFILE(INTAPE)
- OUTFILE(OUTFSM)
- //SYSPRINT DD SYSOUT=*
- //
-
cobal file-control for vsam
- ENVIRONMENT DIVISION.
- INPUT-OUTPUT SECTION.
- FILE-CONTROL.
- SELECT F--IN
- ASSIGN TO FSMIN
- ORGANIZATION IS INDEXED
- ACCESS IS DYNAMIC
- RECORD KEY IS F-KEY
- FILE STATUS IS W-STATUS.
-
vsam cobol file section
- FD F-IN
- RECORD CONTAINS 269 CHARACTERS
- DATA RECORD IS F-REC.
- 01 F-REC.
- 05 FILLER PIC X(01).
- 05 F-KEY.
- 10 F-key1 PIC X(04).
- 10 F-key2X PIC X(2).
- 10 F-key29 REDEFINES F-key2X PIC 9(02).
- 05 FILLER PIC X(20).
-
vsam cobol reads
- Move values to key before read
- READ F-IN INTO ws-RCRD
- INVALID KEY
- MOVE 'Y' TO W-INVALID-key-SW
- END-READ.
-
Binary byte usage
- A binary number with a PICTURE description of
- four or fewer decimal digits occupies 2 bytes;
- five to nine decimal digits, 4 bytes;
- and 10 to 18 decimal digits, 8 bytes.
-
sequential read
- READ file-name RECORD INTO ws-rec
- AT END
- do stuff
- NOT AT END
- do other stuff
- END-READ
-
RANDOM READ
- READ file-name RECORD INTO ws-rec
- KEY IS ws-keyName
- INVALID KEY
- do stuff
- NOT INVALID KEY
- do other stuff
- END-READ
-
syntax of sequential file organization −
- INPUT-OUTPUT SECTION.
- FILE-CONTROL.
- SELECT file-name
- ASSIGN TO dd-name-jcl
- ORGANIZATION IS SEQUENTIAL
-
indexed i-o
- SELECT fileName
- ASSIGN TO ddname
- ORGANIZATION IS INDEXED
- ACCESS IS DYNAMIC
- RECORD KEY IS ws-key
- FILE STATUS IS ws-fileStatus.
-
syntax of indexed sequential file organization −
- INPUT-OUTPUT SECTION.
- FILE-CONTROL.
- SELECT file-name
- ASSIGN TO dd-name-jcl
- ORGANIZATION IS INDEXED
- RECORD KEY IS primary-key
- ALTERNATE RECORD KEY IS rec-key
-
Called Program Constraints
Following are the called program requirements −
Linkage section must be defined in the called program. It consists of data elements passed in the program. The data items should not have Value clause. PIC clause must be compatible with the variables passed through the calling program.
Procedure division using has a list of variables passed from the calling program and the order must be same as mentioned in the Call verb.
Exit program statement is used in the called program to transfer the control back. It must be the last statement in the called program.
-
Following is the syntax of calling subroutine by reference −
CALL sub-prog-name USING variable-1, variable-2.
-
CONTROL FILE
- 01 WS-CONTROL-RECORD.
- 05 WS-PROGRAM-ID PIC X(8).
- 05 WS-PROCESS-DATE PIC X(8).
- 05 WS-CYCLE-NO PIC 9(4).
- 05 WS-FILE-CONTROL OCCURS 10 TIMES.
- 10 WS-DSN PIC X(8).
- 10 WS-RECORD-COUNT PIC S9(13).
-
Declaratives
name-EXCEPTION-HANDLING SECTION. USE AFTER EXCEPTION PROCEDURE ON fileName. name-STATUS-CODE-CHECK. do stuff PERFORM abendPara THRU. nn-EXIT. EXIT.
-
linkage in program from jcl
- LINKAGE SECTION.
- 01 L01-PARMS.
- 05 FILLER PIC S9(04) COMP.
- 05 L01-var.
|
|