variable as an argument in the sum function

Ask/Clarify the questions on EASYTRIEVE

Moderators: DikDude, Moderator Group

Post Reply
eanjr715
Member
Posts: 2
Joined: Tue Jul 29, 2014 9:57 pm

variable as an argument in the sum function

Post by eanjr715 » Tue Jul 29, 2014 10:13 pm

I'd like to know if it is possible to use a variable as the srgument to the sum function. I have a file of column names and product ids, ie LIV_PCT, 0000110001. I wrote a program the reads in the file and populates 2 host variables. I declard a cursor as : SELECT SUM(:WS-COL-NM)
from .....

ws-col-nm has LIV_PCT as it's value. the cursor opens correctly butI'm getting a -432 error - on the FETCH....

is this not possible ?

thanks
Ed

moved to db2 forum -- dbz

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Thu Jul 31, 2014 10:42 pm

well, let us see your sql. is this dynamic sql??

ws-col-nm has LIV_PCT as it's value. <<<<<that comment makes no sense.

show us the working storage definition of ws-col-nm as well as your sql........
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

eanjr715
Member
Posts: 2
Joined: Tue Jul 29, 2014 9:57 pm

Post by eanjr715 » Fri Aug 01, 2014 10:23 pm

This is a compiled EZPlus progam

The host variables are loaded from an input file. a sample would be
0000110001LIV_PCT

in-col-name has "LIV_PCT" in it ws-prod-id has "0000110001"

SQL DECLARE CSRPRDID CURSOR FOR
SELECT SUM(:IN-COL-NAME)
FROM PROD_GRP_SLS_RCOG
WHERE
RCOG_PROD_GRP_ID = :WS-PRD-ID
FOR FETCH ONLY

when I open the curosr i get no error when I execute the fetch I get and error 430

so the question is can I use an host variable in this situation?

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Thu Aug 07, 2014 3:48 pm

well, now that we know what language is invoking db2, we will post this question in the easytrieve forum
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others