Insert Data AS400
| From: | Karl J. Stubsjoen | Date: | Thu, 08 Feb 2001 22:44:00 +0000 |
| Subject: | Insert Data AS400 | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-38825@lists.php.net to get a copy of this message | ||
Help! (if you can).
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 ')
Any Ideas why this isn't working?
Thanks! Karl