on 05-05-2008 3:15 PM
Hi Friends,
Is it possible to give the select command to select data from multiple tables directly in the 'Query SQL statement' in JDBC sender communication channel ? (Instead of Stored Procedure)
Thanking you.
Kind Regards,
Jeg P.
Hi,
here is a sample:
Table #1
Header
Name EmpId Status
Jai 5601 0
Karthik 5579 0
Table #2
Name Contactnumber
Jai 9894268913
Jai 04312432431
Karthik 98984110335
Karthik 04222643993
select Header.Name, Header.EmpId, Item.Contactnumber from Header,Item where Header.Name = (select min(Header.Name) from Header where Header.Status = 0) and Header.Name = Item.Name
Regards Mario
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
This is very much possible.
You can either use JOIN statement in you select or even you try STORED PROCEDURE to achieve the same.
Regards
Ramesh P
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi friends, i need help for sender jdbc adapter. actaully my scenario is i ahve to take data from 2 tables and insert the data from 2tables into another database of having the same 2 tables. how to configure in sender adapter. i have written the select query. but i need the update query statement in sender jdbc adapter.please help me.
Hi
Yes, you can give the select command to select data from multiple tables directly in the 'Query SQL statement' in JDBC sender communication channel. You can either use nested queiries or joins.
Thanks
Saiyog
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can fetch the data from multiple tables using Joins.
Here is one of the features of JDBC sender adapter answering your query as provided by help.sap.com.
db.processDBSQLStatement=<SQL-Select-Statement>
Either specify a valid SQL SELECT statement to select the data to be sent from the specified database, or specify an SQL EXECUTE statement to execute a stored procedure that contains exactly one SELECT statement. The expression only needs to correspond to the SQL variant supported by the respective JDBC driver; so it can also contain table JOINs, for example. This specification is mandatory.
Thanks,
Bala
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Why not, we can write any type of select statement including the joins also.
Its like a general SQL statements, how you can write the SQL statements in the Oracle that all statements we should write here.
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 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.