db2 "import from docfiles.ixf of ixf messages impmsg.txt create into tigris.tmpdocfiles"


CREATE VIEW TIGRIS.DOCVIEW ( DOCIND,    DOCTYPEIND,     DOCCLASSIND, TITLE,         OWNER,   REVIEWPERIOD, AUTHIND,   KNOWLEDGEBASE,  WEBABLE,     WEBONLY,       FAXABLE, FLASHNEWS, FLASHDATE, ACCESS_SUPPORT, EMAILABLE,   EMAILABLEDATE, SUMMARY, METRICIND, ADDINFO,   PARTNUM,        PUBTYPE,     LNDOCID,       SOURCE,  MAINTLOCK, SHOW,      PUBLISH,        WORKIND,     RECYCLED,      DBUSER,  CHANGEDTIME, NAVIGABLE, ENDOFLIFE,      LASTMODIFIED ) AS SELECT A.DOCIND,    A.DOCTYPEIND,     A.DOCCLASSIND, B.TITLE,                A.OWNER,   A.REVIEWPERIOD, A.AUTHIND,   A.KNOWLEDGEBASE,  A.WEBABLE,     A.WEBONLY,              A.FAXABLE, A.FLASHNEWS, A.FLASHDATE, A.ACCESS_SUPPORT, A.EMAILABLE,   A.EMAILABLEDATE,        A.SUMMARY, A.METRICIND, B.ADDINFO,   A.PARTNUM,        A.PUBTYPE,     SUBSTR(B.LNDOCID,1,11), A.SOURCE,  B.MAINTLOCK, A.SHOW,      B.PUBLISH,        B.WORKIND,     B.RECYCLED,             B.DBUSER,  B.CHANGEDTIME, A.NAVIGABLE, A.ENDOFLIFE,      B.LASTMODIFIED 
FROM TIGRIS.DOCUMENTBASE A,
TIGRIS.DOCUMENTS B WHERE A.DOCIND = B.DOCIND AND B.LANGUAGEIND = 1



select * from tigris.docfiles where DOCIND IN (SELECT DOCIND FROM TIGRIS.DOCVIEW WHERE DOCIND = 62068 AND PUBLISH = 'Y' AND WEBABLE = 'Y' AND ENDOFLIFE = 'N' AND DOCCLASSIND = 3