FYI: You can see any VOC entry by just typing: .L RELLEVEL
or something else, like: .L LOGIN This command is also not case sensitive, so typing: .l rellevel will return the same file. Karl <quote who="Jerry Banker"> > If you want to find out what release of uniVerse you are on and can get to > the TCL level (the command level usually a > symbol) type in using all > caps: > ED VOC RELLEVEL > then type in P with a return to print the lines you will something like > the > following, you type in Q to quit then release level is on the second line: >>ED VOC RELLEVEL > 5 lines long. > > ----: P > 0001: X > 0002: 9.6.2.3 > 0003: REALITY > 0004: REALITY.FORMAT > 0005: 9.6.2.3 > Bottom at line 5. > ----: Q > > Jerry > ----- Original Message ----- > From: "Wong, Howard" <[EMAIL PROTECTED]> > To: <[email protected]>; <[EMAIL PROTECTED]> > Sent: Tuesday, March 15, 2005 11:52 AM > Subject: RE: [U2] RE: > > > Andrew, > > Thanks for your suggestion. I'll forward it to the team for considering > adding to the list of possible solutions. > > Regards, > Howard Wong > Asset Management > 416-784-8728 > [EMAIL PROTECTED] > > > > -----Original Message----- > From: Andrew Lakeland [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 15, 2005 12:03 PM > To: [email protected]; '[EMAIL PROTECTED]' > Subject: RE: [U2] RE: > > > A few years back I did an archive system for someone, I restored their > AIX > database straight onto a PC from Tape and then saved the database onto DVD > as a zip file. I did this for various end of months, they then unzipped > which every file they needed back from the DVD to the hard disk and the > system was back to which every point they needed. > > It was a lot cheaper than migrating and they simply have a 4 user license > on > a PC. > > Also remember which ever option you choose you will need to know the > database. Migrating can be very labour intensive which would probably > incur > most costs. > > As you need to know the database which ever route you take, I'd suggest > you > document it and get someone to do your extractions when and IF you need > them. > > You can also get someone to setup an ODBC link to your universe database > so > your could build your own reports from EXCEL, for example. Once the files > are setup for access they are automatically flattened and appear in an > MSquiry as list of files and fields. > > Regards > Andy > > > > > > -----Original Message----- > From: Wong, Howard [mailto:[EMAIL PROTECTED] > Sent: 15 March 2005 17:09 > To: '[EMAIL PROTECTED]'; [email protected] > Subject: [U2] RE: > > Hi David, > > Your feed back is much appreciated. > > The old app was on an AIX box (v 4.3). We were migrating to AIX 5.0, but > at > the time it was suggested that the app could be migrated from AIX 4.3 to > AIX > 5.0. So a new app written in Progress replaced it. There was nothing wrong > with the app. We do not know why newer version of UniVerse (if it was > available) was not used for the migration instead. > > The AIX 4.3 box will be replaced either by a new AIX box or new Solaris > box, > the latter being our new institution-wide standard. > > The old app and DB was kept around because we still inquire on the older > data from time to time. So we don't need full blown app development but > just > need to extract the data for inquiry purpose. > > BTW, we have no idea which version of UniVerse was used to develop the old > app. > > Regards, > Howard Wong > Asset Management > 416-784-8728 > [EMAIL PROTECTED] > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 15, 2005 10:27 AM > To: [email protected] > Cc: Wong, Howard > Subject: RE: > > > HW> Am I on the right track? Can someone tell me if: > HW> 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) > correct? > > Yes .. back several years this was true > > HW> 2) If (1) is good, then is the IBM UniVerse DB the successor of the > VMark > HW> UniVerse DB? > > Yes .. this is also true > > HW> 3) If (2) is correct, then is there any tool or utilities that can > either > HW> (a) extract the structure and content of the database and perhaps > migrate > HW> them to another DBMS (Unix or Windows), > > There are those of us (like myself and my associates) to do data > migration from/to MV/Sql and we have *some* tools which make the > conversion easier. The real problem is understanding your current > *structure*. Although there are *tools* which can help with this it > does take time to analyse. Moving from the MV world (uniVerse) to the > relational world is not simple but doable .. the real work, as I > mentioned is the analysis. Without good documentation on your system > this will take some time. > > I would have to ask (not trying to sell either way), other than having > an old box that needs to be replaced .. are there any other reasons for > moving away from MV. Does the application do all you need it to do. > Are the connectivity problems with other applications? OR are you > simply looking for an 'updated' system. > > HW> or (b) let us understand the structure and content of the DB? > > Once again, there are no specific tools that I know of for this process. > Those of us in the business have our own tools to do this type of > thing. > > Possibly a better understanding of where you are trying to get to would > help us give a better answer. > > > > DSig > David Tod Sigafoos > SigsSolutions, Inc. > > >> -------- Original Message -------- >> Subject: >> From: "Wong, Howard" <[EMAIL PROTECTED]> >> Date: Tue, March 15, 2005 6:45 am >> To: "'[email protected]'" <[email protected]> >> >> To all, >> >> I posted to the Chatter forum but was advise that the mail list would >> have >> wider audience for my question. My original post. In a nutshell, we know >> nothing about UniVerse, but need to keep the data and move them to a >> newer >> server, Unix or otherwise. >> >> Our plan is to convert the data into a mainstream DBMS, e.g. SQL Server, >> DB2, etc. But further research after my original post indicates that it > will >> be very involved. Since we don't know how the data is organised in the >> DB, >> we have to assume for the worst case. I'm afraid multivalues and >> subvalues >> will trip us up. Updating to a new version of UniVerse is probably going > to >> solve the problem, but I doubt the manager would have the appetite to > spend >> good money just to be able to read the very old data. >> >> Please read the original post for details,. Again, any help is much >> appreciated. >> >> Sincerely, >> Howard Wong >> [EMAIL PROTECTED] >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> Original Post: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> We have a very old Unix server that has to be decommissioned. On it is >> an >> application that has long since been migrated to a newer app and UNIX >> platform. This old app is kept around for reference, and is not being >> actively updated. >> >> We have to replace the old Unix box, so the old app has to migrate too. >> Trouble is the app uses a database called VMark, which no one around >> here >> knows anything about. >> >> I did some research on the Net and it seems that VMark was a company >> name, >> and its database product was UniVerse. Further searches brought me to >> this >> site. >> >> Am I on the right track? Can someone tell me if: >> 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? >> 2) If (1) is good, then is the IBM UniVerse DB the successor of the >> VMark >> UniVerse DB? >> 3) If (2) is correct, then is there any tool or utilities that can >> either >> (a) extract the structure and content of the database and perhaps >> migrate >> them to another DBMS (Unix or Windows), or (b) let us understand the >> structure and content of the DB? >> >> Any help is much appreciated. Please feel free to email me. >> >> Sincerely, >> Howard >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> ------- >> u2-users mailing list >> [email protected] >> To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
