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,

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

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.

Thank you, fatboyjim and GinnyJakes