RE: [UD] Union Query
In that case, I'm sorry to say, there is no way to logically do what you're asking with UD. You could physically do it by creating a temp file and copy all records from both files to it. But that would be a great deal of overhead for a query. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: Friday, April 30, 2004 11:24 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query No, a record ID in one file will not exist in the other file. -Original Message- From: Jeff Schasny [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 11:14 AM To: U2 Users Discussion List Subject: RE: [UD] Union Query TCL (or whatever your flavor calls the queery language) is a single file oriented language. No joins. You would need to create TRANS items in the dictionary of one of the files pointing to the other. Are the record ID's in both files the same for a given record that you would want to relate? -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 8:05 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query I understand how Unibasic could handle a list that has been merged, but how would you do a Uniquery statement? for example: SELECT ORDER.FILE WITH DATE 1/1/2004 SAVE-LIST LIST1 SELECT ORDER.FILE.OTHER WITH DATE 1/1/2004 SAVE-LIST LIST2 GET-LIST LIST1 TO 1 GET-LIST LIST2 TO 2 MERGE.LIST 1 UNION 2 SAVE-LIST LIST.ALL GET-LIST LIST.ALL What do you enter here? LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP or LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP How would a virtual dictionary know which file to get the NAME ADDRESS CITY and STATE from? Thanks. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Baakkonen, Rodney [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 10:27 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query You could use MERGER.LIST to get one list which is a UNION of two separate selects of each file. But you would not know which file the key was from when you were done. But Unibasic or Virtual dictionary items could take the merged list and produce what you are looking for. -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 9:13 AM To: 'U2 Users Discussion List' Subject: [UD] Union Query Hello, Does anyone know of a way to do the equivalent of a UNION query (really a LIST or SORT) on 2 or more different UniData files? I have 2 files in separate accounts that are structured the same. I want to do something like: SORT ORDER.FILE AND ORDER.FILE.OTHER WITH DATE 01/01/2004 NAME ADDRESS CITY STATE ZIP Thanks in advance. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help on uv syntax, please
To do what you are saying I would use the RAISE function. NEWARRAY = RAISE(OLDARRAY) This would change all @SVM to @VM. Of course you would have to be kind of careful with it as it would also change all @VM to @AM. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Tuesday, April 27, 2004 12:48 PM To: [EMAIL PROTECTED] Subject: Help on uv syntax, please Hi. Anybody got the syntax for universe for changing one string to another in an array? Mostly I use it for changing a subvalued field into a multivalued one. In Unidata, for example, its NEWARRAY = CHANGE(OLDARRAY,SVM,VM) I'm looking for a similar function in universe. (p.s. if you could e.mail me directly -- I am on digest mode and won't get the answer all day - thanks!) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How far can U2 scale?
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn M. Wolthuis At what point in the life of application software would it be so large that you could not (or would not want to) support it with your existing UniData or UniVerse database? Is there a point where you would be better served by DB2 or Oracle, for example due to the scale you are working with? I hear people talk about moving way from U2 in order to do ODBC and use standard industry tools (and most find that the grass is not greener for those purposes), but I don't hear about switching because of running into scaling issues. However, we sometimes think of PICK as addressing small-to-mid size businesses and RDBMS folks sometimes think of their products as scaling the best. So, what's the cut-off for U2? Thanks. --dawn Dawn M. Wolthuis Tincat Group, Inc. Dawn, Maybe there is a theoretical limit but I've yet to see it reached and don't really know where it is. I've been involved with UD/UV systems with thousand of simultaneous users. Sometimes we had to get creative when there were time constraints for jobs (multi-threading and/or distributed processing) but I've not seen a situation that could not be handle by our beloved multi-valued systems. My US$0.02, Gordon Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: What client platform do YOU use (Parallel to GUI thread)
[snip] I wonder what the REAL numbers are - I mean theory is one thing, but how do the numbers stack up in the real world? How many people are there that actually do use, or WANT to use (I'm talking management want here, not the gee, if I had my way kind of thing) non-windows platforms on the desktop ?. [snip] At this current job we are virtually a total MS shop on the desktop. That is to say that we have around 3300 Windows machines and 4 (count 'em 4) Macs. The Macs are used by the graphic art department. The last company I worked for (3 years ago) was an aluminum smelter and was total MS. However my previous employer (7 years ago) which was based in Portland, Oregon had 90% Macs and 10% MS Windows. The accounting department had the Windows machines. Everyone else (about 200 or so) had Macs. In fact we did all of our UD/SB+ development on Macs. My understanding is that they still have that setup at the headquarters but UD/SB+ was replaced with a system utilizing Oracle. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: What client platform do YOU use (Parallel to GUI thread)
Are you saying UD/SB+ runs *natively* on Macs? Or that UD has an OS layer for Macs? Or that you used Accuterm/Wintegrate to talk to some kind of server ? Will [snip] No no, UD and SB+ were running on Sun Boxes. The Macs were desktop clients. We ran an emulator from Carnation Software. The actual name escapes me right now. Sorry for the confusion, Gordon Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: The future of U2
I don't really care what the backend DB engine is as long as I can use my favorite set of tools to develop applications. But if a change to DB2 or whatever is going to force me to severly change the way I operate, then I'd see that as a bad thing. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Ad - Programmer/Analyst
Nancy! Please contact me offline. Sorry to the group for the intrusion. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nancy Berube Sent: Wednesday, March 24, 2004 10:36 AM To: [EMAIL PROTECTED] Subject: Ad - Programmer/Analyst Masonite International - US headquarters in Tampa, Fl is seeking a skilled professional that can design, develop and support Pick programs in a Unix environment. This requires a talented flexible programmer that can work with a team using independent judgment and interpersonal skills. Major Duties and Responsibilities: * Enhance existing Pick Basic software applications on a Unix based server. * Masterpack experience preferred but not required * Must have at least 2 years experience with SB+ and PICK * EDI /GIS/Gentran experience preferred but not required This is a full time position located in Tampa, FL. We offer competitive salaries and a matching 401(k) plan. Send your resume and salary history to Nancy Berube Masonite International Tampa Division IT /EC Department Fax : 813-261-3582 Email : [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Strange results from I Descriptor
UV 10.0.8 I am trying to create an I-Descriptor that calls a subroutine. The subroutine does a select on another file. When the select is executed I get this error: Non-SQL re-entrant query calls are not allowed. I'm clueless as to what is wrong. Any hints would be greatly appreciated. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Pick AP-Pro Discs
No, it's a newsgroup list. Go to Google and get into the groups. You'll find it there. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Friday, March 05, 2004 10:02 AM To: U2 Users Discussion List Subject: Re: Pick AP-Pro Discs Is that a URL or how do i get into it. thanks I assume you've asked the question on comp.databases.pick? If not, you may get more joy there. Brian -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Ever wondered how something works...
On our UV 10.0.8 on a Sun box there is no L VOC entry. LD is someones shortcut to LIST DICT. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik Sent: Wednesday, March 03, 2004 9:34 PM To: U2 list (E-mail) Subject: [UV] Ever wondered how something works... One day, I stumbled across an interesting behavior; at TCL, if I type 'L', it results in my current SELECT list being cleared. You get an error message, but it does not seem to hurt anything. This is great, because I hate typing in CLEARSELECT. But ever since, I've been wondering what it's really doing. Turns out that 'L' is one of only two similar VOC entries, the other being 'LD'. It looks like this: 0001: V 0002: L 0003: PR The error message you get reads: Unable to create new process. Will try again. Create Process failed (2). This is on NT. IIRC, on unix the message is different. Anybody know what this is doing, or if it is safe? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Common Universe/Unidata files
Unfortunately, there is no hashed file that can be common to both UniVerse and UniData. You may want to explore some sort of duplicate file with 2 way updates. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Randal LeBlanc Sent: Wednesday, February 25, 2004 3:13 PM To: U2 Users Discussion List Subject: Re: Common Universe/Unidata files Rich, Thanks for the reply. Yes, that is a possibility. However, the file will be very large (over 500,000 records) and I am concerned about performance with an aix directory structure. -Original Message- From: Richard A. Wilson [EMAIL PROTECTED] Sent: Feb 25, 2004 12:08 PM To: U2 Users Discussion List [EMAIL PROTECTED] Subject: Re: Common Universe/Unidata files without getting into odbc etc. is record locking required control file kind of data can you set the file up as type 19 under universe and dir under unidata Rich Randal LeBlanc wrote: We have separate applications running on Universe and Unidata. The apps run on separate aix servers. We would like to create a common file that can be accessed by both applications but are not sure of the best approach to take. Any suggestions?? Randal LeBlanc JCL Associates, Inc. [EMAIL PROTECTED] www.jclinc.com -- Richard A. Wilson Lakeside Systems -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Randal LeBlanc JCL Associates, Inc. [EMAIL PROTECTED] www.jclinc.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Format Text in Output Data File
Title: Message By definition a .csv file is plain text. That means no formatting. Best thing you could do is to setup a macro in your spreadsheet to do the formatting you want after loading and parsing your .csv. HTH, Gordon Gordon J. GlorfieldSr. Systems AnalystMAMSI301-360-8839 -Original Message-From: Simon Adams [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 04, 2004 5:28 PMTo: [EMAIL PROTECTED]Subject: Format Text in Output Data File I am trying to format text outputted to a csv data file. I'm building a string of data and writing it out to a data file with 'comma' separation, line by line, and naming the outputted file with a ".csv" extension. Is there a way to format the text/data line(s), as "bold" or "italics" or "colour" etc. without using a third-party software ? Cheers, Simon. Australia.*This e-mail, including any attachments to it, may contain confidential and/or personal information.If you have received this e-mail in error, you must not copy, distribute, or disclose it, use or take any action based on the information contained within it.Please notify the sender immediately by return e-mail of the error and then delete the original e-mail.The information contained within this e-mail may be solely the opinion of the sender and may not necessarily reflect the position, beliefs or opinions of Salmat on any issue.This email has been swept for the presence of computer viruses known to Salmat's anti-virus systems.For more information, visit our website at www.salmat.com.au.* Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users