Re: how to make a key on a view?

On 1/30/2014 5:58 PM, Hoteltravelfundotcom wrote:

the source for the DTAWHS is this
CREATE TABLE PROJ_MKWN1/DTAWHS (
CUSTOMER# CHAR ( 8),
NAME CHAR (40 ),
CITY CHAR (30 ),
STATE CHAR (3 ),
COUNTRY CHAR (3 ),
ZIP_CODE char (10 ),
ITEM# CHAR (15 ),
ITEM_TEXT CHAR (40 ),
ORDER# CHAR (8 ),
ORD_STATUS CHAR (2 ),
INVOICE# CHAR (8 ),
ORD_DATE NUMERIC (8 , 0),
INV_DATE numeric (8 , 0),
ORD_TYPE CHAR (3 ),
CUST_TYPE CHAR (3 ),
PROD_LINE CHAR (3 ),
SALES_REP CHAR (3 ),
WAREHOUSE CHAR (3 ),

Now we're getting somewhere.

The source you posted above is stored in the source file QDDSSRC in
member DTAWHS. This is probably processed via RUNSQLSTM. The fact that
the member type is TXT is irrelevant to your question because the member
type is only important to SEU, PDM and RDi (editors and compiler front
ends).

On Thu, Jan 30, 2014 at 5:43 PM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

here is the official info on this file. Note that in the DDS it is has a
TYPE of TXT, yet, on an Library level view, it has an attribute of PF.



File . . . . . .
QDDSSRC

Library . . . . PROJ_MKWN1 Position to . . . .

Type options, press
Enter.

2=Edit 3=Copy 4=Delete 5=Display 6=Print
7=Rename

8=Display description 9=Save 13=Change text 14=Compile 15=Create
module...



Opt Member Type Text


DATAWHS_PT LF Part #
logical

DTAWHS TXT Create Table - SQL
Statement

SADTAW1F PF SA OutPut-Name/Add/Address (Ted
File)

SADTAW1FX PF SA OutPut-Name/Add/Address (Ted
File)

Once someone processed the source (CREATE TABLE), the database manager
created a table - a PF. As you show below, that table is in fact a PF
and it is called DATAWHS.

CMKWNDTW *PGM CLLE 90112 Clear and Add to
DTAW

MKWNDTW *PGM RPGLE 487424 SA Detail File
Build

CSUBINV4 *PGM CLLE 102400 SA Ext Rpt: Inv &
Mis

SUBINV3 *PGM RPGLE 1200128 Make Inv Dates
One-Ye

DATA_WHSV3 *FILE LF
65536

* DTAWHS *FILE PF
1210241024 *

DTAWHST *FILE PF
53248

QCLSRC *FILE PF 118784 CL Source
File

QDDSSRC *FILE PF 106496 DDS Source
File

QRPGLESRC *FILE PF 405504 RPGLE Source
File

Now for your question.

The table DATAWHS is not a view, it is a table in SQL parlance, or a PF
to a native OS programmer. It looks as if someone has created at least
one view (or LF) called DATA_WHSV3.

Do you want to access DATA_WHSV3 by a different key? Why? Is it
because there is select/omit criteria? Generally, one would do a CREATE
VIEW over the base PF (table), not over another logical file. If you
already had a VIEW (and I don't see that here), then you'd do a CREATE
INDEX to give the database manager some hints on how to optimise SQL
queries.

Let's assume for the moment that you had a VIEW with a key - how would
you be accessing it? SQL SELECT (including embedded SQL)? Query/400?
ODBC? RPG READE? OPNQRYF?
--buck