Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 5 Manipulating Import Data Using TIBCO Object Service Broker : Listing Members of a PDS (z/OS) or Files in a Directory (Open Systems)

Listing Members of a PDS (z/OS) or Files in a Directory (Open Systems)
To list the names of the members of a partitioned data set (PDS) or the names of the files in a directory, you define:
1.
2.
Example for a PDS in z/OS
To list the member names of a PDS called USR40.EXAMPLE.PDS:
1.

 
COMMAND==> TABLE DEFINITION

Table: PDS_EXAMPLE Type: IMP Unit: USR40 IDgen: N

File: USR40.EXAMPLE.PDS
DDname: External Routine Name:
ServerID:

Parameter Name Typ Syn Len Dec Class Src ' Event Rule Typ Acc
---------------- - -- --- -- - - ' ---------------- - -
_ MEMBER I C 8 0 D ’ _
_ LOCATION I C 16 0 L ’ _
-------- IMP --------|--------- Metadata Definition ------
Field Name Xsyn Xlen Xdec Offset Key Typ Syn Len Dec Ord Rqd Default
--------------- ---- ----- -- ----- - - -- ----- --- - - --------
_ KEY C 8 0 0 P S C 8 0
_ DATA C 64 0 8 S C 64 0
_
_
_
_
_

_ PFKEYS: 3=END 12=CANCEL 22=DELETE 13=PRT 14=FIELDS 6=OFFSET 21=DATA 2=DOC

 
2.

 
COMMAND==> TABLE DEFINITION

Table: PDS_EXAMPLE_PRM Type: PRM Unit: USR40
Source: PDS_EXAMPLE


















PFKEYS: 3=END 12=CANCEL 22=DELETE 13=PRINT 14=FIELDS 21=DATA 2=DOC

 
3.

 
BROWSING TABLE : PDS_EXAMPLE_PRM
COMMAND ==>
SCROLL: P
NUMBER MEMBER
_ ----------- --------
_ 1 MEMBER01
_ 2 MEMBER02
_ 3 MEMBER03











PFKEYS: 1=HELP 5=FIND NEXT 9=RECALL 18=EXCLUDE 19=SHOW 13=PRINT 3=END 14=EXPAN

 
Example for a Directory in Windows or Solaris
To list the names of the files in a directory called D:\ObjectStar\database\JOURNAL:
1.

 
COMMAND==> TABLE DEFINITION

Table: PDS_EXAMPLE Type: IMP Unit: USR40 IDgen: N

File: D:\ObjectStar\database\JOURNAL
DDname: External Routine Name:
ServerID:

Parameter Name Typ Syn Len Dec Class Src ' Event Rule Typ Acc
---------------- - -- --- -- - - ' ---------------- - -
_ MEMBER I C 8 0 D ’ _
_ LOCATION I C 16 0 L ’ _
-------- IMP --------|--------- Metadata Definition ------
Field Name Xsyn Xlen Xdec Offset Key Typ Syn Len Dec Ord Rqd Default
---------------- ---- ----- -- ----- - - -- ----- --- - - ----------
_ KEY C 8 0 0 P S C 8 0
_ DATA C 64 0 8 S C 64 0
_
_
_
_
_

_ PFKEYS: 3=END 12=CANCEL 22=DELETE 13=PRT 14=FIELDS 6=OFFSET 21=DATA 2=DOC

 
2.

 
COMMAND==> TABLE DEFINITION

Table: PDS_EXAMPLE_PRM Type: PRM Unit: USR40
Source: PDS_EXAMPLE


















PFKEYS: 3=END 12=CANCEL 22=DELETE 13=PRINT 14=FIELDS 21=DATA 2=DOC

 
3.

 
BROWSING TABLE : PDS_EXAMPLE_PRM
COMMAND ==>
SCROLL: P
NUMBER MBMBER
_ ------ --------------
_ 1 JOURNAL1
_ 2 JOURNAL2
_
_
_
_
_
_
_
_
_
_
_
_
_
_
_
PFKEYS: 1=HELP 5=FIND NEXT 9=RECALL 18=EXCLUDE 13=PRINT 3=END 14=EXPAND

 
See Also
TIBCO Object Service Broker Managing Data for more information on creating PRM tables and on browsing tables.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved