Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am getting error while using load with the sql statment . Please find the sql and load statement. Please correct me if the script is wrong
ODBC Connectivity
Trendanalysis:
crosstable(datetype,Date,2)
Load
CID,
TID,
LTIME,
TRTIME;
SQL SELECT
"CUSTOMERID" as CID,
"TICKETID" As TID,
(TO_CHAR((TO_DATE('01/01/1970 00:00:00', 'MM/DD/YYYY HH24:MI:SS') + ((TICKETLOGGEDTIME)/(60*60*24))))) As LOGGEDTIME,
(TO_CHAR((TO_DATE('01/01/1970 00:00:00', 'MM/DD/YYYY HH24:MI:SS') + ((TICKETRESOLVEDTIME)/(60*60*24))))) As TRTIME FROM TICKETDETAILS Where CUSTOMERID in ('1','2','3','4','5');
Regards,XXX
Hi,
it is resolved. I have used small letters in the Load statement. Hence i was getting the error. Now i have changed and it is working fine.
Regards,XXX
In the SQL statement, you have use LOGGEDTIME. however you use LTIME in the LOAD statement. Correct it!!!
hi,
i have corrected it but still i am getting the error.
Hi,
it is resolved. I have used small letters in the Load statement. Hence i was getting the error. Now i have changed and it is working fine.
Regards,XXX