[PHP] AS400 SQL Errors and Resources

2001-02-05 Thread Karl J. Stubsjoen

Hello,

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?
Was this Off-Topic?
Any suggestions where I could post these questions?

Thanks guys!

Karl


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] AS400 SQL Errors and Resources

2001-02-08 Thread Richard Lynch

> 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 [EMAIL PROTECTED] 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



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]