Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

I use the "Insert Into" syntax, but I get an error -#1000


Recommended Posts

The statement

--------------------------------

INSERT INTO 

/shared/examples/ds_orders/tutorial/employees (employeeid, firstname, lastname, title, extension, workphone) 

VALUES( 99, 'gugu', 'Gu', 'Tester', '99', '(650) 929-9999')

----------------------------------

error was..

----------------------------------

 Error : # 1000, References may not be fully qualified with a slash identifier here. On line 2, column 1. [parser-2909900] [Log ID: 6ce88add-47d5-42e4-89d0-fb5f751c10c6] 

===================================

In the "Select" syntax, the / worked, but I don't know why the error occurs.

Anything to add to the config?

SELECT * FROM /shared/examples/ds_orders/tutorial/employees

is ok.​

--------------------------------

I connected using ODBC,

ODBC version is 8.06.00.01.

Link to comment
Share on other sites

  • 5 months later...
×
×
  • Create New...