 |
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: email an attachment as well as the body msg from mainframe |
|
| Cathygomez Replies: 4 Views: 5148 |
 Forum: Job Control Language(JCL) Posted: Thu May 05, 2005 11:14 am Subject: email an attachment as well as the body msg from mainframe |
| Hi all,
I need to sent a attachment as well as some message in the body of the email from Batch job in mainframe. I used the following jcl to sent an attachement. But i couldnot add any message in th ... |
|
| Topic: Adding a to a field using syncscort |
|
| Cathygomez Replies: 1 Views: 1745 |
Forum: Utilities Posted: Tue Aug 24, 2004 9:25 am Subject: Adding a to a field using syncscort |
| hi,
We have syncsort in our shop. My requirement is I have a file with a singe record with the following details File contains "Updated 00010 TIMES" I want to add 1 to "00010". I need to ... |
|
| Topic: Error:"ORDER BY" CLAUSE NOT PERMITTED |
|
| Cathygomez Replies: 3 Views: 2971 |
Forum: Database Posted: Thu Aug 19, 2004 1:06 am Subject: Error:"ORDER BY" CLAUSE NOT PERMITTED |
| mangsk,
Try this, EXEC SQL SELECT COUNT(*) INTO :WS-GLSSVLD1-CO-DES-CNT FROM TABLE_NAME GROUP BY SYS_ID FETCH FIRST 1 ROWS ONLY ORDER BY 1 DESC END-EXEC. Here ORDER BY Clause comes ... |
|
| Topic: DB2 SPUFI -SUM of an Alias column??? |
|
| Cathygomez Replies: 2 Views: 3287 |
Forum: Database Posted: Thu Aug 19, 2004 1:01 am Subject: DB2 SPUFI -SUM of an Alias column??? |
| Salimo,
Try this... SELECT SUM(PEOPLE_CNT) FROM (SELECT COL1, COL2, COUNT(COL1) AS PEOPLE_CNT FROM TABLE1 GROUP BY COL1, COL2) as X HTH |
|
| Topic: VSAM - Fixed length & Variable length Definition? |
|
| Cathygomez Replies: 7 Views: 6288 |
Forum: Data Management Posted: Thu Aug 12, 2004 2:03 am Subject: VSAM - Fixed length & Variable length Definition? |
| Kolusu,
I was trying to use a VSAM file with max=175 and averag=175 as a input in Syncsort. I was thinking that this file is a fixed lenght file hence I framed the outrec without considering the fir ... |
|
| Topic: VSAM - Fixed length & Variable length Definition? |
|
| Cathygomez Replies: 7 Views: 6288 |
Forum: Data Management Posted: Wed Aug 04, 2004 5:22 am Subject: VSAM - Fixed length & Variable length Definition? |
| Hi
when do we say the VSAM(KSDS) file as a fixed length file or Variable length file? |
|
All times are GMT - 5 Hours |