|
View previous topic :: View next topic
|
| Author |
Message |
loverj24
New User
Joined: 05 Jul 2007
Posts: 16
Location: bangalore
|
|
|
|
| Hi All i am exectuing the following query and i am getting some rows with a '-' in it. I need to remove the '-' from the results. |
|
| Back to top |
|
 |
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8697
Location: Dubuque, Iowa, USA
|
|
|
|
| Before the END) you could add ELSE ' '. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
why post more than 1 megabyte of garbage ( jpegs )
when a palin text cut and paste would have taken at most 4000 bytes ???
2 screen of 24 lines each for 80 bytes ?? |
|
| Back to top |
|
|
loverj24
New User
Joined: 05 Jul 2007
Posts: 16
Location: bangalore
|
|
|
|
Hi Robert,
Thanks for the reply.
By putting an ELSE the '-' disappered. But thats not the result i wanted. I need to elimate the Entire row where the status is blank.Kindly help |
|
| Back to top |
|
|
loverj24
New User
Joined: 05 Jul 2007
Posts: 16
Location: bangalore
|
|
|
|
Hi Enrico,
Sorry about taht will take care of it in the future.
Just wanted to give a relaistic picture of the issue |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8697
Location: Dubuque, Iowa, USA
|
|
|
|
Stating
| Quote: |
| remove the '-' from the results |
is not the same as "remove the records with '-' in the results below" -- if you'd asked the right question first, that would have helped.
Since I'm not a DB2 person I can't tell you how to change the WHERE clause but the records with '-' (now space) either have CDREASON not = H or REG_TYPE not = 'H' or A.DTCREATE not = '2008-10-16' -- so you need to modify your SELECT to not pick those records. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
The "screen" shots have been removed.
If you want that info back in the topic, use copy/paste and the "Code" tag to present information from a 3270-terminal.
Thank you. |
|
| Back to top |
|
|
Suresh Ponnusamy
Active User
Joined: 22 Feb 2008
Posts: 107
Location: New York
|
|
|
|
Hi
This is more specific to the Functionality and your application. Since we do not have any knowledge on your application and table usage, it would not be a more accurate answer what we provide here.
By looking at the result which you have given above,
You are specifically interested only on
1) REG_TYPE = 'H' and A.DTCREATE = '2008-10-16' Or
2) B.CDREASON = 'H'
When the retrieved records are not satisfy this condition, you are getting
'-' (No Value or NULL).
So to avoid these records, you can use the above condition in WHERE Clause of the query.
| Code: |
WHERE A.PERSONAL_ID = B.PERSONAL_ID
..................
.................
.................
AND ((REG_TYPE = 'H' AND A.DTCREATE = '2008-10-16')
OR (B.CDREASON = 'H'))
|
This is just a tendative answer based on your output.
If it also does not satisfy your requirement, do please contact you team mates...
Suggestions are welcome |
|
| Back to top |
|
|
|
|
