MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 19 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Status line W
Celeste Locklin

Replies: 4
Views: 3552

PostForum: 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: 3552

PostForum: 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: 5194

PostForum: 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: 2596

PostForum: 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: 2596

PostForum: 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: 2603

PostForum: Database   Posted: Fri Jul 01, 2011 1:19 pm   Subject: Display decimal
amazing. Wink
  Topic: Display decimal
Celeste Locklin

Replies: 4
Views: 2603

PostForum: 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 ? Wink
  Topic: Display decimal
Celeste Locklin

Replies: 4
Views: 2603

PostForum: 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: 9702

PostForum: 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: 9702

PostForum: 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: 9702

PostForum: 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: 9702

PostForum: 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: 9702

PostForum: 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: 9702

PostForum: 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: 9702

PostForum: 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 ...
 
Page 1 of 2 Goto page 1, 2  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group