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
