Load with sql statement

[#1]

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

[#2]

In the SQL statement, you have use LOGGEDTIME. however you use LTIME in the LOAD statement. Correct it!!!

[#3]

hi,

i have corrected it but still i am getting the error.

[#4 · Accepted solution]

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