[SOLVED] ON TABLE HOLD FORMAT ALPHA no longer working in 7702
Hi,
I have one report that is working fine in 762 version but no longer working in 7611 or 7702 or 7702M. Code as below: SQL SQLORA select to_char(begin_date, 'MON-YY') PP_MONTH from table_name;
TABLE FILE SQLOUT PRINT * ON TABLE HOLD AS PP FORMAT ALPHA END -RUN -READ PP &PP_MONTH.A6 END TYPE &PP_MONTH.A6
The output should be: MAY-10
But now, it's showing 000006 instead.
when I increase form A6 to A12, it is then showing 000006MAY-10
Can anyone help?
Thanks in advance.This message has been edited. Last edited by: Kerry,
June 29, 2011, 06:48 PM
Waz
Best guess is that the sql is returning a varchar, and the numbers are the length of the field.
Try expanding the size of the -Read by increasing the size of the variable or adding a second variable.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
June 29, 2011, 09:13 PM
Alan B
Add SQL SQLORA SET VARCHAR OFF to EDASPROF. You probably have it in 7.6.2 but not the other versions, nothing has changed for FORMAT ALPHA.
Alan. WF 7.705/8.007
June 30, 2011, 12:32 PM
JZMSH
Alan,
You are right, it's not in new release. I just added and now my code is working again..