The display output format for SQL dataviews is shown below. The sample is a dataview for a DB2 view. Notice the ROW ID and TEXT areas following the field display.
=> ---------------------------------------------------------------------------------- IDEAL: DISPLAY DATAVIEW DVW IDLSQLM.CUSTADDR SYS: DOC DISPLAY Commnd Seq Level Field name T I Ch/Dg K Value ====== ================================ T O P ================================= 000001 CATALOGED 11/18/94 14:35 DB2 000002 1 1 IDLSQLM.CUSTADDR 000003 2 2 CUST_ID X 5 K 000004 3 2 NAME X 30 000005 4 2 ADDRESS X 30 000006 5 2 CITY X 15 000007 6 2 STATE X 2 000008 7 2 ZIP X 9 000009 8 2 PHONE X 10 000010 000011 ROW ID(s): 000012 IDLSQLM.CUSTIX: CUST_ID 000013 000014 TEXT: 000015 CREATE VIEW IDLSQLM.CUSTADDR 000016 (CUST_ID, 000017 NAME, 000018 ADDRESS, 000019 CITY, 000020 STATE, 000021 ZIP, 000022 PHONE) 000023 AS SELECT 000024 CUST_ID, 000025 NAME, 000026 ADDRESS, 000027 CITY, 000028 STATE, 000029 ZIP, 000030 PHONE 000031 FROM IDLSQLM.CUSTOMERS ====== ============================= B O T T O M ==============================
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|