Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Location
    UAE , AD
    Posts
    8

    Post Unanswered: General Information .. !!

    Hello everybody ,,,
    This is my first post in dbforums , but it won't be the last ..

    I can not see any general information about DB2 in this forum ,, !!

    Well, some specific information about DB2 can not be easily found on the Internet , thus I would really appreciate answers for the following basic questions ... ?


    1) When was DB2 established (released) .. ?

    2) What is the latest version of DB2 and when was it released ?

    3) How many fields can DB2 (latest version) support (scalability) ?

    4) What software development tool (web application) does is support such as ASP, ASP.NET ..etc ?

    5) What software development tool (windows application) does is support like C, C++, JAVA etc ... ?

    6) What OS platforms does it operate on ?

    7) How much it costs (latest version) ?

    ___________

    I believe that answering these information would be very helpful to a lot of users especially for those who want to use DB2 ..

    I hope that the answers are numbered (1-7) like the questions . . .

    Thanks in Advance ..

  2. #2
    Join Date
    May 2003
    Location
    Toronto
    Posts
    29
    you can get most of your information from this forum and the following link:
    http://www-306.ibm.com/cgi-bin/db2ww...dex.d2w/report

    good luck

  3. #3
    Join Date
    Apr 2004
    Posts
    54
    Everything you asking for you can find there:
    you should visit http://www.db2click.com
    as well as http://www.ibm.com

    But the only thing I want to notice -
    The best way to develop applications for DB2 is EMBEDDED SQL;
    DB2 - the only database which supports Embedded SQL in C++.

    Example:

    class CConnect {
    public:
    EXEC SQL BEGIN DECLARE SECTION;
    char dbname[9];
    char dbuser[9];
    char dbpassword[9];
    EXEC SQL END DECLARE SECTION;

    bool connect() {
    EXEC SQL CONNECT TO ....
    }
    };


    class CMyRow {
    public:
    EXEC SQL BEGIN DECLARE SECTION;
    long RowID;
    char Name[50];
    EXEC SQL END DECLARE SECTION;
    EXEC SQL DECLARE CDN CURSOR WITH HOLD FOR
    SELECT Id,Name FROM Test ORDER BY Name;

    bool open() {
    EXEC SQL OPEN CDN;
    if (SQLCODE) return false;
    return true;
    }
    bool fetch () {
    EXEC SQL FETCH CDN INTO :RowID,:Name;
    if (SQLCODE) return false;
    return true;
    }
    void close() {
    EXEC SQL CLOSE CDN;
    }
    };

    std::vector<CMyRow> vec;
    CMyRow row;
    row.open();
    while(row.fetch()) vec.push_back(row);
    row.close();
    .
    .
    .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •