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 .NbrNamePosSexSal10 AMY2F120035 JOE5M100030 JON7M150020 DON5M115025 ANN8F1550 SQL TermAS/400 TermTa b l eFileRowRecordColumnFieldTableRowColumnT erminologyBasic statementsSELECT - retrieves data; one row or multipleUPDATE - updates one row or multipleDELETE - deletes one row or multipleINSERT - adds one row or multipleEnvironmentsInteractive SQL - Use STRSQL commandEmbedded SQL - Put into High Level Language (HLL)Query Manager - Report FormatterData Manipulation Language Copyright Partner400, - 5

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:

  Programs, Introduction, An introduction, In rpg programs

Information

Related search queries