December 04, 2006, 09:47 AM
KameshTrouble in READ - 716 version
Hi,
Saving a hold file and read it later to get the values. In 716 version, it reads the value prefixed with the length of value. It works fine in 533 version.
Ex:
TABLE FILE CAR
PRINT COUNTRY
ON TABLE SAVE AS TEST
END
-RUN
-READ TEST &COUNTRY.A25.
-RUN
OUTPUT:
SUPPOSED TO BE USA, FRANCE,...
But it is printing as 000003USA, 000006FRANCE.
Can somebody let me know is there any setting I have to do or is this the way 716 will work?
December 04, 2006, 10:05 AM
Tony AKamesh,
What is your data source?
This has been covered multiple times and is due to the default change in VARCHAR behaviour with most SQL data sources.
I'm sure that the above comment will trigger the memory ......
SQL SQLMSS SET VARCHAR OFF
T
December 04, 2006, 10:27 AM
KameshThanks Tony. SET VARCHAR OFF did the trick.