|
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 thetimestamp
field.dalejanus@xxxxxxxxxxxxxxxxx
On May 21, 2013 2:51 PM, "Charles Wilt" <charles.wilt@xxxxxxxxx> wrote:
You may not have referenced it but RPG did.default
RPG's file buffer contains every field.
If you use SQL or create a logical without the timestamp, it would
to current.
Charles
On Tue, May 21, 2013 at 3:39 PM, dale janus <
field,wrote:
I have defined a new file using ddl. I have added a time stamp
newopsdefined as data type timestamp, default value current time stamp via
nav.
I wrote an RPG program to move data from the old file format to the
me,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
no(RPG400-L)
thatmatter how I wrote the record (RPG, SQL, etc). But my results show
(RPG400-L)apparently I must initialize the fields, either in D specs or in thecalcs.
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)
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)
--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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.