[CASE-OPENED] iDM Function in sub-select

March 20, 2015, 03:08 AM

janlouw_infobuild

Hi,

I'm using:
-*DM_CLIENT_RELEASE_GEN=M728100D_827
-*DM_SERVER_RELEASE_GEN=M728100D_827

I'm trying to do a function call to a sqlserver 2008 r2 function within a sub-select.

SQL PREPARE SQLIN FROM
SELECT
T1.FIELD_1 ,
T1.FIELD_17 ,
(SELECT MIN(SQ.@RETURN_VALUE ) FROM
MAITLAND.GETINSTRUMENTIDENTIFER SQ WHERE SQ.@FROMTYPECODE = 'InstCode' AND
SQ.@TARGETTYPECODE = 'BbgUniqID' AND
SQ.@FROMREFERENCEVALUE = T1.FIELD_17 ) AS INST
FROM
corporateactions T1
END
-RUN
When I run the flow I get the following error:
(FOC1400) SQLCODE IS 201 (HEX: 000000C9) XOPEN: 42000
Microsoft SQL Server Native Client 10.0: [42000] Procedure or function '
getInstrumentIdentifer' expects parameter '@FromReferenceValue', which was not supplied.
(FOC1406) SQL OPEN CURSOR ERROR.

SQ.@FROMREFERENCEVALUE = T1.FIELD_17...why is this not working?
When I use a normal sub-select and refer to fields in the main select it works perfectly.

Please help!
Regards,
J

This message has been edited. Last edited by: <Kathryn Henning>,