AW: SQLRPGLE -- date format question

["HauserSSS" <Hauser@xxxxxxxxxxxxxxx>]

Hi Jimmy,

I think you merge two things:
1. Host structure arrays are not supported by the precompiler before release
V5R3M0.
   If you are not yet on release V5R3M0, you have to use a multi occurence
datastructure instead.
   Note: Qualified datastructures are also not supported before release
V5R3M0

2. Date format
   A date is always saved as a binary numeric value. The date format is only
used to convert
   this numeric representation into a readable format.
   SQL converts the date at runtime depending on the actual format.
   The date format SQL uses is determined at compile time, either through
DATFMT option in
   the compile command or a SET OPTION statement in your source.
   The SQL precompiler replaces the SQL statement through API calls.
   It also create new fields for the host variables. If you have a host
variable
   that is a date, the new field gets the date format SQL uses.
   If your original field has date format *ISO (determined by the keyword
DATFMT in H- or
   D-Specs) and the SQL Date format is *JOB (i.e. *MDY) and the date is
either
   lower than 1940-01-01 or greater than 2039-12-31, your program will fail
at run time.
   Normally a program with this date formats gets compiled.

Birgitta


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