RE: Embedded SQL -- RPG400-L

× 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.

<snip>
I understand but what could cause it. The file has 16000+ records. The
file is reuse deleted records no. we ran a program to delete all the
records and then add them back in. We now have:

Member Size Type Date Date Time Records
Records
REL001P 2699264 10/16/06 06/21/07 16:51:00
16962 16965
Text: Customer Relationship File

Total number of members . . . . . . . . . : 1

Total number of members not available . . : 0

Total records . . . . . . . . . . . . . . : 16962

Total deleted records . . . . . . . . . . : 16965

Total of member sizes . . . . . . . . . . : 2699264

When I run the sql in the RPG program it returns 0 records and I get an
SQLSTATE of 42846 - Cast from source type to target type is not
supported.
If I run it interactively by using STRSQL it works. When I run it
interactively I notice that it show processing even the deleted ones but
it only selected the undeleted ones.

If I just do a RGZPFM on the file and call the program it works.

So I am at a loss.
</snip>

IBM support time. This has to be an OS problem.

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.