[U2] UniData Hash File Viewer

the overflow pointers, etc. I checked the Wiki but didn't see anything like this. I have written a cool program like this that just allows one to traverse an OS file, but isn't hash file smart. Before I go and modify it I thought I'd ask the list first. David A. Green (480) 201-7953 DAG Consulting

Re: [U2] Multi-threaded phantom processing

made the auditors very happy. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls Sent: Wednesday, March 05, 2014 5:57 PM To: U2 Users List Cc: U2 Users List

Re: [U2] Multi-threaded phantom processing

Will you kinda lost me on this approach. Since the Server socket is on a different machine than the client they don't see each other's locks. Different clients might be on different servers too. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun

Re: [U2] Multi-threaded phantom processing

I don't know how you would query the OS on the fly, but you can do a manual search for a bank of 10 or 20 unused ports and claim them. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org

Re: [U2] Multi-threaded phantom processing

that would just spawn a transfer server socket and send the socket address to the calling client. Then the client disconnects from the main server and just uses the transfer server to complete the task. Having 10 open phantoms with sockets will use up 10 licenses. David A. Green (480) 201-7953

Re: [U2] Left Outer Join Question

Remove the TO 3 on the MERGE command. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Monday, March 03, 2014 3:37 PM To: u2-users@listserver.u2ug.org

Re: [U2] [UD] Who's locking a record

Can you get what you need using GETREADU? David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, January 28, 2014 1:18 PM To: U2 Mail List Subject

Re: [U2] Regarding: LISTING SUB-VALUES

Shan is CUSTOMER.PHONE.NUMBER an associated MV? If you have an association with a field like CUSTOMER.PHONE.TYPE and you want just the FAX numbers then you can use the WITH keyword in your query like: :LIST CUSTOMER CUSTOMER.NAME WHEN CUSTOMER.PHONE.TYPE EQ FAX CUSTOMER.PHONE.NUMBER David

Re: [U2] BASIC code - upper, lower, CamelCase, what say you?

that contained CSS code in. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Friday, December 20, 2013 12:02 PM To: U2 Users List Subject: [U2] BASIC code

Re: [U2] Unidata index/query ?

of records then you are processing them by index pointer and the disk reads will be all over the file. Whereas without the index you are reading the file going through it by groups and it will minimize the disk reads. David A. Green (480) 201-7953 DAG Consulting -Original Message- From

Re: [U2] Unidata index/query ?

Yes, Doug if an index is properly done it will make a huge difference. But there are times when using an index can be slower. And this is the point I'm making. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users

Re: [U2] Working with accented characters

:= THIS.WORD:DATA.CHAR THIS.WORD = END ELSE OUT.DATA := DATA.CHAR END RETURN ! END David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Little

Re: [U2] [OT] Interview Questions

Why not let HR handle the personality questions and background checks, that's what they do. That leaves you to concentrate on their technical abilities. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun

Re: [U2] What is the equivalent to UNNEST in Universe

Does UniVerse have ASD( ... ) keyword? That's what you would use in UniData. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adrian Halid Sent: Tuesday, August 20, 2013

Re: [U2] KeyPressed

Try a HUSH ON/OFF around your input. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, August 09, 2013 1:04 PM To: 'U2 Users List' Subject: [U2

Re: [U2] [UD] BASIC Code Failing

Intermittent data issues can be one of the hardest to debug. One way that has helped me out is to create a log file to log the transaction information, then verify the data and when it is incorrect, send off an email with the log file key to investigate. David A. Green (480) 813-1725 DAG

Re: [U2] Running total

Here is what I use: SUBROUTINE RUNNING_TOTAL(CUR.TOT, AM.PTR, AMT, RESET.DATA) * RUNNING_TOTAL Keeps a Running Total for Reports * by David A. Green -- 9/12/01 * COMMON /RUNTOT/ RUNTOT.REC(10) * EQUATE RUNTOT.FLAG TO RUNTOT.REC(1) EQUATE RUNTOT.TOTS

[U2] DEBUG in a Phantom issue

Has anyone seen a phantom process get stuck in a loop because of an embedded DEBUG statement? I would think the input at the ! prompt would have aborted the phantom, but it just kept going saying invalid input over and over and over. just about filled the disk. UniData 6.1 David A. Green (480

Re: [U2] UniData PreStore to change the KEY of a record?

I would take my saved list and copy it to a text editor then using copy commands and a quick macro convert the list into a bunch of COPY FROM FILE.A BAD.KEY, GOOD.KEY commands. Then save it as a PA and then execute it. David A. Green (480) 813-1725 DAG Consulting -Original Message- From

Re: [U2] Selecting a special character in a SELECT (UV)

Try: ALT-160 Example: SELECT MY.FILE WITH @ID LIKE ...á... (By holding down the alt key and pressing 160 on the numeric keypad. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org

Re: [U2] [uv] Phantom question

of sockets * Knowledge of SMTP protocol * A subroutine to encode BASE64 David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey Sent: Wednesday, March 27, 2013 2

Re: [U2] REDBACK Fatal UniBasic errors

Bill, thanks for the post, I will check this location for debugging purposes. But it doesn't help my issue of having Redback send back an error message that makes more sense when the UniBasic program aborts. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2

[U2] REDBACK Fatal UniBasic errors

terminating now. Is there a way to capture a better error message? David A. Green (480) 813-1725 DAG Consulting ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] ISO Date Format

In UniData you can just use D-YMD. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Monday, March 11, 2013 6:57 AM To: U2-Users@listserver.u2ug.org

Re: [U2] Unidata WHEN/ASSOCIATED

Jeff, This could be a good enhancement. How do you want it to work? 1. SELECT just the IDs or whatever the SAVING clause points to. Or 2. SELECT the IDs,MV pointers that match But until it goes through I'm sure someone has already written the code to do it in a UniBasic program. David

Re: [U2] I Descriptor no longer working in UniSQL after UD upgrade

Have your compiled your i-descriptor? Is it marked as MV? David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Tuesday, March 05, 2013 5:42 AM To: U2

Re: [U2] UV full screen editor

Is there a way to have BDT use a TCL command besides BASIC/CATALOG to do my compile and cataloging? David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent

Re: [U2] FW: Clearing Input Buffer

CLEARINPUT David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: Friday, February 22, 2013 12:52 PM To: 'U2 Users List' Subject: Re: [U2] FW: Clearing Input

Re: [U2] Turn pagination back on

BPIOCP David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, February 07, 2013 1:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] Turn pagination

Re: [U2] Record locks (Unidata 7.2)

. *Note you can use GETUSERNAME(STATUS()) to see who has it locked. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jon Wells Sent: Wednesday, February 06, 2013 2:53 PM

Re: [U2] [UD] SETPTR

Bill, sounds like a domain name network issue. How does a ping to UDGENERIC respond? Maybe you can add the IP address to your host file? David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun

Re: [U2] Sleeping in Basic

, , 2) PRINT Start UPDATE.REC.PH for :REC.KEY GOSUB UPDATE.REC PRINT Wake up process :UTP.ID WAKE UTP.ID David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf

Re: [U2] Sleeping in Basic

Try changing the port number to something that doesn't exist. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: Friday, December 28, 2012 8:22 AM To: 'U2

Re: [U2] Sleeping in Basic

Doug this works for me in UniData: SLEEP.TIME = 500 ;* .5 Second ERR = openSocket(loopback, 25, 1, SLEEP.TIME, hBUFF) David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org

Re: [U2] Wally Terhune

Wally you will be missed. I've enjoyed working with you over the years. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: Thursday, December 13, 2012 3:04

Re: [U2] Advantage of indirect call in BASIC

Does anyone have any current benchmarks on this type of call? Several years ago when I tested it in UniData it was very slow call compared to using the name. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun

Re: [U2] [UD] Select - Suppress ...IDs do not exist: Message

You can always turn it on and off inside your program or paragraph. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Friday, November 30, 2012 1:16 PM

Re: [U2] Improving performance

PERSON then create the I-Desc to get the needed DONOR data and use PERSON as the base file. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Saturday, November

Re: [U2] Multiple UniData Indexes in same select

It will never use both. Usually the first index command possible will be used. Although I believe an EQ will override an index with GE. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun

Re: [U2] Accessing an https:// server with callHTTP

Kevin my UniBasic is the client. Have you this line in your code? protocolLogging(_PH_\HTTP.LOG.FILE, ON, 10) it might provide some important clues. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun

Re: [U2] Accessing an https:// server with callHTTP

is, or how to create one that works. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Saturday, October 20, 2012 3:55 PM To: U2 Users List Subject: Re: [U2

Re: [U2] Speeding sort

I was thinking of a similar solution, but the op said that they have lots of disks space, so I am thinking why not just add the field from the other file into the your reporting file. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun

Re: [U2] Accessing an https:// server with callHTTP

I just used this and it worked for me: addCertificate(_PH_\HTTP.CERT, 2, 1, 1, SEC.CONTEXT) David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday

Re: [U2] Selection Suggestions for using UV instead of SQL

David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: Wednesday, October 17, 2012 10:54 AM To: 'U2 Users List' Subject: Re: [U2] Selection Suggestions

Re: [U2] U2-Users Digest, Vol 42, Issue 7

GOTO doesn't return. I guess you're stuck in the US... stuck in the US... stuck in the USSR. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Hammerle Sent: Monday

Re: [U2] Unidata 7.1.16 Multiple Active Select Lists

By definition you can only have one active list at a time in UniData. But you can use list 1-9 in your subroutine (or at TCL) by using the TO and FROM keywords. PERFORM SELECT CUSTOMERS WITH STATE = 'CO' TO 1 LOOP READNEXT CUST.KEY FROM 1 ELSE ... David A. Green (480) 813-1725 DAG Consulting

Re: [U2] Unidata 7.1.16 Multiple Active Select Lists

If you already have an active list then you'll have to save it, then restore it. See READLIST and FORMLIST. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King

Re: [U2] Unidata 7.1.16 Multiple Active Select Lists

One thing to look out for is when using FORMLIST make sure your variable ACTIVE.LIST has stuff in it. Otherwise you get a null active list. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun

Re: [U2] [UV] Nice gotcha

things like LIST CUSTOMERS NAME ADDRESS TO VOC. And without warning boom! They have added some dummy proofing since those days. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf

Re: [U2] [ud] Sub-second delay?

Bob UniData was spelled two ways because one was the company name and one was the product name. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Wyatt Sent: Tuesday

Re: [U2] trimming a list (a test of your ability)

Ah, but try it with := instead of Y = Y: David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Thursday, July 12, 2012 8:56 AM To: U2 Users List Subject

Re: [U2] Unidata Limits

Since it is stored as a string it can be any length. If it is used as a Key or ID of the record you're limited by to 126 characters or whatever your LIMIT command shows. And if you need to do math with it you might have to use string math. David A. Green (480) 813-1725 DAG Consulting

Re: [U2] Regarding: use of I - Descriptor

An alternative method is to create an index on the secondary file then create an I-Desc SUBR to access that index from the primary file. Be sure to setup some COMMON variables to only OPEN the secondary file once. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2

Re: [U2] Regarding: use of I - Descriptor

or you can step through the index to create a list of KEYS to return. Lastly create your I-Descriptor in file A calling the SUBR(GET_KEYS_FROM_INDEX, B, Cust_Nbr) David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users

Re: [U2] Is there any way to tell if I am in an EXECUTE level andCAPTURING is turned on?

How about creating a COMMON variable that the program can set before executing the command with a CAPTURING clause? David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug

Re: [U2] FW: Multivalue Question

on how to store your data. 1. Does it need to be sorted? 2. How do you need to retrieve it? David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: Thursday, June 07

Re: [U2] FW: Multivalue Question

George, The REMOVE will set the MORE.FLAG to 0 when it reaches the last value. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, June 07

Re: [U2] READU vs READ and CRT

How about something like this? This way it doesn't get displayed for the quick updates. function doServerUpdate() { var serverUpdateTimer = setTimeout(showServerUpdateWait(), 5000); ... hideServerUpdateWait(); clearTimeout(serverUpdateTimer); } David A. Green (480) 813-1725 DAG

Re: [U2] User ID of a LOCKED record

John, this might not help Andy, but instead of parsing LIST.READU I would just use GETREADU() in UniData UniBasic. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel

Re: [U2] READU vs READ

Dave, I tend to cringe when I hear sizable records and updating MV fields. These are red flags. If you don't have the luxury of reconstructing the database then make sure you are using the right UniBasic tools like REMOVE and not FOR...NEXT. David A. Green (480) 813-1725 DAG Consulting

Re: [U2] YYMMDD easy way?

I use: YYMMDD = CONVERT( , , OCONV(TODAY, DYMD2)) David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users

Re: [U2] EXIT ; EXIT inside a loop

I think people are missing the original post. A WHILE or UNTIL on the FOR...NEXT doesn't work for this scenario. That is why I suggested the LOOP...UNTIL...DO...REPEAT construct. David A. Green (480) 813-1725 DAG Consulting ___ U2-Users mailing list

Re: [U2] EXIT ; EXIT inside a loop

THEN DONE.FLAG = @TRUE UNTIL DONE.FLAG DO twisted little logic REPEAT NEXT A2 NEXT A1 David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent

Re: [U2] EXIT ; EXIT inside a loop

Will, The DONE.FLAG allows the program to gracefully exit out without having to go thru frivolous loops. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent

Re: [U2] EXIT ; EXIT inside a loop

, and stop processing. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, April 19, 2012 3:24 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2

Re: [U2] EXIT ; EXIT inside a loop

I was referring to the outer loops. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, April 19, 2012 3:40 PM To: u2-users@listserver.u2ug.org

Re: [U2] EXIT ; EXIT inside a loop

Will, Two things. First, good programming practice tells you to define the abort logic once. Sure G # H is simple, but this is just an example it could get quite complex. Second, There are statements before and after the abort situation, and your code doesn't handle it. David A. Green (480

Re: [U2] COMMON Size MisMatch

to a different account. Programmers would make all their Account specific data into a single named common that has the flag to initialize on LOGTO. And keep other cross-account data in common that isn't flagged. Easy. David A. Green (480) 813-1725 DAG Consulting -Original Message- From

Re: [U2] Monitoring a U2 server?

opened it will refresh automatically with the new data. Be sure to have a last update date/time to make sure the system is up and running. You can get fancy and have thresholds that could send out an email or sms. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2

Re: [U2] COMMON Size MisMatch

Yes, but why make all the programmers in the world repeat this same code over and over? It could easily be accomplished by the database engine. It could be a new keyword across MV database systems. And another step in bring the MV worlds closer together. David A. Green (480) 813-1725 DAG

Re: [U2] COMMON Size MisMatch

While this topic is on the table, can we request some kind of COMMON flag or command that would tell the DBM to clear commons on a LOGTO? David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun

Re: [U2] Detecting idle time in INPUT statement.

Don, You should at least optimize the code by just checking a counter and not messing with TIME(). Your NAP command automatically takes care of the amount of time spent in each loop. You just need to count how many NAPs it takes to equal the amount of wait time you wish to have. David A. Green

Re: [U2] keeping track of opened files

Look at SYSTEM(50) David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ed Clark Sent: Monday, March 05, 2012 11:42 AM To: U2 Users List Subject: [U2] keeping track of opened

Re: [U2] keeping track of opened files

Unless, of course, you use a phantom process to do all of your I/O. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, March 05, 2012 12:09 PM

Re: [U2] Including Code - A Best Practice?

. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: Tuesday, February 07, 2012 4:05 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Including

Re: [U2] Including Code - A Best Practice?

emails that talked about this very thing. I know you need something like -Z2 -D. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: Baker Hughes [mailto:baker.hug...@mouser.com] Sent: Wednesday, February 08, 2012 8:15 AM To: 'dgr...@dagconsulting.com'; 'U2 Users List

Re: [U2] Building an Excel File

I have to say amen to Tony's comments. Why try and reinvent the wheel when there is a utility already written? Or throw out some kludgy solution when a native one can be found? David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Passing by Value

I always try to use meaningful variable names. CUSTOMER.CNT = DCOUNT(CUSTOMERS, @VM) FOR CUSTOMER.PTR = 1 TO CUSTOMER.CNT CUSTOMER = CUSTOMER1, CUSTOMER.PTR . . . NEXT CUSTOMER.PTR David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun

Re: [U2] Date comparison

Just adding the advice to make sure all your date dictionaries have Right Justified formats. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Tuesday

Re: [U2] Brilliant? or not?

Are you trying to emulate C? SMAX = (S1 S2) ? S1 : S2; David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, January 13, 2012 10:42 AM To: u2-users

Re: [U2] Corrupted compiled code

Maybe you could save off the compiled program before recompiling. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Wednesday, December 21, 2011 3:12 PM

Re: [U2] Corrupted compiled code

ASSIGN will also modify SYSTEM(2). Although I can't seem to find the documentation for it. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton Sent: Wednesday

Re: [U2] Show.Timestamp

Will, I would change the CRT to PRINT. This way if you are running it to a log file the output will follow. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson

Re: [U2] TAB.TO.UNIVERSE

format. Back in the day this was necessary for UniObjects to work and so I have just always had it as the last parameter. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf

Re: [U2] End of Month date routine

YEAR = OCONV(PASS.DATE, DY) TEST = ICONV(Feb 29 :YEAR, D) LEAP.YEAR = (STATUS() = 0) David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Tuesday

Re: [U2] End of Month date routine

Try this routine: SUBROUTINE RPT_DATES(OUT.DATES, IN.DATES, IN.DATE.TYPE, FLAG) * DAG_DATES - By David A. Green -- 1Jun05 * www.dagconsulting.com * * Calculate dates and date ranges * ** Inputs: *IN.DATES - Single or Multivalued List of Dates

Re: [U2] End of Month date routine

Who wants to take each of the Leap Year calculations and put them into different subroutines and loop 100K times and see which one is faster using profiling? David A. Green (480) 813-1725 DAG Consulting ___ U2-Users mailing list U2-Users

Re: [U2] End of Month date routine

. But this is a good example of working together to enhance the U2 products, now we all have the same Leap Year calculation and those that were using the MOD(YEAR, 4) method should now use this method everywhere as to avoid data corruption. David A. Green (480) 813-1725 DAG Consulting -Original Message

Re: [U2] Avoiding deadly embraces

with no need to lock the record that the shipping department will need to update to do its job. David A. Green (480) 813-1725 DAG Consulting ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Universe error message 5000

Looks like Chinese year of the ... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Wednesday, August 17, 2011 5:36 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe error message

Re: [U2] uniobjects question

Doug if you need to satisfy an input, you have to write a wrapper that takes the subroutine inputs and converts them into DATA statements, then you call your program with the INPUTS. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun

Re: [U2] CONV MCU on indexed field?

Chris, I would create a new i-descriptor dictionary called UNAME. The formula would do the uppercase logic like: OCONV(NAME, MCU) or UPCASE(NAME). Then build your index on UNAME. And use UNAME in your SELECT statements for a filter and display NAME for output. David A. Green (480) 813-1725 DAG

Re: [U2] Simple FMT question

Works for me on UniData 6.1 :SPOOL BP DAG.TEST -OT PROGRAM DAG.TEST * X = 1 X = FMT(X, 4\0R) PRINT X END :DAG.TEST 0001 : David

Re: [U2] Simple FMT question

Bob, Format will Truncate or add a Text Mark at any overflow. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Woodward Sent: Friday, July 08, 2011 12:17 PM To: u2

Re: [U2] Conversion Documentation

FORMAT() David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jjuser ud2 Sent: Wednesday, June 15, 2011 12:49 PM To: U2 Users List Subject: [U2] Conversion Documentation

Re: [U2] Uniquery

Try: X.LIST.STMT:= \HEADER AR Invoices with customer last name \:V.JS.VAR1:\and customer first name John.\ David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho

Re: [U2] [UV] Emulate SQL MAX() function at TCL

that point. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Thursday, May 26, 2011 11:04 PM To: U2 Users List Subject: [U2] [UV] Emulate SQL MAX

Re: [U2] Multi char delimiter in DICT item

Bob is right. Lets enhance the FIELD function to accept a string delimiter and not just a single character. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Woodward

[U2] Does anyone us Magento as a front end

Does anyone us Magento as a front end web development tools with UniData? What kind of path do you use? Client Web Server SQL Server UniData Or Client Web Server UniData David A. Green (480) 813-1725 DAG Consulting ___ U2-Users

Re: [U2] Very Weird Trigger Behavior

I would change the SELECT to an XLATE command. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jonathanm Sent: Thursday, April 21, 2011 8:03 AM To: u2-users

  1   2   3   >