RE: [U2] - Determining time sequence
If you are meaning "Across the entire system" as in multiple computers, make sure you are synchronizing time from a common source. If you have Unix systems, running NTP / XNTP services or equivalent and synching with multiple (at least 3) stratum 2 time servers, then syncing internal systems with your time servers would be needed. Bob Gerrish Kingsgate Enterprises, Inc. At 05:14 PM 6/27/2005, you wrote: The thing is I do not want to end up with a bottle neck as the idea behind this is to create a log of transactions across the entire system which can then be used to replicate the data into SQL Server in sequential order. So I want a system wide sequential ID not per file. Using time and looping if the key exists will allow me to do this, as I have down to milliseconds for the key. However the regular time can be effected by Daylight savings time and I want to guarantee time order. Cheers, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Tuesday, 28 June 2005 11:45 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] - Determining time sequence Maybe you should (re)read the thread on sequential IDS --> simply have a "counter" that you increment and you can then be sure to maintain the correct sequence of events. If you want you could then add time() as part of the key, but the REAL, absolute sequence is then derived from your sequential ID, and the noted time is simply ancillary documentation Ross Ferris Stamina Software Visage - an Evolution in Software Development >-Original Message- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of phil walker >Sent: Tuesday, 28 June 2005 8:38 AM >To: u2-users@listserver.u2ug.org >Subject: [U2] - Determining time sequence > >I need to generate a timebased sequential key which is independent of >daylight savings time, so that I can consistently know in what order >transactions took place even when they occur over the daylight saving >time changes. > >I have found the following in the help system about the BASIC SYSTEM(99) >function: > > Returns the system time in the number of seconds > since midnight Greenwich Mean Time (GMT), January > 1, 1970. > >And initially thought I could use this function, but after some testing >are having doubts. Has anyone else done something similar to this? > >Cheers, >--- >u2-users mailing list >u2-users@listserver.u2ug.org >To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [OT] API - Importing Data To GA R91
Greetings, If anyone has esperience with or has knowledge or any API (or other method) of importing data into GA R91 PICK, please contact me off line at: [EMAIL PROTECTED] or [EMAIL PROTECTED] Any information would be appreciated. Thanks, Bob Gerrish --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unique Ids
Although I have seen most of the "Unique ID' scenarios that were presented, there is one that has been missed. I have seen keys that appeared identical but had one or more trailing spaces. They appeared unique to the untrained observer. AND this could happen with a SQL database, also if the key field was a text field. Bob Gerrish --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] POS for Pizza Restaurant
The $1000 is AFTER paying for the DBMS, unless we look at OpenMV, that is. Thanks, Bob At 10:06 AM 2/4/2005, you wrote: Is that $1000 before or AFTER you pay for the DBMS (assuming they aren't using the 2 user freebie) Ross Ferris Stamina Software Visage an Evolution in Software Development >-Original Message- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of Bob Gerrish >Sent: Friday, 4 February 2005 2:04 PM >To: u2-users@listserver.u2ug.org >Subject: [U2] POS for Pizza Restaurant > >Anyone out there know of any reasonably priced (under $1000) >POS systems in UniVerse (or mv in general) that would work for > a Limited Service Pizza Restaurant that does delivery? I have a >client with a limited budget that needs something. > >Thanks >Bob Gerrish - [EMAIL PROTECTED] >--- >u2-users mailing list >u2-users@listserver.u2ug.org >To unsubscribe please visit http://listserver.u2ug.org/ > > >-- >No virus found in this incoming message. >Checked by AVG Anti-Virus. >Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 3/02/2005 > -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 3/02/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] POS for Pizza Restaurant
Anyone out there know of any reasonably priced (under $1000) POS systems in UniVerse (or mv in general) that would work for a Limited Service Pizza Restaurant that does delivery? I have a client with a limited budget that needs something. Thanks Bob Gerrish - [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] AD Universe/Unidata Programmer Wanted
My apologies to the list - I was trying to send direct to the source and am half asleep, still this morning - no caffeine yet! At 03:48 PM 1/10/2005, you wrote: U2logic, Inc a leading IBM VAR, is looking for several Universe/Unidata programmer. RedBack and SB+ experience is a plus. Excellent working environment with 100% company paid health and dental benefits. [EMAIL PROTECTED] 1-866-XLr8me2 (1-866-957-8632) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] AD Universe/Unidata Programmer Wanted
Greetings, I may be interested. Where? Perm? Temp? Contract? If Contract, 1099 or corp to corp? Telecommute? My Corporation (I am the main and currently, only employee) is at: http://www.kingsgate-enterprises.com/ My resume is online: http://www.connectexpress.com/~bobg/bob-resume.html Thanks, Bob Gerrish At 03:48 PM 1/10/2005, you wrote: U2logic, Inc a leading IBM VAR, is looking for several Universe/Unidata programmer. RedBack and SB+ experience is a plus. Excellent working environment with 100% company paid health and dental benefits. [EMAIL PROTECTED] 1-866-XLr8me2 (1-866-957-8632) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV Pre-printed forms
My email was down for several days - now that it is up, I will reply. One of my clients need something similar, but when switching from ADV PICK on SCO to UniVerse on Win2K. I set them up with the "REFORM" spooler. Reform will take the output and put it on a predefined overlay. The docs say it will work with Unix, the only caveat is that Reform, itself, only runs on Windows. http://www.fabsoft.com/ I am a reseller of their product, but consultants can easily become resellers. Thanks Bob Gerrish Kingsgate Enterprises, Inc. At 05:22 AM 1/4/2005, you wrote: One of my clients would like to replace their pre-printed forms with those Thanks in advance Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Server-To-Server - Round Two
I only have a second - I'll address the directory tree copy you couldn't do. WS-FTP should allow you to copy an entire directory tree. It is available online (you'll need to search for it) for free. Alternately, if you happen to have Samba running on each Unix box, you could just use Windows Explorer to copy directory trees. NFS mount across the boxes could also work. Connect to the source directory and: tax cvf - . | (cd /destinaion-path ; tar xf -) This could be used to copy the user's home directories if they are in a tree structure. Bob Gerrish At 04:16 PM 10/27/2004, you wrote: Using a PC DeskTop FTP program, I was able to copy all of the files from the old server to my pc and then from my pc to the new server. I setup an account on the new server. I need help with correlating the new account with the existing data and VOC. If there is a way to copy over users and printers, that would help. Thanks to those who responded to the first post. The command-prompt FTP functionality appears to be unable to copy a directory tree, rather, only one folder at a time. It is not clear to me if it is makes sense to "mount" a directory from another box. I am not sure if tar is usable since I doubt that the tape drive on the old box can be connected to the new box. --Bill A new [refurbished] HP-Ux RX-2600 Itanium server arrived yesterday. I installed UV on this new box and now want to copy most everything from old to new. What is the best way to do this? The tech manual "Administering UniVerse" appears to mainly focus on inter-platform transfers. Suggestions would be appreciated. --Bill --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ Thanks, Bob Gerrish - [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC first query
I tried the nslookup command on the server and got the following reply *** 192.168.25.143 can't find nslookup:No response from server Any other advice before I start playing with it? Set it up on the Unix box, if it is a static IP. Crudest (and easiest) way is to put it into the hosts file (/etc/hosts) Bob Gerrish - [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] major (?) @var security hole
I used this at a client site where they wanted to use 1 login name, but track individuals via a secondary login run via a BASIC program. If it is brought up as a bug to IBM, it could have negative implications at sites like that. Bob Gerrish - [EMAIL PROTECTED] At 12:34 PM 9/10/2004, you wrote: this may be common knowledge , but I stumbled across this yesterday at a client's site and was very surprised / alarmed. if you rely on system variables, @LOGNAME , @WHO in particular, for any kind of security / access control , you may be interested to know that these 'static'/'read only' variables can very easily be modified to contain any values you like - including other user ids and account names. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC first query
At 01:50 PM 9/9/2004, you wrote: A common cause of long delays when first connecting is reverse dns lookups. On the last project I worked on, we found that using the IP address for the system name eliminated this problem. We found ODBC to be too slow in the long run, though and switched to OleDB. Thanks, Bob Gerrish - [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe 10.1.1 ODBC driver
At 01:14 AM 8/11/2004, you wrote: Although we aren't using schemas, we too have experienced timing issuues when retrieving data via the UVODBC. We supply our customers with a 3rd party report writer that connects to Universe via the UVODBC driver. Most of the time this works fine, but on some queries we have noticed that the query can either take hours or get in to what appears to be a continous loop. When this occurs the server is normally affected by the CPU running at 100% and all other processes on the server suffer as you would expect. This normally results in us having to dial in to the customer site, kill the process on the Windows side and then log of the Universe user at TCL to free up the server again. Project I finished up with in March was experiencing this same behavior, occasionally, on some files (no Schemas). Processes had to be killed, also. Switching to OleDB helped speed up processes significantly. Thanks, Bob Gerrish - [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata keystroke capture
Allen, It sounds like a lot of us have done full screen editors, I did mine about the mid 1980's. Bob Gerrish Kingsgate Enterprises, Inc. At 08:51 AM 7/10/2004, you wrote: Hi Ralph, I have a full screen editor that I wrote about .. um. 1990 or so, that works great. I've also adapted it to a full screen TCL manager, and have used it for editing dicts as well. Care to make me an offer for the source? In case you decide no, here's my section from what you're working snip Allen E. Elwood Senior Programmer Analyst Curnayn and Associates Direct (818) 361-5251 Fax(818) 361-5251 Cell(818) 800-5595 Home (818) 361-7217 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] READU vs LOCK
You are both on the right track. > I may be wrong, but I have a vague memory that in the very early days, > multivalue databases (Pick?) didn't have record level locking. Martin you are not wrong. And it wasn't the "very early days" :) Well maybe it was and I'm just a dinosaur ... It was the early days until some of the PICK variants started doing record locks. At any rate, Pick did group locking, not record locking. The entire group a record is in was locked and held locked until the process was finished and did it's WRITE or Release. So it's possible the use of LOCK is related to that. Alternatively perhaps the program was trying to LOCK the entire FILE (!) So in effect maybe it's doing a FILELOCK ? The group locks were not a problem in low volume situations with little activity. In large applications (Like MMC - Manufacturing Management and Control - the predecessor of about 1/3 of the Manufacturing packages) processing was complex enough and high volume enough that group locks on multiple file updates often lead to deadlock situations. Each file was assigned a semaphore lock. These semaphore locks were often used in conjunction with record locking via Escom user modes and a LOCK file to produce pseudo record locks. Mark you said that the LOCKs are assigned to particular files, so if I tried to read another record from that file I have to wait right? So this sounds like a primitive form of FILELOCK to me. It was more of a LOCK on updates to the LOCK file for records pertaining to a particular database file. Bob Gerrish Kingsgate Enterprises, Inc. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Re: Once again and updated. Cheapest way to have Pick talk to Web ?
You should be able to do it similarly from the Windows CMD prompt or as a batch file. (Provided you have an interface from CGI scripting to Windoze.) > #!/bin/sh > /usr/ibm/uv/bin/uv MYCGIPROGRAM > > or even > > #!/usr/ibm/uv/bin/uv MYCGIPROGRAM I think you're talking Unix, I need Windows :) Will --- Bob Gerrish - [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] Cost of Oracle vs PICK
I always tell everyone that you can do it in PICK with half the budget and a 1/3 the staff of any given project in Oracle. That is the plus. There is a lot of flexibility in the data structure. I agree with the security side. In RDBMS models, in general, you can (must) embed constraints and business rules in the database, itself rather than the application. This makes the database more secure. Bob Gerrish - [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] Companies going belly up converting from PICK/MV
I haven't heard of any that went belly up, but quite a few that have spent much longer at a much greater cost than they anticipated. I'm sorry that I can't really name any names - some are still clients. That being said, I was involved in the early 70's with a MRP / Accounting integrated package in the Pacific NW. Our excellent sales person / part owner of the company sold 2 companies a version to be converted from PICK to HP Image and Prime DBMS and gave the customers initial quotes of 40 hours (yes I said hours) for the entire package. Of course that one was way over budget and over hours. Bob Gerrish - [EMAIL PROTECTED] At 07:05 AM 5/16/2004, you wrote: I've tried to search the archives for some old postings and have been unsuccessful, so sorry for asking for previously posted info. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users