No, it’s not bitter and sweet or anything like that! INSERT is a very powerful SQL statement that many people don’t take full advantage of. I’m going to explain its two ways of working—its two “flavors” if you will. Keep reading!
By Rafael Victória-Pereira
Most programmers are familiar with the INSERT SQL statement, and some (including me) prefer it to Data File Utility (DFU) because it’s reproducible, controlled, and most important, easy to track. It’s true that you can save all those spool files produced by DFU somewhere, but it’s not easy to re-input data or even reuse inputted data. With INSERT, a simple copy-paste-adjust operation is all it takes to add a second or third record that shares some similarities with the original statement. Read More
Get empowered with IBM Power
