Note the usage of CRITERIA=Y and the CRITDD DD name.
Here is the report produced
Code:
Extract from
IMS subsystem: xxxx
Primary database: VNOPC00
Extract to data set: S1491B.VNOPC00.EXTRACT1
Processing Options
PSB type: Dynamic
Region type: BMP
Use criteria: Y
Use key values: N
Criteria set: xxxx.UT1PROJ.CRITERIA(S1491B2)
DBD
Data set name 1: xxxx.IMS.DBDLIB
This indicates quite clearly (if I could have formatted with Courier New and the output file confirms it) that the criteria selected 2 segments from VNOACD0 and 22 from VNOACK0.
So.... my original JCL using CRITDD only seems perfectly valid. _________________ Michael
Last edited by misi01 on Tue Jun 13, 2017 6:34 am; edited 1 time in total
Joined: 26 Nov 2002 Posts: 12367 Topics: 75 Location: San Jose
Posted: Tue Jun 13, 2017 11:22 am Post subject:
misi01 wrote:
Just tried the CRITDSN/CRITMEM suggestion you posted to no avail. My Rexx code was as follows
which shows that the GETIMS is only fetching the first (root) segment in the database (as well as the ensuing segments).
Basically, I'm wondering whether combining Rexx code and Criteria works/is allowed in Batch
Misi01,
What are the contents of your criteria dataset?
In the manual in "Chapter 4. Working with Templates and Views" and then in the section "Using views to filter data display" there is a detailed description about "Specifying field selection criteria" which in detail explains the "The effects of selecting and field selection criteria" _________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Joined: 02 Dec 2002 Posts: 618 Topics: 172 Location: Stockholm, Sweden
Posted: Tue Jun 13, 2017 3:38 pm Post subject:
I'll have a look tomorrow, but what I can say is that if we run FM as a batch job with CRITERIA=Y and no Rexx involved, the expected segments alone are selected _________________ Michael
The data after VNOACK0 ...... contains the value from the root segment (01) followed by the DEPA-TYP-KOD (02 or 03), so to me, this is definitely working as expected. _________________ Michael
All times are GMT - 5 Hours Goto page Previous1, 2
Page 2 of 2
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum