j63

  1. parts of SR document
    • title page
    • table of contents
    • revision log
    • purpose (of document)
    • background
    • scope: in and out
    • business requirements(sources, additions)
    • proposed solution
    • component list
    • testing considerations
    • implementation
  2. 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
  3. 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
  4. 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
  5. 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;
  6. Db2 UPPER()
    • SELECT    author_id,    first_name,    last_name
    • FROM    authors
    • WHERE     UPPER(last_name) = 'ANDERSON';
  7. DB2 concatenate
    • SELECT CONCAT(FIRSTNME, LASTNAME)
    • FROM DSN8A10.EMP;
  8. 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)
  9. 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
  10. 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.
  11. Analysis Techniques
    • collect information
    • select pertinent parts
    • analyze information
    • observing
    • research
    • develop solutions
    • communication
  12. 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
  13. other testing types
    boundary testing
  14. batch sql query
    • SELECT WORKDEPT, AVG(SALARY)
    • FROM DSN8A10.EMP
    • GROUP BY WORKDEPT
    • ORDER BY 2;
  15. sql with function
    • SELECT SUM(column_name)
    • FROM table_name
    • WHERE CONDITION
    • GROUP BY column_name
    • HAVING (arithematic function condition);
  16. query unique
    • SELECT DISTINCT column1, column2....columnN
    • FROM table_name;
  17. query in range
    • SELECT column1, column2....columnN
    • FROM table_name
    • WHERE column_name BETWEEN val-1 AND val-2;
  18. query when something belongs to a set
    • SELECT column1, column2....columnN
    • FROM table_name
    • WHERE column_name IN (val-1, val-2,...val-N);
  19. assign columns as index
    • CREATE UNIQUE INDEX index_name
    • ON table_name ( column1, column2,...columnN);
  20. update values of a record
    • UPDATE table_name
    • SET column1 = value1, column2 = value2....columnN=valueN
    • [ WHERE CONDITION ];
  21. add rows to table
    • INSERT INTO table_name( column1, column2....columnN)
    • VALUES ( value1, value2....valueN);
  22. remove rows
    • DELETE FROM table_name
    • WHERE {CONDITION};
  23. Populate one table using another table
    • INSERT INTO first_table_name [(column1, column2, ... columnN)]
    • SELECT column1, column2, ...columnN
    • FROM second_table_name
    • [WHERE condition];
  24. cobol sql next record
  25. basic query
    • SELECT column1, column2....columnN
    • FROM table_name
    • WHERE CONDITION
    • ORDER BY column_name {ASC|DESC};
  26. DELETE VSAM FILE
    • //IDCAMS1 EXEC PGM=IDCAMS
    • //SYSPRINT  DD SYSOUT=*
    • //PRINTDD   DD SYSOUT=*
    • //SYSIN     DD *
    •   DELETE  (QUALVSAM.QUAL1.QUAL2) -
    •   CLUSTER PURGE NOERASE
    • /*
    • //
  27. 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))
    • /*
    • //*
  28. 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=*
    • //
  29. 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.
  30. 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).
  31. 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.
  32. 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.
  33. sequential read
    • READ file-name RECORD INTO ws-rec
    •   AT END
    •     do stuff
    •   NOT AT END
    •    do other stuff
    • END-READ
  34. 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
  35. syntax of sequential file organization −
    • INPUT-OUTPUT SECTION.
    • FILE-CONTROL.
    • SELECT file-name
    •  ASSIGN TO dd-name-jcl
    •   ORGANIZATION IS SEQUENTIAL
  36. indexed i-o
    • SELECT fileName
    •   ASSIGN TO ddname
    •   ORGANIZATION IS INDEXED
    •   ACCESS IS DYNAMIC
    •   RECORD KEY IS ws-key
    •   FILE STATUS IS ws-fileStatus.
  37. 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
  38. 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.
  39. Following is the syntax of calling subroutine by reference −
    CALL sub-prog-name USING variable-1, variable-2.
  40. 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).
  41. Declaratives
    name-EXCEPTION-HANDLING SECTION.   USE AFTER EXCEPTION PROCEDURE ON fileName. name-STATUS-CODE-CHECK.   do stuff   PERFORM abendPara THRU. nn-EXIT.   EXIT.
  42. linkage in program from jcl
    • LINKAGE SECTION.
    • 01  L01-PARMS.
    • 05  FILLER PIC S9(04) COMP.
    • 05  L01-var.
Author
slc53
ID
349933
Card Set
j63
Description
j63
Updated