 |
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 19 matches |
| Author | Message |
|---|---|
 Topic: Status line W |
|
| Celeste Locklin Replies: 4 Views: 3652 |
 Forum: TSO and ISPF Posted: Tue Jan 21, 2014 2:06 pm Subject: Status line W |
| i never could get rid of it, it went away when i logged off and back on. with the W, when i was insert mode and would insert characters, the existing characters on the line would wrap to a new line th ... | |
| Topic: Status line W |
|
| Celeste Locklin Replies: 4 Views: 3652 |
Forum: TSO and ISPF Posted: Fri Jan 17, 2014 6:51 pm Subject: Status line W |
| somehow i activated something that is indicated by a W in the status line on the bottom just to the right of where the insert indicator ^ is. anyone know what i did and how to undo it ? | |
| Topic: PDS member name alias |
|
| Celeste Locklin Replies: 1 Views: 5501 |
Forum: Data Management Posted: Thu Nov 14, 2013 5:37 pm Subject: PDS member name alias |
| what are reasons for creating an alias for a pds member?
i have seen them in change management libraries. Is there any other reason to use one? |
|
| Topic: SQL to relate table rows |
|
| Celeste Locklin Replies: 3 Views: 2671 |
Forum: Database Posted: Fri Sep 16, 2011 3:45 pm Subject: SQL to relate table rows |
| you are the best ! I had to do a little tweaking, adding sum, digits, and dec() but it works
SELECT DIGITS(SUM (CASE WHEN PMT_CD_1 IN ( ... |
|
| Topic: SQL to relate table rows |
|
| Celeste Locklin Replies: 3 Views: 2671 |
Forum: Database Posted: Thu Sep 15, 2011 1:12 pm Subject: SQL to relate table rows |
| My requirement is to add the amts that correspond to the cds where the cd is one of the following values: 'C','D','K','3'
My table contains the following rows: PMT_CD_1 CHAR(2) ... |
|
| Topic: Display decimal |
|
| Celeste Locklin Replies: 4 Views: 2715 |
Forum: Database Posted: Fri Jul 01, 2011 1:19 pm Subject: Display decimal |
amazing.  |
|
| Topic: Display decimal |
|
| Celeste Locklin Replies: 4 Views: 2715 |
Forum: Database Posted: Fri Jul 01, 2011 11:42 am Subject: Display decimal |
| brilliant ! but it turns out to be
CHAR(PMT_AMT) DECIMAL 000000412.80 now how do i suppress those leading zeros ? |
|
| Topic: Display decimal |
|
| Celeste Locklin Replies: 4 Views: 2715 |
Forum: Database Posted: Thu Jun 30, 2011 7:07 pm Subject: Display decimal |
| my table field is defined as PMT_AMT DECIMAL(11,2)
when i select it, i want it to appear in my output formatted as 00000000000.00 i have tried cast(PMT_AMT) & get a hex display ... |
|
| Topic: DMBATCH output |
|
| Celeste Locklin Replies: 11 Views: 9948 |
Forum: Job Control Language(JCL) Posted: Tue Feb 08, 2011 6:15 pm Subject: DMBATCH output |
| it sure would have been nice if the author had left a comment. | |
| Topic: DMBATCH output |
|
| Celeste Locklin Replies: 11 Views: 9948 |
Forum: Job Control Language(JCL) Posted: Tue Feb 08, 2011 6:12 pm Subject: DMBATCH output |
| AH I figured it OUT ! thanks to kolusu,
i have a layout for the CT record, and what is in col 40 is "procno" on the CT record above, it contains '00001AE4' which, when converted to ... |
|
| Topic: DMBATCH output |
|
| Celeste Locklin Replies: 11 Views: 9948 |
Forum: Job Control Language(JCL) Posted: Tue Feb 08, 2011 5:25 pm Subject: DMBATCH output |
| thank you kolusu, that explains that part. | |
| Topic: DMBATCH output |
|
| Celeste Locklin Replies: 11 Views: 9948 |
Forum: Job Control Language(JCL) Posted: Tue Feb 08, 2011 4:42 pm Subject: DMBATCH output |
| The record are from the sorted file. They are not consecutive, but they are in order (i.e. there are a lot of records between these records that are not shown).
Does (9,8 ) REALLY MEAN start at p ... |
|
| Topic: DMBATCH output |
|
| Celeste Locklin Replies: 11 Views: 9948 |
Forum: Job Control Language(JCL) Posted: Tue Feb 08, 2011 2:15 pm Subject: DMBATCH output |
| kolusu,
the date & time are updated every day on the select statement. this is today's select statement: SEL STAT WHERE(STARTT=(2011035,16:05:00)) FILE (there are also signon and sign ... |
|
| Topic: DMBATCH output |
|
| Celeste Locklin Replies: 11 Views: 9948 |
Forum: Job Control Language(JCL) Posted: Tue Feb 08, 2011 12:57 pm Subject: DMBATCH output |
| i am not exactly sure which position(s) to look at since the file is VBA.
but here is the first 60 bytes of 4 records from the sorted file: thank you in advance for your interest and your help. c ... |
|
| Topic: DMBATCH output |
|
| Celeste Locklin Replies: 11 Views: 9948 |
Forum: Job Control Language(JCL) Posted: Mon Feb 07, 2011 9:52 pm Subject: DMBATCH output |
| greetings.
I have a job that executes DMBATCH to select statistics - and the only 'where' is starttime, so the output file contains all statistics, i think. the next step sorts the statistic file u ... |
|
All times are GMT - 5 Hours |