Decimal-data Error Occurred
Contents |
statements Oracle on iSeries File Sharing View All Integrated File System (IFS) iSeries Access (Client Access) iSeries managed email and groupware NetServer Network File System (NFS) QNTC
Decimal-data Error Occurred In As400
File System High Availability View All Business Continuity High Availability Tools how to solve decimal data error in rpg Replication IBM iSeries division news View All iSeries application development View All iSeries Application development tools iSeries decimal data error in rpgle CL programming iSeries COBOL programming iSeries ILE programming iSeries Java programming iSeries programming commands RPG iSeries programming Visual basic on iSeries iSeries backup and recovery View All Data
What Is Decimal Data Error In As400
backup, storage and retrieval on iSeries iSeries disaster recovery and business continuity Remote Journaling Restores Storage iSeries database management View All DB2 UDB (universal databases) iSeries SQL commands and statements Oracle on iSeries iSeries document output View All Imaging on iSeries Printing on iSeries Printing-Imaging Tools iSeries hardware management View All Grid Computing Logical Partitions (LPAR)
Mch1202 Error In As400
On-demand Computing iSeries networking View All Connecting to Printers FTP Physical connections to iSeries Remote Access to iSeries TCP-IP VoIP iSeries security planning View All iSeries physical security iSeries system and application security Security Tools iSeries systems management View All Change Management Debugging i5-OS -- OS-400 iSeries Applications iSeries compliance and regulation iSeries service and support issues iSeries system performance and monitoring Multi-platform Integration Performance Server Consolidation Server Installation Server Pricing Systems Management Tools iSeries training and education View All iSeries job market iSeries skills User Groups iSeries upgrades and modernization View All Web Topics Archive View All iSeries Resources Please select a category File Sharing High Availability IBM iSeries division news iSeries application development iSeries backup and recovery iSeries database management iSeries document output iSeries hardware management iSeries networking iSeries security planning iSeries systems management iSeries training and education iSeries upgrades and modernization Section Evaluate News Get Started Evaluate Manage Problem Solve Sponsored Communities Q What is a Decimal Data Error? byJohn Blenkinsop One
This document provides information about finding and correcting decimal data errors. Resolving the problem It is not uncommon for programs to have problems with decimal data errors how to handle decimal data error in rpg when working with files that originated on mainframes, non-IBM systems, and the
Decimal Data Error In Cobol 400
IBM System/36. Program-described files are normally used on these systems and can result in non-numeric hexadecimal values in numeric fields. rpgle monitor decimal data error It is also possible for a program on the IBM OS/400 or IBM i5/OS system to do this because program-described files are still available, especially for programs that have been migrated http://search400.techtarget.com/answer/What-is-a-Decimal-Data-Error and are running in the System/36 environment. The following example takes advantage of the field descriptions in externally-described files to correct the problem. The program reads in each record and writes it out making assumptions on what the correct value should be. You are responsible for evaluating the results of using this program. Because it is necessary to make assumptions, the results might not http://www-01.ibm.com/support/docview.wss?uid=nas8N1018444 be what you require. However, there is a very good chance the results will be satisfactory. Always keep a back-up copy of the file until you evaluate the results and are comfortable with the end result. In the case of zoned numeric fields, hexadecimal values such as blanks, control characters, and unassigned hexadecimal values are normally converted to zeroes. When letters or special characters (for example, the ampersand) are encountered, the first hexadecimal character is converted to an F. For example, the letter A is C1 in hex, while the letter a is 81 in hex. Both are converted to F1, which is the number one. In testing, 8aA69 is converted to 81169. However, when certain values are encountered in certain positions in the field, the entire field can be converted to a zero value. For packed numeric fields, an incorrect value in any position normally causes the entire field to be converted to a zero value. One exception was noted in testing. A 10-digit packed field requires a 6-byte field, and the first position of the first byte is not used. An incorrect value in that first position s
sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. sponsored links Collapse Announcement Collapse No http://www.code400.com/forum/forum/iseries-programming-languages/rpg-rpgle/2772-decimal-data-error announcement yet. decimal data error Collapse X Collapse Posts Latest Activity Search Page of 1 Filter Time All Time Today Last Week Last Month Show All Discussions only Photos only Videos only Links only Polls only Filtered by: Clear All new posts donna_ny https://www.experts-exchange.com/questions/21806716/How-do-I-force-an-RPG-formatted-DUMP-on-decimal-data-error.html Experienced Forum Member Join Date: Oct 2006 Posts: 81 #1 decimal data error November 30th, 2006, 09:57 AM I get below error while debugging my program Message . . . . : Decimal-data error occurred (C G D F). Cause . . . data error . . : RPG procedure ABC025 in program DLESTER/ABC025 found a decimal-data error at statement 501. A packed or zoned value does not contain valid numeric data. A digit and/or sign is not valid. 501 statement is EVAL ABC_32A_WHLPOS = %abs(ABC_32A_WHLPOS) ABC_32A_WHLPOS is defined as D ABC_32A_WHLPOS... D 12 0 D 1 inz(',') But it appears to me valid data , how can I further debug the problem to find whats going on and to fix it... All help is appreciated. Donna Tags: None Red Analyst Join decimal data error Date: Mar 2005 Posts: 392 #2 November 30th, 2006, 10:07 AM Re: decimal data error Use start debug command STRDBG PGM(program) UPDPROD(*yes) set a break point at the statment in error and display the variable Comment Cancel Post Zdenko Analyst Join Date: Jun 2005 Posts: 195 #3 November 30th, 2006, 10:11 AM Re: decimal data error Hi You don't have to set the break point, because program will stop at the certain line, when condition will be met. LP Zdenko Comment Cancel Post Red Analyst Join Date: Mar 2005 Posts: 392 #4 November 30th, 2006, 10:19 AM Re: decimal data error That's true you don't have to set the break point. I do it out of habit. In hind sight you could skip the debug and just take a dump on the error. Then check the value in the printout. Comment Cancel Post arrow483 Experienced Forum Member Join Date: Oct 2004 Posts: 1776 #5 November 30th, 2006, 02:18 PM Re: decimal data error I can't quite follow your field definition for ABC_32A_WHLPOS (due to spacing) - is it a numeric field with INZ to a comma ? You can't put commas or periods in numeric fields. Comment Cancel Post giri Analyst Join Date: May 2005 Posts: 247 #6 November 30th, 2006, 03:24 PM Re: decimal data error What is ur D-Spec .... D ABC_32A_WHLPOS... D 12 0 D 1 inz(',') Its quite confusing ... D ABC_32A_WHLPOS S 12 0 Inz(',') Is this ur declaration ???? If u declare above, u can't even compile the program. Because u r t
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > How do I force an RPG formatted DUMP on decimal data error? Want to Advertise Here? Solved How do I force an RPG formatted DUMP on decimal data error? Posted on 2006-04-08 IBM System i 2 Verified Solutions 14 Comments 2,150 Views Last Modified: 2012-06-27 I have an AJE job in a subsystem that errored out last night: Additional Message Information Message ID . . . . . . : RNQ0907 Severity . . . . . . . : 99 Message type . . . . . : Inquiry Date sent . . . . . . : 04/08/06 Time sent . . . . . . : 00:04:23 Message . . . . : Decimal-data error occurred (C G D F). Cause . . . . . : RPG procedure ONTIME in program PROACTIVE/ONTIME found a decimal-data error at statement 974. A packed or zoned value does not contain valid numeric data. A digit and/or sign is not valid. Recovery . . . : Contact the person responsible for program maintenance to determine the cause of the problem. A response of 'D' will cause an RPG formatted dump which may be useful in determining which field has the decimal-data error. However, it may be an intermediate value that has the error, if the error occurred in an expression. Possible choices for replying to message . . . . . . . . . . . . . . . : D -- Obtain RPG formatted dump. More... Reply . . . : C Press Enter to continue. F3=Exit F6=Print F9=Display message details F12=Cancel F21=Select assistance level Question: Can I force the system to perform an RPG formatted DUMP for me so the idiots working at night don't take a 'C' to the error? Needless to say, I can't recreate the error. Thanks, Phil 0 Question by:pipster1 Facebook Twitt