My client uses UniData (Pick type of people say not much different from Unverse), they'd like to export their UniData data to SQL Server or the like for easy view etc. I've set up an ODBC connection to the UniData server, then used VSG (Visual Schema Generators) to map UniData mv data into relational data set, then DTS it to SQL Server. All works, almost beautiful except that, by default, VSG makes all columns nullable. Well, in my data transformation process, I can take care of that, but I thought it would be a better way/more efficient way to be able to configure column nullability from VSG, it looks like it can't but that's OK.
Thanks though. BTW, what does RedBack do? schema translation?
Regards,
Don Li
>We run U2(Universe) MVDB. I dont understand your question though.
>Our Configurations are (U2 + RedBack + CF5.0 and U2 + JDBC + CFMX)
>
>What are you trying to accomplish?
>
>Joe Eugene
>----- Original Message -----
>From: Chunshen (Don) Li
>To: CF-Talk
>Sent: Sunday, November 02, 2003 5:24 PM
>Subject: Might be OT: MVDB -- UniData etc.
>
>
>Hi,
>
>I hope this is not OT since it is really another type of database that
>required CF as a middleperson. Something weird. I couldn't find two
>postings and others' followups on this subject posted a few weeks ago.
>Try do a key word search of "MVDB" or "UniData", it won't find
>anything while my previous postings has included them in the subject
>line.
>
>Related question for those who followed up on the topic, I'd
>appreciate your thought/input. VSG v3.1, for any view created, each
>column is set to NULLABLE, well, my requirement is such that I want
>the [ID] column to be NONNULLABLE or NULLABLE value set to N | 0.
>This version of VSG does not seem to have the feature of resetting
>NULLABLE value. Is this understanding correct?
>
>If so, how could I achieve the same thing from UDT? VOC file? Help
>me to beat this "beast" :)
>
>Thanks.
>
>Don Li
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
