Home > Ask the AS/400 Experts > iSeries Application Development Questions & Answers > How do you read a formatted dump of an SQL RPGLE program?
Ask The iSeries 400 Expert: Questions & Answers
EMAIL THIS

How do you read a formatted dump of an SQL RPGLE program?

John Blenkinsop EXPERT RESPONSE FROM: John Blenkinsop

Pose a Question
Other iSeries 400 Categories
Meet all iSeries 400 Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 16 June 2005
How do you read a formatted dump of an SQL RPGLE program and what do you look for? For example, I received an error message on the console RX402R 6641 decimal-data error in field (C G S D F). I entered "D" to perform a dump. Were do I go from here?

>
On the first page of the dump you will see a line like this....

Statement in Error . . . . . . . . . . : 00010500

Open your source and go to that line (105.00 in the example above). In my source, the line is....

 0105.00 C                   Eval      test1 = test1 / test2 

Back at the dump, I search for TEST. I see the following lines....

 
TEST2               ZONED(4,0)               .            '40404040'X 
TEST3               CHAR(4)              '    '           '40404040'X 

and 

TEST1                 INT(10)              1                '00000001'X 

Searching in my source, I find the problem.... 

0088.00 D                 DS                               
0089.00 D test2                   1      4S 0               
0090.00 D test3                   1      4    Inz(*Blank) 

I have been so silly! I have defined a blank field over the top of a numeric field.

Now, I am not usually so silly. But a decimal data error can come from such a thing, or from a failed record read where the record is defined in an uninitialized externally-described data structure, or by invalid data from a passed parameter -- there are several ways of getting bad numeric data. Now you know how to examine your dump along with the source, you should be able to work out the problem and find a solution.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

The Best Web Links: tips, tutorials and more.

Visit the ITKnowledge Exchange and get answers to your developing questions fast.

Ask the Experts yourself: Our application development gurus are waiting to answer your programming questions.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
iSeries Application Development
Monitoring escape messages and using RCVMSG for diagnostic messages
Listing contents of multiple FTP directories on AS/400
Chain operation error after converting RPG3 to ILE RPG (RPGIV)
Space offset X'0015FF00' or X'0000000000000000' is outside current limit for object QIGC2424C
Searching fields for values
iSeries application display subfiles with other program windows
Searching part of a name or address in AS/400
Passing parameters in an ILE RPG module
What's happening to my subfile?
What happening to my subfile?

RPG iSeries programming
Enhancing RPG with external SQL stored procedures
Introduction to SQLRPGLE on IBM i: Making a report
Making the most of RPG data handling on IBM i
IBM i shop boosts online sales with RPG-based Web platform
Migrating from RPG to EGL on IBM i
Allow access to data from a stored procedure result set using COBOL or RPG
EGL Rich UI on IBM i: Do you Dojo?
Programming for the Web on the IBM i, what is possible
A taste of COMMON: ILE, IBM releases, Web applications and new products
Documenting nested program structures on the AS/400

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
Report Program Generator  (Search400.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



iSeries Networking - Printing, Remote Access, TCP/IP
HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts