Hello all,
When using Remedy ODBC driver,
We are having some problems executing qualified queries with any DB2
function (DATEADD etc.) in the query condition. We get the following
error message whenever we use any date / timestamp column.
System.Data.Odbc.OdbcException: ERROR [42S] Data types are not
appropriate for relational operation at
System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle,
SQL_HANDLE hType, RETCODE retcode) at
System.Data.Odbc.OdbcDataReader.Read() at Remedy.WebForm1.getConnected()
in D:\IISPath\wwwroot\Remedy\WebForm1.aspx.vb:line 70
We have tried all possible options to resolve this query. It looks like
the driver is not allowing any DB2 functions in the query.
Listed below is are sample query we are trying to execute through the
Remedy ODBC driver. We are performing these tests through our .NET code
in the Remedy Dev environment.
This query works
select Start_Time_of_Issue, GSD_Ticket_Number, Priority_Level,
Description, Clients_Affected, Time_of_Resolution,Issue_Owner from
DPSR_Form WHERE Time_of_Resolution IS NULL order by Priority_Level,
Time_of_Resolution DESC
This query doesn't works
select START_TIME_OF_ISSUE, GSD_TICKET_NUMBER, PRIORITY_LEVEL,
DESCRIPTION, CLIENTS_AFFECTED, TIME_OF_RESOLUTION, ISSUE_OWNER from
DPSR_Form WHERE PRIORITY_LEVEL IN ('1 - Urgent','2 - High') AND
TIME_OF_RESOLUTION > #DateAdd("d",-1,dateformat(now(),"MM/DD/YYYY"))#
order by PRIORITY_LEVEL, TIME_OF_RESOLUTION DESC
Can you please let us know if we are missing something and help us
resolve this issue? Any assistance would be appreciated.
*********************************************************************
This message and any attachments are solely for the
intended recipient. If you are not the intended recipient,
disclosure, copying, use or distribution of the information
included in this message is prohibited -- Please
immediately and permanently delete.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
