Numeric Field filled with no numeric data



Compuware's data management products: File-AID for IMS, File-AID/MVS, File-AID for DB2 and DBA-XPERT for DB2

Numeric Field filled with no numeric data

Postby vegafacundodaniel » Wed Dec 22, 2010 3:57 pm

Hello,
I have some questions please :

1) How can I detect records with file aid that contain no numeric data in numeric field ?

2) How can I detect records with file aid that contain nulls in numeric field ?

3) How can I detect records with file aid that constain nulls or no numeric data in a packed numeric field ?

Thanks in advance !
vegafacundodaniel
 
Posts: 61
Joined: Tue Jul 20, 2010 4:27 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Numeric Field filled with no numeric data

Postby NicC » Wed Dec 22, 2010 5:25 pm

Have you tried creating a dataset with these conditions and then using FileAidon that dataset?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Numeric Field filled with no numeric data

Postby vegafacundodaniel » Wed Dec 22, 2010 5:32 pm

Non, I am looking for errors.
Regards
vegafacundodaniel
 
Posts: 61
Joined: Tue Jul 20, 2010 4:27 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Numeric Field filled with no numeric data

Postby dick scherrer » Thu Dec 23, 2010 2:09 am

Hello,

You need to create a test file with each of the errors you want to test. . .

Cal all 3 of the questions be summarized into the following:
How can i idenfity non-numeric values in numeric fields?

Does it really matter why a value is non-numeric when it should be numeric?

Is there some reason this must be done using File-Aid?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to File-AID

 


  • Related topics
    Replies
    Views
    Last post