 |
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 48 matches |
| Author | Message |
|---|---|
 Topic: DB2 query to Sum Negatives and Positives seperately |
|
| gans79 Replies: 3 Views: 2304 |
 Forum: Database Posted: Fri Aug 13, 2010 1:05 am Subject: DB2 query to Sum Negatives and Positives seperately |
Thanks Kolusu and everybody !! it worked , It saved me lot of time 
Truly appreciate the help you & your team are providing to the MVS community . Gans79 |
|
| Topic: DB2 query to Sum Negatives and Positives seperately |
|
| gans79 Replies: 3 Views: 2304 |
Forum: Database Posted: Thu Aug 12, 2010 9:29 am Subject: DB2 query to Sum Negatives and Positives seperately |
| Hi,
I have a table A , which has a field Gain-Loss which can be either negative(Loss) or positive(Gain), How can i get the sum of Gains and Sum of Loss from a DB2 Query ? Thanks Gans |
|
| Topic: soc7 for sum for sign leading for VB file |
|
| gans79 Replies: 7 Views: 6724 |
Forum: Utilities Posted: Tue Jul 14, 2009 9:18 pm Subject: soc7 for sum for sign leading for VB file |
| Brian,
can you pls modify the sort card with Outrec , edit i tried going thru the manual, but could not understand much Thanks Ganesh |
|
| Topic: soc7 for sum for sign leading for VB file |
|
| gans79 Replies: 7 Views: 6724 |
Forum: Utilities Posted: Tue Jul 14, 2009 7:31 am Subject: soc7 for sum for sign leading for VB file |
| SSF does not work with syncsort , is there any workaround ? | |
| Topic: soc7 for sum for sign leading for VB file |
|
| gans79 Replies: 7 Views: 6724 |
Forum: Utilities Posted: Tue Jul 14, 2009 4:31 am Subject: soc7 for sum for sign leading for VB file |
| Hi,
Getting a soc7 for the below VB file with 2 fields can someone help me this pls X(19) S9(14).9(5) sign leading seperate AAAAAAAAAAAAAAAAAAA-000000000664363500 ... |
|
| Topic: Restore Deleted Tape |
|
| gans79 Replies: 3 Views: 8502 |
Forum: Data Management Posted: Mon Mar 02, 2009 1:17 am Subject: Restore Deleted Tape |
| Hi,
Can we Restore a deleted Tape using any tool , anything similar to ISMF for DASD's ? any help would be greatly appreciated . Thanks gans79 |
|
| Topic: Get latest record in a GDG |
|
| gans79 Replies: 2 Views: 1624 |
Forum: Utilities Posted: Fri Jan 23, 2009 8:58 am Subject: Get latest record in a GDG |
| Hi superk,
What do i specify in the sort card to select the first occurance ? Thanks gans79 |
|
| Topic: Get latest record in a GDG |
|
| gans79 Replies: 2 Views: 1624 |
Forum: Utilities Posted: Fri Jan 23, 2009 8:21 am Subject: Get latest record in a GDG |
| Hi,
I have a GDG with limit 10, LRECL - 80, Account (1 - 9, CH) How to i get only the latest record from all the generations ? That is, if the account is present in File.Gen(-2) and File.Gen(-4) It ... |
|
| Topic: GVEXPORT VS GVRESTOR |
|
| gans79 Replies: 1 Views: 4790 |
Forum: Utilities Posted: Tue Dec 16, 2008 8:43 am Subject: GVEXPORT VS GVRESTOR |
| Hi,
Can someone let me know the difference between the FAVER products GVEXPORT and GVRESTOR Ganesh |
|
| Topic: No of rows returned by a cursor |
|
| gans79 Replies: 2 Views: 1771 |
Forum: Database Posted: Fri Jul 18, 2008 2:39 am Subject: No of rows returned by a cursor |
| Hi,
I there a way to find the no of rows returned by a cursor without executing a Count(*), I beleive there is a SQLCA variavle sqlerrd(3) which returns no of rows inserted/updated not sure if it wi ... |
|
| Topic: Zip CSV file |
|
| gans79 Replies: 1 Views: 1901 |
Forum: Job Control Language(JCL) Posted: Wed Jun 18, 2008 3:58 am Subject: Zip CSV file |
| Hi,
Can anybody let me the procedure to Zip a CSV file and send it as a MIME attachment thru SMTP. |
|
| Topic: DYNAM/NODYNAM |
|
| gans79 Replies: 1 Views: 3921 |
Forum: Application Programming Posted: Mon Jun 09, 2008 4:28 am Subject: DYNAM/NODYNAM |
| Hi,
I know DYNAM and NODYNAM are compiler options but im not sure how to give these options ( To Cobol Compiler IGYCRCTL or to the Linkage editor IEWL ), Can someone please clarify this . Thanks ... |
|
| Topic: How to send a mail with attachment thru JCL...? |
|
| gans79 Replies: 8 Views: 12938 |
Forum: Job Control Language(JCL) Posted: Tue Jan 22, 2008 5:47 am Subject: How to send a mail with attachment thru JCL...? |
| It worked kolusu, Thanks a lot . I really appreciate your time and effort in helping us solve problems in the need of the hour . | |
| Topic: How to send a mail with attachment thru JCL...? |
|
| gans79 Replies: 8 Views: 12938 |
Forum: Job Control Language(JCL) Posted: Mon Jan 21, 2008 5:13 am Subject: How to send a mail with attachment thru JCL...? |
| Hi,
I tried implementing the above JCL to send a dataset as a email attachment It worked .but one alphanumeric record "02E0006" was converted into "2.00E+06" in the ".csv&qu ... |
|
| Topic: VSAM File status 90 |
|
| gans79 Replies: 1 Views: 7941 |
Forum: Data Management Posted: Thu Jun 28, 2007 8:29 am Subject: VSAM File status 90 |
| Hi,
I'am getting a VSAM file open error 90, I came to know that it can be resolved by IDCAMS VERIFY , can anyone give me the the JCL or the procedure to do this Any help would be really appreciate ... |
|
All times are GMT - 5 Hours |