Re: ALIAS Keyword in Physical File

[Brian Parkins <goodprophet.bp@xxxxxxxxx>]

Jorge, the problem is you are using DFU on the physical file. The DDS 
manual states:

The value specified [for DFT] is assigned to the field in the following 
cases:
- When the program does an output operation to a logical file based on 
this physical file and the record
format in the logical file does not name this field. <<<<<<<
- When you use the Initialize Physical File Member (INZPFM) command for 
a member in this file.
- When you use the Copy File (CPYF) command with FMTOPT(*MAP) specified 
and a field in the to-file
is not in the from-file.

You are using DFU on the physical file - so DFT('AV. AQP') is ignored 
and blanks are placed in DIREMP. If you used a logical file with DIREMP 
omitted from the record format, then DFT('AV. AQP') would be honoured. 
Try it for yourself.

Brian.

On 15/06/2019 05:38, Jorge Nizama wrote:
> Hi Barbara. You answer is good but  DFT doesnt set default values. I
> created a PF with this keyword but when I inserted 3 records with DFU, It
> looks empty in the field with DFT.
>
> R REGEMP
>    CODEMP        10P         ALIAS(CODIGOEMPLEADO)
>    NOMEMP        20A         ALIAS(NOMBREEMPLEADO)
>    DIREMP        20A         ALIAS(DIRECCIONEMPLEADO)
>                              DFT('AV. AQP')
> K CODEMP
>
> ....+....1....+....2....+....3....+....4....+....5....+....
> CODIGOEMPLEADO   NOMBREEMPLEADO        DIRECCIONEMPLEADO
>               1   jorge                 Parse
>               2   Scott                 Tigger
>               3   roxette
>               3   Dido                  kisses
> ********  Fin de datos  ********
>
> In DIRECCIONEMPLEADO should be completed with 'AV. AQP'
>
> Thanks!
> Jorge