Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\extensions\qt\netezza.prm
<?xml version="1.0" encoding="UTF-8"?><DBParameters xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../dbparameters.xsd"> <Configuration> <Parameter Name="GROUPING_SETS">No</Parameter> <Parameter Name="AUTOMATIC_CAST">No</Parameter> <Parameter Name="ACCEPT_COLUMNS_IN_VIEW_DECLARATION">No</Parameter> <Parameter Name="WITH_CLAUSE_SUPPORTED">Yes</Parameter> <Parameter Name="Fct_IfThenElse">CASE WHEN( #1 ) THEN #2 ELSE #3 END</Parameter> <Parameter Name="CONCAT">||</Parameter> <Parameter Name="OWNER">Y</Parameter> <Parameter Name="QUALIFIER">Y</Parameter> <Parameter Name="COMMA">||' '||</Parameter> <Parameter Name="REFRESH_COLUMNS_TYPE">T</Parameter> <Parameter Name="CHECK_OWNER_STATE">Y</Parameter> <Parameter Name="CHECK_QUALIFIER_STATE">Y</Parameter> <Parameter Name="KEY_INFO_SUPPORTED">N</Parameter> <Parameter Name="OUTERJOINS_GENERATION">ANSI_92</Parameter> <Parameter Name="EXT_JOIN_INVERT">YES</Parameter> <Parameter Name="EVAL_WITHOUT_PARENTHESIS">N</Parameter> <Parameter Name="USER_INPUT_DATE_FORMAT">{\d 'yyyy-mm-dd'}</Parameter> <Parameter Language="ja" Name="USER_INPUT_DATE_FORMAT">{!d 'yyyy-mm-dd'}</Parameter> <Parameter Name="USER_INPUT_NUMERIC_SEPARATOR">.</Parameter> <Parameter Name="IF_NULL">NVL</Parameter> </Configuration> </DBParameters>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de