Search found 28 matches

by KevinW
Thu Mar 22, 2018 9:24 am
Forum: Suggestions for Product Enhancements
Topic: Template variable @@LATnnxx
Replies: 1
Views: 7345

Re: Template variable @@LATnnxx

Is this an enhancement?

If, as I suspect, it is not, report it to your local LANSA support organization, along with platform & version, LANSA product and version, and how they can reproduce it.
by KevinW
Tue Feb 06, 2018 11:47 am
Forum: Questions & Answers
Topic: File Level Triggers
Replies: 9
Views: 2141

Re: File Level Triggers

Why not make the database do the work? Forget about LANSA file level triggers and make the logical view that is keyed by the columns unique. You do have such a logical view, don't you. Your next job of course is to make the duplicate key error comprehensible to the user. Edited to say oops this has ...
by KevinW
Thu Nov 02, 2017 3:12 pm
Forum: Questions & Answers
Topic: VL Web(LANSA for the Web) :Current JOB changed other user ID
Replies: 8
Views: 4896

Re: VL Web(LANSA for the Web) :Current JOB changed other user ID

Also, using the CL program as is entails a profile handle leak, and may cause an out of user handles error condition if it is called often enough in the one job (20000?). It needs to release the profile handle after using it.
by KevinW
Wed Apr 12, 2017 9:17 am
Forum: Questions & Answers
Topic: File Locks On "Deliver To"
Replies: 5
Views: 1898

Re: File Locks On "Deliver To"

Most installations have a maintenance window when production users are either not there (before or after normal hours, straight after a back up etc), or announce one in advance. I am surprised that you have not had previous issues. Do you expect that after a certain date and time users will all be u...
by KevinW
Thu Mar 23, 2017 11:56 am
Forum: Questions & Answers
Topic: HTML Editor and Log File/Field changes
Replies: 16
Views: 5665

Re: HTML Editor and Log File/Field changes

RE: is there away to programmatically loop on the fields for the #TRIG_LST? Write an old school building block template. Unfortunately only good for up to 99 fields :( Following is untested: @@GET_FILS TO(1) PROMPT('Enter file for the trigger') @@CLR_LST NUMBER(01) @@RTV_FLDS FROM_FILE(01) INTO_LST(...
by KevinW
Mon Feb 20, 2017 10:04 am
Forum: Questions & Answers
Topic: Using WITH_KEY and WHERE with SELECT command
Replies: 3
Views: 1529

Re: Using WITH_KEY and WHERE with SELECT command

As usual, it depends. The WITH_KEY parameter(s) are always used in the OAM to request the I/O. 1. If the LANSA WHERE does not contain RDML(X) variables not in the file 1.1 if access is via SQL (windows, linux, some IBM i) then the LANSA WHERE is added on to the SQL WHERE (so added to the WITH_KEY pa...
by KevinW
Wed Feb 01, 2017 9:06 am
Forum: Questions & Answers
Topic: Changing Library in Server Module
Replies: 8
Views: 2810

Re: Changing Library in Server Module

CHGLIBL is an IBM i command. So what you pass to the SYSTEM_COMMAND BIF is
"CHGLIBL LIBL(XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX ...)"

Alternatively, the EXEC_OS400 RDML command could be used.
by KevinW
Wed Nov 23, 2016 9:05 am
Forum: Questions & Answers
Topic: Rebuild Table on Check In Files on IBM i
Replies: 2
Views: 1185

Re: Rebuild Table on Check In Files on IBM i

If you loaded the other file from the IBM i then these two options do nothing. If you loaded the other file from elsewhere then these two options will do as they state. Think about it. If the file exists in the IBM i data base and LANSA says it is maintained by "OTHER" then LANSA won't maintain it, ...