One store procedure is working fine at one location. But the same store procedure is taking too much time to execute in different location on same network. What would be reason for this and how to reduce response time?

In other databases we get data based on index using LIMIT. Example: SELECT * FROM ZEMPLOYEE LIMIT 2,9. I tried using native SQL it works fine if we give LIMIT 3, it will fetch the records from 1-3 but when I give LIMIT 2,9. Then it should fetch the data from 2nd record to 9th record but It through...

Hello, For the first time in my IT-life I've encountered following error message when I try to run query using ROWID on a view: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table I found something about key-preserved tables, but I'm not sure that my...

I'd appreciate some help here. My JCL background is HP3000 / MPEX and HP-UX, but my IBM mainframe JCL experience is over ten (10) years old. So I'm having problems creating a JCL - my brain can't remember command syntax's from that long ago. I need to create a JCL that will accept an input file of...

How do I list the mid-western vendors (Illinois, Indiana, Iowa, Minnesota, Wisconsin)? Also display the vendor ID, name, contact name (first & last), city, and state. Use formatting and concatenation to reduce the space required for the contact and city (30 characters should be fine). Order the...

We need to find 50% of employee from each department, who is getting max salary. And every department have different employee count. ex. finance may have 100 employees and sale may have 40 employee. How do I write a query for this?

In a large logfile I have records containing the field INVNO (invoice-number). The lowest and highest values are easy to find, BUT it looks like some numbers in between are not there. Anyone got a trick with SQL, which can tell which numbers are missing within the numberrange (step 1) ?

Hi, I'm on 6.1 and I have RUNSQL in a CL program. The statement is 'UPDATE ...' and run's okay but I need to get the SQL MSG SQL7957 with the number of rows updated or the SQL0100 (row not found). I can get this with RCVMSG but only in debug mode. Can anyone help me? Rui

I have a select query that returns 500000 rows. I need to display 100 rows per page. When the user navigates to next page, I need to display the rows between 100 and 200 and so on. I am using DB2 v10 and java. My query is taking long time to fetch the data even though I am fetching 100 rows at a...

I have a web service using a iDB2 connection to return a Data Set. I am searching a large table on a partial string to find a portion of a serial number, I kept getting this SQL0666 error so I had a new LF created over the file on the i-Series side by the text field I am searching on and it now...

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy