 |
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 6 matches |
| Author | Message |
|---|---|
 Topic: CICS Working Storage AREA Initialization |
|
| salimo Replies: 0 Views: 2232 |
 Forum: CICS and Middleware Posted: Thu Feb 17, 2005 9:19 am Subject: CICS Working Storage AREA Initialization |
 I've searched your Dbase and found nothing on this topic.
CICS(Transaction Server Ver. 2.2 ) compiling with Cobol LE, No longer does WS(Working Storage) in a CICS program get initialized each t ... |
|
| Topic: DB2 SPUFI -SUM of an Alias column??? |
|
| salimo Replies: 2 Views: 3376 |
Forum: Database Posted: Fri Jul 16, 2004 8:13 am Subject: DB2 SPUFI -SUM of an Alias column??? |
| In DB2 SPUFI,
Is there a way to total(SUM) the result of PEOPLE_CNT in the same query? To get the SUM for both Male and Female?NOTE: The SUM function against the alias PEOPLE_CNT does not work !!!! ... |
|
| Topic: Select TOP 10 in DB2 SQL- SPUFI |
|
| salimo Replies: 2 Views: 2388 |
Forum: Database Posted: Tue Jun 22, 2004 7:32 am Subject: TOP N / THANKS |
| Thank you Kolusu,
I totally missed the SEARCH ENGINE is a terrible thing to waste. I will use it before posting. Thanks again. |
|
| Topic: Select TOP 10 in DB2 SQL- SPUFI |
|
| salimo Replies: 2 Views: 2388 |
Forum: Database Posted: Fri Jun 18, 2004 5:36 pm Subject: Select TOP 10 in DB2 SQL- SPUFI |
| Any help with how to accomplish getting the TOP 10 rows
from any Table in DB2 SQL, using SPUFI. I've read the DB2 SQL manual, and it talks about OPTIMIZE FOR, but thats for embedded code. I canno ... |
|
| Topic: DB2 SPUFI CASE statement question |
|
| salimo Replies: 3 Views: 4063 |
Forum: Database Posted: Fri Jun 18, 2004 2:43 pm Subject: CASE in SPUFI SQL, -THANK YOU. |
| THANK YOU.
I was missing a comma after the column name on Select line. AND If your using a Date register the WHEN should refer to an interger, - no ticks. Thanks again for the reply. |
|
| Topic: DB2 SPUFI CASE statement question |
|
| salimo Replies: 3 Views: 4063 |
Forum: Database Posted: Fri Jun 18, 2004 9:28 am Subject: DB2 SPUFI CASE statement question |
|
Can someone offer some help with the below SQL executing with "SPUFI" ,- "CASE" statements. I've lookked at the SQL programmers guide, and cannot see why the SQL below does not work? SEL ... |
|
All times are GMT - 5 Hours |