Re: _Rwrite to db with default value

Thanks Dennis.
Then I'll probably resort to another solution. The view thing just isn't
maintainable. I'm just wondering how this is really handled under the covers
of an RPG write for instance... I would think there would be a way to
simulate that.

Best wishes,
Erik

2010/9/16 Dennis Lovelady <iseries@xxxxxxxxxxxx>

The only choice I see in that case is that you could create a view over the
table that excludes the columns you don't want to write. Then write to
that
view.

Unless I'm missing something, your alternatives are to do that; or to drop
to SQL for the INSERT; or to generate and write the timestamp.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
Fear less, hope more,
eat less, chew more,
whine less, breathe more,
talk less, say more,
hate less, love more,
and all good things will be yours.
-- Swedish proverb

If I have DDL defined tables with columns holding DB2 generated values
such
as ROWID, defaults as CURRENT_TIMESTAMP etc - how do I code a write to
records like that using _Rwrite? To be overly clear, I don't want to
generate say the timestamp in my code, I want DB2 to insert the current
timestamp for each write on these types of columns. Any input
appreciated.

Thank you,
Erik
--
This is the C programming iSeries / AS400 (C400-L) mailing list
To post a message email: C400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/c400-l
or email: C400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/c400-l.

--
This is the C programming iSeries / AS400 (C400-L) mailing list
To post a message email: C400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/c400-l
or email: C400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/c400-l.