RE: [U2] [OT] goodbye to the list(s)

2006-10-24 Thread Claus Derlien
I started programming on a zx81 in 1981 bought in Hong Kong complete
with tape recorder and 16 kb expansion pack for 650 hk $

I was a trainee on a huge maersk container ship - my plan was to be an
engineer maintaining ship diesels
but got hooked on computers, so i changed direction to computers, but
now i go back to the basics :-)

For the record : as a motorman i will be maintaining all mechanical
parts on the rig, as well as being man over board boat captain, and also
take of the role as helicopter landing officer :-)

I will prolly continue to do fun programming on my laptop with UniVerse
PE - one of the pleasures of being on an oil rig is the schedule : 2
weeks offshore 3 weeks on shore at home :-)


best regards from 'Soaking wet' denmark

Claus Derlien


 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
 Sent: Monday, October 23, 2006 2:40 PM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] [OT] goodbye to the list(s)
 
 Good luck. Sounds more exciting than sitting at a desk all day.
 
 For the benefit of all, what was your movitation to convert 
 to a really unrelated career? And what got you into 
 programming in the first place.
 
 Thanks
 Mark Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Have you ever seen this?

2006-10-24 Thread Bob Witney
I'm with Charles on this

I had a scenario a few years ago where we kept loosing the BP file

turned out that we had an active select wish a record key of BP in it and a 
basic delete was isssued and that cleared out the file (yes i know it doesnt 
sound right but i happenend)

I bet its a condition such as that and not malicious at all

Bob

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Stevenson,
Charles
Sent: 23 October 2006 21:04
To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED]
Subject: RE: [U2] Have you ever seen this?


My first guess would be a TCL DELETE command  that was expecting a hightly 
restrictive select list active,  but instead had the whole file.   Or instead 
of TCL delete,  it could be a basic program that did the same inside a readnext 
loop.
 
Or what about an SQL DELETE?I think the defualt there clears a file, i.e., 
there is no WHERE clause. 
 
 
One way the TCL DELETE  (or loop-readnext) scenario could happen would be if 
there were a 2-stage select,  and the second did NOT use REQUIRE.SELECT (aka 
SELECT.ONLY ) keyword.
 
A simple example:
 
   SELECT MASTERf WITH AGE  TWO.YEARS SAVING LINEITEM.IDS
   SELECT LINEITEM(    you _n_e_e_d_ REQUIRE.SELECT here  )
   DELETE LINEITEM
 
Suppose the 1st select comes up blank.
Then the second will be a select list of all LINEITEM ids.
Then the DELETE effectively clears the LINEITEM file.
 
That's where I would look first.
 
cds


From: Patricia Wilson

... an incident last week were one of more heavily used files, the LINEITEM 
file, all of the sudden  go to 0 bytes. Normally, this file has over 46K 
records.  It wasn't a peak load time, and there haven't been any recent changes 
to any BP's.
We had it happen again on another system, to the same file, LINEITEM. 2 
Different boxes, 2 different files (same name) @ 2 different times

[demime 1.01d removed an attachment of type application/ms-tnef which had a 
name of winmail.dat]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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


RE: [U2] [OT] goodbye to the list(s)

2006-10-24 Thread Hona, David S
Good luck Claus! Sounds like you'll have lots of fun on your 3 weeks
off! Not sure if working in the North Sea in winter would be much fun
though! A bit cold and windy, at the best of times, eh? ;-)

Take care and have fun!
David


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Claus Derlien
Sent: Tuesday, October 24, 2006 4:23 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [OT] goodbye to the list(s)

I started programming on a zx81 in 1981 bought in Hong Kong complete
with tape recorder and 16 kb expansion pack for 650 hk $

I was a trainee on a huge maersk container ship - my plan was to be an
engineer maintaining ship diesels but got hooked on computers, so i
changed direction to computers, but now i go back to the basics :-)

For the record : as a motorman i will be maintaining all mechanical
parts on the rig, as well as being man over board boat captain, and also
take of the role as helicopter landing officer :-)

I will prolly continue to do fun programming on my laptop with UniVerse
PE - one of the pleasures of being on an oil rig is the schedule : 2
weeks offshore 3 weeks on shore at home :-)


best regards from 'Soaking wet' denmark

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


RE: [U2] UD and VPN

2006-10-24 Thread Bill Haskett
Paul:

Telnet still doesn't work.  Here's the route print results after I
unchecked the Use default gateway on remote network checkbox:

BEFORE VPN CONNECTION:

C:\Documents and Settings\wphaskettroute print
===
Interface List
0x1 ... MS TCP Loopback interface
0x2 ...00 12 f0 27 db bd .. Intel(R) PRO/Wireless 2200BG Network
Connection
- Packet Scheduler Miniport
0x3 ...00 11 25 ae af 75 .. Intel(R) PRO/1000 MT Mobile Connection -
Packet
Scheduler Miniport
===
===
Active Routes:
Network DestinationNetmask  Gateway   Interface  Metric
  0.0.0.0  0.0.0.0  192.168.1.1192.168.1.51   1
127.0.0.0255.0.0.0127.0.0.1   127.0.0.1   1
  192.168.1.0255.255.255.0 192.168.1.51192.168.1.51   10
 192.168.1.51  255.255.255.255127.0.0.1   127.0.0.1   10
192.168.1.255  255.255.255.255 192.168.1.51192.168.1.51   10
224.0.0.0240.0.0.0 192.168.1.51192.168.1.51   10
  255.255.255.255  255.255.255.255 192.168.1.51192.168.1.51   1
  255.255.255.255  255.255.255.255 192.168.1.51   2   1
Default Gateway:   192.168.1.1
===
Persistent Routes:
  None


AFTER VPN CONNECTION:

C:\Documents and Settings\wphaskettroute print
===
Interface List
0x1 ... MS TCP Loopback interface
0x2 ...00 12 f0 27 db bd .. Intel(R) PRO/Wireless 2200BG Network
Connection
- Packet Scheduler Miniport
0x3 ...00 11 25 ae af 75 .. Intel(R) PRO/1000 MT Mobile Connection -
Packet
Scheduler Miniport
0x80005 ...00 53 45 00 00 00 .. WAN (PPP/SLIP) Interface
===
===
Active Routes:
Network DestinationNetmask  Gateway   Interface  Metric
  0.0.0.0  0.0.0.0  192.168.1.1192.168.1.51   1
   69.xxx.xxx.xxx  255.255.255.255  192.168.1.1192.168.1.51   1
127.0.0.0255.0.0.0127.0.0.1   127.0.0.1   1
  192.168.1.0255.255.255.0 192.168.1.51192.168.1.51   10
  192.168.1.0255.255.255.0 192.168.1.15192.168.1.15   1
 192.168.1.15  255.255.255.255127.0.0.1   127.0.0.1   50
 192.168.1.51  255.255.255.255127.0.0.1   127.0.0.1   10
192.168.1.255  255.255.255.255 192.168.1.15192.168.1.15   50
192.168.1.255  255.255.255.255 192.168.1.51192.168.1.51   10
224.0.0.0240.0.0.0 192.168.1.15192.168.1.15   50
224.0.0.0240.0.0.0 192.168.1.51192.168.1.51   10
  255.255.255.255  255.255.255.255 192.168.1.15192.168.1.15   1
  255.255.255.255  255.255.255.255 192.168.1.15   2   1
  255.255.255.255  255.255.255.255 192.168.1.51192.168.1.51   1
Default Gateway:   192.168.1.1
===
Persistent Routes:
  None

I'll have to read Colin's note a little more carefully, but thought Windows
would spare me the trouble of digging in by hand.  :-0

Bill Haskett
Advantos Systems, Inc.
What Software can be.
4370 La Jolla Village Drive, Suite 400
San Diego, CA  92122

*360-923-4838 (WA)
*760-944-5570 (CA)
[EMAIL PROTECTED]

Visit:  www.advantos.net

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Paul Hamrick
Sent: Monday, October 23, 2006 2:46 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UD and VPN

Bill,

In a follow-up response from Colin, he suggests a route is being added to
your local routing table (route print) when you connect that is throwing
everything off. Let's eliminate that route during the connection of the VPN
and see what the results are?...To prevent the new default route from being
created, select Internet Protocol (TCP/IP) on the Networking tab for the
properties of the VPN connection. Click Properties, and then click Advanced.
In Advanced TCP/IP Settings, on the General tab, clear the Use default
gateway on remote network check box. Reconnect and test the telnet.

Paul H.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Monday, October 23, 2006 2:48 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UD and VPN

Paul:

C:\Documents and Settings\wphaskettipconfig /all

Windows IP Configuration

Host Name . . . . . . . . . . . . : asibill

Re: [U2] [OT] goodbye to the list(s)

2006-10-24 Thread Anthony W. Youngman
In message [EMAIL PROTECTED], 
Claus Derlien [EMAIL PROTECTED] writes


I will prolly continue to do fun programming on my laptop with UniVerse
PE - one of the pleasures of being on an oil rig is the schedule : 2
weeks offshore 3 weeks on shore at home :-)

That's not as cushy as it sounds though ... although I was office staff, 
I also started my career with a company in the oil industry ... The 
engineers loved it though. They worked 2 weeks on, 2 weeks off, but it's 
a 72 hour week - 14 consecutive 12 hour days!


Some of my memories from those days are 300 baud terminals operating 
over the radio, print jobs going wrong spewing paper in offices hundreds 
of miles of sea away, etc etc. And little Prime Rabbits (2250s). Great 
days ... :-)


Cheers,
Wol
--
Anthony W. Youngman [EMAIL PROTECTED]
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man
lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Have you ever seen this?

2006-10-24 Thread Augusto Alonso
Just in case it gives you a guess:
Whe have similar behabiour, but whit Basic Programs.
We use an self-made GUI-Editor that open source code from a server (using
uniobjects), edit it,  an then write down or not.
But, if we lost the conexion with the server, then, the phisical file that
had souce code, becomes 0 bytes.

Regards,
__
Augusto Alonso Alonso
I.T.Manager
Quiter Servicios Informaticos S.L.
Tel: +34 902 23 33 23
Fax: +34 902 23 42 80
[EMAIL PROTECTED]
www.quiter.com
__
- Mensaje original -
De: Bob Witney [EMAIL PROTECTED]
Para: u2-users@listserver.u2ug.org
Enviado: martes, 24 de octubre de 2006 9:05
Asunto: RE: [U2] Have you ever seen this?


 I'm with Charles on this

 I had a scenario a few years ago where we kept loosing the BP file

 turned out that we had an active select wish a record key of BP in it and
a basic delete was isssued and that cleared out the file (yes i know it
doesnt sound right but i happenend)

 I bet its a condition such as that and not malicious at all

 Bob

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of Stevenson,
 Charles
 Sent: 23 October 2006 21:04
 To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED]
 Subject: RE: [U2] Have you ever seen this?


 My first guess would be a TCL DELETE command  that was expecting a hightly
restrictive select list active,  but instead had the whole file.   Or
instead of TCL delete,  it could be a basic program that did the same inside
a readnext loop.

 Or what about an SQL DELETE?I think the defualt there clears a file,
i.e., there is no WHERE clause.


 One way the TCL DELETE  (or loop-readnext) scenario could happen would be
if there were a 2-stage select,  and the second did NOT use REQUIRE.SELECT
(aka SELECT.ONLY ) keyword.

 A simple example:

SELECT MASTERf WITH AGE  TWO.YEARS SAVING LINEITEM.IDS
SELECT LINEITEM(    you _n_e_e_d_ REQUIRE.SELECT here  )
DELETE LINEITEM

 Suppose the 1st select comes up blank.
 Then the second will be a select list of all LINEITEM ids.
 Then the DELETE effectively clears the LINEITEM file.

 That's where I would look first.

 cds
 

 From: Patricia Wilson

 ... an incident last week were one of more heavily used files, the
LINEITEM file, all of the sudden  go to 0 bytes. Normally, this file has
over 46K records.  It wasn't a peak load time, and there haven't been any
recent changes to any BP's.
 We had it happen again on another system, to the same file, LINEITEM. 2
Different boxes, 2 different files (same name) @ 2 different times

 [demime 1.01d removed an attachment of type application/ms-tnef which had
a name of winmail.dat]
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/

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


Re: [U2] [OT] goodbye to the list(s)

2006-10-24 Thread Mark Johnson
Sounds like fun. Again, good luck in the future.
Mark Johnson
- Original Message - 
From: Claus Derlien [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Tuesday, October 24, 2006 2:22 AM
Subject: RE: [U2] [OT] goodbye to the list(s)


 I started programming on a zx81 in 1981 bought in Hong Kong complete
 with tape recorder and 16 kb expansion pack for 650 hk $
 
 I was a trainee on a huge maersk container ship - my plan was to be an
 engineer maintaining ship diesels
 but got hooked on computers, so i changed direction to computers, but
 now i go back to the basics :-)
 
 For the record : as a motorman i will be maintaining all mechanical
 parts on the rig, as well as being man over board boat captain, and also
 take of the role as helicopter landing officer :-)
 
 I will prolly continue to do fun programming on my laptop with UniVerse
 PE - one of the pleasures of being on an oil rig is the schedule : 2
 weeks offshore 3 weeks on shore at home :-)
 
 
 best regards from 'Soaking wet' denmark
 
 Claus Derlien
 
 
  -Original Message-
  From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
  Sent: Monday, October 23, 2006 2:40 PM
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] [OT] goodbye to the list(s)
  
  Good luck. Sounds more exciting than sitting at a desk all day.
  
  For the benefit of all, what was your movitation to convert 
  to a really unrelated career? And what got you into 
  programming in the first place.
  
  Thanks
  Mark Johnson
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UD] Compilation Failed...

2006-10-24 Thread colin.alfke
Make sure that you have modify rights in the BP directory.

Hth
Colin Alfke
Calgary Canada 

-Original Message-
From: David Wolverton

Well ... It does not appear to be TEMP related...

Example:

TESTBASIC BP IMPORT.CLIENTS
Compiling Unibasic: \STUFFHERE\BP\IMPORT.CLIENTS in mode 'p'.

compilation failed 
 
TESTCOPY BP IMPORT.CLIENTS  
TO: TESTING2

1 records copied


TESTBASIC BP TESTING2 
 
Compiling Unibasic: \STUFFHERE\BP\TESTING2 in mode 'p'.  
compilation finished


SO... I cannot compile the EXISTING program, but if I copy the 
source it to a new name, I **CAN** compile it.  So there is 
some permissions settings on the EXISTING object code 
(_progname) file that is the issue -- the problem is figuring out what.

I guess I'll just have the user compare the security of the 
two object codes to see what is different - as bad as I hate that!

If this extra information rings bells, please let me know...


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


RE: [U2] UD and VPN

2006-10-24 Thread colin.alfke
Bill;

The problem is that both networks use the same IP subnet. Think two
cities with the same street numbers (or phone numbers with different
area codes). The system needs some way to figure out which way to go.
The problem is that MS makes it easy for the home (non-network) user by
defaulting everything to use the remote network. I.e. the user dials
an ISP to connect to the internet. I guess MS expects office (network)
users to have someone that has paid MS for certification ;-) and knows
how to figure this out.

The best way to solve this problem depends on your answers to the
following questions:

Are there any other resources on the remote network that you want to
connect to after you make the VPN connection? 
Are there any resources on your office network that you want to connect
to after you make the VPN connection? 
Is it possible to change the IP addressing schemes on either network?

What is happening is that once the VPN connects is that it is saying
that when your PC needs to connect to anything starting with 192.168.1.
should use the VPN connection. Since your UD server is on that subnet it
looks for it over the VPN (you may have noticed that your e-mail doesn't
work as well).

There may be a way to control the routes that are generated by the VPN -
but it's way beyond my limited knowledge. Fortunately I've never hit the
problem you have with the remote network using the identical subnet
(which is odd as 192.168.1.0 is pretty standard). 

My quick and dirty solution was to add a route to tell your PC that when
you want to connect to the 192.168.1.12 address to use your local
network and not the VPN. Quick correction, try:

ROUTE ADD 192.168.1.12 MASK 255.255.255.255 192.168.1.51

If that works you can add the -p flag so that you don't have to keep
entering it. Hopefully that will override the routes the VPN creates.

Another way would be to delete the routes that the VPN creates and add
one for whichever (192.168.1.3?) server that you need to connect to on
the remote network. Hence my questions on which network you need more
access to. I would put all of the route statements in a bat file and run
it after connecting.

Hth
Colin Alfke
Calgary Canada


-Original Message-
From: Bill Haskett

Paul:

Telnet still doesn't work.  Here's the route print results after I
unchecked the Use default gateway on remote network checkbox:

BEFORE VPN CONNECTION:

C:\Documents and Settings\wphaskettroute print
===

Interface List
0x1 ... MS TCP Loopback interface
0x2 ...00 12 f0 27 db bd .. Intel(R) PRO/Wireless 2200BG Network
Connection
- Packet Scheduler Miniport
0x3 ...00 11 25 ae af 75 .. Intel(R) PRO/1000 MT Mobile Connection
-
Packet
Scheduler Miniport
===

===

Active Routes:
Network DestinationNetmask  Gateway   
Interface  Metric
  0.0.0.0  0.0.0.0  192.168.1.1192.168.1.51
1
127.0.0.0255.0.0.0127.0.0.1127.0.0.1
1
  192.168.1.0255.255.255.0 192.168.1.51192.168.1.51
10
 192.168.1.51  255.255.255.255127.0.0.1127.0.0.1
10
192.168.1.255  255.255.255.255 192.168.1.51192.168.1.51
10
224.0.0.0240.0.0.0 192.168.1.51192.168.1.51
10
  255.255.255.255  255.255.255.255 192.168.1.51192.168.1.51
1
  255.255.255.255  255.255.255.255 192.168.1.51   2
1
Default Gateway:   192.168.1.1
===

Persistent Routes:
  None


AFTER VPN CONNECTION:

C:\Documents and Settings\wphaskettroute print
===

Interface List
0x1 ... MS TCP Loopback interface
0x2 ...00 12 f0 27 db bd .. Intel(R) PRO/Wireless 2200BG Network
Connection
- Packet Scheduler Miniport
0x3 ...00 11 25 ae af 75 .. Intel(R) PRO/1000 MT Mobile Connection
-
Packet
Scheduler Miniport
0x80005 ...00 53 45 00 00 00 .. WAN (PPP/SLIP) Interface
===

===

Active Routes:
Network DestinationNetmask  Gateway   
Interface  Metric
  0.0.0.0  0.0.0.0  192.168.1.1192.168.1.51
1
   69.xxx.xxx.xxx  255.255.255.255  192.168.1.1192.168.1.51
1
127.0.0.0255.0.0.0127.0.0.1127.0.0.1
1
  192.168.1.0255.255.255.0 192.168.1.51192.168.1.51
10
  192.168.1.0255.255.255.0 192.168.1.15192.168.1.15
1
 192.168.1.15  255.255.255.255127.0.0.1127.0.0.1
50
 192.168.1.51  255.255.255.255127.0.0.1127.0.0.1
10
192.168.1.255  

Re: [U2] Have you ever seen this?

2006-10-24 Thread karlp
Don't forget to look for:

cat /dev/null  /path/to/filename

also...

Karl

quote who=Clifton Oliver
 On *nix systems, you could do this with

  echo   /path/to/filename

 Might be something to scan for in scripts.

 Any new cron scripts put in the week or so before the effect was seen?


 --

 Regards,

 Clif


 Ray Wurlod wrote:
 Even a CLEAR.FILE will not leave the file at 0 bytes - it always leaves
 a header.  So I'd be suspecting a rogue operating system delete command,
 whether malicious or not.  There's nothing in UniVerse that will detect
 this (alas).
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/



-- 
karl

 _/  _/  _/  _/_/_/      __o
_/ _/   _/  _/_/   _-\._
   _/_/_/  _/_/_/ (_)/ (_)
  _/ _/   _/  _/   ..
 _/   _/ arl _/_/_/  _/ earson[EMAIL PROTECTED]

--
IT Director, ATS Industrial Supply, Inc.
http://www.atsindustrial.com
Toll-free: 800-789-9300 x29
Direct2Desk: 801-978-4429
Facsimile: 801-972-3888
--
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Have you ever seen this?

2006-10-24 Thread Timothy Snyder
[EMAIL PROTECTED] wrote on 10/24/2006 10:51:23 AM:

 Don't forget to look for:
 cat /dev/null  /path/to/filename

While we're at it, you don't even need anything to the left of the 
redirection sign.  The following is a complete and valid statement for 
creating a new, empty file, or for replacing an existing file with an 
empty one:

 /path/to/filename

Tim Snyder
Consulting I/T Specialist
U2 Consulting
North American Lab Services
IBM Software Group
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UD] Compilation Failed...

2006-10-24 Thread Bob Woodward
I have a wild one for you.  In Universe, not Unidata, twice I've had
programs that would not compile properly.  I found that if I added a
statement to the source code then it would compile.  It doesn't matter
what the statement is as long as it affected memory usage.  These two
times, I just added the line Z=JUNK MESSAGE and that fixed whatever
the compiler was doing.

But you already have a fix.  You've copied the program so delete the
original and rename the copy to the originals filename.

YMMV,

BobW
 
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton
Sent: Monday, October 23, 2006 4:22 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] Compilation Failed...

Well ... It does not appear to be TEMP related...

Example:

TESTBASIC BP IMPORT.CLIENTS
Compiling Unibasic: \STUFFHERE\BP\IMPORT.CLIENTS in mode 'p'.

compilation failed 
 
TESTCOPY BP IMPORT.CLIENTS  
TO: TESTING2

1 records copied


TESTBASIC BP TESTING2  
Compiling Unibasic: \STUFFHERE\BP\TESTING2 in mode 'p'.  
compilation finished


SO... I cannot compile the EXISTING program, but if I copy the source it
to
a new name, I **CAN** compile it.  So there is some permissions settings
on
the EXISTING object code (_progname) file that is the issue -- the
problem
is figuring out what.

I guess I'll just have the user compare the security of the two object
codes
to see what is different - as bad as I hate that!

If this extra information rings bells, please let me know...


David W.


 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] On Behalf Of 
 Baakkonen, Rodney A (Rod) 46K
 Sent: Monday, October 23, 2006 4:15 PM
 To: u2-users@listserver.u2ug.org
 Subject: RE: [U2] [UD] Compilation Failed...
 
 Where do you have TMP pointing to? There is a default for TMP 
 in udtconfig. In UNIX the default can be overridden by 
 setting the environment variable TMP.
 
 
 
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of David 
 Wolverton
 Sent: Monday, October 23, 2006 3:06 PM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] [UD] Compilation Failed...
 
 
 I am at a client site today...
 
 Oddest thing - UniData 7.1.6 on Windows
 
 One sign on can compile - all is well.
 Another one cannot - it looks like it is compiling, but 
 always ends with 'compilation failed' - No line number 
 errors, nothing to give me a direction
 -- I compile the same program using a different signon and it 
 works... So I know it's security reasons...
 
 I can write to the VOC, and to the BP -- what permission 
 magic shouild I ask the user to fix for me?  Where else must 
 I need access to do a 'compile'?
 
 This is the first time I've run into this one!
 
 Thanks -
 David W.
 
  
 ===
 Sunset Programming, Inc.
 Developing Today for a Productive Tomorrow P 214.337.8204 F 
 469.442.1368 E [EMAIL PROTECTED] 
 ===
 CONFIDENTIALITY NOTICE:
 
 This e-mail message, and any accompanying documents, is for 
 the sole use of the intended recipient(s) and may contain 
 confidential and privileged information.  Any unauthorized 
 review, use, disclosure, distribution or copying is 
 prohibited.  If you are not the intended recipient, please 
 contact our office by email or by telephone at (214) 337-8204 
 and immediately 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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UD] Compilation Failed...

2006-10-24 Thread Kevin King
Is there perhaps a _IMPORT.CLIENTS in that directory that refuses to
be deleted or overwritten? 

-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com
 
** Check out scheduled Connect! training courses at
http://www.PrecisOnline.com/train.html.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [OT] Excel PivotTable Limitations

2006-10-24 Thread Kevin King
Is anyone aware of a PC-based tool that one can use to do analyses
like Excel PivotTables but without the 65,636 rows by 256 columns
limitation of Excel?
 
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com http://www.precisonline.com/ 
 
** Check out scheduled Connect! training courses at
http://www.precisonline.com/train.html
http://www.PrecisOnline.com/train.html.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UD] Compilation Failed...

2006-10-24 Thread Ross Craig
Here's a long shot.  Try formatting the code with the Format command
before you compile.  See if the Format command runs without errors.

Ross

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, October 24, 2006 5:27 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] Compilation Failed...

Make sure that you have modify rights in the BP directory.

Hth
Colin Alfke
Calgary Canada 

-Original Message-
From: David Wolverton

Well ... It does not appear to be TEMP related...

Example:

TESTBASIC BP IMPORT.CLIENTS
Compiling Unibasic: \STUFFHERE\BP\IMPORT.CLIENTS in mode 'p'.

compilation failed 
 
TESTCOPY BP IMPORT.CLIENTS  
TO: TESTING2

1 records copied


TESTBASIC BP TESTING2 
 
Compiling Unibasic: \STUFFHERE\BP\TESTING2 in mode 'p'.  
compilation finished


SO... I cannot compile the EXISTING program, but if I copy the 
source it to a new name, I **CAN** compile it.  So there is 
some permissions settings on the EXISTING object code 
(_progname) file that is the issue -- the problem is figuring out what.

I guess I'll just have the user compare the security of the 
two object codes to see what is different - as bad as I hate that!

If this extra information rings bells, please let me know...


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


RE: [U2] [UD] Compilation Failed...

2006-10-24 Thread Allen E. Elwood
I've had this happen when there was a TCP/IP hiccup while saving.

I'd get weird errors, totally off base.  So in another window, other than
the one I had the program opened in, I just did a CT BP pgm.name and it was
full of junk.  Saving again restored the program and it compiled fine.



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Bob Woodward
Sent: Tuesday, October 24, 2006 08:20
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] Compilation Failed...


I have a wild one for you.  In Universe, not Unidata, twice I've had
programs that would not compile properly.  I found that if I added a
statement to the source code then it would compile.  It doesn't matter
what the statement is as long as it affected memory usage.  These two
times, I just added the line Z=JUNK MESSAGE and that fixed whatever
the compiler was doing.

But you already have a fix.  You've copied the program so delete the
original and rename the copy to the originals filename.

YMMV,

BobW

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton
Sent: Monday, October 23, 2006 4:22 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] Compilation Failed...

Well ... It does not appear to be TEMP related...

Example:

TESTBASIC BP IMPORT.CLIENTS
Compiling Unibasic: \STUFFHERE\BP\IMPORT.CLIENTS in mode 'p'.

compilation failed

TESTCOPY BP IMPORT.CLIENTS
TO: TESTING2

1 records copied


TESTBASIC BP TESTING2
Compiling Unibasic: \STUFFHERE\BP\TESTING2 in mode 'p'.
compilation finished


SO... I cannot compile the EXISTING program, but if I copy the source it
to
a new name, I **CAN** compile it.  So there is some permissions settings
on
the EXISTING object code (_progname) file that is the issue -- the
problem
is figuring out what.

I guess I'll just have the user compare the security of the two object
codes
to see what is different - as bad as I hate that!

If this extra information rings bells, please let me know...


David W.


 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of
 Baakkonen, Rodney A (Rod) 46K
 Sent: Monday, October 23, 2006 4:15 PM
 To: u2-users@listserver.u2ug.org
 Subject: RE: [U2] [UD] Compilation Failed...

 Where do you have TMP pointing to? There is a default for TMP
 in udtconfig. In UNIX the default can be overridden by
 setting the environment variable TMP.



 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of David
 Wolverton
 Sent: Monday, October 23, 2006 3:06 PM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] [UD] Compilation Failed...


 I am at a client site today...

 Oddest thing - UniData 7.1.6 on Windows

 One sign on can compile - all is well.
 Another one cannot - it looks like it is compiling, but
 always ends with 'compilation failed' - No line number
 errors, nothing to give me a direction
 -- I compile the same program using a different signon and it
 works... So I know it's security reasons...

 I can write to the VOC, and to the BP -- what permission
 magic shouild I ask the user to fix for me?  Where else must
 I need access to do a 'compile'?

 This is the first time I've run into this one!

 Thanks -
 David W.


 ===
 Sunset Programming, Inc.
 Developing Today for a Productive Tomorrow P 214.337.8204 F
 469.442.1368 E [EMAIL PROTECTED]
 ===
 CONFIDENTIALITY NOTICE:

 This e-mail message, and any accompanying documents, is for
 the sole use of the intended recipient(s) and may contain
 confidential and privileged information.  Any unauthorized
 review, use, disclosure, distribution or copying is
 prohibited.  If you are not the intended recipient, please
 contact our office by email or by telephone at (214) 337-8204
 and immediately 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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UD] Compilation Failed...

2006-10-24 Thread Bob Wyatt
Mark Johnson can tell a story (well, another story) about UniData doing the
same thing; UniData 5.1, to be exact. Mark and I worked on that for quite
some time before Mark just gave up and left the useless stuff in there to
make the program work. At least, to the best of my recollection, that was
how it was handled in the end.

I worked with the support team (UniData/Ardent/Informix) in place at that
time; it wasn't readily reproducible, and there never was a fix (at least,
that I knew of). 

Regards,

Bob Wyatt

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward
Sent: Tuesday, October 24, 2006 11:20
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] Compilation Failed...

I have a wild one for you.  In Universe, not Unidata, twice I've had
programs that would not compile properly.  I found that if I added a
statement to the source code then it would compile.  It doesn't matter
what the statement is as long as it affected memory usage.  These two
times, I just added the line Z=JUNK MESSAGE and that fixed whatever
the compiler was doing.

But you already have a fix.  You've copied the program so delete the
original and rename the copy to the originals filename.

YMMV,

BobW
 
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton
Sent: Monday, October 23, 2006 4:22 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] Compilation Failed...

Well ... It does not appear to be TEMP related...

Example:

TESTBASIC BP IMPORT.CLIENTS
Compiling Unibasic: \STUFFHERE\BP\IMPORT.CLIENTS in mode 'p'.

compilation failed 
 
TESTCOPY BP IMPORT.CLIENTS  
TO: TESTING2

1 records copied


TESTBASIC BP TESTING2  
Compiling Unibasic: \STUFFHERE\BP\TESTING2 in mode 'p'.  
compilation finished


SO... I cannot compile the EXISTING program, but if I copy the source it
to
a new name, I **CAN** compile it.  So there is some permissions settings
on
the EXISTING object code (_progname) file that is the issue -- the
problem
is figuring out what.

I guess I'll just have the user compare the security of the two object
codes
to see what is different - as bad as I hate that!

If this extra information rings bells, please let me know...


David W.


 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] On Behalf Of 
 Baakkonen, Rodney A (Rod) 46K
 Sent: Monday, October 23, 2006 4:15 PM
 To: u2-users@listserver.u2ug.org
 Subject: RE: [U2] [UD] Compilation Failed...
 
 Where do you have TMP pointing to? There is a default for TMP 
 in udtconfig. In UNIX the default can be overridden by 
 setting the environment variable TMP.
 
 
 
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of David 
 Wolverton
 Sent: Monday, October 23, 2006 3:06 PM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] [UD] Compilation Failed...
 
 
 I am at a client site today...
 
 Oddest thing - UniData 7.1.6 on Windows
 
 One sign on can compile - all is well.
 Another one cannot - it looks like it is compiling, but 
 always ends with 'compilation failed' - No line number 
 errors, nothing to give me a direction
 -- I compile the same program using a different signon and it 
 works... So I know it's security reasons...
 
 I can write to the VOC, and to the BP -- what permission 
 magic shouild I ask the user to fix for me?  Where else must 
 I need access to do a 'compile'?
 
 This is the first time I've run into this one!
 
 Thanks -
 David W.
 
  
 ===
 Sunset Programming, Inc.
 Developing Today for a Productive Tomorrow P 214.337.8204 F 
 469.442.1368 E [EMAIL PROTECTED] 
 ===
 CONFIDENTIALITY NOTICE:
 
 This e-mail message, and any accompanying documents, is for 
 the sole use of the intended recipient(s) and may contain 
 confidential and privileged information.  Any unauthorized 
 review, use, disclosure, distribution or copying is 
 prohibited.  If you are not the intended recipient, please 
 contact our office by email or by telephone at (214) 337-8204 
 and immediately 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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UD] Compilation Failed...

2006-10-24 Thread David Wolverton
They found the issue - you must have FULL CONTROL or be the OWHER of the
object code to do a compile.

No other option ended up fixing the issue.  But once the User was given
FullControl, the compile issue vanished.

I would have thoought the ability to 'modify' would have been enough!

Thanks for the suggestions and thoughts - it was a Windows brain teaser...
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UD] Compilation Failed...

2006-10-24 Thread Susan Lynch
Folks,

All that is well and good if it is a single program that is the problem -
you can copy and rename, or add dummy lines as a workaround.  I had worked
with David on the problem he was having before he submitted it to the group,
and it was actually most of the programs in the (large!) file.

Any other ideas?

Susan Lynch
F.W. Davison  Company, Inc.
- Original Message - 
From: Bob Wyatt [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Tuesday, October 24, 2006 12:08 PM
Subject: RE: [U2] [UD] Compilation Failed...


 Mark Johnson can tell a story (well, another story) about UniData doing
the
 same thing; UniData 5.1, to be exact. Mark and I worked on that for quite
 some time before Mark just gave up and left the useless stuff in there to
 make the program work. At least, to the best of my recollection, that was
 how it was handled in the end.

 I worked with the support team (UniData/Ardent/Informix) in place at that
 time; it wasn't readily reproducible, and there never was a fix (at least,
 that I knew of).

 Regards,

 Bob Wyatt

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward
 Sent: Tuesday, October 24, 2006 11:20
 To: u2-users@listserver.u2ug.org
 Subject: RE: [U2] [UD] Compilation Failed...

 I have a wild one for you.  In Universe, not Unidata, twice I've had
 programs that would not compile properly.  I found that if I added a
 statement to the source code then it would compile.  It doesn't matter
 what the statement is as long as it affected memory usage.  These two
 times, I just added the line Z=JUNK MESSAGE and that fixed whatever
 the compiler was doing.

 But you already have a fix.  You've copied the program so delete the
 original and rename the copy to the originals filename.

 YMMV,

 BobW

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton
 Sent: Monday, October 23, 2006 4:22 PM
 To: u2-users@listserver.u2ug.org
 Subject: RE: [U2] [UD] Compilation Failed...

 Well ... It does not appear to be TEMP related...

 Example:

 TESTBASIC BP IMPORT.CLIENTS
 Compiling Unibasic: \STUFFHERE\BP\IMPORT.CLIENTS in mode 'p'.

 compilation failed

 TESTCOPY BP IMPORT.CLIENTS
 TO: TESTING2

 1 records copied


 TESTBASIC BP TESTING2
 Compiling Unibasic: \STUFFHERE\BP\TESTING2 in mode 'p'.
 compilation finished


 SO... I cannot compile the EXISTING program, but if I copy the source it
 to
 a new name, I **CAN** compile it.  So there is some permissions settings
 on
 the EXISTING object code (_progname) file that is the issue -- the
 problem
 is figuring out what.

 I guess I'll just have the user compare the security of the two object
 codes
 to see what is different - as bad as I hate that!

 If this extra information rings bells, please let me know...


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


RE: [U2] UD and VPN

2006-10-24 Thread Bill Haskett
Colin:

As always, thanks; it would have taken me quite a while to figure this out.
I guess I need a certified VPN person...too many standards to choose from.
:-)

Bill


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, October 24, 2006 6:49 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UD and VPN

Bill;

The problem is that both networks use the same IP subnet. Think two
cities with the same street numbers (or phone numbers with different
area codes). The system needs some way to figure out which way to go.
The problem is that MS makes it easy for the home (non-network) user by
defaulting everything to use the remote network. I.e. the user dials
an ISP to connect to the internet. I guess MS expects office (network)
users to have someone that has paid MS for certification ;-) and knows
how to figure this out.

The best way to solve this problem depends on your answers to the
following questions:

Are there any other resources on the remote network that you want to
connect to after you make the VPN connection? 
Are there any resources on your office network that you want to connect
to after you make the VPN connection? 
Is it possible to change the IP addressing schemes on either network?

What is happening is that once the VPN connects is that it is saying
that when your PC needs to connect to anything starting with 192.168.1.
should use the VPN connection. Since your UD server is on that subnet it
looks for it over the VPN (you may have noticed that your e-mail doesn't
work as well).

There may be a way to control the routes that are generated by the VPN -
but it's way beyond my limited knowledge. Fortunately I've never hit the
problem you have with the remote network using the identical subnet
(which is odd as 192.168.1.0 is pretty standard). 

My quick and dirty solution was to add a route to tell your PC that when
you want to connect to the 192.168.1.12 address to use your local
network and not the VPN. Quick correction, try:

ROUTE ADD 192.168.1.12 MASK 255.255.255.255 192.168.1.51

If that works you can add the -p flag so that you don't have to keep
entering it. Hopefully that will override the routes the VPN creates.

Another way would be to delete the routes that the VPN creates and add
one for whichever (192.168.1.3?) server that you need to connect to on
the remote network. Hence my questions on which network you need more
access to. I would put all of the route statements in a bat file and run
it after connecting.

Hth
Colin Alfke
Calgary Canada


-Original Message-
From: Bill Haskett

Paul:

Telnet still doesn't work.  Here's the route print results after I
unchecked the Use default gateway on remote network checkbox:

BEFORE VPN CONNECTION:

C:\Documents and Settings\wphaskettroute print
===

Interface List
0x1 ... MS TCP Loopback interface
0x2 ...00 12 f0 27 db bd .. Intel(R) PRO/Wireless 2200BG Network
Connection
- Packet Scheduler Miniport
0x3 ...00 11 25 ae af 75 .. Intel(R) PRO/1000 MT Mobile Connection
-
Packet
Scheduler Miniport
===

===

Active Routes:
Network DestinationNetmask  Gateway   
Interface  Metric
  0.0.0.0  0.0.0.0  192.168.1.1192.168.1.51
1
127.0.0.0255.0.0.0127.0.0.1127.0.0.1
1
  192.168.1.0255.255.255.0 192.168.1.51192.168.1.51
10
 192.168.1.51  255.255.255.255127.0.0.1127.0.0.1
10
192.168.1.255  255.255.255.255 192.168.1.51192.168.1.51
10
224.0.0.0240.0.0.0 192.168.1.51192.168.1.51
10
  255.255.255.255  255.255.255.255 192.168.1.51192.168.1.51
1
  255.255.255.255  255.255.255.255 192.168.1.51   2
1
Default Gateway:   192.168.1.1
===

Persistent Routes:
  None


AFTER VPN CONNECTION:

C:\Documents and Settings\wphaskettroute print
===

Interface List
0x1 ... MS TCP Loopback interface
0x2 ...00 12 f0 27 db bd .. Intel(R) PRO/Wireless 2200BG Network
Connection
- Packet Scheduler Miniport
0x3 ...00 11 25 ae af 75 .. Intel(R) PRO/1000 MT Mobile Connection
-
Packet
Scheduler Miniport
0x80005 ...00 53 45 00 00 00 .. WAN (PPP/SLIP) Interface
===

===

Active Routes:
Network DestinationNetmask  Gateway   
Interface  Metric
  0.0.0.0  0.0.0.0  192.168.1.1192.168.1.51
1
   69.xxx.xxx.xxx  255.255.255.255  192.168.1.1   

RE: [U2] [OT] Excel PivotTable Limitations

2006-10-24 Thread phil walker
Excel 2007

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
Sent: Wednesday, 25 October 2006 6:00 a.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] [OT] Excel PivotTable Limitations

Is anyone aware of a PC-based tool that one can use to do analyses like
Excel PivotTables but without the 65,636 rows by 256 columns limitation
of Excel?
 
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com http://www.precisonline.com/ 
 
** Check out scheduled Connect! training courses at
http://www.precisonline.com/train.html
http://www.PrecisOnline.com/train.html.
---
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] RE: [UD] Compilation Failed...

2006-10-24 Thread David Wolverton
I sent this earlier, but it did not post... 

Odd??  

 -Original Message-
 From: David Wolverton [mailto:[EMAIL PROTECTED] 
 Sent: Monday, October 23, 2006 3:06 PM
 To: 'u2-users@listserver.u2ug.org'
 Subject: [UD] Compilation Failed...
 
 I am at a client site today...
 
 Oddest thing - UniData 7.1.6 on Windows
 
 One sign on can compile - all is well.
 Another one cannot - it looks like it is compiling, but 
 always ends with 'compilation failed' - No line number 
 errors, nothing to give me a direction -- I compile the same 
 program using a different signon and it works... So I know 
 it's security reasons...
 
 I can write to the VOC, and to the BP -- what permission 
 magic shouild I ask the user to fix for me?  Where else must 
 I need access to do a 'compile'?
 
 This is the first time I've run into this one!
 
 Thanks -
 David W.
 
  
 ===
 Sunset Programming, Inc.
 Developing Today for a Productive Tomorrow P 214.337.8204 F 
 469.442.1368 E [EMAIL PROTECTED] 
 ===
 CONFIDENTIALITY NOTICE:
 
 This e-mail message, and any accompanying documents, is for 
 the sole use of the intended recipient(s) and may contain 
 confidential and privileged information.  Any unauthorized 
 review, use, disclosure, distribution or copying is 
 prohibited.  If you are not the intended recipient, please 
 contact our office by email or by telephone at (214) 337-8204 
 and immediately 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] [OT] Excel PivotTable Limitations

2006-10-24 Thread Jeff Schasny

Cognos Powerplay. Good stuff.

Kevin King wrote:

Is anyone aware of a PC-based tool that one can use to do analyses
like Excel PivotTables but without the 65,636 rows by 256 columns
limitation of Excel?
 
-Kevin

[EMAIL PROTECTED]
http://www.PrecisOnline.com http://www.precisonline.com/ 
 
** Check out scheduled Connect! training courses at

http://www.precisonline.com/train.html
http://www.PrecisOnline.com/train.html.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


  


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


RE: [U2] [OT] Excel PivotTable Limitations

2006-10-24 Thread Ron Sharcott
MS Access? Excel has always been the most limiting of the Office apps.


Ron Sharcott (3635)


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
Sent: Tuesday, October 24, 2006 8:44 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [OT] Excel PivotTable Limitations


Is anyone aware of a PC-based tool that one can use to do analyses like
Excel PivotTables but without the 65,636 rows by 256 columns limitation of
Excel?
 
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com http://www.precisonline.com/ 
 
** Check out scheduled Connect! training courses at
http://www.precisonline.com/train.html
http://www.PrecisOnline.com/train.html.
---
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] [OT] Excel PivotTable Limitations

2006-10-24 Thread Richard Taylor
   Try doing the ODBC Query, but tell Excel to generate an OLAP cube file
   instead  of  returning  the  results of to excel directly.  This is an
   option  off the last page of the query wizard.  You can then run pivot
   tables  off  the  cube  file  (a  .cub  file).   You can also save the
   definition  of  the cube and then regenerate it simply by opening that
   definition file (a .oqy extension I believe)

   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS

   250 W. Pratt Street | Baltimore, MD 21201

   P 410.361.8688 | F 410.454.8392

   [EMAIL PROTECTED] | http://www.vertisinc.com

   Vertis  Communications  -  Partnering  with  clients to solve the most
   complex,   time-sensitive  marketing  challenges  through  consulting,
   creative,   research,   direct,   media,  technology,  and  production
   services.

   The more they complicate the plumbing

 the easier it is to stop up the drain

   - Montgomery Scott NCC-1701
   __

   From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED]  On Behalf Of Kevin King
   [EMAIL PROTECTED]
   Sent: Tuesday, October 24, 2006 11:44 AM
   To: u2-users@listserver.u2ug.org
   Subject: [U2] [OT] Excel PivotTable Limitations

   Is anyone aware of a PC-based tool that one can use to do analyses
   like Excel PivotTables but without the 65,636 rows by 256 columns
   limitation of Excel?
   -Kevin
   [EMAIL PROTECTED]
   http://www.PrecisOnline.com
   ** Check out scheduled Connect! training courses at
   http://www.PrecisOnline.com/train.html.
   ---
   u2-users mailing list
   u2-users@listserver.u2ug.org
   To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UD] Compilation Failed...

2006-10-24 Thread David Wolverton
ACTUALLY --

This is what I sent earlier today!! I forwarded the wrong/old message!!

DW 

 -Original Message-
 From: David Wolverton [mailto:[EMAIL PROTECTED] 
 Sent: Tuesday, October 24, 2006 11:18 AM
 To: 'u2-users@listserver.u2ug.org'
 Subject: RE: [U2] [UD] Compilation Failed...
 
 They found the issue - you must have FULL CONTROL or be the 
 OWHER of the object code to do a compile.
 
 No other option ended up fixing the issue.  But once the User 
 was given FullControl, the compile issue vanished.
 
 I would have thoought the ability to 'modify' would have been enough!
 
 Thanks for the suggestions and thoughts - it was a Windows 
 brain teaser...
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UD and VPN

2006-10-24 Thread colin.alfke
No problem. I wish we had one too. I've learned from the school of hard
knocks. The number of methods that we use to connect is silly.
Everything from straight telnet, Remote Desktop, RAS, proprietary
dial-up, PcAnywhere,  various VPN's (MS, Cisco, Novell, Nortel,
Contivity), Citrix, Webex, GotoMyPC, etc. Combined with a number of
non-standard ports and hardware dongles it becomes a real nightmare
sometimes to get everything to work together

Hth
Colin Alfke
Calgary Canada

-Original Message-
From: Bill Haskett

Colin:

As always, thanks; it would have taken me quite a while to 
figure this out.
I guess I need a certified VPN person...too many standards to 
choose from.
:-)

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


RE: [U2] UD and VPN

2006-10-24 Thread Allen E. Elwood
And to think when I was born the only 'connectivity' that existed was the
phone. with a dial !

Allen 'in 83 degree SoCal, light breeze and clear skies' Elwood

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, October 24, 2006 12:24
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UD and VPN


No problem. I wish we had one too. I've learned from the school of hard
knocks. The number of methods that we use to connect is silly.
Everything from straight telnet, Remote Desktop, RAS, proprietary
dial-up, PcAnywhere,  various VPN's (MS, Cisco, Novell, Nortel,
Contivity), Citrix, Webex, GotoMyPC, etc. Combined with a number of
non-standard ports and hardware dongles it becomes a real nightmare
sometimes to get everything to work together

Hth
Colin Alfke
Calgary Canada

-Original Message-
From: Bill Haskett

Colin:

As always, thanks; it would have taken me quite a while to
figure this out.
I guess I need a certified VPN person...too many standards to
choose from.
:-)

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] [OT] goodbye to the list(s)

2006-10-24 Thread Craig Bennett

Farewell Claus.

Have fun in the Sunny North Sea (Oh, you meant THAT North Sea).


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


RE: [U2] Have you ever seen this?

2006-10-24 Thread Stevenson, Charles
Patricia, 

When you said 0 bytes, did you really mean zero bytes at the os?  Or
did you mean zero records, i.e., an empty data file from the UV
perspective?
 
What was the file's type?  The name LINEITEM suggests hashed.  Static
or Dynamic?  What would it look like if you lacked r or x rights to the
type 30's directory?

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