|
View previous topic :: View next topic
|
| Author |
Message |
madhureddygs
New User
Joined: 03 Nov 2009
Posts: 2
Location: Chennai
|
|
|
|
Hi everyone,
I have one table and i want to practice with some SQL quiries. Please let me know what and all i've to create.  |
|
| Back to top |
|
 |
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
Hi Madhu,
Welcome to the forums!
If you already have a table all you have to do is insert and practice.
You can also you DB2 sample databases like this one DSN8D51A.
Thank You,
Sushanth |
|
| Back to top |
|
|
ajeshrn
New User
Joined: 25 Mar 2009
Posts: 78
Location: India
|
|
|
|
Hi Madhu,
You can practice INSERT queries, UPDATE queries , SELECT queries and DELETE queries.
Try creating few more tables and try to get familiarized with JOINS too. |
|
| Back to top |
|
|
ajeshrn
New User
Joined: 25 Mar 2009
Posts: 78
Location: India
|
|
|
|
| Are you looking forward to create indexes? |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
|
hope table is owned by you, if not, consult soneone at your shop before attempting to try UPDATE or INSERT operations.(Just a suggestion) |
|
| Back to top |
|
|
madhureddygs
New User
Joined: 03 Nov 2009
Posts: 2
Location: Chennai
|
|
|
|
Thanks to everyone,
Thank you for answers. Actually im not looking for these answers. I wanted to know regarding SPUFI, DCLGEN , like why they are creating all these and how to create in order to excute quuiries..... |
|
| Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
Madhu,
You should have been more elaborate before & now also.
Tell us what you have tried and what error you are getting. That will be alot easier for us to know what you have done ?
Sushanth |
|
| Back to top |
|
|
mastrahoyar
New User
Joined: 03 Mar 2007
Posts: 17
Location: hyd
|
|
|
|
Hi,
There r 2 ways to execute query
one is SPUFI and 2nd is QMF. Both are different.
Now pls let us know what do you want? |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| There r 2 ways to execute query |
And many others. . .
| Quote: |
| I wanted to know regarding SPUFI, DCLGEN |
These are not even related. . . Why are they mentioned together?
Suggest you use the "IBM Manuals" link at the top of the page and review the material for the release of db2 you are interested in.
The forum is here to help with more specific questions and problems, not provide an intro to the entire db2 environment. |
|
| Back to top |
|
|
|
|
