• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Data Dictionary

sharad

Member
I would like to know the implications of changing the character length in the data dictionary.

would be nice to get a reply on this

Sharad
 

nbiltgen

Active Member
U can't do that since th system use that description to validate and display
the datas on screen.
And for one data of 4 position long u have that field in some file...so if u
change the DD description it will make you unable to use the proggie which
use those fields

----- Original Message -----
From: "sharad" <sharadkuls@rediffmail.com>
To: <jdelistml@jdelist.com>
Sent: Thursday, May 10, 2001 1:36 PM
Subject: Data Dictionary


the data dictionary.
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=1
0520
 

Larry_Jones

Legendary Poster
ditto to nbiltgen's reply Sharad. The implications of changing the length of a DD item are ... (drumroll please) . . . very nasty indeed. Net, net don't try.

Regards,

Larry Jones
ljones@wagstaff.com
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE SP15
 

kread

Active Member
Tread very carefully on this one. I changed the Display Decimals value from 4 to 2 on one field. I found that it affected the values that actually printed. It moved the decimal over 2 positions and caused all kinds of headaches. Lesson learned - don't change the data dictionary.
 

Adrian_Chimirel

Legendary Poster
Hi Sharad,
Some Thursday, 12:30PM, just BEFORE lunch, black humour!
If you say so (would be nice to get a reply on this), this is my 4(th)¢ (or reply, whatever :)
How could anybody change the character length? The character size equals one, only, always, unfortunately everywhere :(
Assuming you want to change (or, sorry, mess up with) a Data Dictionary Item size, see the previous (excellent) 3 positive replies. Don't do it! You'll regret it! You'd better make public the system configuration :)
One was glad to be of help.

LIVE: B732.1 SP12.2, Oracle 806
SANDBOX: Xe SP15 & Update1, Oracle 8i
RS/6000, Citrix
 

Zoltan_Gyimesi

Legendary Poster
Sharad,

Briefly: ditto, DO NOT DO IT!
(... except if it is a custom Data Item and you know all occurences of it as well in tables as well in APPLs, UBEs, BSFNs, DSTRs, etc. and can you handle the changes.)

If you tell us why do you want to do it then maybe List/Forum could suggest some alternatives for you.

Regards,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

wcgodfrey

Member
I will also add my thoughts.
If you want to change data dictionary field length
values you should first draft a nice letter to your
boss saying that you resign (before he can cut your
head off because of the data corruption).

However if you have no data in your files it is safe
to change things like display decimals (with
reservations). But never change the size of the field
because this does not change the way it is stored in
your database.

Bill

--- sharad <sharadkuls@rediffmail.com> wrote:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=10520


_______________________________________________________
 

nbiltgen

Active Member
the only thing u can change in DD are number of decimal, control rules,
display rules...BUT you have to do it carefully...
for example, if you change the number of decimal, u have to convert MANULLY
all data alreday recorded with the old format.

regards

----- Original Message -----
From: "kread" <kread@chiquita.com>
To: <jdelistml@jdelist.com>
Sent: Thursday, May 10, 2001 6:03 PM
Subject: Re: Data Dictionary


from 4 to 2 on one field. I found that it affected the values that actually
printed. It moved the decimal over 2 positions and caused all kinds of
headaches. Lesson learned - don't change the data dictionary.
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=1
0547
 
Top