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

can any one pls tell me some differences between a LF and command OPNQRYF?

3 Answers   Accenture, Cognizant, eFunds,


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

9 Answers  


how to know total no of records in pf with out using sql??????

3 Answers  


how to see number of logical files depending on a pf?...can we declare more than 20 logical files from a single pf? is it possible

4 Answers   ocbc,


How to read a PF in reverse(from last rec to first) using CL?

3 Answers   HCL,






what is use of self join and which cases you will use this join

1 Answers   TCS,


what is multiple member pf

1 Answers   Active Brains,


How to find the list of source physical files in a library?

0 Answers  


What is the interactive job? What is the batch job?

0 Answers  


If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by doing the run query of the file? if not how can we see the impact of these keywords.

2 Answers  


Define interactive jobs and batch jobs

6 Answers  


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

6 Answers  


Categories