Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Insert data into Focus DB

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Insert data into Focus DB
 Login/Join
 
Sim Na
Member
posted
Hi, I created one master file manually following felds like Emp_Name,City,Dept,Emp_Id and i try to insert some data based on this code "SQL
INSERT INTO G_TEST (Emp_Name,City,Dept,Emp_Id) VALUES ('Kumaran','Chennai','IT',1);
END"
but i got thies following errors
(FOC14010) EMP_ID IS NOT A VALID COLUMN NAME
(FOC14010) DEPT IS NOT A VALID COLUMN NAME
(FOC14010) CITY IS NOT A VALID COLUMN NAME
(FOC14010) EMP_NAME IS NOT A VALID COLUMN NAME
. plese suggist me how can i insert data into Focus DB.


Windows Server 2003
WebFOCUS 7.6.9
HTML,PDF,Excel

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


WebFOCUS 7.6.9
Essbase 6.5
Windows Server 2003
HTML,PDF,Excel
 
Posts: 9 | Location: India | Registered: May 21, 2008Report This Post
fatboyjim
Platinum Member
posted Hide Post
Hi,

You can do a hold into a focus table (you can also specify the location of the focus table as well).

Best Regards,

Jimmy Pang


DEV: WF 7.6.10
TEST: WF 7.6.10
PROD: WF 7.6.10
MRE: WF 7.6.4
OS/Platform: Windows
Dev Studio: WF 7.7
Output: HTML, EXCEL, PDF, GRAPH, LOTUS, CSV
 
Posts: 117 | Location: Toronto, Ontario, Canada | Registered: February 29, 2008Report This Post
GinnyJakes
Expert
posted Hide Post
The native language for inserting data into a FOCUS data base is MODIFY. MAINTAIN is another though requires a separate license. You can find documentation on MODIFY in a mainframe FOCUS manual. Or as Jimmy said, you can say ON TABLE HOLD AS holdname FORMAT FOCUS [INDEX fieldname].

You might want to post the master you are trying to load into. If you want the file to hang around after the load, make sure that the master has a DATASET parameter in it or there is an APP HOLD in your program or your file will disappear.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Sim Na
Member
posted Hide Post
Thank you, fatboyjim and GinnyJakes


WebFOCUS 7.6.9
Essbase 6.5
Windows Server 2003
HTML,PDF,Excel
 
Posts: 9 | Location: India | Registered: May 21, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Insert data into Focus DB

Copyright © 1996-2020 Information Builders