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 47 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Using the Same Tape Dataset in Joinkeys Jobs
Fab

Replies: 1
Views: 1991

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

+-------------------------------------------------------------------------------- ...
 
Page 1 of 4 Goto page 1, 2, 3, 4  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group