Don,

RedBack is a Business Object Server. You can write Business Objects/Rules in
RedBack
that talks to U2 Database. Basically, you can consider RedBack as an
Advanced Level
of SQL Server Stored Procedure Programming, a little object oriented...takes
care of
connection pooling and all that stuff. Well MS-SQL Server T-SQL is not all
that great
compared to capabilities of Oracle PL/SQL Or Java Procedure capabilities
Joe Eugene

  -----Original Message-----
  From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED]
  Sent: Monday, November 03, 2003 2:46 PM
  To: CF-Talk
  Subject: Re:Might be OT: MVDB -- UniData etc.

  Joe,

  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]

Reply via email to