Using SQL in RPG Programs: An Introduction
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 SQLCreating/maintaining databases Using SQLSQL on the AS/400Using interactive SQLEmbedding 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/writesDFUQuery/400SQL 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
Download Using SQL in RPG Programs: An Introduction
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
Related search queries
Using SAS, To Move Data between, To Move Data between Servers, Data, Ing Data using the Bloomberg Excel, Ing Data using the Bloomberg, Using Data, Enhance compliance with corporate social media, Data analysis using R and the R-commander Rcmdr, Meridian Software, Inc., Raleigh NC, Using the Contents of PROC CONTENTS, Using the Contents of PROC CONTENTS to