Re: AS400 SQL Errors and Resources

> I reallize that the SQL syntax should be similar among all DB's which allow > SQL, but there are slight differences amongst them. With that said, I have > written an SQL statement to the AS400 and am getting errors back. So, and I > don't have ANY, I need a site to visit where I can reference DB2 and SQL for > the AS400. > Here is my error code: > > SQL error: [IBM][CLI Driver][AS] SQL0401N The data types of the operands for > the operation "= " are not compatible. SQLSTATE=42818 , SQL state 42818 in > SQLExecDirect > > Any ideas? If you can't find docs, throw out bits and pieces of your SQL statement until it doesn't complain, and those are the columns that it doesn't like comparing/using with =, and look at their data types and find a way to cram them down its throat. :-) > Was this Off-Topic? > Any suggestions where I could post these questions? There's a php-db@lists.php.net that would be more appropriate maybe... -- Visit the Zend Store at http://www.zend.com/store/ Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm