Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     (FOC14096) TABLE CONTAINS NO KEY FOR MATCH LOGIC

Read-Only Read-Only Topic
Go
Search
Notify
Tools
(FOC14096) TABLE CONTAINS NO KEY FOR MATCH LOGIC
 Login/Join
 
Member
posted
When trying to insert records into a table I am getting the above error. This table is a rollup table designed to run each night and summarize the previous days worth of data so that when we run reports we can run against this table with smaller data as opposed to the main table with millions of records.

Any assistance as to why this error is occurring and how I can fix it would be appreciated. The following code below is what my report looks like.

-*****(Web Focus - 7.6.11)*****-

-SET &YESTERDAY = AYMD(&YYMD, -2, 'I8YYMD');
-SET &MONTHS = EDIT(&YESTERDAY,'$$$$99$$');
-SET &DAYS = EDIT(&YESTERDAY,'$$$$$$99');
-SET &YEARS = EDIT(&YESTERDAY,'9999$$$$');

-SET &FDATE = EDIT(&MONTHS | '/' | &DAYS | '/' | &YEARS);
-SET &FFDATE = EDIT (&FDATE | ' 12:00:00');

-SET &DATES=HHMMSS(TMSEC);
-SET &FTIME = EDIT (&DATES, '99:$99:$99');

-**********PROCESS_DATE******************
-SET &YESTERDAY2 = AYMD(&YYMD, 0, 'I8YYMD');

-SET &MONTHS2 = EDIT(&YESTERDAY2,'$$$$99$$');
-SET &DAYS2 = EDIT(&YESTERDAY2,'$$$$$$99');
-SET &YEARS2 = EDIT(&YESTERDAY2,'9999$$$$');

-SET &FDATE2 = EDIT(&MONTHS2 | '/' | &DAYS2 | '/' | &YEARS2);

-****************************************

-SET &YESDAY2 = EDIT(&YESTERDAY, '9999/99/99');

-SET &YESDAY3 = EDIT(&YESTERDAY2, '9999/99/99');

-SET &DATE1 = EDIT(&YESDAY2 | ' 00:00:00');
-SET &DATE3 = EDIT(&YESDAY2 | ' 23:59:59');
-SET &FFDATE2 = EDIT (&YESDAY3 | ' ' | &FTIME);


ENGINE SQLORA SET DEFAULT_CONNECTION MODSNJ1.WORLD
ENGINE SQLORA SET DATETIME OFF
SQL SQLORA
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY/MM/DD HH24:MI:SS';
END


ENGINE SQLORA SET DEFAULT_CONNECTION MODSNJ1.WORLD
SQL SQLORA PREPARE SQLOUT FOR
SELECT '&DATE1' AS REPDATE,A.CLIENT_ID,A.SUBCLIENT_ID,B.CLIENT_NAME,B.SUBCLIENT_NAME,A.RECOMMEND,A.REPORT,
COUNT(A.OID) AS VOLUME,SUM(A.TOTAL) AS VALUE, A.CURRCD,A.VIRTBIN,'&FFDATE2' AS PROCESS_DATE
FROM TRANS_MASTER A, COP_MASTER B
WHERE A.CLIENT_ID = B.EBIT_CLIENT_ID
AND A.SUBCLIENT_ID = B.EBIT_SUB_CLIENT_ID
AND A.oid_date between '&DATE1'
and '&DATE3'

GROUP BY A.CLIENT_ID,A.SUBCLIENT_ID,B.CLIENT_NAME,B.SUBCLIENT_NAME,A.RECOMMEND,A.REPORT, A.CURRCD,A.VIRTBIN
;
END

TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS #HLIST1 FORMAT SQLMSS
END
-RUN
-*-- Insert all the rows from the temporary table ----------
ENGINE SQLORA SET DEFAULT_CONNECTION MODSNJ1.WORLD
SQL
INSERT INTO DAILY_TRANS_VIRTBIN_SUMM_VIEW (CLIENT_ID,REPDATE,SUBCLIENT_ID,CLIENT_NAME,SUBCLIENT_NAME,RECOMMEND,REPORT,VOLUME,VALUE,CURRCD,VIRTBIN,PROCESS_DATE)
SELECT CLIENT_ID,'&DATE1',SUBCLIENT_ID,CLIENT_NAME,SUBCLIENT_NAME,RECOMMEND,REPORT,VOLUME,VALUE,CURRCD,VIRTBIN,'&FFDATE2' FROM #HLIST1
;
END
-RUN


7.6.4
windows
Excel2k and HTML.
 
Posts: 10 | Registered: April 02, 2008Report This Post
Virtuoso
posted Hide Post
quote:
DAILY_TRANS_VIRTBIN_SUMM_VIEW

Could it be that this table has an access file that states KEYS=0?


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Guru
posted Hide Post
Did you check to make sure that there is data in the hold file?


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Report This Post
Member
posted Hide Post
Each day there is abotu 14-20K worth in records


7.6.4
windows
Excel2k and HTML.
 
Posts: 10 | Registered: April 02, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     (FOC14096) TABLE CONTAINS NO KEY FOR MATCH LOGIC

Copyright © 1996-2020 Information Builders