[sqr-users] SQR Error running over a federated view

[pcavanaugh@childrensplace.com]

I am having a problem running a select over a federated view.    I have 
listed the error I am getting and the source code that is running.  I have 
run the SQL in the DB2 control center and it worked fine.

I received this error.

(SQR 5528) DB2 SQL FETCH error -1822 in cursor 5:
   SQL1822N  Unexpected error code "-151" received from data source 
"CDSDEV". 

Associated text and tokens are " SQL0151N  The column "MODIFY_USER" cannot 
be 

updated.  SQ".  SQLSTATE=560BD


Error on line 1293:
   (SQR 3725) Bad return fetching row from database.

SQR: Program Aborting.

The code in the SQR is listed below.

begin-select
COLOR_NAME         &description
    move &description       to $color
FROM TSS.V_TSS_COLOR_CODES
WHERE COLOR_CODE = $color_cd
end-select


****************************
Pete Cavanaugh
Director of Logistics, IT
The Children's Place
915 Secaucus Road
Secaucus, NJ 07094
Office: 201-558-2357

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users