Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]When writing to Oracle, Oracle writes Alias names instead of name in fex
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]When writing to Oracle, Oracle writes Alias names instead of name in fex
 Login/Join
 
Platinum Member
posted
When I write to the Oracle database with specific field names, all the fields appear as
FIELDNAME=E13, ALIAS=E13, USAGE=A10, ACTUAL=A10, $
FIELDNAME=E03, ALIAS=E03, USAGE=A40, ACTUAL=A40, $
FIELDNAME=E01, ALIAS=E01, USAGE=A40, ACTUAL=A40, $
FIELDNAME=E09, ALIAS=E09, USAGE=A2, ACTUAL=A2, $
FIELDNAME=E08, ALIAS=E08, USAGE=A3, ACTUAL=A3, $

Rather than the expected field names such as CUSTOMER_ID, STREET, CITY, STATE, CTRY.

What can I do to send the names below to oracle rather than the E* names? The fex is below.



SET ASNAMES = ON

SET SQLENGINE = SQLORA
SQL SQLORA COMMIT

TABLE FILE ZZ_ZZZ_ZZZZZZZ
PRINT
STREET
CITY
STATE
CTRY
BY LOWEST CUSTOMER_ID
ON TABLE HOLD AS XX_XXXX_XX FORMAT SQLORA
END

This message has been edited. Last edited by: Geri,




Prod: WebFOCUS 7.7.05 OS:Linux; Upgrading to: WebFOCUS 8.1.05 OS:Windows; Outputs: HTML, PDF, Excel; Adapters: SAP, MySQL, Oracle incl Report Caster
 
Posts: 102 | Location: Cincinnati, Oh USA area | Registered: November 02, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Try this..

SET ASNAMES = ON

SET SQLENGINE = SQLORA
SQL SQLORA COMMIT

TABLE FILE ZZ_ZZZ_ZZZZZZZ
PRINT
STREET AS 'STREET'
CITY AS 'CITY'
STATE AS 'STATE'
CTRY AS 'CTRY'
BY LOWEST CUSTOMER_ID AS 'CUSTOMER_ID'
ON TABLE HOLD AS XX_XXXX_XX FORMAT SQLORA
END


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1944 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Since the fex name is stored already with an 'AS' name, it seemed like it would copy that way to Oracle.

You are correct, adding the 'AS' name here created the name correctly in Oracle.

Thank you!




Prod: WebFOCUS 7.7.05 OS:Linux; Upgrading to: WebFOCUS 8.1.05 OS:Windows; Outputs: HTML, PDF, Excel; Adapters: SAP, MySQL, Oracle incl Report Caster
 
Posts: 102 | Location: Cincinnati, Oh USA area | Registered: November 02, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]When writing to Oracle, Oracle writes Alias names instead of name in fex

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.