date:20040127

RE: Looking for Software

2004-01-27 Thread Anthony Youngman

Much as I would love people to start using WordPerfect again ...

The latest WP/Unix I know of is 5.1 for SCO - I would be surprised if
that wasn't revamped, though, to at least v6.

There is a WP8/linux which is a native version. Unfortunately, it is
libc5 based so it's a pain to install on any recent distro (recent as in
the last two or three years at least!). I can email anyone the shareware
version (including licence codes) if they want it, but for commercial
use you need a paid-for licence which will be difficult to get.

WP9 (Perfect Office 2000) was released in a linux version. BUT

This was the version that was rewritten for "Windows only" and supplied
for linux with WINE. Co-incidentally, this was why WINE suddenly
improved so dramatically in this time period - Corel threw loads of
engineering at it because they intended to "WINEify" all their apps.

If I were implementing WP on a linux server, I'd get a copy of the
Windows version (either WP10 or WP9), and run it using standard WINE. 9
will almost certainly work (I haven't tried it), 10 I don't know. Oh -
get a fast server, because you'll need it.

WP10 might be problematic, because this is the time MS threw a few
million $ at Corel to get them to pull out of linux.

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Dawn M. Wolthuis
Sent: 26 January 2004 18:58
To: 'U2 Users Discussion List'
Subject: RE: Looking for Software

Word Perfect used to have a UNIX version -- I don't know if that is
still
available.




***

This transmission is intended for the named recipient only. It may contain private and 
confidential information. If this has come to you in error you must not act on 
anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, 
or show it to anyone. Please e-mail the sender to inform us of the transmission error 
or telephone ECA International immediately and delete the e-mail from your information 
system.

Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong 
Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333.

***

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: [UV] ANALYZE.OBJECT

2004-01-27 Thread Ray Wurlod

The information from $COPYRIGHT is right at the end, except that if there are any $* 
directives, those comments are also in the object code, and follow the $COPYRIGHT 
notice.

- Original Message -
From: "Ray Daignault" <[EMAIL PROTECTED]>
Date: Mon, 26 Jan 2004 10:15:32 -0800
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Subject: Re: [UV] ANALYZE.OBJECT

> Try using VList on the program.  I'm sure copyright info is displayed even
> if source code is not available.
> 
> Ray D
> - Original Message - 
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, January 26, 2004 9:21 AM
> Subject: [UV] ANALYZE.OBJECT
> 
> 
> > In the good old days of Prime INFORMATION, there existed an ANALYZE.OBJECT
> > command.
> >
> > 
> > The object code header is displayed using the ANALYZE.OBJECT command.
> > 
> >
> > I cannot find such a command in UniVerse 10.x (for Windows).
> >
> > Specifically, does anyone know how to view text inserted into object code
> > by the $COPYRIGHT compiler directive (assuming that ANALYZE.OBJECT no
> > longer exists)?
> >
> > Thanks,
> > John Appleyard.
> >
> >
> >
> > ___
> > u2-users mailing list
> > [EMAIL PROTECTED]
> > http://www.oliver.com/mailman/listinfo/u2-users
> >
> 
> ___
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Using CALLHTTP with a Secure site

2004-01-27 Thread Laursen, Mark









List;

 

I am trying to do a CALLHTTP to a secure site. I used the createSecureRequest
and that returned a 0 for status. I then
did the submitRequest to the site with data that I needed to send. I receive a
status of 2 back, which is a timeout error. I
must of missed something. In the createSecureRequest, the security_context I am
sending null, does this need to be something?

 

Thanks 
Mark Laursen 
Marriott Vacation Club International

(863) 688-7700 Ext. 4339

[EMAIL PROTECTED]


This
communication contains information from Marriott International, Inc. that may
be confidential. Except for personal use by the intended recipient or as expressly
authorized by the sender, any person who receives this information is
prohibited from disclosing, copying, distributing, and/or using it. If you have
received this communication in error, please immediately delete it and all
copies, and promptly notify the sender. Nothing in this communication is
intended to operate as an electronic signature under applicable law.

 






___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Looking for Software

2004-01-27 Thread Richard Sammartino



Barrie,  We use DESQTOP from Monolith.  I don't know if the
software is still available.  It is written in PICK basic and will
run under Pick/Unidata/Universe/Prime.  The word processor has a
spell checker and will allow you to update words in the spell check
dictionary.  Some of their software can be embedded and called from
your existing software.
Rich Sammartino
At 01:23 PM 1/26/2004 -0500, you wrote:
Content-class:
urn:content-classes:message
Content-Type: multipart/alternative;
boundary="_=_NextPart_001_01C3E439.85AE210A"
A snowy hello from Maryland.  Does anyone know of a
UniVerse or System Builder Word Processing package?  We require
spell checking, including the input of custom dictionary items and what
MSWord calls AutoCorrect.  This is a process that would take
"shortcut" codes from the input and convert them to previously
defined strings of perhaps technical, medical information.

We currently have our staff enter the document, including
the shortcut codes, in Word, then AutoCorrect it to convert the codes to
text, then use System Builder to transfer the temporary ".txt"
file to a record in one of our UniVerse files.

Thanks for any responses. 
Barrie Matovcik 
MobilexUSA 
410.773.2080 

-- Mobilex USA E-Mail Confidentiality Notice CONFIDENTIALITY NOTICE: This
electronic mail transmission and any accompanying documents are intended
for the use of Mobilex USA or for the use of the named addressee(s) to
which it is directed and may contain information that is privileged or
otherwise confidential. It is not intended for transmission to, or
receipt by, anyone other than the named addressee(s) or a person
authorized to deliver it to the named addressee(s). It should not be
copied or forwarded to any unauthorized persons. If you received this
electronic mail transmission in error, please delete it from your system
without copying or forwarding it and notify the sender of the error by
reply e-mail or by calling Mobilex Privacy Office at 1-866-686-1717 so
that our records can be corrected. 
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Richard Sammartino
Systems Analyst
Information Technology
School District of Philadelphia
734 Schuylkill Avenue
Philadelphia,  PA  19146-2397
Phone: (215) 857-4734
Fax: (215) 893-4243

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Using CALLHTTP with a Secure site

2004-01-27 Thread Wendy Smoak

> From: [EMAIL PROTECTED] 
> I am trying to do a CALLHTTP to a secure site. I used the 
> createSecureRequest and that returned a 0 for status. I then 
> did the submitRequest to the site with data that I needed to 
> send. I receive a status of 2 back, which is a timeout error. 
> I must of missed something. In the createSecureRequest, the 
> security_context I am sending null, does this need to be something?

Does this example help at all?
http://www.pickwiki.com/cgi-bin/wiki.pl?CallHTTPWithSSL

If not, please post a small example that doesn't work and someone can
take a look.

-- 
Wendy Smoak
Application Systems Analyst, Sr.
ASU IA Information Resources Management 
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: [UD] LPTR

2004-01-27 Thread Shawn Waldie

Quick update:

I'm not yet sure what they did, but the network people loaded a patch (or
something). Now all 3 printers are working the way they should.

Thanks again to all for the suggestions.

-Original Message-
From: Mats Carlid [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 22, 2004 1:39 AM
To: [EMAIL PROTECTED]
Subject: Re: [UD] LPTR

Also note there could be _huge_ differences how the printers are configured
(at least if they are laserjets ) totally ruining the output on one of 
them while
the other prints ok.  So print their configs and proofread them against 
each other.
And also check/compare the settings of wheels and dials in the paper trays.

BTW:
Typically  output looks like
aaa

ddd
(each line starts in the column after where the line above ends ) when lines
are separated by LF's without CR's
- unless the printer is configured to convert LF to CRLF or course.

cheers
Mats

Shawn Waldie wrote:

>I'm a little out of my element on this, but I'm sure someone here has 
>the answer.
>
>Right now, if I execute "LIST PERSON LAST.NAME LPTR", this is the 
>output on two of our printers (HPs):
>
>LIST PERSON LAST.NAME LPTR 08:54:17 Jan 21 2004
>   PERSON Last 
>Name
>  010 name1
>  011 name2
>  012 name3
>
>Is this the case where there's a LF and not a CR?
>
>
>On another printer (also HP), the output is what I expected - and want:
>
>LIST PERSON LAST.NAME LPTR 08:57:17 Jan 21 2004
>PERSON Last Name
>   010 name1
>   011 name2
>   012 name3
>
>  
>

>  
>  
>

-- 

Unsubscribe: mailto:[EMAIL PROTECTED]
 or  mailto:[EMAIL PROTECTED]   
Moderator  : mailto:[EMAIL PROTECTED]
Web-site   : http://www.oliver.com/lists/u2

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: UniData memresize for dynamic files

2004-01-27 Thread Doug Miller



You should check out the new commands for handling dynamic parts. 

mvpart
The system-level mvpart command
moves one or more part files of a
dynamic file to a different location. mvpart sets or resets symbolic
links, if
needed, and creates or updates a prefix table (.fil_prefix_tbl) at
the
destination location, if needed. Using mvpart ensures that the links,
file
locations, and prefix tables remain synchronized.
Note: You must stop the UniData daemons (with stopud) before
executing mvpart.
When you are done, you can run the "auditor"
command to make sure everything is in it's place.
http://publibfi.boulder.ibm.com/epubs/pdf/9101.pdf
I only say this as it is safer to use database commands to manipulate the
files.  The main reason why I would recommend this is if IBM decided
to change the rules on how parts are stored in the dynamic files without
your knowledge, the commands should be updated to handle this. 
Otherwise, manually manipulating the pieces in future releases, could
break the files.
Doug
Strategy 7
At 07:07 PM 1/26/2004, you wrote:
If
you are on UNIX, you can symbolically link the parts of a file so they
actually take the space of another file system. This is how I have gotten
around memresizing a 30 gig file. I moved the parts to a different file
system or file systemes. Then I symbolically linked them under the
directory where the VOC pointer says they live to the place where they
physically reside. The memresize then make a rszxx directory where
the VOC pointer says it lives. This rszx directory (where the x
is some uniqueness that Unidata comes up with a resize time), then only
needs 30 gig of free space in the file system, not 60. The memresize will
clean up all the space used by the symbolic links when it is thru. It is
a pain, but I have used it successfully many times. -
Rod

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Text Editor

2004-01-27 Thread Daly, Mark

Thanks everyone for the comments.  I've installed Dynamic Connect and
Unidebugger - and will give it a spin. Initial reaction is that it looks
pretty nice.

-Original Message-
From: Ian Renfrew [mailto:[EMAIL PROTECTED] 
Sent: Saturday, January 24, 2004 9:45 AM
To: [EMAIL PROTECTED]
Subject: Re: Text Editor

I find the latest wIntegrate editor very useful. I've enhanced the
wIntegrate editor upload and download scripts to utilize various U2Object
library functions and subroutines. With the modified scripts you can access
items in directory and hashed files almost instantly using UniObject
technology. No need to deal with traditional wIntegrate file transfer
processes. At the moment, I've ignored the processing involved in the newly
added EditCheck, ItemExists functions.

Regards,  Ian Renfrew

- Original Message - 
From: "Daly, Mark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 22, 2004 11:31 AM
Subject: Text Editor

> Am I right in thinking there is some kind of Windows/GUI text editor 
> available for BASIC authoring??? Is anything included on the client 
> CD?  I don't have it handy.
>
> Thanks.
>
> --
> 
> Unsubscribe: mailto:[EMAIL PROTECTED]
>  or  mailto:[EMAIL PROTECTED]
> Moderator  : mailto:[EMAIL PROTECTED]
> Web-site   : http://www.oliver.com/lists/u2
>
>
>

___
u2-users mailing list
[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

UV Setptr Question

2004-01-27 Thread james . ronan

Hi,
I have a few applications that produce daily reports.  Every now and then,
someone walks off with the print out .  The report can not be recreated.
Is it possible, via SETPTR (or some other setting), to print the report and
keep a copy of the report on the print queue?  I would not want the reports
to accumulate on the queue, but instead get overwritten by the next day's
report. Ideally I would like a non-programming solution

I am running UV 9.6.2.5

Thanks.

Jim


___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: UV Setptr Question

2004-01-27 Thread Jeff Schasny

Send the report to the &HOLD& file and print it from there.  Use the SETPTR
"mode" option number 3 to direct LPTR output to the file instead of a
printer.

Try "HELP SETPTR" at TCL for more info

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 27, 2004 11:23 AM
To: [EMAIL PROTECTED]
Subject: UV Setptr Question

Hi,
I have a few applications that produce daily reports.  Every now and then,
someone walks off with the print out .  The report can not be recreated.
Is it possible, via SETPTR (or some other setting), to print the report and
keep a copy of the report on the print queue?  I would not want the reports
to accumulate on the queue, but instead get overwritten by the next day's
report. Ideally I would like a non-programming solution

I am running UV 9.6.2.5

Thanks.

Jim

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

looking for faster Ideas...

2004-01-27 Thread George Gallen

I can't setup any indexs to speed this up. Basically I'm scanning a CSV file
for names to remove
   and set the flag of KICK=1 to remove it (creating a new CSV file at the
same time).

Keep in mind the ".." are people's last names, or zip codes, or part of
their address, changed
them to ".." to protect the unwanting...

Right now, I do a series of CASE's ...
Now, it's not a major problem as I'm only checking for 20 or so names, but
as more and more people
  request to be removed (and we don't have access to the creation of the
list). this could get quite
  slow over 50 or 60 thousand lines of checking.

LIN is one line of the CSV file, the INDEX is checking for a last name & a
zip code and sometimes
   part of the address line.

Any Ideas?

Remember, we can't change the source of the file, it will always be a CSV,
being read line by line

   KICK=0
   BEGIN CASE
  CASE -1
 KICK=1
 BEGIN CASE
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND
INDEX(LIN,"..",1)#0
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND
INDEX(LIN,"..",1)#0 
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
CASE -1
   KICK=0
 END CASE
   END CASE

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

SLACK Incorporated - An innovative information, education and management
company
http://www.slackinc.com

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: UV Setptr Question

2004-01-27 Thread George Gallen

Title: RE: UV Setptr Question





If you are running this on Unix, you could setup a 'special'
printer queue, that the print filter tee's off the job to
the regular print queue as well as to a unix file.


This would require no programming changes except to change
the printer number the job is sent to.


George



>-Original Message-
>From: Jeff Schasny [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, January 27, 2004 1:24 PM
>To: U2 Users Discussion List
>Subject: RE: UV Setptr Question
>
>
>Send the report to the &HOLD& file and print it from there.  
>Use the SETPTR
>"mode" option number 3 to direct LPTR output to the file instead of a
>printer.
>
>Try "HELP SETPTR" at TCL for more info
>
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, January 27, 2004 11:23 AM
>To: [EMAIL PROTECTED]
>Subject: UV Setptr Question
>
>
>Hi,
>I have a few applications that produce daily reports.  Every 
>now and then,
>someone walks off with the print out .  The report can not be 
>recreated.
>Is it possible, via SETPTR (or some other setting), to print 
>the report and
>keep a copy of the report on the print queue?  I would not 
>want the reports
>to accumulate on the queue, but instead get overwritten by the 
>next day's
>report. Ideally I would like a non-programming solution
>
>I am running UV 9.6.2.5
>
>Thanks.
>
>Jim
>
>
>___
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>___
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>



___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: UV Setptr Question

2004-01-27 Thread Anthony Dzikiewicz

Add ',RETAIN' to the end of the SETPTR and it will remain in the spooler
after a print.  Then it's a usm -r  .  Where  is the 'job number' or
spooler id number to release it for printing.
Anthony

 -Original Message-
From:   [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]  On
Behalf Of [EMAIL PROTECTED]
Sent:   Tuesday, January 27, 2004 1:23 PM
To: [EMAIL PROTECTED]
Subject:UV Setptr Question

Hi,
I have a few applications that produce daily reports.  Every now and then,
someone walks off with the print out .  The report can not be recreated.
Is it possible, via SETPTR (or some other setting), to print the report and
keep a copy of the report on the print queue?  I would not want the reports
to accumulate on the queue, but instead get overwritten by the next day's
report. Ideally I would like a non-programming solution

I am running UV 9.6.2.5

Thanks.

Jim

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: looking for faster Ideas...

2004-01-27 Thread Jeff Schasny

how about keeping a list of excluded names as a record in a file (or as a
flat file in a directory with each name/item/whatever on a line) and reading
it into the program as a dynamic array then doing a locate on the string in
question.  Something like this:


READ ALIST FROM AFILE,SOME-ID ELSE STOP
X = 0
LOOP
   X += 1
   ASTRING = INLIST
UNTIL ASTRING = ''
   LOCATE ASTRING IN ALIST SETTING POS THEN
  DO
  OTHER
  STUFF
   END ELSE
  DONT
   END
REPEAT

Of course of you really want speed then sort the list and use a "BY clause
in the locate

-Original Message-
From: George Gallen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 27, 2004 11:33 AM
To: 'Ardent List'
Subject: looking for faster Ideas...


I can't setup any indexs to speed this up. Basically I'm scanning a CSV file
for names to remove
   and set the flag of KICK=1 to remove it (creating a new CSV file at the
same time).

Keep in mind the ".." are people's last names, or zip codes, or part of
their address, changed
them to ".." to protect the unwanting...

Right now, I do a series of CASE's ...
Now, it's not a major problem as I'm only checking for 20 or so names, but
as more and more people
  request to be removed (and we don't have access to the creation of the
list). this could get quite
  slow over 50 or 60 thousand lines of checking.

LIN is one line of the CSV file, the INDEX is checking for a last name & a
zip code and sometimes
   part of the address line.

Any Ideas?

Remember, we can't change the source of the file, it will always be a CSV,
being read line by line

   KICK=0
   BEGIN CASE
  CASE -1
 KICK=1
 BEGIN CASE
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND
INDEX(LIN,"..",1)#0
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND
INDEX(LIN,"..",1)#0 
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
CASE -1
   KICK=0
 END CASE
   END CASE

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

SLACK Incorporated - An innovative information, education and management
company
http://www.slackinc.com

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: UV Setptr Question

2004-01-27 Thread Jerry Banker

Use the RETAIN option with setptr. We do that with almost all of our
reports. In our night processing we clear the spooler at the beginning with
the SPOOL -CANCEL -ALL TCL command to start out with a cleared spooler so
the spooler doesn't get too many entries.

- Original Message - 
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 27, 2004 12:22 PM
Subject: UV Setptr Question

Hi,
I have a few applications that produce daily reports.  Every now and then,
someone walks off with the print out .  The report can not be recreated.
Is it possible, via SETPTR (or some other setting), to print the report and
keep a copy of the report on the print queue?  I would not want the reports
to accumulate on the queue, but instead get overwritten by the next day's
report. Ideally I would like a non-programming solution

I am running UV 9.6.2.5

Thanks.

Jim

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: looking for faster Ideas...

2004-01-27 Thread Ian McGowan

do it outside basic using

$grep -F -f pattern-file csv-file > remove-file

the pattern file would have the pieces in there.  what if you're
excluding something that's not unique?  "smith" would exclude
"smithers", "smithy". "psmith (one for the wodehouse fans :-)" etc.

i do this with some huge syslog files, and fairly big pattern files and
it's pretty darn quick.  

ian

On Tue, 2004-01-27 at 10:33, George Gallen wrote:
> I can't setup any indexs to speed this up. Basically I'm scanning a CSV
> file
> for names to remove
>and set the flag of KICK=1 to remove it (creating a new CSV file at
> the
> same time).
> 
> Keep in mind the ".." are people's last names, or zip codes, or part of
> their address, changed
> them to ".." to protect the unwanting...
> 
> Right now, I do a series of CASE's ...
> Now, it's not a major problem as I'm only checking for 20 or so names,
> but
> as more and more people
>   request to be removed (and we don't have access to the creation of the
> list). this could get quite
>   slow over 50 or 60 thousand lines of checking.
> 
> LIN is one line of the CSV file, the INDEX is checking for a last name &
> a
> zip code and sometimes
>part of the address line.
> 
> Any Ideas?
> 
> Remember, we can't change the source of the file, it will always be a
> CSV,
> being read line by line
> 
>KICK=0
>BEGIN CASE
>   CASE -1
>  KICK=1
>BEGIN CASE
> CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND
> INDEX(LIN,"..",1)#0
>   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND
> INDEX(LIN,"..",1)#0 
>   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>   CASE -1
>  KICK=0
>END CASE
>END CASE
> 
> George Gallen
> Senior Programmer/Analyst
> Accounting/Data Division
> [EMAIL PROTECTED]
> ph:856.848.1000 Ext 220
> 
> SLACK Incorporated - An innovative information, education and management
> company
> http://www.slackinc.com
> 
> ___
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
-- 
Ian McGowan <[EMAIL PROTECTED]>

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: UV Setptr Question

2004-01-27 Thread Ian McGowan

email them as pdf's - that will solve the problem of print outs walking
away :-)

On Tue, 2004-01-27 at 10:22, [EMAIL PROTECTED] wrote:
> Hi,
> I have a few applications that produce daily reports.  Every now and
> then,
> someone walks off with the print out .  The report can not be recreated.
> Is it possible, via SETPTR (or some other setting), to print the report
> and
> keep a copy of the report on the print queue?  I would not want the
> reports
> to accumulate on the queue, but instead get overwritten by the next
> day's
> report. Ideally I would like a non-programming solution
> 
> I am running UV 9.6.2.5
> 
> Thanks.
> 
> Jim
> 
> 
> ___
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
-- 
Ian McGowan <[EMAIL PROTECTED]>

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: UV Setptr Question

2004-01-27 Thread Donald Kibbey

I use a script that will send the print job to the printer and then convert it into a 
pdf and copy it over to a folder that is serviced by Apache (web server).  That way, 
the reports are kept around in a form that is easily shared.


>>> [EMAIL PROTECTED] 01/27/04 01:22PM >>>
Hi,
I have a few applications that produce daily reports.  Every now and then,
someone walks off with the print out .  The report can not be recreated.
Is it possible, via SETPTR (or some other setting), to print the report and
keep a copy of the report on the print queue?  I would not want the reports
to accumulate on the queue, but instead get overwritten by the next day's
report. Ideally I would like a non-programming solution

I am running UV 9.6.2.5

Thanks.

Jim


___
u2-users mailing list
[EMAIL PROTECTED] 
http://www.oliver.com/mailman/listinfo/u2-users

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: looking for faster Ideas...

2004-01-27 Thread George Gallen

Title: RE: looking for faster Ideas...





I can't just check for names, it has to a name with a specific zip code
and if the name is fairly common, we also add in part of the address to
make sure no one else is weeded out that shouldn't be.


I suppose I could keep two or three arrays, do a specific lookup in each
saving the position, and if all three positions are identicle (asuming all
three arrays have the name, address, zip in the same order) then that would
be a matchThanks


George


>-Original Message-
>From: Jeff Schasny [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, January 27, 2004 1:51 PM
>To: U2 Users Discussion List
>Subject: RE: looking for faster Ideas...
>
>
>how about keeping a list of excluded names as a record in a 
>file (or as a
>flat file in a directory with each name/item/whatever on a 
>line) and reading
>it into the program as a dynamic array then doing a locate on 
>the string in
>question.  Something like this:
>
>
>READ ALIST FROM AFILE,SOME-ID ELSE STOP
>X = 0
>LOOP
>   X += 1
>   ASTRING = INLIST
>UNTIL ASTRING = ''
>   LOCATE ASTRING IN ALIST SETTING POS THEN
>  DO
>  OTHER
>  STUFF
>   END ELSE
>  DONT
>   END
>REPEAT
>
>Of course of you really want speed then sort the list and use 
>a "BY clause
>in the locate
>
>-Original Message-
>From: George Gallen [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, January 27, 2004 11:33 AM
>To: 'Ardent List'
>Subject: looking for faster Ideas...
>
>
>I can't setup any indexs to speed this up. Basically I'm 
>scanning a CSV file
>for names to remove
>   and set the flag of KICK=1 to remove it (creating a new CSV 
>file at the
>same time).
>
>Keep in mind the ".." are people's last names, or zip codes, or part of
>their address, changed
>them to ".." to protect the unwanting...
>
>Right now, I do a series of CASE's ...
>Now, it's not a major problem as I'm only checking for 20 or 
>so names, but
>as more and more people
>  request to be removed (and we don't have access to the 
>creation of the
>list). this could get quite
>  slow over 50 or 60 thousand lines of checking.
>
>LIN is one line of the CSV file, the INDEX is checking for a 
>last name & a
>zip code and sometimes
>   part of the address line.
>
>Any Ideas?
>
>Remember, we can't change the source of the file, it will 
>always be a CSV,
>being read line by line
>
>   KICK=0
>   BEGIN CASE
>  CASE -1
> KICK=1
>    BEGIN CASE
>    CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND
>INDEX(LIN,"..",1)#0
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND
>INDEX(LIN,"..",1)#0 
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE -1
>      KICK=0
>    END CASE
>   END CASE
>
>George Gallen
>Senior Programmer/Analyst
>Accounting/Data Division
>[EMAIL PROTECTED]
>ph:856.848.1000 Ext 220
>
>SLACK Incorporated - An innovative information, education and 
>management
>company
>http://www.slackinc.com
>
>___
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>___
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>



___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: looking for faster Ideas...

2004-01-27 Thread Ian McGowan

or actually, since it seems you want to find everyone *except* the
opt-out-er's:

$grep -v -F -f pattern-file csv-file > process-file

and then work thru the process file.  still have a problem with partial
matches, though...

why not get rid of the csv file and keep a record for each user?  then
you could simply add an atb, OPTOUT, and SELECT DIRECTMAILLIST WITH
OPTOUT = ""?  ah, the csv file must be coming from some outside system.

On Tue, 2004-01-27 at 10:56, Ian McGowan wrote:
> do it outside basic using
> 
> $grep -F -f pattern-file csv-file > remove-file
> 
> the pattern file would have the pieces in there.  what if you're
> excluding something that's not unique?  "smith" would exclude
> "smithers", "smithy". "psmith (one for the wodehouse fans :-)" etc.
> 
> i do this with some huge syslog files, and fairly big pattern files and
> it's pretty darn quick.  
> 
> ian
> 
> On Tue, 2004-01-27 at 10:33, George Gallen wrote:
> > I can't setup any indexs to speed this up. Basically I'm scanning a
> CSV
> > file
> > for names to remove
> >and set the flag of KICK=1 to remove it (creating a new CSV file at
> > the
> > same time).
> > 
> > Keep in mind the ".." are people's last names, or zip codes, or part
> of
> > their address, changed
> > them to ".." to protect the unwanting...
> > 
> > Right now, I do a series of CASE's ...
> > Now, it's not a major problem as I'm only checking for 20 or so names,
> > but
> > as more and more people
> >   request to be removed (and we don't have access to the creation of
> the
> > list). this could get quite
> >   slow over 50 or 60 thousand lines of checking.
> > 
> > LIN is one line of the CSV file, the INDEX is checking for a last name
> &
> > a
> > zip code and sometimes
> >part of the address line.
> > 
> > Any Ideas?
> > 
> > Remember, we can't change the source of the file, it will always be a
> > CSV,
> > being read line by line
> > 
> >KICK=0
> >BEGIN CASE
> >   CASE -1
> >  KICK=1
> >  BEGIN CASE
> > CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND
> > INDEX(LIN,"..",1)#0
> > CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> > CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> > CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> > CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> > CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> > CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> > CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> > CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> > CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> > CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> > CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND
> > INDEX(LIN,"..",1)#0 
> > CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> > CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> > CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> > CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> > CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> > CASE -1
> >KICK=0
> >  END CASE
> >END CASE
> > 
> > George Gallen
> > Senior Programmer/Analyst
> > Accounting/Data Division
> > [EMAIL PROTECTED]
> > ph:856.848.1000 Ext 220
> > 
> > SLACK Incorporated - An innovative information, education and
> management
> > company
> > http://www.slackinc.com
> > 
> > ___
> > u2-users mailing list
> > [EMAIL PROTECTED]
> > http://www.oliver.com/mailman/listinfo/u2-users
-- 
Ian McGowan <[EMAIL PROTECTED]>

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: looking for faster Ideas...

2004-01-27 Thread George Gallen

Title: RE: looking for faster Ideas...





thats why the zip code and sometimes the part of the address
  is used also, the chances of the matching part of the name
  the zip code, and part of the address and NOT being unique
  is extremely low.


Which is also what complicates this.


George


>-Original Message-
>From: Ian McGowan [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, January 27, 2004 1:56 PM
>To: U2 Users Discussion List
>Subject: Re: looking for faster Ideas...
>
>
>do it outside basic using
>
>$grep -F -f pattern-file csv-file > remove-file
>
>the pattern file would have the pieces in there.  what if you're
>excluding something that's not unique?  "smith" would exclude
>"smithers", "smithy". "psmith (one for the wodehouse fans :-)" etc.
>
>i do this with some huge syslog files, and fairly big pattern files and
>it's pretty darn quick.  
>
>ian
>
>On Tue, 2004-01-27 at 10:33, George Gallen wrote:
>> I can't setup any indexs to speed this up. Basically I'm 
>scanning a CSV
>> file
>> for names to remove
>>    and set the flag of KICK=1 to remove it (creating a new 
>CSV file at
>> the
>> same time).
>> 
>> Keep in mind the ".." are people's last names, or zip codes, 
>or part of
>> their address, changed
>> them to ".." to protect the unwanting...
>> 
>> Right now, I do a series of CASE's ...
>> Now, it's not a major problem as I'm only checking for 20 or 
>so names,
>> but
>> as more and more people
>>   request to be removed (and we don't have access to the 
>creation of the
>> list). this could get quite
>>   slow over 50 or 60 thousand lines of checking.
>> 
>> LIN is one line of the CSV file, the INDEX is checking for a 
>last name &
>> a
>> zip code and sometimes
>>    part of the address line.
>> 
>> Any Ideas?
>> 
>> Remember, we can't change the source of the file, it will always be a
>> CSV,
>> being read line by line
>> 
>>    KICK=0
>>    BEGIN CASE
>>   CASE -1
>>  KICK=1
>>   BEGIN CASE
>> CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND
>> INDEX(LIN,"..",1)#0
>>      CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>>      CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>>      CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>>      CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>>      CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>>      CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>>      CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>>      CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>>      CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>>      CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>>      CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND
>> INDEX(LIN,"..",1)#0 
>>      CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>>      CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>>      CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>>      CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>>      CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>>      CASE -1
>>     KICK=0
>>   END CASE
>>    END CASE
>> 
>> George Gallen
>> Senior Programmer/Analyst
>> Accounting/Data Division
>> [EMAIL PROTECTED]
>> ph:856.848.1000 Ext 220
>> 
>> SLACK Incorporated - An innovative information, education 
>and management
>> company
>> http://www.slackinc.com
>> 
>> ___
>> u2-users mailing list
>> [EMAIL PROTECTED]
>> http://www.oliver.com/mailman/listinfo/u2-users
>-- 
>Ian McGowan <[EMAIL PROTECTED]>
>
>___
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>



___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: UV Setptr Question

2004-01-27 Thread George Gallen

Title: RE: UV Setptr Question





even if they didn't walk, there is always the chance that
the printer will jam and destroy the report, ribbon/toner
is low and the report is unreadable, etc..


George


>-Original Message-
>From: Ian McGowan [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, January 27, 2004 1:58 PM
>To: U2 Users Discussion List
>Subject: Re: UV Setptr Question
>
>
>email them as pdf's - that will solve the problem of print outs walking
>away :-)
>
>On Tue, 2004-01-27 at 10:22, [EMAIL PROTECTED] wrote:
>> Hi,
>> I have a few applications that produce daily reports.  Every now and
>> then,
>> someone walks off with the print out .  The report can not 
>be recreated.
>> Is it possible, via SETPTR (or some other setting), to print 
>the report
>> and
>> keep a copy of the report on the print queue?  I would not want the
>> reports
>> to accumulate on the queue, but instead get overwritten by the next
>> day's
>> report. Ideally I would like a non-programming solution
>> 
>> I am running UV 9.6.2.5
>> 
>> Thanks.
>> 
>> Jim
>> 
>> 
>> ___
>> u2-users mailing list
>> [EMAIL PROTECTED]
>> http://www.oliver.com/mailman/listinfo/u2-users
>-- 
>Ian McGowan <[EMAIL PROTECTED]>
>
>___
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>



___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: looking for faster Ideas...

2004-01-27 Thread George Gallen

Title: RE: looking for faster Ideas...



in 
rethinking my take on that. That would still be difficult
since 
the arrays would only contain "parts" of the whole fields.
making 
the searching of the arrays very difficult.
 
We 
can't store the exact entry, since sometimes people will
call 
and say stop sending me things and not give us the name
the 
same way it's in the database we rent.
 
Basically it takes the renting company a couple months to 
remove
the 
name, but we like to filter it immediately to stop anything
from 
going out before the renting company removes it, and it
also 
will catch it if the renting company replaces it in a couple
months 
later
 
George
 
 -Original Message-From: 
George Gallen [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 27, 
2004 2:06 PMTo: 'U2 Users Discussion List'Subject: RE: 
looking for faster Ideas...

  I can't just check for names, it has to a name with a specific 
  zip code and if the name is fairly common, we also add 
  in part of the address to make sure no one else is 
  weeded out that shouldn't be. 
  I suppose I could keep two or three arrays, do a specific 
  lookup in each saving the position, and if all three 
  positions are identicle (asuming all three arrays have 
  the name, address, zip in the same order) then that would be a matchThanks 
  George 
  >-Original Message- >From: Jeff Schasny [mailto:[EMAIL PROTECTED]] 
  >Sent: Tuesday, January 27, 2004 1:51 PM >To: U2 Users Discussion List >Subject: 
  RE: looking for faster Ideas... > > >how about keeping a list of excluded 
  names as a record in a >file (or as a 
  >flat file in a directory with each name/item/whatever on 
  a >line) and reading >it 
  into the program as a dynamic array then doing a locate on >the string in >question.  Something 
  like this: > > 
  >READ ALIST FROM AFILE,SOME-ID ELSE STOP >X = 0 >LOOP >   X += 1 >   
  ASTRING = INLIST >UNTIL ASTRING = 
  '' >   LOCATE ASTRING IN ALIST SETTING 
  POS THEN >  DO 
  >  OTHER >  STUFF >   END ELSE >  DONT >   END >REPEAT 
  > >Of course of you really want 
  speed then sort the list and use >a "BY 
  clause >in the locate > >-Original Message- 
  
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: ODBC Set Up Universe

2004-01-27 Thread John Reid

Group,

I had the trigger on a table on a development system until it got
overwritten on the week-end. However, we never had a file named
HS_FILE_ACCESS.  I had created it, but I don't feel that its presence had
much to do with whatever success I had. Is it supposed to 'MATERIALIZE'?
   
My objective is to create a trigger on an existing file.  Try as I might, I
am unable to re-create what I did before.  Could someone go over the steps
one more time?  And possibly, could someone state the function of the
HS.UPDATE.FILEINFO?

I'm not against reading what ever I need to read, but it seems that at least
some people have had negative rewards for their reading efforts. 
thanks.
john reid

-Original Message-
From: Tony Wood [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 22, 2004 5:57 PM
To: [EMAIL PROTECTED]
Subject: Re: ODBC Set Up Universe

Anthony,

Do you have NLS turned on?

Does anyone have NLS turned on with ODBC on UniVerse?

Regards,

T.

- Original Message - 
From: "Anthony Dzikiewicz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 23, 2004 1:58 AM
Subject: RE: ODBC Set Up Universe


> Thanks for the replys on this issue.  The problem was that I did a CREATE
> SCHEMA in the account I was connecting to.  I must have done this because
I
> was reading thru the ODBC guide and the SQL docs and merged the two in my
> brain.  Anyway, I guess if the account is a schema, then the files must be
> present in the UV_TABLES file.  So, my fix was to DROP SCHEMA in the
> account.  I then 'undid' the ODBC access and started from scratch without
> the CREATE SCHEMA.  Now, I can see the files.  Now it is just a matter of
> the HS_FILE_ACCESS and @SELECT that was mentioned.  I placed a piece of
red
> tape over the CREATE SCHEMA button so this wont happen again.
> Thanks
> Anthony
>
>  -Original Message-
> From: Anthony Dzikiewicz [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 21, 2004 4:52 PM
> To: [EMAIL PROTECTED]
> Subject: RE: ODBC Set Up Universe
>
> OK I just got back to messing with the ODBC problem.  There was one file
in
> particular that I was trying to make accessible called 'CR.TRANS'.  I did
> everything by the book and I still cant access it.  As I mentioned, I
didn't
> see this file listed in UV_TABLES.  There was a HS_FILE_ACCESS created in
> the account.  Anyway, I thought to just create a new file.  So I did.  I
did
> it thru the SQL command 'CREATE TABLE ANTHONY (MY_KEY PRIMARY KEY); I did
a
> HS.UPDATE.FILEINFO.  I tried again via Microsoft query and I was able to
see
> ANTHONY with MY_KEY as a field.  It worked !  I also noticed that
UV_TABLES
> has a new entry for this file.  So, it looks like what I missed is the
fact
> that files that need to be accessible via ODBC should have entries in the
> UV_TABLES file.  Is this true ?  If so, is there a utility that can get an
> existing file added as a table ?  Obviously, I cant CREATE TABLE to do
this.
> The file(s) already exist.  Id rather not have to do REVISE UV_TABLES and
> have to type everything manually.  So, what did I miss in the part about
> converting existing accounts into schemas ?  Does any one know the magic
> word to get existing files into the ODBC arena ?
> Thanks
> Anthony Dzikiewicz
>
>  -Original Message-
> From: Anthony Youngman [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 21, 2004 5:39 AM
> To: [EMAIL PROTECTED]
> Subject: RE: ODBC Set Up Universe
>
> And make sure that you don't have more files than you need in the
> account. HS.SCRUB has a habit of abending without any errors (UV 9.6),
> which can be a real pig when you're wondering why a certain file does
> not appear to be exported ... there's a system multi-level file that
> seems always to cause us grief. Can't remember what it's called - we
> delete the voc pointer every time we see it - something to do with pterm
> iirc.
>
> -Original Message-
> From: Jeff Schasny [mailto:[EMAIL PROTECTED]
> Sent: 20 January 2004 21:56
> To: [EMAIL PROTECTED]
> Subject: RE: ODBC Set Up Universe
>
> Dictionarys of the files you wish to access must have an @SELECT "PH"
> item
> listing the fields that will be accessable in attribute 2 seperated by
> spaces. Like this:
>
> DICT ENAMES02:52:08pm  20 Jan 2004  Page1
>
>
>
>Type &
>
> Field. Field. Field Conversion.. Column. Output
> Depth &
> Name.. Number Definition... Code Heading Format
> Assoc..
>
>
> @IDD0ENAMES  10L
> S
>
> NAME   D1NAME35L
> S
>
> PW D2PW  12L
> S
>
> @SELECTPH NAME PW
>
> When you get these items created you will need to execute the
> HS.UPDATE.FILEINFO command from tcl.
> CREATE.SCHEMA & SCRUB are nice but not necessary
>
>
> -Original Message-
> From: Anthony Dzikiewicz [mailto:[EMAIL PROTECTED]

RE: looking for faster Ideas...

2004-01-27 Thread Ian McGowan

if speed is the issue, sounds like a job for a compiled lanuage. or
semi-compiled like perl or python.

is there a unique number sent over by the other system?  it might be
quicker to parse the whole thing and keep an exclude file keyed off the
unique number.  if it weren't for embedded comma's you could CONVERT ","
TO @AM, extract the key and write the record out as-is.  that would be
quicker than 852 INDEX's :-)

On Tue, 2004-01-27 at 11:05, George Gallen wrote:
> I can't just check for names, it has to a name with a specific zip code 
> and if the name is fairly common, we also add in part of the address to 
> make sure no one else is weeded out that shouldn't be. 
> 
> I suppose I could keep two or three arrays, do a specific lookup in each
> 
> saving the position, and if all three positions are identicle (asuming
> all 
> three arrays have the name, address, zip in the same order) then that
> would 
> be a matchThanks 
> 
> George 
> 
> >-Original Message- 
> >From: Jeff Schasny [ mailto:[EMAIL PROTECTED]
>  ] 
> >Sent: Tuesday, January 27, 2004 1:51 PM 
> >To: U2 Users Discussion List 
> >Subject: RE: looking for faster Ideas... 
> > 
> > 
> >how about keeping a list of excluded names as a record in a 
> >file (or as a 
> >flat file in a directory with each name/item/whatever on a 
> >line) and reading 
> >it into the program as a dynamic array then doing a locate on 
> >the string in 
> >question.  Something like this: 
> > 
> > 
> >READ ALIST FROM AFILE,SOME-ID ELSE STOP 
> >X = 0 
> >LOOP 
> >   X += 1 
> >   ASTRING = INLIST 
> >UNTIL ASTRING = '' 
> >   LOCATE ASTRING IN ALIST SETTING POS THEN 
> >  DO 
> >  OTHER 
> >  STUFF 
> >   END ELSE 
> >  DONT 
> >   END 
> >REPEAT 
> > 
> >Of course of you really want speed then sort the list and use 
> >a "BY clause 
> >in the locate 
> > 
> >-Original Message- 
> >From: George Gallen [ mailto:[EMAIL PROTECTED]
>  ] 
> >Sent: Tuesday, January 27, 2004 11:33 AM 
> >To: 'Ardent List' 
> >Subject: looking for faster Ideas... 
> > 
> > 
> >I can't setup any indexs to speed this up. Basically I'm 
> >scanning a CSV file 
> >for names to remove 
> >   and set the flag of KICK=1 to remove it (creating a new CSV 
> >file at the 
> >same time). 
> > 
> >Keep in mind the ".." are people's last names, or zip codes, or part of
> 
> >their address, changed 
> >them to ".." to protect the unwanting... 
> > 
> >Right now, I do a series of CASE's ... 
> >Now, it's not a major problem as I'm only checking for 20 or 
> >so names, but 
> >as more and more people 
> >  request to be removed (and we don't have access to the 
> >creation of the 
> >list). this could get quite 
> >  slow over 50 or 60 thousand lines of checking. 
> > 
> >LIN is one line of the CSV file, the INDEX is checking for a 
> >last name & a 
> >zip code and sometimes 
> >   part of the address line. 
> > 
> >Any Ideas? 
> > 
> >Remember, we can't change the source of the file, it will 
> >always be a CSV, 
> >being read line by line 
> > 
> >   KICK=0 
> >   BEGIN CASE 
> >  CASE -1 
> > KICK=1 
> >BEGIN CASE 
> >CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND 
> >INDEX(LIN,"..",1)#0 
> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND 
> >INDEX(LIN,"..",1)#0 
> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
> >   CASE -1 
> >  KICK=0 
> >END CASE 
> >   END CASE 
> > 
> >George Gallen 
> >Senior Programmer/Analyst 
> >Accounting/Data Division 
> >[EMAIL PROTECTED] 
> >ph:856.848.1000 Ext 220 
> > 
> >SLACK Incorporated - An innovative information, education and 
> >management 
> >company 
> > http://www.slackinc.com   
> > 
> >___ 
> >u2-users mailing list 
> >[EMAIL PROTECTED] 
> > http://www.oliver.com/mailman/listinfo/u2-users
>   
> >___ 
> >u2-users mailing list 
> >[EMAIL PR

[UV] SP.STATUS Error

2004-01-27 Thread Cross, Thomas J

Has anyone seen this

SP.STATUS then Option #1

   
Program "SP.STATUS.B": pc = 1002, Fatal error has occured.

HPUX 11i 

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: [UV] SP.STATUS Error

2004-01-27 Thread Hennessey, Mark F.




Has anyone seen this

SP.STATUS then Option #1


Off the top of my head...  Do a CONFIG ALL, then check the permissions in the 
directory listed for UVSPOOL.  Do any other options work?
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: looking for faster Ideas...

2004-01-27 Thread Ian McGowan

On Tue, 2004-01-27 at 11:12, George Gallen wrote:
> in rethinking my take on that. That would still be difficult
> since the arrays would only contain "parts" of the whole fields.
> making the searching of the arrays very difficult.

ah, then you can't use grep or INDEX on the unparsed line - you have to
parse the line into records first.  some kind of unique key (phone
number?) would be helpful, but you could always have an exclude file
keyed on last name, with an MV list of zip codes: 

MCGOWAN
94111]94598]40210

and exclude them in your program:

LOOP
GOSUB READ.NEXT.LINE
IF DONE THEN EXIT
GOSUB PARSE.LINE
NAME=REC<2>
ZIP=REC<23>
READ EXCLUDE.ZIPS FROM EXCLUDE.FILE, NAME THEN
LOCATE ZIP IN EXCLUDE.ZIPS<1> SETTING POS THEN CONTINUE
END
... MORE PROCESSING ...
REPEAT

-- 
Ian McGowan <[EMAIL PROTECTED]>

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: looking for faster Ideas...

2004-01-27 Thread Mike Rajkowski

Title: RE: looking for faster Ideas...









Create a temp file, and populate it with
variations of the name in question (upcase and remove
spaces).  (Storing address
information in each record)

 

Then loop through your list, taking the
name, and parsing the various combinations of the words.  

( John David Doe  - JOHNDOE,
DOEJOHN JOHNDAVIDDOE, JOHNDOEDAVID)

 

And attempt to read the item from the temp
file, if it can read an item then verify the address information.  Otherwise check the next item.

 

 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of George Gallen
Sent: Tuesday, January 27, 2004
12:13 PM
To: 'U2 Users Discussion List'
Subject: RE: looking for faster
Ideas...

 



in rethinking my take on
that. That would still be difficult





since the arrays would
only contain "parts" of the whole fields.





making the searching of
the arrays very difficult.





 





We can't store the exact
entry, since sometimes people will





call and say stop sending
me things and not give us the name





the same way it's in the
database we rent.





 





Basically it takes the
renting company a couple months to remove





the name, but we like to
filter it immediately to stop anything





from going out before the
renting company removes it, and it





also will catch it if the
renting company replaces it in a couple





months later





 





George





 





 -Original Message-
From: George Gallen
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 27, 2004
2:06 PM
To: 'U2 Users Discussion List'
Subject: RE: looking for faster
Ideas...





I can't just check for names, it has to a name with a
specific zip code 
and if the name is fairly common,
we also add in part of the address to 
make sure no one else is weeded out
that shouldn't be. 

I suppose I could keep two or three arrays, do a
specific lookup in each 
saving the position, and if all
three positions are identicle (asuming all 
three arrays have the name,
address, zip in the same order) then that would 
be a matchThanks 

George 

>-Original Message- 
>From: Jeff Schasny [mailto:[EMAIL PROTECTED]]

>Sent: Tuesday, January 27, 2004
1:51 PM 
>To: U2 Users Discussion List

>Subject: RE: looking for faster
Ideas... 
> 
> 
>how about keeping a list of
excluded names as a record in a 
>file (or as a 
>flat file in a directory with
each name/item/whatever on a 
>line) and reading

>it into the program as a
dynamic array then doing a locate on 
>the string in 
>question.  Something like
this: 
> 
> 
>READ ALIST FROM AFILE,SOME-ID
ELSE STOP 
>X = 0 
>LOOP 
>   X += 1

>   ASTRING =
INLIST 
>UNTIL ASTRING = ''

>   LOCATE ASTRING IN
ALIST SETTING POS THEN 
> 
DO 
> 
OTHER 
> 
STUFF 
>   END ELSE

> 
DONT 
>   END 
>REPEAT 
> 
>Of course of you really want
speed then sort the list and use 
>a "BY clause

>in the locate 
> 
>-Original Message-










___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: [UV] SP.STATUS Error

2004-01-27 Thread Cross, Thomas J

That was it. Thanks Mark

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Hennessey, Mark F.
Sent: Tuesday, January 27, 2004 2:28 PM
To: U2 Users Discussion List
Subject: RE: [UV] SP.STATUS Error

Has anyone seen this

SP.STATUS then Option #1

Off the top of my head...  Do a CONFIG ALL, then check the permissions in the 
directory listed for UVSPOOL.  Do any other options work?
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: looking for faster Ideas...

2004-01-27 Thread George Gallen

Title: RE: looking for faster Ideas...





sometimes there is a number, but rarely, are we given
the number when requested to remove, usually just
remove me from your $^&#^$*&$ mailing :) some add please.


I considered PERL as a pre-processor to remove the names
then pass that file to my program which does other stuff
too


George


>-Original Message-
>From: Ian McGowan [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, January 27, 2004 2:22 PM
>To: U2 Users Discussion List
>Subject: RE: looking for faster Ideas...
>
>
>if speed is the issue, sounds like a job for a compiled lanuage. or
>semi-compiled like perl or python.
>
>is there a unique number sent over by the other system?  it might be
>quicker to parse the whole thing and keep an exclude file keyed off the
>unique number.  if it weren't for embedded comma's you could 
>CONVERT ","
>TO @AM, extract the key and write the record out as-is.  that would be
>quicker than 852 INDEX's :-)
>
>On Tue, 2004-01-27 at 11:05, George Gallen wrote:
>> I can't just check for names, it has to a name with a 
>specific zip code 
>> and if the name is fairly common, we also add in part of the 
>address to 
>> make sure no one else is weeded out that shouldn't be. 
>> 
>> I suppose I could keep two or three arrays, do a specific 
>lookup in each
>> 
>> saving the position, and if all three positions are 
>identicle (asuming
>> all 
>> three arrays have the name, address, zip in the same order) then that
>> would 
>> be a matchThanks 
>> 
>> George 
>> 
>> >-Original Message- 
>> >From: Jeff Schasny [ mailto:[EMAIL PROTECTED]
>>  ] 
>> >Sent: Tuesday, January 27, 2004 1:51 PM 
>> >To: U2 Users Discussion List 
>> >Subject: RE: looking for faster Ideas... 
>> > 
>> > 
>> >how about keeping a list of excluded names as a record in a 
>> >file (or as a 
>> >flat file in a directory with each name/item/whatever on a 
>> >line) and reading 
>> >it into the program as a dynamic array then doing a locate on 
>> >the string in 
>> >question.  Something like this: 
>> > 
>> > 
>> >READ ALIST FROM AFILE,SOME-ID ELSE STOP 
>> >X = 0 
>> >LOOP 
>> >   X += 1 
>> >   ASTRING = INLIST 
>> >UNTIL ASTRING = '' 
>> >   LOCATE ASTRING IN ALIST SETTING POS THEN 
>> >  DO 
>> >  OTHER 
>> >  STUFF 
>> >   END ELSE 
>> >  DONT 
>> >   END 
>> >REPEAT 
>> > 
>> >Of course of you really want speed then sort the list and use 
>> >a "BY clause 
>> >in the locate 
>> > 
>> >-Original Message- 
>> >From: George Gallen [ mailto:[EMAIL PROTECTED]
>>  ] 
>> >Sent: Tuesday, January 27, 2004 11:33 AM 
>> >To: 'Ardent List' 
>> >Subject: looking for faster Ideas... 
>> > 
>> > 
>> >I can't setup any indexs to speed this up. Basically I'm 
>> >scanning a CSV file 
>> >for names to remove 
>> >   and set the flag of KICK=1 to remove it (creating a new CSV 
>> >file at the 
>> >same time). 
>> > 
>> >Keep in mind the ".." are people's last names, or zip 
>codes, or part of
>> 
>> >their address, changed 
>> >them to ".." to protect the unwanting... 
>> > 
>> >Right now, I do a series of CASE's ... 
>> >Now, it's not a major problem as I'm only checking for 20 or 
>> >so names, but 
>> >as more and more people 
>> >  request to be removed (and we don't have access to the 
>> >creation of the 
>> >list). this could get quite 
>> >  slow over 50 or 60 thousand lines of checking. 
>> > 
>> >LIN is one line of the CSV file, the INDEX is checking for a 
>> >last name & a 
>> >zip code and sometimes 
>> >   part of the address line. 
>> > 
>> >Any Ideas? 
>> > 
>> >Remember, we can't change the source of the file, it will 
>> >always be a CSV, 
>> >being read line by line 
>> > 
>> >   KICK=0 
>> >   BEGIN CASE 
>> >  CASE -1 
>> > KICK=1 
>> >    BEGIN CASE 
>> >    CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND 
>> >INDEX(LIN,"..",1)#0 
>> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND 
>> >INDEX(LIN,"..",1)#0 
>> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>> >   CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>> >

RE: looking for faster Ideas...

2004-01-27 Thread George Gallen

Title: RE: looking for faster Ideas...



Mike, 
doing what you propose would require a massive file to start with, 
and
would 
require a crap load of disk reads, which would be far slower then a 
bunch
of 
cases, and the project isn't worth that kind of investment anyway. But 
thanks.
 
the 
source line would look something like
 
"","jon c smith","1234 anywhere 
st","","","somecity","SS","12345-1254",""
 
I'm 
looking for "smith" & "12345" and sometimes "anywhere"
 
We may 
get a call from john smith (john not jon because they
didn't 
spell their first name), didn't leave their middle init and
didn't 
give us their 9 digit zip, only 5 digit zip.
 
So I 
can't build any indexes. Searching for multiple pieces on the same 
line
   pretty  much gives a fairly good matchup considing the 
source and match
   data aren't EXACTLY the same.
 
Any of 
course, I'm not going to go hog wild in doing this. Creating a 
temp
file, 
parsing into dynamic arrays loops and lookups...way too much, 
rather
just 
use PERL to pre-process.

  -Original Message-From: Mike Rajkowski 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 27, 2004 
  2:41 PMTo: U2 Users Discussion ListSubject: RE: looking 
  for faster Ideas...
  
  Create a temp file, 
  and populate it with variations of the name in question (upcase and remove spaces).  (Storing address information in each 
  record)
   
  Then loop through 
  your list, taking the name, and parsing the various combinations of the words. 
   
  ( 
  John David Doe  - JOHNDOE, DOEJOHN JOHNDAVIDDOE, 
  JOHNDOEDAVID)
   
  And attempt to read 
  the item from the temp file, if it can read an item then verify the address 
  information.  Otherwise check the 
  next item.
   
   
  -Original 
  Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George GallenSent: Tuesday, January 27, 2004 12:13 
  PMTo: 'U2 Users Discussion 
  List'Subject: RE: looking 
  for faster Ideas...
   
  
  in 
  rethinking my take on that. That would still be 
  difficult
  
  since 
  the arrays would only contain "parts" of the whole 
  fields.
  
  making 
  the searching of the arrays very difficult.
  
   
  
  We can't 
  store the exact entry, since sometimes people 
  will
  
  call and 
  say stop sending me things and not give us the 
  name
  
  the same 
  way it's in the database we rent.
  
   
  
  Basically it takes 
  the renting company a couple months to 
  remove
  
  the 
  name, but we like to filter it immediately to stop 
  anything
  
  from 
  going out before the renting company removes it, and 
  it
  
  also 
  will catch it if the renting company replaces it in a 
  couple
  
  months 
  later
  
   
  
  George
  
   
  
   -Original Message-From: George Gallen 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 27, 2004 2:06 
  PMTo: 'U2 Users Discussion 
  List'Subject: RE: looking 
  for faster Ideas...
  
I can't just check for names, it has to a name with 
a specific zip code and if the name is fairly common, we also add in 
part of the address to make sure no one else is weeded out that shouldn't 
be. 
I suppose I could keep two or three arrays, do a 
specific lookup in each saving the position, and if all three positions are 
identicle (asuming all three arrays have the name, address, zip in the same 
order) then that would be a matchThanks 
George 
>-Original Message- 
>From: Jeff Schasny [mailto:[EMAIL PROTECTED]] 
>Sent: Tuesday, January 
27, 2004 1:51 PM >To: U2 Users Discussion List 
>Subject: RE: looking for 
faster Ideas... > > >how about keeping a list of excluded names as a 
record in a >file (or as a >flat file in a directory with each 
name/item/whatever on a >line) and reading >it into the program as a dynamic 
array then doing a locate on >the string in >question.  Something like 
this: > > >READ ALIST FROM AFILE,SOME-ID ELSE 
STOP >X = 
0 >LOOP >   X += 1 >   ASTRING = 
INLIST >UNTIL ASTRING = '' >   LOCATE ASTRING IN 
ALIST SETTING POS THEN >  DO 
>  
OTHER >  
STUFF >   END ELSE >  
DONT >   END >REPEAT > >Of course of you really want speed 
then sort the list and use >a "BY clause >in the locate 
> >-Original 
Message- 

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: looking for faster Ideas...

2004-01-27 Thread George Gallen

Title: RE: looking for faster Ideas...



keep 
in mind, it's not the renting company that is
giveing us the remove infomation, it's the consumer,
and of 
course they never have the mailing piece in 
their 
hand. Although usually, if they call, we can get
the 
specific info we are looking for which can change
the 
case to one check.
 
But 
when the info is mailed in or emailed in or left on
a 
voice mail, that's when we run into not having the
best 
data to go with. Calling/emailing/mailing them
back 
usually just increases the annoyance level on
their 
end, since we are contacting them Again..
 
George

  -Original Message-From: George Gallen 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 27, 2004 2:51 
  PMTo: 'U2 Users Discussion List'Subject: RE: looking for 
  faster Ideas...
  sometimes there is a number, but rarely, are we given 
  the number when requested to remove, usually just 
  remove me from your $^&#^$*&$ mailing :) some add 
  please. 
  I considered PERL as a pre-processor to remove the 
  names then pass that file to my program which does 
  other stuff too 
  George 
  >-Original Message- >From: Ian McGowan [mailto:[EMAIL PROTECTED]] 
  >Sent: Tuesday, January 27, 2004 2:22 PM >To: U2 Users Discussion List >Subject: 
  RE: looking for faster Ideas... > > >if speed is the issue, sounds like a 
  job for a compiled lanuage. or >semi-compiled like 
  perl or python. > >is 
  there a unique number sent over by the other system?  it might be 
  >quicker to parse the whole thing and keep an exclude file 
  keyed off the >unique number.  if it weren't 
  for embedded comma's you could >CONVERT "," 
  >TO @AM, extract the key and write the record out 
  as-is.  that would be >quicker than 852 
  INDEX's :-) > >On Tue, 
  2004-01-27 at 11:05, George Gallen wrote: >> I 
  can't just check for names, it has to a name with a >specific zip code >> and if the name 
  is fairly common, we also add in part of the >address to >> make sure no one else 
  is weeded out that shouldn't be. >> 
  >> I suppose I could keep two or three arrays, 
  do a specific >lookup in each >> >> saving the position, and if 
  all three positions are >identicle (asuming 
  >> all >> three arrays 
  have the name, address, zip in the same order) then that >> would >> be a matchThanks 
  >> >> George 
  >> >> 
  >-Original Message- >> >From: Jeff 
  Schasny [ mailto:[EMAIL PROTECTED] 
  >>  ] 
  >> >Sent: Tuesday, January 27, 2004 1:51 PM 
  >> >To: U2 Users Discussion List 
  >> >Subject: RE: looking for faster Ideas... 
  >> > >> > 
  >> >how about keeping a list of excluded 
  names as a record in a >> >file (or as a 
  >> >flat file in a directory with each 
  name/item/whatever on a >> >line) and reading 
  >> >it into the program as a dynamic array 
  then doing a locate on >> >the string in 
  >> >question.  Something like this: 
  >> > >> > 
  >> >READ ALIST FROM AFILE,SOME-ID ELSE STOP 
  >> >X = 0 >> 
  >LOOP >> >   X += 1 
  >> >   ASTRING = INLIST 
  >> >UNTIL ASTRING = '' >> >   LOCATE ASTRING IN ALIST SETTING POS THEN 
  >> >  DO 
  >> >  OTHER 
  >> >  STUFF 
  >> >   END ELSE >> >  DONT >> >   END >> 
  >REPEAT >> > >> >Of course of you really want speed then sort the list and 
  use >> >a "BY clause >> >in the locate >> > 
  >> >-Original Message- 
  >> >From: George Gallen [ mailto:[EMAIL PROTECTED] 
  >>  ] 
  >> >Sent: Tuesday, January 27, 2004 11:33 AM 
  >> >To: 'Ardent List' >> >Subject: looking for faster Ideas... >> > >> > >> >I can't setup any indexs to speed this up. Basically I'm 
  >> >scanning a CSV file >> >for names to remove >> 
  >   and set the flag of KICK=1 to remove it (creating a new CSV 
  >> >file at the >> >same time). >> > 
  >> >Keep in mind the ".." are people's last 
  names, or zip >codes, or part of >> >> >their address, changed 
  >> >them to ".." to protect the unwanting... 
  >> > >> 
  >Right now, I do a series of CASE's ... >> 
  >Now, it's not a major problem as I'm only checking for 20 or 
  >> >so names, but >> >as more and more people >> 
  >  request to be removed (and we don't have access to the 
  >> >creation of the >> >list). this could get quite >> >  slow over 50 or 60 thousand lines of checking. 
  >> > >> >LIN 
  is one line of the CSV file, the INDEX is checking for a >> >last name & a >> >zip 
  code and sometimes >> >   part of 
  the address line. >> > >> >Any Ideas? >> > 
  >> >Remember, we can't change the source of 
  the file, it will >> >always be a CSV, 
  >> >being read line by line >> > >> >   KICK=0 
  >> >   BEGIN CASE >> >  CASE -1 >> > KICK=1 
  >> 
  >    BEGIN CASE >> 
  >    CASE 
  INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND >> >INDEX(LIN,"..",1)#0 >> 
  >   CASE 
  INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 >> 
  >   CASE 
  INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 >> 
  >   CASE

Uniobjects in C#

2004-01-27 Thread Carl Sadlier

Has any one used UniObjects and C#? I am a VB programmer and having a hard
time defining, right now, the Command method of the unioaiflib control.
Thanks,
Carl
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: looking for faster Ideas...

2004-01-27 Thread Jeff Schasny

What? As opposed to Uni/UV/Pick Basic? Surprise! it compiles to psudocode
just like java. Now if you were to have proposed "C", Fortran, Assembler,
etc I could see your point.

-Original Message-
From: Ian McGowan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 27, 2004 12:22 PM
To: U2 Users Discussion List
Subject: RE: looking for faster Ideas...

if speed is the issue, sounds like a job for a compiled lanuage. or
semi-compiled like perl or python.

[snip]
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

uvsql and Dynamic files

2004-01-27 Thread Barry Rogen


   We have an ORDER file in our uvsql account. This file is 
  a dynamic file. The select statement below works fine.
  however ---
   If I run that same select statement, but use a  q-pointer 
  to the ORDER file in my production UV account, it chokes on the 
  'LIKE' statement.

SELECT @ID, F1, F2, F31, F32, F35, F36, F150, F24 FROM ORDER

WHERE @ID LIKE '1234567';


   The error message is...

The LIKE operator may only be used with character data


  Any ideas will be  mucho appreciated.


Barry Rogen
Senior Programmer
PNY  Technologies
(973) 515 - 9700  ext 5327
[EMAIL PROTECTED]
_
The quality of a person's life is in direct
proportion to their commitment to excellence
regardless of their chosen field of endeavor
   vince lombardi
_

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: looking for faster Ideas...

2004-01-27 Thread George Gallen

Title: RE: looking for faster Ideas...





what is it considered if you run the perl program
through perl2exe ?  


Is it compiled then? or still interpreted with a
big library?


George


>-Original Message-
>From: Jeff Schasny [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, January 27, 2004 3:46 PM
>To: U2 Users Discussion List
>Subject: RE: looking for faster Ideas...
>
>
>What? As opposed to Uni/UV/Pick Basic? Surprise! it compiles 
>to psudocode
>just like java. Now if you were to have proposed "C", Fortran, 
>Assembler,
>etc I could see your point.
>
>-Original Message-
>From: Ian McGowan [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, January 27, 2004 12:22 PM
>To: U2 Users Discussion List
>Subject: RE: looking for faster Ideas...
>
>
>if speed is the issue, sounds like a job for a compiled lanuage. or
>semi-compiled like perl or python.
>
>[snip]
>___
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>



___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

mkdbfile: create file in another account

2004-01-27 Thread Kate Stanton




Does anyone know anything about using mkdbfile 
(from UV bin) to create a file in an account other than the current user 
account?
 
A colleague told me about it, but it does not seem 
to be documented, and does not seem to work on my UV 10.0.17 system on Windows 
2000, as it does on his UV 9.5.2.1 on Windows something.
 
I tried, according to his 
instructions:
VOC mkdbfile
0001: V
0002: mkdbfile
0003: E
0004: FG
0005:
0006: PICK.FORMAT
 
Then, from TCL: mkdbfile 
C:\BeaconUV\DevelData\XXINV\KKINV 30 1 4 20 50 80 1068
where:
C:\BeaconUV\DevelData\XXINV\KKINV is pathname of 
file to create
30 is file type
1 is modulo
4 is separation
20 is hash type
50 is max load
80 is split load
1096 is large record size
 
This gave error message: invalid filetype 
specified
 
I feel very nervous about using something that is 
not documented, so presumably may not be reliably supported.
 
Anyone know anything, please?
 
Cheers,  Kate
 
Kate StantonWalstan Systems Ltd4 Kelmarna 
Ave, Herne Bay, Auckland, New Zealandph +64 9 360 5310  fax +64 9 376 
0750ah +64 9 378 9594[EMAIL PROTECTED]
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: mkdbfile: create file in another account

2004-01-27 Thread Daly, Mark

Title: Message



Well, I just posed 
this question - and mkdbfile was the suggestion that 
won!
 
However, I didn't 
create a VOC entry. The idea (I believe) is to execute this command at the OS 
prompt - not TCL.
 
Since it looks like 
you're on Windows it would be something like so:
 
EXECUTE 'sh -c 
"cd C:\BeaconUV\DevelData\XXINV\KKINV; ':SYSTEM(32):'\bin\mkdbfile 
DATA \XXINV\KKINV 30 1 4 20 50 80 1068'
 

 It's not documented, since it's really an internal UV command - as 
opposed to a TCL statement of BASIC function.
 
The CREATE.FILE verb needs to be enhanced 
to perform this function - and prevent us from dabbling in the 'bin' directory. 
But until then - this is the way to go.
 
HTH,
 
Mark.
 
 Original 
Message-From: Kate Stanton [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 27, 2004 4:17 PMTo: 
[EMAIL PROTECTED]Subject: mkdbfile: create file in another 
account
Does anyone know anything about using mkdbfile 
(from UV bin) to create a file in an account other than the current user 
account?
 
A colleague told me about it, but it does not seem 
to be documented, and does not seem to work on my  
 
 UV 
10.0.17 system on Windows 2000, as it does on his UV 9.5.2.1 on Windows 
something.
 
I tried, according to his 
instructions:
VOC mkdbfile
0001: V
0002: mkdbfile
0003: E
0004: FG
0005:
0006: PICK.FORMAT
 
Then, from TCL: mkdbfile 
C:\BeaconUV\DevelData\XXINV\KKINV 30 1 4 20 50 80 1068
where:
C:\BeaconUV\DevelData\XXINV\KKINV is pathname of 
file to create
30 is file type
1 is modulo
4 is separation
20 is hash type
50 is max load
80 is split load
1096 is large record size
 
This gave error message: invalid filetype 
specified
 
I feel very nervous about using something that is 
not documented, so presumably may not be reliably supported.
 
Anyone know anything, please?
 
Cheers,  Kate
 
Kate StantonWalstan Systems Ltd4 Kelmarna 
Ave, Herne Bay, Auckland, New Zealandph +64 9 360 5310  fax +64 9 376 
0750ah +64 9 378 9594[EMAIL PROTECTED]
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: mkdbfile: create file in another account

2004-01-27 Thread Logan, David (SST - Adelaide)

Title: Message



Hi 
Kate,
 
These 
commands are designed to be run from the unix or (blerk, I hate this word) dos 
environment. Running them from TCL would require an sh -c type 
command.
 
Regards
David Logan Database Administrator 
HP Managed Services 
139 Frome Street, 
Adelaide 5000 
Australia 
+61 8 8408 4273 
+61 417 268 665 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf 
  Of Kate StantonSent: Wednesday, 28 January 2004 7:47 
  AMTo: [EMAIL PROTECTED]Subject: mkdbfile: create file 
  in another account
  Does anyone know anything about using mkdbfile 
  (from UV bin) to create a file in an account other than the current user 
  account?
   
  A colleague told me about it, but it does not 
  seem to be documented, and does not seem to work on my UV 10.0.17 system on 
  Windows 2000, as it does on his UV 9.5.2.1 on Windows something.
   
  I tried, according to his 
  instructions:
  VOC mkdbfile
  0001: V
  0002: mkdbfile
  0003: E
  0004: FG
  0005:
  0006: PICK.FORMAT
   
  Then, from TCL: mkdbfile 
  C:\BeaconUV\DevelData\XXINV\KKINV 30 1 4 20 50 80 1068
  where:
  C:\BeaconUV\DevelData\XXINV\KKINV is pathname of 
  file to create
  30 is file type
  1 is modulo
  4 is separation
  20 is hash type
  50 is max load
  80 is split load
  1096 is large record size
   
  This gave error message: invalid filetype 
  specified
   
  I feel very nervous about using something that is 
  not documented, so presumably may not be reliably supported.
   
  Anyone know anything, please?
   
  Cheers,  Kate
   
  Kate StantonWalstan Systems Ltd4 Kelmarna 
  Ave, Herne Bay, Auckland, New Zealandph +64 9 360 5310  fax +64 9 376 
  0750ah +64 9 378 9594[EMAIL PROTECTED]
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: mkdbfile: create file in another account

2004-01-27 Thread Tom Firl

Title: Message



...or 
DOS /C if you are on Windows.

  -Original Message-From: Logan, David (SST - 
  Adelaide) [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 27, 
  2004 1:39 PMTo: U2 Users Discussion ListSubject: RE: 
  mkdbfile: create file in another account
  Hi 
  Kate,
   
  These commands are designed to be run from the unix or (blerk, I hate 
  this word) dos environment. Running them from TCL would require an sh -c type 
  command.
   
  Regards
  David Logan 
  Database 
  Administrator HP 
  Managed Services 139 Frome Street, Adelaide 5000 Australia 
  +61 8 8408 4273 
  +61 417 268 665 

  

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
Behalf Of Kate StantonSent: Wednesday, 28 January 2004 7:47 
AMTo: [EMAIL PROTECTED]Subject: mkdbfile: create 
file in another account
Does anyone know anything about using mkdbfile 
(from UV bin) to create a file in an account other than the current user 
account?
 
A colleague told me about it, but it does not 
seem to be documented, and does not seem to work on my UV 10.0.17 system on 
Windows 2000, as it does on his UV 9.5.2.1 on Windows 
something.
 
I tried, according to his 
instructions:
VOC mkdbfile
0001: V
0002: mkdbfile
0003: E
0004: FG
0005:
0006: PICK.FORMAT
 
Then, from TCL: mkdbfile 
C:\BeaconUV\DevelData\XXINV\KKINV 30 1 4 20 50 80 1068
where:
C:\BeaconUV\DevelData\XXINV\KKINV is pathname 
of file to create
30 is file type
1 is modulo
4 is separation
20 is hash type
50 is max load
80 is split load
1096 is large record size
 
This gave error message: invalid filetype 
specified
 
I feel very nervous about using something that 
is not documented, so presumably may not be reliably supported.
 
Anyone know anything, please?
 
Cheers,  Kate
 
Kate StantonWalstan Systems Ltd4 
Kelmarna Ave, Herne Bay, Auckland, New Zealandph +64 9 360 5310  
fax +64 9 376 0750ah +64 9 378 9594[EMAIL PROTECTED]
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: looking for faster Ideas...

2004-01-27 Thread Geoffrey Mitchell

Title: RE: looking for faster Ideas...




We do something like this, using a "match code" composed of fragments of data concatenated together.  I think we use a delimiter, but you wouldn't need to.

So, if you want to match Johnson in zipcode 12345 on Maple street, you might have a matchcode of "JOHNSON*12345*MAPLE", so you would extract the relevant fields, build the matchcode and check it against a list or file.  Actually, we use an I-type dictionary to generate the matchcode, and have an index built on it.  For small datasets this may be *slower* than your case statement, but I would think that it would be easier to maintain, and for large datasets it should be quicker since the time to construct the matchcode and do a read, selectindex, or whatever would be constant.  Of course, if you have a Jonsson that gets spelled Johnson, you're going to have problems no matter how you approach it.

On Tue, 2004-01-27 at 13:05, George Gallen wrote:

I can't just check for names, it has to a name with a specific zip code
and if the name is fairly common, we also add in part of the address to
make sure no one else is weeded out that shouldn't be.

I suppose I could keep two or three arrays, do a specific lookup in each
saving the position, and if all three positions are identicle (asuming all
three arrays have the name, address, zip in the same order) then that would
be a matchThanks

George

>-Original Message-
>From: Jeff Schasny [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, January 27, 2004 1:51 PM
>To: U2 Users Discussion List
>Subject: RE: looking for faster Ideas...
>
>
>how about keeping a list of excluded names as a record in a 
>file (or as a
>flat file in a directory with each name/item/whatever on a 
>line) and reading
>it into the program as a dynamic array then doing a locate on 
>the string in
>question.  Something like this:
>
>
>READ ALIST FROM AFILE,SOME-ID ELSE STOP
>X = 0
>LOOP
>   X += 1
>   ASTRING = INLIST
>UNTIL ASTRING = ''
>   LOCATE ASTRING IN ALIST SETTING POS THEN
>  DO
>  OTHER
>  STUFF
>   END ELSE
>  DONT
>   END
>REPEAT
>
>Of course of you really want speed then sort the list and use 
>a "BY clause
>in the locate
>
>-Original Message-
>From: George Gallen [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, January 27, 2004 11:33 AM
>To: 'Ardent List'
>Subject: looking for faster Ideas...
>
>
>I can't setup any indexs to speed this up. Basically I'm 
>scanning a CSV file
>for names to remove
>   and set the flag of KICK=1 to remove it (creating a new CSV 
>file at the
>same time).
>
>Keep in mind the ".." are people's last names, or zip codes, or part of
>their address, changed
>them to ".." to protect the unwanting...
>
>Right now, I do a series of CASE's ...
>Now, it's not a major problem as I'm only checking for 20 or 
>so names, but
>as more and more people
>  request to be removed (and we don't have access to the 
>creation of the
>list). this could get quite
>  slow over 50 or 60 thousand lines of checking.
>
>LIN is one line of the CSV file, the INDEX is checking for a 
>last name & a
>zip code and sometimes
>   part of the address line.
>
>Any Ideas?
>
>Remember, we can't change the source of the file, it will 
>always be a CSV,
>being read line by line
>
>   KICK=0
>   BEGIN CASE
>  CASE -1
> KICK=1
>    BEGIN CASE
>    CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND
>INDEX(LIN,"..",1)#0
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND
>INDEX(LIN,"..",1)#0 
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE -1
>      KICK=0
>    END CASE
>   END CASE
>
>George Gallen
>Senior

Periodic COMO file problem

2004-01-27 Thread Robert Porter




This has happened a couple of times now.  The &COMO& file 
somehow becomes "corrupt" - for the lack of a better explaination.  Any 
attempt to edit a record in it results in a severely hung process. You won't be 
able to break out of it. MASTER OFF (usernumber) doesn't work.  A 
standard kill at the Unix level won't touch it either. It will take a kill -9 to 
get rid of the user.  
 
This is on a UniVerse 9.5.1.1 box running under HP-UX 11.0.  It's run 
fine for a couple of years now, and has recently (past few months) begun strange 
occurances like this.  It's also periodically corrupted a few dynamic type 
files as well.  On those, it simple would fail with a Fault Type X (11/13 
IIRC).  Anyone experienced anything like this before?
 
TIA,
Robert
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: looking for faster Ideas...

2004-01-27 Thread Jeff Schasny

Title: RE: looking for faster Ideas...



I 
suppose you could soundex the whole thing

  -Original Message-From: Geoffrey Mitchell 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 27, 2004 2:59 
  PMTo: U2 Users Discussion ListSubject: RE: looking for 
  faster Ideas...We do something like this, using a "match 
  code" composed of fragments of data concatenated together.  I think we 
  use a delimiter, but you wouldn't need to.So, if you want to match 
  Johnson in zipcode 12345 on Maple street, you might have a matchcode of 
  "JOHNSON*12345*MAPLE", so you would extract the relevant fields, build the 
  matchcode and check it against a list or file.  Actually, we use an 
  I-type dictionary to generate the matchcode, and have an index built on 
  it.  For small datasets this may be *slower* than your case statement, 
  but I would think that it would be easier to maintain, and for large datasets 
  it should be quicker since the time to construct the matchcode and do a read, 
  selectindex, or whatever would be constant.  Of course, if you have a 
  Jonsson that gets spelled Johnson, you're going to have problems no matter how 
  you approach it.On Tue, 2004-01-27 at 13:05, George Gallen wrote: 
  I can't just check for 
names, it has to a name with a specific zip codeand if the name is 
fairly common, we also add in part of the address tomake sure no one 
else is weeded out that shouldn't be.I suppose I could keep two or 
three arrays, do a specific lookup in eachsaving the position, and if 
all three positions are identicle (asuming allthree arrays have the 
name, address, zip in the same order) then that wouldbe a 
matchThanksGeorge>-Original 
Message->From: Jeff Schasny [mailto:[EMAIL PROTECTED]]>Sent: Tuesday, January 27, 2004 1:51 PM>To: U2 Users 
Discussion List>Subject: RE: looking for faster 
Ideas...>>>how about keeping a list of excluded names 
as a record in a >file (or as a>flat file in a directory with 
each name/item/whatever on a >line) and reading>it into the 
program as a dynamic array then doing a locate on >the string 
in>question.  Something like this:>>>READ 
ALIST FROM AFILE,SOME-ID ELSE STOP>X = 
0>LOOP>   X += 1>   ASTRING = 
INLIST>UNTIL ASTRING = ''>   LOCATE ASTRING 
IN ALIST SETTING POS THEN>  
DO>  
OTHER>  STUFF>   END 
ELSE>  DONT>   
END>REPEAT>>Of course of you really want speed then 
sort the list and use >a "BY clause>in the 
locate>>-Original Message->From: George Gallen 
[mailto:[EMAIL PROTECTED]]>Sent: Tuesday, January 27, 2004 11:33 AM>To: 'Ardent 
List'>Subject: looking for faster Ideas...>>>I 
can't setup any indexs to speed this up. Basically I'm >scanning a 
CSV file>for names to remove>   and set the flag of 
KICK=1 to remove it (creating a new CSV >file at the>same 
time).>>Keep in mind the ".." are people's last names, or zip 
codes, or part of>their address, changed>them to ".." to 
protect the unwanting...>>Right now, I do a series of CASE's 
...>Now, it's not a major problem as I'm only checking for 20 or 
>so names, but>as more and more people>  request 
to be removed (and we don't have access to the >creation of 
the>list). this could get quite>  slow over 50 or 60 
thousand lines of checking.>>LIN is one line of the CSV file, 
the INDEX is checking for a >last name & a>zip code and 
sometimes>   part of the address line.>>Any 
Ideas?>>Remember, we can't change the source of the file, it 
will >always be a CSV,>being read line by 
line>>   KICK=0>   BEGIN 
CASE>  CASE 
-1> 
KICK=1>    BEGIN 
CASE>    
CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
AND>INDEX(LIN,"..",1)#0>   
    CASE INDEX(LIN,"..",1)#0 AND 
INDEX(LIN,"..",1)#0>   
    CASE INDEX(LIN,"..",1)#0 AND 
INDEX(LIN,"..",1)#0>   
    CASE INDEX(LIN,"..",1)#0 AND 
INDEX(LIN,"..",1)#0>   
    CASE INDEX(LIN,"..",1)#0 AND 
INDEX(LIN,"..",1)#0>   
    CASE INDEX(LIN,"..",1)#0 AND 
INDEX(LIN,"..",1)#0>   
    CASE INDEX(LIN,"..",1)#0 AND 
INDEX(LIN,"..",1)#0>   
    CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE 
INDEX(LIN,"..",1)#0 AND 
INDEX(LIN,"..",1)#0>   
    CASE INDEX(LIN,"..",1)#0 AND 
INDEX(LIN,"..",1)#0>   
    CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE 
INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND>INDEX(LIN,"..",1)#0 
>       CASE 
INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE 
INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE 
INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE 
INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
>       CASE 
INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#

RE: looking for faster Ideas...

2004-01-27 Thread George Gallen

Title: RE: looking for faster Ideas...



I 
thought of that, but soundex only works on the first three letters, if I 
remember correctly.
or it 
only encodes the first three letters, then remaining are 
unchanged.
 
The 
main problem is I can't isolate a last name from the source, it comes in as a 
full name,
and if 
I use the full name as given to us by the consumer, there is a chance it won't 
be in
the 
same exact format as in the file from the rental, might be missing the middle 
initial
one 
may have a married hyphenated name, one could be a shortened or different first 
name
(ie. 
betty instead of elizabeth, or jack instead john..etc).
 
Since 
my original was a list of if/thens, looks like the I'm not going to be able to 
gain much
in 
speed any other way with straight programming (that is no temp files, or files 
to bounce off).
 
George

  -Original Message-From: Jeff Schasny 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 27, 2004 5:12 
  PMTo: U2 Users Discussion ListSubject: RE: looking for 
  faster Ideas...
  I 
  suppose you could soundex the whole thing
  
-Original Message-From: Geoffrey Mitchell 
[mailto:[EMAIL PROTECTED]Sent: Tuesday, January 27, 2004 2:59 
PMTo: U2 Users Discussion ListSubject: RE: looking for 
faster Ideas...We do something like this, using a 
"match code" composed of fragments of data concatenated together.  I 
think we use a delimiter, but you wouldn't need to.So, if you want 
to match Johnson in zipcode 12345 on Maple street, you might have a 
matchcode of "JOHNSON*12345*MAPLE", so you would extract the relevant 
fields, build the matchcode and check it against a list or file.  
Actually, we use an I-type dictionary to generate the matchcode, and have an 
index built on it.  For small datasets this may be *slower* than your 
case statement, but I would think that it would be easier to maintain, and 
for large datasets it should be quicker since the time to construct the 
matchcode and do a read, selectindex, or whatever would be constant.  
Of course, if you have a Jonsson that gets spelled Johnson, you're going to 
have problems no matter how you approach it.On Tue, 2004-01-27 at 
13:05, George Gallen wrote: 
I can't just check 
  for names, it has to a name with a specific zip codeand if the name is 
  fairly common, we also add in part of the address tomake sure no one 
  else is weeded out that shouldn't be.I suppose I could keep two or 
  three arrays, do a specific lookup in eachsaving the position, and if 
  all three positions are identicle (asuming allthree arrays have the 
  name, address, zip in the same order) then that wouldbe a 
  matchThanksGeorge>-Original 
  Message->From: Jeff Schasny [mailto:[EMAIL PROTECTED]]>Sent: Tuesday, January 27, 2004 1:51 PM>To: U2 
  Users Discussion List>Subject: RE: looking for faster 
  Ideas...>>>how about keeping a list of excluded names 
  as a record in a >file (or as a>flat file in a directory 
  with each name/item/whatever on a >line) and reading>it into 
  the program as a dynamic array then doing a locate on >the string 
  in>question.  Something like this:>>>READ 
  ALIST FROM AFILE,SOME-ID ELSE STOP>X = 
  0>LOOP>   X += 1>   ASTRING = 
  INLIST>UNTIL ASTRING = ''>   LOCATE 
  ASTRING IN ALIST SETTING POS THEN>  
  DO>  
  OTHER>  STUFF>   END 
  ELSE>  DONT>   
  END>REPEAT>>Of course of you really want speed then 
  sort the list and use >a "BY clause>in the 
  locate>>-Original Message->From: George 
  Gallen [mailto:[EMAIL PROTECTED]]>Sent: Tuesday, January 27, 2004 11:33 AM>To: 
  'Ardent List'>Subject: looking for faster 
  Ideas...>>>I can't setup any indexs to speed this up. 
  Basically I'm >scanning a CSV file>for names to 
  remove>   and set the flag of KICK=1 to remove it 
  (creating a new CSV >file at the>same 
  time).>>Keep in mind the ".." are people's last names, or 
  zip codes, or part of>their address, changed>them to ".." to 
  protect the unwanting...>>Right now, I do a series of CASE's 
  ...>Now, it's not a major problem as I'm only checking for 20 or 
  >so names, but>as more and more people>  request 
  to be removed (and we don't have access to the >creation of 
  the>list). this could get quite>  slow over 50 or 60 
  thousand lines of checking.>>LIN is one line of the CSV 
  file, the INDEX is checking for a >last name & a>zip 
  code and sometimes>   part of the address 
  line.>>Any Ideas?>>Remember, we can't change 
  the source of the file, it will >always be a CSV,>being read 
  line by line>>   KICK=0>   BEGIN 
  CASE>  CASE 
  -1> 
  KICK=1>    BEGIN 
  CASE>    
  CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 
  AND>INDEX

RE: looking for faster Ideas...

2004-01-27 Thread Jeff Schasny

Title: RE: looking for faster Ideas...



More 
than you could have ever possibly wanted to know about 
soundex:
 
http://www.avotaynu.com/soundex.html

  -Original Message-From: George Gallen 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 27, 2004 3:33 
  PMTo: 'U2 Users Discussion List'Subject: RE: looking for 
  faster Ideas...
  I 
  thought of that, but soundex only works on the first three letters, if I 
  remember correctly.
  or 
  it only encodes the first three letters, then remaining are 
  unchanged.
   
  The 
  main problem is I can't isolate a last name from the source, it comes in as a 
  full name,
  and 
  if I use the full name as given to us by the consumer, there is a chance it 
  won't be in
  the 
  same exact format as in the file from the rental, might be missing the middle 
  initial
  one 
  may have a married hyphenated name, one could be a shortened or different 
  first name
  (ie. 
  betty instead of elizabeth, or jack instead 
john..etc).
   
  Since my original was a list of if/thens, looks like the I'm not going 
  to be able to gain much
  in 
  speed any other way with straight programming (that is no temp files, or files 
  to bounce off).
   
  George
  
-Original Message-From: Jeff Schasny 
[mailto:[EMAIL PROTECTED]Sent: Tuesday, January 27, 2004 
5:12 PMTo: U2 Users Discussion ListSubject: RE: 
looking for faster Ideas...
I 
suppose you could soundex the whole thing

  -Original Message-From: Geoffrey Mitchell 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 27, 2004 
  2:59 PMTo: U2 Users Discussion ListSubject: RE: 
  looking for faster Ideas...We do something like this, 
  using a "match code" composed of fragments of data concatenated 
  together.  I think we use a delimiter, but you wouldn't need 
  to.So, if you want to match Johnson in zipcode 12345 on Maple 
  street, you might have a matchcode of "JOHNSON*12345*MAPLE", so you would 
  extract the relevant fields, build the matchcode and check it against a 
  list or file.  Actually, we use an I-type dictionary to generate the 
  matchcode, and have an index built on it.  For small datasets this 
  may be *slower* than your case statement, but I would think that it would 
  be easier to maintain, and for large datasets it should be quicker since 
  the time to construct the matchcode and do a read, selectindex, or 
  whatever would be constant.  Of course, if you have a Jonsson that 
  gets spelled Johnson, you're going to have problems no matter how you 
  approach it.On Tue, 2004-01-27 at 13:05, George Gallen wrote: 
  I can't just check 
for names, it has to a name with a specific zip codeand if the name 
is fairly common, we also add in part of the address tomake sure no 
one else is weeded out that shouldn't be.I suppose I could keep two 
or three arrays, do a specific lookup in eachsaving the position, 
and if all three positions are identicle (asuming allthree arrays 
have the name, address, zip in the same order) then that wouldbe a 
matchThanksGeorge>-Original 
Message->From: Jeff Schasny [mailto:[EMAIL PROTECTED]]>Sent: Tuesday, January 27, 2004 1:51 PM>To: U2 
Users Discussion List>Subject: RE: looking for faster 
Ideas...>>>how about keeping a list of excluded 
names as a record in a >file (or as a>flat file in a 
directory with each name/item/whatever on a >line) and 
reading>it into the program as a dynamic array then doing a 
locate on >the string in>question.  Something like 
this:>>>READ ALIST FROM AFILE,SOME-ID ELSE 
STOP>X = 0>LOOP>   X += 
1>   ASTRING = INLIST>UNTIL ASTRING = 
''>   LOCATE ASTRING IN ALIST SETTING POS 
THEN>  
DO>  
OTHER>  STUFF>   
END ELSE>  DONT>   
END>REPEAT>>Of course of you really want speed then 
sort the list and use >a "BY clause>in the 
locate>>-Original Message->From: George 
Gallen [mailto:[EMAIL PROTECTED]]>Sent: Tuesday, January 27, 2004 11:33 AM>To: 
'Ardent List'>Subject: looking for faster 
Ideas...>>>I can't setup any indexs to speed this 
up. Basically I'm >scanning a CSV file>for names to 
remove>   and set the flag of KICK=1 to remove it 
(creating a new CSV >file at the>same 
time).>>Keep in mind the ".." are people's last names, or 
zip codes, or part of>their address, changed>them to ".." 
to protect the unwanting...>>Right now, I do a series of 
CASE's ...>Now, it's not a major problem as I'm only checking for 
20 or >so names, but>as more and more people>  
request to be removed (and we don't have access to the >creation 
of the>list). this could get quite>  slow over 50 or

Re: Periodic COMO file problem

2004-01-27 Thread Karl L Pearson

Here's my "shot in the dark":

I would check the OS tunable dealing with inode and related settings
such as nfile. It's been over a year since I attempted to tune any HPUX
kernels.

Since the &COMO& file is a type 1/19 it's a Unix directory so has
limitations dealing with the native OS.

Now, someone correct my ignorance so I can learn, too.


On Tue, 2004-01-27 at 15:05, Robert Porter wrote:
> This has happened a couple of times now.  The &COMO& file somehow
becomes "corrupt" - for the lack of a better explaination.  Any attempt
to edit a record in it results in a severely hung process. You won't be
able to break out of it. MASTER OFF (usernumber) doesn't work.  A
standard kill at the Unix level won't touch it either. It will take a
kill -9 to get rid of the user.  
> 
> This is on a UniVerse 9.5.1.1 box running under HP-UX 11.0.  It's run
fine for a couple of years now, and has recently (past few months) begun
strange occurances like this.  It's also periodically corrupted a few
dynamic type files as well.  On those, it simple would fail with a Fault
Type X (11/13 IIRC).  Anyone experienced anything like this before?
> 
> TIA,
> Robert
> 
> 

> ___
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
Karl L. Pearson
Director of IT,
ATS Industrial Supply
Direct: 801-978-4429
Toll-free: 888-972-3182 x29
Fax: 801-972-3888
http://www.atsindustrial.com
[EMAIL PROTECTED]


___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

UD Coding a 'Hard Carriage Return" for an Excel file

2004-01-27 Thread Burwell, Edward

Hello,

I am creating a tab-delimted file with and xls extension that excel is very
happy to open.  I would like to create a cell that has line-breaks or
Hard-Carriage-Returns in them.  You can accomplish this manually by pressing
ALT+ENTER while entering data into a cell.  I belive the character is the
same as what you get in MSWORD when you hold the ALT key and enter 0010.  

Here is a snippet of the code that I am using:

284:   TAB=CHAR(9) ; CR=CHAR(13) ; LF=CHAR(10) ; CRLF=CR:LF
285:  * *
286:   HDR=SOURCE:TAB
287:   HDR:=\=\:QUOTE(INVOICE):TAB  ; * to force excel to see this as
text
288:   HDR:=CUST:TAB
289:  * ADDRESS *
290:   IF FULL.ADDRESS THEN
290: * set Line Break character *
291: *LB=CHAR(1034) ; * CHAR(10) + CHAR(1024) - ALT KEY
292: *LB=CR   ; * CHAR(13)
293: *LB=CRLF ; * CHAR(13) : CHAR(10)
294:  LB=LF   ; * CHAR(10)
295:  ADDR=NAME:LB
296:  IF LEN(AD1) THEN ADDR:=AD1:LB
297:  IF LEN(AD2) THEN ADDR:=AD2:LB
298:  IF LEN(ATTN) THEN ADDR:=ATTN:LB
299:  ADDR:=CITY:", ":ST:"  ":ZIP
300:  HDR:=QUOTE(ADDR):TAB
301:   END ELSE
302:  HDR:=NAME:TAB
303:   END

When I manually enter data into a cell and press ALT+ENTER for a
hard-carriage-return, then copy and paste that cell into notepad, I see a
square non-printable character where the carriage-returns were.  When I look
at that square in a hex viewer, its 0A or ASCII 10, char(10), the line feed
character.

When I run the above code then open the file in excel and look at the cell,
it seems to work, however, now there is a visible square right where I put
the char(10)'s!  I get the same result when I use CRLF as well.  When I use
CR only, it doesn't wrap at all.

Any help would be greatly appreciated.

Also - I am only receiving the Digest, but I want to receive all postings
(and the Digest).  I went to the site and my settings look ok.  My IE cookie
setting is medium, but that's what it's always been.  If someone could tell
me how to get all mailings that would be appreciated also!

Thanks in advance. 

Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: looking for faster Ideas...

2004-01-27 Thread Ian McGowan

http://aspell.sourceforge.net/metaphone/metaphone.basic

soundex is pathetic - nowadays, metaphone is much better.

if you're feeling perl'ish

http://www.foo.be/docs/tpj/issues/vol5_3/tpj0503-0009.html

has an interesting discussion of using several approximate methods for
identifying records by name.  it even discusses the betty/elizabeth,
jack/john problem...  looks slow so you would probably have to cache the
results. c'mon there must be *something* unique in the file they send!
:-)

On Tue, 2004-01-27 at 14:32, George Gallen wrote:
> I thought of that, but soundex only works on the first three letters, if
> I remember correctly.
> or it only encodes the first three letters, then remaining are
> unchanged.
>  
> The main problem is I can't isolate a last name from the source, it
> comes in as a full name,
> and if I use the full name as given to us by the consumer, there is a
> chance it won't be in
> the same exact format as in the file from the rental, might be missing
> the middle initial
> one may have a married hyphenated name, one could be a shortened or
> different first name
> (ie. betty instead of elizabeth, or jack instead john..etc).
>  
> Since my original was a list of if/thens, looks like the I'm not going
> to be able to gain much
> in speed any other way with straight programming (that is no temp files,
> or files to bounce off).
>  
> George
> 
> -Original Message-
> From: Jeff Schasny [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 27, 2004 5:12 PM
> To: U2 Users Discussion List
> Subject: RE: looking for faster Ideas...
> 
> 
> I suppose you could soundex the whole thing
> 
> -Original Message-
> From: Geoffrey Mitchell [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 27, 2004 2:59 PM
> To: U2 Users Discussion List
> Subject: RE: looking for faster Ideas...
> 
> 
> We do something like this, using a "match code" composed of fragments of
> data concatenated together.  I think we use a delimiter, but you
> wouldn't need to.
> 
> So, if you want to match Johnson in zipcode 12345 on Maple street, you
> might have a matchcode of "JOHNSON*12345*MAPLE", so you would extract
> the relevant fields, build the matchcode and check it against a list or
> file.  Actually, we use an I-type dictionary to generate the matchcode,
> and have an index built on it.  For small datasets this may be *slower*
> than your case statement, but I would think that it would be easier to
> maintain, and for large datasets it should be quicker since the time to
> construct the matchcode and do a read, selectindex, or whatever would be
> constant.  Of course, if you have a Jonsson that gets spelled Johnson,
> you're going to have problems no matter how you approach it.
> 
> On Tue, 2004-01-27 at 13:05, George Gallen wrote: 
> 
> I can't just check for names, it has to a name with a specific zip code
> and if the name is fairly common, we also add in part of the address to
> make sure no one else is weeded out that shouldn't be.
> 
> I suppose I could keep two or three arrays, do a specific lookup in each
> saving the position, and if all three positions are identicle (asuming
> all
> three arrays have the name, address, zip in the same order) then that
> would
> be a matchThanks
> 
> George
> 
> >-Original Message-
> >From: Jeff Schasny [  
> mailto:[EMAIL PROTECTED]
> >Sent: Tuesday, January 27, 2004 1:51 PM
> >To: U2 Users Discussion List
> >Subject: RE: looking for faster Ideas...
> >
> >
> >how about keeping a list of excluded names as a record in a 
> >file (or as a
> >flat file in a directory with each name/item/whatever on a 
> >line) and reading
> >it into the program as a dynamic array then doing a locate on 
> >the string in
> >question.  Something like this:
> >
> >
> >READ ALIST FROM AFILE,SOME-ID ELSE STOP
> >X = 0
> >LOOP
> >   X += 1
> >   ASTRING = INLIST
> >UNTIL ASTRING = ''
> >   LOCATE ASTRING IN ALIST SETTING POS THEN
> >  DO
> >  OTHER
> >  STUFF
> >   END ELSE
> >  DONT
> >   END
> >REPEAT
> >
> >Of course of you really want speed then sort the list and use 
> >a "BY clause
> >in the locate
> >
> >-Original Message-
> >From: George Gallen [  
> mailto:[EMAIL PROTECTED]
> >Sent: Tuesday, January 27, 2004 11:33 AM
> >To: 'Ardent List'
> >Subject: looking for faster Ideas...
> >
> >
> >I can't setup any indexs to speed this up. Basically I'm 
> >scanning a CSV file
> >for names to remove
> >   and set the flag of KICK=1 to remove it (creating a new CSV 
> >file at the
> >same time).
> >
> >Keep in mind the ".." are people's last names, or zip codes, or part of
> >their address, changed
> >them to ".." to protect the unwanting...
> >
> >Right now, I do a series of CASE's ...
> >Now, it's not a major problem as I'm only checking for 20 or 
> >so names, but
> >as more and more people
> >  request to be removed (and we don't have access to the 
> >creation of the
> >list). this could get qu

Re: looking for faster Ideas...

2004-01-27 Thread Tony Wood

Hi George,

We some processing through files of 5-4Mb in D3 and UniVerse. We found one
of the quicker to process these files was to read about 2k of data at a
time. You would need to identify the last complete line work with everything
before that keeping the last bit for then next processing chunk.

As far as finding matches you have one, two or three pieces of data to match
on.So start with one if you score a match then look further. This will
reduce your processing to quickly find anything that might match rather than
having to match on everything for every line. Processing in 2k chunks also
means you can index for "SMITH" and find none quickly rather than processing
each line looking for "SMITH" + "" and "SMITH" + "MENERE ST".

I would avoid using index on a line by line basis. I would also look at what
information you usually get and consider using a record where the item id is
the key search string. Where you have more than one out-opter you can then
use either multi-values or attributes to contain the other search criteria.

Sounds a little complicated but it breaks the job into smaller chunks to be
resolved and will require less processing in the long run I believe.

Good luck

T.

- Original Message - 
From: "George Gallen" <[EMAIL PROTECTED]>
To: "'Ardent List'" <[EMAIL PROTECTED]>
Sent: Wednesday, January 28, 2004 5:33 AM
Subject: looking for faster Ideas...


> I can't setup any indexs to speed this up. Basically I'm scanning a CSV
file
> for names to remove
>and set the flag of KICK=1 to remove it (creating a new CSV file at the
> same time).
>
> Keep in mind the ".." are people's last names, or zip codes, or part of
> their address, changed
> them to ".." to protect the unwanting...
>
> Right now, I do a series of CASE's ...
> Now, it's not a major problem as I'm only checking for 20 or so names, but
> as more and more people
>   request to be removed (and we don't have access to the creation of the
> list). this could get quite
>   slow over 50 or 60 thousand lines of checking.
>
> LIN is one line of the CSV file, the INDEX is checking for a last name & a
> zip code and sometimes
>part of the address line.
>
> Any Ideas?
>
> Remember, we can't change the source of the file, it will always be a CSV,
> being read line by line
>
>KICK=0
>BEGIN CASE
>   CASE -1
>  KICK=1
> BEGIN CASE
> CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND
> INDEX(LIN,"..",1)#0
> CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0 AND
> INDEX(LIN,"..",1)#0
> CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> CASE INDEX(LIN,"..",1)#0 AND INDEX(LIN,"..",1)#0
> CASE -1
>KICK=0
> END CASE
>END CASE
>
> George Gallen
> Senior Programmer/Analyst
> Accounting/Data Division
> [EMAIL PROTECTED]
> ph:856.848.1000 Ext 220
>
> SLACK Incorporated - An innovative information, education and management
> company
> http://www.slackinc.com
>
> ___
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users
>
>


___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Periodic COMO file problem

2004-01-27 Thread Jerry Banker




I had this happen a couple of times when I worked on an HP 
system. Turned out to be a bad spot on the disk drive. Then again how big is the 
como file? If the file is large it could take a while to bring it into memory, 
if it doesn't get a memory full error first.

  - Original Message - 
  From: 
  Robert 
  Porter 
  To: [EMAIL PROTECTED] 
  Sent: Tuesday, January 27, 2004 4:05 
  PM
  Subject: Periodic COMO file problem
  
  This has happened a couple of times now.  The &COMO& file 
  somehow becomes "corrupt" - for the lack of a better explaination.  Any 
  attempt to edit a record in it results in a severely hung process. You won't 
  be able to break out of it. MASTER OFF (usernumber) doesn't work.  A 
  standard kill at the Unix level won't touch it either. It will take a kill -9 
  to get rid of the user.  
   
  This is on a UniVerse 9.5.1.1 box running under HP-UX 11.0.  It's 
  run fine for a couple of years now, and has recently (past few months) begun 
  strange occurances like this.  It's also periodically corrupted a few 
  dynamic type files as well.  On those, it simple would fail with a Fault 
  Type X (11/13 IIRC).  Anyone experienced anything like this before?
   
  TIA,
  Robert
  
  

  ___u2-users mailing 
  list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

UNCLASSIFIED RE: UD Coding a 'Hard Carriage Return" for an Excel file

2004-01-27 Thread HENDERSON MICHAEL MR

Ed,

I can help with the IE problem ...

In IE, go to Tools / Internet Options / Privacy

Click on the "Edit ..." button near the bottom

Under "Address of Web Site" enter the domain name from which you need to
accept cookies (e.g. "oliver.com")
Click on "Allow"
Click on "OK"  a couple of times

Tada!  Should work now


HTH

Mike

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED]
> Behalf Of Burwell, Edward
> Sent: Wednesday, 28 January 2004 11:51 a.m.
> To: '[EMAIL PROTECTED]'
> Subject: UD Coding a 'Hard Carriage Return" for an Excel file
> 
> 
> Hello,
> 
[snip]
> 
> Also - I am only receiving the Digest, but I want to receive all postings
> (and the Digest).  I went to the site and my settings look ok.  My IE
cookie
> setting is medium, but that's what it's always been.  If  someone could
tell
> me how to get all mailings that would be appreciated also!
> 
> Thanks in advance. 
> 
> Ed Burwell
> [EMAIL PROTECTED]
> 973.361.5400 x1512

The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Periodic COMO file problem

2004-01-27 Thread Robert Porter




It's a Type 1 file. And editing any record even a new one in the file 
(really a directory) would result in the problem.  I would think, if it was 
a bad spot on the disk, predictive support should have shown it by 
now. Even if it was bad, everything is mirrored with MirrorDisk/UX, LVM 
w/OnlineJFS. That LE should have gone stale and the mirror should have taken 
over. But it's a direction I haven't considered and worth looking into. 
Thanks.  
 
As for it being large, even the small/new records did this. We left them 
there for a couple hours, waiting until we could bring the system down and it 
still never worked.
 
Thanks,
rfp
>>> [EMAIL PROTECTED] 01/27/04 04:56PM 
>>>
I had this happen a couple of times when I worked on an HP 
system. Turned out to be a bad spot on the disk drive. Then again how big is the 
como file? If the file is large it could take a while to bring it into memory, 
if it doesn't get a memory full error first.

  - Original Message - 
  From: 
  Robert 
  Porter 
  To: [EMAIL PROTECTED] 
  Sent: Tuesday, January 27, 2004 4:05 
  PM
  Subject: Periodic COMO file problem
  
  This has happened a couple of times now.  The &COMO& file 
  somehow becomes "corrupt" - for the lack of a better explaination.  Any 
  attempt to edit a record in it results in a severely hung process. You won't 
  be able to break out of it. MASTER OFF (usernumber) doesn't work.  A 
  standard kill at the Unix level won't touch it either. It will take a kill -9 
  to get rid of the user.  
   
  This is on a UniVerse 9.5.1.1 box running under HP-UX 11.0.  It's 
  run fine for a couple of years now, and has recently (past few months) begun 
  strange occurances like this.  It's also periodically corrupted a few 
  dynamic type files as well.  On those, it simple would fail with a Fault 
  Type X (11/13 IIRC).  Anyone experienced anything like this before?
   
  TIA,
  Robert
  
  

  ___u2-users mailing 
  list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: looking for faster Ideas...

2004-01-27 Thread Craig Bennett

George,

I don't know if this will help you, but part of the problem with a CASE
statement is that every statement is tested until you have a match and EVERY
statement is tested if there is no match. If you don't have a large number
to remove, this can get very wasteful.

When I need to parse some data and I need to do it fast (and I don't care
that I may write a very long tedious program (sometime I even write a
program to build the final program)) I find that a state machine model with
computed gosubs based on ASCII character numbers can be quicker.

I started writing the code below, but then remembered I had to work :(

The basic Idea is to only test the characters you need and to test them one
by one where each letter in a match is another internal subroutine eg:

LOOP WHILE POS LE (DATALEN - MATCHLEN) DO
* Just match A-Z and we are only looking for names starting with A and T
CHARCODE = SEQ(MYDATA[POS, 1]);* Under UV BYTEVAL(MYDATA, POS)
is MUCH quicker.
ON CHARCODE + 64 GOSUB NOMATCH,
FIRSTCHARA,
NOMATCH,;* B
NOMATCH,;* C
NOMATCH,;* D
NOMATCH,;* E
NOMATCH,;* F
NOMATCH,;* G
NOMATCH,;* H
NOMATCH,;* I
NOMATCH,;* J
NOMATCH,;* K
NOMATCH,;* L
NOMATCH,;* M
NOMATCH,;* N
NOMATCH,;* O
NOMATCH,;* P
NOMATCH,;* Q
NOMATCH,;* R
NOMATCH,;* S
FIRSTCHART,
NOMATCH,;* U
NOMATCH,;* V
NOMATCH,;* W
NOMATCH,;* X
NOMATCH,;* Y
NOMATCH,;* Z
NOMATCH

REPEAT

NOMATCH:
* Set a flag to false
MATCH.NAME = 0
RETURN

FIRSTCHARA:
POS += 1
CHARCODE = SEQ(MYDATA[POS, 1])
ON CHARCODE + 64 GOSUB NOMATCH,
NOMATCH,;* A
SECONDCHARB,
NOMATCH,;* C
NOMATCH,;* D
NOMATCH,;* E
NOMATCH,;* F
NOMATCH,;* G
NOMATCH,;* H
NOMATCH,;* I
NOMATCH,;* J
NOMATCH,;* K
NOMATCH,;* L
NOMATCH,;* M
NOMATCH,;* N
NOMATCH,;* O
NOMATCH,;* P
NOMATCH,;* Q
NOMATCH,;* R
NOMATCH,;* S
SECONDCHART,
NOMATCH,;* U
NOMATCH,;* V
NOMATCH,;* W
NOMATCH,;* X
NOMATCH,;* Y

Converting between Java/UniData dates

2004-01-27 Thread Wendy Smoak


Datatel has stored an internal Java date in a database field.  Would
anyone like to take up the challenge of writing a UniBasic utility to
convert between that and UniData internal date format, and then OCONV
the result?

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

They provide a DATE.CONVERT utility that converts between
internal/external format at the colon prompt.  Perhaps a subroutine that
could be used in an I-Descriptor would be useful here, so you can get a
human-readable date from the Java internal date.

-- 
Wendy Smoak
Application Systems Analyst, Sr.
ASU IA Information Resources Management 
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Periodic COMO file problem

2004-01-27 Thread John Jenkins




Robert
 
Other than hardware 
related issues (check the disk...) (I see Jerry spotted this one 
:-)
 
The &COMO& file 
is really an O/S level directory - when you run ED you are running a BASIC 
program which does a READ on a record (file) in the file 
(directory).
 
If the file is massive - 
as is quite possible .. then this will churn the system 
terribly.
Check the file size at 
the O/S before you use the ED command - or after if it seems to 
hang...
 
You can play around with 
increasing various limits - but the bottom line is don't do it -  if your 
&COMO& files are that big I would lay odds their 
main use is  occasional diagnostics or an audit trail (if needed) 
(no-one reads a 1000 page report)
 
You can use the sed 
command at Unix if you need to manipulate something really big - otherwise you 
could use vi (sed is less friendly - but I think it can handle bigger 
files..
 
If you are using a 
program then take a look at OPENSEQ/READSEQ/WRITESEQ/CLOSESEQ (don't forget 
CLOSESEQ ! ) rather than OPEN/READ/WRITE.
 
One other possibility is 
a no-no character in the file - but this usually results in truncation rather 
than any other symptom.
 
 
Regards
JayJay


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
On Behalf Of Robert PorterSent: 27 January 2004 
22:05To: [EMAIL PROTECTED]Subject: Periodic COMO file 
problem

This has happened a couple of times now.  The &COMO& file 
somehow becomes "corrupt" - for the lack of a better explaination.  Any 
attempt to edit a record in it results in a severely hung process. You won't be 
able to break out of it. MASTER OFF (usernumber) doesn't work.  A 
standard kill at the Unix level won't touch it either. It will take a kill -9 to 
get rid of the user.  
 
This is on a UniVerse 9.5.1.1 box running under HP-UX 11.0.  It's run 
fine for a couple of years now, and has recently (past few months) begun strange 
occurances like this.  It's also periodically corrupted a few dynamic type 
files as well.  On those, it simple would fail with a Fault Type X (11/13 
IIRC).  Anyone experienced anything like this before?
 
TIA,
Robert
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Periodic COMO file problem

2004-01-27 Thread John Jenkins




Hmmm
 
what's your MFILES 
?
 
Regards
 
JayJay
 


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
On Behalf Of Robert PorterSent: 27 January 2004 
23:10To: [EMAIL PROTECTED]Subject: Re: Periodic COMO 
file problem

It's a Type 1 file. And editing any record even a new one in the file 
(really a directory) would result in the problem.  I would think, if it was 
a bad spot on the disk, predictive support should have shown it by 
now. Even if it was bad, everything is mirrored with MirrorDisk/UX, LVM 
w/OnlineJFS. That LE should have gone stale and the mirror should have taken 
over. But it's a direction I haven't considered and worth looking into. 
Thanks.  
 
As for it being large, even the small/new records did this. We left them 
there for a couple hours, waiting until we could bring the system down and it 
still never worked.
 
Thanks,
rfp
 
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: ODBC Set Up Universe

2004-01-27 Thread Stuart Boydell

setup a trigger on a uv file:

create.file testfile 30 (nb. information flavour account commands)
create.file testbp 19
ed testbp trigHandler
  0001: subroutine trigHandler(TriggerName,Schema,TableName,Event,
  0002: EventTime,NewRecordID,NewRecord,OldRecordID,OldRecord,
  0003: Association,AssociationEvent,TriggerCount,ChainCascade,Cascade)
  0004: return
basic testbp trigHandler
catalog testbp trigHandler (or catalog testbp *trigHandler)
create trigger AfterUpdate after update on testfile for each row calling
"trigHandler";

---

Make an account visible to ODBC & UniOLEDB:
logto HS.ADMIN
>HS.ADMIN
Action 3, Activate access to files in an account.

The process of making files visible does the following:
Scans the dictionaries of all nonsystem files named in the VOC, finding all
associations and unassociated multivalued columns.
Writes an @EMPTY.NULL X-record in each file dictionary.
Writes S or M in field 5 of A- and S-descriptors.
Creates Q-pointers in the VOC for files comprising multiple data files.
Creates an HS_FILE_ACCESS file in the account.
Creates a file information cache (.hs_fileinfo) under the accounts
directory, which contains a compressed list of all 1NF filenames in the
account and is used by the UniOLEDB provider to rapidly construct the TABLES
rowset whenever a consumer requests it to do so.
Updates the UV.ACCOUNT file to indicate that the files in the account have
been made visible.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of John Reid
Sent: Wednesday, 28 January 2004 06:14
To: '[EMAIL PROTECTED]'
Subject: RE: ODBC Set Up Universe


Group,

I had the trigger on a table on a development system until it got
overwritten on the week-end. However, we never had a file named
HS_FILE_ACCESS.  I had created it, but I don't feel that its presence had
much to do with whatever success I had. Is it supposed to 'MATERIALIZE'?

My objective is to create a trigger on an existing file.  Try as I might, I
am unable to re-create what I did before.  Could someone go over the steps
one more time?  And possibly, could someone state the function of the
HS.UPDATE.FILEINFO?

I'm not against reading what ever I need to read, but it seems that at least
some people have had negative rewards for their reading efforts.
thanks.
john reid




**
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 viruses.
**

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: UD Coding a 'Hard Carriage Return" for an Excel file

2004-01-27 Thread Richard Lewis




If you want to insert the line break in excel's 'native 
language'/character set, shouldn't you be creating the file in excel's native 
format, rather than as a tab-delimited file?  I'm afraid I don't know the 
solution either, but that may at least explain the results you're 
getting.

Richard 
B. Lewis
Sr. 
Software Engineer
 
Dynix
[EMAIL PROTECTED]
p 
801-223-5392
f  801-223-5202
www.dynix.com
-Original 
Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
On Behalf Of Burwell, EdwardSent: Tuesday, January 27, 2004 3:51 PMTo: 
'[EMAIL PROTECTED]'Subject: UD Coding a 'Hard Carriage Return" for an 
Excel fileHello,I am creating a tab-delimted file with and xls 
extension that excel is very happy to open.  I would like to create a cell 
that has line-breaks or Hard-Carriage-Returns in them.  You can accomplish 
this manually by pressingALT+ENTER while entering data into a cell.  I 
belive the character isALT+thesame as what you get in MSWORD when you 
hold the ALT key and enter 0010. Here is a snippet of the code that 
I am using:284:   TAB=CHAR(9) ; 
CR=CHAR(13) ; LF=CHAR(10) ; CRLF=CR:LF285:  
* *286:   
HDR=SOURCE:TAB287:   
HDR:=\=\:QUOTE(INVOICE):TAB  ; * to force excel to see this 
astext288:   
HDR:=CUST:TAB289:  * ADDRESS 
*290:   IF FULL.ADDRESS 
THEN290: * set Line 
Break character *291: *    
LB=CHAR(1034) ; * CHAR(10) + CHAR(1024) - ALT KEY292: 
*    LB=CR   ; * 
CHAR(13)293: *    LB=CRLF ; * 
CHAR(13) : 
CHAR(10)294:  
LB=LF   ; * 
CHAR(10)295:  
ADDR=NAME:LB296:  IF 
LEN(AD1) THEN 
ADDR:=AD1:LB297:  IF 
LEN(AD2) THEN 
ADDR:=AD2:LB298:  IF 
LEN(ATTN) THEN 
ADDR:=ATTN:LB299:  
ADDR:=CITY:", ":ST:"  
":ZIP300:  
HDR:=QUOTE(ADDR):TAB301:   END 
ELSE302:  
HDR:=NAME:TAB303:   ENDWhen I 
manually enter data into a cell and press ALT+ENTER for a hard-carriage-return, 
then copy and paste that cell into notepad, I see a square non-printable 
character where the carriage-returns were.  When I look at that square in a 
hex viewer, its 0A or ASCII 10, char(10), the line feed character.When I 
run the above code then open the file in excel and look at the cell, it seems to 
work, however, now there is a visible square right where I put the 
char(10)'s!  I get the same result when I use CRLF as well.  When I 
use CR only, it doesn't wrap at all.Any help would be greatly 
appreciated.Also - I am only receiving the Digest, but I want to receive 
all postings (and the Digest).  I went to the site and my settings look 
ok.  My IE cookie setting is medium, but that's what it's always 
been.  If someone could tell me how to get all mailings that would be 
appreciated also!Thanks in advance.Ed 
Burwell[EMAIL PROTECTED]973.361.5400 
x1512___u2-users mailing 
list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Liz H Stoelker/User/MWLtd/Montgomery Watson is out of the office.

2004-01-27 Thread Liz . H . Stoelker

I will be out of the office starting  26/01/2004 and will not return until
30/01/2004.

I am a course on 26,27 and 28 Jan 2004. I will be back in the office on
Friday.

=
This electronic communication and its attachments may contain confidential,
proprietary and/or legally privileged information and are for the sole use
of the intended recipient. If you are not the intended recipient, any use,
distribution, or reproduction of this communication is strictly prohibited
and may be unlawful; please contact the sender and delete this
communication.
MWH does not warrant or make any representation regarding this transmission

whatsoever nor does it warrant that it is free from viruses or defects,
correct or reliable. MWH is not liable for any loss or damage that occurs
as a result of this communication entering your computer network.

The views expressed in this message are not necessarily those of MWH.
This communication cannot form a binding agreement unless that is the
express
intent of the parties and they are authorized to make such an agreement.
MWH reserves all intellectual property rights contained in this
transmission.
MWH reserves the right to monitor any electronic communication sent or
received by its employees.


___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: UD Coding a 'Hard Carriage Return" for an Excel file

2004-01-27 Thread Tony Gravagno

Ed, the data that needs to be in the CSV is:
"one" : char(10) : "two"

The character Excel uses is indeed a LF, not a CR or CRLF.  When you open
Excel, you will still see a square rather than multiple lines.  To remove
the square, you need to set the WrapText property of the cells in question
(or the whole sheet) to True.

You can automate that with a macro or a COM Add-in, you can't manipulate the
worksheet from CSV data, even with embedded formulas.  It seems to me you
don't mind doing manual processes, as in order to see your multiline data
you will need to manually reset the size of the rows in question anyway.

For what it's worth, my NebulAnalysis software does all this automatically
with BASIC code directly from a MV app.  See these pages if you're
interested:
http://nebula-rnd.com/products/analysis.htm
and for an audio/video demo:
http://nebula-rnd.com/demos/nebulanalysis/

HTH,
Tony



>-Original Message-
>From: [EMAIL PROTECTED] 
>[mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward
>Sent: Tuesday, January 27, 2004 2:51 PM
>To: '[EMAIL PROTECTED]'
>Subject: UD Coding a 'Hard Carriage Return" for an Excel file
>
>
>Hello,
>
>I am creating a tab-delimted file with and xls extension that 
>excel is very happy to open.  I would like to create a cell 
>that has line-breaks or Hard-Carriage-Returns in them.  You 
>can accomplish this manually by pressing
>ALT+ENTER while entering data into a cell.  I belive the character is 
>ALT+the
>same as what you get in MSWORD when you hold the ALT key and 
>enter 0010.  
>
>Here is a snippet of the code that I am using:
>
>284:   TAB=CHAR(9) ; CR=CHAR(13) ; LF=CHAR(10) ; CRLF=CR:LF
>285:  * *
>286:   HDR=SOURCE:TAB
>287:   HDR:=\=\:QUOTE(INVOICE):TAB  ; * to force excel to 
>see this as
>text
>288:   HDR:=CUST:TAB
>289:  * ADDRESS *
>290:   IF FULL.ADDRESS THEN
>290: * set Line Break character *
>291: *LB=CHAR(1034) ; * CHAR(10) + CHAR(1024) - ALT KEY
>292: *LB=CR   ; * CHAR(13)
>293: *LB=CRLF ; * CHAR(13) : CHAR(10)
>294:  LB=LF   ; * CHAR(10)
>295:  ADDR=NAME:LB
>296:  IF LEN(AD1) THEN ADDR:=AD1:LB
>297:  IF LEN(AD2) THEN ADDR:=AD2:LB
>298:  IF LEN(ATTN) THEN ADDR:=ATTN:LB
>299:  ADDR:=CITY:", ":ST:"  ":ZIP
>300:  HDR:=QUOTE(ADDR):TAB
>301:   END ELSE
>302:  HDR:=NAME:TAB
>303:   END
>
>When I manually enter data into a cell and press ALT+ENTER for 
>a hard-carriage-return, then copy and paste that cell into 
>notepad, I see a square non-printable character where the 
>carriage-returns were.  When I look at that square in a hex 
>viewer, its 0A or ASCII 10, char(10), the line feed character.
>
>When I run the above code then open the file in excel and look 
>at the cell, it seems to work, however, now there is a visible 
>square right where I put the char(10)'s!  I get the same 
>result when I use CRLF as well.  When I use CR only, it 
>doesn't wrap at all.
>
>Any help would be greatly appreciated.
>
>Also - I am only receiving the Digest, but I want to receive 
>all postings (and the Digest).  I went to the site and my 
>settings look ok.  My IE cookie setting is medium, but that's 
>what it's always been.  If someone could tell me how to get 
>all mailings that would be appreciated also!
>
>Thanks in advance. 
>
>Ed Burwell
>[EMAIL PROTECTED]
>973.361.5400 x1512 ___
>u2-users mailing list
>[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
>
>

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Converting between Java/UniData dates

2004-01-27 Thread Larry Hiscock

Java dates are stored internally as the number of milliseconds since the
standard base time known as "the epoch" (1 Jan 1970 00:00:00 GMT).  Since
1/1/1970 is day 732 in the multivalue world, the conversion should be
simply: INT(JAVA.DT / 8640) + 732 - (JAVA.DT < 0)

You could put this in an I-descriptor as follows:

I
INT(JAVA.DATE / 8640) + 732 - (JAVA.DATE < 0)
D4-
DATE
10R
S


The '- (JAVA.DATE.FIELD < 0)' at the end is necessary to deal with
correcting for the way the INT() function deals with negative numbers.


Larry Hiscock
Western Computer Services
http://www.wcs-corp.com



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Wendy Smoak
Sent: Tuesday, January 27, 2004 3:28 PM
To: U2 Users Discussion List
Subject: Converting between Java/UniData dates



Datatel has stored an internal Java date in a database field.  Would
anyone like to take up the challenge of writing a UniBasic utility to
convert between that and UniData internal date format, and then OCONV
the result?

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

They provide a DATE.CONVERT utility that converts between
internal/external format at the colon prompt.  Perhaps a subroutine that
could be used in an I-Descriptor would be useful here, so you can get a
human-readable date from the Java internal date.

--
Wendy Smoak
Application Systems Analyst, Sr.
ASU IA Information Resources Management
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: mkdbfile: create file in another account

2004-01-27 Thread Kate Stanton

Title: Message




Thanks.  That (using DOS \C rather than sh 
-c)  got rid of the error message, but it did not seem to create 
a file.
 
Looks like I have the wrong syntax, but it is 
rather hard to look up the documentation!
 
I still feel uncomfortable using an undocumented 
feature - no security it will not disappear or change.
 
 - Original Message - 

  From: 
  Daly, Mark 
  
  To: 'U2 Users Discussion List' 
  Sent: Wednesday, January 28, 2004 10:23 
  AM
  Subject: RE: mkdbfile: create file in 
  another account
  
  Well, I just posed 
  this question - and mkdbfile was the suggestion that 
  won!
   
  However, I didn't 
  create a VOC entry. The idea (I believe) is to execute this command at the OS 
  prompt - not TCL.
   
  Since it looks 
  like you're on Windows it would be something like so:
   
  EXECUTE 'sh 
  -c "cd C:\BeaconUV\DevelData\XXINV\KKINV; ':SYSTEM(32):'\bin\mkdbfile 
  DATA \XXINV\KKINV 30 1 4 20 50 80 1068'
   
  
   It's not documented, since it's really 
  an internal UV command - as opposed to a TCL statement of BASIC 
  function.
   
  The CREATE.FILE verb needs to be 
  enhanced to perform this function - and prevent us from dabbling in the 'bin' 
  directory. But until then - this is the way to go.
   
  HTH,
   
  Mark.
   
   Original 
  Message-From: Kate Stanton [mailto:[EMAIL PROTECTED] 
  Sent: Tuesday, January 27, 2004 4:17 PMTo: 
  [EMAIL PROTECTED]Subject: mkdbfile: create file in another 
  account
  Does anyone know anything about using mkdbfile 
  (from UV bin) to create a file in an account other than the current user 
  account?
   
  A colleague told me about it, but it does not 
  seem to be documented, and does not seem to work on my  
   
   UV 
  10.0.17 system on Windows 2000, as it does on his UV 9.5.2.1 on Windows 
  something.
   
  I tried, according to his 
  instructions:
  VOC mkdbfile
  0001: V
  0002: mkdbfile
  0003: E
  0004: FG
  0005:
  0006: PICK.FORMAT
   
  Then, from TCL: mkdbfile 
  C:\BeaconUV\DevelData\XXINV\KKINV 30 1 4 20 50 80 1068
  where:
  C:\BeaconUV\DevelData\XXINV\KKINV is pathname of 
  file to create
  30 is file type
  1 is modulo
  4 is separation
  20 is hash type
  50 is max load
  80 is split load
  1096 is large record size
   
  This gave error message: invalid filetype 
  specified
   
  I feel very nervous about using something that is 
  not documented, so presumably may not be reliably supported.
   
  Anyone know anything, please?
   
  Cheers,  Kate
   
  Kate StantonWalstan Systems Ltd4 Kelmarna 
  Ave, Herne Bay, Auckland, New Zealandph +64 9 360 5310  fax +64 9 376 
  0750ah +64 9 378 9594[EMAIL PROTECTED]
  
  

  ___u2-users mailing 
  list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Converting between Java/UniData dates

2004-01-27 Thread Dawn M. Wolthuis

Why in the world did that do that?  Is it in WebAdvisor?  

So, in the Datatel Colleague and Benefactor products there are hundreds if
not thousands of PICK dates and exactly 1 Java date stored?  I guess the
good thing about standards is that everyone can come up with their own, eh?
Smiles.  --dawn

Dawn M. Wolthuis
Tincat Group, Inc.
www.tincat-group.com

Take and give some delight today.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Wendy Smoak
Sent: Tuesday, January 27, 2004 5:28 PM
To: U2 Users Discussion List
Subject: Converting between Java/UniData dates


Datatel has stored an internal Java date in a database field.  Would
anyone like to take up the challenge of writing a UniBasic utility to
convert between that and UniData internal date format, and then OCONV
the result?

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

They provide a DATE.CONVERT utility that converts between
internal/external format at the colon prompt.  Perhaps a subroutine that
could be used in an I-Descriptor would be useful here, so you can get a
human-readable date from the Java internal date.

-- 
Wendy Smoak
Application Systems Analyst, Sr.
ASU IA Information Resources Management 
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: mkdbfile: create file in another account

2004-01-27 Thread djordan

Title: Message



Hi 
Kate
 
The 
SQL Create Table command allows you to create a file in another directory and it 
is documented.
 
Regards
 



David JordanManaging Consultant[EMAIL PROTECTED]
Dacono Holdings Pty LtdBusiness & Technology 
ConsultingPO Box 
909Lane Cove NSW 2066AustraliaPh 61 2 9418 8329Fax 61 
2 9427 2371www.dacono.com.au 


  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf 
  Of Kate StantonSent: Wednesday, 28 January 2004 8:17 
  AMTo: [EMAIL PROTECTED]Subject: mkdbfile: create file 
  in another account
  Does anyone know anything about using mkdbfile 
  (from UV bin) to create a file in an account other than the current user 
  account?
   
  A colleague told me about it, but it does not 
  seem to be documented, and does not seem to work on my UV 10.0.17 system on 
  Windows 2000, as it does on his UV 9.5.2.1 on Windows something.
   
  I tried, according to his 
  instructions:
  VOC mkdbfile
  0001: V
  0002: mkdbfile
  0003: E
  0004: FG
  0005:
  0006: PICK.FORMAT
   
  Then, from TCL: mkdbfile 
  C:\BeaconUV\DevelData\XXINV\KKINV 30 1 4 20 50 80 1068
  where:
  C:\BeaconUV\DevelData\XXINV\KKINV is pathname of 
  file to create
  30 is file type
  1 is modulo
  4 is separation
  20 is hash type
  50 is max load
  80 is split load
  1096 is large record size
   
  This gave error message: invalid filetype 
  specified
   
  I feel very nervous about using something that is 
  not documented, so presumably may not be reliably supported.
   
  Anyone know anything, please?
   
  Cheers,  Kate
   
  Kate StantonWalstan Systems Ltd4 Kelmarna 
  Ave, Herne Bay, Auckland, New Zealandph +64 9 360 5310  fax +64 9 376 
  0750ah +64 9 378 9594[EMAIL PROTECTED]
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

UNCLASSIFIED RE: mkdbfile: create file in another account

2004-01-27 Thread HENDERSON MICHAEL MR

Title: Message



Kate
 
You may be 
striking a bug in the UV "dos /c ..." command, which has some, err, foibles 
...
 
1)  The 
command string MUST be enclosed in single quotes (this is not documented 
anywhere)
  so, you must say DOS /c '
  not DOS /c "
 
2)  If you try to pass a parameter enclosed in double 
quotes, you are in trouble :-(
 So DOS /c 'blat.exe -s:"a subject with 
spaces" ...' just doesn't work, the double quotes get 
mangled.
 
I have cases 
opened on both issues with IBM, and have tested a patched version of UV that 
solves the second problem.  I understand this will be released with the 
next windows 10.0.x version, and presumably included in the subsequent 
10.1.x.  Dunno when, if ever, the documentation issue will be 
addressed.
 
The 
work-round for the second problem that is least awful is to generate a batch 
file (DOS .bat extension) on the fly in your UniBasic program, and then run that 
.bat file from the DOS /c command.
 
Call me on 
(04) 2371828 if you want a better explanation!
 
HTH
 
Mike

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Kate 
  StantonSent: Wednesday, 28 January 2004 3:32 p.m.To: U2 
  Users Discussion ListSubject: Re: mkdbfile: create file in another 
  account
  
  Thanks.  That (using DOS \C rather than sh 
  -c)  got rid of the error message, but it did not seem 
  to create a file.
   
  Looks like I have the wrong syntax, but it is 
  rather hard to look up the documentation!
   
  I still feel uncomfortable using an undocumented 
  feature - no security it will not disappear or change.
   
   - Original Message - 
  
From: 
Daly, Mark 

To: 'U2 Users Discussion List' 
Sent: Wednesday, January 28, 2004 10:23 
AM
Subject: RE: mkdbfile: create file in 
another account

Well, I just 
posed this question - and mkdbfile was the suggestion that 
won!
 
However, I 
didn't create a VOC entry. The idea (I believe) is to execute this command 
at the OS prompt - not TCL.
 
Since it looks 
like you're on Windows it would be something like so:
 
EXECUTE 
'sh -c "cd C:\BeaconUV\DevelData\XXINV\KKINV; ':SYSTEM(32):'\bin\mkdbfile 
DATA \XXINV\KKINV 30 1 4 20 50 80 1068'
 

 It's not documented, since it's 
really an internal UV command - as opposed to a TCL statement of BASIC 
function.
 
The CREATE.FILE verb needs 
to be enhanced to perform this function - and prevent us from dabbling in 
the 'bin' directory. But until then - this is the way to 
go.
 
HTH,
 
Mark.
 
 Original 
Message-From: Kate Stanton [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 27, 2004 4:17 PMTo: 
[EMAIL PROTECTED]Subject: mkdbfile: create file in another 
account
Does anyone know anything about using mkdbfile 
(from UV bin) to create a file in an account other than the current user 
account?
 
A colleague told me about it, but it does not 
seem to be documented, and does not seem to work on my  
 
 UV 
10.0.17 system on Windows 2000, as it does on his UV 9.5.2.1 on Windows 
something.
 
I tried, according to his 
instructions:
VOC mkdbfile
0001: V
0002: mkdbfile
0003: E
0004: FG
0005:
0006: PICK.FORMAT
 
Then, from TCL: mkdbfile 
C:\BeaconUV\DevelData\XXINV\KKINV 30 1 4 20 50 80 1068
where:
C:\BeaconUV\DevelData\XXINV\KKINV is pathname 
of file to create
30 is file type
1 is modulo
4 is separation
20 is hash type
50 is max load
80 is split load
1096 is large record size
 
This gave error message: invalid filetype 
specified
 
I feel very nervous about using something that 
is not documented, so presumably may not be reliably supported.
 
Anyone know anything, please?
 
Cheers,  Kate
 
Kate StantonWalstan Systems Ltd4 
Kelmarna Ave, Herne Bay, Auckland, New Zealandph +64 9 360 5310  
fax +64 9 376 0750ah +64 9 378 9594[EMAIL PROTECTED]



___u2-users mailing 
list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users
The information contained in this Internet Email 
message is intended for the addressee only and may contain privileged 
information, but not necessarily the official views or opinions of the New 
Zealand Defence Force.  If you are not the intended recipient you must not 
use, disclose, copy or distribute this message or the information in 
it.  If you have received this message in error, please Email or telephone 
the sender immediately.

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: mkdbfile: create file in another account

2004-01-27 Thread djordan

Title: Message



Hi 
Kate
 
You 
could set up a VOC Paragraph or a program in the remote account that reads 
parameters from the command line as paramters for the CREATE FILE statement. 
Then all you are doing is using the EXECUTE 'DOS uvbinpath\UV remoteacc\PROG fn 
mod "  
 
At 
least this will not disappear.  
 
otherwise create the file in the current director, doan OS Move and then 
build the VOC item through a setfile pointer
 
else 
CREATE TABLE path Filename
 
 
Regards
 



David JordanManaging Consultant[EMAIL PROTECTED]
Dacono Holdings Pty LtdBusiness & Technology 
ConsultingPO Box 
909Lane Cove NSW 2066AustraliaPh 61 2 9418 8329Fax 61 
2 9427 2371www.dacono.com.au 


  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf 
  Of Kate StantonSent: Wednesday, 28 January 2004 1:32 
  PMTo: U2 Users Discussion ListSubject: Re: mkdbfile: 
  create file in another account
  
  Thanks.  That (using DOS \C rather than sh 
  -c)  got rid of the error message, but it did not seem 
  to create a file.
   
  Looks like I have the wrong syntax, but it is 
  rather hard to look up the documentation!
   
  I still feel uncomfortable using an undocumented 
  feature - no security it will not disappear or change.
   
   - Original Message - 
  
From: 
Daly, Mark 

To: 'U2 Users Discussion List' 
Sent: Wednesday, January 28, 2004 10:23 
AM
Subject: RE: mkdbfile: create file in 
another account

Well, I just 
posed this question - and mkdbfile was the suggestion that 
won!
 
However, I 
didn't create a VOC entry. The idea (I believe) is to execute this command 
at the OS prompt - not TCL.
 
Since it looks 
like you're on Windows it would be something like so:
 
EXECUTE 
'sh -c "cd C:\BeaconUV\DevelData\XXINV\KKINV; ':SYSTEM(32):'\bin\mkdbfile 
DATA \XXINV\KKINV 30 1 4 20 50 80 1068'
 

 It's not documented, since it's 
really an internal UV command - as opposed to a TCL statement of BASIC 
function.
 
The CREATE.FILE verb needs 
to be enhanced to perform this function - and prevent us from dabbling in 
the 'bin' directory. But until then - this is the way to 
go.
 
HTH,
 
Mark.
 
 Original 
Message-From: Kate Stanton [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 27, 2004 4:17 PMTo: 
[EMAIL PROTECTED]Subject: mkdbfile: create file in another 
account
Does anyone know anything about using mkdbfile 
(from UV bin) to create a file in an account other than the current user 
account?
 
A colleague told me about it, but it does not 
seem to be documented, and does not seem to work on my  
 
 UV 
10.0.17 system on Windows 2000, as it does on his UV 9.5.2.1 on Windows 
something.
 
I tried, according to his 
instructions:
VOC mkdbfile
0001: V
0002: mkdbfile
0003: E
0004: FG
0005:
0006: PICK.FORMAT
 
Then, from TCL: mkdbfile 
C:\BeaconUV\DevelData\XXINV\KKINV 30 1 4 20 50 80 1068
where:
C:\BeaconUV\DevelData\XXINV\KKINV is pathname 
of file to create
30 is file type
1 is modulo
4 is separation
20 is hash type
50 is max load
80 is split load
1096 is large record size
 
This gave error message: invalid filetype 
specified
 
I feel very nervous about using something that 
is not documented, so presumably may not be reliably supported.
 
Anyone know anything, please?
 
Cheers,  Kate
 
Kate StantonWalstan Systems Ltd4 
Kelmarna Ave, Herne Bay, Auckland, New Zealandph +64 9 360 5310  
fax +64 9 376 0750ah +64 9 378 9594[EMAIL PROTECTED]



___u2-users mailing 
list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: UD Coding a 'Hard Carriage Return" for an Excel file

2004-01-27 Thread Stuart Boydell

Edward,
char(10) is the correct character to use. It might be being modified when
you write out the file to a type 1/19 file as char(13)char(10).
Try using ASSIGN @TRUE TO SYSTEM(1017) before you write the file. This
should stop UV converting the char(10) character if that's what's happening.

EQU TAB TO CHAR(9), LF TO CHAR(10), CR TO CHAR(13), QT TO '"'
TXT = 123:TAB:QT:'ABC':LF:'DEF':QT:CR:LF:'HIJ':TAB:'JKL':CR:LF
ASSIGN @TRUE TO SYSTEM(1017)
WRITE TXT ON F.FILE,'output.txt'

The problem with Excel, or at least one of the problems, is that it "thinks"
it knows what you are trying to do. Unfortunately, line breaks are
problematic. Trying to read a tab file with line breaks saved from excel
invokes the impotent wizend, oops, i mean import wizard, and ends up
mangling the line break. Opening the file in notepad and copying it to the
clipboard then pasting it to excel does work just fine. Go figure. Even
using html where you would think that a  should work as a line break,
doesn't.

If your terminal emulator supports windows objects (SBClient, Host Access,
Wintegrate etc) I reckon using the windows clipboard is the way to go,
transferring tab delimited data to an activex/com spreadsheet. We use
SBClient for this and it works fast and efficiently for us even with very
large amounts of data.

Cheers,
Stuart




-Original Message-
On Behalf Of Burwell, Edward

I am creating a tab-delimted file with and xls extension that excel is very
happy to open.  I would like to create a cell that has line-breaks or
Hard-Carriage-Returns in them.
...
it seems to work, however, now there is a visible square right where I put
the char(10)'s!  I get the same result when I use CRLF as well.  When I use
CR only, it doesn't wrap at all.

Any help would be greatly appreciated.













**
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 viruses.
**

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: mkdbfile: create file in another account

2004-01-27 Thread Tom Firl

Title: Message



I 
don't think you need to "cd" command as the mkdbfile will accept the absolute 
path to the file you are creating.  If you need to execute multiple 
commands in the same DOS shell, then separate the commands with an ampersand 
(&) instead of semi-colon (;).
 
I'd be 
a little surprised if mkdbfile disappeared or required changes to your code, but 
you never know.  I'm pretty sure the Universe installation scripts/programs 
-- among other things -- use mkdbfile quite extensively.
 
At any 
rate, give the following a whirl...
 

EXECUTE 'DOS /C 
"':SYSTEM(32):'\bin\mkdbfile C:\BeaconUV\DevelData\XXINV\KKINV 30 1 4 20 50 
80 1068"'
 
Tom Firl
Columbia 
Ultimate

  -Original Message-From: Kate Stanton 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 27, 2004 6:32 
  PMTo: U2 Users Discussion ListSubject: Re: mkdbfile: 
  create file in another account
  
  Thanks.  That (using DOS \C rather than sh 
  -c)  got rid of the error message, but it did not seem 
  to create a file.
   
  Looks like I have the wrong syntax, but it is 
  rather hard to look up the documentation!
   
  I still feel uncomfortable using an undocumented 
  feature - no security it will not disappear or change.
   
   - Original Message - 
  
From: 
Daly, Mark 

To: 'U2 Users Discussion List' 
Sent: Wednesday, January 28, 2004 10:23 
AM
Subject: RE: mkdbfile: create file in 
another account

Well, I just 
posed this question - and mkdbfile was the suggestion that 
won!
 
However, I 
didn't create a VOC entry. The idea (I believe) is to execute this command 
at the OS prompt - not TCL.
 
Since it looks 
like you're on Windows it would be something like so:
 
EXECUTE 
'sh -c "cd C:\BeaconUV\DevelData\XXINV\KKINV; ':SYSTEM(32):'\bin\mkdbfile 
DATA \XXINV\KKINV 30 1 4 20 50 80 1068'
 

 It's not documented, since it's 
really an internal UV command - as opposed to a TCL statement of BASIC 
function.
 
The CREATE.FILE verb needs 
to be enhanced to perform this function - and prevent us from dabbling in 
the 'bin' directory. But until then - this is the way to 
go.
 
HTH,
 
Mark.
 
 Original 
Message-From: Kate Stanton [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 27, 2004 4:17 PMTo: 
[EMAIL PROTECTED]Subject: mkdbfile: create file in another 
account
Does anyone know anything about using mkdbfile 
(from UV bin) to create a file in an account other than the current user 
account?
 
A colleague told me about it, but it does not 
seem to be documented, and does not seem to work on my  
 
 UV 
10.0.17 system on Windows 2000, as it does on his UV 9.5.2.1 on Windows 
something.
 
I tried, according to his 
instructions:
VOC mkdbfile
0001: V
0002: mkdbfile
0003: E
0004: FG
0005:
0006: PICK.FORMAT
 
Then, from TCL: mkdbfile 
C:\BeaconUV\DevelData\XXINV\KKINV 30 1 4 20 50 80 1068
where:
C:\BeaconUV\DevelData\XXINV\KKINV is pathname 
of file to create
30 is file type
1 is modulo
4 is separation
20 is hash type
50 is max load
80 is split load
1096 is large record size
 
This gave error message: invalid filetype 
specified
 
I feel very nervous about using something that 
is not documented, so presumably may not be reliably supported.
 
Anyone know anything, please?
 
Cheers,  Kate
 
Kate StantonWalstan Systems Ltd4 
Kelmarna Ave, Herne Bay, Auckland, New Zealandph +64 9 360 5310  
fax +64 9 376 0750ah +64 9 378 9594[EMAIL PROTECTED]



___u2-users mailing 
list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Converting between Java/UniData dates

2004-01-27 Thread Stuart Boydell

Unlike "pick" time/dates, milliseconds from 1970-01-01 00:00 UTC or "epoch"
is locality independant. If you have an application distributed over time
zones, and recording events sequentially is important to you, then you will
want to know that an event that occured at 16:00 in Melbourne actually
occured BEFORE an event at 15:00 in Perth*. Using milliseconds from epoch
will give you a sequentially correct numeric stamp with intrinsic date/time
information whereas "pick" time date will require 2 fields and a bit more
work to convert between time zones.

To convert the epoch value to a local date/time is simple, however, if the
location that the recording event occured was not the same as the location
that the conversion program is running in then you would need to take the
time zone of the recording event into account when you do the conversion.
This gets more complex and is a good reason for IBM to include ISO 8601
standard conversion routines in U2!

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

Cheers,
Stuart


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Dawn M. Wolthuis
Sent: Wednesday, 28 January 2004 13:30
To: 'U2 Users Discussion List'
Subject: RE: Converting between Java/UniData dates


Why in the world did that do that?  Is it in WebAdvisor?

So, in the Datatel Colleague and Benefactor products there are hundreds if
not thousands of PICK dates and exactly 1 Java date stored?  I guess the
good thing about standards is that everyone can come up with their own, eh?
Smiles.  --dawn

Dawn M. Wolthuis
Tincat Group, Inc.
www.tincat-group.com

Take and give some delight today.




**
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 viruses.
**

___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

70 matches

Mail list logo