Transcription of Using SQL in RPG Programs: An Introduction
{{id}} {{{paragraph}}}
Example: stock market
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 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
Loading..
Tags:
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, Meridian Software, Inc., Raleigh NC, Using the Contents of PROC CONTENTS, Using the Contents of PROC CONTENTS to, Enhance compliance with corporate social media, Data analysis using R and the R-commander Rcmdr