dbTalk Databases Forums  

D3 automatic item id length in LIST

comp.databases.pick comp.databases.pick


Discuss D3 automatic item id length in LIST in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
panzerboy@gmail.com
 
Posts: n/a

Default D3 automatic item id length in LIST - 03-20-2006 , 04:53 PM






Just started a new job using D3, I have been using UniData.
I have an 'opertunity' trying to assign the length of the item id when
LISTing.
I've tried UD MD filename and assigning the attr 9 & 10 and UD DICT
filename filename
doing the same thing but the item ids still come out too short.
Is there some magic in D3 to assign the automatic item id length for
access listings?

Jeremy Thomson


Reply With Quote
  #2  
Old   
Ross Ferris
 
Posts: n/a

Default Re: D3 automatic item id length in LIST - 03-20-2006 , 05:02 PM






you were correct with

ed dict filename filename (d

changng attr 9 & 10, as per :

:ed dict bp bp (d
top
..p
001 D
002 887848
003 9
004
005
006
007
008
009 L
010 20

Without the "D" option, you will not "save" the newly modified D-ptr
item! so things will appear to fail (well, they DO fail) - I think you
need to have SYS2 account access


Reply With Quote
  #3  
Old   
panzerboy@gmail.com
 
Posts: n/a

Default Re: D3 automatic item id length in LIST - 03-20-2006 , 06:13 PM



Hmmm... doesnt seem to work.

I can see the whole id if I use the ONLY thus ...
:LIST ONLY BIN.STOCK
Page 1 BIN.STOCK

BIN.STOCK

GREA065:1:F7630
CHAK820:1:T5632
....

A simple LIST Picks up the default attr defination 1 and truncates the
id length
:LIST BIN.STOCK
Page 1 BIN.STOCK

BIN.STOCK QOH.......

GREA065:1 360.00
CHAK820:1 22.00

even though the dict length suggests It should be 20 chars long ...
:ED DICT BIN.STOCK BIN.STOCK (D)
top
..P
001 D
002 $(MDS):$(MD)/BIN.STOCK/BIN.STOCK/BIN.STOCK
003 13
004
005
006
007
008
009 L
010 20
011
.... snip ...
030
031 4096
eoi 031

If it helps the MD entry is ...
:ED MD BIN.STOCK (D)
top
..P
001 D
002 $(MDS):$(MD)/BIN.STOCK/BIN.STOCK
003 1
004
.... snip ...
030
031 4096
eoi 031

My USERS item has a sys2 in attr 8 so I think my account access is
okay.
Thanks anyway, at least I know I was on the right(ish) track.

Jeremy Thomson


Reply With Quote
  #4  
Old   
Tony Gravagno
 
Posts: n/a

Default Re: D3 automatic item id length in LIST - 03-20-2006 , 07:27 PM



Someone mentioned to me just yesterday that there is an issue with
LISTDICT that causes dict listings to go vertical, and modifying the
Length atb in the file d-pointers fixes it. I've also heard that this
issue has since been fixed by RD in a current release of D3. To help
our colleagues who feel a need to adjust every d-pointer, can someone
here articulate exactly what the issue was, if it still exists in the
latest D3 7.4.x, and perhaps if there is a quick mod we can make to
the LISTDICT (LD) program that will temporarily fix this and save
people some pain. I seem to recall Bill Haskett mentioning this first
but I don't recall if this is the same issue, or maybe he mentioned
and issue with column widths in LISTFILES. I don't know what the
default verbs do at the moment - I have my own LISTFILES, for example,
which separates pointers into D, DX, Q, and QS, etc. I don't recall
if I tweaked LISTDICT to avoid this issue.

Thanks.
T


"Ross Ferris" <rossf (AT) stamina (DOT) com.au> wrote:

Quote:
you were correct with

ed dict filename filename (d

changng attr 9 & 10, as per :

:ed dict bp bp (d
top
.p
001 D
002 887848
003 9
004
005
006
007
008
009 L
010 20

Without the "D" option, you will not "save" the newly modified D-ptr
item! so things will appear to fail (well, they DO fail) - I think you
need to have SYS2 account access


Reply With Quote
  #5  
Old   
douglas@pickteam.com
 
Posts: n/a

Default Re: D3 automatic item id length in LIST - 03-20-2006 , 07:33 PM



If you want to stay in your comfort zone, just create an @ID dict item
with attribute 0 (zero). You can make this any length, justification,
or column heading that you want.

Then when you list the file, add the @ID to your list of display
fields, and put in an ID-SUPP or (I option to suppress the default id
listing.


Reply With Quote
  #6  
Old   
Ross Ferris
 
Posts: n/a

Default Re: D3 automatic item id length in LIST - 03-20-2006 , 07:36 PM



Quote:
From you entry I see you are actually using D3/NT ...
Why not just create a new dictionary item, called "key" or "@id" - set
the length of this dict item, then do your list, but include @id id-supp



Reply With Quote
  #7  
Old   
Mark Brown
 
Posts: n/a

Default Re: D3 automatic item id length in LIST - 03-20-2006 , 10:45 PM



Try changing attr 9 and 10 in the MD item to be L and 20.

IIRC, the DICT contains items that define the data, while MD contains Items
that define the dict. ID is considered a DICT piece of info, because attr 0
is not technically Greater than or Equal to 1.

Mark Brown

<panzerboy (AT) gmail (DOT) com> wrote

Quote:
Hmmm... doesnt seem to work.

I can see the whole id if I use the ONLY thus ...
:LIST ONLY BIN.STOCK
Page 1 BIN.STOCK

BIN.STOCK

GREA065:1:F7630
CHAK820:1:T5632
...

A simple LIST Picks up the default attr defination 1 and truncates the
id length
:LIST BIN.STOCK
Page 1 BIN.STOCK

BIN.STOCK QOH.......

GREA065:1 360.00
CHAK820:1 22.00

even though the dict length suggests It should be 20 chars long ...
:ED DICT BIN.STOCK BIN.STOCK (D)
top
.P
001 D
002 $(MDS):$(MD)/BIN.STOCK/BIN.STOCK/BIN.STOCK
003 13
004
005
006
007
008
009 L
010 20
011
... snip ...
030
031 4096
eoi 031

If it helps the MD entry is ...
:ED MD BIN.STOCK (D)
top
.P
001 D
002 $(MDS):$(MD)/BIN.STOCK/BIN.STOCK
003 1
004
... snip ...
030
031 4096
eoi 031

My USERS item has a sys2 in attr 8 so I think my account access is
okay.
Thanks anyway, at least I know I was on the right(ish) track.

Jeremy Thomson




Reply With Quote
  #8  
Old   
Mark Brown
 
Posts: n/a

Default Re: D3 automatic item id length in LIST - 03-20-2006 , 10:51 PM



I may have mis-spoke (typigraphically speaking).

LISTDICT id is controled by the FDI in the master dictionary. Make it wider
to see long dictionary names.

LIST/SORT id is controled by the FDI in the dictionary of the file. Make it
wider to make the default width of attribute 0 wider.

Or, as others have suggested, make a specific item ID ADI and the ID-SUPP
adverb.

Mark Brown


"Mark Brown" <mbrown (AT) drexelmgt (DOT) com> wrote

Quote:
Try changing attr 9 and 10 in the MD item to be L and 20.

IIRC, the DICT contains items that define the data, while MD contains
Items that define the dict. ID is considered a DICT piece of info,
because attr 0 is not technically Greater than or Equal to 1.

Mark Brown

panzerboy (AT) gmail (DOT) com> wrote in message
news:1142899996.552664.78130 (AT) t31g2000cwb (DOT) googlegroups.com...
Hmmm... doesnt seem to work.

I can see the whole id if I use the ONLY thus ...
:LIST ONLY BIN.STOCK
Page 1 BIN.STOCK

BIN.STOCK

GREA065:1:F7630
CHAK820:1:T5632
...

A simple LIST Picks up the default attr defination 1 and truncates the
id length
:LIST BIN.STOCK
Page 1 BIN.STOCK

BIN.STOCK QOH.......

GREA065:1 360.00
CHAK820:1 22.00

even though the dict length suggests It should be 20 chars long ...
:ED DICT BIN.STOCK BIN.STOCK (D)
top
.P
001 D
002 $(MDS):$(MD)/BIN.STOCK/BIN.STOCK/BIN.STOCK
003 13
004
005
006
007
008
009 L
010 20
011
... snip ...
030
031 4096
eoi 031

If it helps the MD entry is ...
:ED MD BIN.STOCK (D)
top
.P
001 D
002 $(MDS):$(MD)/BIN.STOCK/BIN.STOCK
003 1
004
... snip ...
030
031 4096
eoi 031

My USERS item has a sys2 in attr 8 so I think my account access is
okay.
Thanks anyway, at least I know I was on the right(ish) track.

Jeremy Thomson






Reply With Quote
  #9  
Old   
panzerboy@gmail.com
 
Posts: n/a

Default Re: D3 automatic item id length in LIST - 03-21-2006 , 02:20 PM



Thanks to the chaps that emailed me.
It seems you have to log off after changing a D-pointer item.
When I logged in this morning the automatic item id length was fixed.
Changing a d-pointer then doing a LOGTO and back doesnt work
Seems strange, I dont have to logoff after creating a file to list its
items?
Hmmm.. what would Richard Pick think of that?

Jeremy Thomson


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.