I'm getting the error : "ERROR: CLI describe error: [IBM][CLI Driver][DB2] SQL0401N The data types of the operands for the operation "" are not compatible or comparable. SQLSTATE=42818" I suspect that it has to do with my filter that uses a macro, when I read up on this I saw that it's probably because of the version of DB2 we are running. Is anyone able to help me fix this? I've bolded where I believe the problem is. Ultimately I'm going to pull one month at a time summarize it and stack it all up. I want to be able to just say "do i=1 to 24" and it gives me back 2 years summarized how I want it. If relevant I'll be adding some procs after this one before I close the macro that does the summary/append. I have tried to insert some casts with the macro references but it hasn't worked. The do loop works on its own and the proc sql works on its own outside of a macro with the dates manually entered log error /*IN PROGRESS FULL MACRO*/
%macro iscool();
%DO i = 1 %TO 2;
data _null_;
%LET INPUTDATE = %SYSFUNC(INTNX(MONTH,'01JAN2017'D,&i,B));
CALL SYMPUT('A', put(&INPUTDATE,mmddyy10.));
CALL SYMPUT('B', put(&INPUTDATE,mmddyy10.)); /*this will turn into EOM eventually*/
%PUT &INPUTDATE &A &i;
RUN;
/*RUNS ON DB2*/
PROC SQL;
CONNECT TO ODBC AS DB2 (dsn=dsn user="&USER" pwd="&PWD");
CREATE TABLE MainData AS
SELECT * FROM CONNECTION TO DB2
[lots of code that worked before I adjusted the below]
where
C.LIAB_ASGN_IND = 'Y'
/*TESTING DATES*/
AND A.CLM_OPEN_DT between &A and &B
);QUIT;
%END;
%mend;
... View more