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

How to know the perticular record in pf with out reading?

2 Answers   Cap Gemini,


What is the purpose of the chain and setll and setgt?

0 Answers  


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  


how to update physical files using normal logical file

4 Answers  


Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any duplicate records in this pf.Based on this pf one Logical file i have used.But this lf is viewing only 80 records only of that pf?What is the reason for this?Please give me answer?

4 Answers   IBM,






How to insert more than one record to a pf at a time?(Bulk insert to a pf)

9 Answers  


How to index LF by relative record no (RRN)

0 Answers  


What is the interactive job?

0 Answers  


What is the batch job?

0 Answers  


Where the QTEMP library will get created? if the the answer is QSYS, then howcome more than one job can create same library name(QTEMP) in QSYS? what is the uniqueness of QTEMP? For example, run the below command in different workstation WRKOBJ QSYS/QTEMP And take 8 in the option to check the description. both will have different info. so where(which LIB) exactly the QTEMP is stored?

2 Answers  


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

5 Answers  


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,


Categories