If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > General Information .. !!

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-13-04, 09:15
Juve_Heart Juve_Heart is offline
Registered User
 
Join Date: Apr 2004
Location: UAE , AD
Posts: 8
Post 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 ..
Reply With Quote
  #2 (permalink)  
Old 04-13-04, 10:14
ddlldd2000 ddlldd2000 is offline
Registered User
 
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
Reply With Quote
  #3 (permalink)  
Old 04-13-04, 10:19
gardenman gardenman is offline
Registered User
 
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();
.
.
.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On