IDMS DML/O Handout

IDMS DML/O Handout

Session Covers the following:

1. Central Version Vs. Local Mode

2. Preparing the IDMS region (BIND & READY)

3. Introduction to DMLO

4. Retrieval Commands

5. Modification Commands

6. Control Statements

7. Other useful Commands

DML/O Command Syntax

Preparing the IDMS region:

1. BIND

a) BIND RUN-UNIT [FOR subschema-name]

[DBNODE (NODENAME) dds-node-name]

[DBNAME dbname]

[DICTNODE dds-node-name]

[DICTNAME dictname]

b) BIND record-name

2. READY

READY [area-name]USAGE-MODE IS [PROTECTED / EXCLUSIVE]

{ RETRIEVAL / UPDATE }

Retrieval Commands:

1. FIND/OBTAIN

a) { FIND / OBTAIN }[KEEP [EXCLUSIVE]]

{CALC (ANY) DUPLICATE} record-name

b) {FIND / OBTAIN } [KEEP [EXCLUSIVE]] {NEXT

PRIOR

FIRST

LAST

Sequence-no}

[record-name] WITHIN

{ set-name /

area-name}

c) {FIND / OBTAIN } [KEEP [EXCLUSIVE]] CURRENT

[ record-name

WITHIN set-name

WITHIN area-name ]

d) {FIND / OBTAIN } [KEEP [EXCLUSIVE]] [record-name]

DB-KEY IS dbkey

e) {FIND / OBTAIN } [KEEP [EXCLUSIVE]]

OWNER WITHIN set-name

f) {FIND / OBTAIN} [KEEP [EXCLUSIVE]]

record-name WITHIN set-name

[CURRENT] USING sort-field-name

2. GET

GET [record-name]

3. RETURN

RETURN dbkey FROM index-set-name

{CURRENCY

FIRST CURRENCY

LAST CURRENCY

NEXT CURRENCY

PRIOR CURRENCY

USING index-key-value}

4. ACCEPT

a) ACCEPT dbkey-location FROM

[Record-name

Set-name

Area-name] CURRENCY

b) ACCEPT dbkey-location FROM set-name

{NEXT

PRIOR

OWNER} CURRENCY

Modification Commands:

1. CONNECT

CONNECT record-name TO set-name

2. DISCONNECT

DISCONNECT record-name FROM set-name

3. ERASE

ERASE record-name [{PERMANENET

SELECTIVE

ALL

} MEMBERS]

4. KEEP

KEEP [EXCLUSIVE] CURRENT

[record-name

WITHIN set-name

WITHIN area-name]

5. MODIFY

MODIFY record-name

6. STORE

STORE record-name

Control Statements:

1. IF

a) IF set-name IS [NOT] EMPTY imperative-statement

b) IF [NOT] set-name MEMBER imperative-statement

2. COMMIT

COMMIT [TASK]

[ALL]

3. ROLLBACK

ROLLBACK [TASK]

[CONTINUE]

4. FINISH

FINISH [TASK]

Other useful Commands

1. REC

2. AREAS

3. SETS

4. EQUATE

5. Assigning Commands to PF keys

PAGE 1