[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

1153.0. "AS/400 database - SQL/400" by PRESS1::SPERLING () Thu May 21 1992 22:42

    Does anyone have any information about SQL/400 (or what ever it is
    called) ?
    
    - Record level locking
    - Types of journaling
    - Call interface
    - Report writer
    - Multiple database support
    
    Does the AS/400 have:
    
    - an integrated data dictionary
    - Forms generation package
    
    Thanks for any help,
    
    Elizabeth Sperling
T.RTitleUserPersonal
Name		DateLines
1153.1A few answers...LARVAE::JONES_SDeclining fdl - ifdl,ufdl...Fri May 22 1992 09:3011
    AS400 has an integrated data dictionary, the whole machine's program
    development revolve around it.
    
    AS400 has an integrated forms package.
    
    It has a report write called Query built in.
    
    Hope this helps
    
    Steve J
1153.2STOHUB::DSCGLF::FARLOWSimplifyTue Jun 02 1992 18:3740
> Does anyone have any information about SQL/400 (or what ever it is
>   called) ?
 
Try the Competitive Hotline:  DTN: 297-3333

 IBM will position the AS400 system as a Database Machine.  However, our
 TPC-A database benchmark results are very strong compared to IBM.'s.
 
 IBM's journalling called Commitment Control is not very efficient, and 
 many customers don't user it.

 The SQL interface to the AS400 Db is relatively new and not that efficient - be
 careful about saying this though.

 There are very few 3rd Party CASE, SW development and 4GL tools available
 that work with the AS400 database.  Position it as a closed architecture and
 play up the number of tools available to work with Rdb. 

 Play up the SQL Services interface and the ability to develop PC Client Server
 applications as well as existing PC applications that have access to Rdb
 data (DECquery, DECreport, Lotus, Excel, FOCUS, Paradox).

 I have heard that the AS400 database is not truly a relational database 
 however I don't have the technical details to back this up.

 Mention the advanced database management and creation tools available with
 Rdb - RMU Utilities, RdbExpert, Graphical Schema Editor, InstantSQL, DECtrace.

 Don't forget Rdb On-Line Backup and sophisticated recovery capabilities - like
 restore to a specified time etc.  In the past the AS/400 has had a terrible
 reputation for extremely slow recovery times when disk failures have occurred.
 Also, mention high availability of Rdb data through clustering. 

 If the customer likes the automatic spreading of data across disks associated
 with the AS/400, talk about Disk Striping. 

 Hope this helps,

 Steve Farlow @STO
 DTN: 445-7212