Anthony

<div>
<div class="content wysiwyg-content">
Does anyone know the syntax that would be used to create a multimember view using SQL on the AS/400? &nbsp;I have a table that has 4 members and in order to do a type of specific type of update, I need to see all the members in one view.<br />
<br />
Any help on this would be appreciated.<br />
<br />
Thanks.<br />
<br />
-Anthony
</div>
</div>


Does anyone know the syntax that would be used to create a multimember view using SQL on the AS/400?  I have a table that has 4 members and in order to do a type of specific type of update, I need to see all the members in one view.

Any help on this would be appreciated.

Thanks.

-Anthony

How to create a view using multimember table

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.