How to run more queries in one time

[rjd2003]

Hello from Holland!

I use WRKJOBSCDE for scheduling several queries. Is it possible to run more queries in one RUNQRY command?

My command screen looks as follows (in Dutch, but I guess the screen is the same...)

Naam taak . . . . . . . . . . . > RJDING1 Naam
Nummer . . . . . . . . . . . . . > 000103 000001-999999, *ONLY
Uit te voeren opdracht . . . . . RUNQRY QRY(RJQUERY/RJDING)

Frequentie . . . . . . . . . . . *WEEKLY *SAME, *ONCE, *WEEKLY...
Datum waarvoor gepland, of . . . *NONE Datum, *SAME, *CURRENT...
Dag waarvoor gepland . . . . . . *ALL *SAME, *NONE, *ALL, *MON..
+ voor meer waarden
Tijdstip waarvoor gepland . . . '19:00:00' Tijd, *SAME, *CURRENT

Thanks in advance!

RJ

 

[flapeyre]

Create a CL program to run them.

WRKMBRPDM FILE(QGPL/QCLSRC)

Press F6 to create a new source member.

PGM
RUNQRY QRY(RJQUERY/RJDING) 
RUNQRY QRY(RJQUERY/xxxxxx) 
.....
ENDPGM

Add as many queries as you need.

Save the source by pressing F3.

Compile the program with Option 14.

Change your job schedule entry (CHGJOBSCDE) to call the program you just created, instead of using RUNQRY htere:

CALL QGPL/RUN_QUERY, for example.



"When once you have tasted flight, you will forever walk the Earth with your eyes turned skyward, for here you have been, and there you will always long to return."

--Leonardo da Vinci

 

[rjd2003]

Dear flapeyre,

Thanks for your clear answer. But how can I enter the command. My system gives the following:

"Command WRKMBRPDM not found in library *LIBL"

I am logged in as security officer.

Best regards,

RJ

 

[gpzcrasher]

The command normally lives in library QSYS and you will need this in your library list or alternatively enter the command as

QSYS/WRKMBRPDM FILE(QGPL/QCLSRC)

If this still does not work enter the following to find which library the command is in

DSPOBJD OBJ(*ALL/WRKMBRPDM) OBJTYPE(*CMD)

and then substitute QSYS for the correct library


--------------------------------
Codito, ergo sum

 

[flapeyre]

GO LICPGM

Option 10 (Display installed licensed programs)

Make sure the following are installed:

Licensed  Installed                                   
Program   Status       Description                    
5722WDS   *COMPATIBLE  WebSphere Development ToolSet  
5722WDS   *COMPATIBLE  Tools - Application Development

"When once you have tasted flight, you will forever walk the Earth with your eyes turned skyward, for here you have been, and there you will always long to return."

--Leonardo da Vinci

 

[rjd2003]

I guess we really need a new AS400 with up-to-date software... 5722 range is not present.

Before the end of the year we will have a new one, I assume these programs are with that.

RJ

 

[iSeriesCodePoet]

You might not have PDM on your system. There was an extra cost before. In V4R5 and beyond they changed the name to WebSphere Development xxxx. You should see either the webshere entry or Program Development Manager somewhere in your list. If not, you will have to use another method. Do you guys do development on this box at all?

iSeriesCodePoet
iSeries Programmer/Lawson Software Administrator

http://www.koldark.net

See my progress to converting to linux.

http://linux.koldark.net