Transcription of Using SQL in RPG Programs: An Introduction - …
{{id}} {{{paragraph}}}
Your partner in AS/400 and iSeries Education Copyright Partner400, M. @ SQL in RPG Programs: An Introduction OCEAN Technical ConferenceCatch the WaveAgendaWhat is SQL?SQL language overviewAccessing data Using SQLC reating/maintaining databases Using SQLSQL on the AS/400 Using interactive SQLE mbedding SQL in programsQuery Manager Copyright Partner400, - 1-2 .What is SQL on the AS/400?An alternative database interface languageNOT a database management systemHigh level, simple statement formatsA language used for:Data Definition (DDL)Data Manipulation (DML)Completely interchangeable data methodsSQL tables may be accessed with native language DDS created files can be access with SQLOS/400 Integrated Relational Database ManagerDDS definitionSQL DDLIDDUHLL reads/writesDFUQ uery/400 SQL DMLOne Database Manager Copyright Partner400, - 3-4.
Use SQL source member types e.g., SQLRPG, SQLRPGLE, SQLCBL, SQLCBLLE Prompting won't work without SQL member type You can prompt SQL statements in SEU
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}