Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
help in selecting rows with low values.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Roshnii

New User


Joined: 30 Sep 2008
Posts: 45
Location: bangalore

PostPosted: Tue Nov 25, 2008 7:05 pm    Post subject: help in selecting rows with low values.
Reply with quote

Hi,

Is there any way where I can select rows from table with low values in the where clause?

There is a text field in my table which will be populated with low value. I want all the rows with low values in that particular column from the table. Is that possible?



Thanks,
Roshnii
Back to top
View user's profile Send private message

Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Tue Nov 25, 2008 7:40 pm    Post subject:
Reply with quote

Yes, just compare with x'00'!
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue Nov 25, 2008 7:40 pm    Post subject:
Reply with quote

yes. What is the definition of the text field?
Back to top
View user's profile Send private message
Roshnii

New User


Joined: 30 Sep 2008
Posts: 45
Location: bangalore

PostPosted: Tue Nov 25, 2008 7:59 pm    Post subject: Reply to: help in selecting rows with low values.
Reply with quote

the column is char(30)
Back to top
View user's profile Send private message
Roshnii

New User


Joined: 30 Sep 2008
Posts: 45
Location: bangalore

PostPosted: Tue Nov 25, 2008 8:00 pm    Post subject:
Reply with quote

I am sorry, its not a varchar field, its a char field
Back to top
View user's profile Send private message
Roshnii

New User


Joined: 30 Sep 2008
Posts: 45
Location: bangalore

PostPosted: Tue Nov 25, 2008 8:21 pm    Post subject:
Reply with quote

I have to pick up rows which are either low values or ---------.
I have tried giving x'60' but it did not pick up the rows with values as ---------.
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Tue Nov 25, 2008 8:24 pm    Post subject:
Reply with quote

x'60' would not be low values!
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue Nov 25, 2008 8:36 pm    Post subject:
Reply with quote

is this text column NULLABLE?
Back to top
View user's profile Send private message
Roshnii

New User


Joined: 30 Sep 2008
Posts: 45
Location: bangalore

PostPosted: Wed Nov 26, 2008 11:45 am    Post subject: Reply to: help in selecting rows with low values.
Reply with quote

yes the field is nullable.

I need rows which have the value --------- also which is '606060'
Back to top
View user's profile Send private message
Roshnii

New User


Joined: 30 Sep 2008
Posts: 45
Location: bangalore

PostPosted: Thu Nov 27, 2008 11:43 am    Post subject:
Reply with quote

I am using Column_name IS NULL and its working.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Nov 28, 2008 3:12 am    Post subject:
Reply with quote

Hello,

If IS NULL is working, your questions about x'00' and x'60' have nothing to do with the query that you say meets your requirement.

If the requirement is to find rows with te NULL value, why the discussion about the other hex values? Might the query be only partly working?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Conditional highlighting of rows in I... packerm CLIST & REXX 2 Thu Sep 21, 2017 6:50 pm
No new posts column with count of rows within dist... ronald wouterson DB2 4 Sun Sep 17, 2017 9:48 pm
No new posts Working with hex values in Filemanage... Emile Straker IBM Tools 0 Tue Sep 12, 2017 1:42 am
No new posts DB2 NULL Values display V S Amarendra Reddy DB2 3 Thu Sep 07, 2017 6:59 pm
No new posts Moving values to a variable of copybo... Vignesh Sid COBOL Programming 6 Wed Sep 06, 2017 1:04 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us