Re: timestamp not correct

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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.