Just check whether you forgot the comma separator between the preceding field and the WDATE field.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them and keeping them!"
„Train people well enough so they can leave, treat them well enough so they don't want to.“ (Richard Branson)
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxx> On Behalf Of Booth Martin
Sent: Donnerstag, 20. Dezember 2018 19:19
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Subject: SQL0080: Position 44 Indicator variable WDATE not SMALLINT type.
I have an SQLRPGLE program selecting a 9/0 field, used for dates, into wDate which is a 10/0 field. There is nothing that I can see that is smallint about it.
The immediately adjacent field is a 7/0 field used for time, into wTime which is a 7/0 field and works fine.
What am I not seeing?
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
