Dattatraya, As others have said it sounds like you need more background knowledge of unidata in general. Unidata comes with some good pdfs for this kind of thing - certainly explaining basic concepts such as dictionary items. Try looking in UDTD.pdf - Using Unidata. This is available for download, try googling for it.
To answer your question: You can list the data in the n'th attribute (field) of a file with LIST filename F1 F2 Fn These generic Fn dictionary items live in the VOC. The VOC being a central file defining a whole bunch of things including dictionary items that can then be used against any file. If you get a message saying 'Illegal attribute name: Fn' then you won't have the Fn item set up. You can add it manually by, for example attribute 2: AE VOC F2 Top of New "F2" in "VOC". *--: I 001= D 002= 2 003= 004= 005= 10L 006= M *--: FI Filed "F2" in file "VOC". : Note that to enter the blank lines (lines 3 and 4) you need to use the backquote character (`)- the key to the left of the 1 key on UK (& international?) keyboards. Alternatively, you can look at data in individual records with a couple of commands: Try CT filename recordname to Copy to Terminal the contents of the record. Try AE filename recordname to edit the record - press P<enter> to see lines. Press ? for help on all other commands. Hope this helps Edward -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dattatraya Walgude Sent: 07 October 2009 04:58 To: U2 Users List Subject: Re: [U2] How to check data dictionary? 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 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of George Gallen Sent: Tuesday, October 06, 2009 10:47 PM To: U2 Users List Subject: Re: [U2] How to check data dictionary? I think he is getting caught with a file that doesn't have a very well defined DICT file, whereas with SQL You can't really add anything to a table without being able to see a description of it. Life in UV is not like life in SQL. > -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of Norman Bauer > Sent: Tuesday, October 06, 2009 12:41 PM > To: U2 Users List > Subject: Re: [U2] How to check data dictionary? > > Along the lines of what David suggested, I would also recoment reading > the System Description PDF that is provided in the documentation as > well as the Guide to Retrieve. > > I am not sure exactly what you are asking, but the only way that I > know of to check the dictionary (in UniVerse, not sure about UniData) > is: > > LIST.DICT filename > > Which will give you all the information on what data is stored in the > file as well as information of I-Descriptors, which are virtual fields > and I suspect that is what has you hung up. The Systems Description > guide goes into detail about I-Descriptors as well. > > Norm > > On Tue, Oct 6, 2009 at 3:42 AM, Dattatraya Walgude > <[email protected]> wrote: > > Dear ALL > > > > We are working on UNIDATA version 6 and we need your guide line. > > > > > > > > One of the table is having many multivalve columns but by LISTDICT I > can > > not see. These columns have data but vendor program is showing all > > columns data. As I do not know column name then let me know how to > see > > the other columns? May I need to update dictionary to table to see > > column name or suggest any other ways > > > > By LISTDICT I can not see all column names. > > > > > > > > My questions are:- > > > > > > > > 1) How to check data dictionary? > > > > 2) How to select / extract data form this tables ( for all columns > like > > oracle select * from )? > > > > 3) How to remove extra space from column ( like oracle Trim() ) > > > > > > > > Your suggestions are most well-come and waiting for your positive > reply. > > > > > > Regards > > > > Dattatraya > > > > > > > > Thanks & Regards, > > Dattatraya Walgude > > DBA Team > > Rsystems International Ltd, Pune, > > * : +91-20-22909212 > > > > > > > > > > **************** Disclaimer ***************** > > > > > > > > > > This mail, including any attachments contains confidential and > privileged information for the sole use of the addressee(s). If you are > not the intended recipient, > > > > please notify the sender by e-mail and delete the original message. > Any unauthorized review, use, disclosure, dissemination, forwarding, > printing or copying of > > > > this email or any action taken in reliance on this e-mail is > strictly prohibited and are unlawful. This e-mail may contain viruses. > R Systems International Limited has > > > > taken every reasonable precaution to minimize this risk. R Systems > International Limited is not liable for any damage you may sustain as a > result of any virus in this e-mail. > > > > Before opening the e-mail or attachment, You should carry out your > own virus checks. R Systems International Limited reserves the right to > record, monitor, and inspect > > > > all email communications through its internal and external networks. > R Systems International Ltd prohibits its information systems from > being used to view, store or forward > > > > offensive or discriminatory material. > > > > > > > > ******** End of Disclaimer ******** > > > > _______________________________________________ > > 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 _______________________________________________ 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
