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 !
Numeric Field filled with no numeric data
-
- Posts: 61
- Joined: Tue Jul 20, 2010 4:27 pm
- Skillset: Everythings on Mainframe
- Referer: Search on internet
-
- Global moderator
- Posts: 3025
- Joined: Sun Jul 04, 2010 12:13 am
- Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
- Referer: Google
- Location: Pushing up the daisies (almost)
Re: Numeric Field filled with no numeric data
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
Regards
Nic
-
- Posts: 61
- Joined: Tue Jul 20, 2010 4:27 pm
- Skillset: Everythings on Mainframe
- Referer: Search on internet
Re: Numeric Field filled with no numeric data
Non, I am looking for errors.
Regards
Regards
- dick scherrer
- Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
Re: Numeric Field filled with no numeric data
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?
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.
d.sch.
-
- Similar Topics
- Replies
- Views
- Last post
-
-
Retain non numeric character in IFTHEN - BUILD
by Shambu » Wed Dec 01, 2021 5:00 pm » in Syncsort/Synctool - 1
- 1976
-
by sergeyken
View the latest post
Sat Dec 04, 2021 2:28 pm
-
-
- 1
- 1789
-
by sergeyken
View the latest post
Fri Mar 26, 2021 11:59 pm
-
- 2
- 1584
-
by sergeyken
View the latest post
Sun Jan 26, 2025 3:07 am
-
-
sort card to add zeros to varying alphanumeric field.
by longfall » Thu Mar 09, 2023 12:03 am » in DFSORT/ICETOOL/ICEGENER - 1
- 1832
-
by sergeyken
View the latest post
Thu Mar 09, 2023 2:04 am
-
-
- 3
- 6853
-
by socker_dad
View the latest post
Wed May 04, 2022 12:59 am