Is anybody able to provide some SAS 9.1.3 code for ascertaining the DISTRIBUTE_ON key of a particular Netezza table?
have tried using the guidance here but the table comes back empty..
Asked
Active
Viewed 151 times
1 Answers
0
There is a nzsql command called \d which will retrieve the distribution keys on the table. Check the NZ Database User Guide.
Regards, Venk
Teja
- 13,214
- 36
- 93
- 155
-
Yes but can you submit these commands (and view the results) using SAS? – Allan Bowe Dec 15 '11 at 11:37