Yeesh
sorry Darrell, but if ANY program attempts to use that data, I'm pretty
sure that someone is going to get a call @ 2:30 in the morning.
Someone should investigate why these values are there,
rectify the problem,
rectify the data
Murphys law stipulates that a problem is going to raise its ugly head at
the MOST inopportune time
Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill
DLee@xxxxxxxx
Sent by:
rpg400-l-bounces@ To
midrange.com rpg400-l@xxxxxxxxxxxx
cc
01/14/2010 02:36 Subject
PM Re: Embedded SQL Error 22023
Please respond to
RPG programming
on the IBM i /
System i
<rpg400-l@midrang
e.com>
Could use some help
When running an embedded sql program I get SQLSTATE error 22023 SQL CODE
-802 which means a paameter or host variable value is invalid.
And it's true, I discovered on some records, where the entry time and date
fields have blanks, like hex 404040.
These don't seem to be causing any problems anywhere in the system (yet),
and I really don't want to get into the process of correcting them if I
don't have too.
Is there a way I can run this sql, and ignore those two fields?
They are defined as numeric 6,0 for time and 8,0 for date.
Thanks for your help.
Regards,
Darrell
SWBC
9311 San Pedro Ave., Suite 600
San Antonio, TX 78216
Visit our website at www.swbc.com
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/rpg400-l.
midrange.com
