Home » Developer & Programmer » Precompilers, OCI & OCCI » PCB-S-00209, Scale is not supported for host variable "Sum"
PCB-S-00209, Scale is not supported for host variable "Sum" [message #153240] Fri, 30 December 2005 05:37 Go to next message
abdou_7a
Messages: 1
Registered: December 2005
Junior Member
Hi !

I migrate the application written in COBOL of vms to MicroFocus, but I encounter the following problem :

Error at line 871, column 47 in file ../CPY/TREAT.CPY
EXEC SQL SELECT TOT INTO :Sum :i1
.....................................1

PCB-S-00209, Scale is not supported for host variable "Sum"

and the variable "Sum" is declared in the main program as follows :
01 Sum PIC S9(7)V9(2) COMP.

thank you for your help.
Re: PCB-S-00209, Scale is not supported for host variable "Sum" [message #154217 is a reply to message #153240] Fri, 06 January 2006 04:50 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Sum is an oracle reserved word, change that and retry.

MHE
Previous Topic: Problem--Dynamic SQL method 4 using host array
Next Topic: Round
Goto Forum:
  


Current Time: Thu Mar 28 17:29:01 CDT 2024