Re: [U2] Unwanted Duplicates

Use the UNION keyword in MERGE.LIST. GET.LIST LIST 1 TO 1 GET.LIST LIST2 TO 2 MERGE.LIST 1 UNION 2 If you are using UniData, use ECLTYPE U not ECLTYPE P. get.list LIST1 TO 1 get.list LIST2 TO 2 merge.list 1 UNION 2 From HELP: Note: UniQuery only supports MERGE.LIST is in ECLTYPE U. Note: The

[U2] Entering a Value Mark

Sorry for the late reply but have been under the weather. I believe you can enter ^253 (that's shift-6 carat and number 253) to get a value mark into an attribute. Shaun Ferguson Information Technology, Application Architect I Ferguson Enterprises, Inc. 12500 Jefferson Avenue * Newport News *

[U2] UniData Triggers

We are creating a trigger on a file that is used extensively in the system. Is it necessary to logoff users when creating an update trigger on a file or does UniData handle that when updating the trigger information to the header of the file? The 'help' does not specify whether trigger creation

Re: [U2] UniData Triggers

Thank you for your replies! We also make use of master trigger subroutines that call subroutines so that is not an issue. I just wanted to be sure that the initial creation of an update trigger on a file would not affect current logged in users with that file open. We'll do the creation in the

[U2] html 2 xls

Anyone know of a conversion tool that will take html and produce xls (Excel spreadsheet) formatted files? We are running UniData on HPUX but could probably use a utility on a windows server if necessary. Thanks! Shaun Ferguson Applications Architect I Wolseley Group Services - 12500 Jefferson

Re: [U2] Very Weird Trigger Behavior

. --- Wow! This is really similar to what I'm trying to do. What is your: OS, Unidata version, BASICTYPE? Also, are you having success with both ECL DELETEs and UniBasic DELETEs? Thanks! Jonathan Shaun.Ferguson wrote: We are doing this with a county and zip file

Re: [U2] Very Weird Trigger Behavior

We are doing this with a county and zip file - the trigger is on the county file and a record cannot be deleted if it's referenced in the zip file: SUBROUTINE TRIG.COUNTY.DEL (EXECSTAT, DICTFLAG, FILENAME, COUNTY_ID) EQU DELETE_DENIED TO 0 EQU DELETE_ALLOWED TO 1 EXECSTAT = DELETE_DENIED IF

Re: [U2] UV retrieve

Have you tried specifying dictionary items in the list command? EX; LIST ANYFILE F1 F5 USING DICT VOC Shaun Ferguson Master Data Systems Analyst Wolseley Group Services - 12500 Jefferson Avenue - Newport News - VA - 23602-4314 T: (757) 989-2916 - F: (757) 989-2801 - E:

Re: [U2] UD: Phantoms

I am on digest, so apologies if this is a duplication of a suggestion made earlier. We tend to use plain old record locks for our phantom processes. The record won't list but if you try to edit it, it will come back as locked and prevents a second instance of the process from running. Ex; *

[U2] 2 cents

Amazing that almost entire digest posts have been dedicated to helping one individual (Mr Walgude of Rsystems, International, ltd) with one piece of logic in UniBasic. I can't imagine what it's going to be like when more of these questions are asked. Will we still have a viable UG helping each

Re: [U2] Error 4 22 from PHP exec of uv on AIX

Sorry, I'm on digest... Does the user executing this command have a profile setup with the paths to Universe? I've been working in UniData so it may be different, but the user has to have their environment setup to the correct paths to UniData bin, etc (UDTBIN = /blablabla/ud/bin). Shaun

Re: [U2] Triggers and Account Copy

Triggers on files usually call subroutines that do something, update an audit file or check for consistency or add an item to a queue, for example. As long as the trigger subroutines are accessing local files in the test environment and the main trigger subroutines are cataloged globally, you

[U2] Index Rebuilding

I'm on digest, so sorry for the delay. Indexes on UniVerse and UniData are different. UniVerse will stop you from creating them if the file is open by any process (very good!). UniData will go on it's merry way and create the index even if the file is open by another process. You run the

[U2] UniData Dynamic File Behavior

Hello and happy new year! HpUx 11.11 - UniData 6.1.18 - We have a dynamic file created with KEYDATA using the default split/merge of 95/40. Monday night, an automated purge process kicked off removing approx. 310,000 plus records from this file. On Tuesday, the process was still running and the

[U2] RE: reindexing

Jeff, You did not mention the flavor of U2, but I know that on UniData, if the file is open by anyone, the index does not function properly even though it appears to have performed your indexing commands without error. UniVerse, on the other hand, complains that the file is not available to

[U2] UniData Application Monitor

Hello all, I am trying to search for a monitoring tool for UniData UniBasic applications and am getting no results at indexinfocus.com. The search engine appears to be hosed. Anyone have any suggestions? Specifically, we want to know things like, how often a subroutine is called, how much cpu

[U2] RE: Named Common

I'm on digest, but here's an example of named common which we use extensively supporting many many concurrent users (makes the systems fly without all that open file overhead, imho). Hpux / UniData, btw. 001: *INCLUDE EX.NAMED.COMMON 002: * EX named common and file open routine 003: * 004:

[U2] Unidata Data Replication - RECONFIG command

Hello all! Unidata 6.1.10 on Unix - I am doing a preliminary investigation of Data Replication and will be setting up a test environment. The guide says that I can install it manually (creating files, updating a table, setting the REP_FLAG in udtconfig), but, it also says that the system is

[U2] BY.EXP Levels

Unidata 5.2 running on HPUX 11i Just a quick question, though I know I won't get an answer til the a.m. (digest only)... Does anyone know how many fields one can do BY.EXP on before this type of error occurs? system error in get_oldloc() index=1, wlv=-2, *vnumb=1, *snumb=1system error in