Re: Change PF Field text?

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

In SQL it is

LABEL ON COLUMN library/file (field TEXT IS 'text string')

To change column headings you omit the keyword 'TEXT'. The text string is 
limited to 60 characters and is divided into segments of 20 characters 
without regard to word breaks.

LABEL ON COLUMN library/file (field IS 'text string')

Logicals take on the column headings and text of the corresponding physical 
file, if not specified. I was not able to change the text with SQL over a 
logical that did not have its own. It has to be a view, table, or PF.

HTH

Vern

At 02:59 PM 6/5/2003 -0500, you wrote:

> I want to up change the field text description of a DDS physical without
> recreating the file and recompiling the associated programs.
> Is this possible?  SQL,? API?
> And would I have to do the same for the logicals or would they change when
> the physical Changes?
> field name:       Unuse1
> field text: Unused field1
> type:       Packed
> Length:           5  0
>
> J. Scott Carter
> Programmer/Analyst
> e-mail: Mailto:scarter@xxxxxxxxxxx
> Phone: 214.583.0348