Re: [U2] Universe - UniData - Pick/D3 Application DeveloperAvailable -SoCal USA
It means that I am using my current employer's email system to post the availability and that the employer is supportive of it. My employer also has Master Service Agreements with its customers that often contain restrictions on hiring me away. My employer, cognizant of the current economy, will allow me to talk even to current customers without the prospect of litigation or requiring the posting of an agency fee. Marvin R. Fisher Technical Resource Group A Pipeline Group Company 2850 Red Hill Ave. Suite 110 Santa Ana, CA 92705 Tel (949) 296-8380 ext. 620 Fax (949) 756-0029 Pipeline Software Statement: This email message is confidential and may be legally privileged. The contents contained within, including any attached files, are intended solely for the addressee(s). Access by anyone other than the addressee(s) is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action, taken or not taken, in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email message in error, please contact the sender. Any views expressed within are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Pipeline-Software, Inc., Santa Ana, CA. (The contents of this email message have been scanned for the presence of computer viruses.) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen E. Elwood Sent: Monday, November 23, 2009 7:48 PM To: U2 Users List Subject: Re: [U2] Universe - UniData - Pick/D3 Application DeveloperAvailable -SoCal USA And *what* does that mean in english? Not that I'm interested, but it just seems there must be an easier way of saying whatever it is you just said -Original Message----- Marvin R. Fisher ...who has stated that any non-solicitation clause in any existing Master Services Agreement pertaining to the poster will not be pursued. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Universe - UniData - Pick/D3 Application Developer Available - SoCal USA
This posting has the approval of the CEO of Pipeline Group who has stated that any non-solicitation clause in any existing Master Services Agreement pertaining to the poster will not be pursued. Poster is located in Orange County, California. While contact using the information in the signature block is allowed, preferred methods of contact are contained within the link below. http://home.pacbell.net/fishermr/resume.html Marvin R. Fisher Technical Resource Group A Pipeline Group Company 2850 Red Hill Ave. Suite 110 Santa Ana, CA 92705 Tel (949) 296-8380 ext. 620 Fax (949) 756-0029 Pipeline Software Statement: This email message is confidential and may be legally privileged. The contents contained within, including any attached files, are intended solely for the addressee(s). Access by anyone other than the addressee(s) is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action, taken or not taken, in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email message in error, please contact the sender. Any views expressed within are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Pipeline-Software, Inc., Santa Ana, CA. (The contents of this email message have been scanned for the presence of computer viruses.) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] Unidata 6.1 Opening a File Dictionary issue
Great - I almost posted another message mentioning the line number might be wrong in the error message and should be pointing to the line cited. Wouldn't be the first time that happened. Sent from my Windows Mobile. phone. -Original Message- From: Jeff Ritchie Sent: Thursday, December 18, 2008 7:49 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6.1 Opening a File Dictionary issue Marvin, That did the trick, issue with the filename extract was causing mayhem Jeff -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Marvin R. Fisher Sent: Friday, 19 December 2008 11:51 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6.1 Opening a File Dictionary issue Don't know why that would error as assigning a file name to a variable is often used, however your error message in line 35 should end with D.KEY as D.FILE is a file handle. Marvin R. Fisher Technical Resource Group A Pipeline Group Company 2850 Red Hill Ave. Suite 110 Santa Ana, CA 92705 Tel (949) 296-8380 ext. 620 Fax (949) 756-0029 Pipeline Software Statement: This email message is confidential and may be legally privileged. The contents contained within, including any attached files, are intended solely for the addressee(s). Access by anyone other than the addressee(s) is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action, taken or not taken, in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email message in error, please contact the sender. Any views expressed within are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Pipeline-Software, Inc., Santa Ana, CA. (The contents of this email message have been scanned for the presence of computer viruses.) -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Ritchie Sent: Thursday, December 18, 2008 4:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata 6.1 Opening a File Dictionary issue Hi all, Have some weirdness at the edge of town going down here 0032D.KEY = "BANKS" 0033* 0034OPEN 'DICT', D.KEY TO D.FILE ELSE 0035 PRINT "UNABLE TO OPEN DICTIONARY ":D.FILE 0036 STOP 0037END Am receiving an unassigned error on line 34 with a subsequent read failure. If I replace D.KEY with "BANKS" it works fine. This is part of a utility that is meant to loop through every file on the system checking dictionaries. Cheers, thanks in advance, and hope the xmas period is hectic Jeff --- 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/
RE: [U2] Unidata 6.1 Opening a File Dictionary issue
Don't know why that would error as assigning a file name to a variable is often used, however your error message in line 35 should end with D.KEY as D.FILE is a file handle. Marvin R. Fisher Technical Resource Group A Pipeline Group Company 2850 Red Hill Ave. Suite 110 Santa Ana, CA 92705 Tel (949) 296-8380 ext. 620 Fax (949) 756-0029 Pipeline Software Statement: This email message is confidential and may be legally privileged. The contents contained within, including any attached files, are intended solely for the addressee(s). Access by anyone other than the addressee(s) is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action, taken or not taken, in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email message in error, please contact the sender. Any views expressed within are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Pipeline-Software, Inc., Santa Ana, CA. (The contents of this email message have been scanned for the presence of computer viruses.) -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Ritchie Sent: Thursday, December 18, 2008 4:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata 6.1 Opening a File Dictionary issue Hi all, Have some weirdness at the edge of town going down here 0032D.KEY = "BANKS" 0033* 0034OPEN 'DICT', D.KEY TO D.FILE ELSE 0035 PRINT "UNABLE TO OPEN DICTIONARY ":D.FILE 0036 STOP 0037END Am receiving an unassigned error on line 34 with a subsequent read failure. If I replace D.KEY with "BANKS" it works fine. This is part of a utility that is meant to loop through every file on the system checking dictionaries. Cheers, thanks in advance, and hope the xmas period is hectic Jeff --- 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] Speeding up processing through large dynamic table
I think a lot of us need to brush up on how remove works. Marvin R. Fisher Technical Resource Group A Pipeline Group Company 2850 Red Hill Ave. Suite 110 Santa Ana, CA 92705 Tel (949) 296-8380 ext. 620 Fax (949) 756-0029 Pipeline Software Statement: This email message is confidential and may be legally privileged. The contents contained within, including any attached files, are intended solely for the addressee(s). Access by anyone other than the addressee(s) is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action, taken or not taken, in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email message in error, please contact the sender. Any views expressed within are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Pipeline-Software, Inc., Santa Ana, CA. (The contents of this email message have been scanned for the presence of computer viruses.) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: Monday, November 17, 2008 12:52 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Speeding up processing through large dynamic table And unless there is a need to work with attributes rather than values, eliminate the SWAP to get: CUST.NUM = IN.LINE<1,1> CUST.DESC = IN.LINE<1,2> > From: Joshua Gallant > Try something like this instead: > > LOOP > REMOVE IN.LINE FROM IN.TAB SETTING MARK > SWAP @VM WITH @AM IN IN.LINE > CUST.NUM = IN.LINE<1> > CUST.DESC = IN.LINE<2> > WHILE MARK DO > REPEAT > > That will keep track of where you were in the array and pick up where > you left off. --- 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] Speeding up processing through large dynamic table
The REMOVE 'stops' at every @VM and @AM. ... See my earlier response. Marvin R. Fisher Technical Resource Group A Pipeline Group Company 2850 Red Hill Ave. Suite 110 Santa Ana, CA 92705 Tel (949) 296-8380 ext. 620 Fax (949) 756-0029 Pipeline Software Statement: This email message is confidential and may be legally privileged. The contents contained within, including any attached files, are intended solely for the addressee(s). Access by anyone other than the addressee(s) is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action, taken or not taken, in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email message in error, please contact the sender. Any views expressed within are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Pipeline-Software, Inc., Santa Ana, CA. (The contents of this email message have been scanned for the presence of computer viruses.) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Laansma Sent: Monday, November 17, 2008 11:24 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Speeding up processing through large dynamic table Oh my goodness! This is incredible. Okay, now I have a mixture of @VM and @AM in the table. The REMOVE 'stops' at every @VM and @AM. I only want it to 'stop' at @AMs. How do I do that? David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office:810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com "Delivering Products, Services, and Innovative Solutions" -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joshua Gallant Sent: Monday, November 17, 2008 1:31 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Speeding up processing through large dynamic table When running through an array with a for next loop the last item processed isn't remembered so the program needs to traverse the entire array for each record and will slow down as you get to records later in the process. Instead of this: A11 = DCOUNT(IN.TAB,@AM) FOR A1 = 1 TO A11 IN.LINE = IN.TAB SWAP @VM WITH @AM IN IN.LINE CUST.NUM = IN.LINE<1> CUST.DESC = IN.LINE<2> NEXT A1 Try something like this instead: LOOP REMOVE IN.LINE FROM IN.TAB SETTING MARK SWAP @VM WITH @AM IN IN.LINE CUST.NUM = IN.LINE<1> CUST.DESC = IN.LINE<2> WHILE MARK DO REPEAT That will keep track of where you were in the array and pick up where you left off. Let me know how that works out for you. Thanks, Josh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Laansma Sent: Monday, November 17, 2008 1:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] Speeding up processing through large dynamic table Is there a way to speed up spinning through a very large dynamic table? Here is a sample of my program: A11 = DCOUNT(IN.TAB,@AM) FOR A1 = 1 TO A11 IN.LINE = IN.TAB SWAP @VM WITH @AM IN IN.LINE CUST.NUM = IN.LINE<1> CUST.DESC = IN.LINE<2> NEXT A1 A11 is 85,000+ and as this loop goes on, this thing get really slow. Any tips on speeding this up? --- 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/
RE: [U2] Speeding up processing through large dynamic table
But it is not a file - it's an array. Marvin R. Fisher Technical Resource Group A Pipeline Group Company 2850 Red Hill Ave. Suite 110 Santa Ana, CA 92705 Tel (949) 296-8380 ext. 620 Fax (949) 756-0029 Pipeline Software Statement: This email message is confidential and may be legally privileged. The contents contained within, including any attached files, are intended solely for the addressee(s). Access by anyone other than the addressee(s) is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action, taken or not taken, in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email message in error, please contact the sender. Any views expressed within are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Pipeline-Software, Inc., Santa Ana, CA. (The contents of this email message have been scanned for the presence of computer viruses.) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mecki Foerthmann Sent: Monday, November 17, 2008 11:21 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Speeding up processing through large dynamic table READNEXT could be an option SELECT IN.TAB LOOP WHILE READNEXT IN.LINE DO CUST.NUM=IN.LINE<1,1> CUST.DESC=IN.LINE<1,2> REPEAT this should be lightning-fast regardless how big IN.TAB is. David Laansma wrote: > Is there a way to speed up spinning through a very large dynamic table? Here > is > a sample of my program: > > A11 = DCOUNT(IN.TAB,@AM) > > FOR A1 = 1 TO A11 > IN.LINE = IN.TAB > SWAP @VM WITH @AM IN IN.LINE > CUST.NUM = IN.LINE<1> > CUST.DESC = IN.LINE<2> > NEXT A1 > > A11 is 85,000+ and as this loop goes on, this thing get really slow. Any tips > on speeding this up? > --- > 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/
RE: [U2] Speeding up processing through large dynamic table
So the remove pointer (mark) works like the example believes it should... SWAP @VM WITH CHAR(0) IN IN.TAB LOOP REMOVE IN.LINE FROM IN.TAB SETTING MARK SWAP CHAR(0) WITH @AM IN IN.LINE * SWAP @VM WITH @AM IN IN.LINE CUST.NUM = IN.LINE<1> CUST.DESC = IN.LINE<2> WHILE MARK DO REPEAT Marvin R. Fisher Technical Resource Group A Pipeline Group Company 2850 Red Hill Ave. Suite 110 Santa Ana, CA 92705 Tel (949) 296-8380 ext. 620 Fax (949) 756-0029 Pipeline Software Statement: This email message is confidential and may be legally privileged. The contents contained within, including any attached files, are intended solely for the addressee(s). Access by anyone other than the addressee(s) is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action, taken or not taken, in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email message in error, please contact the sender. Any views expressed within are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Pipeline-Software, Inc., Santa Ana, CA. (The contents of this email message have been scanned for the presence of computer viruses.) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joshua Gallant Sent: Monday, November 17, 2008 10:31 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Speeding up processing through large dynamic table When running through an array with a for next loop the last item processed isn't remembered so the program needs to traverse the entire array for each record and will slow down as you get to records later in the process. Instead of this: A11 = DCOUNT(IN.TAB,@AM) FOR A1 = 1 TO A11 IN.LINE = IN.TAB SWAP @VM WITH @AM IN IN.LINE CUST.NUM = IN.LINE<1> CUST.DESC = IN.LINE<2> NEXT A1 Try something like this instead: LOOP REMOVE IN.LINE FROM IN.TAB SETTING MARK SWAP @VM WITH @AM IN IN.LINE CUST.NUM = IN.LINE<1> CUST.DESC = IN.LINE<2> WHILE MARK DO REPEAT That will keep track of where you were in the array and pick up where you left off. Let me know how that works out for you. Thanks, Josh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Laansma Sent: Monday, November 17, 2008 1:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] Speeding up processing through large dynamic table Is there a way to speed up spinning through a very large dynamic table? Here is a sample of my program: A11 = DCOUNT(IN.TAB,@AM) FOR A1 = 1 TO A11 IN.LINE = IN.TAB SWAP @VM WITH @AM IN IN.LINE CUST.NUM = IN.LINE<1> CUST.DESC = IN.LINE<2> NEXT A1 A11 is 85,000+ and as this loop goes on, this thing get really slow. Any tips on speeding this up? --- 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/
RE: [U2] Pentaho/ETL Tools
MITS - www.mits.com Native to many MV platforms - Universe, UniData, D3 etc... And yes, we sell it and I implement it, but I would still recommend it - so I don't believe an AD marker is appropriate. Marvin R. Fisher Technical Resource Group A Pipeline Group Company 2850 Red Hill Ave. Suite 110 Santa Ana, CA 92705 Tel (949) 296-8380 ext. 620 Fax (949) 756-0029 Pipeline Software Statement: This email message is confidential and may be legally privileged. The contents contained within, including any attached files, are intended solely for the addressee(s). Access by anyone other than the addressee(s) is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action, taken or not taken, in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email message in error, please contact the sender. Any views expressed within are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Pipeline-Software, Inc., Santa Ana, CA. (The contents of this email message have been scanned for the presence of computer viruses.) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Butera Sent: Friday, November 14, 2008 7:45 PM To: u2-users@listserver.u2ug.org Subject: [U2] Pentaho/ETL Tools We're in the midst of creating a data warehouse from our UniData databases and exploring the possibility of using Pentaho. Their ETL tool does have an entry for Universe (not Unidata), but the connection methods are JDBC, ODBC or JNDI. We don't want to create an SQL-view of Unidata merely for ETL, we'd prefer to find an ETL tool that can natively talk with Unidata. Has anyone worked with Pentaho? Any thoughts? Does anyone have ETL tools in mind that natively talk to Unidata? Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 "But Dad, I'm not listening to you." Catherine Butera --- 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] Change columns from 80 to 132 and from 132 to 80
Since nobody else is re-asking the question... Wintegrate is a terminal emulator... What TERMINAL is Wintegrate emulating, in case the @ variables cannot be used? Marvin R. Fisher Technical Resource Group A Pipeline Group Company 2850 Red Hill Ave. Suite 110 Santa Ana, CA 92705 Tel (949) 296-8380 ext. 620 Fax (949) 756-0029 Pipeline Software Statement: This email message is confidential and may be legally privileged. The contents contained within, including any attached files, are intended solely for the addressee(s). Access by anyone other than the addressee(s) is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action, taken or not taken, in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email message in error, please contact the sender. Any views expressed within are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Pipeline-Software, Inc., Santa Ana, CA. (The contents of this email message have been scanned for the presence of computer viruses.) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Stokes Sent: Friday, September 12, 2008 2:35 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change columns from 80 to 132 and from 132 to 80 I am trying to set the columns in wintegrate from 80 to 132 or from 132 to 80 Tim Stokes [EMAIL PROTECTED] Monolith Corporation Phone: (919) 878-1900 ext 267 Fax: (919) 878-8844 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Friday, September 12, 2008 3:40 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Change columns from 80 to 132 and from 132 to 80 Depends on the emulator. What emulator and emulation are you using in that program? --- 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/
RE: [U2] [UD] Tab characters in output
Instead of complaining we should send them a thank-you note. Sent from my Windows Mobile. phone. -Original Message- From: Bill Haskett <[EMAIL PROTECTED]> Sent: Friday, September 12, 2008 7:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Tab characters in output Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 Bill --- 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] Is there a UNIDATA equivalent of Universe Itype @RECORD
According to the "Using Unidata.pdf", it looks to work just like Prime
Information and UniVerse.
While they don't talk a lot about using @record, they pass it to a subr in the
subr discussion -
Top of "ZIP" in "DICT CLIENTS", 7 lines, 50 characters.
*--: P
001: V
002: SUBR("PSTLCODE_FMT",@RECORD)
003:
004: Postal Code
005: 10R
006: S
Bottom.
*--:
But you'd have to think that if you can pass @record you should also be able to
reference @record<1> or anything you'd want to do with @record.
I don't have my UniData virtual machine available right now or I'd test it.
Marvin R. Fisher
Technical Resource Group
A Pipeline Group Company
2850 Red Hill Ave.
Suite 110
Santa Ana, CA 92705
Tel (949) 296-8380 ext. 620
Fax (949) 756-0029
Pipeline Software Statement: This email message is confidential and may be
legally privileged. The contents contained within, including any attached
files, are intended solely for the addressee(s). Access by anyone other than
the addressee(s) is unauthorized. If you are not the intended recipient, any
disclosure, copying, distribution or any action, taken or not taken, in
reliance on it, is prohibited and may be unlawful. If you believe that you have
received this email message in error, please contact the sender. Any views
expressed within are those of the individual sender, except where the sender
specifies and with authority, states them to be the views of Pipeline-Software,
Inc., Santa Ana, CA.
(The contents of this email message have been scanned for the presence of
computer viruses.)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent
Sent: Monday, June 02, 2008 3:32 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD
does anyone konw if there is way around this for dict items and evaluations
Thanks in advance
jak
---
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] Using ETL to extract data from UD to SQL
Using Dynamic Change Update in MITS removes the need for the select and merge method. You just have to know which applications write to the source file and modify them to write MITS.TODOS_app records for new source records, MITS.REDOS_app records for changed source records and MITS.UNDOS_app records for deleted source records. Marvin R. Fisher Technical Resource Group A Pipeline Group Company 2850 Red Hill Ave. Suite 110 Santa Ana, CA 92705 Tel (949) 296-8380 ext. 620 Fax (949) 756-0029 Pipeline Software Statement: This email message is confidential and may be legally privileged. The contents contained within, including any attached files, are intended solely for the addressee(s). Access by anyone other than the addressee(s) is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action, taken or not taken, in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email message in error, please contact the sender. Any views expressed within are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Pipeline-Software, Inc., Santa Ana, CA. (The contents of this email message have been scanned for the presence of computer viruses.) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: Friday, May 09, 2008 7:26 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Using ETL to extract data from UD to SQL Well, MITS does a SELECT against their copy, then against the source copy and then merge the list. So - the larger it gets - well (Not to mention I think MITS is a hunk of glorified crap) I've had no issues using triggers. (My box is huge thou) > 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/
RE: [U2] [off topic] 32 bit vs 64 bit + JRE
Does this help - http://www.netfaqs.com/linux/Version/SuSEVer/index.asp Marvin R. Fisher Technical Resource Group A Pipeline Group Company 2850 Red Hill Ave. Suite 110 Santa Ana, CA 92705 Tel (949) 296-8380 ext. 620 Fax (949) 756-0029 Pipeline Software Statement: This email message is confidential and may be legally privileged. The contents contained within, including any attached files, are intended solely for the addressee(s). Access by anyone other than the addressee(s) is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action, taken or not taken, in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email message in error, please contact the sender. Any views expressed within are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Pipeline-Software, Inc., Santa Ana, CA. (The contents of this email message have been scanned for the presence of computer viruses.) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Tuesday, February 19, 2008 8:09 AM To: u2-users@listserver.u2ug.org Subject: [U2] [off topic] 32 bit vs 64 bit + JRE I don't know who else to ask, and uncle googl is not being that helpful... so (1) how do I find out if my server is 32bit SUSE or 64bit SUSE (googl says you can tell at install, but that's a bit late..) (2) I want to download the Java Runtime to install on SUSE 10 - it asks me whether I want 32bit or 64 bit. Why I need to know, is... We are wanting to install Sysaid Help Desk on our server. (www.illient.com) - well worth a look at coz its free and very good. I have only ever installed [anything] on Windoze. Now I get to put this thing on linux. Hoo boy. --- 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] Excel downloads
Try this:
=CONCATENATE("","01234")
For any values with leading zeroes.
Marv
Marvin R. Fisher
Technical Resource Group
A Pipeline Group Company
2850 Red Hill Ave.
Suite 110
Santa Ana, CA 92705
Tel (949) 296-8380 ext. 620
Fax (949) 756-0029
Pipeline Software Statement: This email message is confidential and may be
legally privileged. The contents contained within, including any attached
files, are intended solely for the addressee(s). Access by anyone other than
the addressee(s) is unauthorized. If you are not the intended recipient, any
disclosure, copying, distribution or any action, taken or not taken, in
reliance on it, is prohibited and may be unlawful. If you believe that you have
received this email message in error, please contact the sender. Any views
expressed within are those of the individual sender, except where the sender
specifies and with authority, states them to be the views of Pipeline-Software,
Inc., Santa Ana, CA.
(The contents of this email message have been scanned for the presence of
computer viruses.)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming
Sent: Wednesday, February 13, 2008 6:05 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Excel downloads
On this topic, I have a request for a solution.
In New Jersey, all the zip codes start with '0'. Add product codes like
012345 and order numbers like 000123 etc and you'll see the leading zeros.
When creating and exporting a CSV to eventually be used by Excel, those
columns lose their leading zeros as Excel thinks they are numeric.
I know that the users can and choose Custom etc.
I've converted the same CSV into a HTML boxed record and the zeros remain as
expected.
I've tried prepending the values with an astrophe (single quote) to no
avail.
The true data (as viewed in Notepad) is exactly as I sent it:
"07748","012345","000123"
So, any tricks in having Excel leave the zeros alone when clicking on the
CSV in WIndows Explorer. Meaning, that the person opening the CSV in excel
doesn't have to convert anything.
Thanks in advance
Mark Johnson
- Original Message -
From: "David Murray" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, February 12, 2008 4:40 PM
Subject: RE: [U2] Excel downloads
> Laurie,
>
> For simple totals, it is possible to add an EXCEL formula into a cell by
> starting the cell/formula with an '=' sign. This also works with CSV
> structured files, which EXCEL will load and convert on the fly.
>
> Create a virtual/correlative field which will simply output the formula as
> text and add it to the CSV file e.g. "=SUM(An)".
>
> Cheers,
>
> David Murray
>
>
> .learn and do
> .excel and share
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen
> Sent: Tuesday, February 12, 2008 12:10 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Excel downloads
>
> Hello,
>
> We are looking for a simple way to drop aggregate totals type reports
> out of Universe into Excel. Our users are using AccuTerm and we also
> have MITS Reports installed. But, neither one does the trick for
> summarized reports that use the DET-SUP option. Having the detail and
> forcing the users to do their own grouping/sub-totals in Excel is simply
> not an acceptable option here.
>
> UV 10.2.3 on Win2003 server; AccuTerm 2K2 re. 5.1. We also would be
> happy to develop a "simple" (key word...) VB.Net executable that works
> smoothly regardless of the version of Excel, as our users work on
> anything from Office 2000 and above.
>
> Any suggestions welcome.
>
> TIA,
> Laure Hansen,
> City of Redwood City
> Information Technology
> 1017 Middlefield Road
> Redwood City, CA 94063
> Tel 650-780-7087
> Cell 650-207-3235
> Fax 650-556-9204
> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> ---
> 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] Exabyte 8MM under Universe PE
Need some assistance with configuring the subject drive under Universe PE. I have added the device under UniAdmin, but am a bit clueless what to place in the rewind and skip dos command prompts. The examples in the help file do not work (c:\ibm\uv\bin\uvmt -dtape0 rew ). The tape drive cannot be tested without the rewind entry. Any help would be appreciated. Regards, Marv Marvin R. Fisher Technical Resourse Group A Pipeline Group Company 2850 Red Hill Ave. Suite 110 Santa Ana, CA 92705 Tel (949) 296-8380 ext. 620 Fax (949) 756-0029 Pipeline Software Statement: This email message is confidential and may be legally privileged. The contents contained within, including any attached files, are intended solely for the addressee(s). Access by anyone other than the addressee(s) is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action, taken or not taken, in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email message in error, please contact the sender. Any views expressed within are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Pipeline-Software, Inc., Santa Ana, CA. (The contents of this email message have been scanned for the presence of computer viruses.) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
