RE: [U2] SOX question (United States only, I believe)

2005-12-09 Thread Peter Gonzalez
SOX SUCKS! (we have tee shirts with 'SOX SUCKS' on the front)

Our productivity has gone way down. If there is a problem here is what we have 
to do now. And there are plenty of internal and external auditors to make sure 
we do the following.

1. Create a request to modify.
2. Copy the records from LIVE to DEVEL.
3. Debug the process.
4. Mod the program and correct the data records.
5. Create a user approval form.
6. Have the user sign off.
7. Have the IT manager sign off.
8. Notify the manager of programmers of the change
9. The manager of programmers notifies the system admin.
10. The system admin then moves the programs and (or) the corrected data 
records.
11. The system admin then notifies the IT staff of the move.
12. The programmer then notifies the user.

Documentations includes screen shoots of all changes, programs, DICT, screens 
and records.  The average doc package is about 8 pages.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven M Wagner
Sent: Friday, December 09, 2005 8:27 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SOX question (United States only, I believe)

Marc

How do the programmers to customer support if they cannot look at the data 
in the production data-base?  It would be hard to research problems if you 
cannot look at live data.

Steve

At 08:49 AM 12/9/05 -0300, you wrote:
Good Morning Charlie,
No only a US issue, but also an issue for multinationals with US home 
offices. We are in Argentina and have clients that must comply and frankly 
we DO separate the DBA role from the programmer role and I am in favor of 
this although it is an administrative pain at times. Programmers on these 
sites do not get access to the production data-base and only get read-only 
to the user testing environment.
Regards,
Marc Hilbert
Pick Professional Center
Buenos Aires,
Argentina.

- Original Message - From: Charlie Rubeor 
[EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Thursday, December 08, 2005 6:28 PM
Subject: [U2] SOX question (United States only, I believe)


When we started implementing Sarbanes-Oxley, I knew the question of why we
don't separate the Database Admin role from the Programmer role would come
up.  Has anyone on this list been able to provide a satisfactory answer to
the auditors, without spending a lot of time explaining the benefits of an
MV database?

Charlie Rubeor
Unix/Database Administrator
Wiremold/Legrand
60 Woodlawn Street
West Hartford, CT 06110
Tel: 860.233.6251 x3498
Fax: 860.523.3690
Email: [EMAIL PROTECTED]
Internet: www.wiremold.com

[demime 1.01d removed an attachment of type image/jpeg]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

--
Steven M Wagner
[EMAIL PROTECTED]
Cary, North Carolina, United States of America
---
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] SOX question (United States only, I believe)

2005-12-09 Thread Peter Gonzalez
Les,
I didn't include the MMDIFF program that we run. It too, prints the difference, 
if any, on LIVE and DEVEL.

Our understanding of SOX is not to have one or two people involved in software 
administration and conspiring to hard the system. The more people that are 
involved, the less chances of company fraud. 
 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Les Hewkin
Sent: Friday, December 09, 2005 10:34 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] SOX question (United States only, I believe)

Is that all there is to it

We have to do all that now...

We also produce diff items of the programs. This details all the changes
made.

But I do have access to the live machine as well.  


Les

-Original Message-
From: Peter Gonzalez [mailto:[EMAIL PROTECTED] 
Sent: 09 December 2005 14:13
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] SOX question (United States only, I believe)

SOX SUCKS! (we have tee shirts with 'SOX SUCKS' on the front)

Our productivity has gone way down. If there is a problem here is what
we have to do now. And there are plenty of internal and external
auditors to make sure we do the following.

1. Create a request to modify.
2. Copy the records from LIVE to DEVEL.
3. Debug the process.
4. Mod the program and correct the data records.
5. Create a user approval form.
6. Have the user sign off.
7. Have the IT manager sign off.
8. Notify the manager of programmers of the change
9. The manager of programmers notifies the system admin.
10. The system admin then moves the programs and (or) the corrected data
records.
11. The system admin then notifies the IT staff of the move.
12. The programmer then notifies the user.

Documentations includes screen shoots of all changes, programs, DICT,
screens and records.  The average doc package is about 8 pages.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Steven M Wagner
Sent: Friday, December 09, 2005 8:27 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SOX question (United States only, I believe)

Marc

How do the programmers to customer support if they cannot look at the
data 
in the production data-base?  It would be hard to research problems if
you 
cannot look at live data.

Steve

At 08:49 AM 12/9/05 -0300, you wrote:
Good Morning Charlie,
No only a US issue, but also an issue for multinationals with US home 
offices. We are in Argentina and have clients that must comply and
frankly 
we DO separate the DBA role from the programmer role and I am in favor
of 
this although it is an administrative pain at times. Programmers on
these 
sites do not get access to the production data-base and only get
read-only 
to the user testing environment.
Regards,
Marc Hilbert
Pick Professional Center
Buenos Aires,
Argentina.

- Original Message - From: Charlie Rubeor 
[EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Thursday, December 08, 2005 6:28 PM
Subject: [U2] SOX question (United States only, I believe)


When we started implementing Sarbanes-Oxley, I knew the question of
why we
don't separate the Database Admin role from the Programmer role would
come
up.  Has anyone on this list been able to provide a satisfactory
answer to
the auditors, without spending a lot of time explaining the benefits
of an
MV database?

Charlie Rubeor
Unix/Database Administrator
Wiremold/Legrand
60 Woodlawn Street
West Hartford, CT 06110
Tel: 860.233.6251 x3498
Fax: 860.523.3690
Email: [EMAIL PROTECTED]
Internet: www.wiremold.com

[demime 1.01d removed an attachment of type image/jpeg]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

--
Steven M Wagner
[EMAIL PROTECTED]
Cary, North Carolina, United States of America
---
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/

This message has been comprehensively scanned for viruses,
please visit http://virus.e2e-filter.com/ for details.


This e-mail and any attachments are confidential and intended solely for the 
use of the addressee only. If you have received this message in error, you must 
not copy, distribute or disclose the contents; please notify the sender 
immediately and delete the message.
This message is attributed to the sender and may not necessarily reflect the 
view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements 
binding Travis Perkins may not be concluded by means of e-mail communication.
E-mail transmissions are not secure and Travis Perkins accepts no 
responsibility for changes made to this message after it was sent. Whilst steps 
have been taken to ensure that this message is virus free

RE: [U2] Deciphering Pick UniBasic statement

2005-12-08 Thread Peter Gonzalez
Several years go I wrote a utility to clean source code for Unidata, for this 
very same reason. The utility added END statements when need. It also accounted 
for all Unidata functions, Verbs. An added feature that I was not able to 
complete, due to time, was a flowchart. A second program would take the cleaned 
source and build a Visio flowchart. Maybe I'll finish it one of these days.

Pete

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Caleb Ng
Sent: Thursday, December 08, 2005 2:11 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Deciphering Pick UniBasic statement

I'm trying to decipher and break the following IF/THEN/ELSE statement
into multiple lines because I need to add some logic into it.   Being a
PICK newbie, I'm having difficulty understanding it.  I believe this
code was ported from an old MD Pick system but I want to make sure it
behaves in a similar fashion once I break it apart.  I'm sure this will
be no problem to gurus like yourselves.

IF P(2)-AR(12)=28 THEN CC=CC+1; INS 0 BEFORE AR(14)1,1; DEL
AR(14)1,9; ELSE IF AR(13)=DATE() THEN CC=CC ELSE INS 1 BEFORE
AR(14)1,1; DEL AR(14)1,9

Thanks in advance,


Caleb Ng
Systems Analyst
Sweetwater Authority
[EMAIL PROTECTED]
(619) 409-6763
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
R
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2][UV] UPS rate calculator

2005-10-27 Thread Peter Gonzalez
I actually wrote the entire UPS host manifest system in Unidata. It is 
integrated with our custom programs. We get a UPS label, Summary label, 
tracking details, summary reports and a file to send to UPS for billing. 
The only feature that we don't use is international service codes.  We 
create over 1,000 labels a day. It has been working for over 4 years. Let 
me know if you need any assistance.


At 07:38 AM 10/27/2005 -0700, you wrote:

JH Has anyone directly integrated UPS's online shipping rate calculator
JH service and/or address verification with UV?

Not the rate calculator but the USPS 'shipping label' process.  It was
pretty simple once we got on line and talked through our understanding
of their documentation G.


--
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___
---
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] connection from UniBasic to a SQL database

2005-10-14 Thread Peter Gonzalez
Hello Bob.   I would like to see a sample of how you do that.   You don't 
have to give away your source, but giving us an ideal of how it works.


thanks.





-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney
Sent: Thursday, October 13, 2005 11:13 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] connection from UniBasic to a SQL database [was What
are you using to develop your web pages...] {Unclassified}

Wendy:

We talk to ms sql all the time thru OpenLink ODBC drivers using the BCI

It works fine and the only problems we had was with the ODBC driver

Have routines that do it if you'd like to look

Bob

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of gerry-u2ug
Sent: 14 October 2005 01:48
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] connection from UniBasic to a SQL database [was What
are you using to develop your web pages...] {Unclassified}


things are not this simle on unix - 3rd party odbc drivers need to be
purchased , installed  configured.
I have never worked with a client who has gone this route, it never
seems to be worth the bother  expense.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of HENDERSON MIKE,
MR
Sent: Thursday, October 13, 2005 06:11 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] connection from UniBasic to a SQL database [was What
are you using to develop your web pages...] {Unclassified}


Wendy

 -Original Message-
 From: [EMAIL PROTECTED] On Behalf Of Wendy Smoak
 Sent: Friday, 14 October 2005 09:10
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] [AD] What are you using to develop your web pages?
 JavaScript? PHP? .Net?

 From: Symeon Breen [EMAIL PROTECTED]

  it is easy to read/write mysql from your Unibasic.

 Really?  So far we have not been successful getting a connection from
 UniBasic to a SQL database.  What are you using?  (My guess is that
 you're on Windows.)

I've written stuff to read from a SQL database into UniBasic using the
BCI.
There's no conceptual difference between reading  writing, it's just a
matter of using a SQL INSERT or MODIFY instead of a SELECT in the string
passed to SQL.  I do have some doubts about how to set up transactions
to allow simultaneous SQL  UV updates, but that's functionality we
don't need yet.

The BCI documentation is sparse and the example code execrable, but it
does work and performance is not too bad, either.

UV 10.0.15 to MS SQL Server 2000, all on Windows, using the MS SQL
Server driver.

Mike


 We're on HP-UX.  At the moment I'm reading from Sybase with their JDBC

 driver then using UniObjects for Java to write records into UniData.
 It's working fine, but it would be
 *really* nice to connect directly to Sybase from a UniBasic program.

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

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

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
__

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
__
---
u2-users mailing list
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] squelching the ClearScreen before a LIST output

2005-09-22 Thread Peter Gonzalez
George, If you CAPTURE the output to a variable you can modify the LIST 
results.   I can even have a routine to move 'F'oward or 'B'ack and display 
your LIST results.



At 09:35 AM 9/22/2005 -0400, you wrote:

OK. this is for UV10

Is there a keyword/option to NOT do a clear screen on the LIST command.
This would be from a Paragraph, so I can't do an execute and just remove
  it from captured data.

What we want to do is show information, then LIST file (which only has one
  or two items), then show more information below it.

Right now, every time we do the LIST, it clears the screen and gets rid of
the top information.

George
---
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: [Maybe spam] RE: [U2] Remove Scenario

2005-08-12 Thread Peter Gonzalez

Tony,
Thank you for clearing up the issue of using EQUATES. I was ready to pile 
on you along with Les Hewkin. We use EQUATES and live by what they 
describe.  I have learned never to trust DICTS.


I always value your responses, since you where the head guy at Pick Systems 
RD. Keep writing to this list. thanks.


At 02:34 AM 8/12/2005 -0700, you wrote:

I wasn't clear about that at all, sorry.  What I meant was that experienced
developers don't put a table of 50,000 invoice numbers into a single
attribute in the customer master file, or even reserve one atb for open
invoices and another one for closed, especially when either one of those
atb's can expend beyond a couple thousand values.

Equating a name to a dimensioned array element is absolutely standard and
IMO preferred practice - sorry if that was confused.

Tony

Les Hewkin wrote:
 Rubbish,sorry Tony but that's what I think. You say
 experienced developers and big companies don't use EQU
 INVNO.TABLE TO CUST(40). I beg to differ. What do you
 call experienced? does 20 years count??? and what do you
 call a big company??? we only have two boxes running
 universe, two HP boxes, one with 32 processors and four
 logical machines, with over 5k users. We define all our
 files this way. Our user base is growing all the time as
 the company grows and our apps just keep on working.

 Les.

 -Original Message-
 From: Tony Gravagno
 That construct that you
 describe EQU INVNO.TABLE TO CUST(40) is something that
 experienced developers simply don't use anymore...
---
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] True random select lists?

2005-08-09 Thread Peter Gonzalez

Wow,  imagine using my ipod with a MV database. 


At 11:27 AM 8/9/2005 -0700, you wrote:

Wow, and here I just program dull business programs, day after day, year
after year, decade after decade.

Have Fun

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Dave Walker
Sent: Tuesday, August 09, 2005 10:51
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] True random select lists?


I use xmms for playing the music, but until now have used a mysql database
to generate the playlists.

What I'm actually trying to do is learn how to talk to OpenQM with qmclilib.
I've managed to create a python wrapper for the library, and have now built
the database using the same program I wrote to learn how to program python.
I've just stripped out the mysql bits and put in the OpenQM equivalent. (The
database structure has also changed, of course, to take advantage of
multivalues!)

I'll eventually put a pretty face on the frontend with PyQT, and possibly
give it multiple personalities with apache2 and mod_python.

But I have to learn to walk before I can run, and an mp3 application is the
easiest way I have to generate a fair sized database. I can populate it from
the mp3 tags themselves, and do so many fun things with it after it's built!

Thanks for the comments,
--
Dave Walker
8..7 4(())  -::-
  -::-8.74 .74(())
 ((88.74  ..74  -::-
((88.74   * Peace



 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of Allen
 E. Elwood
 Sent: Tuesday, August 09, 2005 12:11 PM
 To: u2-users@listserver.u2ug.org
 Subject: RE: [U2] True random select lists?


 The I-desc is a nice idea, however you're going to get
 multiple hits on the
 same song, and don't we all hate that when we hear the same song?

 The basic idea is very similar to something that I did with
 the thought of
 the day.  I used to select the entire file put it into an
 array, and then
 base the random number based off of the time of the day with
 a modulo of a
 prime number close to the total number of records selected
 and use that to
 prime RND.  Or maybe visa versa.  It was a LONG time ago in a
 universe very
 very far away ;)

 This was similar to hashing in pick, and where I got the
 idea.  Using the
 time, gave as close to a really random number as possible.
 Since I was only
 selecting one record a day, I would post a 1 to that record
 so it would not
 be selected the next time.  When my select didn't return any
 records I would
 just clear all the 1's in the file and start over.  Worked great!

 But but but, why not just get the free winamp www.winamp.com
 and just click
 on random???

 Allen

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of Dave Walker
 Sent: Tuesday, August 09, 2005 08:22
 To: 'u2-users@listserver.u2ug.org'
 Subject: RE: [U2] True random select lists?


 Yes, I would like a DIFFERENT 100 every time, otherwise the
 FIRST would have
 worked. The first thing I thought of was your basic routine,
 but I just
 wondered if I'd overlooked a SELECT option that I wasn't
 familiar with.

 I'm wondering which would be more efficient; the basic subroutine or
 Christophe's suggestion of an I descriptor?

 Thanks,
 --
 Dave Walker
 8..7 4(())  -::-
   -::-8.74 .74(())
  ((88.74  ..74  -::-
 ((88.74   * Peace



  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED] Behalf Of
  Martin Phillips
  Sent: Tuesday, August 09, 2005 10:46 AM
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] True random select lists?
 
 
  Hi Dave,
 
   I've built a database of all my mp3s. Now I want to
  generate a random list
   of 100 songs. s there a way to do that with a SELECT
  statement, or must I
   muck around in basic to do so.
 
  This depends what you mean by random. If you are happy to
  agree that the
  hashing process is effectively random from an external point
  of view, simply
  use
 SELECT filename FIRST 100
 
  However, you seem to want a different 100 records each time.
  I cannot see
  any way to do this aside from using a Basic program. Even
  then, you will
  have to start with a list of all the records and then extract
  100 items
  randomly...
 
  OPEN 'filename' TO FVAR ELSE STOP
  SELECT FVAR
  READLIST LIST THEN
 N = DCOUNT(LIST, @FM)
 FOR I = 1 TO 100
X = RND(N) + 1
ID = LISTX
DEL LISTX
N -= 1
 NEXT I
  END
 
  The above idea assumes that the list has over 100 items in it
 
  The basic problem here is that computers are supposed to be
  repeatable. What
  you want is random behaviour so you are unlikely to find it
  in the standard
  toolset.
 
 
  Martin Phillips
  Ladybridge Systems
  17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
  +44-(0)1604-709200
  ---
  u2-users mailing list
  u2-users@listserver.u2ug.org
  To 

RE: [U2] Printing from UniVerse

2005-06-07 Thread Peter Gonzalez
Bob,
In all the places that I have worked without standards, I have applied the 
standard you refer to with variables names.  It's great. Additional, I 
don't rust DICTs I look at the EQU item for a true description of what the 
field is and what it does.

016: *   ITEM ID = CONO '!' REJECT#
017:
018: DIM MAT.REJ.REC(40)
019:
020: EQU MR.ENTER.DT$  TO MAT.REJ.REC(1) ;* S Entered Date
021: EQU MR.INSPECTOR$ TO MAT.REJ.REC(2) ;* S Inspector#
022: EQU MR.PONO$  TO MAT.REJ.REC(3) ;* S Purchase Order#
023: EQU MR.VENDNO$TO MAT.REJ.REC(4) ;* S Vendor#


At 01:18 PM 6/7/2005 -0700, you wrote:
One of the programming standards I've seen names all equates with a
trailing $.  System subroutines start with a $ and I thought this was a
pretty slick way of knowing instantly that it's an equate, not a
variable, while browsing the source code.

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


[U2] Help with BREAK-ON TOTAL

2005-05-26 Thread Peter Gonzalez

Hello,

I need a little help on a statement. I'm working with multiple currencies 
dollar amounts in the same file. I'm trying to do the following.


SORT BY FCURR.CD BREAK-ON FCURR.CD TOTAL INV.AMT

The problem, as you can imagine is that after all currencies are added and 
displayed, an additional row displays with ALL currencies added. This last 
row has no meaning at all, since they are the sum of all currencies.  Is 
there a way to not print that last row?


system is Unidata 6.0 on Unix.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Help with BREAK-ON TOTAL

2005-05-26 Thread Peter Gonzalez

Ed,
I have been converting these PROCS to programs, but it's very time 
consuming.  Plus there are other TOTAL columns that I need to see the grand 
total.   I guess, I'm looking for a magic option in the TOTAL clause.


Thanks.

At 03:43 PM 5/26/2005 -0400, you wrote:

you could use the GRAND-TOTAL clause (in ECL-TYPE P only, according to the
manual) to force that final total line onto a seperate page, i.e.
SORT BY FCURR.CD BREAK-ON FCURR.CD TOTAL INV.AMT GRAND-TOTAL 'P'
and then throw the offending page away. sorry I can't think of any better
alternative besides doing it in a basic program.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Peter Gonzalez
Sent: Thursday, May 26, 2005 1:38 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Help with BREAK-ON  TOTAL


Hello,

I need a little help on a statement. I'm working with multiple currencies
dollar amounts in the same file. I'm trying to do the following.

SORT BY FCURR.CD BREAK-ON FCURR.CD TOTAL INV.AMT

The problem, as you can imagine is that after all currencies are added and
displayed, an additional row displays with ALL currencies added. This last
row has no meaning at all, since they are the sum of all currencies.  Is
there a way to not print that last row?

system is Unidata 6.0 on Unix.
---
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] INCLUDE or $INCLUDE

2004-12-17 Thread Peter Gonzalez
Good day!

We created a duplicate account of our live system.   The new account has 
our programs and data files. We have a problem with the way programs are 
executed.

Programs with $INCLUDE work fine. Programs with INCLUDE bomb out!We are 
clueless as to what's going on.

My understanding for the last 20 years was that there is no 
difference.   Did I missed something in those 20 years?

Unidata 6.0 on RH Enterprise Linux Rel 3.

08:42 AM 12/17/2004 -0700, you wrote:
  From: [EMAIL PROTECTED]
  I'm not sure how different they are - they hadn't been
  changed in a while.
  The windows version is a simple setup.exe install.

Here are some hints for installing on Linux:
http://www.pickwiki.com/cgi-bin/wiki.pl?Redhat8UD6PEInstallInfo

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



Peter Gonzalez
Senior Programmer Analyst
M  M Aerospace Hardware, Inc., a B/E Aerospace Company
1 NW 15 Terrace
Miami, Florida 33172
Phone: 305.925.2714
Fax: 305.925.2610
www.mmaero.com
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Unidata and international settings

2004-10-18 Thread Peter Gonzalez
At 09:49 AM 10/11/2004 -0400, you wrote:
Good day,

I have a few questions on Unidata and international settings. Any
suggestions will be highly appreciated.

1. What languages does Unidata comes in?

2. Could you have different intl. Unidata accounts on the same machine?

3. Could a US version be setup to handle international users? in other
words a mix of US and international users on the same account.

4. Could you have diff date formats in the same Unidata accounts?

5. Suggestions on handling Dictionary headings. (I'm thinking of the LIST
PROD USING DICT PROD.ITALIAN)

6. International Keyboards.

7. Displaying hyphens and intl. characters on the screen. (this would be on
PuTty)




Peter Gonzalez
Senior Programmer Analyst
M  M Aerospace Hardware, Inc., a B/E Aerospace Company
1 NW 15 Terrace
Miami, Florida 33172
Phone: 305.925.2714
Fax: 305.925.2610
www.mmaero.com
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/



Peter Gonzalez
Senior Programmer Analyst
M  M Aerospace Hardware, Inc., a B/E Aerospace Company
1 NW 15 Terrace
Miami, Florida 33172
Phone: 305.925.2714
Fax: 305.925.2610
www.mmaero.com
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Unidata and international settings

2004-10-11 Thread Peter Gonzalez
Good day,

I have a few questions on Unidata and international settings. Any 
suggestions will be highly appreciated.

1. What languages does Unidata comes in?

2. Could you have different intl. Unidata accounts on the same machine?

3. Could a US version be setup to handle international users? in other 
words a mix of US and international users on the same account.

4. Could you have diff date formats in the same Unidata accounts?

5. Suggestions on handling Dictionary headings. (I'm thinking of the LIST 
PROD USING DICT PROD.ITALIAN)

6. International Keyboards.

7. Displaying hyphens and intl. characters on the screen. (this would be on 
PuTty)




Peter Gonzalez
Senior Programmer Analyst
M  M Aerospace Hardware, Inc., a B/E Aerospace Company
1 NW 15 Terrace
Miami, Florida 33172
Phone: 305.925.2714
Fax: 305.925.2610
www.mmaero.com
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] hello ?

2004-09-23 Thread Peter Gonzalez
a FLOYD fan! Now i know I'm in the right place.

At 06:06 AM 9/23/2004 -0600, you wrote:
Careful with that axe, Eugene!

  -Original Message-
  From: [EMAIL PROTECTED] [mailto:owner-u2-
  [EMAIL PROTECTED] On Behalf Of Stuart Boydell
  Sent: Wednesday, September 22, 2004 9:11 PM
  To: [EMAIL PROTECTED]
  Subject: RE: [U2] hello ?
 
   Yes us pagans are dancing in the moonlight and had to address the
   4 element
   forces at noon... ;-) call to the East, South, North  West..
 
  Ah, NOW I understand how this thread is related to MV... you were gathered
  in a cave and grooving with a Pict.*
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/



Peter Gonzalez
Senior Programmer Analyst
M  M Aerospace Hardware, Inc., a B/E Aerospace Company
1 NW 15 Terrace
Miami, Florida 33172
Phone: 305.925.2714
Fax: 305.925.2610
www.mmaero.com
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] UniObjects for .NET

2004-07-16 Thread Peter Gonzalez
UniObjects for .NET it's finally here!   It's also free!  Hopefully there 
will be some documentation.


UniData v6.1 to Become Available on 7/30/04

   This feature rich release of UniData includes the following
   enhancements:
   -  XML Enhancements, including the generation of XML Schema for
   XML output, support for an XML DOM API in Basic, XML/DB tool to
   move data from XML to/from UniData files, and a GUI XML/DB Mapping
   tool
   -  SOAP Client API
   -  Secure Socket Layer (SSL) for JDBC
   -  Table Relationship Mapping for ODBC Tools
   -  UniObjects for .NET

   The initial platforms on which this release will be available are
   AIX, HPUX (RISC), Solaris, Windows and Red Hat Linux.  Stay tuned
   for more details on the 7/30/04 release on the U2 website!



Peter Gonzalez
Senior Programmer Analyst
M  M Aerospace Hardware, Inc., a B/E Aerospace Company
1 NW 15 Terrace
Miami, Florida 33172
Phone: 305.925.2714
Fax: 305.925.2610
www.mmaero.com
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniObjects for .NET

2004-07-16 Thread Peter Gonzalez
DOn't know.  There is no additional info.


At 03:32 PM 7/16/2004 +0100, you wrote:
Yahoo,
Does it have a .net data provider for using ADO .net ?

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Peter Gonzalez
Sent: 16 July 2004 14:13
To: [EMAIL PROTECTED]
Subject: [U2] UniObjects for .NET

UniObjects for .NET it's finally here!   It's also free!  Hopefully
there
will be some documentation.


UniData v6.1 to Become Available on 7/30/04

This feature rich release of UniData includes the following
enhancements:
-  XML Enhancements, including the generation of XML Schema for
XML output, support for an XML DOM API in Basic, XML/DB tool to
move data from XML to/from UniData files, and a GUI XML/DB Mapping
tool
-  SOAP Client API
-  Secure Socket Layer (SSL) for JDBC
-  Table Relationship Mapping for ODBC Tools
-  UniObjects for .NET

The initial platforms on which this release will be available are
AIX, HPUX (RISC), Solaris, Windows and Red Hat Linux.  Stay tuned
for more details on the 7/30/04 release on the U2 website!



Peter Gonzalez
Senior Programmer Analyst
M  M Aerospace Hardware, Inc., a B/E Aerospace Company
1 NW 15 Terrace
Miami, Florida 33172
Phone: 305.925.2714
Fax: 305.925.2610
www.mmaero.com
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/



Peter Gonzalez
Senior Programmer Analyst
M  M Aerospace Hardware, Inc., a B/E Aerospace Company
1 NW 15 Terrace
Miami, Florida 33172
Phone: 305.925.2714
Fax: 305.925.2610
www.mmaero.com
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniObjects for .NET

2004-07-16 Thread Peter Gonzalez
It's not available till 7/30. Here is the link, but has no mention of the 
beta version.
http://www.ibm.com/isource/cgi-bin/goto?on=IMNL704J02


I received the monthly newsletter form IBM.

Subject: DB2 Information Management Software Today newsletter





At 11:39 AM 7/16/2004 -0400, you wrote:
Does it have a web link where we can obtain it !




Don Kibbey
Financial Systems Manager
Finnegan, Henderson, Farabow, Garrett  Dunner LLP
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/



Peter Gonzalez
Senior Programmer Analyst
M  M Aerospace Hardware, Inc., a B/E Aerospace Company
1 NW 15 Terrace
Miami, Florida 33172
Phone: 305.925.2714
Fax: 305.925.2610
www.mmaero.com
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] WHILE READNEXT id DO

2004-06-17 Thread Peter Gonzalez
That is what I have used for years.  It's simple to understand what the 
program is doing.


At 03:03 PM 6/17/2004 +0100, you wrote:
Why do you need the WHILE 1 DO?
You could use
LOOP
 READNEXT ID ELSE EXIT
 code

REPEAT



Peter Gonzalez
Senior Programmer Analyst
M  M Aerospace Hardware, Inc., a B/E Aerospace Company
1 NW 15 Terrace
Miami, Florida 33172
Phone: 305.925.2714
Fax: 305.925.2610
www.mmaero.com
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] WHILE READNEXT id DO

2004-06-17 Thread Peter Gonzalez
Now we all know that you are kidding, right?

Rule number 1 when we traine new programmers. NO GOTOs!

At 07:02 PM 6/17/2004 +0100, you wrote:
[EMAIL PROTECTED] ...
  LOOP
  code
  WHILE READNEXT id DO
  more code
  REPEAT

I prefer:

100
[code]
GOTO 300
200
[more code]
GOTO 100
300
READNEXT ID THEN GOTO 200
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/



Peter Gonzalez
Senior Programmer Analyst
M  M Aerospace Hardware, Inc., a B/E Aerospace Company
1 NW 15 Terrace
Miami, Florida 33172
Phone: 305.925.2714
Fax: 305.925.2610
www.mmaero.com
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] create date

2004-05-21 Thread Peter Gonzalez
Hello group,
Is there a Unidata internal stamp of when an item was created?

Thank you,
Peter Gonzalez
Senior Programmer 
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users