 |
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 200 matches |
| Author | Message |
|---|---|
 Topic: MS Access SQL Query Help |
|
| CraigG Replies: 1 Views: 2732 |
 Forum: Database Posted: Mon Nov 17, 2014 8:56 am Subject: MS Access SQL Query Help |
| And what does MS Access DB have to do wiith MVS? | |
| Topic: GDG - creation date of multiple generations using (0) (-1) |
|
| CraigG Replies: 5 Views: 4882 |
Forum: Utilities Posted: Wed Sep 24, 2014 2:27 pm Subject: GDG - creation date of multiple generations using (0) (-1) |
| Thank you very much! One step and I can add the version as another parm, which I had intended to do anyhow!
You had better learn the difference between versions and generations!! |
|
| Topic: Convert PS to excel |
|
| CraigG Replies: 7 Views: 6469 |
Forum: Job Control Language(JCL) Posted: Tue Feb 22, 2011 7:12 am Subject: Convert PS to excel |
| That is the way excel handles numbers! | |
| Topic: How to find the Table's last updated details |
|
| CraigG Replies: 3 Views: 2510 |
Forum: Database Posted: Wed Dec 01, 2010 12:53 pm Subject: Re: How to find the Table's last updated details |
| Hello All,
I have searched for this query in forum.But I didn't get the answer. So I am posting here. I would like to know the date, when a particular DB2 table updated(Ex:few new columns added ... |
|
| Topic: TSO Edit - change command with single quote in 'from' value |
|
| CraigG Replies: 6 Views: 4505 |
Forum: TSO and ISPF Posted: Wed Jul 28, 2010 6:57 pm Subject: TSO Edit - change command with single quote in 'from' value |
| C "C'" "C'A" ALL
Use double quotes as the delimiter the you can use single quotes within the from and to strings. |
|
| Topic: how to select the latest PS file |
|
| CraigG Replies: 22 Views: 13815 |
Forum: Job Control Language(JCL) Posted: Fri Jul 02, 2010 7:26 am Subject: how to select the latest PS file |
| Shyam,
Help me understand. For ur question I think you have a GDG base "'aaaa.bbbb.cccc" and there are diff versions created. You want to send the latest version through FTP ... correct. ... |
|
| Topic: how to select the latest PS file |
|
| CraigG Replies: 22 Views: 13815 |
Forum: Job Control Language(JCL) Posted: Thu Jul 01, 2010 9:59 am Subject: how to select the latest PS file |
| That is why there GDG's! | |
| Topic: Cics and address space |
|
| CraigG Replies: 6 Views: 4103 |
Forum: CICS and Middleware Posted: Fri Apr 02, 2010 6:54 am Subject: Cics and address space |
| Use of unintialized working storage variables is a very poor practice and you are getting what you deserve! | |
| Topic: Calculate # of weekend days between 2 date ranges |
|
| CraigG Replies: 8 Views: 3565 |
Forum: Database Posted: Fri Mar 12, 2010 6:04 pm Subject: Calculate # of weekend days between 2 date ranges |
| One little mistake
weekend_days = days(begin-date) - days(end-date) - weekdays(begin-date, end-date) should be weekend_days = days(end-date) - days(begin-date) - weekdays(begin-date, end-date) |
|
| Topic: Calculate # of weekend days between 2 date ranges |
|
| CraigG Replies: 8 Views: 3565 |
Forum: Database Posted: Fri Mar 12, 2010 3:54 pm Subject: Calculate # of weekend days between 2 date ranges |
| I had to come up with calculations for workdays so for a Monday thru Friday work week
weekend_days = days(begin-date) - days(end-date) - weekdays(begin-date, end-date) ... |
|
| Topic: Empty file to SYNCSORT |
|
| CraigG Replies: 1 Views: 1904 |
Forum: Job Control Language(JCL) Posted: Thu Dec 17, 2009 7:45 pm Subject: Empty file to SYNCSORT |
| Just supply the RECFM, LRECL, and BLKSIZE with the DD DUMMY statement. | |
| Topic: SDSF data in column 1 |
|
| CraigG Replies: 3 Views: 3128 |
Forum: Job Control Language(JCL) Posted: Tue Jul 21, 2009 8:59 am Subject: SDSF data in column 1 |
| RTFM -- Write after advancing! | |
| Topic: ADRDSSU Utility problem |
|
| CraigG Replies: 6 Views: 10010 |
Forum: Job Control Language(JCL) Posted: Fri Jul 10, 2009 12:58 pm Subject: ADRDSSU Utility problem |
| A Job was run using the utility FDRDSF to backup to a tape
I would look in the documentation for FDR to find out how to restore it. |
|
| Topic: ADRDSSU Utility problem |
|
| CraigG Replies: 6 Views: 10010 |
Forum: Job Control Language(JCL) Posted: Fri Jul 10, 2009 9:42 am Subject: ADRDSSU Utility problem |
| ADR389E (001)-IORT (01), INVALID INPUT ON DDNAME TAPE, INPUT DATA SET NOT PRODUCED BY DFDSS OR DFSMSDSS
That looks like a clue as to what your problem is, how was the tape produce ... |
|
| Topic: Timestamp Formatting in Spufi |
|
| CraigG Replies: 4 Views: 3057 |
Forum: Database Posted: Wed Jun 24, 2009 2:14 pm Subject: Re: Timestamp Formatting in Spufi |
| Hi,
I have two Timestamp Variables on two different tables. I need to get the difference of them in Timesamp Format(atleast I need Days, hours, Minutes differences). I tried: a) B.UDT_TS - A.REC_ ... |
|
All times are GMT - 5 Hours |