Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\extensions\qt\mysql.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="OUTERJOINS_GENERATION">ANSI_92</Parameter> <Parameter Name="EXT_JOIN_INVERT">YES</Parameter> <Parameter Name="IDENTIFIER_DELIMITER">`</Parameter> <Parameter Name="CONCAT">+</Parameter> <Parameter Name="OWNER">N</Parameter> <Parameter Name="QUALIFIER">N</Parameter> <Parameter Name="COMMA">+' '+</Parameter> <Parameter Name="REFRESH_COLUMNS_TYPE">Q</Parameter> <Parameter Name="CHECK_OWNER_STATE">N</Parameter> <Parameter Name="CHECK_QUALIFIER_STATE">N</Parameter> <Parameter Name="KEY_INFO_SUPPORTED">Y</Parameter> <Parameter Name="BACK_QUOTE_SUPPORTED">Y</Parameter> <Parameter Name="USER_INPUT_DATE_FORMAT">{\d 'yyyy-mm-dd HH:mm:ss'}</Parameter> <Parameter Language="ja" Name="USER_INPUT_DATE_FORMAT">{!d 'yyyy-mm-dd HH:mm:ss'}</Parameter> <Parameter Name="USER_INPUT_NUMERIC_SEPARATOR">.</Parameter> <Parameter Name="UNICODE_PATTERN">N$</Parameter> </Configuration> </DBParameters>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de