View previous topic :: View next topic
|
Author |
Message |
philipraju Warnings : 1 New User
Joined: 16 Apr 2006 Posts: 29
|
|
|
|
Hi any one gives query to the below one
I want to retrive the records which one haven null values...i dont know in which colomun i haven null value...so i want to check all the columns....is it possible without specifying the all coloumns in where clause...pls reply to me |
|
Back to top |
|
|
DavidatK
Active Member
Joined: 22 Nov 2005 Posts: 700 Location: Troy, Michigan USA
|
|
|
|
I think what you want to do is not possible.
You are going to have to list each column. (Cut the column list from the DCLGNLIB).
If you find another way, please come back and post it for the rest of us.
Dave |
|
Back to top |
|
|
anamikak
New User
Joined: 10 May 2006 Posts: 64 Location: Singapore
|
|
|
|
To Mininmize the list of column names in your query, you can first query SYSIBM.SYSCOLUMNS as
select name from SYSIBM.SYSCOLUMNS
where TBNAME ='your table name'
AND NULLS = 'Y';
this would give you the list of nullable columns
and then in your second query you can check for IS NULL.
Anamika |
|
Back to top |
|
|
|