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

["the dragon" <ceprn@hotmail.com>]

If it's db2 on a mainframe, doesn't it need to be in inside \  \? - you 
didn't report the OS.

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery. If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul. Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent. Be careful lest you let other people 
spend it for you." -- Carl Sandburg (1878 - 1967)

It is impossible to defeat an ignorant man in argument. -- William G. McAdoo

Religion is regarded by the common people as true, by the wise as false, and 
by the rulers as useful. -- Seneca




----Original Message Follows----
Suggestion:  Try using '[$color_cd]' instead of just '$color_cd'.
Perhaps you may need to quote it before using it: let $color_cd = '''' || 
$color_cd || ''''


>
>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
>

_________________________________________________________________
Get the latest Windows Live Messenger 8.1 Beta version. Join now. 
http://ideas.live.com


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