|
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 mailing list archive is Copyright 1997-2025 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.