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.

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.

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.

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

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

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

1 Answers   TCS,

There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.

0 Answers  

what is open data base command

1 Answers   Active Brains, Cognizant, CSC, CTS,

How to index LF by relative record no (RRN)

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  

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

4 Answers   HSBC,

How to retrieve a physical file after deleting that ? what is keyword used for that....??

6 Answers  

Why journalling is compulsory before commitment control?

1 Answers  

can any one tell me what is meant by PSSR? Kindly elaborate it...

1 Answers  

What is the interactive job? What is the batch job? How to change the batch job to interactive job?

0 Answers  

What is the batch job?

0 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,