×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
RPG RLA WRITE sets an identity column properly without any special handling.
-----Original Message-----
From: Rob Berendt [mailto:rob@xxxxxxxxx]
Sent: Wednesday, February 07, 2018 7:19 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Handling default fields on RPG WRITE
Assume you aren't using DDS but you're using DDL.
Let's say you have a column like any of the following:
- an identity column which is always generated
- a column which is generated with other defaults, like current user, last changed timestamp, etc How do you prevent RPG from overriding it with the values from your program?
Thoughts which immediately come to mind are:
- Stop using RPG WRITE and use SQL and select only the columns you don't want defaulted
- Use a logical for output which omits defaulted columns
- Use O specs. Do those still require you put column position?
- Is there a %FIELDS like UPDATE has?
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
midrange.com
