 |
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 17 matches |
| Author | Message |
|---|---|
 Topic: Alter clustered index |
|
| showkath Replies: 4 Views: 1938 |
 Forum: Database Posted: Thu Oct 04, 2007 4:38 pm Subject: Alter clustered index |
| Hi,
I am looking for the exact syntax or samples for altering a clustered index for redefining the index cluster with new values. Also please let me know the steps involved in implementing this ... |
|
| Topic: Record count in each partition |
|
| showkath Replies: 4 Views: 2115 |
Forum: Database Posted: Mon Sep 17, 2007 11:55 am Subject: Record count in each partition |
| Hi Kolusu,
Thanks for your suggestion. Actually it's a 100 part table and it has two partition keys. so I have to write 100 Select queries to get the record count based on the partition range. I t ... |
|
| Topic: Comparison query |
|
| showkath Replies: 11 Views: 4369 |
Forum: Database Posted: Fri Sep 30, 2005 3:19 am Subject: Comparison query |
| Phantom,
Thanks for that. It really solved my problem. |
|
| Topic: Comparison query |
|
| showkath Replies: 11 Views: 4369 |
Forum: Database Posted: Thu Sep 29, 2005 10:41 pm Subject: Comparison query |
| Phantom,
You are right. It should be B.FLD1 instead of B.LOT. I want to select the four columns and compare them side by side for the corresponding Fld1. That's why i am not comparing the co ... |
|
| Topic: Comparison query |
|
| showkath Replies: 11 Views: 4369 |
Forum: Database Posted: Thu Sep 29, 2005 5:16 am Subject: Comparison query |
| Hi Kolusu,
Query suggested by you works fine. With that I have tried the below query to display the number of records if the count does not match from both the tables, for particular value of fld ... |
|
| Topic: Comparison query |
|
| showkath Replies: 11 Views: 4369 |
Forum: Database Posted: Mon Sep 26, 2005 10:27 pm Subject: Comparison query |
| Thanks guys for your excellent suppport. | |
| Topic: Comparison query |
|
| showkath Replies: 11 Views: 4369 |
Forum: Database Posted: Mon Sep 26, 2005 7:34 am Subject: Comparison query |
| Hi,
Could you help me in writing a query for the below requirement I need to find out the difference between two tables as follows Table A: Fld1, Fld2 Table B: Fld1, Fld2 I want to ... |
|
| Topic: RPAD / LPAD function in DB2 |
|
| showkath Replies: 6 Views: 4090 |
Forum: Database Posted: Wed Jun 08, 2005 6:07 am Subject: RPAD / LPAD function in DB2 |
| Kolusu,
Thanks for your reply. |
|
| Topic: RPAD / LPAD function in DB2 |
|
| showkath Replies: 6 Views: 4090 |
Forum: Database Posted: Tue Jun 07, 2005 10:29 pm Subject: Actual requirement... |
| Kolusu,
Thanks for your timely reply. Let us consider the following example. A table TMP001 has a column MAIL_ID of type char(10) which would have values in the form COMP001, COMP002, COMP00 ... |
|
| Topic: RPAD / LPAD function in DB2 |
|
| showkath Replies: 6 Views: 4090 |
Forum: Database Posted: Tue Jun 07, 2005 5:58 am Subject: RPAD / LPAD function in DB2 |
| Hi,
Could anyone please let me know whether DB2 has RPAD / LPAD function similar to Oracle. |
|
| Topic: Query for reconciliation report |
|
| showkath Replies: 2 Views: 1547 |
Forum: Database Posted: Thu Jun 02, 2005 7:23 am Subject: Query for reconciliation report |
| kOLUSU,
Thanks for ur prompt reply. That query is working as per the requirement. Thanks a lot. Regards, Showkath |
|
| Topic: Query for reconciliation report |
|
| showkath Replies: 2 Views: 1547 |
Forum: Database Posted: Thu Jun 02, 2005 5:46 am Subject: Query for reconciliation report |
| Hi,
Please help me to write the following query Consider following table. ACCTFIN ACCOUNT ID SEQ_NO SHRS DOLS A M 1 100 100 B M 2 200 ... |
|
| Topic: Week number of a year according to MS outllook calendar |
|
| showkath Replies: 2 Views: 1581 |
Forum: Database Posted: Wed May 04, 2005 10:26 pm Subject: Week number of a year according to MS outllook calendar |
| Dear Kolusu,
Thanks in bunch. Regards, Showkath |
|
| Topic: Week number of a year according to MS outllook calendar |
|
| showkath Replies: 2 Views: 1581 |
Forum: Database Posted: Wed May 04, 2005 5:51 am Subject: Week number of a year according to MS outllook calendar |
| Hi all,
Can anyone help me to solve the following: I want to find out the week number for the given date as per MS outlook Calendar calculation in DB2. For example, 1) if date is 01-jan ... |
|
| Topic: Indexed / Relative file without VSAM |
|
| showkath Replies: 2 Views: 1308 |
Forum: Application Programming Posted: Tue May 03, 2005 6:16 am Subject: Indexed / Relative file without VSAM |
|
Kolusu, Thanks a lot. |
|
All times are GMT - 5 Hours |