Do you have an example for the proper syntax/usage of using TRIM or CHAR?
-Original Message-
From: Seay, Paul [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 10:52 PM
To: [EMAIL PROTECTED]
Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
Also, if the length
current_timestamp - 8 hours group by nodename
-Original Message-
From: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 6:39 AM
To: [EMAIL PROTECTED]
Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
Do you have an example for the proper syntax/usage
Thanks
Matt
-Original Message-
From: Seay, Paul [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 8:27 AM
To: [EMAIL PROTECTED]
Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
select NodeName, sum(cast(cast(trim(substr(message,47,6)) as
decimal(10,3))*case when
To: [EMAIL PROTECTED]
Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
Ike,
I got it to work with some help from Dennis Glover. He sent me an
example of something that worked. The big difference was that the -COMMA
option MUST BE LISTED BEFORE THE MACRO option. So
DSMADMC -ID
To: [EMAIL PROTECTED]
Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
To control the length of character fields you can use:
CHAR(expression,n)
LEFT(exppression,n)
RIGHT(expression,n)
where n is the length of the string you want returned
-Original Message-
From: MC Matt
=x MACRO DD:D2 -COMMA does not!
Matt
-Original Message-
From: Ike Hunley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 5:44 AM
To: [EMAIL PROTECTED]
Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
Matt,
I have not found a way to get my data on one line
-253-8000 ofc
425-988-8478 fax
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
MC Matt Cooper (2838)
Sent: Monday, April 01, 2002 10:08 AM
To: [EMAIL PROTECTED]
Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
Ike,
I
Hi Dennis,
Your idea is SUPERB !!
Thanks ...
Sumitro.
From: Dennis Glover <[EMAIL PROTECTED]>
Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Need Help Controlling Script Output, Field Lengths
Date: Thu, 28 Mar 2002 19:16:21
]]On Behalf Of
MC Matt Cooper (2838)
Sent: Wednesday, March 27, 2002 2:25 PM
To: [EMAIL PROTECTED]
Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
I have tried everyone's suggestions. I believe the fact that I have one AS
statement in the script that it will ignore the attempts of fixing
-Original Message-
From: Ike Hunley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 5:44 AM
To: [EMAIL PROTECTED]
Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
Matt,
I have not found a way to get my data on one line either. I input the data
into REXX code
Unless you want to try your hand at REXX programming, or getting heavily
into
multi-record ''sed'', I'd suggest that you invoke the administrative
command line client like this:
dsmadmc -comma
You will have to type the admin name and password as usual.
All of the output from any command(s)
Matt,
What do you do to execute the select command in the z/OS environment?
-Original Message-
From: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 8:15 AM
To: [EMAIL PROTECTED]
Subject: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
Hello all
Hello all,
I am trying to write a simple script that shows the nodes that were
not accessed by TSM for more than x days and then do an E-mail notification
from there. I AM RUNNING TSM 4.1.5 on z/OS 1.1. The select command to get
the node name, last access date, and contact name (the
PROTECTED]]
Sent: Wednesday, March 27, 2002 8:21 AM
To: [EMAIL PROTECTED]
Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
Matt,
What do you do to execute the select command in the z/OS environment?
-Original Message-
From: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]]
Sent
) To: [EMAIL PROTECTED]
Matt.Cooper@AMGREcc:
ETINGS.COM Subject: Re: NEED HELP CONTROLLING
SCRIPT OUTPUT, FIELD LENGTHS
Sent by: ADSM:
Dist Stor Manager
is lenghtened to prevent the wrap by
adding the spaces.
-Original Message-
From: Rejean Larivee/Quebec/IBM [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 10:46 AM
To: [EMAIL PROTECTED]
Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
Hello Matt,
remove the -TAB and use
To: [EMAIL PROTECTED]
Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
Ike,
I am running the following batch job. I added the -TAB and tried
-OUTFILE with a redirect in the macro to the data set and that didn't work
either. So I tried a few different variation of the above
Try the
-commadelimited
parameter. This gives a single line of output per row in the table. It's in
standard comma-delimited format, which is understood by most PC
spreadsheets, although not easily by humans. I'm not sure about SAS.
Regards
Richard Foster
, March 27, 2002 11:13 AM
To: [EMAIL PROTECTED]
Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
That will help, but you can also do the AS [ lots of spaces ] to lengthen
the output field. What we really need is a set displaymode=fixedraw.
This is an example of something that I do
19 matches
Mail list logo