× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.