Re: timestamp not correct

Coud Stuart be referring to OSPECS to control what fields are written?


On Wed, May 22, 2013 at 8:18 AM, Charles Wilt <charles.wilt@xxxxxxxxx>wrote:

No, %fields() only works for UPDATE.

Charles


On Tue, May 21, 2013 at 6:39 PM, Stuart Rowe <rowestu@xxxxxxxxx> wrote:

You can also specify the fields on the write opcode, snd omit the

timestamp

field.
On May 21, 2013 2:51 PM, "Charles Wilt" <charles.wilt@xxxxxxxxx> wrote:

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.

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