Missing dicts seems likely to me also. In our system we tend to create dicts only for fields we report / select on. File layouts are maintained in a bespoke editor, which in turn ties in with the way we use records from these files programmatically. So programmers tend to maintain the file layouts and dictionaries are usually an afterthought.
Edward -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Israel, John R. Sent: 07 October 2009 15:09 To: U2 Users List Subject: Re: [U2] How to check data dictionary? Here is an unlikely reason for the missing Dicts (I am assuming they are missing): Whoever created the fields did not want people to easily access them. For example, un-encrypted passwords. I seriously doubt this is the situation, but I thought I would just throw it out. My vote is still simply missing Dicts. John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH 45342 937-866-0711 x44380 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Colin Alfke Sent: Wednesday, October 07, 2009 10:05 AM To: 'U2 Users List' Subject: Re: [U2] How to check data dictionary? How do you know? What are you doing that you can see the data that you can't find? I'm with the other posters that believe that you're simply missing dictionary items (the UniData dictionary is DEescriptive *NOT* PREsriptive like Oracle). However, if they are in multi-value columns there are a couple of things that could be giving you grief: 1. The dicts are not properly associated or marked as multi-value 2. You're looking at the file through SQL and the multi-value data is setup in a subtable/view. Hth Colin Alfke Calgary, Canada -----Original Message----- From: Dattatraya Walgude The following command is not showing all data columns. LIST filename ALL The LISTDICT filename - Not showing all column names Now, from one of the filename, I have to extract data from hidden 3 columns which I can not see the names of column. Requesting you to suggest me in such cases how to extract/see data. I will be thankful to you, if you provide me all steps in details. This is urgent matter & my work is stuck. Thanks in advance. Dattatraya Walgude _______________________________________________ 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 ------------------------------------------------------------------------------------------- Please remember to recycle wherever possible. Reduce, reuse, recycle, think do you need to print this e-mail? ------------------------------------------------------------------------------------------- This e-mail and any attachment(s), is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the addressee, dissemination, copying or use of this e-mail or any of its content is prohibited and may be unlawful. If you are not the intended recipient please inform the sender immediately and destroy the e-mail, any attachment(s) and any copies. All liability for viruses is excluded to the fullest extent permitted by law. It is your responsibility to scan or otherwise check this email and any attachment(s). Unless otherwise stated (i) views expressed in this message are those of the individual sender (ii) no contract may be construed by this e-mail. Emails may be monitored and you are taken to consent to this monitoring. Civica Services Limited, Company No. 02374268; Civica UK Limited, Company No. 01628868 Both companies are registered in England and Wales and each has its registered office at 2 Burston Road, Putney, London, SW15 6AR. ------------------------------------------------------------------------------------------- _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
