2) Can you please suggest the easiest way to fetch records from a table with a column having characters other than non-specified values ? For Example : I need a row which is having characters other than A, B and C ???
Input : ABC, AMC, BBC, TTG, KKK, LLL
Output should be : TTG, KKK, LLL
3) I need to update the values of a column in DB2 if the value is numeric ???
Ex : Input value is : 123, 145
Output should be : 00123 , 00145
4) There are three tables Current, History and archive. The contents of these tables are consolidated in one table called Full. I need to write a query in which i need to sum up the record count of Current, History and archive
SELECT COUNT(*) AS C
SELECT COUNT(*) AS H
SELECT COUNT(*) AS A
Now i need to sum up the count values(c,h,a) in the same query.
Can anyone help me on this?
5) I need to fetch all the rows where spaces is a part of column value with some restriction ???
I/P is : UNITED STATES, INDIA, UK
O/P should be : UNITED STATES (as it is having spaces)
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be