diff b/w fixedquery & fixedquerywithoutput

[Former Member]

Hi,

Can anyone tell me the exact fifference between FixedQuery , FixedQueryWithOutput & Command

Thanks,

Kamala

[Former Member · Accepted solution]

Hi Kamala,

here is the help documentation about the modes:

+ The Command mode allows for the use of SQL commands that do not return data, such as UPDATE,

INSERT, DELETE, or execution of a stored procedure that performs some type of data management

function. The Query parameter is used in conjunction with the Command mode to tell the IDBC what

SQL command to execute.

+ FixedQuery mode requires that the entire SQL statement be passed via the Query and QueryParams

parameters. For standard SQL queries, only the Query parameter would typically be used.

+ FixedQueryWithOutput. This mode is used to execute an Oracle stored procedure or function that

returns a REF CURSOR as output. The position of the REF CURSOR is marked by a "?" in the query.

Complete description you will find here:

http://help.sap.com/saphelp_xmii115/helpdata/en/Connectors/IDBCConnector.htm

Hope this helps.

Regards

Pedro

[Former Member · Accepted solution]

Thankyou Pedro Iglesias

The Link which u have mentioned was very helpful to me

Regards,

Kamala