Home > AS/400 Tips > iSeries book excerpts > The iSeries Pocket SQL Guide -- Chapter 4
iSeries 400 Tips:
EMAIL THIS
 TIPS & NEWSLETTERS TOPICS 

ISERIES BOOK EXCERPTS

The iSeries Pocket SQL Guide -- Chapter 4


Brian Kelly
04.04.2006
Rating: -3.56- (out of 5)


iSeries news and advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



As a registered member of Search400.com, you're entitled to a complimentary copy of Chapter 4 of The iSeries Pocket SQL Guide written by Brian Kelly and published by MC Press. This chapter, "SQL concepts & facilities " will help you to master iSeries SQL database development.


[IMAGE]

Book description:

In today's IT landscape, most shops support heterogeneous systems with numerous client and server PCs, and even Unix boxes. Ironically, all of these non-iSeries platforms, from the smallest to the largest have one thing in common in the relational database area. They all use SQL as their data language. That's a big change in the database landscape. Nobody even tries to deny that SQL is now the industry data/query language standard. IBM backs SQL 100%. A quick look at the SQL function list for V5R4 gives a good indication...


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
iSeries book excerpts
IBM System i APIs at Work, Second Edition -- Chapter 10
SOA for the Business Developer -- Chapter 2
Managing Without Walls -- Chapter 7
IBM WebSphere Portal Primer, Second Edition -- Chapter 2
AS/400 Primer, Third Edition -- Chapter 6
WebSphere Application Server: Step by Step -- Chapter 2
Hot iSeries books in 2006
Java for RPG Programmers, Third Edition -- Chapter 10
Active Server Pages Primer -- Chapter 2
The Modern RPG IV Language, Fourth Edition -- Chapter 13

iSeries SQL commands and statements
Enhancing RPG with external SQL stored procedures
Tracking data changes on IBM i with triggers
Introduction to SQLRPGLE on IBM i: Making a report
Making the most of RPG data handling on IBM i
When is the YES option for 'reuse deleted files' function the best choice?
Monitoring members 'stuck' within a physical file on an EDI system
Creating a host variable of the 'where in' statement in SQL
SQL server error message -321
Choose which column names are returned via ODBC when working with DB2 files
Convert a numeric physical file to a character in SQL without leading zeros
iSeries SQL commands and statements Research

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


that SQL will have an even more important role in the iSeries future. IBM has been chipping away at all the little things and the annoying things over the years so that SQl is no longer a lesser function cousin on iSeries to DDS. It certainly is not yet the time to throw in the DDS towel but the new SQL functions are more and more compelling with each release. So, today, it makes little sense for an iSeries professional to not be on board by warming up to SQL – at least for functions that return sets of data.

>> Read "Chapter 4: SQL concepts & facilities" now.

>> After you've read the chapter, test yourself to see how much you know.

>> Want to learn more about the book? Buy the book from MC Press.

Rate this Tip
To rate tips, you must be a member of Search400.com.
Register now to start rating these tips. Log in if you are already a member.




DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.



iSeries Security - Security Tools, Physical Security and System Security
HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy 		  TechTarget - The IT Media ROI Experts