IMS DBDL/I Call GNP & ISRT - Mainframes Online Training

IMS DBDL/I Call GNP & ISRT - Mainframes Online Training

IMS DB DL/I Call GNP & ISRT IMS Training Class 06 Sequential Retrieval Using GNP Call GNP Call performs sequential retrieval very similar to the GN function, except that it retrieves only segments that are subordinate to the currently established parent.

Parentage must be established by issuing either a GU or GN call, in which case DL/I not only establishes a position on same segment occurrence, but it also, establishes parentage on that occurrence. GNP calls without SSA's Issuing a series of GNP calls without SSA's will retrieve only those segments that are dependant on the segment at which the

parentage is established GU HOSPITAL (HOSPNAME = XYZ HOSP) Assume this establishes parentage; say at segment 1 in database. Next GNP call without SSA will retrieve the first word segment that is segment 2 Further GNP calls without SSA will scan through the database and retrieve in hierarchical sequence all the segments that are dependent on XYZ HOSP Hospital Segment. The last one being segment 14. One more GNP call after segment 14 would return a status code of GE indicating no more segments under the established parent

GNP call with Unqualified SSAs GNP calls with unqualified SSA's will sequentially retrieve only segment of the particular segment type. GU HOSPITAL (HOSPNAME = XYZ HOSP) Assume, this established parentage, say at segment 1 in database. GNP PATIENT In this case, GNP calls that specify an unqualified SSA for the Patient segment retrieves the segments 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 and 14 in the first database record that is segment no. 1 for XYZ HOSP Hospital GNP call with Qualified SSA's

GNP calls with qualified SSA's can be used when performing Skip-Sequential Processing. Perform a series of GNP calls using SSA only for the segment type being retrieved. Assume, this established parentage at ward no 01 in XYZ HOSP Hospital, say at segment 2 in the database. GNP PATIENT (BEDIDENT = Supplied Value) Now, issuing GNP calls with a single qualified SSA for the patient segment instead of GN calls, the program has automatically limited the area of search to only there segments which are dependant on ward no. 1. That is segment 2.

GNP Calls - Status Code When issued without SSA's (unqualified GNP call) GA - Moved up in level to retrieve the segment GK - New segment type at the same level is retrieved GE - End of database is reached When issued with unqualified SSA's (qualified GNP call) GE - End of database is reached When issued with qualified SSA's (Qualified GNP call) BLANK - Segment successfully retrieved GE - Segments not found following the current position Loading Segments Into An Empty

Database ISRT call is issued to load a database with segments from the scratch PCB for the database in the PSB should specify as processing options L or LS in the PROCOPT operand for permitting loading of segments in the Ascending sequence in the Load mode

One important rule for ISRT call is that the segment being loaded or inserted must be identified in an single unqualified SSA, since qualified SSA is not valid. Loading Segments Into An Empty Database

Programs designed to Load databases normally use ISRT calls With Unqualified SSA Segments must be presented to the Load Program in the Hierarchical Sequence. The appropriate segment name for the segment type being loaded is moved into the Unqualified SSA are before

CALL 'CBLTDLI' USING ISRT PCB-MASK I-O AREA UNQUALIFIED-SSA ISRT Call (Load Mode) - Status Codes LB - When you try to load the same segment twice i.e. segment already exists LC - The segments being loaded are not in their Hierarchical sequence i.e. key values out of sequence LD - No parent for the segments being loaded. You cannot load a dependant segment until its parent has been loaded.

LE - Segment types out of sequence. For example: - If you tried to load a facility segment before a patient segment. Inserting Segments Into An Existing DB ISRT call is issued to insert a new segment into the database. Insertion of segments can be made in any sequence.

Program should build the segment occurrence data in the segment description area in Working-Storage section before issuing a call. PCB for the database in the PSB should specifying as processing options I or IS in the PROCOPT operand for permitting insertions of segments in the Ascending Sequence in the Insert Mode. (A or AS is also permitted)

ISRT Call - Status Codes II - The segment already exists in the database. A duplicate key value is being inserted into. IX - Encountered an Insert Rule Violation. Program tried to insert a segment into the wrong place in the database. Thank You Polsani Anil Kumar

Recently Viewed Presentations

  • Αντοχή πλοίου ΙΙ

    Αντοχή πλοίου ΙΙ

    Ip = polar moment of inertia, in cm4 , of profile about connection of stiffener to plate = h?3??310−4 for flat bars (slabs) = h?3??3+h?2????10−4 for flanged profiles. ... For web plate of longitudinals the ideal elastic buckling stress is...
  • TWENTY-SECOND SUNDAY IN ORDINARY TIME SEPTEMBER 1, 2013

    TWENTY-SECOND SUNDAY IN ORDINARY TIME SEPTEMBER 1, 2013

    MARY'S SHELTER: Mary's Shelter was founded as a viable alternative to abortion by women and men who believe that every living person, including the unborn, are children of one Heavenly Father who creates all in his infinite goodness and wisdom....
  • Quickdraw Carol Ann Duffy

    Quickdraw Carol Ann Duffy

    To analyse the poem " Quickdraw " by Carol Ann Duffy. To learn about extended metaphor. Wednesday, 28 February 2018. A comparison between two unlike things that continues throughout a piece of literature, including poems. Extended Metaphor.
  • Opiates and Diuretics

    Opiates and Diuretics

    Name what type of diuretic the following are and which part of the kidney they work in: a. Frusemide . b. Acetozolamide. c. Bendroflumethiazide Describe how frusemide works and whether Na excretion is increased or decreased? Name a condition which...
  • CHO Reactions III-Hydrolysis

    CHO Reactions III-Hydrolysis

    Times New Roman Arial Monotype Sorts Symbol Wingdings kgelmast.ppt Microsoft PowerPoint Slide Microsoft Word Document Lecture V CHO Reactions III Reactions of Carbohydrates IV Anomeric hydroxyl group Reactions of Carbohydrates IV Anomeric hydroxyl group Reactions of Carbohydrates IV Glycosyl halides...
  • What Educational & Research Networks Need To Know

    What Educational & Research Networks Need To Know

    ASN assignments. Transfers. Reverse DNS. Record Maintenance. ... Initially, specified recipient transfers were allowed only in the ARIN region. Some years after the first policy was implemented, the community created an inter-RIR transfer policy, which in essence is the same...
  • SoECS Moves (OW) in Support of Research Lab Establishment

    SoECS Moves (OW) in Support of Research Lab Establishment

    Instruction-Level Parallelism (ILP) Basic Block (BB) ILP is quite small. BB: a straight-line code sequence with no branches in except to the entry and no branches out except at the exit. average dynamic branch frequency 15% to 25% => 4...
  • Women In Physics

    Women In Physics

    WOMEN IN PHYSICS:The IUPAP International Conference on Women in Physics (Paris, France, 7-9 March 2002) ... In industry, the position of a person, man or woman, becomes higher as his/her age reaches 40 and above. Promotion of women stops at...