Can you move this app to another server and upgrade the Client to V6R1 ?
Might be time to start the migration process.
From the limited google info available it looks like you either eliminate indicator variables (possibly coerce to a different format in your SQL) or upgrade CA/400 to V6R1.
Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site:
http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT
----------------------------------------------------------------------
message: 1
date: Tue, 12 Apr 2011 11:17:25 -0500
from: Mike Wills <mike@xxxxxxxxxxxx>
subject: [SystemiDotNet] Error on Old Code
Hey all, I am adding a page to one of my ASP.NET applications. I do a simple lookup query to collect some information. Previously, we were on V5R4 and now on 6.1. My Client Access is still at V5R4 until we migrate all of our ASP.NET applications to 6.1 (Royal pain BTW). In this app, I am using a DataSet (xsd) to build the needed code to work with the tables. My statement looks like:
SELECT PIN13, HOUSE_NUMB, ADDRESS, DEEDHOLDER, MAIL1, MAIL2, MAIL_CITY,
MAIL_STATE, MAIL_ZIP
FROM BECPARP
WHERE (PIN13 = ?)
I am passing in "R010930103004".
My error message is:
---------------------------
Microsoft Visual Studio
---------------------------
SQL Execution Error.
Executed SQL statement: SELECT PIN13, HOUSE_NUMB, ADDRESS, DEEDHOLDER, MAIL1, MAIL2, MAIL_CITY, MAIL_STATE, MAIL_ZIP, PIN17, PIN12, PIN17DOT, PINL10, CITYTWP, ACREAGE, GIS_NUMBER, MAP_NAME, CONTRACTTO, SUBDIVDESC, SECTION, LOT, BLOCK, LEGAL, DEEDED_ACR, TOTAL_LAND, TOTAL_DW...
Error Source: IBMDA400 Command
Error Message: SQL0363: Extended indicator variable value for item 1 not valid.
Cause . . . . . : The value of the extended indicator variable for item 1
was not within the range of acceptable values. The value must be in the
range of 0 to -7 inclusive. Recovery . . . : Change the value of the
extended indicator variable to one which is allowed for the statement or context in which it was used. Try the request again.
This was working on V5R4. Any ideas?
Upgrading the client is out of the question at this time like this answer
suggested:
http://forums.systeminetwork.com/isnetforums/showthread.php?t=74921
--
Mike Wills
http://mikewills.me
midrange.com
