Hi All, Can any one give me a suggestion for below prob
One job is in MSGW due to decimal dara error and I find out
stmt error and Value in DMUP.
but my file has millions of records.So how can i find out
on which record the error was occured....?
- 3 Answers
- 9513 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / reshma
Hi
First check the job using option 7
then press shift esc +3
then use the option 14 to see the open files
there u can check for which RRN the record is stuck for
that file.
thanks
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / kamlesh
use file information datastructure for ur pf in rpg pgm
then write below opcode
POST FILEINFORMATIONDS
before the statement which raise decimal data error. then
use DUMP opcode. finally u will get record number in file
info ds.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / syam
When MSGW display, give option "D" to print a DUMP. Open
that DUMP you can find some values of same record. Use
DSPPFM, there you search for that value. Close to this
value you can find that non numberic data.
| Is This Answer Correct ? | 2 Yes | 3 No |
How to know message id (errorid) in msgfile when error is occurred on screen ? WRKMSF will display all error id but i want to know error id based on error msg only?
1 Answers IBM, Ignis Technologies, SSR,
how can you detect and handle a record lock situation?
what is the length of a variable in rpg?
In 'o' Specs What Is The Opcode For Write?
what do we can do with the embedded sql statements?
What is the purpose of SFLFOLD and SFLDROP keywords?
I have created a command that display Source file and library. Now i want that when i enter library name and press f4 on Source file, pgm should display all the PF- SRC's in that Library. For F4 option i have used Choice program but since only limited paramters are passed in Choice pgm i am not able to paas library name and further can't call a pgm that will display list of Source files. Below is the Code snippet for CMD type object :- CMD PROMPT('Source Scan for HUB Standard') PARM KWD(SOURCE) TYPE(*CHAR) LEN(1) RSTD(*YES) + VALUES(N A) MIN(1) + CHOICE('N,A') PARM KWD(SRCFILE) TYPE(FILE) RSTD(*NO) + PROMPT('SOURCE FILE') FILE: QUAL TYPE(*NAME) LEN(10) RSTD(*NO) EXPR (*YES) + CHOICE(*PGM) + CHOICEPGM (XXXXXLIB/YYYPGM) QUAL TYPE(*NAME) LEN(10) DFT(*LIBL) + SPCVAL((*LIBL)) EXPR(*YES) PROMPT ('Library') Below is the Choice pgm:- PGM PARM(&PARM1 &PARM2) DCL VAR(&PARM1) TYPE(*CHAR) LEN (21) DCL VAR(&PARM2) TYPE(*CHAR) LEN (2000) IF COND(%SST(&PARM1 1 10) = 'CHOICE ' *AND + %SST(&PARM1 11 10) = 'SRCFILE ' *AND + (%SST(&PARM1 21 1) = 'C' *OR %SST (&PARM1 + 21 1) = 'P')) THEN (DO) /* (%SST(&PARM1 21 1) = 'C' *OR %SST (&PARM1 + */ CHGVAR VAR(&PARM2) VALUE('Name, F4 for List') ENDDO IF COND(%SST(&PARM1 1 10) = 'CHOICE ' *AND + %SST(&PARM1 11 10) = 'SRCFILE ' *AND + %SST(&PARM1 21 1) = 'P') THEN (DO) CHGVAR VAR(&PARM2) VALUE('Name, F4 for List') CALL PGM(GTSQL) PARM ('XXXXLIB') return ENDDO Thanks in Advance for looking into.
Which is better LF or OPNQRYF ? When should we use LF and when should we use OPNQRYF ?
what is a logical file?
what are different record spacing keywords in rlu ?
why we sometimes use same file name in FILE and TOFILE in OVRDBF and sometimes different??please tell
what are the basic features of seu?
RPG400 
