cancel
Showing results for 
Search instead for 
Did you mean: 

how to view the sql query?

Former Member
0 Kudos

hi,

how to view the sql query formed from the xml structure in the receiver jdbc?

Accepted Solutions (1)

Accepted Solutions (1)

former_member192892
Active Contributor
0 Kudos

In receiver JDBC channel, in advanced mode parameters provide a parameter logSQLStatement as true

See note 801367

Answers (3)

Answers (3)

Former Member
0 Kudos

im not able 2 find the parameters that u specified in the additional parameters in advanced mode? Is that bcoz im not using SP9?

Former Member
0 Kudos

Which SP-level do you use?

If you are >=SP09 you can add the mentioned parameter manually in the "Advanced"-tab. There you have to activate "Advanced Mode". Then you can create a new entry with the plus-button and there you define Name and Value:

Name=logSQLStatement

Value=true

I have another question to the log-entry. Is the sql-statement, that is shown in the rwb-log for the message, 100percent equal to the statement that is transmitted to the database?

Regards,

Heinrich

Former Member
0 Kudos

thanx 4 quick response. im very new to SAP. can u tell me what is SAP Note 801367?

prateek
Active Contributor
0 Kudos

You can view SAP Note at

http://service.sap.com/notes

But you require SMP login ID for this which you should get from your company. The content of the notes are as follows:

Reason and Prerequisites

You are looking for additional parameter settings. There are two possible reasons why a feature is available via the "additional parameters" table in the "advanced mode" section of the configuration, but not as documented parameter in the configuration UI itself:

Category 1: The parameter has been introduced for a patch or a SP upgrade where no UI upgrade and/or documentation upgrade was possible. In this case, the parameter will be moved to the UI and the documentation as soon as possible. The parameter in the "additional parameters" table will be deprecated after this move, but still be working. The parameter belongs to the supported adapter functionality and can be used in all, also productive, scenarios.

Category 2. The parameter has been introduced for testing purposes, proof-of-concept scenarios, as workaround or as pre-released functionality. In this case, the parameter may or may not be moved to the UI and documentation, and the functionality may be changed, replaced or removed. For this parameter category there is no guaranteed support and usage in productive scenarios is not supported.

When you want to use a parameter documented here, please be aware to which category it belongs!

Solution

The following list shows all available parameters of category 1 or 2. Please note:

Parameter names are always case-sensitive! Parameter values may be case-sensitive, this is documented for each parameter.

Parameter names and values as documented below must be used always without quotaton marks ("), if not explicitly stated otherwise.

The default value of a parameter is always chosen that it does not change the standard functionality

JDBC Receiver Adapter Parameters

1. Parameter name: "logSQLStatement"

Parameter type: boolean

Parameter value: true for any string value, false only for empty string

Parameter value default: false (empty String)

Available with: SP9

Category: 2

Description:

When implementing a scenario with the JDBC receiver adapter, it may be helpful to see which SQL statement is generated by the JDBC adapter from the XI message content for error analysis. Before SP9, this can only be found in the trace of the JDBC adapter if trace level DEBUG is activated. With SP9, the generated SQL statement will be shown in the details page (audit protocol) of the message monitor for each message directly.

This should be used only during the test phase and not in productive scenarios.

Regards,

Prateek

prateek
Active Contributor
0 Kudos

You may use additional parameter as described in SAP Note 801367.

Regards,

Prateek