> >Best answer: don't use sub-values. They're evil, anyway. > I've been somewhat "surprised" over recent years by the number of software companies that not only use SVM, but go down a level or 2 from that !
If you are using the "standard" inbuilt facilities of ANY of the mv systems, they have never coped well with SVM - but I wouldn't necessarily say they are "evil". Indeed some of the ways I've seemed them used to map real world problems simplify the issues at hand, and can help render better performance. To NOT use multi-values in an MV database to a certain extent diminishes one of the major arguments for using mv in the first place, doesn't it ? You are already compromising your design (perhaps) because of your choice of tool. Perhaps we should all capitulate & start to use flat CSV files ? Ross Ferris Stamina Software Visage – an Evolution in Software Development >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >Behalf Of Geoffrey Mitchell >Sent: Saturday, 17 April 2004 4:06 AM >To: U2 Users Discussion List >Subject: Re: UV to Text Conversion Standard? > >To my knowledge, no. Not in Universe anyway. I *think* (from the docs, >I've never played with it) that UniData has a way to map sub-values to >ODBC/JDBC, but UniVerse does not. Multivalues work fine, but it doesn't >go any lower than that. > >Best answer: don't use sub-values. They're evil, anyway. > >On Fri, 2004-04-16 at 12:48, [EMAIL PROTECTED] wrote: > >> Thank you, but what is the exact method to do this? >> I have never seen a "view of SVM level data" that actually works. >> Using ODBC or any other tool >> And by "works" I mean that it understands the relationship of the SVM >data to the VM data and the relationship of that to the AM data and >properly processes table-in-a-table configurations for editing, etc. >> >> It's one thing to use BY-EXP to understand VM level tables, but can you >really use some tool to understand SVM embedded data at that second table >level? >> Will >> >> >> In a message dated 4/16/2004 1:03:17 PM Eastern Daylight Time, >[EMAIL PROTECTED] writes: >> >> > Will, >> > >> > I'm not sure if this is what you're asking but all it does is create a >> > "virtual" view of the data into 1nf tables that Excel (in this case) >sees >> > and understands. >> > >> > Note: I have only done this with UniData and D3 and I know UniVerse >does it >> > a little differently. >> > >> > -- >> > Colin Alfke >> > Calgary, Alberta Canada >> > >> > "Just because something isn't broken doesn't mean that you can't fix >it" >> > >> > Stu Pickles >> > >> > >> > >-----Original Message----- >> > >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >> > >Sent: Friday, April 16, 2004 9:26 AM >> > >To: [EMAIL PROTECTED] >> > >Subject: Re: UV to Text Conversion Standard? >> > > >> > > >> > >In a message dated 4/15/2004 12:52:51 AM Pacific Daylight Time, >> > >[EMAIL PROTECTED] writes: >> > > >> > > >> > >> You can use the UniVerse ODBC Driver to pull the data from >> > >UniVerse to >> > >> Excel, using correct dictionaries UniVerse will normalise >> > >the data and sort >> > >> out the VM and SVM for you. >> > > >> > >Jonathan can you give a exact method for "sorting of >> > SVM's" >> > >within Universe >> > >using an ODBC (or really any tool). >> > >I am not aware of this >> > >Thank you >> > >Will >> > -- >> > u2-users mailing list >> > [EMAIL PROTECTED] >> > http://www.oliver.com/mailman/listinfo/u2-users > >-- >Geoffrey Mitchell 314-684-1062 >Programmer/Analyst [EMAIL PROTECTED] >Knights Direct > > >--- >Incoming mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.658 / Virus Database: 421 - Release Date: 9/04/2004 > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.658 / Virus Database: 421 - Release Date: 9/04/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
