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...

CRTDTA AND CRTARA should be used along with?

2 Answers  

How many maximum record format a logical file have?

0 Answers  

what is general and type of general

1 Answers   Active Brains,

how can i know logical file belongs to which physical file without source?

4 Answers   Cap Gemini,

When we use any keyword like FIFO,LIFO, at file level but whenever we check by runqry we couldn't find answer in FIFO,LIFO,FCFO etc so how we check the answer.

2 Answers  

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

1 Answers  

can we concate fileds in physical file? If yes how can we do?

5 Answers   Patni,

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

0 Answers  

There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.

0 Answers  

what is the intractive job? what is the batch job ? how to change the batch job to interactive job?

2 Answers   Four soft,

how to update physical file using logucal file with example

1 Answers   Wipro,

When we create a pf and did not fill up maint parameter, then by default which access path will the system take & why?

0 Answers