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
variable as an argument in the sum function
Moderators: DikDude, Moderator Group
- dbzTHEdinosauer
- Moderator
- Posts: 981
- Joined: Mon Oct 02, 2006 8:31 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........
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.
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
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?
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?
- dbzTHEdinosauer
- Moderator
- Posts: 981
- Joined: Mon Oct 02, 2006 8:31 pm
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
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page