Author |
Message |
Topic: Using the Same Tape Dataset in Joinkeys Jobs |
Fab
Replies: 1
Views: 1991
|
Forum: Utilities Posted: Thu Mar 08, 2018 11:29 am Subject: Using the Same Tape Dataset in Joinkeys Jobs |
Hello,
A friend just called me, he need to run this job:
//SORTC EXEC PGM=SORT,PARM='CORE=MAX'
//SORTIN1 DD DSN=THC.BT.IT.FN1.NEW.CAIS.VALID.SORTB.BPIT505,DISP ... |
Topic: Append variable number of lines to the correct previous one |
Fab
Replies: 36
Views: 10360
|
Forum: Utilities Posted: Thu May 18, 2017 8:02 am Subject: Append variable number of lines to the correct previous one |
Still debugging, stop step0100 just before OUTFIL I see this
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0----+----1----+----2----+----3----+- ... |
Topic: Append variable number of lines to the correct previous one |
Fab
Replies: 36
Views: 10360
|
Forum: Utilities Posted: Thu May 18, 2017 7:36 am Subject: Append variable number of lines to the correct previous one |
One more thing about this header, I have seen this morning that if query is beyond 1 page, these sorts behave wrong, example:
1PAGE 1 ... |
Topic: Append variable number of lines to the correct previous one |
Fab
Replies: 36
Views: 10360
|
Forum: Utilities Posted: Thu May 18, 2017 4:03 am Subject: Append variable number of lines to the correct previous one |
Hi Kolusu,
yes header was removed because it starts with the query executed, basically it was my fault, I deleted everything before beginning of data, 1st 1PAGE included. Now with header back again y ... |
Topic: Append variable number of lines to the correct previous one |
Fab
Replies: 36
Views: 10360
|
Forum: Utilities Posted: Wed May 17, 2017 8:58 am Subject: Append variable number of lines to the correct previous one |
Hello,
I tried today a different input, with 3 blocks (each line will be 131x3), it works perfect except for the 1st block.
my input now begins like this
----+----1----+----2----+----3----+---- ... |
Topic: Append variable number of lines to the correct previous one |
Fab
Replies: 36
Views: 10360
|
Forum: Utilities Posted: Tue May 16, 2017 1:36 am Subject: Append variable number of lines to the correct previous one |
It worked a treat Kolusu, as usual. Thanks much. Today I will test it on another input (adjusting what it need to be adjusted of course). Thanks again. |
Topic: Append variable number of lines to the correct previous one |
Fab
Replies: 36
Views: 10360
|
Forum: Utilities Posted: Wed May 10, 2017 8:22 am Subject: Append variable number of lines to the correct previous one |
...continued from previous post
This is when begins big block 2:
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8---+----8----+----9----+----0----+----1----+----2 ... |
Topic: Append variable number of lines to the correct previous one |
Fab
Replies: 36
Views: 10360
|
Forum: Utilities Posted: Wed May 10, 2017 7:23 am Subject: Append variable number of lines to the correct previous one |
Thanks Kolusu,
I cannot see your data and I am not sure as to where the pages are reset and the first column data starts over.
As far as I can see I cannot attach files here, so I will try to sh ... |
Topic: Append variable number of lines to the correct previous one |
Fab
Replies: 36
Views: 10360
|
Forum: Utilities Posted: Tue May 09, 2017 2:45 am Subject: Append variable number of lines to the correct previous one |
Thanks Kolusu, I'm doing my best,
I am assuming you are trying to understand 1PAGE xx increment sequence, so my answers are following this assumption. I hope I am not completely misundertanding you.
... |
Topic: Append variable number of lines to the correct previous one |
Fab
Replies: 36
Views: 10360
|
Forum: Utilities Posted: Mon May 08, 2017 4:28 am Subject: Append variable number of lines to the correct previous one |
Thanks Kolusu,
You haven't answered my earlier question 1. Can you find .1 in position 11 in your DSNTEP2 unload file?
No, in my input there are not '1.' char in position 11. This is my input sin ... |
Topic: Append variable number of lines to the correct previous one |
Fab
Replies: 36
Views: 10360
|
Forum: Utilities Posted: Fri May 05, 2017 8:20 am Subject: Append variable number of lines to the correct previous one |
@misi01
PM sent |
Topic: Append variable number of lines to the correct previous one |
Fab
Replies: 36
Views: 10360
|
Forum: Utilities Posted: Fri May 05, 2017 8:11 am Subject: Append variable number of lines to the correct previous one |
thanks Kolusu,
when I run your code as you gave me
//STEP0100 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DISP=SHR,DSN=MYUSERID.JOBXSORT
//* ... |
Topic: Append variable number of lines to the correct previous one |
Fab
Replies: 36
Views: 10360
|
Forum: Utilities Posted: Thu May 04, 2017 2:57 am Subject: Append variable number of lines to the correct previous one |
Thanks Kolusu,
I run Step0200 as you suggested and values from last record are as follow:
-+----4----+----5----+----6--
00001411 00000054 00184841
starting column is 134.
After that I ... |
Topic: Append variable number of lines to the correct previous one |
Fab
Replies: 36
Views: 10360
|
Forum: Utilities Posted: Wed May 03, 2017 10:41 am Subject: Append variable number of lines to the correct previous one |
Thanks heaps Kolusu & misi01,
@misi01
I have verified that I can run REXX scripts in my test env. I used the following JCL to test it:
//S0010 EXEC PGM=IKJEFT01 ... |
Topic: Append variable number of lines to the correct previous one |
Fab
Replies: 36
Views: 10360
|
Forum: Utilities Posted: Tue May 02, 2017 10:04 am Subject: Append variable number of lines to the correct previous one |
Thanks much for your kind offer misi01,
unfortunately it is not that clear to me if your output will be like this:
+-------------------------------------------------------------------------------- ... |
|