Re: [U2] MS-SQL Question

FROM SomeTable ) as DerivedTable WHERE DerivedTable.PID = something Don Verhagen www.REMOVEemjackTHIS.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, December 28, 2011 3:38 PM

Re: [U2] Testing . . .

4 ... 5 ... 6 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Thursday, November 24, 2011 8:34 AM To: U2 Users List Subject: [U2] Testing . . . 1 ... 2 ... 3

Re: [U2] Opinions on Cache

. After the comments from this forum, I am going to request an evaluation version from Intersystems. Again, I just wanted to thank all for their comments, both online and offline. Thanks, Don Verhagen Emjack Group LLC. u2-us...@southeast-florida.com -Original Message- Various

[U2] Opinions on Cache

related to Cache, online or offline. P.S. I have been on this list for at least a decade, please don't hold that against me. =) Don Verhagen Emjack Group, LLC. Email: u2-us...@southeast-florida.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org

[U2] Unidata/SBClient/SBServer Pricing - USA

for the above. Please feel free to contact me OFFLINE as I don't want to make your pricing info public. =) Thanks, Don Verhagen (donrem...@thissoutheast-florida.com) (please make sure to remove the rem...@this from the email address). ___ U2-Users

Re: [U2] More questions on indexing

In Unidata (v6.x) you can issue the command BUILD.INDEX MYFILE ALL. With the KEYWORD ALL it's builds/rebuilds all the indexes that have been created on the file. I would hate to have to remember that INDEX_1 is say, Customer Name, verus a dictionary named CUST_NAME. I would agree with others, I

Re: [U2] Simple Export to Excel

-florida.com) south east (dash) florida dot com Don Verhagen (Plugging along in SQL and .Net where a simple generic empty validation ain't so simple!) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent

Re: [U2] [u2u] UV on Windows question

My Outlook Express 2003 directs replies directly back to the list. -- Don V -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: Monday, June 01, 2009 6:51 PM To: u2-users@listserver.u2ug.org

RE: [U2] Leaving U2 World to the Dark Side (SQL)

that I have seen less written about and worse even less thought out in the application(s) that I'm having to deal with. Thanks, Don Verhagen -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Sunday

[U2] Leaving U2 World to the Dark Side (SQL)

and evaluate the use MSSQL in a true business application that I myself have built on a U2 platform in a previous time. While this doesn't exclusively rule out U2 in the future, for now, I'll be in SQL-land. Just wanted give a heads up to those that know me here. Don Verhagen Application Development

RE: [U2] Green Software - Green Business

a green change if it *cost you more* money than not going green. And as a side note, I hate green, the movement, the color. Can't we go blue? The sky is blue, so is the ocean, so is the porn..., damn it, blue is out. Don Verhagen Commuting 60 miles a day in 5.7L Hemi SUV with the a/c on high

Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD

John, Try using lower case list, this will force ECLTYPE U (Unidata) flavor. Don Verhagen - Original Message - From: John Kent [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, June 03, 2008 6:41 PM Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype

[U2] OT: Textpad Syntax File for Unidata

Group, I was wondering if any else out there uses a text editor TEXTPAD and has already created a syntax file for it. If so, please email offline or link. Thanks, Don Verhagen --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Time Travel

I own the domain. It's not hosted by myself here in the frigid 82F degree winter. Donald Verhagen ([EMAIL PROTECTED]) Chief Information Officer - Tandem Voice: 561.226.8261 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Monday,

RE: [U2] Time Travel

Let me rephrase that. I donated the funds for the domain name and registered it. U2UG owns the domain in whole. I love whois..I should have paid for that privacy thingie too. Donald Verhagen ([EMAIL PROTECTED]) Chief Information Officer - Tandem Voice: 561.226.8261 -Original

[U2] [UD] Unidata 7.1 / HPUX 11.11i

I have a question for the group. Mainly because I'm too lazy to go to the IBM product matrix and also wondering if anyone else is running this configuration. I was told by people inside my organization that UD 7.1.x only runs on HPUX 11.x in 64-bit mode and I find that hard to believe.

RE: [U2] [UD] Union Query

I'd have to second David on this. I wish in Unibasic there was a program/function to create temporary user files that get cleaned-up on exit and let UD/UV determine the area to create these on the file system. Donald Verhagen Never clean my room when I was younger either -- Donald Verhagen

RE: [U2] Help with File Pointers

So Simple, yet effective. Regards, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 3/15/2007 at 10:52 am, in message

Re: [U2] Help with File Pointers

Susan, I noticed that err..that other software...had problems with relative paths. With SB Installed (and maybe without) you can get the base path of the ACCOUNT that the VOC from DMACCOUNTS1. You can then work with what the VOC entry from the path ACCOUNT in the account. I think you're

Re: [U2] Redback on Windows 2003 Server

The first Redback that installs correctly on Windows 2003 is 4.2.5, but if you're upgrading from 3.2.3, you might as well upgraded to the newest 4.3. 3.2.3 will not work on WIn2003 Server. Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing

Re: [U2] Program Mgmt System

Barry, So Susan J (list member) doesn't have to toot her own horn, I will. We have been using PRC Revision Control Software since 2001 and could be happier with it. (www.sjplus.com) Handles programs, data items (if desired), etc... Thanks, -- Donald Verhagen Application Development

Re: [U2] Program Mgmt System

That was suppose to say Couldn't be happier with it. Sorry, I'm not very good at this plugging stuff. Thanks, Don V -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice

Re: [U2] [UV] OpenXMLData error

Jason, Unless it's a typo, you quoted the TEST_XML_HANDEL variable in your OpenXMLData statement Should by STATUS = OpenXMLData(TEST_XML_HANDEL,.) not OpenXMLData(TEST_XML_HANDEL,...) Don V On 11/17/2006 at 7:11 pm, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: Hi guys. I

Re: [U2] Sort / Select keyword

John, I think the keyword is EXPLAIN. I don't have a copy of Universe nearby. Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone:

[U2] UV 10.2 Data encryption/ Unidata Soon?

Steve, Are they plans to include this in a Unidata release anytime soon? I have a few hundred thousand SSN numbers that are feeling a bit unprotected in the big bad cold world of ours. =) Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions,

RE: [U2] UniVerse Personal Editions

It says right in this email below: - Original Message - From: Leroy Dreyfuss [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, August 29, 2006 4:33 PM Subject: [U2] UniVerse Personal Editions All, Because the current

[U2] VAR[1] was Encrypt...

I don't agree that RESULT[1] is any clearer/cleaner than RESULT[LEN(RESULT),1]. Does the [1] represent the FIRST character or the LAST character? I will agree that it's shorter to write. =) -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc.

RE: [U2] Hosted UniData

stole fuel). We use to have it in our own site with generators, the servers were up, but no one could connect because the telecom lines were down. David W, If you want some pricing info call me direct, you know the numbers. Thanks, Don Verhagen Tandem Staffing Solutions, Inc. On 8/9/2006 at 1:40 pm

RE: [U2] ICONV 'DW' [was:UniVerse Internal Date Blackout]

1:00AM EDT is converted to Monday June 12th 10:00PM PDT. Here the date is affected as well as the time. And it *is* an ISO standard, so it would be nice if it was supported. Yeah yeah, I wrote a function. =) Don Verhagen Cheers, Stuart

Re: [U2] Phantom Question

Are you closing the printer. The printer is automatically closed once the program ends. PRINTER ON PRINTER OFF PRINTER CLOSE Otherwise it's held in the print buffer until the program ends. Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing

RE: [U2] TIME

I have to agree. We are in 4 times zones in the US and 2 Daylight Savings Time (Arizona and parts of Indiana do not observe DST). We store all our DATES and times in EST. You have to always include the DATE when dealing with time because 04/04/2006 12:30AM PST is 04/03/2006 11:30PM MST (notice

Re: [U2] check signature [Possible AD]

We currently print about 500,000 checks a year (past 6 years) using a set of programs (Unibasic) that I wrote that will/can print the following: 1) Signature (Black White Tiff) or signature lines if above a pre-signed limit 2) The MICR Line (Can either use a secured DIMM chip or not) 3) Any

[U2] [Redback] Upgrading from 4.2.5 to 4.2.6

I'm going to be upgrading my Redback Server and Gateway from 4.2.5 to 4.2.6 and I have one question about the Gateway. Currently I have my web server (open to world) on ServerA and I have the Redback Server on a server on the inside (ServerB). I wanted to do a 2 step Upgrade. That is upgrade the

Re: [U2] Unidata XML

I found this out the hard way also. I believe the documentation is wrong (for Unidata). Thanks, -- * Please NOTE NEW ADDRESS AND TELELPHONE Numbers * -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450

Re: [U2] Creating a Folder

CREATE.FILE DIR NEW.BP You need the Keyword DIR (For directory/folder) in the CREATE.FILE command. It basically creates the DIRECTORY NEW.BP and the DICTIONARY D_NEW.BP (As a file at the same level as the directory, not IN the directory) The VOC entry should look something like: 1] DIR 2]

RE: [U2] Unidata on XP Lap Top

* Please NOTE NEW ADDRESS AND TELELPHONE Numbers * -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 [EMAIL PROTECTED] 3:39 pm

Re: [U2] making a .csv file into an .xls file?

Or you can use a PERL script to take a File that is delimited by @AM (rows) and @VM (columns) and create an XLS binary file. I currently do this on an HPUX 11.x running Unidata 6.X. Did I mention it was free? Email me offline if you would like details. Thanks, * Please NOTE NEW ADDRESS AND

RE: [U2] UniVerse - file importation

If you email offline (see email below) I will send you a DBF converter I have written in Unidata (surely easily converted to Universe) that can read the DBF file DIRECTLY in it's binary format and create a unidata file (complete with dictionaries from the DBF structure) . Thanks, Don Verhagen

Re: [U2] NFA and Triggers

Wendy, We use NFA pointers on our web server, so basically the kiddies can't get all of our production files [grin]. Triggers get executed on the server where the files live (aka not the remote server). However, you will not be the Enviroment of the account, it's just Unidata running. We for

[U2] [RANT] HTH

CTDSL = CHANGE THE DAMN SUBJECT LINE. Re: [U2]UD Login User There we more postings under the original subject line related to HTH than the OP (Original Post). * Please NOTE NEW Telephone Number * -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing

Re: [U2] [Redback] multi-valued data displays strangely

Adrian. Using RBOScope, I don't think so. The RBOScope asp/uv/ud code Magically converts new lines characters into Value Marks, this is, as I believe also, useful when testing and have to enter multivalue data into a RBO property. Using a textbox outside of RBOScope does not exhibit

Re: [U2] Spam/Virus?

Return Your IT badge to lady at the front desk, you're being phished. [EMAIL PROTECTED] 4:31:23 PM 06/03/2005 I just received an email from the admissions server at Hamilton College in New York. Any of you people on the list? It said my email account would be closed if I didn't fill out a

Re: [U2] Finding last day of month

* User Supplied ISO Date UserDate= '20040203' UserDateYear= UserDate[1,4] + 0 UserDateMonth = UserDate[5,2] + 0 UserDateDay = UserDate[7,2] + 0 * First Day Of The Next Month NextMonthYear = UserDateYear + (IF (UserDateMonth + 1) 12 THEN 1 ELSE 0) NextMonthMonth = (IF

RE: [U2] [UV] uniadmin without having to be in administrators group?

If you're on *nix platform you may be able to use SUDO ( http://www.sudo.ws/ ) that allows you to run certain commands as that may require root (or root-like access). I think many of the UVADMIN (or UDAMIN) commands require root or admin (WINDOWS) access to run O/S commands that require that

RE: [U2] Redback Startup

Or you can separate out the data layer from the presentation layer. Programmers - Respsonsible for Redback object properties (fields) and methods (databasic programs) REAL Web Designers - Responsible for website presentation. Redback allows web designers to be web designers and programmers,

Re: [U2] Conversion to Windoze % vs ? character

You cannot use ? in a filename on Windoze (Same as *) that you may have used on Unix. I know my FTP client switches any * in filenames (record id in a directory file) to @ when I ftp from UNIX to Windows. Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED]

Re: [U2] UniBasic CRLF over NFS mount

If you're using FTP to do the transfer from UNIX to DOS (which you say you are) then make the the FTP Transfer mode is ASCII, it usually defaults to BINARY (BIN). Most FTP clients will automatically convert CR to CRLF when transfering in ASCII mode. ASSIGN 1 to SYSTEM(1017) In Unidata the

Re: [U2][UD] Using Environmental Variables in VOC...

It works on UNIX, however, you could have a program get the environment variable and write out the voc with the path information. UDTBIN_PATH = GETENV(UDTBIN) SAVEDLOG_PATH = UDTBIN_PATH:saved_logs VOC.REC= DIR VOC.REC2 = SAVEDLOG_PATH VOC.REC3 = D_BP It would seem unnecessary, but hey

Re: [U2][UD] Using Environmental Variables in VOC...

For the benefit of the group (I emailed David offline). In windows it's the @ sign not $ sign for environment variables. ie. 002: @UDTBIN\saved_logs Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue,

Re: [U2] [UD] Precision

Maybe they are paid semi-monthly (24 periods) rather than Bi-weekly (26 periods). -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone:

[U2] [UD] XML Parse/Open/ReadXMLData

I'm having a problem with creating an extraction file in Unidata 6.0.9 on HPUX 11.11i. It's not writting to the correct attribute as defined by the dictionary item named in field. Simple XML Doc(test.xml): root node1Node1/node1 node2Node2/node2 node3Node3/node3 /root - Extraction

Re: [U2] [UV] Initialization Error

The Not a typewriter is indictative of the a term type not being set correctly or blank. On all our unix cron jobs a wrapper functions sets these enviroment variables since cron only sets a few enviroments by default. Thanks, -- Donald Verhagen Application Development Manager

Re: [U2] thoroughbred basic

Throughbred basic as far as I know isn't Pick. The last time I saw this was with a software package called Payplus. -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice

RE: [U2] Editors [TEXTPAD]

Speaking of Textpad. I use this. Does anyone have a syntax file for UD using Textpad? Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592

Re: [U2] RedBack # of responders configuration

A better resource may be: rbsolutions http://groups.yahoo.com/group/rbsolutions/ Don [EMAIL PROTECTED] 6:15:12 AM 09/24/2004 Hello there, I know this is the U2 mailing list and sorry for sending a RedBack related message but figured someone out there may have the answers. Recently, I've

OT: [U2] spammed

-- [EMAIL PROTECTED] 12:08:42 PM 09/21/2004 -- It's illegal to send UBE (unsolicited bulk e-mail) here in the states, but that doesn't stop people from finding loopholes in the FCC regs or spoofing source addresses and IPs. If the post office didn't track where mail came from/went, you could put

RE: [U2] UVODBC first query

I know this happens even with TELNET on Window Servers. It has something do with the first time it looks up a username in the doman and then it caches the the user tree (probably wrong term) of all the users. So each login after than does NOT have to retrieve a list of users. Does that make sense?

Re: [U2] Pyramid HR

It's HRPyramind. We have use this since 1998 for our core inhouse payroll about (200-600 employees) and we used it briefly for our PEO business but we sold that division off. I have nothing but praise for the software and the company and it's well supported. It's put out by a company FW Davison.

WebEX Recommendation was [U2] Univere Login Security

We use WebEx on our HPUX machines to allow HP techs in to help us with supporting our servers. I whole heartedly (sp.?) endorse it over netmeeting. -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210

RE: [U2] Universe Database Hang

We had this problem but it was related to Vertias Replication software. Are you by chance running Vertias on HPUX? Sorry deleted the original post if that had the OS info in it. Don Verhagen Tandem Staffing Solutions, Inc. [EMAIL PROTECTED] 11:56:10 AM 06/21/2004 Ang Suan Yong wrote

RE: [U2] UniBasic Performance Question

EQU V.SEC.SYNONYM TO COURSE.SECTIONS.REC.TABLEI.COURSE.SECTIONS,15 PRINT.VAR = V.SEC.SYNONYM verus PRINT.VAR = COURSE.SECTIONS.REC.TABLEI.COURSE.SECTIONS,15 I'm not sure but I think, in this case, elimating the EQUATE would be less keystrokes. Don [EMAIL PROTECTED] 4:03:24 PM 05/18/2004