View previous topic :: View next topic
|
Author |
Message |
ksk
Active User
Joined: 08 Jun 2006 Posts: 355 Location: New York
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
|