You do need to be able to connect to the database and query the underlying tables, so it could require some privileges, but you might be able to get it to work. It is just showing you a framework of what you could do.

I had already played with the parameters features of Aginity and it works fine. Only thing is you have to enter the parameters into this pop-up box for a different view or column name every time you want to change :-( And I don't think Netezza SQL supports passing of parameters...

Can you show an example of how you would pass the parameter with no manual intervention? Maybe we can find a way to do what you want, but no matter how you look at it, someone (or something) needs to supply the value to the parameter.

I realize the query should look something like this:

SELECT DISTINCT :cname FROM LRST_DB.ELT_SERVICE.VW_LRST_IT_ON_LLT_RDS

But how will the value for the cname parameter get through to the query? Where is it coming from?

Introduction
Hopefully the following mnemonic and, ultimately, the acronym it represents is common place to all those reading: Please Excuse My Dear Aunt Sally (PEMDAS). Briefly, though, PEMDAS is used to signify the order of operations (http://en.…

Sometimes MS breaks things just for fun...
In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset.
Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters.
So, …

With just a little bit of SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form. If you have never written code or looked at an SQL statement before, no problem! ... give i…