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]




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