Re: SQL testing - fetch first 100 rows only

[Michael Schutte <mschutte369@xxxxxxxxx>]

Copy the source file to another... make the changes and then run your job.
 That way you don't have to go back and change existing that I assume are
used in production?

On Tue, Jan 29, 2013 at 1:36 PM, Stone, Joel <Joel.Stone@xxxxxxxxxx> wrote:

> I have several SQL commands in a CL named CL_JOB1.
>
> I am using CL command
>
> RUNSQLSTM  SRCFILE(QQRYSRC) SRCMBR(&SQLCMD) COMMIT(*NONE)
>
> To run each one.
>
>
> I would like to run CL_JOB1 using a small sample of data from each input
> file.
>
> I can place the SQL string
>
> "fetch first 100  rows only"
>
> in each SQL text module.
>
> But later I have to back that out of each SQL text for production.
>
> Is it possible to "fetch the first 100 rows " for ALL SQL runs in a job
> WITHOUT changing each SQL command text?
>
> Thanks
>
>
>
> ______________________________________________________________________
> This outbound email has been scanned for all viruses by the MessageLabs
> Skyscan service.
> For more information please visit http://www.symanteccloud.com
> ______________________________________________________________________
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.