Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Query on field name parameter of DBD definition

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
nmr4u

New User


Joined: 14 May 2007
Posts: 9
Location: India

PostPosted: Tue Jan 08, 2008 11:49 am    Post subject: Query on field name parameter of DBD definition
Reply with quote

Hi,

The Field name parameter contains a clause with an optional "SEQ,M" or "SEQ,U". What does each of these signify? Please help me with the following example.

SEGM NAME=TESTSEG1,PARENT=0,BYTES=90,PTR=TB
FIELD NAME=(TESTKEY1,SEQ,U),BYTES=4,START=1,TYPE=P


SEGM NAME=TESTSEG1,PARENT=0,BYTES=90,PTR=TB
FIELD NAME=(TESTKEY1,SEQ,M),BYTES=4,START=1,TYPE=P


Thanks,
Mohan
Back to top
View user's profile Send private message

Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Fri Jan 11, 2008 10:59 pm    Post subject:
Reply with quote

SEQ,U is a unique sequence key; SEQ,M is a sequence key but allows multiple same keys values.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Join in SQL Query vickey_dw DB2 2 Tue Jan 17, 2017 12:15 am
No new posts INVALID FIELD OR CONSTANT IN SORTOF ?? Ron Klop DFSORT/ICETOOL 8 Wed Jan 11, 2017 3:44 pm
This topic is locked: you cannot edit posts or make replies. MQ setup query mohitsaini Java & MQSeries 4 Sun Jan 08, 2017 1:53 am
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
No new posts DDNAME parameter mistah kurtz JCL & VSAM 6 Mon Dec 19, 2016 4:41 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us