July 12, 2005, 12:52 PM
Lenny WardConverting to WebFOCUS 7.1
We are converting to 7.1 and just ran into a major problem.
We use MS SQL Server adapter. All are data retrieval is done with SQL stored procs.
We frequently run a SQL proc to retrieve data to set an &var. Prior to 7.1 varchar data would come back as fixed by default so that we could do something like this.
SQL SQLMSS EX p_get_rpt_machinename;
TABLE FILE SQLOUT
PRINT MACHINE
ON TABLE SAVE
END
-RUN
-READ SAVE &MACH.A40.
-TYPE &MACH
The problem is that in 7.1 MACHINE comes back as varchar and you can't read it.
The default behavior has been changed in 7.1.
In order to fix this problem you need to add this code to EDASPROF.PRF
SQL SQLMSS SET VARCHAR OFF
I hope this helps anyone converting to 7.1
Lenny
July 12, 2005, 04:52 PM
<NorthNone>Thanks for taking time to share your knowledge with the rest of us!
July 13, 2005, 08:27 AM
Tony AThanks Lenny,
Something to bear in mind! Fortunately my Client isn't planning to use stored procs, but you never know!
July 13, 2005, 05:25 PM
mgrackinFYI,
I have WebFOCUS 7.1 on a test box and I am finding problems with Graph API calls for formating. I have an application that does a lot of graphing and certain API formating calls that work in 5.2.3 do not work in 7.1.
IBI has reproduced the problems and is researching.