• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • V5R3 SQL Insert Improvement

    January 4, 2006 Ted Holt

    SQL’s INSERT command adds records to a table (physical file) or view (logical file). There are three forms of INSERT. The VALUES form allows you to create a record from constants. For example, assume a table PLANT with two columns (fields)–ID and NAME.

    create table qtemp/Plants
      (ID   char(4),         
       Name char(12))
    

    To create rows (records) for two factories, you could use two insert commands.

    insert into qtemp/plants values('1492', 'Lost Angeles')
    insert into qtemp/plants values('2001', 'New Yolk')
    

    In V5R3, IBM enhanced the VALUES form of INSERT to permit you to insert more than one row at a time. The following INSERT command inserts two rows.

    insert into qtemp/plants
       values ('1492', 'Lost Angeles'), ('2001', 'New Yolk')
    

    Each row’s values are enclosed in parentheses and separated from other rows with commas.

    This is not an IBM-only feature. Other SQL platforms support it as well.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    IBM

    Roundtable Webinar: 10 Surprising Insights On Used IT

    January 28, 2021

    10:00 AM ET

    Learn why 58% of organizations IDC surveyed are planning to increase their spending on used IT, the most important criteria in selecting a used IT equipment provider, how used IT can help accelerate sustainability initiatives, plus other key insights on the used IT marketplace.

    Register today to attend a 45-minute webinar roundtable with IDC’s Susan Middleton, Research Director Flexible Consumption and Financing Strategies for IT Infrastructure, IBM, Skytap, Celerity and ChannelWorks.  This panel discussion will review key findings from recent IDC research on the used IT marketplace with real customer experiences with of used IT.

    Webinar: 10 Surprising Insights On Used IT

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    COMMON:  Join us at the Spring 2006 conference, March 26-30, in Minneapolis, Minnesota
    Arkeia:  Linux backup solutions for SMBs and enterprises with heterogeneous environments
    BCD:  Try WebSmart - the easiest and most complete iSeries Web development tool

    China Tops the United States in IT Exports, Says OECD IBM, AMD Expect 45-Nanometer Chips in Mid-2008

    Leave a Reply Cancel reply

Volume 6, Number 1 -- January 4, 2006
THIS ISSUE SPONSORED BY:

WorksRight Software
Advanced Systems Concepts
COMMON

Table of Contents

  • Properly Placed Procedures
  • V5R3 SQL Insert Improvement
  • Admin Alert: Limiting *PUBLIC Access to i5/OS Objects, Part 1

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • IBM i Software And Power Systems Upgrades Keep Rolling Forward
  • Preparing For What’s Next In A Thoughtful, Structured Way
  • Guru: Fall Brings New RPG Features, Part 3
  • ARCAD Plugs IBM i DevOps Suite Into Microsoft Azure
  • Park Place Buys Curvature To Become Maintenance Goliath
  • 2021 Predictions for IBM i, Part 1
  • West Four Stands Out With On Demand Color Label Printing
  • HelpSystems Acquires Data Security, File Transfer Companies
  • Four Hundred Monitor, January 13
  • IBM i PTF Guide, Volume 23, Number 2

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2021 IT Jungle

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.