 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 49 matches |
| Author | Message |
|---|---|
 Topic: Does Sequence matter for INNER JOIN or LEFT OUTER JOIN |
|
| seekaysk Replies: 0 Views: 2310 |
 Forum: Database Posted: Wed Oct 07, 2009 1:09 pm Subject: Does Sequence matter for INNER JOIN or LEFT OUTER JOIN |
| Hi,
I am running an explain onto a query where I am puzzled to see that the number of columns that match for a table changes if I change the sequence of INNER JOIN and LEFT OUTER JOIN. i.e., inste ... |
|
| Topic: Get 12 Periods(Monthly, Quarterly or Yearly) from given date |
|
| seekaysk Replies: 5 Views: 3091 |
Forum: Database Posted: Tue Sep 29, 2009 8:43 am Subject: Get 12 Periods(Monthly, Quarterly or Yearly) from given date |
| Thanks a lot Kolusu. This should be fine.
Also while testing I was receiving 01056 sqlstate on the formula given by you for date adjustments. Hence, for documentation I am presenting the modified ... |
|
| Topic: Get 12 Periods(Monthly, Quarterly or Yearly) from given date |
|
| seekaysk Replies: 5 Views: 3091 |
Forum: Database Posted: Mon Sep 28, 2009 2:58 pm Subject: Get 12 Periods(Monthly, Quarterly or Yearly) from given date |
| To give more insight, this is the query I have build up. (Nothing but joining all 3 queries using CASE statement).
It is not embedded in program and hence not tested with any syntax or so errors. ... |
|
| Topic: Get 12 Periods(Monthly, Quarterly or Yearly) from given date |
|
| seekaysk Replies: 5 Views: 3091 |
Forum: Database Posted: Mon Sep 28, 2009 1:55 pm Subject: Get 12 Periods(Monthly, Quarterly or Yearly) from given date |
| Thanks Kolusu.
Yes, the 12 periods are inclusive of the given date. Ultimately, the From_date extracted out of these queries will help to get the necessary data from the other tables. These period ... |
|
| Topic: Get 12 Periods(Monthly, Quarterly or Yearly) from given date |
|
| seekaysk Replies: 5 Views: 3091 |
Forum: Database Posted: Mon Sep 28, 2009 1:11 pm Subject: Get 12 Periods(Monthly, Quarterly or Yearly) from given date |
| Hi,
I am back with again a query on dates logic. However, It is not a problem. I already have the queries with me ready giving correct output. However, they are 3 different queries to get 12 perio ... |
|
| Topic: Handling zero selected rows in query itself - for Inner quer |
|
| seekaysk Replies: 4 Views: 2674 |
Forum: Database Posted: Wed Jul 22, 2009 3:00 pm Subject: Handling zero selected rows in query itself - for Inner quer |
| great. thanks again for the extended help. This is a very handy doc. | |
| Topic: Handling zero selected rows in query itself - for Inner quer |
|
| seekaysk Replies: 4 Views: 2674 |
Forum: Database Posted: Wed Jul 22, 2009 8:29 am Subject: Handling zero selected rows in query itself - for Inner quer |
| This is great. thanks a lot kolusu. I am learning IBMREQD parameter for the first time here. thank you so much for the prompt reply.
P.S. I was taking time to test with various scenarios and hence ... |
|
| Topic: Handling zero selected rows in query itself - for Inner quer |
|
| seekaysk Replies: 4 Views: 2674 |
Forum: Database Posted: Tue Jul 21, 2009 1:48 pm Subject: Handling zero selected rows in query itself - for Inner quer |
| Hi,
I have to write an inner subquery. Its supposed to be small and requirements too are minimal. However, I tried a lot framing the query as well as find it here but in vain. Please help me. ... |
|
| Topic: Avoiding the cursor |
|
| seekaysk Replies: 6 Views: 3071 |
Forum: Database Posted: Wed Mar 18, 2009 12:45 pm Subject: Avoiding the cursor |
| yes. I do have. It would be the set of two columns. One is: "unique id" column (PIC S9(9) COMP) and other is date column. This combination of two columns is unique. | |
| Topic: Avoiding the cursor |
|
| seekaysk Replies: 6 Views: 3071 |
Forum: Database Posted: Tue Mar 17, 2009 1:54 pm Subject: Avoiding the cursor |
| thanks jsharon1248. | |
| Topic: Avoiding the cursor |
|
| seekaysk Replies: 6 Views: 3071 |
Forum: Database Posted: Tue Mar 17, 2009 1:21 pm Subject: Avoiding the cursor |
| Thanks kolusu for repying.
fyi. It is only one standalone column that I need to select in my cursor or standalone select statement. And all I need is the only final computed value. |
|
| Topic: Avoiding the cursor |
|
| seekaysk Replies: 6 Views: 3071 |
Forum: Database Posted: Tue Mar 17, 2009 12:29 pm Subject: Avoiding the cursor |
| Hey guys,
I have to apply a formula to one columns of values. I was trying to think if I could avoid a cursor and just do it within a select or may be something like that... details: Table1 con ... |
|
| Topic: Playing with dates in DB2 query |
|
| seekaysk Replies: 2 Views: 2165 |
Forum: Database Posted: Thu Mar 12, 2009 2:44 pm Subject: Playing with dates in DB2 query |
| Oh my god...Bravo Kolusu! and simultaneously foolish on my side...This is what happens when we perceive the requirements as so complex...Anyways, I am happy it serves a good thread with a simple solut ... | |
| Topic: Playing with dates in DB2 query |
|
| seekaysk Replies: 2 Views: 2165 |
Forum: Database Posted: Thu Mar 12, 2009 11:50 am Subject: Playing with dates in DB2 query |
| Hi all,
My requirement is: for requested date as input (that date is in some table), I need to send an output (in yearly format) with 10 years of data before requested date. E.g. if Input date ... |
|
| Topic: Negative base with fractional Exponents |
|
| seekaysk Replies: 7 Views: 5921 |
Forum: Application Programming Posted: Thu Oct 23, 2008 3:05 pm Subject: Negative base with fractional Exponents |
| thanks jsharon1248 and all. I am still not sure whether multiplying the result by -1 is the exact logical thing to do...and that's the reason i had this thread so that I can know the experts views. I ... | |
All times are GMT - 5 Hours |