LINKED SERVER to NETEZZA QUESTION

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » Working with Oracle » LINKED SERVER to NETEZZA QUESTION

LINKED SERVER to NETEZZA QUESTION

Rate Topic

Display Mode

Topic Options

Author

Message

David F

Posted Thursday, March 07, 2013 5:10 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 22, 2013 12:46 PM
Points: 14, Visits: 61

Hello, I have what I hope is a simple question. I have setup a linked server using a System ODBC DSN that connects to a Netezza device. I'm currently testing, and while the performance is solid, I'm having trouble understanding what is happening when I try to "SELECT TOP [X] FROM ..."

My understanding is that this is supposed to be interpolated to "SELECT * FROM TABLE LIMIT [X]" but the query continues to give me all the records.

I've tried both of these:

SELECT TOP 10 *
From [LINKED_SERVER].[TABLE].[SCHEMA].[TABLE]

SELECT TOP 10 *
FROM OPENQUERY([LINKED_SERVER], 'SELECT * FROM [TABLE].[SCHEMA].[TABLE]')

Both return all Records.

If I try this:

SELECT *
FROM OPENQUERY([LINKED_SERVER], 'SELECT * FROM [TABLE].[SCHEMA].[TABLE] LIMIT 10')

I get an error that says "Incorrect syntax near "SELECT", found "10" "
If I Alias the table then I get the same error except it says found 'Limit'

Any ideas?

Post #1428329

« Prev Topic | Next Topic »

Permissions