Re: timestamp not correct

You may not have referenced it but RPG did.

RPG's file buffer contains every field.

If you use SQL or create a logical without the timestamp, it would default
to current.



Charles


On Tue, May 21, 2013 at 3:39 PM, dale janus <dalejanus@xxxxxxxxxxxxxxxxx

wrote:

I have defined a new file using ddl. I have added a time stamp field,
defined as data type timestamp, default value current time stamp via ops
nav.

I wrote an RPG program to move data from the old file format to the new
empty file. all the time stamps are 0001-01-01-00.00.00.000000 .
In the program, I never referenced the timestamp field.


I thought sql and ddl was supposed to put data into that field for me, no
matter how I wrote the record (RPG, SQL, etc). But my results show that
apparently I must initialize the fields, either in D specs or in the

calcs.

This isn't working the way I thought it would work.

---Dale


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

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