Re: Error on Old Code

No other web servers are setup. Might have to convince the web dev to
switch now. I wish IBM allowed multiple versions. This is a royal pain
having to update EVERY application that uses Client Access and we have quite
a few.

--
Mike Wills
http://mikewills.me


On Tue, Apr 12, 2011 at 1:19 PM, Richard Schoen <richard@xxxxxxxxxxxxxxx>wrote:

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


--
This is the .net use with the System i (SystemiDotNet) mailing list
To post a message email: SystemiDotNet@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/systemidotnet
or email: SystemiDotNet-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/systemidotnet.