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
