IBM Mainframe Forum

Dear friends
I want to insert a column from an excell sheet to a source.(A JCL)
But I must put them at special lines for example every 4 line I must paste a cell value in position 10 to 20 of my dataset.(my JCL).
How I can remove temporary lines so only lines that I want to paste into, retained. And after pasting my values how I can restore temorary removed lines.
I use "X" command to exclude but there is a dashed line apear for excluded lines.How I can remove this daeshed line.(NOT deleting this lines only temporary remove thoes)
And how I can resotore excluded lines so I can see thems?

How about reading a manual? Or pressing PF1 while in Edit and reading about all primary commands?

If you follow Prino's suggestions, you'll find out how to exclude the dashed-line.

If you continue, as I think he's hinting, you'll come to a lot about the Change command which should help you. There is no need to "paste" onto every line, you would be able to do it with one Change command, without having to make the excluded lines invisible anyway.

Look at the Help, look at the manual. Experiment. If you get stuck, come back.

BillyBoyo wrote:If you follow Prino's suggestions, you'll find out how to exclude the dashed-line.

If you continue, as I think he's hinting, you'll come to a lot about the Change command which should help you. There is no need to "paste" onto every line, you would be able to do it with one Change command, without having to make the excluded lines invisible anyway.

A change command may not work if the contents of the ExCrap cells are different, in which case a paste with the non visible excluded lines may be the only viable solution.

I may be missing something, but it is JCL, so why not:



This successfully obliterated:



In one shot.

HIDE and RES - as per F1, manual, forum etc. However, if once you have hidden all your lines you want to paste you excel data over the remaining lines that does not work - you will have to paste after one line and then move all your lines one by one. Unless someone comes up with a better solution.

NicC wrote:HIDE and RES - as per F1, manual, forum etc. However, if once you have hidden all your lines you want to paste you excel data over the remaining lines that does not work - you will have to paste afetr one line and then move all your lines one by one. Unless someone comes up with a better solution.

Oh, yes, it does work. Used it many times on "that" system when I was doing volume defrags etc.

My quick test on that system this morning was unsuccessful - may have to try again as I can see that it could be useful.