AW: SQLRPGLE -- date format question

["HauserSSS" <Hauser@xxxxxxxxxxxxxxx>]

-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]Im Auftrag von Jimmy Ballard
Gesendet: Dienstag, 30. November 2004 22:27
An: 'rpg400-l@xxxxxxxxxxxx'
Betreff: SQLRPGLE -- date format question


Hello all,

I have an SQLRPGLE program that is populating a host data structure via an
SQL fetch statement. The date format in the file is *ISO, and my DS in the
RPG program specifies DATFMT(*ISO). However, the program will not compile --
the initial compile listing (which is very short -- I assume its some type
of SQL precompiler) lists the error as "Host structure array ... not defined
or not usable."

My question is this -- I can fix the problem if I compile the program with
DATFMT(*ISO) -- but if I add an H spec to the top of the source for
DATFMT(*ISO) it doesn't compile. In SQLRPGLE programs are the H specs
ignored? Sure would be nice if that worked.

While I have your attention -- a quick second question.  One of my
annoyances with Client Access is that the light blue and the yellow colors
on display files have those irritating column separators. Whats up with
that? Is there any way to get around it?

Thanks!
-Jimmy
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.