I'm trying to perform a JOIN between 2 tables, then loading 2 fields from the JOIN into a table, using the DEFINE FILE command. Please advise.

ENGINE DB2 SET DEFAULT_CONNECTION ITIMDBP
JOIN
FSLDAPIDENTITYACCOUNT.FSLDAPIDENTITYACCOUNT.DN IN FSLDAPIDENTITYACCOUNT TO
FSLDAPIDENTITYACCOUNT_AUTHCERTDN.FSLDAPIDENTITYACCOUNT_AUTHCERTDN.DN IN
FSLDAPIDENTITYACCOUNT_AUTHCERTDN AS J1
END
SQL DB2 PREPARE SQLOUT FOR
SELECT ERUID FROM ENROLE.FSLDAPIDENTITYACCOUNT
SELECT AUTHCERTDN FROM ENORLE.FSLDAPIDENTITYACCOUNT_AUTHCERTDN
JOIN ENROLE.FSLDAPIDENTITYACCOUNT ON
ENROLE.FSLDAPIDENTITYACCOUNT_AUTHCERTDN.DN = ENROLE.FSLDAPIDENTITYACCOUNT.DN
END
DEFINE FILE SQLOUT
USERID/A8 = ERUID
IDX/I2 = POSIT(AUTHCERTDN, 240, '+', 1, IDX);
AUTHNAME/A60 = SUBSTR(60, AUTHCERTDN, 1, IDX - 1, IDX - 4, AUTHNAME);
END
TABLE FILE SQLOUT
PRINT DST.USERID
PRINT DST.ORGSHORTNAME
ON TABLE PCHOLD FORMAT XML
ON TABLE SET HOLDLIST PRINTONLY
END
(FOC1400) SQLCODE IS -104 (HEX: FFFFFF98)
: [42601] [IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token "ERUI
: D FROM ENROLE.FSLDAPIDENTITYACCOUNT" was found following "SELECT ". Exp
: ected tokens may include: "". SQLSTATE=42601
L (FOC1405) SQL PREPARE ERROR.
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: SQLOUT
BYPASSING TO END OF COMMAND
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: SQLOUT
BYPASSING TO END OF COMMAND

This message has been edited. Last edited by: Kerry,

WebFocus Developer Studio version 7611
Windows, All Outputs

I'm a bit confused on the mix of SQL and WebFOCUS code in this one. So, please check you syntax and try to break it down to block of significant code. I think the basic syntax should be more like this:

SQL ODBC
SELECT *
FROM oeorgsummarysample
;

TABLE FILE SQLOUT
PRINT (desired fields)
END

?

In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.    Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206