Re: [U2] MS-SQL Question

[Don Verhagen]

You can't use the Column alias directly in a where cause, you need to put in
a derived dataset (table)

i.e.

SELECT *
FROM
(
SELECT
 substring(colname ,charindex('|',colname)+1, charindex('|',colname,
 charindex('|',colname)+1) - charindex('|',colname) -1) as "PID"
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
> To: U2 Users List
> Subject: Re: [U2] MS-SQL Question
> 
> It came back with unknown column error. I'll have to play with it
> again, it's possible I typed something wrong,
> But at least for now, it's working the other way I set it up.
> 
> Thanks
> George
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of George Gallen
> Sent: Thursday, 29 December 2011 2:51 AM
> To: U2 Users
> Subject: [U2] MS-SQL Question
> 
> I'm querying a sequel server , I have a column in one table that the
> data is in the form of "X|Y|Z".
> 
> I have the following in my SELECT:
> 
> substring(colname ,charindex('|',colname)+1, charindex('|',colname,
> charindex('|',colname)+1) - charindex('|',colname) -1) as "PID"
> 
> Is there anyway that I can then use the "PID" designation  in a where
> clause, without having to retype the string again?
> 
> 
> I can't add a virtual column to the table , and I can't add a procedure
> either.
> 
> ___
> 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-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-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

Re: [U2] Testing . . .

[Don Verhagen]

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
> 
> ___
> 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

Re: [U2] Opinions on Cache

[Don Verhagen]

First I like to thank all that have responded to my query. I knew that
posting a question that may lead me to dropping U2 as a database may cause
some concern as to whether that is appropriate for this list.

I believe it is, because I want the opinions of people who have
experience/exposure in both U2 and Cache. There was a bit of confusion about
U2 and SB. If I decide to go with Cache, I would abandon the SB platform for
GUI UI. I was interested if there was any conversion utilities between SB
and .NET forms. Specifically if Cache has .NET DLLs/providers for
connectivity and databinding in .Net controls, etc.

I haven't looked at SB/XA yet, which I believe is the XAML (WPF) replacement
for SB. The candidate application is approx 15 years old (last used 3 years
ago) and is due for a major rewrite/overhaul. I have used WebDE (Redback) in
the past and was satisfied with it as middleware.

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 Posters =)



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Opinions on Cache

[Don Verhagen]

Group,

I want to ask if anyone has had any experience with Cache and also has
experience with U2 and SQL. I have been out of the MV (U2) since then of
2008, currently .NET (C#) and MSSQL.  I have a large MV application written
in SB and Unidata that I would like to re-develop.

The basic roundup:
Entity Files
- Employees (1M+ records)
- Customers (1M+ records)

Transactons:
- Payroll/Timecard/Invocing related files (10M+ records each file).

Binary Files:
- Photos, Documents (resumes, HR Forms) (2-3M records)


This will be a small/midsize enterprise application that will have both
desktop, web, and mobile modules.

Areas of interest:
- Speed (I know this is difficult without hardware/etc).
- File / Program Architecture
- Development Language/Environment
- Change Management (SDLC)
- Deployment


I just looking for an over feel and professional opinions as compared to
other platforms. The biggest issues I have with SQL is the shear about of
tables and their inflexibility with max sizes and such.  The toughest
question I hate to answer what is: The maximum size for column/field "Last
Name/Surname", Answer: How the hell do I know!

Thank you in advance for any and all opinions 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
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Unidata/SBClient/SBServer Pricing - USA

[Don Verhagen]

Group,

I'm looking for ballpark pricing for the following Unidata/SB setup for
development. I used to deal with IBM directly not a var. I prefer this
arrangement but it's not mandatory.  I have lost all my US IBM contacts over
the last 2 years.

What I need is pricing for the following:

5-User Development license for Unidata 7.x for Windows

Development License for SBServer or whatever the most current incarnication
is. I know there was talk about making SB a .Net component(s).

1-5 SBClient licenses (if the .Net components aren't production ready).

Plus Annual support/maintenance 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 mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] More questions on indexing

[Don Verhagen]

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 rarely had any need to rebuild any indexes with
Unidata, other than part of a file resizing/space considerations.

Donald Verhagen
People 2.0

 



> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
> Bill Haskett
> Sent: Thursday, July 16, 2009 4:52 PM
> To: U2 Users List
> Subject: Re: [U2] More questions on indexing
> 
> Brad:
> 
> I've defined indexes in my files with dictionary items like 
> "INDEX_1", 
> etc.  Thus only these dictionaries are ever used for 
> indexing.  A file 
> may have 4 or 5 indexes (INDEX_1 - INDEX_4).
> 
> I wrote another program to do the indexing for a single file or an 
> entire account by executing the command...
> 
> :ACCT-INDEX  CUSTFILE  -IINDEX_
> 
> ...which will create all the indexes on the CUSTFILE.  Also, my 
> dictionary listing will show these indexes separately so it 
> looks like:
> 
> Dictionary of File: APPO  
> 13:48:38 Jul 16 2009
> Dict Name.. Typ # Col-Heading Field-Def... Conversion.. Formt 
> Assoc...
> 
> @UQ Phr   VENDNO CLIEN
>   TNO DISSUE A
>   UTH DESCT DC
>   LOSED
> INDEX_1 Indx  IF DCLOSED N
>   18L   S
>   E "" THEN CL
>   IENTNO "R(%4
>   )" : UNITNO
>   "R(%7)" : SE
>   QNO "R(%7)"
> @ID D 0   APPO
>   6RS
> PONOD 0   PO# 
>   7RS
> VENDNO  D 1   VEND#   
>   5RS
> CLIENTNOD 2   CLNT
>   4RS
> 
> 
> We don't normally rebuild indexes on UD v7.1 or v7.2.
> 
> HTH,
> 
> Bill
> 
> --
> --
> bradley.sch...@usbank.com said the following on 7/16/2009 1:18 PM:
> > Thanks, Rod. One more thing. I've written a test program to 
> simplify index 
> > creation and building. When I run it under type U or type P using 
> > BUILD.INDEX or BUILD-INDEX, it gives me the "Enter  to 
> > continue..." prompt after each screen of *'s. Definitely 
> not desirable for 
> > an automated process. It doesn't do this at TCL. 
> >
> > How can I work around this? I'd rather not throw a bunch of DATA 
> > statements in there.
> >
> >
> > EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY'
> > DATA 20
> > EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY'
> > EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY'
> >
> >
> > TIA,
> > Brad.
> >
> >   
> >> Please respond to U2 Users List
> >>
> >>  I think Oracle's indexing scheme is much more complicated that
> >> Unidata's, so I don't think you can compare the two. I do 
> rebuild some
> >> of the dynamic files on occasion to get some space back. Other than
> >> that, I leave them alone and haven't had problems. - Rod
> >>
> >> 
> >
> >
> >   
> >> Research continues and I have more question for the group: 
> my Oracle 
> >> buddies rebuild their indexes at least weekly. Seems to be a best 
> >> practice. Seems odd to not be able to trust that your 
> index is correct.
> >> Is 
> >> this a concern for ud 7.1? 
> >>
> >> TIA,
> >> Brad.
> >>
> >> ud 7.1
> >> AIX 5.3
> >> U.S. BANCORP made the following annotations
> >> 
> >
> > U.S. BANCORP made the following annotations
> > 
> -
> > Electronic Privacy Notice. This e-mail, and any 
> attachments, contains information that is, or may be, covered 
> by electronic communications privacy laws, and is also 
> confidential and proprietary in nature. If you are not the 
> intended recipient, please be advised that you are legally 
> prohibited from retaining, using, copying, distributing, or 
> otherwise disclosing this information in any manner. Instead, 
> please reply to the sender that you have received this 
> communication in error, and then immediately delete it. Thank 
> you in advance for your cooperation.
> >
> >
> >
> > 
> -
> >
> > ___
> > 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.u2

Re: [U2] Simple Export to Excel

[Don Verhagen]

Group (I didn't see who the OP was),

I have a perl script/unidata program which will do XLS (Excel 2003 and
before). It requires that perl be installed and a few *excel.ppms* freely
available. The black box unidata driver program handles column heading,
formatting, justification, sorting, subtotaling and grouping.  I'm working
through the OpenXML formats for Office, I've conquered Word 2007 and moving
onto Excel 2007 (openxml) next. I will update the group when I finish.  If
anyone wants the perl/excel2003 scripts and unidata programs let me know.
(email: u2ex...@remove-thissoutheast-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: Monday, July 06, 2009 12:55 PM
> To: U2 Users List
> Subject: Re: [U2] Simple Export to Excel
> 
> >On Mon, Jul 6, 2009 at 9:59 AM, Larry Hiscock 
>  wrote:
> >Or, you can create your export in the Office XML format, and 
> tell excel
> >explicitly what to do with each column of data.
> 
> Absolutely.  But what a time-consuming chore that can be... :-)
> 
> -K
> ___
> 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

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

[Don Verhagen]

 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
> Subject: Re: [U2] [u2u] UV on Windows question
> 
> How interesting, you can't just reply to the email anymore, 
> you have to change the to address.
> 
>  
> 
> Jerry Banker
> 
>  
> 
> From: Dave R [mailto:dave.ra...@juno.com] 
> Sent: Monday, June 01, 2009 3:54 PM
> To: jpb-u...@hotmail.com
> Subject: Re: [u2u] UV on Windows question
> 
>  
> 
> Unix has it's own set of administration tools different the 
> windows administration tools, I don't believe they require 
> about the same knowledge to use, if you are a windows 
> engineer you would like a windows platform and if you are a 
> Unix engineer you would prefer Unix.
> 
> Even thought I use a Windows platform I prefer Unix systems 
> as a platform for a Multi-Value system.  If you want to 
> purchase a new system then I would go to Reality (contact 
> Northgate-IS, John Semen or Mark Pick). It is the rated by 
> the experts as the best of the systems, Unidata would be 
> next, and UniVerse would be 3rd.  
> 
> The first reason is that Unix systems are not susceptible by 
> Windows viruses.  The second reason is security, Most windows 
> hackers are complete lost in UNIX.  The Unix systems are more 
> robust.  The file management is improved in Unix and 
> 
> The Unix OS was designed for multi users and by mainframe 
> software engineers who have a far more knowledge of multi 
> user environments.  
> 
> Most companies hire windows network engineers and they don't 
> like the idea of Unix platforms. However most large companies 
> run Unix or Aix or Hpux for the platform for Reality or U2.
> 
> Some other considerations would be if you are coming from a 
> different Multi-Value package like Pick D2 or mvBase, Reality 
> and UniVerse have switches to creating an environment to run 
> that flavor of Multi-Value, requiring little to no conversion 
> of the software and database.  A big cost factor in the conversion.
> 
>  
> 
> 
> 
> 
> Dave R. 949 757 8519 (work) 
> 
> eFax (815)4259364
> 
> -- Original Message --
> From: "JPB-U2UG" 
> To: 
> Subject: [u2u] UV on Windows question
> Date: Sat, 30 May 2009 16:00:37 -0500
> 
> I've never worked with UV on Windows so I would like to know, 
> apart from the
> obvious differences of the operating system, is there much 
> difference in
> administering the database in Windows as compared to Linux/Unix.
> 
> 
> 
>  
> Criminal Lawyers - Click here. 
>  cygQ1UHaGxeSYzU7qCu4EnncAfGU1lK5Ikr5JJDuhy/> 
> 
> 



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Don Verhagen]

Brian,

Thanks for book suggestions as this is one of the concepts that I am having
issues with. Understanding the database/languages, SQL and Csharp, are just
a "how-to" problem which I've got a pretty decent grasp of. However, RECORD
LOCKING and concurrency seems to be the white elephant in  room 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, February 22, 2009 12:39 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Leaving U2 World to the Dark Side (SQL)
> 
> Hi Don
> 
> I'm sure you'll excel there - especially with your depth of 
> real-world (ie
> multivalue) knowledge behind you!
> 
> But I would highly recommend reading whatever is the latest 
> book on SQL
> Server and .Net by Roger Jennings before you do (check out 
> Wrox press).
> Apart from the stuff pointed out here about maintaining three tier
> architectures and not just using data binding (actually, data 
> binding to
> classes is fine, just binding to data sets is crap) the real bitch is
> concurrency control and how to handle it when you need to 
> start looking at
> merge processing. There's a lot of good advise on that in the 
> Roger Jennings
> books - and details on some hidden language features to make 
> SQL Server
> access in .Net a lot more performant...
> 
> Best of luck.
> 
> Brian
> 
> > -Original Message-
> > From: owner-u2-us...@listserver.u2ug.org 
> > [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of 
> Don Verhagen
> > Sent: 19 February 2009 11:04
> > To: u2-users@listserver.u2ug.org
> > Subject: [U2] Leaving U2 World to the Dark Side (SQL)
> > 
> > To those that know me on this group. I have been using the 
> > Unidata databases since 1998 when introduced to it by my 
> > former CIO. Over the years and throughout my IT career, it 
> > has served me well. Decreasing software production and 
> > maintenance costs, while at the same time increasing the 
> > value of the software I (we) developed to solve complex 
> > business solutions.
> > 
> > I have accepted an Application Development management 
> > position with a company here in the Philadelphia area. 
> > However, they are not a U2 shop.  I view this opportunity as 
> > a chance to build my skills in and around the .NET platform 
> > 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 Manager
> > People 2.0
> > www.people20.com
> > ---
> > 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] Leaving U2 World to the Dark Side (SQL)

[Don Verhagen]

To those that know me on this group. I have been using the Unidata databases
since 1998 when introduced to it by my former CIO. Over the years and
throughout my IT career, it has served me well. Decreasing software
production and maintenance costs, while at the same time increasing the
value of the software I (we) developed to solve complex business solutions.

I have accepted an Application Development management position with a
company here in the Philadelphia area. However, they are not a U2 shop.  I
view this opportunity as a chance to build my skills in and around the .NET
platform 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 Manager
People 2.0
www.people20.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Green Software -> Green Business

[Don Verhagen]

Susan,

While the below changes may result in "green" results I tend to believe the
main motivation behind most of the changes were monetary not environmental.

Every "green" change has monetary benefit to the business owner.
1) Software and Documentation
- No CD production costs / No Reams of Paper

2) Don't commute / Employees don't commute
-- No office building rent/lease, a/c, water, etc.

3) Travel
-- Obvious, however, it may be like me and I like to keep me shoes on in
public. =)

I think the question is what really motivated the change. Money (and
convenience) or "green"?

Would you make 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 and the
windows open.





> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn
> Sent: Friday, July 25, 2008 7:25 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Green Software -> Green Business
> 
> This idea is interesting, though.  Is this bordering - or 
> boldly going -
> into an off-topic discussion? 
> 
> Software companies (and departments) are among the types of 
> organizations
> that can most easily lend themselves to "Kermit-chrome".  I 
> can't say that I
> require payment by Paypal - my customers' are businesses that have
> accounting departments and pay cycles and all kinds of things 
> that I don't
> feel are my right to force them to circumvent in order to do 
> business with
> me. But I do provide the software and the documentation via electronic
> media,  I avoid unnecessary paper, I don't commute and the 
> folks that do
> work for me also do it from home.  I do upgrades and training 
> remotely with
> more and more use of web-based meetings.  So less flying my 
> carbon footprint
> around (which also conserves my more personal energy!)
> 
> So far my efforts to go green have been very easy.  They 
> corresponded with
> technology advances, good sense budget monitoring and 
> convenience.  That's a
> triple win!  I would be interested in hearing about other 
> companies who are
> making any efforts and what kind of efforts to go green.  
> 
> Replacing monitors?  Lowering the power settings? (I'd have a 
> hard time
> seeing my laptop screen!) What else is anyone doing or 
> thinking of doing?
> 
> Curiously and even spuriously yours,
> Susan J.
> ---
> 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] CALL @progname

[Don Verhagen]

On the bright side, anything is more "efficent" than the program "blowing 
up". I hear what you're saying about efficency, however, sometimes it's 
better to be safe than sorry (ie less effiecent).

I had to do this in a time import program in which each type of time clock 
had it's custom-definable parsing program. In this day and age, 2 extra 
reads are going to cost less than the possible hit to the 
reputation/reliability of the program. Yes, programs have reputations...heh.

My 2 cents.

Don Verhagen




- Original Message - 
From: "Kathleeni M Hunter" <[EMAIL PROTECTED]>
To: 
Sent: Saturday, June 07, 2008 11:02 AM
Subject: RE: [U2] [UD] CALL @progname


| But if the program is not globally catalog then you will find it there. It
| make sure that you can exit the program catalog it before calling it. If 
you
| want to make sure that you can catalog it the basic the program before the
| catalog.
|
| EXECUTE "BASIC ":filename:" ":program CAPTURING OUTPUT (stops display to
| screen)
| EXECUTE "CATALOG ":filename:" ":program CAPTURING OUTPUT
|
| Note that if all your code is in one file that you can hard code the
| filename.
|
| -Original Message-
| From: Cordes, Tom (contractor) [mailto:[EMAIL PROTECTED]
| Sent: Tuesday, May 27, 2008 6:32 AM
| To: 'u2-users@listserver.u2ug.org'
| Subject: RE: [U2] [UD] CALL @progname
|
| Dave,
|
| If the _MAP_ file is current, all globally catalogued programs have an
| entry.  'MAKE.MAP.FILE' updates the file.
|
| Tom
|
| -Original Message-
| From: [EMAIL PROTECTED]
| [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton
| Sent: Thursday, March 15, 2007 11:20 AM
| To: u2-users@listserver.u2ug.org
| Subject: [U2] [UD] CALL @progname
|
| I am writing some code that will execute a variable passed in "progname"
| using CALL @progname.
|
| Question - what is the 'best' way to know that "progname" exists before I
| attempt the CALL.
|
| I thought about reading the VOC, but if it's globally cataloged, that 
won't
| work.
|
| I could read the VOC and then the CTLGTB -- but that was two reads just to
| 'know' the routine wasn't going to blow up.  Is there a more efficient or
| systemic way to do this?
|
| **Typically** "progname" will reference a real program, so this testing is
| 'overhead' for 99.9% of the time - but if someone were to pass in a bad
| 'progname', I want to be more graceful (and secure!) just falling over.
| Since some of the calls will come from 'web connected' clients, and some 
of
| the clients may not know for sure that the host cannot handle the 
request -
| if the client has a different function list than the host at that point 
and
| time... I'm just trying to plan for 'worst case'.
|
| How do others handle CALL @
| ---
| 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] Is there a UNIDATA equivalent of Universe Itype @RECORD

[Don Verhagen]

John,

Try using lower case "list", this will force ECLTYPE U (Unidata) flavor.

Don Verhagen


- Original Message - 
From: "John Kent" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, June 03, 2008 6:41 PM
Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD


| Bill,
|not for me though
|
| LIST STK EVAL "DCOUNT(EXTRACT(@RECORD,30,0,0),@VM)" 09:01:48 04 Jun 2008 1
| STK...
|
| Illegal attribute:
| select criteria EVAL is not a field.
|
| whereas an itype will
| ED DICT STK JAK
| Top of "JAK" in "DICT STK", 6 lines, 50 characters.
| 001: I
| 002: DCOUNT(EXTRACT(@RECORD,30,0,0),@VM)
| 003: MD0
|
| i am not familiar with Unidata nor they way this machine is configured but
| it annoying when simple things like this dont work
|
| jak
|
| - Original Message - 
| From: "Bill Haskett" <[EMAIL PROTECTED]>
| To: 
| Sent: Tuesday, June 03, 2008 7:06 PM
| Subject: RE: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD
|
|
| > Jak:
| >
| > This worked fine for me in an EVAL.  UD v7.1 in Win 2K3 with ECLTYPE =
| > Pick.
| >
| > :list APOPEN ACCTS AMTS EVAL "DCOUNT(EXTRACT(@RECORD, 9, 0, 0), @VM)"
| > COL.HDG "Cnt"
| >
| > APOPEN ACCT. ACCT/AMTS Cnt...
| >
| > 69*7   2090270.06  1
| > 830*38779  3060120.64  2
| >   3070111.13
| > 830*38750  3060 63.03  2
| >   3070 51.78
| > 830*38895  3060 37.15  2
| >   3070 52.51
| >
| > Bill
| >
| >>-Original Message-
| >>From: [EMAIL PROTECTED] [mailto:owner-u2-
| >>[EMAIL PROTECTED] On Behalf Of John Kent
| >>Sent: Monday, June 02, 2008 8:11 PM
| >>To: u2-users@listserver.u2ug.org
| >>Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype 
@RECORD
| >>
| >>Jeff,
| >>what actually worked was...
| >>
| >>DCOUNT(EXTRACT(@RECORD,30,0,0),@VM)
| >>
| >>doesn't seem to work in an EVAL though
| >>eg
| >>LIST STK EVAL "DCOUNT(EXTRACT(@RECORD,30,0,0),@VM)" A30
| >>
| >>jak
| >>- Original Message -
| >>From: "John Kent" <[EMAIL PROTECTED]>
| >>To: 
| >>Sent: Tuesday, June 03, 2008 11:38 AM
| >>Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype 
@RECORD
| >>
| >>
| >>> Jeff,
| >>>that'll do, thanks
| >>> jak
| >>> - Original Message -
| >>> From: "Jeff Butera" <[EMAIL PROTECTED]>
| >>> To: 
| >>> Sent: Tuesday, June 03, 2008 11:08 AM
| >>> Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype
| >>> @RECORD
| >>>
| >>>
| >>>> On Tue, 3 Jun 2008, John Kent wrote:
| >>>>
| >>>>> Ken,
| >>>>>  i want to create a simple dict item like
| >>>>>
| >>>>> ED DICT STK JAK
| >>>>> Top of "JAK" in "DICT STK", 6 lines, 38 characters.
| >>>>> *--: P7
| >>>>> 001: I
| >>>>> 002: DCOUNT(@RECORD<30>,@VM)
| >>>>
| >>>> Try this:
| >>>>
| >>>> DCOUNT(EXTRACT(@RECORD,@AM,30),@VM)
| >>>>
| >>>> Jeff Butera, Ph.D.
| >>>> Administrative Systems
| >>>> Hampshire College
| >>>> [EMAIL PROTECTED]
| >>>> 413-559-5556
| > ---
| > u2-users mailing list
| > u2-users@listserver.u2ug.org
| > To unsubscribe please visit http://listserver.u2ug.org/
| ---
| u2-users mailing list
| u2-users@listserver.u2ug.org
| To unsubscribe please visit http://listserver.u2ug.org/ 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] OT: Textpad Syntax File for Unidata

[Don Verhagen]

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/

[U2] [UD] UTC/GMT - Unidata - Windows XP/Windows 2003

[Don Verhagen]

Group,

I'm running UD 7.1 on Windows Server 2003 and a Windows XP Pro workstation.
Is there an OCONV or SYSTEM() function that will return the time in UTC/GMT?
I want to start date/time stamping the transactions and once in UTC I can
convert to any timezone after that.

Any thoughts? I can't seem to find any windows related stuff on the web,
plenty of UNIX though.

Thanks,
Don Verhagen
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Time Travel

[Don Verhagen]

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 Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker
Sent: Monday, November 26, 2007 2:33 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Time Travel

I thought that the list server was located in Australia but when I
looked it up in whois it shows up in Florida and administered by Donald
Verhagen!?

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 26, 2007 10:56 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Time Travel
> 
> I have to add my two bits. Okay, I don't 'have' to...
> 
> I use the exact same email group software (majordomo 1.94.5) on my
'home'
> system with over 7000 subscribers to over 180 different email groups.
Our
> groups never see the delays the members of this group see, so with all
due
> respect, there's something different happening that's causing the
lags. We
> often see as many as 200 emails a second going out of our server,
which is
> an 800mghz PIII with 120GB disk, no mirroring (I know, bad idea) and
> running fedora core 4 (old...). Our group members get their emails
back
> within seconds, literally. I send an email to this group, and it
sometimes
> takes an hour or so before I see it come back to me. I send an email
to
> one of my groups at home, and I get it back within seconds.
> 
> Now then, with that said, I've also added bulk_mailer to my email
group
> server so maybe that speeds things up a great deal. I don't know. I
did it
> so I would quit getting the annoying 'too many email connections from
your
> server' errors I see from aol, hotmail, msn, yahoo, netscape, netzero,
> juno, gmail, . . . ad infinitum of the 'big' email hosts.
> 
> My point? none really, other than to show that Charles' nice
numerically
> explained _time travel_ doesn't match my real-life experience with my
own
> majordomo server...
> 
> I don't know why, they just aren't the same.
> 
> Karl
> 
> 
> > Or upgrade to a forum based group - just my standard gripe about
email
> > lists   ;)
> >
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of Moderator
> > Sent: 26 November 2007 06:03
> > To: u2-users@listserver.u2ug.org
> > Subject: [U2] Time Travel
> >
> > To fix this problem, you'd have to
> > redesign the methods under which the internet manages and routes
mail.
> >
> > - Charles Barouch, Moderator
> > ---
> > 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/
> >
> 
> 
> --
> Karl Pearson
> Director of I.T.
> ATS Industrial Supply, Inc.
> [EMAIL PROTECTED]
> http://www.atsindustrial.com
> 800-789-9300 x29
> Local: 801-978-4429
> Fax: 801-972-3888
> 
> "To mess up your Linux PC, you have to really work at it;
>  to mess up a microsoft PC you just have to work on it."
> ---
> 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] Time Travel

[Don Verhagen]

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, November 26, 2007 2:33 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Time Travel

I thought that the list server was located in Australia but when I
looked it up in whois it shows up in Florida and administered by Donald
Verhagen!?

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 26, 2007 10:56 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Time Travel
> 
> I have to add my two bits. Okay, I don't 'have' to...
> 
> I use the exact same email group software (majordomo 1.94.5) on my
'home'
> system with over 7000 subscribers to over 180 different email groups.
Our
> groups never see the delays the members of this group see, so with all
due
> respect, there's something different happening that's causing the
lags. We
> often see as many as 200 emails a second going out of our server,
which is
> an 800mghz PIII with 120GB disk, no mirroring (I know, bad idea) and
> running fedora core 4 (old...). Our group members get their emails
back
> within seconds, literally. I send an email to this group, and it
sometimes
> takes an hour or so before I see it come back to me. I send an email
to
> one of my groups at home, and I get it back within seconds.
> 
> Now then, with that said, I've also added bulk_mailer to my email
group
> server so maybe that speeds things up a great deal. I don't know. I
did it
> so I would quit getting the annoying 'too many email connections from
your
> server' errors I see from aol, hotmail, msn, yahoo, netscape, netzero,
> juno, gmail, . . . ad infinitum of the 'big' email hosts.
> 
> My point? none really, other than to show that Charles' nice
numerically
> explained _time travel_ doesn't match my real-life experience with my
own
> majordomo server...
> 
> I don't know why, they just aren't the same.
> 
> Karl
> 
> 
> > Or upgrade to a forum based group - just my standard gripe about
email
> > lists   ;)
> >
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of Moderator
> > Sent: 26 November 2007 06:03
> > To: u2-users@listserver.u2ug.org
> > Subject: [U2] Time Travel
> >
> > To fix this problem, you'd have to
> > redesign the methods under which the internet manages and routes
mail.
> >
> > - Charles Barouch, Moderator
> > ---
> > 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/
> >
> 
> 
> --
> Karl Pearson
> Director of I.T.
> ATS Industrial Supply, Inc.
> [EMAIL PROTECTED]
> http://www.atsindustrial.com
> 800-789-9300 x29
> Local: 801-978-4429
> Fax: 801-972-3888
> 
> "To mess up your Linux PC, you have to really work at it;
>  to mess up a microsoft PC you just have to work on it."
> ---
> 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] [UD] Unidata 7.1 / HPUX 11.11i

[Don Verhagen]

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. Currently we are running 
UD 6.0.9 on HPUX 11.11i in 32-bit (non 64-bit mode).

So my question is, is UD 7.1.x only available on HPUX in 64bit versions?

Thanks for advice or experiences.


-- 

Donald Verhagen 
Director Of Application Development
[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
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UD] Union Query

[Don Verhagen]

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 
Director Of Application Development
[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 5/16/2007 at 12:26 pm, in message <[EMAIL PROTECTED]>,
"David Wolverton" <[EMAIL PROTECTED]> wrote:
> Question for everyone then: Should IBM invent a method to extend the Query
> languages of UniData/UniVerse to do this 'Temporal File' - a "Cross Data
> File" SELECT/LIST/SORT?
> 
> That is, should the logic for handling multiple datafiles with a common
> dictionary basis be 'native' to the processes?  Would we gain significantly
> from this?
> 
> If so, this should go to the Better n' Better group and U2AskUs...
> 
> Have to contemplate how it would work though - essentially, they would have
> to have back TWO elements on 'READNEXT' - the datakey and the file  But
> I could see TREMENDOUS use on some new fuctionality here...
> 
> David W. 
> 
>> -Original Message-
>> From: [EMAIL PROTECTED] 
>> [mailto:[EMAIL PROTECTED] On Behalf Of Norman Morgan
>> Sent: Wednesday, May 16, 2007 10:32 AM
>> To: u2-users@listserver.u2ug.org 
>> Subject: RE: [U2] [UD] Union Query
>> 
>> I'm with you, Charles.  We face this all the time, since 
>> Prelude's ADS splits data into open and history files.  
>> Merging lists is all well and good, but I still have to 
>> retrieve data from two separate files. I always wind up 
>> writing Basic to do it, making independent selects from each 
>> file and writing the keys to a work file with a tag 
>> indicating where the data resides.
> ---
> 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] Help with File Pointers

[Don Verhagen]

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
<[EMAIL PROTECTED]>, Michael
Rajkowski <[EMAIL PROTECTED]> wrote:
> If you are trying to determine that two files are pointing to the same
> thing, you could set a lock on one and try to set it on the other.  If it
> will not let you do it, then you have the same file.
> 
> ( note that my first thought was to write an item, but that could cause
> problems if anyone else was using the file. )
> 
> give the lock a unique name like testingFilePointerTestProgram so you don't
> have issues with existing data.
> ---
> 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] Help with File Pointers

[Don Verhagen]

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 DMACCOUNTS<1>. You can then work with what the VOC entry from 
the path ACCOUNT in the account.

I think you're asking how to determine the full path even when you're not 
LOGGED to the ACCOUNT, correct?

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: 561.226.8115


>>> On 3/12/2007 at 5:18 pm, in message <[EMAIL PROTECTED]>, Jeff
Schasny <[EMAIL PROTECTED]> wrote:
> This: ../.. means the directory above the directory above the one I'm in 
> right now, so by knowing where you are right now (pwd) you can fill in 
> the complete path.and compare apples to apples
> 
> Susan Joslyn wrote:
>> Hi Karl,
>> Thanks! The thing is, I can figure out where "I am", but I need to figure
>> out where two Fpointers are pointing.
>>
>> Say I have two Fpointers (VOC entries):
>>
>> 001 F
>> 002 ../../this.path/that.path/BANANA
>> 003 ../../this.path/that.path/D_BANANA
>>
>> And another
>> 001 F
>> 002 /u1/ud/this.path/that.path/BANANA
>> 003 /u1/ud/this.path/that.path/BANANA
>>
>> How do I determine for certain that they are (or are not) pointing to the
>> same exact file?
>>
>> Susan
>> ---
>> 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] Redback on Windows 2003 Server

[Don Verhagen]

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 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 1/20/2007 at 12:56 pm, in message
<[EMAIL PROTECTED]>, "Susan Lynch" <[EMAIL PROTECTED]>
wrote:
> Jan,
> 
> Given that the earliest release of Redback that shows W2003 in the Product 
> Availability matrix is 4.2.3, and 3.2.3 is not even on the Product 
> Availability list, I think you probably want to upgrade Redback.
> 
> Susan Lynch
> 
> - Original Message - 
> From: "Jan Darr" <[EMAIL PROTECTED]>
> To: 
> Sent: Friday, January 19, 2007 5:31 PM
> Subject: [U2] Redback on Windows 2003 Server
> 
> 
>> I'm attempting to install Redback, version 3.2.3 onto a Windows 2003 
>> Server, will this load properly? Is there something different that needs 
>> to be done, once installed to allow it to run? I've noticed that the 
>> scripts folder did not get created, in addition to the Redback programs 
>> not getting installed. Do I need a later release? Any and all help is 
>> greatly appreciated.
>>
>> Thanks,
>>
>> Jan
>> ---
>> 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] Program Mgmt System

[Don Verhagen]

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 Phone: 561.226.8261 Fax Phone: 561.226.8115


>>> On 12/1/2006 at 10:49 am, in message <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] wrote:
> 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,
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Program Mgmt System

[Don Verhagen]

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 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 12/1/2006 at 9:02 am, in message
<[EMAIL PROTECTED]>, [EMAIL PROTECTED] 
wrote:
> To all,
> 
>   We are in process of getting new systems here, which will be
> allowing us to segregate
> the programming people from the live system In this light, we will
> actually be setting up a
> form testing to implementation environment.
> 
> Question:  Does anybody know of a good  'software management' program
> out there  that will
>   allow us to manage program version control, implementation
> process, auditing
>   capabilities, etc, etc.Any suggestions will be much
> appreciated.
> 
> Barry  Rogen
> PNY Technologies, Inc.
> Senior  Programmer/Analyst
> (973)  515 - 9700  ext 5327
> [EMAIL PROTECTED] 
> 
> -
> Far better it is to dare mighty things, to win
> glorious triumphs even though checkered by
> failure, than to rank with those poor spirits who
> neither enjoy nor suffer much because they live
> in the gray twilight that knows neither victory
> nor defeat.t. roosevelt
> 
> 
> 
> 
> 
> NOT INTENDED AS A SUBSTITUTE FOR A WRITING
> 
> NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN
> ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY
> CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING
> OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC
> TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW 
> OF
> SIMILAR SUBSTANCE OR EFFECT.  THIS EMAIL MESSAGE, ITS CONTENTS AND 
> ATTACHMENTS
> ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER 
> INTO
> A CONTRACT.  NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A
> PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER.
> 
> This e-mail message from PNY Technologies, Inc. is for the sole use of the
> intended recipient(s) and may contain confidential and privileged 
> information.
> Any unauthorized review, use, disclosure or distribution is prohibited. If 
> you
> are not the intended recipient, please contact the sender by reply e-mail and
> destroy all copies of the original message.
> 
> [demime 1.01d removed an attachment of type application/ms-tnef which had a 
> name of winmail.dat]
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org 
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UV] OpenXMLData error

[Don Verhagen]

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 am doing some testing of receiving XML data into Universe database and I
> and kind of stuck with the OpenXMLData function which keeps returning a
> INVALID.XML.HANDEL error.
> 
> Here is what I attempted to do in a BASIC program mostly by following the
> examples in BASIC Extension documentation.
> 
> $INCLUDE UNIVERSE.INCLUDE XML.H
> STATUS = PrepareXML("TEST_FILE/TEST.xml", TEST_XML_HANDEL)
> IF STATUS # XML.ERROR THEN
>STATUS = OpenXMLData("TEST_XML_HANDEL", "&XML&/TEST_EXTRACT_RULES",
> TEST_XML_DATA)
> END
> 
> STATUS returned by OpenXMLData always gives me -2 which is
> XML.INVALID.HANDLE.
> 
> All examples I have found for OpenXMLData are passing quoted string for
> the xml handle and I don't know why.  If OpenXMLData depends on a valid
> xml handle created by PrepareXML, I imagine the variable TEXT_XML_HANDEL
> should be passed to OpenXMLData.  However, examples I have seen in
> Universe docs all have the xml handle name quoted.  (Here I am thinking
> the xml handle variable works like a opened file variable).
> If I remove un-quote the xml handle name, STATUS returned will be -1.
> 
> 
> Does any know anything wrong with my usage of OpenXMLData?
> 
> Thanks.
> Jason
> ---
> 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] Sort / Select keyword

[Don Verhagen]

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: 561.226.8115


>>> On 10/13/2006 at 10:02 am, in message
<[EMAIL PROTECTED]>,
[EMAIL PROTECTED] wrote:
> I seem to recall that there is a keyword / option / modifier which will
> display more details about the internals of a select statement.
> 
> 
> 
> Am I hallucinating again or is there really such an animal ?
> 
> 
> 
> We are on UniVerse 9.6.1
> 
> 
> 
> Cheers
> 
> 
> 
> 
> 
> John Rodgers
> ---
> 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] UV 10.2 Data encryption/ Unidata Soon?

[Don Verhagen]

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, Inc.
5901 Broken Sound Parkway NW, Suite 450
Boca Raton, FL 33487 USA
Voice Phone: 561.226.8261 Fax Phone: 561.226.8115


>>> On 9/29/2006 at 10:14 am, in message
<[EMAIL PROTECTED]>,
[EMAIL PROTECTED] wrote:
> OK Gals & Guys!  This has a really big feature in it... Data
encryption at 
> rest!
> 
> Stated another way... You can encrypt individual fields of a file,
like 
> the CREDIT CARD NUMBER, with little or no programming changes!
> 
> From the announcement "UniVerse 10.2 automates encryption of data at
rest, 
> protecting important information and meeting government standards.
This 
> advanced technology utilizes today's modern cryptology techniques to

> secure data at rest with little to zero changes to applications.
Utilizing 
> a new graphical interface, administrators can create the security
rules 
> needed for their organization, thus protecting sensitive information
at 
> the field or record level."
> 
> FYI...
>Steve
> 
>Stephen M. O'Neal
>Lab Services Sales for U2
>IBM SWG Information Management Lab Services
> 
> 
> 
> 
> 
> "Hennessey, Mark F." <[EMAIL PROTECTED]> 
> Sent by: [EMAIL PROTECTED] 
> 09/29/2006 06:56 AM
> Please respond to
> u2-users@listserver.u2ug.org 
> 
> 
> To
> u2-users@listserver.u2ug.org 
> cc
> 
> Subject
> [U2] UV 10.2 has been announced
> 
> 
> 
> 
> 
> 
> Did everyone get their marketing-gram from Janet Oswald?
> ---
> We are pleased to announce that IBM UniVerse. 10.2 will be generally

> available on September 29, 2006. This release protects personal data,

> supports U2 Web Services, strengthens and streamlines high
availability, 
> and more! 
>  
>  
> Read the full product announcement at 
> http://www.ibm.com/software/data/u2/universe/universe10-2.html 
> 
> If you have any questions on the information, please send them to 
> [EMAIL PROTECTED]
> 
> ---
> 
> It appears that the product availability page has not been updated
yet
> 
> Mark Hennessey
> ---
> 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] UniVerse Personal Editions

[Don Verhagen]

It says right in this email below:

>> - Original Message -
>> From: "Leroy Dreyfuss" <[EMAIL PROTECTED]>
>> To: 
>> Sent: Tuesday, August 29, 2006 4:33 PM
>> Subject: [U2] UniVerse Personal Editions
>>
>>
>>>   All,
>>> Because   the  current  UniVerse  10.1.11 (Windows) and
> 10.1.12
>(Linux)
>>>   Personal  Editions  were  about  to  expire  (31 August
2006),
> we
>have
>>>   reloaded  them  with  a  new  expiration date. The updated
> copies
>will
>>>   expire  on  31  October  2006,  and  will be replaced by
> UniVerse
>10.2
>>> versions   about a month before then. If you are running
> either
>10.1.11
>>> or   10.1.12   Personal   Edition,   you   should 
download
> and
>install the
>>>   replaced copies to avoid interruption.


So it looks like the new date for UV10.2PE is around 31 Oct 2006

Don





>>> On 8/31/2006 at 12:00 pm, in message
<[EMAIL PROTECTED]>,
[EMAIL PROTECTED] wrote:
> I was told 10.2 would be released in August back in June while I was
at
> a training class in December. Then through something else (this list
I
> believe) the date became 8-31-2006.  That is today.  Since that
hasn't
> happened, any idea when?
> 
> Brenda
> 
> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Leroy
Dreyfuss
> Sent: Thursday, August 31, 2006 8:05 AM
> To: u2-users@listserver.u2ug.org 
> Subject: Re: [U2] UniVerse Personal Editions
> 
>All,
>Only  the  two 10.1 servers were updated. There is no need to
> download
>the clients again until they are replaced with those from 10.2.
> 
>Regards,
> 
>LeRoy F. Dreyfuss
>Product Manager
>IBM UniVerse and UniData (U2) Data Servers
>[cid:_2_0A4857540A4855478B87872571DB]
> 
>Tel: 303-773-7783  Fax: 303-773-5915
>Mobile: 720-341-4317   Tie-line: 656-7783
>External email:  [EMAIL PROTECTED] 
>WWW:  http://www.ibm.com/software/data/u2 
> 
>Information On Demand conference
>2006-[cid:_2_0A486E080A486AC000478B87872571DB] 
> 
>"jpb" <[EMAIL PROTECTED]>
>Sent by: [EMAIL PROTECTED] 
> 
>08/30/2006 03:10 PM
> 
>  Please respond to
> u2-users@listserver.u2ug.org 
> 
>  
> To
> 
>
> 
>  
> cc
> 
>  
> Subject
> 
>Re: [U2] UniVerse Personal Editions
> 
>My bad, I found the problem. Was using an old link to the
program.
>- Original Message -
>From: "jpb" <[EMAIL PROTECTED]>
>To: 
>Sent: Wednesday, August 30, 2006 3:13 PM
>Subject: Re: [U2] UniVerse Personal Editions
>>I also tried the new UniAdmin and now It won't connect to my
> servers.
>One
>>is  the  PC I am on, another is our Linux server, and the last
is
> our
>Solaris
>>test system. None will connect. What's up?
>> Jerry
>> - Original Message -
>> From: "Leroy Dreyfuss" <[EMAIL PROTECTED]>
>> To: 
>> Sent: Tuesday, August 29, 2006 4:33 PM
>> Subject: [U2] UniVerse Personal Editions
>>
>>
>>>   All,
>>> Because   the  current  UniVerse  10.1.11 (Windows) and
> 10.1.12
>(Linux)
>>>   Personal  Editions  were  about  to  expire  (31 August
2006),
> we
>have
>>>   reloaded  them  with  a  new  expiration date. The updated
> copies
>will
>>>   expire  on  31  October  2006,  and  will be replaced by
> UniVerse
>10.2
>>> versions   about a month before then. If you are running
> either
>10.1.11
>>> or   10.1.12   Personal   Edition,   you   should 
download
> and
>install the
>>>   replaced copies to avoid interruption.
>>>
>>>   Regards,
>>>
>>>   LeRoy F. Dreyfuss
>>>   Product Manager
>>>   IBM UniVerse and UniData (U2) Data Servers
>>>   [cid:_2_0BF4A3E80BF4A19400765456872571D9]
>>>
>>>   Tel: 303-773-7783  Fax: 303-773-5915
>>>   Mobile: 720-341-4317   Tie-line: 656-7783
>>>   External email:  [EMAIL PROTECTED] 
>>>   WWW:  http://www.ibm.com/software/data/u2 
>>>
>>>   Information On Demand conference
>>>   2006-[cid:_2_0BF4BA9C0BF4B75400765456872571D9]
>>>
>>> [demime 1.01d removed an attachment of type image/jpeg]
>>>
>>> [demime 1.01d removed an attachment of type image/jpeg]
>>> ---
>>> 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/ 
> 
> [demime 1.01d removed an attachment of type image/jpeg]
> 
> [demime 1.01d removed an attachment of type image/jpeg]
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org 
> To uns

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

[Don Verhagen]

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.
5901 Broken Sound Parkway NW, Suite 450
Boca Raton, FL 33487 USA
Voice Phone: 561.226.8261 Fax Phone: 561.226.8115


>>> On 8/25/2006 at 1:26 pm, in message <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] wrote:
> David A. Green wrote:
>> Why do programmers use result[LEN(result),1]? Doesn't result[1] do
the same
>> thing but easier, quicker, and more readable?
> 
> 
> variable[1] to reference the last byte of variable is a relatively 
> recent addition to Universe.  Where "relatively" refers to the
lifeline 
> of the Pick/PI/U2 product family.
> 
> So you'll typically see it either in older code, or in code written
by 
> guys who've been programming a while and haven't picked up on all of
the 
> "newer" facilities.
> 
> I vaguely remember it being introduced and enjoying the fact that I 
> could write less code and have it more readable.  So it became one of

> the things I tended to retrofit as I was working on existing code,
not 
> worth looking for, but worth cleaning up while I was in the
neighborhood.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Hosted UniData

[Don Verhagen]

We've colo'd at an SBC (AT&T) data center also for the last 2+ years. 
The best thing about the AT&T center is the communications connected to
the "Matrix" [smirk].  With the 4 hurricanes last year and 3 the
previous, Our US locations didn't even blink (I on the hand, beg,
borrowed, and yes, even 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, in message
<[EMAIL PROTECTED]>,
[EMAIL PROTECTED] wrote:
>>  -Original Message-
>> From: [EMAIL PROTECTED] 
>> [mailto:[EMAIL PROTECTED] On Behalf Of 
>> David Wolverton
>> Sent: Wednesday, August 09, 2006 7:53 AM
>> To: u2-users@listserver.u2ug.org 
>> Subject: [U2] Hosted UniData
>> 
>> We have a customer wanting to review options for 
>> 'Outsourcing' their servers
>> - either to a CoLocation facility, or a fully hosted site.
>> 
>> Does anyone have their servers for UniData CoLo or Hosted, 
>> and if so, would
>> you mind sharing your provider and experience?
> 
> We've had our UV server colo'd at one of SBC's (now AT&T) data
centers
> for about 5 years, and have been happy with their service.  They
provide
> what you'd expect from a hardened data center:  
> 
> Multiple layers of physical security - you pass through 2 man traps
and
> a biometric palm scan to get on the data center floor.
> Connections to multiple power grids and redundant diesel generators.
> 24x7 access.
> 24x7 staffed NOC if you need something power-cycled (i.e. a hung
Windows
> server).
> Data center floor elevated above the flood plane.
> Built to withstand a 7.4 earthquake.
> A fire suppression system that won't damage electronics.
> Redundant internet connections to your cabinet.
> 
> As Symeon noted, the software you're running is irrelevant to your
colo
> provider since you manage the servers yourself.  AFAIK, SBC only had
2
> data centers prior to the merger with AT&T (southern California and
west
> Texas), but I think AT&T had a few more.  They also offer some degree
of
> managed hosting, but I've never checked into the details.
> 
> -John
> ---
> 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] ICONV 'DW' [was:UniVerse Internal Date Blackout]

[Don Verhagen]

>>> On 6/13/2006 at 5:38 am, in message
<[EMAIL PROTECTED]>,
[EMAIL PROTECTED] wrote:
> Brian,
>  [snipped...]
>As  far  as  ISO  conversion goes - here's a hypothetical question for
>you: If 2 book orders came in from the web each for 1 "Da Vinci Code",
>you  only  have  1  in stock, which order gets priority? The one dated
>2006-04-30T02:56:32+11:00 or the other dated
>2006-04-29T11:56:32-05:00?
> 
>That's  right,  you  have  to  cut the book in half... even though one
>order  was dated the 30^th and the other the 29^th they were raised at
>exactly  the  same moment in time (spooky music plays - camera pans to
>cryptic  symbols  ...)  and  have the same temporal priority. The fact
>that  ISO date time is a recognised international standard and is used
>extensively  in  XML,  is  "language"  and  OS independent and that it
>DOESN'T  separate  date and time is actually something I wish Pick did
>better.  It  is  functionality that IBM already have in other products
>and could easily incorporate into a U2.

I agree with Stuart on this. I do a lot of TIME calculations. including time 
zone conversions, in which the date is vital. i.e. Tuesday June 13th 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
 



>__
> 
>Stuart
>> Speaking of ICONV, anyone noticed that `DWx'
>> conversions are fubar.
>Sorry  to  sound  negative  and apologies if I'm misunderstanding your
>gripe
>but..
>How  can  you  ICONV  with  a  DW?  Date conversions should ICONV to a
>specific
>date to be meaningful: if you want to convert a Monday - which Monday?
>This
>Monday,  last  Monday,  nearest  Monday, the first Monday (this year),
>first
>Monday ever? (give or take a couple of billion years).
>And  if  IBM  did  pluck  one  of those out of a hat, you can bet your
>bottom
>dollar  half  the  people  on  the  list would complain that it wasn't
>*their*
>interpretation.
>Some conversions just ain't meant to be reversible.
>> This, along with my other gripe of not easily handling
>> ISO standard
>> dates (-mm-ddTHH:mm:ssZ) it seems like an
>That really stems from the fact that MVDBMS sensibly separate date and
>time:
>something  I  so  often wish other languages did! You can get the date
>format
>using:
>D-YMD[4,2,2]
>Eg.
>LIST BOOK_SALES SALE_DATE CONV "D-YMD[4,2,2]"
>LIST  BOOK_SALES SALE_DATE SALE_DATE CONV "D-YMD[4,2,2]" 09:26:16am 13
>Jun
>2006
>PAGE 1
>BOOK_SALES... Sale Date.. Sale Date..
>13660*37800*1 25 MAY 2005 2005-05-25
>13512*63000*1 28 DEC 2004 2004-12-28
>13715*54000*3 19 JUL 2005 2005-07-19
>Brian
>---
>u2-users mailing list
>u2-users@listserver.u2ug.org 
>To unsubscribe please visit http://listserver.u2ug.org/ 
> 
>**
> 
>This  email message and any files transmitted with it are confidential
>and intended solely for the use of addressed recipient(s). If you have
>received  this  email  in  error please notify the Spotless IS Support
>Centre  (+61 3 9269 7555) immediately, who will advise further action.
>This  footnote  also confirms that this email message has been scanned
>for the presence of computer related viruses.
> 
>**
> ---
> 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] Phantom Question

[Don Verhagen]

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 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 4/19/2006 at 3:12:50 pm, in message
<[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]> wrote:
> RedHat 8
> Unidata 6.0
> 
> I use PHANTOM to run a proc that starts a program that continuously checks 
> an item looking for work to do.  The terminal output from that program is 
> recorded in the como file, but any output sent to the printer does not print 
> until the process is instructed to end.  Then everything it has been asked to 
> send to the printer shows up all at once.  This rather defeats the purpose of 
> the routine.
> 
> Any ideas?
> Thanks,
> Kebbon Irwin
> ---
> 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] TIME

[Don Verhagen]

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 the date). And
you have to account for Daylight Savings Time.

 Warning Code Below *
FUNCTION B.OFFSET.TIME(cDateTime,cToTimeZone,cFromTimeZone)
INCLUDE DMSKELCODE COMMON
**
*   Meta Comment Header
 *
**
* @AUTHOR = DON
* @CDATE  = 03/04/04
* @VERSION= 1.0.39
* @LMOD   = 01/19/06}16:36:20}DON
* @SDESC  = Convert A Date and Time to An Offet Date and Time
* cDateTime
* <1> - Time To Be Converted (If Blank, Assume Current EST Time)
* <2> - Date (If Blank, Assume Current EST Date
* <3> - Use DST (Y/N) (Default is Y)
* ReturVal
* <1> - Offset Time
* <2> - Offset Date
* Needs a TimeZone Record (EST | CST | MST | PST)
* TZ.REC
* <2> Holds the offset from the BASE ZONE (In this case Base Zone is
EST)
**
ReturnVal = ''
IF LEN(cDateTime<1>) <= 0 THEN cDateTime<1> = TIME()
IF LEN(cDateTime<2>) <= 0 THEN cDateTime<2> = DATE()
IF LEN(cDateTime<3>) <= 0 OR cDateTime<3> # 'N' THEN cDateTime<3> =
'Y'
*
*
OffsetDate = cDateTime<2>
OffsetTime = cDateTime<1> + 0
OffsetYear = OCONV(OffsetDate,'DY')
OffsetDST  = (IF cDateTime<3> = 'N' THEN 0 ELSE 1)
**
* Determine If Daylight Savings Time is in Effect
* DST Starts on the FIRST Sunday of APRIL
* DST Ends on the LAST Sunday of OCTOBER
**
BEGIN CASE
  CASE OffsetYear <= 1917
* No Daylight Savings Time
DSTSDate = ''
DSTEDate = ''
  CASE OffsetYear >= 1918 AND OffsetYear <= 1919
* Last Sunday Of March / Last Sunday Of October
DSTSDate= ICONV('03/31/':OffsetYear,'D4/')
DSTEDate= ICONV('10/31/':OffsetYear,'D4/')
*
DSTStart.Found = 0
LOOP WHILE (DSTStart.Found = 0) DO
  IF OCONV(DSTSDate,'DW') = 0 THEN
DSTStart.Found = 1
  END ELSE
DSTSDate -= 1
  END
REPEAT
*
DSTEnd.Found = 0
LOOP WHILE (DSTEnd.Found = 0) DO
  IF OCONV(DSTEDate,'DW') = 0 THEN
DSTEnd.Found = 1
  END ELSE
DSTEDate -= 1
  END
REPEAT
  CASE OffsetYear >= 1920 AND OffsetYear <= 1941
* No Daylight Savings Time
DSTSDate = ''
DSTEDate = ''
  CASE OffsetYear >= 1942 AND OffsetYear <= 1945
* Observed Continuously Due To WWII
DSTSDate= ICONV('02/09/1942','D4/')
DSTEDate= ICONV('09/20/1945','D4/')
  CASE OffsetYear >= 1946 AND OffsetYear <= 1965
* No Daylight Savings Time
DSTSDate = ''
DSTEDate = ''
  CASE OffsetYear >= 1966 AND OffsetYear <= 1973
* Last Sunday In April, Last Sunday In October
DSTSDate= ICONV('04/30/':OffsetYear,'D4/')
DSTEDate= ICONV('10/31/':OffsetYear,'D4/')
*
DSTStart.Found = 0
LOOP WHILE (DSTStart.Found = 0) DO
  IF OCONV(DSTSDate,'DW') = 0 THEN
DSTStart.Found = 1
  END ELSE
DSTSDate -= 1
  END
REPEAT
*
DSTEnd.Found = 0
LOOP WHILE (DSTEnd.Found = 0) DO
  IF OCONV(DSTEDate,'DW') = 0 THEN
DSTEnd.Found = 1
  END ELSE
DSTEDate -= 1
  END
REPEAT
  CASE OffsetYear = 1974
* Changed By The Energy Commission
DSTSDate = ICONV('01/06/1974','D4/')
DSTEDate = ICONV('10/27/1974','D4/')
  CASE OffsetYear = 1975
* Changed By The Energy Commission
DSTSDate = ICONV('02/23/1974','D4/')
DSTEDate = ICONV('10/27/1974','D4/')
  CASE OffsetYear >= 1976 AND OffsetYear <= 1986
* Last Sunday In April, Last Sunday In October
DSTSDate= ICONV('04/30/':OffsetYear,'D4/')
DSTEDate= ICONV('10/31/':OffsetYear,'D4/')
*
DSTStart.Found = 0
LOOP WHILE (DSTStart.Found = 0) DO
  IF OCONV(DSTSDate,'DW') = 0 THEN
DSTStart.Found = 1
  END ELSE
DSTSDate -= 1
  END
REPEAT
*
DSTEnd.Found = 0
LOOP WHILE (DSTEnd.Found = 0) DO
  IF OCONV(DSTEDate,'DW') = 0 THEN
DSTEnd.Found = 1
  END ELSE
DSTEDate -= 1
  END
REPEAT
  CASE OffsetYear >= 1987
* First Sunday In April, Last Sunday In October
DSTSDate= ICONV('04/01/':OffsetYear,'D4/')
DSTEDate= ICONV('10/31/':OffsetYear,'D4/')
*
DSTStart.Found = 0
LOOP WHILE (DSTStart.Found = 0) DO
  IF OCONV(DSTSDate,'DW') = 0 THEN
DSTStart.Found = 1
  END ELSE
DSTSDate += 1
  END
REPEAT
*
DSTEnd.Found = 0
LOOP WHILE (DSTEnd.Found = 0) DO
  IF OCONV(DSTEDate,'DW') = 0 THEN
DSTEnd.Found = 1
  END ELSE
DSTEDate -= 1
  END
REPEAT
END CASE
*

Re: [U2] check signature [Possible AD]

[Don Verhagen]

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 number of graphics (boxes, logos, etc)
4) Multiple Check Forms (ie A/P, Payroll, etc..)

Email me off line at (don at southeast-florida dot com) if you want more info. 
This may be an AD, however, I never released the code outside the company I 
work for, although I been tweaking for years here and there. I'm think I'm 
willing to give it try with outside company.

Lastly you didn't say what platform and o/s you are on.


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: 561.226.8115


>>> On 3/9/2006 at 4:44 pm, in message
<[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]> wrote:
> I am converting our AP Checks from tractor fed continuous forms to laser
> print. They currently have a check signing machine that they feed the
> stack of checks into after they have printed. How do other companies
> handle check signing? Is there a way to print a digitized signature from
> the basic program? Any other ideas?
> 
> 
> 
> Thank you.
> 
> Steve Kunzman
> 
> 
> 
> ASI DataMyte
> 
> 2800 Campus Drive, Suite 60
> 
> Plymouth, MN 55441
> ---
> 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] [Redback] Upgrading from 4.2.5 to 4.2.6

[Don Verhagen]

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 Redback Server (ServerB) first to
4.2.6 and then, at a later point, upgrade the web server Gateway on
ServerA.

Does anyone know if the Gateway (4.2.5) will run/connect with the
Server (4.2.6) properly? The reason for this is that I have other
websites running on ServerB and don't necessarily want to disrupt them
until some schedule offline time.  

Thanks for any heads up.


-- 

* 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
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Unidata XML

[Don Verhagen]

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
Boca Raton, FL 33487 USA
Voice Phone: 561.226.8261 Fax Phone: 561.226.8115

>>> On 2/5/2006 at 3:33 pm, in message
<[EMAIL PROTECTED]>,
[EMAIL PROTECTED] 
wrote:
> I originally wrote about a compilation error with:
>>
>>X.STATUS = PrepareXML(X.XML.INPUT.FILE, X.XML.HANDLE)
>>X.STATUS = OpenXMLData(X.XML.HANDLE, X.XML.EXT.RULE.FILE,
X.XML.DATA.HANDLE)
> 
> On Sun, 5 Feb 2006, Allen Egerton replied:
>>
>> The compiler is seeing what you're defining as functions as
matrixes.
>> Which means that you've got a more basic problem 'cause you're not
>> trying to use matrixes.  You need to somehow define the
>> subroutines/functions you're trying to use.
> 
> Funny solution here - In Unidata 6.1.4, I have to enter these
function
> names in uppsercase to compile cleanly (although the document
indicates
> these are case-sensitive).  After uppercasing everything, it
compiles
> cleanly.
> 
> Jeff Butera, Ph.D.
> Administrative Systems
> Hampshire College
> [EMAIL PROTECTED] 
> 413-559-5556
> 
> "Hindsight alone is not wisdom."
>  George W. Bush
> ---
> 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] Creating a Folder

[Don Verhagen]

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] NEW.BP
3] D_NEW.BP

With your brute force method you also need to copy an EMPTY DICT
(Except for @ID). 

I've done this before:
1] DIR
2] NEW.BP
3] D_VOC 

Just for a temporary look at a directory. However, it's very dangerous
using D_VOC, because if you delete.file NEW.BP, there goes your VOC
(MD). I've done that before too..heh.

Hope this helps,

-- 

* 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

>>> On 1/27/2006 at 3:58 pm, in message
<[EMAIL PROTECTED]>, [EMAIL PROTECTED]
wrote:
> With HP-Ux and UniVerse, I need to create a folder (account?) NEW.BP
for
> UniBasic code...
> 
> Now we have
> 
> /u2/METAL/
>   DATA1
>   DATA2
> /u2/SOFTWARE/...
> 
>   AP.BP/
>   APP.1
>   APP.2
> PUR.BP/
>   APP.98
>   APP.99 
> NEW.BP
> 
> 
> Without luck, I tried it brute-force in Unix; UV did not recognize
it.
> 
> I tried CREATE.FILE; I need a folder, not a file.
> 
> Suggestions would be appreciated.
> 
> --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] Unidata on XP Lap Top

[Don Verhagen]

* 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 01/17/2006 >>>
[SNIPPED..]
And.I'd LOVE to make this available to all the diet groups, but
telling
everyone to install Unidata PE sort of makes that OVERKILL to the max
for
someone that just wants to see what their favorite recipe comes out
per
serving
[..SNIPPED]

Not to mention a clear violation of IBM's copyright.

Direct from the website when you download, in this case UD7.1PE

"You may 1) use the Program only for internal evaluation, testing, or
demonstration purposes, on a trial or "try-and-buy" basis; and 2) make
and install a reasonable number of copies, including a backup copy, of
the Program to support such use. The terms of this license apply to each
copy You make. You will reproduce all copyright notices and all other
legends of ownership on each copy, or partial copy, of the Program. "

Thanks,
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[Don Verhagen]

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 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] 2:45 pm 01/13/2006 >>>
Our UV system creates an ASCII .csv file for another
  system to import on a daily basis. The 3rd party software
  after a recent upgrade now only imports .xls files.

Is there an easy way to "automate" Excel to load the .csv,
  then save as .xls?

Or how much more difficult is it to create the .xls instead of
   a .csv?

I thought about getting one of those programs that records
mouse clicks, and create a macro of the conversion (since the
filename is the same each day), but wonder if there was
something we could do in a batch file and run every day under
the Windows scheduler.

George

George Gallen
Senior Programmer/Analyst
Accounting/Data Division
[EMAIL PROTECTED] 
ph:856.848.1000 Ext 220

SLACK Incorporated - Delivering the best in health care information and
education worldwide.
http://www.slackinc.com 
---
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] UniVerse - file importation

[Don Verhagen]

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
[EMAIL PROTECTED]


>>> [EMAIL PROTECTED] 4:16:54 PM 11/10/2005 >>>
Perhaps a nightly (or hourly) Windows script to create a .txt file from
dBase to a Windows network drive.

I presume that wIntegrate has some (cron) scripting functionality.  From
wIntegrate, run a UniBasic application to thing to grab the .txt file and
save the data to a UV file.

As an alternative, I expect that an ODBC/JDBC/XML thing could be setup.

A challenging task...

--Bill

-Original Message-
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] Behalf Of Barry Rogen
Sent: Thursday, November 10, 2005 2:08 PM
To: u2-users@listserver.u2ug.org 
Subject: [U2] UniVerse - file importation


Does anybody know of a good way (or program/utility)  to
import (translate as it were)  dBase IV  data   onto a  UniVerse
system.  We have a shipping package that uses dBase IV and I
would love to be able to utlize that data from UniVerse. As always,
any help is greatly appreciated.

 UV :10.0.19
   HPUX:   11.0


  Cheers,

Barry  Rogen
PNY Technologies, Inc.
Senior  Programmer/Analyst
(973)  515 - 9700  ext 5327
[EMAIL PROTECTED] 

-
Far better it is to dare mighty things, to win
glorious triumphs even though checkered by
failure, than to rank with those poor spirits who
neither enjoy nor suffer much because they live
in the gray twilight that knows neither victory
nor defeat

---
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] NFA and Triggers

[Don Verhagen]

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 example have SB+ 
Accounts, the SB enviroment is NOT loaded (ie @ACNT.NAME, @USER.ID, @PORT are 
initialized but values are not set.)

So if your triggers depend on these things you may have to setup a program in 
your login process to load these enviroment variables.

Hope this helps,


* Please NOTE NEW Telephone Number * 
--
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.226.8261 Fax Phone: 561.226.8118

>>> [EMAIL PROTECTED] 4:58:43 PM 11/01/2005 >>>
Wendy:
I have not tried this, but I would expect the trigger defined on the file
on the remote system would work fine. There is no NFA file on the 'client'
system - just an 'FX' style file pointer - so you couldn't define a trigger
to fire on an FX pointer in the 'client' environment. (using 'client'
loosely - as the system with the FX pointer to a file on a 'remote' system)

Wally Terhune
Manager - U2 Advanced Client Support
IBM Information Management
4700 South Syracuse Street, Denver, CO   80237
Tel:  303.773.7969< New Number!
Fax: 303.773.5915< New Number!
[EMAIL PROTECTED] 





 Wendy Smoak
 <[EMAIL PROTECTED] 
 g> To
 Sent by:  u2-users@listserver.u2ug.org 
 [EMAIL PROTECTED]  cc
 stserver.u2ug.org
   Subject
   [U2] NFA and Triggers
 11/01/2005 10:47
 AM


 Please respond to
 u2-users






Given a file with a trigger, where does the trigger code actually execute
when you open a file with (over?) NFA and write a record to it?

We have some trigger code that needs a certain environment (Datatel's
Envision) to run, and that environment exists where the  file lives... but
not in the account from which we're opening files with NFA.

The backup plan is to get rid of the trigger and simply write records to a
file that gets processed later by a cron job.

Any advice or discussion to help me understand this better?

--
Wendy Smoak
---
u2-users mailing list
u2-users@listserver.u2ug.org 
To unsubscribe please visit http://listserver.u2ug.org/ 

[demime 1.01d removed an attachment of type image/gif which had a name of 
graycol.gif]

[demime 1.01d removed an attachment of type image/gif which had a name of 
pic07440.gif]

[demime 1.01d removed an attachment of type image/gif which had a name of 
ecblank.gif]
---
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] [RANT] HTH

[Don Verhagen]

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 Solutions, Inc.
1690 S Congress Avenue, Suite 210
Delray Beach, FL 33445  USA
Voice Phone: 561.226.8261 Fax Phone: 561.226.8118

>>> [EMAIL PROTECTED] 12:04:14 PM 09/14/2005 >>>
Hope that helps!(You can check out acronyms like that at
http://www.ucc.ie/cgi-bin/acronym/acro.html)

Susan
- Original Message - 
From: "Marilyn Hilb" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, September 14, 2005 11:00 AM
Subject: RE: [U2]UD Login User


> Ok. I have to ask.. What does hth mean??
>
> HTH,
>
> Jeff Fitzgerald
> Fitzgerald & Long, Inc.
> ---
> 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] [Redback] multi-valued data displays strangely

[Don Verhagen]

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
(magically) this behaviour.  I suppose you may be able to ScopeProps.asp to get 
the behaviour you are looking for.

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 Fax Phone: 561.454.3640 

>>> [EMAIL PROTECTED] 3:40:57 AM 07/14/2005 >>>
Using RBOScope for testing - if I press enter to get a new line in a text box
and then call a validation routine which returns an error - the new line in
the text box has magically transformed into a "}" character.  When the data
arrives in my universe subroutine the new line is a value-mark (which is fine
by me).

Is there a way to keep the new line as a new line instead of a "}" ?

I've tried defining the field as a "Field" and later as a "mvField" in redback
designer, and it made no difference.

AdrianW










DISCLAIMER:
Disclaimer.  This e-mail is private and confidential. If you are not the
intended recipient, please advise us by return e-mail immediately, and delete
the e-mail and any attachments without using or disclosing the contents in any
way. The views expressed in this e-mail are those of the author, and do not
represent those of this company unless this is clearly indicated. You should
scan this e-mail and any attachments for viruses. This company accepts no
liability for any direct or indirect damage or loss resulting from the use of
any attachments to this e-mail.
---
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] Spam/Virus?

[Don Verhagen]

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 form that was attached. Of course I didn't open it
because I have nothing to do with Hamilton College. Anybody else receive this
email? Sounds like a virus.
Jerry Banker
---
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] Finding last day of month

[Don Verhagen]

* 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 (UserDateMonth + 1) > 12 THEN 1 ELSE (UserDateMonth+1))
NextMonthDay= 1
NextMonthIDate  = ICONV(NextMonthMonth:"/":NextMonthDay:"/":NextMonthYear,"D4/")
*Subtract 1 day from the first day on the next month to get the last day of the 
month supplied
UserDateIEOM = NextMonthIDate -1
UserDateEOM  = 
OCONV(UserDateIEOM,'DY'):OCONV(OCONV(UserDateIEOM,"DM"),"MR(%2)"):OCONV(OCONV(UserDateIEOM,"DD"),"MR(%2)")
*
PRINT 'NextMonthYear  = ':NextMonthYear
PRINT 'NextMonthMonth = ':NextMonthMonth
PRINT 'NextMonthDay   = ':NextMonthDay
PRINT 'EOM Internal   = ':UserDateIEOM
PRINT 'EOM ISO Date   = ':UserDateEOM
*









--
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: 561.454.3640 

>>> [EMAIL PROTECTED] 1:31:17 PM 06/02/2005 >>>
Hi,

Given a date like 20040203, I want to return the last valid date for that month 
and year (20040229 in this case). What is the shortest code fragment to achieve 
this?

At the moment I'm replacing the day with 01, then iconv, add 35 days to the 
internal date and then oconv and replace the day again with 01. I'm then on the 
first day of the next month. I then iconv, subtract 1 day and oconv.

Thanks for any help.


-
Yahoo! Messenger NEW - crystal clear PC to PCcalling worldwide with voicemail
---
u2-users mailing list
u2-users@listserver.u2ug.org 
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[Don Verhagen]

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 access level.

Then again it's almost Friday, and I don't want to overwork myself. =)

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 Fax Phone: 561.454.3640 

>>> [EMAIL PROTECTED] 4:30:20 PM 05/05/2005 >>>
Your idea about UV administrator group is one that we have wanted on our 
UV/Linux server too.  Too many of the UV admin tools require root 
priviledges on the Unix servers.  UV should not require root or system 
administrator privileges, but the admin functions should be assignable to a 
group of users.  I agree IBM needs to make this type of mod to Universe.

Ken Hall

At 11:32 AM 5/5/2005, you wrote:
>JayJay,
>
>Thanks for the reply.
>
>I guess my point is that we WANT to grant a user complete usage of ALL
>the functions within uniadmin. However, we specifically do not want them
>to be a windows system administrator in order to use the tool.  And yes,
>its ok if this individual can stop and start UV services - just those 2
>or 3 services that are IN the uniadmin tool.   But we don't want them to
>control other aspects of the server that are inherent when you are in
>the administrator's group.
>
>It seems like there is a need to have a administrator maintained group
>code that can be associated with users that need to use the tool and the
>tool checks to make sure the user trying to use it is a member of said
>group.   This would accomplish our objective without granting
>unnecessary priveleges.   (this sounds like a mod request for IBM to
>implement for uniadmin)
>
>
>-Original Message-
>From: [EMAIL PROTECTED] 
>[mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins
>Sent: Wednesday, May 04, 2005 3:57 PM
>To: u2-users@listserver.u2ug.org 
>Subject: RE: [U2] [UV] uniadmin without having to be in administrators
>group?
>
>Troy
>
>This is not a good idea - you will be giving non-administrators the
>right to change Windows services.???
>[snip]
>---
>u2-users mailing list
>u2-users@listserver.u2ug.org 
>To unsubscribe please visit http://listserver.u2ug.org/ 



Ken R. Hall
Information Technology Manager
Western States Electric, Inc. a Hughes Supply Company
9151 SE McBrod Street
Portland, OR 97222
503-653-8619
fax: 503-653-2279
mailto:[EMAIL PROTECTED] 
www.wselectric.com 
---
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] Pro's/cons of keeping UV maint/support contract current (paid)

[Don Verhagen]

The personal edition would not apply as it would be used for commerical 
purposes, which is explicitly prohibited.

>>> [EMAIL PROTECTED] 8:51:46 AM 04/14/2005 >>>
[snipped...]
Isn't there a UV-lite or personal version that may apply? Notice that we're
offering up lesser supported items as a possible solution. 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Q-pointers to system folder

[Don Verhagen]

I wouldn't use D_VOC for the dictionary  because if someone (usually the 
confident programmer) issues a DELETE.FILE command they would delete the D_VOC 
(bad bad bad).

ie DELETE.FILE TEXTFILES

Just my 2cents

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 Fax Phone: 561.454.3640 

>>> [EMAIL PROTECTED] 9:51:02 AM 03/23/2005 >>>
You can do the same thing in UniData; however you should put DIR in line 1 
instead of F and use CREATE.FILE DICT TEXTFILES 1 to create the dict item.

I also tend to put D_VOC in line 3 instead of doing the CREATE.FILE.

You can also use things like @UDTHOME and @UDTBIN in the path. I do this to 
create a pointer to the bin directory so that I can look at the log files.

I've put a program on the PickWiki that can be used to grab the O/S info for 
items in DIR files. There are also some dictionary items so you can list or 
select the files.

http://www.pickwiki.com/cgi-bin/wiki.pl?GetOsInfo 

Colin Alfke
Calgary, AB


>-Original Message-
>>From: Nick Cipollina

>>One possible solution is this, say you have a folder that is located
>>at C:\TextFiles.  Edit a VOC entry called TEXTFILES and put the
>>following:
>>
>>001 F
>>002 C:\TextFiles
>>
>>save it.  Then do the following  CREATE.FILE DICT TEXTFILES 1,1,18.
>>This will create the dictionary for this file
---
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] Order of criteria

[Don Verhagen]

Charles,

What is the syntax for the "EXPLAIN" keyword I don't see it documented in 
Unidata (6.X)

I tried:
SELECT MY.FILE WITH MY.FILE="SOMETHING" EXPLAIN

All it did was select the records, does it EXPLAIN in a log file or somewhere 
else?

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 Fax Phone: 561.454.3640 

>>> [EMAIL PROTECTED] 5:02:18 PM 02/24/2005 >>>
Generally speaking, you've got it right, John.
A few caveats, notes, gotchas:

-  Use EXPLAIN keyword to get RetrieVe to show you what it is going to
do.
[snipped..]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Redback Startup

[Don Verhagen]

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, dba's, etc. 
to stay in their own little data world.

My 2cents,

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 Fax Phone: 561.454.3640 

>>> [EMAIL PROTECTED] 12:23:18 PM 02/18/2005 >>>
[Snipped..]'

As a minimum you will need to know:

Database programming (UniBasic or UniVerse Basic)
HTML
Active Server Pages
VBScript

You will also need to be confident designing and building web sites.
RedBack is an enabling tool, not a site builder.
That means you need all the attendant page design, validation and navigation
skills 
(CSS, JavaScript and so forth).

You also need to be able to write fast, efficient database code.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[Don Verhagen]

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]
Tandem Staffing Solutions, Inc.
1690 S Congress Avenue, Suite 210
Delray Beach, FL 33445  USA
Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 

>>> [EMAIL PROTECTED] 1:46:26 PM 02/17/2005 >>>
I'm attempting to convert a system using a uvbackup tape from hpux to windows.  
I've noticed that many cataloged items now have a name that ends in the % 
character wheras on the production system they end in a ? character.

Is there something I'm missing here as far as a conversion command or 
something?  Since I used uvbackup and uvrestore, I'm thinking that doing a 
fnuxi is not required.  

Any ideas?

Thanks,



Don Kibbey
Financial Systems Manager
Finnegan, Henderson, Farabow, Garrett & Dunner LLP
---
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] UniBasic CRLF over NFS mount

[Don Verhagen]

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 equivalent command for no conversion is "NOCONVERT [ON | OFF]"

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 Fax Phone: 561.454.3640 

>>> [EMAIL PROTECTED] 7:37:01 PM 02/09/2005 >>>
There should be a ux2dos or unix2dos program in the operating system you can 
use to convert cr to crlf. Example: cat foo.txt| ux2dos > new.txt ; mv new.txt 
foo.txt

You can execute this statement from your basic program etc...



-Original Message-
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: u2-users@listserver.u2ug.org 
Sent: Wed Feb 09 16:33:13 2005
Subject: [U2] UniBasic CRLF over NFS mount

I'm building a flat file in UniBasic on a unix system, then writing it
to an NFS mount point.

The file attributes are interpreted as CRLF's when I ftp the file over
to the windows system, but when I write or move the file over to the NFS
mount, the attributes are only separated by unrecognizable characters
(to notepad).

The problem is, the version of the (BarTender) application I'm upgrading
to, requires a CRLF before/after one of the attributes.

Any suggestions/thoughts?

TIA,
Amy
---
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] Using Environmental Variables in VOC...

[Don Verhagen]

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, Suite 210
Delray Beach, FL 33445  USA
Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 

>>> [EMAIL PROTECTED] 3:30:06 PM 01/28/2005 >>>
How can I get this to work as I would like:

I want to have a VOC entry called UDT_SAVED_LOGS

001: DIR
002: $UDTBIN\saved_logs
003: D_BP

The Dict section doesn't matter, it just has to exist... And I would have
thought the $UDTBIN would map correctly, but it does not (6.0.6, NT) --
Should it?  Or is this one of those where each site would have to be
hard-coded to the path??

My goal is an 'In-App' test of logs - things like Replication can die
quietly..., and with no effect on the end user to warn them...  I want to
test the file for size and content and decide if I should raise a 'Red
Alert' within the appication - I can hard code the path per site, but seems
like enrvironmantals *should* work...

David W.
---
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] Using Environmental Variables in VOC...

[Don Verhagen]

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.REC<2> = SAVEDLOG_PATH
VOC.REC<3> = "D_BP"

It would seem unnecessary, but hey it's Friday and I'm leaving for the beach 
(bar).

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 Fax Phone: 561.454.3640 

>>> [EMAIL PROTECTED] 3:30:06 PM 01/28/2005 >>>
How can I get this to work as I would like:

I want to have a VOC entry called UDT_SAVED_LOGS

001: DIR
002: $UDTBIN\saved_logs
003: D_BP

The Dict section doesn't matter, it just has to exist... And I would have
thought the $UDTBIN would map correctly, but it does not (6.0.6, NT) --
Should it?  Or is this one of those where each site would have to be
hard-coded to the path??

My goal is an 'In-App' test of logs - things like Replication can die
quietly..., and with no effect on the end user to warn them...  I want to
test the file for size and content and decide if I should raise a 'Red
Alert' within the appication - I can hard code the path per site, but seems
like enrvironmantals *should* work...

David W.
---
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] Precision

[Don Verhagen]

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: 561.454.3640 

>>> [EMAIL PROTECTED] 3:52:25 PM 11/30/2004 >>>
52/2 = 26 paychecks ?
2 * 12 = 24 paychecks 
where the 2 missing paychecks ?  

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] 
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

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

[Don Verhagen]

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):


Node1
Node2
Node3

-
Extraction Record (text.ext)











-
Test Program
*$BASICTYPE "U"
SUBROUTINE B.TEST.XML
OPEN '','TEST.FILE' TO F.TF ELSE RETURN
*
XML.FNAME = "_XML_/test.xml"
EXT.FNAME = "_XML_/TEST.EXT"
*
STATUS = PREPAREXML(XML.FNAME,F_XML)
IF NOT(STATUS) THEN
  STATUS = OPENXMLDATA(F_XML,EXT.FNAME,D_XML)
  IF NOT(STATUS) THEN
MOREDATA = 1
LOOP WHILE (MOREDATA=1) DO
  STATUS = READXMLDATA(D_XML,THIS.REC)
  IF NOT(STATUS) THEN
WRITE THIS.REC ON F.TF,'DON.XML'
MOREDATA = 0
  END ELSE
  MOREDATA = 0
  STOP 'XML ERROR'
END
  END
REPEAT
*
STATUS = CLOSEXMLDATA(D_XML)
STATUS = RELEASEXML(F_XML)

  END ELSE
   PRINT 'OPENXML ERROR'
  END
END ELSE
  PRINT 'PREPARE ERROR'
END
-

Results of Test record (DON.XML) written to TEST.FILE:
<1> node1
<2> node3
-
Unidata appears to just be writing the data out sequentially rather than using 
the attribute number in the dictionary item.

Any ideas?

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 Fax Phone: 561.454.3640 
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UV] Initialization Error

[Don Verhagen]

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
[EMAIL PROTECTED]
Tandem Staffing Solutions, Inc.
1690 S Congress Avenue, Suite 210
Delray Beach, FL 33445  USA
Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 

>>> [EMAIL PROTECTED] 10:53:56 AM 11/19/2004 >>>
Wow.  Have never seen this one.  Though I am not certain how to resolve 
this, the error codes mean:

1: Unable to create a signature; the getid system call failed.

25: (ENOTTY) Not a typewriter. The file mentioned in an ioctl is not a 
terminal or one of the other devices to which these calls apply.

Anyone have more?

At 10:39 AM 11/19/2004, you wrote:
>I am receiving an error when trying to run a phantom:
>
>An error has occurred during uniVerse initialization
>  Please contact the system administrator
>  Error code:  1  25
>
>
>I have not been able to find a listing of what the error codes translate to.
>Does anyone have an idea?
>
>Thanks,
>
>Bryan Haglund
>Haglund Consulting Inc.
>---
>u2-users mailing list
>[EMAIL PROTECTED] 
>To unsubscribe please visit http://listserver.u2ug.org/ 
---
u2-users mailing list
[EMAIL PROTECTED] 
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] "thoroughbred basic"

[Don Verhagen]

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 Phone: 561.454.3592 Fax Phone: 561.454.3640 

>>> [EMAIL PROTECTED] 11:27:22 AM 09/29/2004 >>>
Does anyone know the dbms this runs on

Is it PICK based ?


Bob 




__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__
---
u2-users mailing list
[EMAIL PROTECTED] 
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] RedBack "# of responders" configuration

[Don Verhagen]

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 tweaked our production environment's rgwresp.ini to
lower the # of responders (er UDT processes) eaten up by rgwsched. Is
there any sort of rhyme or general rule behind defining a set number
of responders and if so, what is it?

TIA,
Andy Pflueger
Webmaster
Ivy Hill Corp.
Louisville, KY
-- 
Sent using http://gmail.google.com/ :-P
---
u2-users mailing list
[EMAIL PROTECTED] 
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Editors [TEXTPAD]

[Don Verhagen]

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 Fax Phone: 561.454.3640 

>>> [EMAIL PROTECTED] 10:25:09 PM 09/23/2004 >>>
> From: djordan [mailto:[EMAIL PROTECTED] 
> I occasionaly need to edit a type 1 file of around 30-50 
> megabytes.  The problem is most editors want to load the file 
> into memory before working on it.  Does anyone know an editor 
> that would handle big files like this

Emacs can handle 128MB files out of the box.  Bigger with some
tweaking.

http://www.emacswiki.org/cgi-bin/wiki?EmacsFileSizeLimit 

Though you might have to buy more memory just to be able to run emacs
:-)

Textpad is a great windows editor (we have a site licence and install
it on
all systems).  Claims to handle files "up to the limits of virtual
memory".
I know I've edited some very large delimited files with it.  It has
nifty
regular expression search and replace that makes stripping or adding
funny
characters easy.

http://www.textpad.com/products/textpad/features.html 

Hth,
Ian
---
u2-users mailing list
[EMAIL PROTECTED] 
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

OT: [U2] spammed

[Don Verhagen]

-- [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 any return address on an envelope and no one would
ever know it wasn't accurate. Heck, you might still be able to do that in
some cities.
*--
The US post office doesn't track the return address on US mail, it tracks which post 
office it was processed in. You can put *anything* as the return address on a piece of 
mail. Look at the anthrax, mail fraud, and other cases.

Considering one of my US credit card companies preprints *their* address as the return 
address on my payment remittance envelopes is proof enough that it's not illegal, it's 
widespread.


--
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: 561.454.3640 
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UVODBC first query

[Don Verhagen]

I am ammending my answer [grin].  I was thinking of the reverse dns
lookup too (See Adrian.Matthews post), not the user tree being cache.

Hey I remember it caching *something*. So sue me, or better yet hit me
with 3 hurricanes in 1 month (This wasn't was in the disaster recovery
plan!)

Thanks,
Don
(If it's not raining, it's not summer in Florida)


>>> [EMAIL PROTECTED] 4:46:42 AM 09/10/2004 >>>
DISCLAIMER:
This email and any files transmitted with it are confidential and
intended
solely for the use of the individual or entity to whom they are
addressed.
If you have received this email in error, please delete it and notify
the sender immediately.  Please note that there is no guarantee that
this email or any attachment is virus free or has not been intercepted
or amended.

The telnet connections aren't affected by the same delay that the
UVODBC
is.

And as far as I know we are using the server's IP in the UVODBC
configuration.

We also found on Windows servers that including the full path to the
account you are connecting to instead of just the account name also
improves performance, but it still doesn't remove the first query
pause.

Thanks for the suggestions though, I will have a play with the reverse
dns lookups and see if that helps.

Andy Moore
Selima Software Ltd.

-Original Message-
From: Don Verhagen [mailto:[EMAIL PROTECTED] 
Sent: 09 September 2004 17:53
To: [EMAIL PROTECTED] 
Subject: 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?

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 Fax Phone: 561.454.3640 

>>> [EMAIL PROTECTED] 11:44:18 AM 09/09/2004 >>>
We are using UVODBC to connect our web site to our production UV
database and we also experience a FIRST CONNECT lag time. Subsequent
queries are processed almost immediately. We have considered creating
a
routine on the server to periodically query UV so that any user would
hopefully be the SECOND CONNECT.

Garry Smith
Dir. Info Systems
Charles McMurray Company
V# 559-292-5782   F# 559-346-6169

CONFIDENCE NOTICE:
This is an e-mail message, theretofore may have many accompanying
documents, and is truly for the intended recipient(s) and heretofore
may
contain data and information.  Surely any unauthorized review, use,
disclosure, distribution or copying could become arum nauseous.  If
you
are not the intended recipient, please look deep within yourself by
any
means and immediately forgo digesting the original message.

> -Original Message-
> From: Andy Moore [SMTP:[EMAIL PROTECTED] 
> Sent: Thursday, September 09, 2004 3:42 AM
> To:   [EMAIL PROTECTED] 
> Subject:  [U2] UVODBC first query
> 
> We are using a report writer called Bi/Query with Universe via the 
> UVODBC and have noticed that once connected to the database, the
first
> query has a delay of about 20 seconds before it returns any results.
> 
> Further queries after this time run immediately without the delay,
but
> leaving the session without activity for about 5-10 minutes means
that
> the next query again has a 20 second delay before returning any
results.
> 
> We have noticed this on many of our customer sites, has anyone else 
> experienced this delay with the UVODBC or aware of what may cause
this
> or how to fix it?
> 
> Thanks
> 
> 
> Andy Moore
> Selima Software Ltd
> Tel: 0114 2815000
> Fax: 0114 281
> email: [EMAIL PROTECTED] 
> ---
> u2-users mailing list
> [EMAIL PROTECTED] 
> To unsubscribe please visit http://listserver.u2ug.org/ 
---
u2-users mailing list
[EMAIL PROTECTED] 
To unsubscribe please visit http://listserver.u2ug.org/ 
---
u2-users mailing list
[EMAIL PROTECTED] 
To unsubscribe please visit http://listserver.u2ug.org/ 
---
u2-users mailing list
[EMAIL PROTECTED] 
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UVODBC first query

[Don Verhagen]

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?

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 Fax Phone: 561.454.3640 

>>> [EMAIL PROTECTED] 11:44:18 AM 09/09/2004 >>>
We are using UVODBC to connect our web site to our production UV
database
and we also experience a FIRST CONNECT lag time. Subsequent queries
are
processed almost immediately. We have considered creating a routine on
the
server to periodically query UV so that any user would hopefully be
the
SECOND CONNECT.

Garry Smith
Dir. Info Systems
Charles McMurray Company
V# 559-292-5782   F# 559-346-6169

CONFIDENCE NOTICE:
This is an e-mail message, theretofore may have many accompanying
documents,
and is truly for the intended recipient(s) and heretofore may contain
data
and information.  Surely any unauthorized review, use, disclosure,
distribution or copying could become arum nauseous.  If you are not
the
intended recipient, please look deep within yourself by any means and
immediately forgo digesting the original message.

> -Original Message-
> From: Andy Moore [SMTP:[EMAIL PROTECTED] 
> Sent: Thursday, September 09, 2004 3:42 AM
> To:   [EMAIL PROTECTED] 
> Subject:  [U2] UVODBC first query
> 
> We are using a report writer called Bi/Query with Universe via the
> UVODBC and have noticed that once connected to the database, the
first
> query has a delay of about 20 seconds before it returns any results.
> 
> Further queries after this time run immediately without the delay,
but
> leaving the session without activity for about 5-10 minutes means
that
> the next query again has a 20 second delay before returning any
results.
> 
> We have noticed this on many of our customer sites, has anyone else
> experienced this delay with the UVODBC or aware of what may cause
this
> or how to fix it?
> 
> Thanks
> 
> 
> Andy Moore
> Selima Software Ltd
> Tel: 0114 2815000
> Fax: 0114 281
> email: [EMAIL PROTECTED] 
> ---
> u2-users mailing list
> [EMAIL PROTECTED] 
> To unsubscribe please visit http://listserver.u2ug.org/ 
---
u2-users mailing list
[EMAIL PROTECTED] 
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

RE: [OT] [U2] Technical Product Manager opening in Boston (PICK/UniV erse/U2)

[Don Verhagen]

Why is that when someone final posts a "decent" job posting for a
PICK/U2 position, all anyone does is bitch about the post.  Sometimes I
wonder why people would even post a open position.

It's a management position. Like it or not, most of those "positions"
require a degree.

Hell even relocation may be covered (unlike the Denver, Colorado US
one).

Stop bitching and either apply for it or don't.

(Sorry I'm a bit testy after Hurricance Frances and not looking forward
to Hurricance Ivan)

Donald Verhagen
Fort Lauderdale, FL USA
(Running on generator power for 3 days and counting!)

(Am I worse for bitching about the people bitching about the post?)
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] UNIDATA - SAVING UNIQUE and LIST.ALGEBRA

[Don Verhagen]

Is PST.ROOM.ASSIGNMENTS dict item defined as MV (Multivalue) or SV
(Single Valued) item?

I would expect this if it was defined as SV (Single Valued) but really
MV in it.



--
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: 561.454.3640 

>>> [EMAIL PROTECTED] 3:26:54 PM 08/23/2004 >>>
Hi all,

Not a regular here but I was hoping someone could enlighten me with
this
interesting 'feature' of UNIDATA...

If I issue a select statement using saving unique on a mv field of
pointers, then edit the SAVEDLISTS file to check the IDs, I see
something like this... 

SELECT PERSON.ST 3152749 SAVING UNIQUE PST.ROOM.ASSIGNMENTS
SAVE.LIST X.1

AE SAVEDLISTS X.1000

001: 8654y1y1
002: 9490y2y1
003: 9491y3y1

(where 'y' is the value marker)

Why is there y1y1, y2y1, y3y1 appended at the end of each ID?  I'm
guessing it has to do with the saving unique feature or something?

To continue with the issue... 

SELECT PERSON.ST 3152750 SAVING UNIQUE PST.ROOM.ASSIGNMENTS
SAVE.LIST X.2

001: 1443y1y1
002: 2904y2y1
003: 5128y3y1
004: 6743y4y1


LIST.ALGEBRA X.3 = X.1 + X.2

the system returns:

SIZE OF X.1 IS 3
SIZE OF X.2 IS 4
SIZE OF X.3 IS 7

result is stored in 'X.3'

GET.LIST X.3
21 records retrieved to list 0.
>LIST ROOM.ASSIGNMENTS
1443
2904
5128
6743
4
8654
9490
9491
8 records listed
Enter  to print non exist record ids
1
1
2
1
3
1
1
1
1
2
1
3

The LIST.ALGEBRA isn't ignoring what comes after the IDs and creates a
savedlists with every value delimited by the value marker.  I was
expecting a total of 7 records (as indicated by LIST.ALGEBRA), when I
do
the GET.LIST X.3 there are 21 records.

So first, what is the extraneous information at the end of each ID in
the SAVEDLISTS?  If I use a BSELECT instead I do not get this extra
info.

I am merely seeking more information with this whole thing... I was
unaware that 'extra' information is stored when doing a SAVING UNIQUE
and that using savedlists created with SAVING UNIQUE within
LIST.ALGEBRA
causes problems... or am I doing something wrong?  I haven't found any
documentation that denotes the above mentionned issue. 

Thanks for any feedback,
Phil

-- 
Philippe Parent - [EMAIL PROTECTED] 
Programmer Analyst, Administrative Information Services (ITS)
University of New Brunswick
PO Box 4400, Fredericton, NB, Canada, E3B 5A3 
Phone (506) 453 3563 - Fax (506) 453 3590
---
u2-users mailing list
[EMAIL PROTECTED] 
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Pyramid HR

[Don Verhagen]

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. Website: www.fwdco.com 

If you would like to discuss offline please email or call me directly
at the numbers in my signature.

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 Fax Phone: 561.454.3640 

>>> [EMAIL PROTECTED] 9:06:55 AM 08/05/2004 >>>
Has anyone worked on a package called Pyramid HR?  It uses Unidata for
its
database. Any details would be appreciated.

TIA

Steve Kunzman
Minneapolis, MN
(612)750-3899 cellular
---
u2-users mailing list
[EMAIL PROTECTED] 
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

WebEX Recommendation was [U2] Univere Login Security

[Don Verhagen]

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
Delray Beach, FL 33445  USA
Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 

>>> [EMAIL PROTECTED] 12:15:26 PM 08/04/2004 >>>
I recently had a sys admin try to get me to use webex instead of
netmeeting.
He said it works much better because it's browser based.

www.webex.com says they are cross platform (HPUX, Linux etc). It's a
full
blown video-tel-white board conferencing application but from what I
understand you could just use it as a telnet session.

It's a web based version of Net Meeting which I've used as a virtual
console.

They offer a free-trial for 15 days, so if you are willing to be our
guinea
pig you can let us know if it works.

-Original Message-
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED] 
Sent: Wednesday, August 04, 2004 12:45 PM
To: u2-Users
Subject: [U2] Univere Login Security

Hi all,
A buddy of mine wants me to be able to login to his computer on a
routine
basis to give him a hand with some development.  Currently, he has a
process
that matches the ip address to the username and if it does not match,
the
user gets booted.  The problem that I have is that my ip address is
dynamic.
Given the fact that this is a unix machine that I will be logging into,
I
assume that I cannot use a mac address or anything like that,  Can
someone
out there give me a simple and effective solution for this?


Thanks,

Scott
---
u2-users mailing list
[EMAIL PROTECTED] 
To unsubscribe please visit http://listserver.u2ug.org/ 
---
u2-users mailing list
[EMAIL PROTECTED] 
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Unidata 6 XML DTD question

[Don Verhagen]

There astericks signify that the element can appear Zero or more times.

+ = minimum of one occurrence
(nothing) = appears only once within elements
? = zero to one occurrences

More help here:
http://www.xmlfiles.com/dtd/dtd_elements.asp 
 
How Unidata determines this? Got Me. Are any of the (*)elements empty
in the records listed

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 Fax Phone: 561.454.3640 

>>> [EMAIL PROTECTED] 3:20:02 PM 07/01/2004 >>>
Anybody know why, when creating an XML document in a LIST statement
using WITHDTD

you sometimes get  " * " (asterisks) in the DTD.



Ex.



















]>
---
u2-users mailing list
[EMAIL PROTECTED] 
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Universe Database Hang

[Don Verhagen]

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:
>   Do anyone having experience on Universe Database hang. 
> ( note that
> existing user process still able to run the process and 
> access the database
> only user which using new session log to the database will 
> hang over there ?

Not UniVerse, but UniData was doing that to us intermittently.  Nobody
new could log in, but users who were already in didn't experience any
problems.  I don't think we ever figured out what the issue was, but
we
moved up to UD6 and it hasn't happened again.

-- 
Wendy Smoak
Application Systems Analyst, Sr.
ASU IA Information Resources Management 
---
u2-users mailing list
[EMAIL PROTECTED] 
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UniBasic Performance Question

[Don Verhagen]

 EQU V.SEC.SYNONYM TO COURSE.SECTIONS.REC.TABLE
 PRINT.VAR = V.SEC.SYNONYM

verus

PRINT.VAR = COURSE.SECTIONS.REC.TABLE

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 >>>
Fawaz,

No, it won't speed up your app.  It will speed up your getting carpel
tunnel
syndrome.  Equates are used for several purposes.  In this case it
looks as
if they are being used to reduce the number of keystrokes the
programmer
will have to make.

HTH,

Gordon J. Glorfield
Sr. Applications Developer
MAMSI (A UnitedHealth Company)
301-360-8839 



[snip]
> I have a UniBasic program with hundreds of equate
> statements like
>  
> EQU V.SEC.SYNONYM TO COURSE.SECTIONS.REC.TABLE
> 
> and only thing they do is assign it to a PRINT.VAR
> 
> PRINT.VAR = V.SEC.SYNONYM:" ":..
> 
> I am planning to take off the equate and assign the
> variable directly to the PRINT.VAR
> 
> PRINT.VAR =
> COURSE.SECTIONS.REC.TABLE:"
> ":..
> 
> Will this speed up the process? Since we are passing
> the information to .NET with XML tags, any improvement
> to the speed is desirable.
[snip]


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.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users