|
midrange.com
Hi!
I created a Join Logical with a select condition over 2 physical files.
I'd need Access Path Select/Omit (only 2% of the records meet the select
condition). But the logical behaves as if it has Dynamic Select/Omit: the
select processing is performed when the file is read rather than when the
file is updated.
I checked the manuals, consulted some helpdesks but we couldn't figure out
yet what could cause the problem.
Anybody an idea what could the reason for not obtaining Access Path
Select/Omit ?
Here's the DDS:
A R CLATREC
A TEXT('PX(CLAT-)')
A JFILE(CLTNPF CLNTPF )
A J JOIN(001 002 )
A JFLD(CLNTPFX CLNTPFX )
A JFLD(CLNTCOY CLNTCOY )
A JFLD(CLNTNUM CLNTNUM )
A CLNTPFX JREF(1)
A CLNTCOY JREF(1)
A CLNTNUM JREF(1)
A NAMETYPE JREF(1)
A NAMET JREF(1)
A CLTDOB JREF(1)
A SALUTL JREF(1)
A CLTIND JREF(1)
A FAOT JREF(1)
A BIRTHPT JREF(1)
A CLTADDRPT JREF(1)
A CLTADDRST JREF(1)
A CLTEMAILT JREF(1)
A MOTHERSNAT JREF(1)
A TRANID JREF(2)
A VALIDFLAG JREF(2)
A CLTTYPE JREF(2)
A SECUITYNO JREF(2)
A PAYROLLNO JREF(2)
A SURNAME JREF(2)
A GIVNAME JREF(2)
A SALUT JREF(2)
A INITIALS JREF(2)
A CLTSEX JREF(2)
A CLTADDR01 JREF(2)
A CLTADDR02 JREF(2)
A CLTADDR03 JREF(2)
A CLTADDR04 JREF(2)
A CLTADDR05 JREF(2)
A CLTPCODE JREF(2)
A CTRYCODE JREF(2)
A MAILING JREF(2)
A DIRMAIL JREF(2)
A ADDRTYPE JREF(2)
A CLTPHONE01 JREF(2)
A CLTPHONE02 JREF(2)
A VIP JREF(2)
A OCCPCODE JREF(2)
A SERVBRH JREF(2)
A STATCODE JREF(2)
A SOE JREF(2)
A DOCNO JREF(2)
A CLTDOD JREF(2)
A CLTSTAT JREF(2)
A CLTMCHG JREF(2)
A MIDDL01 JREF(2)
A MIDDL02 JREF(2)
A MARRYD JREF(2)
A TLXNO JREF(2)
A FAXNO JREF(2)
A TGRAM JREF(2)
A BIRTHP JREF(2)
A STCA JREF(2)
A STCB JREF(2)
A STCC JREF(2)
A STCD JREF(2)
A STCE JREF(2)
A PROCFLAG JREF(2)
A TERMID JREF(2)
A USER JREF(2)
A TRDT JREF(2)
A TRTM JREF(2)
A SNDXCDE JREF(2)
A NATLTY JREF(2)
A FAO JREF(2)
A STATE JREF(2)
A LANGUAGE JREF(2)
A ZDOCNO JREF(2)
A ZTAXNO JREF(2)
A ZTAXCHECK JREF(2)
A ZPCAT JREF(2)
A ZCCAT JREF(2)
A ZVATAPP JREF(2)
A ROLEFLAG01 JREF(2)
A ROLEFLAG02 JREF(2)
A ROLEFLAG03 JREF(2)
A ROLEFLAG04 JREF(2)
A ROLEFLAG05 JREF(2)
A ROLEFLAG06 JREF(2)
A ROLEFLAG07 JREF(2)
A ROLEFLAG08 JREF(2)
A ROLEFLAG09 JREF(2)
A ROLEFLAG10 JREF(2)
A ROLEFLAG11 JREF(2)
A ROLEFLAG12 JREF(2)
A ROLEFLAG13 JREF(2)
A ROLEFLAG14 JREF(2)
A ROLEFLAG15 JREF(2)
A ROLEFLAG16 JREF(2)
A ROLEFLAG17 JREF(2)
A ROLEFLAG18 JREF(2)
A ROLEFLAG19 JREF(2)
A ROLEFLAG20 JREF(2)
A ROLEFLAG21 JREF(2)
A ROLEFLAG22 JREF(2)
A ROLEFLAG23 JREF(2)
A ROLEFLAG24 JREF(2)
A ROLEFLAG25 JREF(2)
A ROLEFLAG26 JREF(2)
A ROLEFLAG27 JREF(2)
A ROLEFLAG28 JREF(2)
A ROLEFLAG29 JREF(2)
A ROLEFLAG30 JREF(2)
A ROLEFLAG31 JREF(2)
A ROLEFLAG32 JREF(2)
A ROLEFLAG33 JREF(2)
A ROLEFLAG34 JREF(2)
A ROLEFLAG35 JREF(2)
A JOBNM JREF(1)
A USRPRF JREF(1)
A DATIME JREF(1)
A K NAMET
A K CLTDOB
A K BIRTHPT
A K SALUTL
A K CLTIND
A K FAOT
A S ROLEFLAG02 COMP(EQ 'Y' )
A S ROLEFLAG02 COMP(EQ 'U' )
Paul Hendrickx
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
