MVSFORUMS.com

suggala · Beginner Joined: 07 Oct 2003 Posts: 3 Topics: 2

Hi,

I am able to create a working storage variable as follows

select count(*) into :ws-count
from table.name
where var1 = 'x'
and var2 = 2

all this is stored in varchar working storage variable totcnt
I am moving length too.

When I issue a prepare statement I am getting error -312.
I am guessing it may be due to existance of host variable
ws-count.

Any help in this regard to overcome this. thanx

Raghu
_________________
Raghu

kolusu · Posted: Tue Oct 14, 2003 5:02 pm Post subject:

suggala,

How is ws-count defined? Is it defined as comp field? If it is indeed defined as comp field , then make sure that it is 01 level or 05 level item.

Any way check this link for a detailed explanation of seql error code -312

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCH11/2.1.6.107?SHELF=&DT=20010718150520

Hope this helps...

cheers

kolusu