topic Re: Using Modify Statement for a DB2 table with table name higher than 18 chars gives error. in SAS Programming

Using Modify Statement for a DB2 table with table name higher than 18 chars gives error.

saroj — Thu, 13 Sep 2012 13:28:55 GMT

Hello All,

I am trying to run the below code on SAS 9.2 for Z/OS i.e mainframe and SAS is throwing up an error. anyway i can resolve this ?

OPTIONS ERRORABEND ;

LIBNAME DB2DB DB2 SSID=DB39 SCHEMA=ADRPMMT ;

DATA LOADFL ;

INFILE LOADFL ;

INPUT @001 DEALER_NUMBER $CHAR6.

@008 FILL_GOALX PD3.1

@015 FILL_GOAL_YEAR $CHAR04.

;

RUN;

DATA DB2DB.DEALER_MGMT_FILL_GOAL;

MODIFY DB2DB.DEALER_MGMT_FILL_GOAL

LOADFL ;

BY DEALER_NUMBER FILL_GOAL_YEAR ;

FILL_GOAL = FILL_GOALX ;

IF _IORC_ = %SYSRC(_SOK) THEN REPLACE ;

ELSE IF _IORC_ = %SYSRC(_DSENMR) THEN

DO;

_ERROR_ = 0 ;

_IORC_ = 0 ;

OUTPUT ;

END;

RUN;

sas error:

ERROR: File DB2DB.DEALER_MGMT_FILL_GOAL.DATA is sequential.This task requires reading observations in a random order, but the engine allows only sequential access.

NOTE: The SAS System stopped processing this step because of errors.

Re: Using Modify Statement for a DB2 table with table name higher than 18 chars gives error.

Amir — Thu, 13 Sep 2012 17:25:00 GMT

Hi,

Does the following apply:

http://support.sas.com/kb/6/720.html

If so, you might just need an extra option on the libname statement.

Regards,

Amir.

Re: Using Modify Statement for a DB2 table with table name higher than 18 chars gives error.

saroj — Fri, 14 Sep 2012 04:16:41 GMT

That did solve the issue !! thanks a lot Amir.

Re: Using Modify Statement for a DB2 table with table name higher than 18 chars gives error.

yugal — Thu, 11 Aug 2016 08:19:14 GMT

I am also facing same issue. Can you please provide me solution as SAS Support page is not available now.

Re: Using Modify Statement for a DB2 table with table name higher than 18 chars gives error.

richardbalajSAS — Mon, 12 Sep 2016 13:49:01 GMT

it's this option for libname statement:

REREAD_EXPOSURE = YES