IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Null Value finding Using Fileaid


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ksk

Active User


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

PostPosted: Wed Sep 01, 2010 5:39 pm
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

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Sep 01, 2010 5:47 pm
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: 2481
Location: Netherlands, Amstelveen

PostPosted: Wed Sep 01, 2010 5:49 pm
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: 8696
Location: Dubuque, Iowa, USA

PostPosted: Wed Sep 01, 2010 5:54 pm
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: 6966
Location: porcelain throne

PostPosted: Wed Sep 01, 2010 7:57 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts Search two or more word with FILEAID Compuware & Other Tools 15
No new posts VB to FB - Finding LRECL SYNCSORT 4
No new posts Null values are considered in Total c... DFSORT/ICETOOL 6
No new posts Finding Assembler programs PL/I & Assembler 5
No new posts Finding faulty logic Subscript out of... COBOL Programming 5
Search our Forums:

Back to Top