Logo SQLinForm

 

[solved] Tuning for Netezza SQL

[solved] Tuning for Netezza SQL
October 31, 2014 04:51PM
Hi,

I need to ask how to format for some Netezza specific key words. Specifically, I'm referring to how SqlInForm handles the DISTRIBUTE keyword in create table statements.

Right now, this is what is produced:



While I can define DISTRIBUTE as a key word for the sake of highlighting and capitalization, there doesn't seem to be anything I can do to keep "DISTRIBUTE ON" on the same line or "DISTRIBUTE ON HASH" on the same line. I'm fine with having the "(" on a new line after that, but the distribute statement, which can be HASH or RANDOM, really ought to be together. The way the indention works now is also sort of odd

thanks

khariV



Edited 1 time(s). Last edit at 06/13/2016 11:16PM by guidomarcel.
Re: Tuning for Netezza SQL
November 02, 2014 05:00PM
Hi hkhariV,
thank you for your feedback. I will add this request on my todo list for the next release. If you have any further requests please do not hesitate to contact me.

Regards
Guido
Re: Tuning for Netezza SQL
July 16, 2015 11:43PM
Hi ,
the keywords have been added to the new release 5.0 which will be released soon
Thanks for your feedback
Guido
Author:

Your Email (Optional):


Subject:


Spam prevention:
Please, solve the mathematical question and enter the answer in the input field below. This is for blocking bots that try to post this form automatically.
Question: how much is 25 plus 8?
Message: