Error occured during query execution :[DM_QUERY_E_SYNTAX]error: "A Parser Error (syntax error) has o

Hi,

I m running a simple DQL query as SELECT id, name, address FROM dbo.MyTable but showing following error

Error occured during query execution :[DM_QUERY_E_SYNTAX]error: "A Parser Error (syntax error) has occurred in the vicinity of: SELECT id,"

where it is successfully showing output for same table with SELECT * FROM dbo.MyTable, Can anybody tell the reason for this.

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

vincentklock

you can try using:


register table dm_dbo.MyTable(dummy int)

No need to specifically add all the columns, Your DBMS system will know what is behind, and you will still be able to set ACL on the registered table.

All comments

christopher.imes

Firstly, welcome to the forums, and above all, thank you for being an EMC customer.

Please consider moving this question as-is (no need to recreate) to the proper forum for maximum visibility. Questions written to the users' own "Discussions" space don't get the same amount of attention and can go unanswered for a long time.

You can do so by selecting "Move" under ACTIONS along the upper-right. Then search for: "Documentum" and select the very first result that comes up. This will relocate it to the Developer Network subspace of the Documentum community.

For further guidance on engaging with the communities for Documentum and related products, please refer to the

IIG Communities Getting Started Guide.

Alvaro_de_Andres

If that is a simple table you've created in the database, have you registered in documentum?

PanfilovAB

id is a reserved word in DQL, use "id" (note double quotes) instead.

JD_DCTM

Thanks for Rply,

I have changed the column name from id to my_id and tried to register it with following query,

But i got following error,

Error occured during query execution :[DM_QUERY_E_SYNTAX]error: "A Parser Error (syntax error) has occurred in the vicinity of: register table dm_dbo.MyTable(my_id int,name CHAR(10),address"

vincentklock

you can try using:


register table dm_dbo.MyTable(dummy int)

No need to specifically add all the columns, Your DBMS system will know what is behind, and you will still be able to set ACL on the registered table.

JD_DCTM

Ya Its working with this command.

Thank for your help guys.