IBM SPUFI

SPUFI (SQL Processor Using File Input) is a database facility invented by IBM for interfacing with their Db2 system. It is accessed from within TSO ISPF from the DB2I Primary Option menu.

SPUFI allows direct input of SQL commands in the TSO environment, rather than having them embedded within a program.

SPUFI defaults

Once set up the SPUFI defaults are unlikely to be changed. Their values are very similar across installations, a typical example is shown below.

                           CURRENT SPUFI DEFAULTS             SSID: DDBA
 ===> ____________________________________________________________________________

 Enter the following to control your SPUFI session:
  1  SQL TERMINATOR .. ===> ;          (SQL Statement Terminator)
  2  ISOLATION LEVEL   ===> CS         (RR=Repeatable Read, CS=Cursor Stability)
  3  MAX SELECT LINES  ===> 250        (Maximum number of lines to be
                                        returned from a SELECT)
 Output data set characteristics:
  4  RECORD LENGTH ... ===> 4092       (LRECL=Logical record length)
  5  BLOCK SIZE ...... ===> 4096       (Size of one block)
  6  RECORD FORMAT ... ===> VB         (RECFM=F, FB, FBA, V, VB, or VBA)
  7  DEVICE TYPE ..... ===> SYSDA      (Must be DASD unit name)

 Output format characteristics:
  8  MAX NUMERIC FIELD ===> 33         (Maximum width for numeric fields)
  9  MAX CHAR FIELD .. ===> 80         (Maximum width for character fields)
 10  COLUMN HEADING .. ===> NAMES      (NAMES, LABELS, ANY or BOTH)

Mode of use

Although it is essentially an interactive tool, SPUFI operates using a pair of datasets. (A dataset on z/OS is equivalent to a file on other operating systems.) In the main SPUFI screen one specifies an input dataset and an output dataset; these can be specified once and then reused repeatedly. When the user moves on from the main screen, the standard ISPF editor is opened on the input dataset. At this point the user can enter the required SQL statements using the familiar editor. On exiting from the editor the main SPUFI screen reappears; when the user moves on this time the contents of the input dataset are executed. The results are placed in the output dataset and the ISPF editor is opened (in read-only "browse" mode) on that output. This is how the user reads their results. Interactive use of SPUFI continues around these steps; in summary the cycle is:

... Main → edit → Main → view output → Main → edit → Main → view output → Main ...

Because SPUFI uses normal datasets for the commands and the output, it is possible to pre-populate the commands or operate on the output by accessing the datasets independently of the SPUFI tool. Using datasets also means that a possibly-complicated set of SQL commands will persist from session to session rather than being lost when the user exits the tool.

Example query

SQL command

A simple query with comments.

 -- Select specific fields from the EMPLOYEE table
 -- for staff in Department 01.

   SELECT FIRST_NAME, LAST_NAME, DATE_JOINED
     FROM EMPLOYEE
    WHERE DEPARTMENT = '01'
    ORDER BY LAST_NAME DESC, FIRST_NAME

Results set

Typical result from this type of query.

 -----------+-----------+-----------+-----------+
 FIRST_NAME LAST_NAME   DATE_JOINED
 -----------+-----------+-----------+-----------+
 Joe        Briggs       2001-10-01
 Bob        Brown        2002-05-06
 Fred       Brown        2000-01-03
 -----------+-----------+-----------+-----------+
 NUMBER OF ROWS AFFECTED IS 3
 STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
 -----------+-----------+-----------+-----------+

The Output dataset contains the resultant rows(in case of SELECT) along with additional details like number of rows affected by the SQL query, SQLCODE returned on execution of the SQL query. In case of any SQL errors the details about the error will be given.

References

DB2 Developer's Guide, Craig S Mullins, Sams Publishing, ISBN 0-672-31168-2

Read other articles:

Hawaii (pulau)

HawaiʻiPulau BesarLandsat mosaic, 1999–2001.Lokasi di negara Hawaii.GeografiLokasi19°34′N 155°30′W / 19.567°N 155.500°W / 19.567; -155.500Wilayah4,028.0 sq. mi. (10,432.5 km²)Peringkatke-1, Pulau Hawaii terbesarTitik tertinggiMauna KeaPeninggian maksimum13,796 ft. (4,205 m)DemografiJumlah penduduk148,677 (pada 2000)Kepadatan37/sq mi (14/km²)Official InsigniaBungaʻŌhiʻa lehuaWarnaʻUlaʻula (red) Pulau Hawaii,[1] juga...

羅生門 (電影)

本條目存在以下問題，請協助改善本條目或在討論頁針對議題發表看法。此條目需要补充更多来源。 (2018年3月17日)请协助補充多方面可靠来源以改善这篇条目，无法查证的内容可能會因為异议提出而被移除。致使用者：请搜索一下条目的标题（来源搜索：羅生門 (電影) — 网页、新闻、书籍、学术、图像），以检查网络上是否存在该主题的更多可靠来源（判定指引）。 �...

Logaritma biner

Logaritma binerInformasi umumBidang penerapanTeori musikDomain dan CitraDomain dari fungsi ( 0 , ∞ ) {\displaystyle (0,\infty )} Daerah hasil fungsi ( − ∞ , ∞ ) {\displaystyle (-\infty ,\infty )} Nilai-nilai spesifikNilai di 0 1 {\displaystyle 1} Nilai maksimumTidak adaNilai minimumTidak adaInvers x = 2 y {\displaystyle x=2^{y}} Turunan 1 x ln ⁡ 2 {\displaystyle {\frac {1}{x\ln 2}}} Logaritma biner (Inggris: binary logarithmcode: en is deprecated ) dalam mat...

Cycling at the 1952 Summer Olympics

Cyclingat the Games of the XV OlympiadVenuesKäpylä and the surrounding areaHelsinki VelodromeDate28 –31 July 1952 (track)2 August 1952 (road)Competitors215 from 36 nations← 19481956 → Three Belgian cyclists during the road race. The cycling competition at the 1952 Summer Olympics consisted of two road cycling events and four track cycling events, all for men only. 215 cyclists from 36 countries competed in the six events.[1] Medal summary Road...

Ploujean

Ploujean Le château de Suscinio, maison natale de Charles Cornic, façade nord. Administration Pays France Région Bretagne Département Finistère Commune Morlaix Statut Ancienne commune Code postal 29600 Code commune 29200 Démographie Population 3 142 hab. (1954) Géographie Coordonnées 48° 36′ 19″ nord, 3° 50′ 02″ ouest Historique Fusion 21 février 1959 Commune(s) d'intégration Morlaix Localisation Géolocalisation sur la carte :...

The Becoming (EP)

2007 EP by After Midnight ProjectThe BecomingEP by After Midnight ProjectReleased2007GenreAlternative rock, post-grungeLabelSelf-releasedProducerJason Evigan and Evan A. RichardsonAfter Midnight Project chronology After Midnight Project(2005) The Becoming(2007) Let's Build Something to Break(2009) The Becoming is an EP released by American rock band, After Midnight Project. It was released in 2007. This album caught the attention of Universal Motown and eventually led to the band bein...

Beniapukur

Neighbourhood in Kolkata in West Bengal, IndiaBeniapukurNeighbourhood in Kolkata (Calcutta)Nonapukur Tram Depot, BeniapukurBeniapukurLocation in KolkataCoordinates: 22°32′47″N 88°22′10″E / 22.546333°N 88.369525°E / 22.546333; 88.369525Country IndiaStateWest BengalCityKolkataDistrictKolkataMetro StationClose to Rabindra Sadan, Close to Maidan, Close to Park Street, Close to Sealdah(under construction) and Close to Barun Sengupta(under construction)Muni...

Gastone Boni

Questa voce sull'argomento calciatori italiani è solo un abbozzo. Contribuisci a migliorarla secondo le convenzioni di Wikipedia. Segui i suggerimenti del progetto di riferimento. Gastone Boni Nazionalità Italia Altezza 174 cm Peso 73 kg Calcio Ruolo Allenatore (ex attaccante) Termine carriera 1946 - giocatore1954 - allenatore CarrieraSquadre di club1 1932-1934 Padova4 (0)1934-1937 Catanzarese20+ (7+)193?-1940 Carpi? (?)1940-1942 Sangiovannese? (?)194?-1946&#...

Quartier de la Place-Vendôme

Place-VendômeQuartier administratifQuartier de la Place-VendômePlace VendômeKoordinat: 48°52′03″N 2°19′46″E / 48.86750°N 2.32944°E / 48.86750; 2.32944Koordinat: 48°52′03″N 2°19′46″E / 48.86750°N 2.32944°E / 48.86750; 2.32944Negara PrancisRegionÎle-de-FranceKomuneParisArondisemenke-1Luas • Total0,269 km2 (0,104 sq mi)Populasi (2016)[1] • Total2,743 • ...

Hindu pilgrimage sites

Part of a series onHinduism Hindus History OriginsHistorical Hindu synthesis (500/200 BCE-300 CE) History Indus Valley Civilisation Historical Vedic religion Dravidian folk religion Śramaṇa Tribal religions in India Traditional Itihasa-Purana Epic-Puranic royal genealogies Epic-Puranic chronology Traditions Major traditions Shaivism Shaktism Smartism Vaishnavism List Deities Trimurti Brahma Vishnu Shiva Tridevi Saraswati Lakshmi Parvati Other major Devas / Devis Vedic: Agni Ashvi...

西遊記大結局之仙履奇緣

本條目存在以下問題，請協助改善本條目或在討論頁針對議題發表看法。此條目需要編修，以確保文法、用詞、语气、格式、標點等使用恰当。 (2013年8月6日)請按照校對指引，幫助编辑這個條目。（幫助、討論）此條目剧情、虛構用語或人物介紹过长过细，需清理无关故事主轴的细节、用語和角色介紹。 (2020年10月6日)劇情、用語和人物介紹都只是用於了解故事主軸，輔助�...

Елабужский государственный музей-заповедник

Елабужский государственный музей-заповедник Дата основания 1989 Дата открытия 09:00 — 18:00, пн — выходной Местонахождение Елабуга Адрес Елабуга, улица Гассара, 9 Посетителей в год от 100 тыс. в год Директор Гульзада Ракиповна Руденко Сайт elabuga.com Медиафайлы на Викискладе Объ�...

Criminal law in the Marshall Court

Chief Justice John Marshall History of U.S. federal criminal law By Court Marshall (1801–1835) Taney (1836–1864) Chase (1864–1873) Waite (1874–1888) vte The Marshall Court (1801–1835) heard forty-one criminal law cases, slightly more than one per year. Among such cases are United States v. Simms (1803), United States v. More (1805), Ex parte Bollman (1807), United States v. Hudson (1812), Cohens v. Virginia (1821), United States v. Perez (1824), Worcester v. Geo...

Sadratnamala

Book by Sankara Varman Sadratnamala Opening verses of Sadratnamala (in Devanagari)AuthorSankara Varman (1774–1839)CountryIndiaLanguageSanskritSubjectAstronomy/MathematicsPublication date1819 CE Sadratnamala is an astronomical-mathematical treatise in Sanskrit written by Sankara Varman, an astronomer-mathematician of the Kerala school of mathematics, in 1819.[1] Even though the book has been written at a time when western mathematics and astronomy had been introduced in India, it is ...

All Dulles Area Muslim Society

All Dulles Area Muslim SocietyReligionAffiliationIslamEcclesiastical or organizational statusnon-profit religious organizationLocationLocation46903 Sugarland Rd, Sterling, VA 20164Location in VirginiaShow map of VirginiaAll Dulles Area Muslim Society (the United States)Show map of the United StatesGeographic coordinates39°00′23″N 77°22′46″W / 39.00639°N 77.37936°W / 39.00639; -77.37936ArchitectureTypeMosqueDate established1983SpecificationsCapacity700+[...

Dooley Wilson

American actor, musician (1886–1953) Dooley WilsonWilson in 1945BornArthur Wilson(1886-04-03)April 3, 1886Tyler, Texas, U.S.DiedMay 30, 1953(1953-05-30) (aged 67)Los Angeles, California, U.S.Resting placeAngelus-Rosedale CemeteryOccupations Actor singer musician Years active1893–1952Spouse(s)Estelle Williams(m. 19??; his death 1953) Arthur Dooley Wilson (April 3, 1886 – May 30, 1953) was an American actor, singer and musician who is best remembered for his portrayal of Sam in ...

Boletina

Boletina Klasifikasi ilmiah Kerajaan: Animalia Filum: Arthropoda Kelas: Insecta Ordo: Diptera Famili: Mycetophilidae Genus: Boletina Boletina adalah genus lalat yang tergolong famili Mycetophilidae. Lalat ini juga merupakan bagian dari ordo Diptera, kelas Insecta, filum Arthropoda, dan kingdom Animalia. Lalat dalam genus ini biasanya dapat ditemui di tempat lembap. Referensi Bisby F.A., Roskov Y.R., Orrell T.M., Nicolson D., Paglinawan L.E., Bailly N., Kirk P.M., Bourgoin T., Baillargeon G.,...

Segundo Concílio de Niceia

Segundo Concílio de Niceia II Segundo Concílio de NiceiaÍcone do Segundo Concílio Ecumênico de Niceia (Convento de Novodevichy, Moscou Data Ano 787 da Era Cristã Aceite por Católicos Romanos, Ortodoxos Velha Igreja Católica Anglicanos e alguns protestantes Concílio anterior Terceiro Concílio de Constantinopla Concílio seguinte Católicos: Quarto Concílio de Constantinopla (Católico Romano)Ortodoxos: Quarto Concílio de Constantinopla (Ortodoxo) Convocado por Tarásio, patriarca ...

2014 Namibian general election

2014 Namibian general election ← 2009 28 November 2014 (2014-11-28) 2019 → Presidential election Nominee Hage Geingob McHenry Venaani Party SWAPO DTA Popular vote 772,528 44,271 Percentage 86.73% 4.97% Results by region President before election Hifikepunye Pohamba SWAPO Elected President Hage Geingob SWAPO Politics of Namibia Constitution Constituent Assembly Executive President Nangolo Mbumba Vice-President Netumbo Nandi-Ndaitwah Prime ...

修士

この項目では、学位について説明しています。聖公会における用法については「修道士」をご覧ください。修士（しゅうし、英語: Master's degree）とは大学院における修士課程もしくは博士課程の前期課程を修了することで得られる学位である。英語圏ではmaster、ドイツ語圏ではマギスターまたはマギステル (Magister)、中華人民共和国や台湾（中華民国）、大韓民国等...

PROFILPELAJAR.COM