Solved

Help with DB2 V5.2

Posted on 2000-04-27
6
317 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Read about achieving the basic levels of HRIS security in the workplace.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
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…

839 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