WHAT IS THE DIFFERENCE BETWEEN 'COLHDG' AND 'ALIAS'?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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)
how to know total no of records in pf with out using sql??????
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
How to read a PF in reverse(from last rec to first) using CL?
what is use of self join and which cases you will use this join
what is multiple member pf
How to find the list of source physical files in a library?
What is the interactive job? What is the batch job?
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.
Define interactive jobs and batch jobs
Is it possible to create a logical file whose Physical file is not in same library?