ispf
how to create a jcl in mainframe
db2 tutorial
qmf tutorial
tso tutorial
z os tutorialqmf tutorial pdf
mainframe tutorial

10 Feb 2015 However, this lesson provides an opportunity for you learn how to query data by using the commands and menus of the panel-based SPUFI facility in the z/OS 8 Apr 2013 www.grandsysteme.com,Spufi,Spufi batch,Spufi db2,Spufi documentation,Spufi ibm,Spufi jcl,Spufi tutorial,SPUFI,SQL Processor Using File12 Feb 2011 SPUFI. Hi, I am new to Mainframe..using QMF.Instead of using multiple select queries,my Explore, press help, read the manual, experiement. 30 Dec 2010 hi, i have a pds which consists of 20 members each memeber in that pds consists of 5-10 queries so i need a jcl(ikjeft01) to submit all the pds JCL FAQ · VSAM FAQ · DB2 FAQ. SPUFI (SQL processor using file input) Tutorial: 1. Take 9 option from ISPF primary option menu to go to IBM products panel. SQL Processing Using File Input is a database facility invented by IBM for interfacing with their . Categories: IBM DB2 · IBM software · Database administration tools · IBM mainframe software DB2: Run SQL queries thru JCL - Batch SPUFI. Using the below job, you can run any SQL queries. The utility program DSNTEP2 is called as "batch SPUFI". You can execute SQL statements dynamically in a TSO session by using the SPUFI (SQL processor using file input) facility. format suitable for further processing by LOAD utilities or programs. This JCL works fine with us on DB2 UDB V6 for OS/390. However it is