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 29 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Pivot Table using DFSort
cyberuser

Replies: 1
Views: 1921

PostForum: Utilities   Posted: Sun Sep 30, 2018 9:15 am   Subject: Pivot Table using DFSort
Would be possible to create a pivot table using dfsort ?



input file FB/80:
10:01 w1 5
10:01 w2 15
10:01 w4 30
10:02 w2 18
10:02 w3 5
10:02 w5 10 ...
  Topic: Remove all entries except first
cyberuser

Replies: 4
Views: 3228

PostForum: Utilities   Posted: Thu Oct 06, 2016 4:09 pm   Subject: Remove all entries except first
Actually, i'm including more data to the file using the include cond. Copy/rename wouldn't help
  Topic: Remove all entries except first
cyberuser

Replies: 4
Views: 3228

PostForum: Utilities   Posted: Thu Oct 06, 2016 12:58 pm   Subject: Remove all entries except first
hello , i have FB 80 file with thousands of records.
Would like to know, using icetool how can i remove all entries based on certain condition leaving the first entry. Any help is welcome.


My & ...
  Topic: Removing end pipe from end of line
cyberuser

Replies: 4
Views: 4312

PostForum: TSO and ISPF   Posted: Sat Jul 04, 2015 1:19 pm   Subject: Removing end pipe from end of line
I'm trying to achieve the following in REXX but i think i'm getting too old for this.
Any help is appreciated.

Sample Data
'data|data|data|data|' ;
'data|data|data||' ;
'data|d ...
  Topic: Retrieve records with count higher than n
cyberuser

Replies: 2
Views: 2636

PostForum: Utilities   Posted: Tue May 08, 2012 3:41 pm   Subject: Retrieve records with count higher than n
thanks a lot kolusu it worked pretty well.
  Topic: Retrieve records with count higher than n
cyberuser

Replies: 2
Views: 2636

PostForum: Utilities   Posted: Tue May 08, 2012 2:55 pm   Subject: Retrieve records with count higher than n
Hello,
I've question on the following situaiton:

FB, LRECL 82 file with the following info:

----+----1----+----2----+----3----+-
ZZZZ ZZZZ 00593738 25/03/12
ZZZZ ZZZZ 00 ...
  Topic: rexx and assembler
cyberuser

Replies: 8
Views: 7892

PostForum: TSO and ISPF   Posted: Sat May 07, 2011 5:33 pm   Subject: rexx and assembler
ok i understand... and that's the way i've being using since i've wrote both programs...
but the question is... is there any way to pack (compile) both together ?
  Topic: rexx and assembler
cyberuser

Replies: 8
Views: 7892

PostForum: TSO and ISPF   Posted: Sat May 07, 2011 12:04 pm   Subject: rexx and assembler
i have a small assembler source code to clean the screen.
normally i call this program before to start my rexx procedures.
is there any way during the compilation of the rexx to include this program ...
  Topic: temp file
cyberuser

Replies: 4
Views: 2546

PostForum: TSO and ISPF   Posted: Sun Dec 27, 2009 5:44 pm   Subject: temp file
it worked perfectly. Thank you !!
  Topic: temp file
cyberuser

Replies: 4
Views: 2546

PostForum: TSO and ISPF   Posted: Sat Dec 26, 2009 11:01 am   Subject: temp file
hello, would be possible to have a TSO command to do same thing the JCL below is doing ?


//TEMP1 DD DSN=&&TEMP1,DISP=(,PASS),
SPACE=(CYL,(5,5)),UNIT=SYSDA


...
  Topic: Multi Row Insert via QMF
cyberuser

Replies: 3
Views: 3560

PostForum: Database   Posted: Mon Jul 06, 2009 10:14 pm   Subject: Multi Row Insert via QMF
it seems it's not recognizing the "2" .... from statement FOR 2 ROWS...
  Topic: Multi Row Insert via QMF
cyberuser

Replies: 3
Views: 3560

PostForum: Database   Posted: Mon Jul 06, 2009 9:39 pm   Subject: Multi Row Insert via QMF
i tried to use the following statement on qmf and it worked fine.
INSERT INTO table (name, address)
values ('john doe', 'street one')

but when using :
INSERT INTO table (name, address)
valu ...
  Topic: rexx stem and macro
cyberuser

Replies: 16
Views: 9326

PostForum: TSO and ISPF   Posted: Wed Sep 10, 2008 5:31 pm   Subject: rexx stem and macro
thanks jim haire !!
i got the workaround concept ! it worked perfectly !
  Topic: rexx stem and macro
cyberuser

Replies: 16
Views: 9326

PostForum: TSO and ISPF   Posted: Wed Sep 10, 2008 8:10 am   Subject: rexx stem and macro
/*rexx*/

dat1.1 = Zfirst <= my question is here.
.
.
.


do A=1 to dat1.0
...
end
  Topic: rexx stem and macro
cyberuser

Replies: 16
Views: 9326

PostForum: TSO and ISPF   Posted: Wed Sep 10, 2008 8:06 am   Subject: rexx stem and macro
opening a dataset, i would like to run or a rexx/macro code to pickup the all the lines.... then i would work these lines into the stem and produce another stem to populate back the same dataset....
...
 
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