MVSFORUMS.com

kingo · Posted: Fri Feb 09, 2007 6:11 am Post subject: SYSREC00

Hi,

Can anyone help me with the difference between sysrec and sysrec00.

Regds,
Kingo
_________________
IF YOU ARE NOT FOCUSSED ON GOAL ALL YOU SEE IS OBSTACLE.

kolusu · Posted: Fri Feb 09, 2007 8:58 am Post subject:

Kingo,

There is no difference at all , they are both the same. SYSREC is used by LOAD, REORG, UNLOAD utilities

SYSRECnn. The value nn ranges from 00 to 99. You can have a maximum of 100 LOAD/UNLOAD output data sets for a single execution of the utility. So the first sql takes/unloads the data to SYSREC00 and then the next sql is associated to SYSREC01 and so on.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

kingo · Posted: Mon Feb 12, 2007 11:38 pm Post subject:

Thanks Kolusu

Regds,
Kingo
_________________
IF YOU ARE NOT FOCUSSED ON GOAL ALL YOU SEE IS OBSTACLE.

kingo · Posted: Tue Feb 13, 2007 3:27 am Post subject:

But kolusu u have said So the first sql takes/unloads the data to SYSREC00 can u explain me this.

Regds,
Kingo
_________________
IF YOU ARE NOT FOCUSSED ON GOAL ALL YOU SEE IS OBSTACLE.

blitz2 · Beginner Joined: 23 Jan 2007 Posts: 84 Topics: 14

takes <-> LOAD
unloads <-> UNLOAD
________
CB750K

kingo · Posted: Tue Feb 13, 2007 4:06 am Post subject:

No i got that But my concern is about tht "FST SQL"
what does that mean?As it is its gonna be one single statement which is going to do all
these things.Can anyone explain me about that?

Regds,
Kingo
_________________
IF YOU ARE NOT FOCUSSED ON GOAL ALL YOU SEE IS OBSTACLE.

kolusu · Posted: Tue Feb 13, 2007 6:30 am Post subject:

kingo · Posted: Tue Feb 13, 2007 7:07 am Post subject:

Thanks a lottttttttt Kolusu Very Happy

It really helped me and I was breaking my head with this simple question.

Regds,
Kingo
_________________
IF YOU ARE NOT FOCUSSED ON GOAL ALL YOU SEE IS OBSTACLE.