What does it typically mean when you get the FOCUS TRACE Eroor (FOC2599) NON-SQL SEGMENT IN HIERARCHY (OTHER INTERFACE PRESENT)? I have a report which selects the desired fields through a SQL statement Such as:

SELECT
JOB_ID, JOB_DESC, JOB_NAME
FROM
JOBS

TABLE
ON TABLE HOLD AS SQLOUT1
END

I then connect the new focus table to an existing focus table by JOB_ID. Once those tables are connected they output the final results and hold them to an htm table which is later used in an html document. When I run the trace I still get the error mentioned above

Aaron
WebFOCUS 7: 7.1.4
WINXP
Excel, PDF, HTML: EXCEL, PDF, HTML

You are joining something that is not an SQL-based table to an SQL-based table.

Oh Okay,
The First Three Tables that I am retrieving data from are SQL Server Tables, I then hold the data retrieved to a focus table. Then I join that focus tables to another table of type DB2, Im guessing that is where the issue is taking place.

Here is the following code.... Any suggestion on where the ERROR is occurring and how it can be fixed

-DEFAULT &txtPolNum = ' ';

SET EMPTYREPORT = ON
SET ACCBLN = ON

SQL
SELECT
A.JOB_ID, A.DOC_ID, A.CURRENT_USR, A.COMPANY, A.DEPARTMENT,
A.ACCOUNT, A.FOLDER, A.STEP_DATETIME, A.STEP_DESC, A.FLOW_NAME,
A.USED_BY_NAME, B.USER_KEY_3, C.DOCTP_DESC, D.USER_FIRST_NAME,
D.USER_LAST_NAME, D.USER_LOGIN_ID, D.FULLNAME
FROM (
((WKFL_MASTER_QUEUE A LEFT OUTER JOIN tfb_optimg05_audit C ON C.doctp_id = A.doc_id)
LEFT OUTER JOIN optimg01 B ON B.pg_doc_id = A.doc_id )
LEFT OUTER JOIN sec_users D ON D.userid = A.current_usr)
WHERE (A.company <> 'CLAIMS')
AND (C.doctp_desc = '&txtPolNum')
AND (B.pg_doc_id = A.doc_id);

TABLE
ON TABLE HOLD AS SQLOUT2
END

TABLE FILE SQLOUT2
PRINT
JOB_ID
DOC_ID
CURRENT_USR
COMPANY
DEPARTMENT
ACCOUNT
FOLDER
STEP_DATETIME
STEP_DESC
FLOW_NAME
USED_BY_NAME
USER_KEY_3
DOCTP_DESC
USER_FIRST_NAME
USER_LAST_NAME
USER_ID
FULLNAME
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS CALC2_SQL FORMAT FOCUS INDEX USER_ID
END

JOIN
LEFT_OUTER CALC2_SQL.SEG01.USER_ID IN CALC2_SQL TO UNIQUE
OD_USER_INFO.OD_USER_INFO.USER_ID IN OD_USER_INFO AS J2
END

TABLE FILE CALC2_SQL
PRINT
JOB_ID AS 'Job ID'
DOCTP_DESC/A30 AS 'Document'
USER_KEY_3 NOPRINT
FLOW_NAME/A50 AS 'Flow Name'
USED_BY_NAME AS 'Used By'
NEW_FULLNAME AS 'Current User'
NEW_EMAIL NOPRINT
STEP_DESC/A50 AS 'Step Description'
COMPANY/A50 AS 'Company'
DEPARTMENT/A50 AS 'Department'
ACCOUNT/A50 AS 'Account'
FOLDER/A50 AS 'Folder'
DAYS_DIFF AS 'Days In Queue'
NEW_DOCTP_DESC/A30 NOPRINT
ON TABLE SUBHEAD
"Current Queue by Policy Number"
ON TABLE SUBFOOT
"Generated on <+0>&DATE <+0> "
ON TABLE SET PAGE-NUM OFF
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
ON TABLE HOLD AS H1 FORMAT HTMTABLE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
PAGECOLOR=RGB(245 245 245),
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
JUSTIFY=LEFT,
$
TYPE=DATA,
BACKCOLOR=( 'WHITE' RGB(223 223 223) ),
$
TYPE=DATA,
COLUMN=N6,
WHEN=N7 NE 'N/A',
JAVASCRIPT=fnMail(NEW_EMAIL NEW_DOCTP_DESC),
$
TYPE=DATA,
COLUMN=N14,
BACKCOLOR=( 'WHITE' RGB(223 223 223) ),
JUSTIFY=CENTER,
$
TYPE=TITLE,
FONT='VERDANA',
SIZE=10,
BACKCOLOR=RGB(184 184 165),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=20,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=11,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
TYPE=REPORT,
COLUMN=N14,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N3,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N8,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N2,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N4,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N9,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N10,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N11,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N12,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N13,
WRAP=6.000000,
$
ENDSTYLE
END
-RUN
-HTMLFORM BEGIN
<script LANGUAGE=JAVASCRIPT>
function fnMail(Email,Subject)
{
window.location = 'mailto:' + Email + '?Subject=' + Subject;
}

!IBI.FIL.HOLD;
-HTMLFORM END

-HTMLFORM currentqueuebypolicynumber
-HTMLFORM BEGIN
!IBI.FIL.H1;
-HTMLFORM END
-HTMLFORM BEGIN
&LINES job(s) found

You are correct as to the cause in your next to the last previous post. One way to get around that is to select the data from the last SQL table separately but use the key data from the FOCUS file. Use the WHERE IN FILE syntax. Your file can be no longer than 16000 bytes.

Thankyou thats solved my problem