Solved

Help with DB2 V5.2

Posted on 2000-04-27
6
289 Views
Last Modified: 2008-03-06
Hello

I am 100% to databases, I installed DB2 V5.2, created a database and... have no clue how to enter the datas!

I have no other database or datas elsewhere to import, I am starting from scratch, I have to enter the datas in my database but how?

Any help is welcome.

Thanks
wirefram
0
Comment
Question by:wirefram
  • 3
  • 2
6 Comments
 
LVL 54

Accepted Solution

by:
nico5038 earned 100 total points
ID: 2755817
Two simple thought's
1) Use series of INSERT statements.
2) Setup ODBC and use VB or Access as frontend.
0
 

Author Comment

by:wirefram
ID: 2756008
Well, where do I put INSERT?

Right now I defined a database, create a table with columns.

That's where I am so far using DB2 V5.2 personal edition on NT4.

What do I do next generally speaking. I don't have Access or VB.

I had in mind I could fill the columns I created.....

Please next explanation in plain clear english.

Thanks


0
 
LVL 54

Expert Comment

by:nico5038
ID: 2756114
As far as I know you define tables with CREATE TABLE ..... commands
In the same way you can give
INSERT INTO table (Field) VALUES ('test');

(Not sure about the syntax, check your help/manual)
 
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 2

Expert Comment

by:odessa
ID: 2763661
In plain english.

For what proposes do u wish to use the DataBase.

Now DB2 (in your case UDB) is a relation database engine, witch prime function is to store and serv data.

U can easily create databases tables and relations but data input&output is done by some Frontend or a by query.

Example input
insert into my_table (year, expense)
values (1997,1234.21)

Example for a output
select * from my_table

with a Some frontend like a Access, or a any application u can fave a more userfriendly interface.


0
 

Author Comment

by:wirefram
ID: 2765640
OK. I got my answer, I am only suprise as I believed I could enter datas with DB2 without utsing anything else.

Thanks. I'd like to close the question.

0
 

Author Comment

by:wirefram
ID: 2773102
In fact there is no way to enter datas with DB2 so I need another soft!

Thanks
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now