Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL Need a query to run in db2

Have Programming Question? Ask it here!
 
 
 


sindy
Need a query to run in db2
0 Answer(s)      2 years and 11 months ago
Posted in : SQL


hi all,

I need a query to run in DB2 for the following:

Table 1- MARKETINGACCOUNTS Fields-ACCOUNTTYPE,Accountnumber; Table 2- ACCOUNTS Fields-LEDGERCODE,ACCOUNTNUMBER,BALANCE

FROM THE ABOVE I NEED A QUERY TO RETRIEVE ONLY THE ACCOUNTYPE=AFFILIATE FOR ACCOUNTNUMBERS FROM TABLE 1 AND IN TABLE 2 LEDGERCODE=EC AND BALANCE>0

Pls help. Thanks


Advertisement
View Answers

Related Tutorials/Questions & Answers:
Need a query to run in db2
Need a query to run in db2  hi all, I need a query to run in DB2...; Table 2- ACCOUNTS Fields-LEDGERCODE,ACCOUNTNUMBER,BALANCE FROM THE ABOVE I NEED A QUERY TO RETRIEVE ONLY THE ACCOUNTYPE=AFFILIATE FOR ACCOUNTNUMBERS FROM TABLE
DB2
DB2  Actually i want to store Live Video Streaming(from Camera) in data base(DB2) & also i want to retrieve the stored video from client(Authorized Person). So Please send me the java code for above functions
Advertisements
need query
need query  hi sir , i am beginner to sql.i need a query so that it can be helpful to my project. i have four tables each containing different fruits with different amounts. i need a query in such a way that when i say some
need search query - WebSevices
need search query  I have a field in database as DOB. But I want to search recrods as per "fromage" to "toage". I dont know how to compare the ages with DOB field and retrieve records. plese help me.  Hi Friend
Hibernate db2
In this section, you will learn about the db2 configuration in Hibernate
Need query for rollup based on month and category
Need query for rollup based on month and category   Hi, Here is my question.. I have a table as below. trans_date,cateory,amount 1-1-11,1,10 2-1-11,2,20 3-2-11,3,15 23-2-11,4,12 13-5-11,4,19 Need a query to get result like
DB2 - Development process
DB2  Actually I am participating in IBM's greatming challenges competition. I am using IBM's DB2 for database purpose. I don't know how to connect to database(DB2) from jsp application.I am using eclipse as an IDE. I am
jsp connection to db2
jsp connection to db2  hello friends i have a project to do in jsp using db2 database can anyone please help me in connecting a jsp page to db2 database?? please frienda help me
New to JSP..need help to make & run a JSP program.
New to JSP..need help to make & run a JSP program.  Hi, I have installed Tomcat 5.5 on my system. Plz help me to make a simple JSP program. And also how to run it.   Hi Friend, Have you set the classpath? Anyways
connecting servlet to db2 - JSP-Servlet
connecting servlet to db2  Hello sir, Iam new to db2.so I would like to know the procedure to connect to db2 from a servlet or jsp.Also Tell me the configuration we need to be done before connecting to the db2(such as what path
XML to DB2 Comparison using Java xpath
XML to DB2 Comparison using Java xpath  Hi , I am a manual tester...' products . i want to compare these xml values with db2 using Java. I have Good... from xml and save it a file. similar way query details from database and save
storing images in directory,saving path in db2
storing images in directory,saving path in db2  i am working in a web... in a folder and its path(relative/absolute) in my DB2 database. and when.... can you help?? i'm using DB2 databse Linux(fedora 13) environment
Sql Query
Sql Query  Is this query work in Db2 or not ? Select * from FORUM LIMIT 2
Sql Query
Sql Query  Is this query work in Db2 or not ? Select * from FORUM LIMIT 2
urgent need for jsp code with mysql query for uploading and downloading file - JSP-Servlet
urgent need for jsp code with mysql query for uploading and downloading file  can anyone tell me how to upload and download a doc file using jsp with mysql as the back end... and kindly help me to create the table too
JPA Named Query
by many classes and instances. For developing JPA Named Query, you need... JPA Named Query       In this section, you will read about the JPA Query, its types
Query
Query  how can i set path and Classpath or Environmental Variable for jsp/servlet program to compile and run
query
or JRE is the run time for executing the Java applications. Read more about JRE... independent: You can write and compile the Java program and then run on any platform
need
need  i need a jsp coding based project plz help me
query string
query string  Need some examples of query strings.send me as soon as possible. Regards, R.Santhosh
query optimization
query optimization  hai ! i need a code in java for database query optimization.plz help
DB2 Universal claims to support JDBC 2.0, But I can only get JDBC 1.0 functionality.
DB2 Universal claims to support JDBC 2.0, But I can only get JDBC 1.0 functionality.  DB2 Universal claims to support JDBC 2.0, But I can only get JDBC 1.0 functionality. What can I do
query related to jdbc
query related to jdbc  hello, i have done my database connection successfully ie db2 with RAD. but while running my application i am not able to fetch the data so please suggest and help me
What is query optimization?
of the best query is important when performance is considered. So you need to sql query tuning based on the requirement. The query optimizer is the component...What is query optimization?  What is query optimization?   
sql/xml query in jsp - JSP-Servlet
sql/xml query in jsp  Sir Here is my code which is not working..." ) Whenever i run this code in the eclipse i am getting... I have created database in db2 9 here are details of it: schema:"SYSTEM
mysql run multiple queries at once
mysql run multiple queries at once  Running two MySQL queries at a time in PHP mysql_query
sql query
numbers of sids.i want to delete the sid based on the mid.for that i need sql query plz help to me
sql query
numbers of sids.i want to delete the sid based on the mid.for that i need sql query plz help to me
sql query
numbers of sids.i want to delete the sid based on the mid.for that i need sql query plz help to me
sql query - JDBC
sql query  I need a SQL query to add data into database
query in JDBC
query in JDBC  What are the steps required to execute a query in JDBC
SQL QUERY
Gopal oracle C Now i need to write a query "which
how to run rmi program
how to run rmi program  how to run rmi program
run php code online
run php code online  Is it possible to run PHP Code online
insert query in jsp
insert query in jsp  give me insert code in jsp at run time
java pages run
java pages run  how do we run jsp file in the browser. do we need to install server. could it be run on the xamp server   You need Apache Tomcat Server to run the jsp code over it. Follow these steps to run the simple
Query Question
Query Question  How would I write a query to display the name, department of the employee that earns the highest salary in the Employees table
Simple Query on RDF file in Java
in this section we are going to describe how to run simple query on the RDF graph model. Now lets see the example that can fires a simple query. The example is going... Simple Query on RDF file in Java   
How to run? - Hibernate
How to run?  Hiiiiiiiiiiiii friend.. i am Magesh, doing MCA at Madurai in Tamilnadu. i know little bit about Jsp,Servlet.. But my... maps the Java classes to the database tables. It also provides the data query
best os to run java
best os to run java  which is best os to run java program
Java run time polymorphism
Java run time polymorphism  What is run-time polymorphism or dynamic method dispatch
Run time polymorphism
Run time polymorphism  What is run time polymorphism or dynamic method dispatch
Need of JUnit
Need of JUnit  Hi sir, What makes JUnit better than other... complex & takes less time. 3 JUnit tests can be run automatically and they check their own results and provide immediate feedback. There's no need
HQL Query
HQL Query  Hibernate query language: How to use a left join in Hibernate query language. Can somebody help with an example. I am getting a unexpected token error in HQL Query tool If I use joins
Query regarding hashmap
Query regarding hashmap  I want to store some names and ids in hashmap in session, then retrieve it on next page and iterate through ids to run a query using ids one at a time
Needs to Run - Struts
Needs to Run  What are the Fundamentals to Run a Struts Applications
Run XML file
Run XML file  Hi.. How do I execute or run an XML file? please tell me about that Thanks
jdbc query
jdbc query  write a query of how to print the values of any column present in database in reverse order
run project on company lan
run project on company lan  sir, i have create dynamic java project of complaint registration and run on local host http://localhost:8080 and by using ip adress but the problem is how to run it at on company server so
how to run this program?
how to run this program?  how to run java swing program   Java Swing program runs same as a simple java program. There is no difference... with javac and run with java command, same as a simple java program. Learn Swing
Advertisements
 

 

 

DMCA.com