Hi Satya When you LIST a file, the database shows you one of a number of things.
1. If you are on UniData and have an @UQ phrase, it will show that. 2. If you have an @ phrase, it will show that. 3. If not, it will show the key field (@ID). Now, the @ and @UQ phrases are known as the default listing. The idea of this is to give an indication of what the file holds - not all the fields in the file as that be a pain to look through, but just enough to give a sense of the main fields. So you have a number of choices: 1. Change the @ID field so it only returns the first part. Bad idea - it will confuse others who expect to see and select the whole key. 2. Create an @ phrase to make the default listing. That is generally okay so long as everyone knows that is what is being shown. 3. Create your own phrase and use that i.e. LIST FILENAME SATYA For (2) and (3) you can word your phrase like this assuming you are on UniVerse or UniData in ECLTYPE U: 1> PH 2> EVAL "@ID['*',1,1]" ID.SUP That will give you just the first part of the @ID field. Brian -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sathya Sent: 26 March 2013 14:32 To: [email protected] Subject: [U2] List.. Hi all,.. I have a small issue in listing a file. When I use LIST FILENAME, the data comes like 123456*001 123456*001. I would like to display the data as 123456 123456 Can someone please help me in doing this? TIA, Sathya V. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
