Occasionally, there is a need to quickly drop a list of tables and you don’t always want to write or generate each command individually in Aginity.
Leave a comment Netezza / PureData – How to build a multi table drop command from a selectĭatabase Management How to Quick Drop Multiple Tables Print Posted on by Bert Swope Posted in All categories Tagged Aginity, aginity for netezza, Aginity for Netezza SQL, aginity netezza client, aginity netezza functions, aginity netezza linux, aginity netezza query, aginity netezza tool, aginity netezza workbench, aginity netezza workbench 3.0, aginity netezza workbench documentation, aginity netezza workbench setup, aginity netezza workbench setup 圆4, aginity netezza workbench tool, aginity netezza workbench tutorial, aginity workbench for ibm netezza, aginity workbench for netezza, aginity workbench for netezza 3.0, aginity workbench for netezza 4.1, aginity workbench for netezza 4.3, aginity workbench for netezza documentation, aginity workbench for netezza functionality, aginity workbench for netezza help, aginity workbench for netezza manual, aginity workbench for netezza sql, aginity workbench for netezza tutorial, aginity workbench for netezza user guide, big Data, comment On Command, Database Administration, Database Administrator, Databases, IBM Netezza database user documentation, Information Managment, netezza aginity, netezza appliance, netezza basics, netezza bi, netezza big data, netezza etl, netezza ibm, netezza pda, netezza SQL, Netezza SQL command reference, netezza sql commands, netezza sql examples, netezza sql functions, PureData, PureData System for Analytics, PureData System for Analytics 7.2.1, PureSystems, Quotes, SQL, Structured Query Language, Technology And Information Management, Technology2.
Netezza / PureData – How to build a multi-table drop command from a select.‘,’||””|| S1.ORDER_NUM||”” as Quoted_Order_NumberįROM Sales S1 How to Quote A Single Quote Example SQL Related Reference This results in a delimited and quoted list ( ,’116490856′) which needs only to have the parentheses added and the first comma removed, which is much less work than manually editing the 200 item that resulted from this select. And closed with a quoted single Quote (entered as four single quotes (””)).
The short answer is to use four single quotes (””), which will result in a single quote within the select statement results. How To Quote a Single Quote in Netezza SQL?