|
Rob
I'm lost somewhere - does TrustedLink use UPDDTA? I don't recall UPDDTA
mentioned as part of this thread.
Your point on recompiling with DDS is well-taken.
Regards
Vern
On 8/11/2023 6:15 AM, Rob Berendt wrote:
However, how does that DFT really work? Just because one thing workswith
UPDDTA doesn't necessarily mean it will work that way in an RPG program.has
Often the buffer gets initialized totally different. For example, DDS
keywords to restrict a value of a field to certain characters, forexample
Y or N. And that may even be enforced in UPDDTA. However if I want toADDPFCST
write an RPG program, or even use a sql insert statement, I can put
whatever I want into that field. You define that with DDL, with a
constraint right there within the DDL and it can't be set to any other
value. Sure you can bolt constraints onto a DDS defined file with
but that's not within the DDS and the next person comes along andin
recompiles the DDS and your constraints are gone.
On Thu, Aug 10, 2023 at 4:09 PM VERNON HAMBERG Owner via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:
If TrustedLink will let Greg do that, of course. I think I covered that
currenta reply - there is a DFT in DDS, and the docs suggest it will use
specifydate or time, if you don't specify it - I think you also should not
robertowenberendt@xxxxxxxxx>a field in the WRITE.
SQL is the ticket here, of course, as you say.
Cheers
Vern
On Thu, 10 Aug, 2023 at 2:37 PM, Rob Berendt <
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>>wrote:
To: midrange systems technical discussion
Here's the problem: "... an existing database file (DDS)".
Quit that. Use SQL's DDL instead. DDL will allow you to default new
columns to current date, etc. DDS will NOT. Sure, you can add triggers
and stuff but that isn't really DDS, is it?
On Thu, Aug 10, 2023 at 1:57 PM Greg Wilburn <
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:
whenwrote:
I recently added an ISO date and ISO time field to an existing database
file (DDS). This file is populated by our TrustedLink EDI software
updatewe
receive an inbound PO. I guess I had hoped it would capture thedate/time
the record was created. Tli support says the EDI translator won't
gwilburn@xxxxxxxxxxxxxxxxxxxxxxxthose "automatically".https://www.totalbizfulfillment.com/>> Greg Wilburn
Anyone know of a method of getting these fields to update with current
info upon creation? Otherwise, I'll have to update them in my RPG
processing program.
TIA,
Greg
[Logo]<https://www.totalbizfulfillment.com/><
Director of IT
301.895.3792 ext. 1231
301.895.3895 direct
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:
list<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>>
1 Corporate Drhttp://www.totalbizfulfillment.com<http://www.totalbizfulfillment.com>>
Grantsville, MD 21536
www.totalbizfulfillment.com<http://www.totalbizfulfillment.com><
--list
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:
Before posting, please take a moment to review the archivessupport@xxxxxxxxxxxxxxxxxxxx> for any subscription related
at https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:
questions.--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
listTo post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:
MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:
MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:
support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
relatedTo post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
questions.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
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.