Author |
Message |
Topic: Pivot Table using DFSort |
cyberuser
Replies: 1
Views: 1921
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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....
... |
|