Hello folks,
I am trying to update a VSAM file, however I am getting the error below:
ERROR: Record not found, or the RBA is not found in the buffer pool.
ERROR: VSAM (GET) logical I/O error occurred on fileref DIREICL, rc = 8 (decimal), feedback code = 16 (decimal).
ERROR: Undetermined I/O failure.
FATAL: Unrecoverable I/O error detected in the execution of the DATA step program. Aborted during the EXECUTION phase.
Can anyone help me? I think this error is related to the VSAM file key (KSDS), but I am not sure. Is there any way for me to check the position of the columns in the VSAM file?
Thanks everyone!
I'd suggest opening a Tech Support track for this. AFAIK, there are very few mainframe SAS users active in the Community and its so many years since I last had anything to do with VSAM files.
You should post your complete SAS log of the step producing these errors though. Without your source code we have no idea how to help.
Thanks for trying to help, I am attaching part of the log.
No need to attach a file to share text. Just click the Insert Code button and paste the text.
59 DATA _NULL_; 60 61 SET UNION; 62 63 VEVSCLA = NOR; 64 65 INFILE VSAMDS VSAM FDBK=CODER KEY=VEVSCLA; 66 67 IF CODER > 4 68 THEN DO; 69 _ERROR_ = 0; 70 ABORT RETURN 1420; 71 STOP; 72 END; 73 74 INPUT; 75 76 FILE VSAMDS; 77 PUT @001 _INFILE_ 78 @&PCC TCOD 1.; 79 80 RUN; 14 The SAS System 15:47 Wednesday, April 5, 2023 NOTE: The file/infile DIREICL is: Dsname=DXA.SALIDA.REPRO.KSDS, Volume=XF5078,Disp=SHR,Unit=3390,Type=INDEXED, Spanned=NO,Recordsize=(.,225),Amp=('AMORG'), Records=28427,Keys=(11 0) ERROR: Record not found, or the RBA is not found in the buffer pool. ERROR: VSAM (GET) logical I/O error occurred on fileref DIREICL, rc = 8 (decimal), feedback code = 16 (decimal). ERROR: Undetermined I/O failure. FATAL: Unrecoverable I/O error detected in the execution of the DATA step program. Aborted during the EXECUTION phase. NOTE: 0 records were read from the infile DIREICL. NOTE: 0 records were written to the file DIREICL. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 1 observations read from the data set WORK.UNION. NOTE: The DATA statement used 0.02 CPU seconds and 17084K. NOTE: The address space has used a maximum of 624K below the line and 19416K above the line. ERROR: Errors printed on page 4. NOTE: The SAS session used 0.27 CPU seconds and 18748K. NOTE: The address space has used a maximum of 624K below the line and 19416K above the line. NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
Can you successfully read this VSAM file? SImplify your program just to read the file and see if that works.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.