Hi all,
I’d like to use FME to execute some count SQL functions on SQL server (SDE). I’m having trouble with the syntax of the SQL in FME and I’m not receiving any output from the SQL Executor.
SQL I’m running:
SELECT COUNT(*)
from "SDE".SAMPLE;
Solved
SQL Count function
+5- Contributor
Best answer by hkingsbury
I don’t think you can use a COUNT against SDE like this (using the SDE connection).
You’ll need to use the underlying database connection and run the select against the view or basetable that the SDE FeatureClass is linked to
1 person upvoted this
+54
Try in a single line, without semicolon. Use an alias, to expose.
SELECT COUNT(*) as CountRecords from SDE.[sample]
+5- Contributor
Hi Niels
Thanks for your help. I’m still not getting anything outputted via the SQLExecutor Result port.
Here is the log file for the SQL Executor:
1 person upvoted this
+54In the SQLExector, open the SQL Editor. (Arrow next to SQL Statement field.) Then in the upper left, click on Database Tables to unfold it. Find your table and double click it to add it to the editor. Just to be sure it written as it should.
+5- Contributor
Thanks Niels. It turns out that the Database table is correct
I’m able to run a ‘Select * from’ statement successfully, so perhaps something is wrong with how I’m understanding/using the ‘Select count’ function. I may have to reach out to safe support, thanks!
+53- Celebrity
- Best Answer
I don’t think you can use a COUNT against SDE like this (using the SDE connection).
You’ll need to use the underlying database connection and run the select against the view or basetable that the SDE FeatureClass is linked to
+5- Contributor
Thanks hkingbury. I’ll try using a direct connection to SQL Server non spatial
1 person upvoted this
Also, make sure your “sample” table is really located inside the SDE schema (which usually wouldn’t / shouldn’t be the case).
+5- Contributor
Hi all,
Thanks for your help. I was able to get this working by querying SQL S non spatial directly
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.