Loading Profile...
Twitter,
Facebook, or email.
I'm getting a parsing error when I tried to add the following WHERE clause into the queryString below:
<properties dataSourceName="NJS75D-0002-DEV2_gml" queryString="select contact_id, cont_last_name, cont_first_name, cont_middle_name, cont_name_suffix, cont_addr_qualifier, company_id, bus_phone_city_cd, bus_phone_num, bus_fax_city_cd, bus_fax_num, internet_addr from q_dbgml001.dbo.gml_contact_tbl where rownum >
What is the work around?
Thanks.
PM
I’m
puzzled and unhappy
Error Parsing a queryString...
Official
Response
-
Comment also for other users:
queryString expects SQL written in the dialect of used database engine. It is not Ataccama specific but depends on the db engine. For example in Microsoft you have to use the above mentioned construction:
SELECT TOP 1000 * FROM gml_contact_tbl
while on mySql database you should use
SELECT * FROM gml_contact_tbl LIMIT 1000
On Oracle you will use
SELECT * FROM gml_contact_tbl WHERE ROWNUM<=1000
Marek
-
EMPLOYEE
1Hello Pierre,
try to use "SELECT TOP 100 contact_id, cont_last_name...."
rownum is not supported with MS SQL.
Does it help?
Regards
MarekComment -
-
I’m
thankful
Bonjour Marek,
It worked indeed but I'm sure I will want to include a where clause with greater than in the future. Any work around in that case.
Thanks.
PM -
-
Comment also for other users:
queryString expects SQL written in the dialect of used database engine. It is not Ataccama specific but depends on the db engine. For example in Microsoft you have to use the above mentioned construction:
SELECT TOP 1000 * FROM gml_contact_tbl
while on mySql database you should use
SELECT * FROM gml_contact_tbl LIMIT 1000
On Oracle you will use
SELECT * FROM gml_contact_tbl WHERE ROWNUM<=1000
Marek -
