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

["Dwight Schrute" <schrute.dwight@hotmail.com>]

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


>From: pcavanaugh@childrensplace.com
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: sqr-users@sqrug.org
>Subject: [sqr-users] SQR Error running over a federated view
>Date: Tue, 12 Dec 2006 16:10:44 -0500
>
>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

_________________________________________________________________
All-in-one security and maintenance for your PC.  Get a free 90-day trial! 
http://clk.atdmt.com/MSN/go/msnnkwlo0050000002msn/direct/01/?href=http://clk.atdmt.com/MSN/go/msnnkwlo0050000001msn/direct/01/?href=http://www.windowsonecare.com/?sc_cid=msn_hotmail


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