on 01-24-2006 12:05 PM
Hi,
I'm using the JDBC-Sender-Adapter and need to use a SQL-Statement like this:
SELECT * FROM myTable WHERE myDate = <current_date>
Is such a dynamic-sql possible, or can I only use static sql-statements. And if yes how can I solve this problem.
many thx
Hi,
thanks to all of you. I'm sure that this would work. But the problem is, that the oracle-DB is from our company in usa, I sit in austria and the admin of this db is not easy to reach. So I hoped for a possibility to do it with a simple select-statement in the adapter where I could use variables to build somewhat like "dynmaic sql statemens" - so long - thanks - werner
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Michal,
thanks for your fast reply. Is this the only possibility, or do I also have access to the current date within the JDBC-adapter. Foe example somehow using additional parameters in the "Extended Mode" ?
so long - werner
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Werner,
if your DBs sysdate is always the current date (which it should be...), you can use a DB specific function to retrieve it. In oracle it is <b>sysdate</b>, if you use another DB product check the documentation but there should be something similar.
For Oracle the statement would be like:
<i>where mydate = sysdate</i>
Best regards
Christine
Hi Werner,
inside the <b>Query SQL Statement</b> you can use <b>SQL EXECUTE</b>
which can execute a stored procedure
in which you can do
SELECT * FROM myTable WHERE myDate = <current_date>
http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm
Regards,
michal
-
<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions">XI FAQ - Frequently Asked Questions</a>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.