on 01-28-2009 6:32 AM
hi,
how to view the sql query formed from the xml structure in the receiver jdbc?
In receiver JDBC channel, in advanced mode parameters provide a parameter logSQLStatement as true
See note 801367
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
im not able 2 find the parameters that u specified in the additional parameters in advanced mode? Is that bcoz im not using SP9?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
thanx 4 quick response. im very new to SAP. can u tell me what is SAP Note 801367?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can view SAP Note at
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
You may use additional parameter as described in SAP Note 801367.
Regards,
Prateek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.