Re: Insert Data AS400

Richard, > If that doesn't help, just start throwing out columns. Or throw them all > out and build it up 1 column at a time) until you find out which one it > doesn't like. I have gone as far as creating a single table with a single alpa field. No luck there either. It gives me the exact same error. > PS Am I to assume you actually have a working PHP<->AS400 connection? If > you could build a PHP/AS400 page, you would probably get much traffic. > People keep asking about AS400, and I've never even seen one. I am succesfully selecting data from the AS400. But no insert yet. Haven't tried creating tables or anything else beyond that. Karl *end of my reply* ----- Original Message ----- From: "Richard Lynch" <richard@zend.com> To: <php-general@lists.php.net> Sent: Thursday, February 08, 2001 8:21 PM Subject: Re: [PHP] Insert Data AS400 > > I'm having troubles inserting records into our AS400. I've tried just > about > > every combination I can think of when trying to insert a record, but > nothing > > is working. Here is the most recent error I keep getting: > > > > Warning: SQL error: [IBM][CLI Driver][AS] SQL7008N REXX variable "WBO230P > " > > contains inconsistent data. SQLSTATE=55019 , SQL state 55019 in SQLExecute > > > > And here is the SQL command: > > INSERT INTO WEBTEST.wbo230p (WOSTS, WOORD, WOCUS, WOST, WSNAM, WSAD1, > WSAD2, > > WSADX, WSAD3, WSSTA, WSZIP, WOPO, WODTTM, WONORD, WINVDT, WPHONE, WEMAIL, > > WSBSTA, WSAMT) VALUES ('1',0000000001,000001,0001,'t ','t > > ','t ','t ','t > > ','t ','t ','t ',00000000000001,'t ','t > > ','t ','t ','t ','t ') > > Like, unless AS400/IBM/CLI/AS SQL is way different from SQL92, you either > don't need WEBTEST, or there should be no .wbo230p, or you aren't telling us > that you are doing something funky like trying to insert into one database > (WEBTEST) even though you are connected to another... > > But, even so, WEBTEST.wbo230p maybe be fine, and it's just one of those > columns whose data it doesn't like. > > The question, of course, is which one. > > The leading 0's on WOORD and WOCUS and [mumble] look pretty darned > suspicious to me. If those are integer, they should just be 1, not 000001. > If they are *not* integer, you need apostrophes on them just like the > others. > > If that doesn't help, just start throwing out columns. Or throw them all > out and build it up 1 column at a time) until you find out which one it > doesn't like. > > I dunno why SQL engines are so darned non-specific in their error messages. > My favorite: > syntax error near ',' > Thanks guys! Like what non-trivial SQL statement *doesn't* have a bazillion > commas in it?! > > PS Am I to assume you actually have a working PHP<->AS400 connection? If > you could build a PHP/AS400 page, you would probably get much traffic. > People keep asking about AS400, and I've never even seen one. > > -- > 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: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >