| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> CHAR Fields treated as Variable len?????
Help,
I am working on an installation of a batch cobol program that performs a select into and am getting a +100 when I should get a +0. The WHERE criteria includes a key field defined as CHAR(20) and I am using a DCLGEN where the field is defined as PIC X(20). The field was loaded via the LOAD APPEND function having 18 char value and two spaces.
The problem seems to be that the field is acting like it is variable, when in fact it is fixed. The only way that I could get the program to find the rown was to add VARYING after the PIC X(20) and set the length of the field and text of the field.
Send email to me if you can help at Luiz.deFreitas_at_DOL.NET.
Thanks,
Lou d. Received on Tue Sep 29 1998 - 13:07:15 CDT
![]() |
![]() |