Page 1 of 1

Numeric Field filled with no numeric data

PostPosted: Wed Dec 22, 2010 3:57 pm
by vegafacundodaniel
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 !

Re: Numeric Field filled with no numeric data

PostPosted: Wed Dec 22, 2010 5:25 pm
by NicC
Have you tried creating a dataset with these conditions and then using FileAidon that dataset?

Re: Numeric Field filled with no numeric data

PostPosted: Wed Dec 22, 2010 5:32 pm
by vegafacundodaniel
Non, I am looking for errors.
Regards

Re: Numeric Field filled with no numeric data

PostPosted: Thu Dec 23, 2010 2:09 am
by dick scherrer
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?