[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ulysse::rdb_vms_competition

Title:DEC Rdb against the World
Moderator:HERON::GODFRIND
Created:Fri Jun 12 1987
Last Modified:Thu Feb 23 1995
Last Successful Update:Fri Jun 06 1997
Number of topics:1348
Total number of notes:5438

498.0. "conversion ENTREPRISE DB -> RDB/VMS" by KETJE::VANTRICHT (Eddy VAN TRICHT) Fri Nov 17 1989 15:27

Does anyone has information using Cullinet (now COMPUTER ASSOCIATES)
4gl tools (KnowledgeBuild -> now  CA-DB:GENERATOR) with Rdb.

Specially i am searching if there exist :
        - any restrictions (dictionary usage,data types,...)
        - vs. advantages   (price, performance,...)
when using those tools with Rdb instead of IDMS/SQL 
(IDMS/SQL then called Entreprise DB -> now CA-DB/VAX).

The reason for this is that our customer is complaining about the
SUPPORT and ENHANCEMENTS planned for those products by Computer Associates
compared to the excellent support they received previously from Cullinet.
  
This could be a unique opportunity for us to propose them to switch over to Rdb
but this strategy can only work if no or minimal conversion effort is required.
T.RTitleUserPersonal
Name		DateLines
498.1CULLINET replyTHAM02::THUMRONGMon Nov 27 1989 04:0126
    
    Hi !
    
    I have some information about Cullinet 4 GL tool.
      They have 2 product for Cullinet 4GL tools
    	1. Enterprise/Generator
    		This product is same as Cobol/Generator but it can
                generatror more language such as cobol, fortran, basic .
    	2. Enterprise/BUilder 
    		This product is for screen design , report etc.
    
    - KNOWledge/BUILD can work with Rdb but check for KNOWledge/BUILD
    version 1.2 is OK.
    
    - KNOWledge/BUILD has their own dictionary they call Application
    Dictionary use to store screen , report , PSR program etc, so you must
    have 2 data dictionary for 1 system ( Rdb and KNOWledge/BUILD ).
    
    - Caution for reserve word use with Rdb, I think "S_".
    
    - Performance Rdb is better , we can do more for Physical Database
    Design.
           
    
    -
498.2additional specific questionsKETJE::VANTRICHTEddy VAN TRICHTWed Nov 29 1989 13:0013
Thanks for your reply,
could you help me further with following questions :

1) Can Knowlegde/Build access the Rdb system relations or Rdb def. in CDD/PLUS
   in order to obtain the definition of fields, relations, constraints in Rdb ?

2) If you have a running applications written with KNOWLEDGE/BUILD 
   and using IDMS/SQL as database and you want to convert this application
   to use Rdb  :
   a) what needs to be changed in the KB Application Dictionary ?
   b) do you need changes in the KB application or can you simply point to
      Rdb by use of a logical name?
498.3<< kb & rdb specific >>THAM02::THUMRONGTue Dec 12 1989 03:5842

	Hello.
	
	I'm sorry to answer your question too late.
	
	Let's back to your question.

	1. We have 2 way to define Rdb database for KB.
		- used data definition tool in KB menu.
		  ( to define table, index, field )
                  ( this tool generate VAX SQL command to manipulate rdb ).
                  
	 	- used VAX SQL command in SQL tool menu.
		  ( create, alter, drop )

	  CAUTION.
		Name of field, table, index in Rdb can't
		- excess 18 character.
		- include $ character.
		- start with S_ character.

		KB used this rule to maintain system name in  Rdb, such as
			S_RDB_TAB
			S_RDB_VIEW
			S_DATABASE 

		KB set up new application dictionary for Rdb, so i think it
                couldn't work with cdd plus but we can used data defininton
		menu create field, table, constraints .  

	2.a. We have 2 dictionary for database ( one for IDMS/SQL , one for
	     Rdb & RMS ) so we don't have to change anything in KB application 
	     dictionary).  

	2.b  Only modify login.com to 
		$ DEFINE RDB_DATABASE dbname.



thumrong