Answer / afnas

Both(COLHDG & ALIAS) are used to identify fields.COLHDG &
ALIAS is the Description of fileds.the diference is that in
ALIAS we can access data based on that ALIAS name,while
COLHDG is not allowed.suppose in PF field name as
DES78,give ALIAS as Description78,then user can access data
from using Description78.

Answer / nupur

Allias is an alternate name for the field in PF. We can
access data with the new name. while colhdg is just a text
management which is visible at a time of query, SDA, DFU,
etc.

Answer / suju

using ALIAS name we can access the data,but we cannot
access the data using COLHDG.maximum number of COLHDG for a
particular field is 3.

Answer / viney

both give a meaning 2 d fld..while colhdg just gives a
heading to d fiels name represented in quotes.......alias
gives an alternate name 2 d field...this name given in
alias can also be used 2 search d variable...if required

Answer / gatla

PF::A R RCD
A NAME 9A ALIAS(YOUR)
A AGE 2P COLHDG('IN YEARS')


OUTPUT: 000001 KARU 57
000002 LAV 24
000003 MAI 24

I THINK NOW YOU HAVE CLEAR IDEA.... RIGHT...

In how many ways we can create a logical file?`

5 Answers  

how to update physical file using logucal file with example

1 Answers   Wipro,

what is dynslt and why we use that command when do we use command

2 Answers   Active Brains, UHG,

How to change the batch job to interactive job?

0 Answers  

how to add a new field to a file without compiling it?

1 Answers  

1. How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name? 2. How to differentiate between the types of join from a Join logical file DDS. Is it possible to have different types of Join Logical files? 3.Any performance difference between Opnqrf and Embedded SQL? When I should prefer Opnqryf and when SQL? 4. I know access path is the path chosen by the program to retrieve data. It can be of keyed access path or arrival sequence. *IMMED- *IMMED description says access path is updated each time record is added or deleted from a member. - What is updating here? *REBLD - The access path is completely rebuilt each time a file member is opened. The access path is maintained until the member is closed, then the access path is deleted. - I am not able to understand this completely. Could anyone explain these more clearly? 5.What is the purpose of using activation group. I know it is a resource allocator, but other than this any other benefits of using an activation group?

2 Answers   IBM,

Maximum how many fields we can create under a record format of PF?

5 Answers  

CRTDTA AND CRTARA should be used along with?

2 Answers  

What is FORMAT keyword and its use?

0 Answers  

what is the difference between adding keys & constraints into a phisical file

4 Answers   HSBC,

Can we concatenate fields in physical file? If yes how can we do?

0 Answers  

can any one tell me what is meant by PSSR? Kindly elaborate it...

1 Answers