DB2 10.1 SQL0418N Error
Posted: Wed 25 May 2016 15:18
Hello,
I try to run the following query in DB2 10.1 with devart for DB2 1.8.636 and EF 6.1.40302.0 but an SQL0418N error is returned.
The problem is in line 12:
As it seems, EF Provider does not cast the p__linq__1 parameter. If I manually cast it, then the query runs correctly!
Any ideas on how to resolve the problem?
I try to run the following query in DB2 10.1 with devart for DB2 1.8.636 and EF 6.1.40302.0 but an SQL0418N error is returned.
Code: Select all
SELECT
Project2.roiRoadIncidentID,
Project2.rocRoadContractID,
Project2.C1,
Project2.roaRoadAssignmentID
FROM ( SELECT
Limit1.roiRoadIncidentID,
Limit1.rocRoadContractID,
Extent3.roaRoadAssignmentID
CASE WHEN Extent3.roaRoadAssignmentID IS NULL THEN CAST(NULL AS INTEGER) ELSE 1 END AS C1
FROM (SELECT
@p__linq__1 AS p__linq__1,
Extent1.roiRoadIncidentID,
Extent2.rocRoadContractID
FROM Administrator.Interamerican_RoadIncident Extent1
INNER JOIN Administrator.Interamerican_RoadContract Extent2 ON Extent1.roiRoadContractID = Extent2.rocRoadContractID
WHERE Extent1.roiRoadIncidentID = @p__linq__0
FETCH FIRST 1 ROWS ONLY ) Limit1
LEFT OUTER JOIN Administrator.Interamerican_RoadAssignment Extent3 ON (Extent3.roaRoadIncidentID = Limit1.roiRoadIncidentID) AND (Extent3.roaRoadAssignmentID = @p__linq__1)
) Project2
ORDER BY Project2.roiRoadIncidentID ASC, Project2.rocRoadContractID ASC, Project2.C1 ASCCode: Select all
@p__linq__1 AS p__linq__1,
Code: Select all
CAST(@p__linq__1 AS INTEGER) AS p__linq__1,