MVSFORUMS.com

Jayanthi Periasamy · Beginner Joined: 04 Apr 2006 Posts: 4 Topics: 2

Hi,

I am trying to creating an index for a database. The database contains one parent segment and one child segment. The index is for child segment. Now, it has one field as the key but I need to amend it as four fields to be a key and all the four fields are not adjacent to eachother. So, if I try with giving one field as SEQ and others as SRCH , I am getting " SEQ field not Unique" abend, since the combination of all the four fields only will be unique.

ANIL SARATHY · Posted: Mon May 22, 2006 9:57 am Post subject:

It is not mandatory to have all search fields to be adjacent.

Give all four fields in SRCH=(,,,) and it is you or your teams call to have
symbolic or direct pointer addressing for secondary index.

SEQ= can have two value to make key unique in case if all 4 fields are not unique. ( /SX or /CK for symbolic or concatenated key)

Very Happy

_________________
Anil Sarathy

Jayanthi Periasamy · Beginner Joined: 04 Apr 2006 Posts: 4 Topics: 2

Anil,

Thanks for your reply.
My Present DBD is

SEGM NAME=SWPIDCH,PARENT=SWPIDRT,BYTES=98
FIELD NAME=(FWCHDKEY,SEQ),BYTES=2,START=1

I tried to change as

SEGM NAME=SWPIDCH,PARENT=SWPIDRT,BYTES=98
FIELD NAME=(FWPEFFDT,SEQ),BYTES=5,START=10
FIELD NAME=FWPBSN,BYTES=1,START=79
FIELD NAME=FWPSEQ ,BYTES=1,START=80
FIELD NAME=FWPCOVC,BYTES=1,START=82

In this, it is telling FWPEFFDT is not unique. Could you help me in this... Sad

ANIL SARATHY · Posted: Tue May 23, 2006 9:31 am Post subject:

I thought u had problen with secondary index ,considering SEQ and SRCH words. But it is not the case here. Problem is with primary key itself.

What actually mean by "creating index". I think this DBD already exists with
child segment having key. Then why new index
_________________
Anil Sarathy