Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to list all the database in DB2?
Hey there, Another way is you can do is type "? GET" or "? List" in the command center or the CLP and when you run it you'll be able to see the different options that are available to you. -
Help on DB2 for Windows NT
Hey eli, If you are using NT, then all you have to do is go and create a user in the User Manager (you can find it in the Start -> Programs -> Administrative Tools section. So all you have to do is create a new user and make sure that you make him part of the Administrative group. By doing... -
Decode in Oracle = ??? in DB2
Hey there... Try using "CASE" -
Help on DB2 for Windows NT
Hey eli, The basic systax to create a database is as follows: "CREATE DATABASE database_name" Of course you can play around with different parameters, however as I said the basic command is as seen above. One more thing, you'll have to make sure that you have the right authority... -
Export Stored Procedures
I want to be able to create a script for one of my databases, but when I do so it does not export the stored procedures that I had on my database. Does any one have any clue how can I include my stored procedures? Thanks.
