Re: _Rwrite to db with default value

It's an interesting question, and you might want to re-post it at the MI400
list. I'd like to see how the responses go there, myself.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"Fear of becoming a has-been keeps some people from becoming anything."
-- Eric Hoffer

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.

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