 |
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 13 matches |
| Author | Message |
|---|---|
 Topic: CAST with CASE Statement |
|
| subho Replies: 3 Views: 2519 |
 Forum: Database Posted: Fri Jul 10, 2009 8:22 am Subject: CAST with CASE Statement |
| Kolusu,
Thanks for your reply. Yes, it works as well! I have multiple WHEN in CASE statements of my query and my last WHEN is substituted with ELSE. Thanks, Subho |
|
| Topic: CAST with CASE Statement |
|
| subho Replies: 3 Views: 2519 |
Forum: Database Posted: Thu Jul 09, 2009 5:17 pm Subject: CAST with CASE Statement |
| I think I have got the solution. The following SQL works for me:
SELECT CASE WHEN A1 IN (1,2,9) THEN CAST(4 AS SMALLINT) WHEN A1 IN (6,7) THEN CAST(5 AS SMALLINT) ... |
|
| Topic: CAST with CASE Statement |
|
| subho Replies: 3 Views: 2519 |
Forum: Database Posted: Thu Jul 09, 2009 5:14 pm Subject: CAST with CASE Statement |
|
SELECT CAST (CASE WHEN A1 IN (1,2,9) THEN 4 WHEN A1 IN (6,7) THEN 5 END CASE AS SMALLINT), COL2 FROM TABLE1 WHERE A1 IN (1,2,6,7,9) ; My objective ... |
|
| Topic: Platinum Performance issue for unloading |
|
| subho Replies: 6 Views: 4363 |
Forum: Database Posted: Mon Apr 14, 2008 4:35 pm Subject: Platinum Performance issue for unloading |
| Chuck,
Unloading multiple tables and match merging in COBOL program is a standard practise which we do a lot in our shop. My point is to avoid this process and get the platinum working. Any help ... |
|
| Topic: Need tips for tuning below mentioned queries |
|
| subho Replies: 14 Views: 6142 |
Forum: Database Posted: Mon Apr 14, 2008 11:17 am Subject: Need tips for tuning below mentioned queries |
| Mainframes530,
Have you considered to add any more predicate? Have you considered to create a small set of table for the larger table? Have your SQL expedited using IN and BETWEEN? Please let u ... |
|
| Topic: Platinum Performance issue for unloading |
|
| subho Replies: 6 Views: 4363 |
Forum: Database Posted: Mon Apr 14, 2008 10:52 am Subject: Platinum Performance issue for unloading |
| Chuck,
Thanks for your reply. Yes, I will go in this route if i don't find any alternative to get the result using platinum or any utility directly. Again, I have two main concerns here. 1. Perform ... |
|
| Topic: Platinum Performance issue for unloading |
|
| subho Replies: 6 Views: 4363 |
Forum: Database Posted: Fri Apr 11, 2008 2:38 pm Subject: Platinum Performance issue for unloading |
| Chuck,
Thanks for your suggestion. I have already thought (matter of fact, wrote the high level spec) in the same route if platinum join of two tables don't work efficiently. But I was wondering if t ... |
|
| Topic: Platinum Performance issue for unloading |
|
| subho Replies: 6 Views: 4363 |
Forum: Database Posted: Thu Apr 10, 2008 2:34 pm Subject: Platinum Performance issue for unloading |
| When I use platinum unload batch utility to unload a single DB2 table, it works great. But when I use this unload by joining two (2) DB2 tables, it runs for a long time and eventually I have to kill t ... | |
| Topic: Delete and Count in DB2 |
|
| subho Replies: 2 Views: 2903 |
Forum: Database Posted: Fri Jun 09, 2006 1:40 pm Subject: Delete and Count in DB2 |
| I have a COBOL with embedded SQL for DB2 program. I want to get the number of rows which are deleted from the DB2 table. I can do it in two steps easily. At first, count how many records will be delet ... | |
| Topic: How do we create a different record length file? |
|
| subho Replies: 5 Views: 2701 |
Forum: Utilities Posted: Tue Nov 16, 2004 4:21 pm Subject: How do we create a different record length file? |
| Thanks a lot!! It's working PERFECT!!
Thanks again, Subho |
|
| Topic: How do we create a different record length file? |
|
| subho Replies: 5 Views: 2701 |
Forum: Utilities Posted: Tue Nov 16, 2004 3:19 pm Subject: How do we create a different record length file? |
| In addition to this issue, how can we have a different length output file where additional field is in between? For an example record length of input file is 90. Output file will have record length of ... | |
| Topic: How do we create a different record length file? |
|
| subho Replies: 5 Views: 2701 |
Forum: Utilities Posted: Tue Nov 16, 2004 1:58 pm Subject: How do we create a different record length file? |
It worked!!! woow..  Thanks a lot!!
Subho |
|
| Topic: How do we create a different record length file? |
|
| subho Replies: 5 Views: 2701 |
Forum: Utilities Posted: Tue Nov 16, 2004 1:24 pm Subject: How do we create a different record length file? |
I have searched in this forum but couldn't find it.  How do we create a dataset from another dataset, which will have just one byte extra? For an example, I have a file with Record Length 105. I wa ... |
|
All times are GMT - 5 Hours |