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



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

Follow-Ups:

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.