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



FYI, the reason code is   -- Reason 2 - host variable S1ENTDT is a
numeric type that is different than the type of the value being
retrieved.

The FIENTD is defined as 8S 0 (via a physical file)

On 4/17/06, rick baird <rick.baird@xxxxxxxxx> wrote:
> I have a multirow fetch into a qualified multi occurance DS - code as follows.
>
> I'm getting an SQL7919, data conversion required, on S1ENTDT even
> though I defined it 'like' the field I'm fetching.  It's not a hard
> error, but I noticed it in my joblog when testing the program in
> debug.
>
> any ideas?
>
> d s1DS            ds                  dim(15)      qualified
> d S1STYL                              like(FISTYL)
> d S1COLR                              like(FICOLR)
> d S1LOGO                              like(FILOGO)
> d S1CMT1                              like(FICMT1)
> d S1CMT2                              like(FICMT2)
> d S1ENTDT                             like(FIENTD)
> d S1EXPDT                             like(FIEXPD)
> d S1USER                              like(FIUSER)
> d S1REAS                              like(FIREAS)
> d S1STAT                              like(FISTAT)
> <snip>
> c/exec sql
> c+
> c+             declare  c1      scroll cursor
> c+                 for
> c+              select  FISTYL,
> c+                      FICOLR,
> c+                      FILOGO,
> c+                      FICMT1,
> c+                      FICMT2,
> c+                      FIENTD,
> c+                      FIEXPD,
> c+                      FIUSER,
> c+                      FIREAS,
> c+                      FISTAT
> c+                from  BLOFPDP
> c+               where  FISTYL = :C1STYL
> c+            order by  FISTYL, FICOLR, FILOGO
> c+        optimize for  15 rows
> c+
> c/end-exec
>


As an Amazon Associate we earn from qualifying purchases.

This thread ...

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.