I ran this code in both 7.6.4 and 8.0.9 and got different format results...webfocus 8 is adding a "V" after the alpha formats. Does anyone have any ideas on why? :
-SET &ECHO=ALL;
ENGINE SQLORA SET OPTIMIZATION ON ENGINE SQLORA SET OPTIFTHENELSE ON
from "SAPBWP".ZRLSLSBB where FISCPER >= '2015001' AND SOLD_TO IN ('C2601','C4586','C4711','0001397434','0001416356','0001416625') END -RUN TABLEF FILE SQLOUT PRINT MANDT MATERIAL SOLDTO SHIPTO IDPLANT PRMPLANT BACKUP PLANT
ON TABLE HOLD AS HOLD END -RUN
--------Version 7.6.4 format ------- FILENAME= HOLD MANDT E01 A3 MATERIAL E02 A18 SOLDTO E03 A10 SHIPTO E04 A10 IDPLANT E05 A4 PRMPLANT E06 A4 BACKUP E07 A4 PLANT E08 A4
--------Version 8.0.9 format ------- FILENAME= HOLD MANDT E01 A3 MATERIAL E02 A18V SOLDTO E03 A10V SHIPTO E04 A10V IDPLANT E05 A4V PRMPLANT E06 A4V BACKUP E07 A4V PLANT E08 A4VThis message has been edited. Last edited by: <Kathryn Henning>,
8.0.9, Windows excel / pdf
July 14, 2015, 02:12 PM
David Briars
What is the DATA_TYPE in Oracle?
Is it VARCHAR2?
If so, it not so much that WF 8.x is adding a 'V', as WF 8.x is creating a format that closely matches what Oracle has.
I started with the 7.7 Oracle adapter, so I'm not sure about 7.6, but it might be possible that 'A' was the closest format match in that release.
Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster
July 14, 2015, 02:29 PM
MMcDonald
Data_Type in Oracle is a "VARCHAR2" . is there any way to control that so the hold will remain the same as 7.6.4 version? This is a fairly big issue since we are joining to various tables and when joining an "A10V" to a "A10" key in a table the join now fails.
8.0.9, Windows excel / pdf
July 14, 2015, 02:35 PM
David Briars
Take a look at the setting of VARCHAR.
ENGINE SQLORA SET VARCHAR ON is by default.
Maybe setting this to OFF, will get your code to behave like it did in 7.6.
July 14, 2015, 03:11 PM
MMcDonald
quote:
ENGINE SQLORA SET VARCHAR ON is by default.
David, Thanks for your help. I made the change to a test program and it worked. So I went ahead and added to the Server Profile and that seemed to take care of all the issues.