HELP: new to db2 5.2 
Author Message
 HELP: new to db2 5.2
Hello

I am completely new to db2 and databases generally speaking.

I installed db2 5.2, created a database but I can't find a way to enter new
datas in the database!

I am starting from scratch, have no other databases or datas elsewhere on my
computer, I have to enter my new datas somewhere/somehow!!!

Any help is welcome

Thanks

Pat



Mon, 14 Oct 2002 03:00:00 GMT
 HELP: new to db2 5.2

Well, how far did you get?
Do you have the sample database running and you worked through the first
steps?
Getting Don Chamberlin's book:
"A complete guide to DB2 Univeral Database" from Morgan Kaufman might be
helpfull. It's easy to read and has many examples....


Mon, 14 Oct 2002 03:00:00 GMT
 HELP: new to db2 5.2
Yes, I had the sample database running but it doesn't tell me how I enter MY
datas in MY database.

It's pretty much limited at the script, modify the command, doesn't say how
to enter a name/date whatever in my columns.

Patricia


Quote:
> Well, how far did you get?
> Do you have the sample database running and you worked through the first
> steps?
> Getting Don Chamberlin's book:
> "A complete guide to DB2 Univeral Database" from Morgan Kaufman might be
> helpfull. It's easy to read and has many examples....



Mon, 14 Oct 2002 03:00:00 GMT
 HELP: new to db2 5.2
Where did you find the DB2 version 5.2 software.  I am currently
looking for that version and can only find version 6.1.  Just curious.

* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!



Mon, 14 Oct 2002 03:00:00 GMT
 HELP: new to db2 5.2
I got it from IBM few months ago before 6.1 was available.

Strange you are looking for an old version....

BTW: do you have an answer to my Q? Once a database is created with DB2 I am
supposed to be able to enter data with the same DB2 or not?

I am inquiring where I can and the last answer I got was " I have to create
my databases with DB2 then enter datas with Access.." This doesn't make
sense.

Pat


Quote:
> Where did you find the DB2 version 5.2 software.  I am currently
> looking for that version and can only find version 6.1.  Just curious.

> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!



Mon, 14 Oct 2002 03:00:00 GMT
 HELP: new to db2 5.2
.. you can enter data into DB2 using the command center or CLP to
issue SQl commands. For DDL (such as CREATE TABLE) you can use
the control center or the CLP.
It is in fact fairly common that people use Access as a front end to
create forms that help to enter data into DB2. But, since there is
likely some setup required it
would be good if you started to play with SQL first, before putting
apllications on top of DB2.

Cheers
Serge



Mon, 14 Oct 2002 03:00:00 GMT
 HELP: new to db2 5.2
Quote:
> I am supposed to be able to enter data with the same DB2 or not?

No, you are not.
With Access or Clipper or Fox or xdb you get a file system bundled
with a small programming system. Those bundles are called "database".
In bigger IT shops, the database is just that: a database. A program
that manages data. It does it much better that the other mentioned,
has better security, is much more solid, can handle many times more
data, and interfaces with many programming systems like for example
Visual Basic but also COBOL, C, C++, Java, and counting.
We write specialized programs so the users can enter and query the
data.
One way to get data into and from Db2 is to use a smaller system as a
front end, like Approach or Access. This will let you write YOUR data
w/o writing a program.
Approach comes with IBM's Lotus' Smart Suite and connects well to Db2.
Or you can connect your database thru ODBC and work with many other
tools like Access or even Excel.
Good luck
--
Juan Lanus
TECNOSOL


Tue, 15 Oct 2002 03:00:00 GMT
 HELP: new to db2 5.2
Well, thanks to everybody.

Finally got the answer, so I can't enter anything in my DB2 database with
the same Db2, my last hope is to be able to enter datas with Cold Fusion!

Thanks for your answers.

Pat


Quote:
> > I am supposed to be able to enter data with the same DB2 or not?
> No, you are not.
> With Access or Clipper or Fox or xdb you get a file system bundled
> with a small programming system. Those bundles are called "database".
> In bigger IT shops, the database is just that: a database. A program
> that manages data. It does it much better that the other mentioned,
> has better security, is much more solid, can handle many times more
> data, and interfaces with many programming systems like for example
> Visual Basic but also COBOL, C, C++, Java, and counting.
> We write specialized programs so the users can enter and query the
> data.
> One way to get data into and from Db2 is to use a smaller system as a
> front end, like Approach or Access. This will let you write YOUR data
> w/o writing a program.
> Approach comes with IBM's Lotus' Smart Suite and connects well to Db2.
> Or you can connect your database thru ODBC and work with many other
> tools like Access or even Excel.
> Good luck
> --
> Juan Lanus
> TECNOSOL



Tue, 15 Oct 2002 03:00:00 GMT
 HELP: new to db2 5.2
You can enter data using sql insert statements in the command line processor
or command center.  You can also import delimited ascii, ascii, ixf, ad wsf
(spreadsheet) files.
Quote:

> Well, thanks to everybody.

> Finally got the answer, so I can't enter anything in my DB2 database with
> the same Db2, my last hope is to be able to enter datas with Cold Fusion!

> Thanks for your answers.

> Pat



> > > I am supposed to be able to enter data with the same DB2 or not?
> > No, you are not.
> > With Access or Clipper or Fox or xdb you get a file system bundled
> > with a small programming system. Those bundles are called "database".
> > In bigger IT shops, the database is just that: a database. A program
> > that manages data. It does it much better that the other mentioned,
> > has better security, is much more solid, can handle many times more
> > data, and interfaces with many programming systems like for example
> > Visual Basic but also COBOL, C, C++, Java, and counting.
> > We write specialized programs so the users can enter and query the
> > data.
> > One way to get data into and from Db2 is to use a smaller system as a
> > front end, like Approach or Access. This will let you write YOUR data
> > w/o writing a program.
> > Approach comes with IBM's Lotus' Smart Suite and connects well to Db2.
> > Or you can connect your database thru ODBC and work with many other
> > tools like Access or even Excel.
> > Good luck
> > --
> > Juan Lanus
> > TECNOSOL



Tue, 15 Oct 2002 03:00:00 GMT
 
 [ 9 post ] 

 Relevant Pages 

1. DB2 Newbie needs help with DB2 5.2 ODBC: can browse schema, but get no data

2. Error in Java Program, when it accesses DB2 UDB 7.2 from DB2 UDB 5.2 Client

3. Connecting to db2 v7.1(linux) from db2 5.2 cc(nt)

4. Connect to db2 5.2 Server from db2 7.1

5. Help - Crash DB2 v 5.2 FP15 (WR21217)

6. Migrating from IBM DB2 5.2

7. SQL Server 7.0 to DB2 5.2 connection no working

8. DB2 UDB 5.2 and Decimal Fields

9. Java DB2 5.2 known bugs

10. ADO 2.5, DB2 5.2, MTS Testing

11. ADO 2.5 & DB2 5.2

12. any success using VB6-ADO-DB2 5.2


 
Powered by phpBB® Forum Software