Dattatraya, What do you mean by the 3 hidden columns? Are they fields that exist in the DATA files but have no DICT that defines the fields? If that is the case, you should determine what program is updating these fields, what type of data it is, then build the missing Dicts. This is simply an oversight on whoever wrote the program(s). It is sloppy coding, but we have all done it at one time or another.
Or, as Edward wrote, simply build three generic Dicts that point to these fields and figure out what they are later. Just to clarify what Edward wrote about the generic Dicts, be sure there is nothing in fields 3 and 4. This will simply dump the raw data out (so if it is a date or time, you will get the internal date or time). Again, U2 is not SQL. It is better in a lot of ways, not as good in others. Don't get too bogged down trying to treat them as the same thing. Similar, yes, but not the same. Good luck. 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 Edward Brown Sent: Wednesday, October 07, 2009 6:21 AM To: U2 Users List Subject: Re: [U2] How to check data dictionary? 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 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
