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 |
1. How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name? 2. How to differentiate between the types of join from a Join logical file DDS. Is it possible to have different types of Join Logical files? 3.Any performance difference between Opnqrf and Embedded SQL? When I should prefer Opnqryf and when SQL? 4. I know access path is the path chosen by the program to retrieve data. It can be of keyed access path or arrival sequence. *IMMED- *IMMED description says access path is updated each time record is added or deleted from a member. - What is updating here? *REBLD - The access path is completely rebuilt each time a file member is opened. The access path is maintained until the member is closed, then the access path is deleted. - I am not able to understand this completely. Could anyone explain these more clearly? 5.What is the purpose of using activation group. I know it is a resource allocator, but other than this any other benefits of using an activation group?
A pf containing 100 records... my query is how to display from 11th record in the pf?
How can we know that a trigger has been added on a PF? and what is the purpose of adding a trigger?
What is FORMAT keyword and its use?
one physical file can have how many max of logical files? what is the primary file?
What is the batch job?
Last statement of any rpg program is lr?
Suppose 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?
How to change the batch job to interactive job?
Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the concern is can the size of the file changes or it remains the same... kindly help me out with thorough xplanation.... Thanks in-advance...
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.
can we concate fileds in physical file? If yes how can we do?