|
View previous topic :: View next topic
|
| Author |
Message |
Jon_Walker
New User
Joined: 02 Jun 2008
Posts: 6
Location: Ottawa, Canada
|
|
|
|
I have a merged file of multiple data extract SQL statements (using SELECT and JOIN) that must be run from a JCL.
RUNSQLSTM won't work - 1) its a CL command and 2) No support for SELECT statement.
Can anyone provide an answer OR solution to my problem. |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello Jon and welcome to the forums,
| Quote: |
| must be run from a JCL |
Have you tried using SPUFI in batch? This should do what you need. |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| Or DSNREXX from REXX ? |
|
| Back to top |
|
|
Jon_Walker
New User
Joined: 02 Jun 2008
Posts: 6
Location: Ottawa, Canada
|
|
|
|
| dick scherrer wrote: |
Hello Jon and welcome to the forums,
| Quote: |
| must be run from a JCL |
Have you tried using SPUFI in batch? This should do what you need. |
Thanks Dick; Didn't think there was a BATCH version of SPUFI!?! It was one of the first solutions I came up with, but mgmt (a.k.a. Project Lead) said 'It wasn't an option'. (?Why not?!?)
I'll investigate further. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello Jon,
| Quote: |
| I'll investigate further |
There are some topics on this in the forum. A good time to meet the "SEARCH" feature (near the top of the page) 
Looking for "batch spufi" without the quotes and selecting "Search for all terms" will get several "hits". |
|
| Back to top |
|
|
|
|
