Re: [U2] Excel downloads

[MAJ Programming]

I have a subroutine on Basic called LINE.TO.CSV that accomodates data values
having either single or double quotes. It alternates the delimiting quote
character when necessary and if both are present, it replaces the single one
with an accent. It's usually a text field anyway.

I also have its opposite subroutine called CSV.TO.REC that takes a CSV and
returns it as a attributeXvalue from RowsXColumns. It strips out the bounded
quotes if they're not data. The standard CONVERT would not work as it would
take embedded commas and use 253's.

Unfortunately it has to process each row into an attribute and parse each
line, pairing the quotes.

I also agree that Tabs went out a long time ago. My personal disappointment
is opening a tabbed record in Notepad then saving and the tabs reverted to
spaces. Thus, I avoid tabs.

My 1 cent
Mark Johnson
- Original Message -
From: "IT-Laure Hansen" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, February 13, 2008 12:00 PM
Subject: RE: [U2] Excel downloads


> Comma delimited fields are always a bit of an issue in this case. The
> correct way to program CSVs is to place quotes around the fields, to
> account for just this - but then: what if you have quotes in your
> fields? Tab is usually a "safer" delimiter for the simple reason that it
> is rarely stored as such in data files, but Excel does not handle a
> tab-delimited file quite as well as a CSV file. You can of course use
> I-descriptors that convert quotes to blanks first, or any other
> transformation.
>
> Thus my original question asking for help and tricks: I know what it
> takes to get me to where I want to be, but I am looking for the miracle
> tool that will work for all types of data extractions with minimal data
> massaging and scripting from me.
>
> Thanks,
>
> Laure Hansen,
> City of Redwood City
> Information Technology
> 1017 Middlefield Road
> Redwood City, CA 94063
> Tel 650-780-7087
> Cell 650-207-3235
> Fax 650-556-9204
> [EMAIL PROTECTED]
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Dave Davis
> Sent: Wednesday, February 13, 2008 7:36 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Excel downloads
>
> What if the data fields contain quotes or double-quotes themselves?
> Does this handle that situation?
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett
> Sent: Wednesday, February 13, 2008 4:00 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Excel downloads
>
> Laure
>
> Then it sounds like you could do the option described in these posts
>
>
>
> For those who are lazy to write fancy routines to create CSV files, I've
> created two dict items, namely COMMA and QUOTE, as follows:
>
> COMMA
> 001:  I
> 002:  ","
> 003:
> 004:  ,
> 005:  1T
>
>
> QUOTE
> 001:  I
> 002:  '"'
> 003:
> 004:  "
> 005: 1T
>
>
> To create a CSV file of _ANY_ file data, these dict items either need to
> be in the DICT of every file, OR once off in the DICT.DICT (I think -
> correct me anyone?)
>
>
>
> >> csv imports don't mind excessive spaces...
>
> LIST DFQ COMMA DFQ.ID COMMA ACCOUNT COMMA DATEOP COMMA 21:47:38
> 07-02-08
>
> DFQUOTE.FILE.  ,  QUOTE NO.  ,  ACCOUNT...  ,  DATEOP  ,
> 208-015646-01  ,  208-015646-01  ,  208-015646  ,  04/05/2007  ,
> 205-011887-AH  ,  205-011887-AH  ,  205-011887  ,  10/11/2000  ,
> 202-012637-AH  ,  202-012637-AH  ,  202-012637  ,  16/02/2005  ,
>
>
>
>
> >> to handle numeric fields simply quote them
>
> LIST DFQ COMMA QUOTE DFQ.ID QUOTE COMMA QUOTE ACCOUNT QUOTE 21:50:36
> 07-02
>
> DFQUOTE.FILE. ,'QUOTE NO.','ACCOUNT...
> '
> '208-015646-01,'208-015646-01','208-015646
> '
> '205-011887-AH,'205-011887-AH','205-011887
> '
> '202-012637-AH,'202-012637-AH','202-012637
> '
> '202-014954-01,'202-014954-01','202-014954
> '
>
>
>
>
> And here is where I used it
>
> 0001: PA
> 0002: DISPLAY Saving output as AAQ
> 0003: SP-ASSIGN HS
> 0004: SETPTR 0,300,,0,0,3,BRIEF,NFMT, BANNER AAQ
> 0005: SORT DFQ _
> 0006:  WITH INVOICE <> "" _
> 0007:  BY ACCOUNT _
> 0008:  BY DATEOP _
> 0009:  COMMA DFQ.ID _
> 0010:  COMMA ACCOUNT _
> 0011:  COMMA DATEOP _
> 0012:  COMMA _
> 0013:  COMMA DFQ.HPHONE _
> 0014:  COMMA HPM.HOMEPHONE _
> 0015:  COMMA _
> 0016:  COMMA DFQ.WPHONE _
> 0017:  COMMA HPM.WORKPHONE _
> 0018:  COMMA _
> 0019:  COMMA DFQ.CELL _
> 0020:  COMMA HPM.CELLPHONE _
> 0021:  COMMA _
> 0022:  COMMA DFQ.SPWORKNO _
> 0023:  COMMA HPM.SPWORKPHONE _
> 0024:  COMMA _
> 0025:  COMMA DFQ.SPCELL _
> 0026:  COMMA HPM.SPCELLPHONE _
> 0027:  LPTR NOPAGE HDR.SUP ID.SUP
>
>
>
> And subsequently modified by Kevin
>
> For what it's worth,
>
> I do something similar, but I use TAB.  My Dict item looks like:
>
> 0001: I
>
> 0002: " "
>
> 0003:
>
> 0004: TAB
>
> 0005: 1L
>
> 0006: S
>
>
> Line two is actually "^009", but it shows " ".
>

Re: [U2] CSV output

[MAJ Programming]

An indirect answer would be to send an appropriate ESC sequence to the
screen's status row with the account/branch you are on.

I like accuterm where I can change the caption of the session. I usually put
the Account and Port number as many process use ported work files.

My 1 cent.
Mark Johnson
- Original Message -
From: "Dennis Bartlett" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, February 14, 2008 10:20 AM
Subject: RE: [U2] CSV output


> Hi
>
> Is there any way to change the > prompt to something like BR299>?
>
> It would really help to know where I am, whilst hopping from branch to
> branch.
>
> Thanks
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Excel downloads

[MAJ Programming]

In response to Karen:

It's not an import option issue. A CSV is a member of the Excel class of
data files and when double clicking in explorer, Excel opens it and sSays
"Welcome home" with no import wizard.

My request is to not have any intervention of the user. They can adjust the
columns as necessary themselves as CSV's don't convey column widths although
an earlier response gave me the ="0123" suggestion.

I'm a little hesitant of putting a formula in front of the data but on the
other hand it would only be for those values that are numeric and start with
0. I would not have to use ="Fred" as "Fred" is okay.

Thanks
- Original Message -
From: "Bessel, Karen" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, February 13, 2008 11:43 AM
Subject: RE: [U2] Excel downloads


> I have had similar problems with Excel in the past.
>
> Have you tried importing the column as "text"?
>
> Sometimes that works & sometimes it doesn't. Excel is a very peculiar
> animal indeed.
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming
> Sent: Wednesday, February 13, 2008 8:05 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Excel downloads
>
> On this topic, I have a request for a solution.
>
> In New Jersey, all the zip codes start with '0'. Add product codes like
> 012345 and order numbers like 000123 etc and you'll see the leading
> zeros.
>
> When creating and exporting a CSV to eventually be used by Excel, those
> columns lose their leading zeros as Excel thinks they are numeric.
>
> I know that the users can  and choose Custom etc.
>
> I've converted the same CSV into a HTML boxed record and the zeros
> remain as
> expected.
>
> I've tried prepending the values with an astrophe (single quote) to no
> avail.
>
> The true data (as viewed in Notepad) is exactly as I sent it:
> "07748","012345","000123"
>
> So, any tricks in having Excel leave the zeros alone when clicking on
> the
> CSV in WIndows Explorer. Meaning, that the person opening the CSV in
> excel
> doesn't have to convert anything.
>
> Thanks in advance
> Mark Johnson
> - Original Message -
> From: "David Murray" <[EMAIL PROTECTED]>
> To: 
> Sent: Tuesday, February 12, 2008 4:40 PM
> Subject: RE: [U2] Excel downloads
>
>
> > Laurie,
> >
> > For simple totals, it is possible to add an EXCEL formula into a cell
> by
> > starting the cell/formula with an '=' sign. This also works with CSV
> > structured files, which EXCEL will load and convert on the fly.
> >
> > Create a virtual/correlative field which will simply output the
> formula as
> > text and add it to the CSV file e.g. "=SUM(An)".
> >
> > Cheers,
> >
> > David Murray
> >
> >
> > .learn and do
> > .excel and share
> >
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure
> Hansen
> > Sent: Tuesday, February 12, 2008 12:10 PM
> > To: u2-users@listserver.u2ug.org
> > Subject: [U2] Excel downloads
> >
> > Hello,
> >
> > We are looking for a simple way to drop aggregate totals type reports
> > out of Universe into Excel. Our users are using AccuTerm and we also
> > have MITS Reports installed. But, neither one does the trick for
> > summarized reports that use the DET-SUP option. Having the detail and
> > forcing the users to do their own grouping/sub-totals in Excel is
> simply
> > not an acceptable option here.
> >
> > UV 10.2.3 on Win2003 server; AccuTerm 2K2 re. 5.1. We also would be
> > happy to develop a "simple" (key word...) VB.Net executable that works
> > smoothly regardless of the version of Excel, as our users work on
> > anything from Office 2000 and above.
> >
> > Any suggestions welcome.
> >
> > TIA,
> > Laure Hansen,
> > City of Redwood City
> > Information Technology
> > 1017 Middlefield Road
> > Redwood City, CA 94063
> > Tel 650-780-7087
> > Cell 650-207-3235
> > Fax 650-556-9204
> > [EMAIL PROTECTED] 
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Excel downloads

[MAJ Programming]

I'll try this method. I do beaucoups of downloads.
Thanks
- Original Message -
From: "Symeon Breen" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, February 13, 2008 10:42 AM
Subject: RE: [U2] Excel downloads


> Instead of "07748","012345","000123"   have ="07748",="012345",="000123"
??
>
> -Original Message-
> From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming
> Sent: 13 February 2008 14:05
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Excel downloads
>
> On this topic, I have a request for a solution.
>
> In New Jersey, all the zip codes start with '0'. Add product codes like
> 012345 and order numbers like 000123 etc and you'll see the leading zeros.
>
> When creating and exporting a CSV to eventually be used by Excel, those
> columns lose their leading zeros as Excel thinks they are numeric.
>
> I know that the users can  and choose Custom etc.
>
> I've converted the same CSV into a HTML boxed record and the zeros remain
as
> expected.
>
> I've tried prepending the values with an astrophe (single quote) to no
> avail.
>
> The true data (as viewed in Notepad) is exactly as I sent it:
> "07748","012345","000123"
>
> So, any tricks in having Excel leave the zeros alone when clicking on the
> CSV in WIndows Explorer. Meaning, that the person opening the CSV in excel
> doesn't have to convert anything.
>
> Thanks in advance
> Mark Johnson
> - Original Message -
> From: "David Murray" <[EMAIL PROTECTED]>
> To: 
> Sent: Tuesday, February 12, 2008 4:40 PM
> Subject: RE: [U2] Excel downloads
>
>
> > Laurie,
> >
> > For simple totals, it is possible to add an EXCEL formula into a cell by
> > starting the cell/formula with an '=' sign. This also works with CSV
> > structured files, which EXCEL will load and convert on the fly.
> >
> > Create a virtual/correlative field which will simply output the formula
as
> > text and add it to the CSV file e.g. "=SUM(An)".
> >
> > Cheers,
> >
> > David Murray
> >
> >
> > .learn and do
> > .excel and share
> >
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen
> > Sent: Tuesday, February 12, 2008 12:10 PM
> > To: u2-users@listserver.u2ug.org
> > Subject: [U2] Excel downloads
> >
> > Hello,
> >
> > We are looking for a simple way to drop aggregate totals type reports
> > out of Universe into Excel. Our users are using AccuTerm and we also
> > have MITS Reports installed. But, neither one does the trick for
> > summarized reports that use the DET-SUP option. Having the detail and
> > forcing the users to do their own grouping/sub-totals in Excel is simply
> > not an acceptable option here.
> >
> > UV 10.2.3 on Win2003 server; AccuTerm 2K2 re. 5.1. We also would be
> > happy to develop a "simple" (key word...) VB.Net executable that works
> > smoothly regardless of the version of Excel, as our users work on
> > anything from Office 2000 and above.
> >
> > Any suggestions welcome.
> >
> > TIA,
> > Laure Hansen,
> > City of Redwood City
> > Information Technology
> > 1017 Middlefield Road
> > Redwood City, CA 94063
> > Tel 650-780-7087
> > Cell 650-207-3235
> > Fax 650-556-9204
> > [EMAIL PROTECTED] 
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UB] Beep Error

[Womack, Adrian]

If you use @SYS.BELL instead of CHAR(7), the bell can be turned on or
off using BELL ON or BELL OFF. 

BELL ON/OFF - toggles the value of @SYS.BELL between CHAR(7) and "".

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: Friday, 15 February 2008 12:32 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] [UB] Beep Error

How do I send a rudimentay ascii audio error beep message when an
end-user makes a keyboard error?

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


DISCLAIMER:
Disclaimer.  This e-mail is private and confidential. If you are not the 
intended recipient, please advise us by return e-mail immediately, and delete 
the e-mail and any attachments without using or disclosing the contents in any 
way. The views expressed in this e-mail are those of the author, and do not 
represent those of this company unless this is clearly indicated. You should 
scan this e-mail and any attachments for viruses. This company accepts no 
liability for any direct or indirect damage or loss resulting from the use of 
any attachments to this e-mail.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UB] Beep Error [not-secure]

[Tim Stokes]

Just a side note. 

If there is a problem with the speaker or the user has an hearing
problem the bell with not be heard. 

Users may also grow 'upset' with hearing a bell. 

I tend to lean towards visual clues (error messages). 



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Hennessey, Mark
F.
Sent: Thursday, February 14, 2008 1:24 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UB] Beep Error [not-secure]

Control-g...   ^007? 


Mark Hennessey

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: Thursday, February 14, 2008 10:32 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] [UB] Beep Error

How do I send a rudimentay ascii audio error beep message when an
end-user makes a keyboard error?

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

RE: [U2][UV] Type 18 File Hashing Algorithm

[Perry Taylor]

Thanks Rick!  MOD(XXX, 2**31) did the trick! 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard
Nuckolls
Sent: Wednesday, February 13, 2008 2:45 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2][UV] Type 18 File Hashing Algorithm

Try taking the mod of the calculation against 2**31 or 2**32.  I have  
not tested this, but most of the other algorithms just toss any  
overflow of a 32 bit accumulator.

Rick Nuckolls
Lynden Inc.

ie:
EQU TWO32 TO 4294967296
...

GROUP = MOD(GROUP*10 + SEQ(ID[NC, 1]), TWO32)


On Feb 13, 2008, at 5:59 AM, Perry Taylor wrote:

> FOR NC = 1 TO LEN.ID
>
>   GROUP = GROUP * 10 + SEQ(ID[NC, 1])
>
> NEXT NC
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for 
the sole use of the intended recipient(s) and may contain confidential and 
privileged information.  Any unauthorized review, use, disclosure or 
distribution is prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health Information, 
any communications containing such material will be returned to the originating 
party with such advisement noted. If you are not the intended recipient, please 
contact the sender by reply e-mail and destroy all copies of the original 
message.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2][UV] Type 18 File Hashing Algorithm

[Perry Taylor]

I had considered that and in fact that is exactly how I am testing the
accuracy of my hash-calculating logic.  I just didn't want the overhead
of the UniVerse RECORD command which, in addition to reporting the group
number, does a lookup of the record and reports whether or not it is on
file. 

Thanks.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard
Sammartino
Sent: Wednesday, February 13, 2008 3:02 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2][UV] Type 18 File Hashing Algorithm

Perry, in Unidata there is the RECORD command which will return the
group
number to which a record will hash. Unidata does not support type 18
files
so I don't know what you will have access to in Universe. If the command
exists, you could create and empty file with the appropriate modulo and
then
execute the RECORD command against this file with whatever aid you
choose to
use. I can't speak for the overhead in executing this command
repeatedly.

Rich Sammartino
 
Richard Sammartino
Systems Analyst
School District of Philadelphia
440 N Broad Street
Philadelphia,  Pa 19130
Phone: (215) 400-5086
Fax:   (215) 400-4411 


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor
Sent: Wednesday, February 13, 2008 9:00 AM
To: u2-users@listserver.u2ug.org
Subject: [U2][UV] Type 18 File Hashing Algorithm

I need to come up with an equivalent in BASIC to UniVerse's type 18 file
hashing algorithm.  I understand that IBM treats this as proprietary but
I was hoping someone could shed some light on how I might pull this off
in BASIC.  The following code works fine until the length of the ID
exceeds eight characters 


GROUP = 0
LEN.ID = LEN(ID)

FOR NC = 1 TO LEN.ID

GROUP = GROUP * 10 + SEQ(ID[NC, 1])

NEXT NC

IF GROUP THEN GROUP = MOD(GROUP, FILE.MODULUS) + 1


Thanks.

Perry Taylor
Zirmed, Inc.

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
is
for
the sole use of the intended recipient(s) and may contain confidential
and
privileged information.  Any unauthorized review, use, disclosure or
distribution is prohibited. ZirMed, Inc. has strict policies regarding
the
content of e-mail communications, specifically Protected Health
Information,
any communications containing such material will be returned to the
originating party with such advisement noted. If you are not the
intended
recipient, please contact the sender by reply e-mail and destroy all
copies
of
the original message.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UB] Beep Error [not-secure]

[Hennessey, Mark F.]

Control-g...   ^007? 


Mark Hennessey

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: Thursday, February 14, 2008 10:32 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] [UB] Beep Error

How do I send a rudimentay ascii audio error beep message when an
end-user makes a keyboard error?

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

RE: [U2] [UB] Beep Error via @(-19)

[Brutzman, Bill]

@(-19) just moves the cursor on my Dynamic Connect screen


  equate beep to char(7)
  
  crt @(-1)

  crt beep
   Base.Time = time()
  loop
Time.Now = time()  ;Delta = Time.Now - Base.Time
  until Delta > 0.2 do repeat   
  
  crt beep
  
  sleep
  SLEEP
  
*---
---
  
  print @(-19)
   Base.Time = time()
  loop
Time.Now = time()  ;Delta = Time.Now - Base.Time
  until Delta > 0.2 do repeat   
  
  print @(-19)
  
  sleep
  
*---
---
The.End:

  crt @(-1)
  
  END
  

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of David A. Green
Sent: Thursday, February 14, 2008 11:51 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UB] Beep Error


I would use @(-19)

Thanks,
David A. Green
www.dagconsulting.com
(480) 813-1725
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UB] Beep Error

[David A. Green]

I would use @(-19)

Thanks,
David A. Green
www.dagconsulting.com
(480) 813-1725
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] RE: [UB] Beep Error

[Brutzman, Bill]

Thanks to those who responded.  Let's call it a victory...

--Bill

_

 SUBROUTINE BEEP.BEEP.AND.SLEEP.R0

  equate beep to char(7)
  
  crt @(-1)

  crt beep
 Base.Time = time()
  loop
Time.Now = time()  ;Delta = Time.Now - Base.Time
  until Delta > 0.2 do repeat   
  
  crt beep
  
  sleep
  
*---
---
The.End:

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

Re: [U2] [UB] Beep Error

[Ken Hall]

Bill -
Just CRT or PRINT CHAR(7): to get a bell (beep) if the users terminal 
emulator supports it.


Ken

At 07:32 AM 2/14/2008, you wrote:

How do I send a rudimentay ascii audio error beep message when an end-user
makes a keyboard error?

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

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

[U2] Piping to a unix command with echo

[Marco Manyevere]

Im trying to process the contents of a string generated in Universe with an
external program by shelling out to the OS as follows:

CHANGE '\' TO '\\' IN
STR1
CHANGE '"' TO '\"' IN STR1
SH.CMD = 'SH -c echo ':QUOTE(STR1):' |
./myscript'
EXECUTE SH.CMD CAPTURING RESULT

STR1 can contain any characters
so to avoid interpratation by the shell I put the two CHANGE statements but it
seems some situations are still not covered, for example when STR1 contains
\008, the output is wrong. Does anyone know how I can make this foolproof or
an alternate method? I am able to get consistent results by writing STR1 to a
temp file then running my script with input and output redirection but I want
to cut down on unnecessary disk IO.

Another question: While STR1 is
guaranteed not to exceed 4k, does anyone know the maximum size of the command
I can run in this way? Im on AIX.

Marco.
__
Sent from Yahoo!
Mail - a smarter inbox http://uk.mail.yahoo.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UB] Beep Error

[Charles_Shaffer]

In UNIBASIC you can do this.

EQU BELL  TO CHAR (7) 
.
.
.
DISPLAY BELL

Charles Shaffer
Senior Analyst
NTN-Bower Corporation




"Brutzman, Bill" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/14/2008 09:32 AM
Please respond to u2-users

 
To: "'u2-users@listserver.u2ug.org'" 
cc: 
Subject:[U2] [UB] Beep Error


How do I send a rudimentay ascii audio error beep message when an end-user
makes a keyboard error?

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

This email was Anti Virus checked by Astaro Security Gateway. 
http://www.astaro.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UB] Beep Error

[IT-Laure Hansen]

CRT CHAR(7) 


Laure Hansen,
City of Redwood City
Information Technology
1017 Middlefield Road
Redwood City, CA 94063
Tel 650-780-7087
Cell 650-207-3235
Fax 650-556-9204
[EMAIL PROTECTED]

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: Thursday, February 14, 2008 7:32 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] [UB] Beep Error

How do I send a rudimentay ascii audio error beep message when an
end-user makes a keyboard error?

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

RE: [U2] [UB] Beep Error

[Andrew Lakeland]

PRINT "ERROR":CHAR(7)

andy


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: 14 February 2008 16:32
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] [UB] Beep Error

How do I send a rudimentay ascii audio error beep message when an
end-user
makes a keyboard error?

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

Legal Disclaimer:
The information contained in this message may be privileged and confidential. 
It is intended to be read only by the individual or entity to whom it is 
addressed or by their designee. If the reader of this message is not the 
intended recipient, you are on notice that any distribution of this message, in 
any form, is strictly prohibited. If you have received this message in error, 
please immediately notify the sender and delete or destroy any copy of this 
message
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UB] Beep Error

[Mike Dallaire]

CRT CHAR(7)

Michael Dallaire
Senior Applications Developer
IBM Certified Solutions Expert
Mortgage Builder Software, Inc.
Phone: (248) 304-0600
Fax: (248) 304-0601
[EMAIL PROTECTED]
www.mortgagebuilder.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: Thursday, February 14, 2008 10:32 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] [UB] Beep Error

How do I send a rudimentay ascii audio error beep message when an end-user
makes a keyboard error?

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

RE: [U2] [UB] Beep Error

[Ron Hutchings]

>From a program, CRT @BELL or CRT CHAR(7)

Some terminal emulators recognized ctrl-g



> Date: Thu, 14 Feb 2008 10:32:27 -0500
> From: [EMAIL PROTECTED]
> Subject: [U2] [UB] Beep Error
> To: u2-users@listserver.u2ug.org
>
> How do I send a rudimentay ascii audio error beep message when an end-user
> makes a keyboard error?
>
> --Bill
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/

_
Shed those extra pounds with MSN and The Biggest Loser!
http://biggestloser.msn.com/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] CSV output

[Ron Hutchings]

Are you remembering back to the "good old days" of Pr1me and Information when
that was user maintainable?



> From: [EMAIL PROTECTED]
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] CSV output
> Date: Thu, 14 Feb 2008 17:20:23 +0200
>
> Hi
>
> Is there any way to change the > prompt to something like BR299>?
>
> It would really help to know where I am, whilst hopping from branch to
> branch.
>
> Thanks
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/

_
Need to know the score, the latest news, or you need your Hotmail.-get your
"fix".
http://www.msnmobilefix.com/Default.aspx
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UB] Beep Error

[Brutzman, Bill]

Answering my own question...

   crt char(7)



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill
Sent: Thursday, February 14, 2008 10:32 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] [UB] Beep Error


How do I send a rudimentay ascii audio error beep message when an end-user
makes a keyboard error?

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

RE: [U2] Change Prompt

[Caminiti, Marc]

I believe something on the lines of this was posted before.  Here is
what we use:

IF @ACCOUNT = "mc" OR @ACCOUNT = "da" THEN
   STELPROMPT= @WHO : '>'
END ELSE
   STELPROMPT = "Press G and hit ENTER to continue>"
END
ASSIGN 1 TO SYSTEM(4001)
ASSIGN STELPROMPT TO SYSTEM(4002) 

and then that program gets called during the login process

Marc Caminiti
IS Manager
Nashbar Direct, Inc
6103 State Route 446
Canfield, OH 44406
330.533.1989, ext 336
330.702.9733, fax

Birthdays are good for you - the more you have the longer you live.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett
Sent: Thursday, February 14, 2008 10:21 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Change Prompt

Oops sent the last on the wrong subject... sorry!

-Original Message-
From: Dennis Bartlett [mailto:[EMAIL PROTECTED]
Sent: 14 February 2008 05:20 PM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] CSV output

Hi

Is there any way to change the > prompt to something like BR299>?

It would really help to know where I am, whilst hopping from branch to
branch.

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

RE: [U2] [UB] Beep Error

[Anthony Youngman]

PRINT CHAR(7)

I think you can also do PRINT @BELL

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: 14 February 2008 15:32
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] [UB] Beep Error

How do I send a rudimentay ascii audio error beep message when an end-user
makes a keyboard error?

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

RE: [U2] CSV output

[roy]

You can assign the prompt name to SYSTEM(4002) using basic and run it in the
Login paragraph.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett
Sent: Thursday, February 14, 2008 10:20 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] CSV output

Hi

Is there any way to change the > prompt to something like BR299>?

It would really help to know where I am, whilst hopping from branch to
branch.

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

[U2] [UB] Beep Error

[Brutzman, Bill]

How do I send a rudimentay ascii audio error beep message when an end-user
makes a keyboard error?

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

[U2] Change Prompt

[Dennis Bartlett]

Oops sent the last on the wrong subject... sorry!

-Original Message-
From: Dennis Bartlett [mailto:[EMAIL PROTECTED] 
Sent: 14 February 2008 05:20 PM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] CSV output

Hi

Is there any way to change the > prompt to something like BR299>?

It would really help to know where I am, whilst hopping from branch to
branch.

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

RE: [U2] CSV output

[Dennis Bartlett]

Hi

Is there any way to change the > prompt to something like BR299>?

It would really help to know where I am, whilst hopping from branch to
branch.

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

RE: [U2] UniVerse 10.2 Error code: 2 2 on OpenSUSE

[Anthony Youngman]

It's the classic "UV is supported on Red Hat" problem. The install script 
doesn't understand the SuSE rc setup.

This all ought to be documented somewhere ... has somebody put a "how to 
install on SuSE" FAQ on the u2ug wiki? If not, could someone put one there (I 
did it so long ago, I've forgotten how :-)

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mats Carlid
Sent: 14 February 2008 13:50
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniVerse 10.2 Error code: 2 2 on OpenSUSE

Universe comes with a bootscript to be placed in the startup scripts folder
that is not executed  - sthg like  uv.rc.

HTH

-- mats



DeanNapper skrev:
> Hi.  I have installed UniVerse 10.2 onto OpenSUSE and all was well until I
> restarted the host, now UniVerse reports the following when starting:
>
>An error has occurred during uniVerse initialization
>Please contact the system administrator
>Error code:  2   2
>
> I can't seem to find any info about this error, please help!
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] SLEEP 60 slept only 53 seconds, or else TIMEDATE() is wrong

[Doug Chanco]

Hey all,
Where on IBM's massive web site can I find what was fixed on what
version of universe?

This thread got me wondering if some weird issues I have seen have
already been fixed on a new versions of universe (we are running on AIX
if that matters)

As well as what new features have been added to new versions of universe

Thanks!

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

Re: [U2] UniVerse 10.2 Error code: 2 2 on OpenSUSE

[Mats Carlid]

Universe comes with a bootscript to be placed in the startup scripts folder
that is not executed  - sthg like  uv.rc.

HTH

-- mats



DeanNapper skrev:

Hi.  I have installed UniVerse 10.2 onto OpenSUSE and all was well until I
restarted the host, now UniVerse reports the following when starting:

   An error has occurred during uniVerse initialization
   Please contact the system administrator 
   Error code:  2   2  


I can't seem to find any info about this error, please help!

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

[U2] UniVerse 10.2 Error code: 2 2 on OpenSUSE

[DeanNapper]

Hi.  I have installed UniVerse 10.2 onto OpenSUSE and all was well until I
restarted the host, now UniVerse reports the following when starting:

   An error has occurred during uniVerse initialization
   Please contact the system administrator 
   Error code:  2   2  

I can't seem to find any info about this error, please help!


-- 
View this message in context: 
http://www.nabble.com/UniVerse-10.2-Error-code%3A--2---2-on-OpenSUSE-tp15462596p15462596.html
Sent from the U2 - Users mailing list archive at Nabble.com.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/