WHAT IS THE DIFFERENCE BETWEEN 'COLHDG' AND 'ALIAS'?

Answers were Sorted based on User's Feedback



WHAT IS THE DIFFERENCE BETWEEN 'COLHDG' AND 'ALIAS'?..

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.

Is This Answer Correct ?    23 Yes 0 No

WHAT IS THE DIFFERENCE BETWEEN 'COLHDG' AND 'ALIAS'?..

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.

Is This Answer Correct ?    9 Yes 0 No

WHAT IS THE DIFFERENCE BETWEEN 'COLHDG' AND 'ALIAS'?..

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.

Is This Answer Correct ?    11 Yes 3 No

WHAT IS THE DIFFERENCE BETWEEN 'COLHDG' AND 'ALIAS'?..

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

Is This Answer Correct ?    1 Yes 0 No

WHAT IS THE DIFFERENCE BETWEEN 'COLHDG' AND 'ALIAS'?..

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

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More DB400 Interview Questions

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

4 Answers   HSBC,


Why journalling is compulsory before commitment control?

1 Answers  


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

1 Answers  


how to update physical files using normal logical file

4 Answers  


how to update physical file using logucal file with example

1 Answers   Wipro,






hi iam very new to as400. i had created one physical file can any one tell command to enter data in to that

9 Answers   Encore,


i have a PF,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in PF

3 Answers  


How can i retrieve city while my i have one field address length 60 but i don't know what where is city in this field ?

4 Answers  


Is it possible to create a logical file whose Physical file is not in same library?

6 Answers  


When u create a PF and did not fill up Maint parameter, then by default which access path will the system take & why

2 Answers   HCL,


one physical file can have how many max of logical files? what is the primary file?

3 Answers   Four soft,


What is the use of member in pf?

0 Answers  


Categories