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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DB2 back up while it is being accessed
Hi, How to take backup in DB2 while DB is being accessed by applications? (ie. connections are open).. Pl. give the steps to be followed in control center or if any url which explains this , send that... Sriram -
how to print all table from db
how to print all the table ( == describe table <table name> of a data base ... is there any tool/ utility..... -
What is equivalant to oracle's to_date() in DB2
Hi, I need to insert a date which will be available in Eur format. ie. dd.mm.yyyy . How can i do it? I need some thing similar oracle to_date(...) function where we can specify the format also. If the input is in dd/mm/yyyy , how to insert that? Regards Sriram -
how to get the serial number from a result
Hi, Happy New Year!.. I think interpretation of the question is bit wrong. What i want is continuous sl numbers for the result set , not the stored row id. I can have a query which joins 2 or more tables also . But the results should have serial numbers like 1 , 2,3.. which we can directly... -
how to get the serial number from a result
Hi , I would like to get the serial numbers of the rows fetched from a query like select * from table1; slno field1 field2... ------------------------------ 1 abc jjj 2 def kji 3 ghi .... 4.... If I get this from db2 ,I neednot have to... -
how to change the date format
Hi, I am getting date from DB2 table in java result set as yyyy/mm/dd .I want to show it as dd/mm/yyyy or mm/dd/yyyy . What is the command for that... Regards, Sriram
