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
 
Null Value finding Using Fileaid

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
ksk

Active User


Joined: 08 Jun 2006
Posts: 356
Location: New York

PostPosted: Wed Sep 01, 2010 5:39 pm    Post subject: Null Value finding Using Fileaid
Reply with quote

Hi,

Can we give a check to find out null value records using Interactive Fileaid (not in batch)? This can be done using DFSORT but I want to know is there any option using Fileaid.

For ex:

Code:

123456789.....012345
455456567464646464
745677757.....989888


In the above example, I want to check if there are any null values (shown with periods) present in a position from 10 to 14 (length 5) in the record. I would like to display the records which have nulls in 10 to 14 colomns.
In my output, I should get

Code:

123456789.....012345
745677757.....989888


Regards,
KSK
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10326
Location: italy

PostPosted: Wed Sep 01, 2010 5:47 pm    Post subject: Reply to: Null Value finding Using Fileaid
Reply with quote

when browsing most often the product will substitute dots for non printable chars

to determine exactly the content of the columns in question You should use something like HEX ON
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2442
Location: Netherlands, Amstelveen

PostPosted: Wed Sep 01, 2010 5:49 pm    Post subject:
Reply with quote

If you can nullify a field (in batch) by for example :
EDIT=(1,6,C’AAAA’,C’’)
Then i guess its possible that there is a construct for
comparing with C''
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8165
Location: East Dubuque, Illinois, USA

PostPosted: Wed Sep 01, 2010 5:54 pm    Post subject:
Reply with quote

Interactive File Aid allows you to enter selection criteria -- such as starting column, length, and hex values to be matched -- to wit:
Code:
 IFASCU10 -------------  Unformatted Selection Criteria  ---- Row 1 to 20 of 20
 COMMAND ===>                                                  SCROLL ===> PAGE

 Use END to continue, CANCEL to return to main screen.

     AND
 Cmd /OR Position Length RO                      Data Value
 --- --- -------- ------ -- ----------------------------------------------------
 ___      _____   _____  EQ ____________________________________________________
 ___ AND  _____   _____  EQ ____________________________________________________
 ___ AND  _____   _____  EQ ____________________________________________________
 ___ AND  _____   _____  EQ ____________________________________________________
 ___ AND  _____   _____  EQ ____________________________________________________
 ___ AND  _____   _____  EQ ____________________________________________________
 ___ AND  _____   _____  EQ ____________________________________________________
 ___ AND  _____   _____  EQ ____________________________________________________
 ___ AND  _____   _____  EQ ____________________________________________________
 ___ AND  _____   _____  EQ ____________________________________________________
 ___ AND  _____   _____  EQ ____________________________________________________
 ___ AND  _____   _____  EQ ____________________________________________________
 ___ AND  _____   _____  EQ ____________________________________________________
 ___ AND  _____   _____  EQ ____________________________________________________
 ___ AND  _____   _____  EQ ____________________________________________________
 ___ AND  _____   _____  EQ ____________________________________________________
 ___ AND  _____   _____  EQ ____________________________________________________
 ___ AND  _____   _____  EQ ____________________________________________________
 ___ AND  _____   _____  EQ ____________________________________________________
 ___ AND  _____   _____  EQ ____________________________________________________
If you don't know about this, perhaps you should find a copy of the File Aid manual and read it to learn the capabilities of File Aid.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Wed Sep 01, 2010 7:57 pm    Post subject:
Reply with quote

and considering NULL Value is a DB2 concept and has nothing to do with actual data values,
this is yet another example of a problem
due to lack of knowledge/understanding of fundamentals.
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 -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts LMINIT problem - not finding DDNAME Danielle.Filteau CLIST & REXX 7 Tue Sep 19, 2017 9:57 pm
No new posts DB2 NULL Values display V S Amarendra Reddy DB2 3 Thu Sep 07, 2017 6:59 pm
No new posts Finding IMS resource blocker after se... Hooman24 IMS DB/DC 1 Wed Aug 16, 2017 9:17 pm
No new posts finding delayed job/s in OPC jzhardy IBM Tools 0 Mon May 29, 2017 9:04 am
No new posts Fileaid 2 commands instream work. In ... descann Compuware & Other Tools 2 Tue May 16, 2017 3:31 pm

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