Re: [U2] [UV] Conversion code for week number

2007-07-11 Thread Ray Wurlod
There isn't one, and for a very good reason - you have to nail the business 
rules, and these won't be the same everywhere.  For example, on what dat does 
your week start?  It's Sunday for you (I assume, since you're in Australia), 
but it's Monday in the USA.  Some businesses run Thursday through Wednesday as 
their week.  The other business rule is the definition of week number 1 in the 
year.  Assuming that you want to implement the ISO 8601 standard format 
Wnn, in which every week has seven days, you must decide some kind of rule 
for week number 1 - for example the first week that has four dates in the 
calendar year.  Using such a rule January 1st is often in week #53 of the 
preceding year.

Of course, if you don't require seven days in every week, and week number 1 
starts on January 1st, then you can go with something like 
Int(Oconv(TheDate, DJ) / 7)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Logged user list

2007-07-11 Thread Ray Wurlod
Assuming this is UniVerse on UNIX, you have the PORT.STATUS command in the UV 
account, and you have ipcs -m | grep aceb at the operating system level.

If it's Windows-based UniVerse you still have PORT.STATUS.  The equivalent of 
ipcs is shrdump, but you don't have an equivalent for grep.  So you need your 
own mechanism for parsing out the aceb entries.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniObjects .NET - Security Best Practices, Connection Pooling in UD

2007-07-11 Thread Symeon Breen
[ad]

On the decompiling of .net source code - I am about to release some exciting
new software on this front to help in the security of .net applications,
including obfuscation, encryption, virtualisation and one click deploy.

We are still in beta but watch this space for our new developments
http://www.bitfactorysoftware.com/

[/ad]


Rgds
Symeon.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno
Sent: 10 July 2007 23:12
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UniObjects .NET - Security Best Practices, Connection
Pooling in UD

This can be a lengthy topic...

Following the MVC design pattern, when building any web app it's best to
funnel all data access through a single Data Access Layer (DAL).  This is
in preference to having MV-related code in every page and class throughout
a web application.  This makes maintenance easier, allows you to switch the
back-end for some or all functions, and allows for changing connectivity
tools - all without changing the entire front-end.  This also allows you to
get one person to do the front-end access and someone else to do data
access.  Someone who grew up on a green screen may not be adept at creating
an attractive or fully functional UI.  It also follows that someone can
change the front-end, even to something completely different like a web
service, without any changes to the DAL.

One of the best security methods is to not give people access to source.
Put your DAL into a DLL and take the source off of your deployment system.
If someone hacks in there they will be much less likely to find
vulnerabilities in your DAL code.  And because .NET code can be
de-compiled, obfuscate your assemblies.

Security is handled at different layers including transport and
application.  Transport security means using HTTPS from client to server,
and maybe SSH or tunneling for web server to DBMS.  Application security
involves authentication and authorization.  In other words, only allow
people in with an ID and password, and then ensure that only people who fit
a given role are authorized to access specific functions.  This prevents
someone with a generic ID from maliciously or accidentally executing things
they shouldn't.

Do not allow users to enter data which then gets executed blindly by
queries.  I think this is one of the biggest faults in MV applications when
a new UI is added.  This is known in the RDBMS world as SQL injection but
we are just as subject to queries being tweaked if your code does not
carefully screen data entry.

I don't use UO.NET so I can't comment on its pooling details.  I do sell,
support, and develop with mv.NET which has its own pooling mechanisms, and
that allows fine-tuning of license limits.  mv.NET is a superset of UO.NET,
and even uses UO.NET underneath as a basic transport tool.  I've also found
that UO.NET requires full permissions to do almost anything, and no one
seems to be able to tell us what the absolute minimal permissions are which
are required to run it.  That's not very security-friendly...

For assistance with any of the above, feel free to contact me.

Tony Gravagno
Nebula Research and Development
Worldwide distributor for mv.NET
TG@ removethisNebula-RnD.com


Robert Kubarych wrote:
 Does anyone have any security best practices for building web
 applications using UniObjects for .NET?
 
 I've placed the connection string in web.config and encrypted it, as
 well as created a separate remote account with a stripped down VOC. 
 The only data files that can be accessed from this separate remote
 are the two that the application needs to access (via pointers the
 main remote account).  I also tried to dial down the asp.net trust
 level runs with, but it seems that uniobjects for .net needs to run
 with full trust. 
 
 I guess it's not possible to use connection pooling until UniData 7.1.
 We are still on UniData 6.1.  Is there some other method I could use
 to limit the number of licenses the web application can grab?
---
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] Logged user list

2007-07-11 Thread chuchi
Thank you very much for your help!

in Unix, PORT.STATUS only show the users with the same name but this is
my requeriment.

Thanks again.


El miC), 11-07-2007 a las 16:05 +1000, Ray Wurlod escribiC3:

 Assuming this is UniVerse on UNIX, you have the PORT.STATUS command in the UV 
 account, and you have ipcs -m | grep aceb at the operating system level.
 
 If it's Windows-based UniVerse you still have PORT.STATUS.  The equivalent of 
 ipcs is shrdump, but you don't have an equivalent for grep.  So you need your 
 own mechanism for parsing out the aceb entries.
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
 

 
Pulse para ir al sitio web  
JesC:s Barbero RodrC-guez
Departamento de AnC!lisis y ProgramaciC3n - Desarrollo tecnolC3gico
Zoco Gran Santander, 1B* Planta b  39011 PeC1acastillo b  Santander b  
ESPACA

Tel.: +34 902 233 323 b  Fax: +34 902 234 280




AVISO LEGAL: Este mensaje contiene informaciC3n destinada exclusivamente
al usuario de destino, pudiendo contener informaciC3n confidencial o
protegida legalmente. Si, por un error de envC-o o transmisiC3n, ha
recibido este mensaje y usted no es el destinatario del mismo, por
favor, notifique de este hecho al remitente y no use, informe,
distribuya, imprima, copie o difunda este mensaje bajo ningC:n medio .
Cualquier opiniC3n en C)l contenida, es exclusiva de su autor y no
representa necesariamente la opiniC3n de Quiter Servicios InformC!ticos,
S.L.

LEGAL WARNING: This e-mail and any attachment, contain information
intended solely for the addressee and may contain confidential
information or legally protected data. If you are not the intended
recipient, please notify the sender and do not use, disclose,
distribute, copy, print or rely on this e-mail under any circumstances.
The views and opinions expressed are the authorE=s own and do not
necessarily reflect those of Quiter Servicios InformC!ticos, S.L.   
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] Conversion code for week number

2007-07-11 Thread MAJ Programming
Likewise for the business definitions of months and years. I've got clients
that have 13 EVEN 4 week months and one has 12 'months' offset by no-one
knows why days and an off year. For example, today, July 11, 2007 is period
06/08, meaning period 06 in year '08'. I ain't making this stuff up.

The 13 EVEN 4 weeks months client has a parent company in Holland. The 06/08
client has their HQ in USA and offices in Belgium and China. Go figure.

It's heavily dependent on control tables as I haven't been able to create a
calculation using a base date and constants to tell me what period September
27, 2004 was in.

BTW this was one of those Y2K things that didn't get resolved, ie the 06/08,
so theres dozens of dict items for sorting in the long-term history files.

One of my client's software REQUIRES that the end of month processing is
performed exactly on the last day of the month, regardless if it's a
saturday, sunday or New Year's Eve. Who were the brain surgeons that wrote
this? I've offered to add some hamburger helper but they wouldn't pay for it
as it's the way it's always been...

Finally, what is the calculation that MV uses for its internal dates? (Don't
bother telling me the base date, what's the calculation? I don't think it's
Thirty days hath September...) I've heard it called Zeller's Congruence
and I've looked it up but didn't get the direct connection to how our dates
are incredibly fastly derived/converted.

Thanks in advance
Mark Johnson


- Original Message -
From: Ray Wurlod [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Wednesday, July 11, 2007 2:00 AM
Subject: Re: [U2] [UV] Conversion code for week number


 There isn't one, and for a very good reason - you have to nail the
business rules, and these won't be the same everywhere.  For example, on
what dat does your week start?  It's Sunday for you (I assume, since you're
in Australia), but it's Monday in the USA.  Some businesses run Thursday
through Wednesday as their week.  The other business rule is the definition
of week number 1 in the year.  Assuming that you want to implement the ISO
8601 standard format Wnn, in which every week has seven days, you must
decide some kind of rule for week number 1 - for example the first week that
has four dates in the calendar year.  Using such a rule January 1st is often
in week #53 of the preceding year.

 Of course, if you don't require seven days in every week, and week number
1 starts on January 1st, then you can go with something like
 Int(Oconv(TheDate, DJ) / 7)
 ---
 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] Logged user list

2007-07-11 Thread colin.alfke
For simple stuff like this you can use find on windows on a command
line.

Hth
Colin Alfke
Calgary Canada 

-Original Message-
From: Ray Wurlod

Assuming this is UniVerse on UNIX, you have the PORT.STATUS command in
the UV account, and you have ipcs -m | grep aceb at the operating system
level.

If it's Windows-based UniVerse you still have PORT.STATUS.  The
equivalent of ipcs is shrdump, but you don't have an equivalent for
grep.  So you need your own mechanism for parsing out the aceb entries.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Error code 2

2007-07-11 Thread karlp
The following cron response came to me at 2:30pm in the day. We have
programs that run at various times, but this is the first time I've seen
this. What are the probable causes? TIA, Karl

* BEGIN CRON EMAIL 

1537 record(s) selected to SELECT list #0.
A fatal error has occurred in UniVerse.
Unable to re-open operating system file 
Error code   2


*
cron: The previous message is the standard output
and standard error of one of the cron commands.


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


[U2] Utilities for Pick-type to UniData-type (ODBC) Dictionary 'Conversions'

2007-07-11 Thread Bob Wyatt
Does anyone know of, have, use, or be willing to share a utility that
'converts' old-style PICK-type Virtual and I-descriptors in UniData to legal
ODBC/UniData descriptors? For example, changing Tfilename;X;n;m functions to
TRANS and like conversions. I am in the process of opening up hundreds of
files to ODBC; before reinventing the wheel, just checking to see if the
wheel has already been made. I did not see such a utility on pickwiki.

If such a utility is for sale, that would be good to know as well.
Feel free to contact me off-list if you are more comfortable doing so..

Regards, 

Bob Wyatt
Private E-Mail:  [EMAIL PROTECTED] 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Conversion code for week number

2007-07-11 Thread Jerry Banker
Zeller's Congruence finds the day of the week and, at least on UV, isn't
the same as what we use. It is 0 - 6, 0 is Saturday, and UV is 1 - 7, 1
is Monday.

-Original Message-
From: MAJ Programming [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 11, 2007 8:17 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Conversion code for week number

SNIP

Finally, what is the calculation that MV uses for its internal dates?
(Don't
bother telling me the base date, what's the calculation? I don't think
it's
Thirty days hath September...) I've heard it called Zeller's
Congruence
and I've looked it up but didn't get the direct connection to how our
dates
are incredibly fastly derived/converted.

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


RE: [U2] JMS and Unidata

2007-07-11 Thread Shin.Tanaka
We use JBoss.  Basically we use CallHTTP POST data to JBoss, and JBoss
format the request, and put it in JMS queue, send to the destination
(application).

We did that way since we've been using CallHTTP for a few years and our
UniBasic developer is comfortable using it.  
UniData's XML functionality is difficult to setup and code from my
personal experience...

We are running UniData 6.1.18 on HP-UX 11, and JBoss on Windows 2003
server.

Good Luck.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Chris Neal
Sent: Tuesday, July 10, 2007 9:01 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] JMS and Unidata

Has anyone had any experience integrating from Unibasic to JMS?

We were thinking of using the XML tools to map the database then use a
Database Trigger to send a XML message to a JMS server...


-- 
View this message in context:
http://www.nabble.com/JMS-and-Unidata-tf4059332.html#a11532415
Sent from the U2 - Users mailing list archive at Nabble.com.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Conversion code for week number

2007-07-11 Thread Anthony Youngman
I know you said don't tell me it's the base date, but the date 1/1/68
was chosen for a reason - it means divide by 365.25 actually gives the
right answer...

Cheers,
Wol

-Original Message-
From: MAJ Programming [mailto:[EMAIL PROTECTED] 
Sent: 11 July 2007 14:17
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Conversion code for week number

Finally, what is the calculation that MV uses for its internal dates?
(Don't
bother telling me the base date, what's the calculation? I don't think
it's
Thirty days hath September...) I've heard it called Zeller's
Congruence
and I've looked it up but didn't get the direct connection to how our
dates
are incredibly fastly derived/converted.

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


RE: [U2] [UV] Conversion code for week number

2007-07-11 Thread Timothy Snyder
 I know you said don't tell me it's the base date, but the date 1/1/68
 was chosen for a reason - it means divide by 365.25 actually gives the
 right answer...

Anybody that relies on that in code is bound to get a nasty surprise. 
There are dates for which that doesn't work.  Try it with July 7, 2006. 
Today's date is 14437, a year ago was 14072.  The difference is 365. 
Divide that by 365.25 and you get less than one year.  The argument could 
be made that you could round it after the division, but that will throw 
other dates off.  The bottom line is that this is not a safe way to 
accurately calculate an age - it's *almost* always right, but when that's 
not good enough, it shouldn't be used.

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


RE: [U2] Utilities for Pick-type to UniData-type (ODBC) Dictionary 'Conversions'

2007-07-11 Thread colin.alfke
When we first converted from Pick to Unidata, Unidata had a conversion
account that you used to restore the account into and then it converted
it. This was on Aix - I haven't seen anything on like it on Windows. It
was also back when Unidata was Unidata (not IBM or Informix).

IBM may be able to dredge up something???

Hth
Colin Alfke
Calgary Canada

-Original Message-
From: Bob Wyatt

Does anyone know of, have, use, or be willing to share a utility that
'converts' old-style PICK-type Virtual and I-descriptors in UniData to
legal ODBC/UniData descriptors? For example, changing Tfilename;X;n;m
functions to TRANS and like conversions. I am in the process of opening
up hundreds of files to ODBC; before reinventing the wheel, just
checking to see if the wheel has already been made. I did not see such a
utility on pickwiki.

If such a utility is for sale, that would be good to know as well.
Feel free to contact me off-list if you are more comfortable doing so..

Regards, 

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


RE: [U2] JMS and Unidata

2007-07-11 Thread Joseph Ruiz
Shin,
   How have you been?
Joe

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 11, 2007 9:52 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] JMS and Unidata

We use JBoss.  Basically we use CallHTTP POST data to JBoss, and JBoss
format the request, and put it in JMS queue, send to the destination
(application).

We did that way since we've been using CallHTTP for a few years and our
UniBasic developer is comfortable using it.  
UniData's XML functionality is difficult to setup and code from my
personal experience...

We are running UniData 6.1.18 on HP-UX 11, and JBoss on Windows 2003
server.

Good Luck.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Chris Neal
Sent: Tuesday, July 10, 2007 9:01 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] JMS and Unidata

Has anyone had any experience integrating from Unibasic to JMS?

We were thinking of using the XML tools to map the database then use a
Database Trigger to send a XML message to a JMS server...


-- 
View this message in context:
http://www.nabble.com/JMS-and-Unidata-tf4059332.html#a11532415
Sent from the U2 - Users mailing list archive at Nabble.com.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
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] Tracking Disk Writes - AIX, Unidata

2007-07-11 Thread Kevin King
AIX, Unidata 6.1, SB+ 5.3.8

I have a client who is experiencing something rather strange.  Every few
seconds, and not with any particularly regularity, topas will report a
spike in disk writes, maxing out one or more disks to 100% utilization.  CPU
utilization, on the other hand, remains nominal or only slightly elevated.
When this happens, the world stands still - literally - as user screens
freeze up until several seconds after the disks have gone back to normal
load. Is there an AIX utility that can be used to track which specific
processes are reading or writing disk?  This would be very helpful in
determining what (or who) specifically is triggering this activity.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Tracking Disk Writes - AIX, Unidata

2007-07-11 Thread Allen Egerton

Kevin King wrote:

AIX, Unidata 6.1, SB+ 5.3.8

I have a client who is experiencing something rather strange.  Every few
seconds, and not with any particularly regularity, topas will report a
spike in disk writes, maxing out one or more disks to 100% utilization.  CPU
utilization, on the other hand, remains nominal or only slightly elevated.
When this happens, the world stands still - literally - as user screens
freeze up until several seconds after the disks have gone back to normal
load. Is there an AIX utility that can be used to track which specific
processes are reading or writing disk?  This would be very helpful in
determining what (or who) specifically is triggering this activity.


Is filemon installed on their machine?

--
Allen Egerton
aegerton at pobox dot com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Tracking Disk Writes - AIX, Unidata

2007-07-11 Thread Clifton Oliver

Are you running JFS2?


On Jul 11, 2007, at 1:34 PM, Kevin King wrote:


AIX, Unidata 6.1, SB+ 5.3.8

I have a client who is experiencing something rather strange.   
Every few
seconds, and not with any particularly regularity, topas will  
report a
spike in disk writes, maxing out one or more disks to 100%  
utilization.  CPU
utilization, on the other hand, remains nominal or only slightly  
elevated.
When this happens, the world stands still - literally - as user  
screens
freeze up until several seconds after the disks have gone back to  
normal

load. Is there an AIX utility that can be used to track which specific
processes are reading or writing disk?  This would be very helpful in
determining what (or who) specifically is triggering this activity.
---
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] Tracking Disk Writes - AIX, Unidata

2007-07-11 Thread Scott Richardson
Sounds like swapping - how much physical RAM and swap space?
File system fragmentation?

You should be able to find a SMART Disk utility which may also prove helpful
 useful.

The DPMonitor (http://deltek.us ) will also track individual and system wide
processes


 Subject: Re: [U2] Tracking Disk Writes - AIX, Unidata
 Are you running JFS2?
%===
 I have a client who is experiencing something rather strange.
 Every few seconds, and not with any particularly regularity, topas will
 report a spike in disk writes, maxing out one or more disks to 100%
 utilization.  CPU utilization, on the other hand, remains nominal or only
 slightly  elevated.
 When this happens, the world stands still - literally - as user  screens
 freeze up until several seconds after the disks have gone back to
 normal load. Is there an AIX utility that can be used to track which
specific
 processes are reading or writing disk?  This would be very helpful in
 determining what (or who) specifically is triggering this activity.
 ---
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Error code 2

2007-07-11 Thread John Jenkins
Karl

I can't see enough from your posting, but if you are running UniVerse
foreground processes from crontab as root then please don't especially
AIX.

Change to a non-root crontab

Regards

JayJay

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: 11 July 2007 15:07
To: u2-users@listserver.u2ug.org
Subject: [U2] Error code 2

The following cron response came to me at 2:30pm in the day. We have
programs that run at various times, but this is the first time I've seen
this. What are the probable causes? TIA, Karl

* BEGIN CRON EMAIL 

1537 record(s) selected to SELECT list #0.
A fatal error has occurred in UniVerse.
Unable to re-open operating system file 
Error code   2


*
cron: The previous message is the standard output
and standard error of one of the cron commands.


  END CRON 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] Utilities for Pick-type to UniData-type (ODBC) Dictionary 'Conversions'

2007-07-11 Thread John Jenkins
There was a utility package that was used by UniData services - it used
various Unix tools to convert the Dictionaries (you needed a full compiler).

Worth an ask... UCONV3 I think. It converted *accounts* save in old
format BTW - not just Dictionaries.

To be honest - when I've done Dictionary conversions (many) for ODBC even
just in UniData - I find so many just-plain-wrong dictionaries that don't
reflect the data as it is I have to do the lot manually in any case.

Check S really is S, MV really is MV, SV really is SV, All MV and SV have
PHRASES (etc, etc).

Regards

JayJay

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Wyatt
Sent: 11 July 2007 15:11
To: u2-users@listserver.u2ug.org
Subject: [U2] Utilities for Pick-type to UniData-type (ODBC) Dictionary
'Conversions'

Does anyone know of, have, use, or be willing to share a utility that
'converts' old-style PICK-type Virtual and I-descriptors in UniData to legal
ODBC/UniData descriptors? For example, changing Tfilename;X;n;m functions to
TRANS and like conversions. I am in the process of opening up hundreds of
files to ODBC; before reinventing the wheel, just checking to see if the
wheel has already been made. I did not see such a utility on pickwiki.

If such a utility is for sale, that would be good to know as well.
Feel free to contact me off-list if you are more comfortable doing so..

Regards, 

Bob Wyatt
Private E-Mail:  [EMAIL PROTECTED] 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] Conversion code for week number

2007-07-11 Thread MAJ Programming
So we're guessing.

I gotta believe that there's something to it instead of simply counting
days, dividing by 365.25, carrying the 3, square root of October etc.

How does 1/1/68 mean 'divide by 365.25'? Also, divide 'what' by 365.25 ?

Considering how incredibly often the function is used and how blazingly fast
it does its ICONVs and OCONVs, there must be something more to it.

Thanks
- Original Message -
From: Timothy Snyder [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Wednesday, July 11, 2007 12:06 PM
Subject: RE: [U2] [UV] Conversion code for week number


  I know you said don't tell me it's the base date, but the date 1/1/68
  was chosen for a reason - it means divide by 365.25 actually gives the
  right answer...

 Anybody that relies on that in code is bound to get a nasty surprise.
 There are dates for which that doesn't work.  Try it with July 7, 2006.
 Today's date is 14437, a year ago was 14072.  The difference is 365.
 Divide that by 365.25 and you get less than one year.  The argument could
 be made that you could round it after the division, but that will throw
 other dates off.  The bottom line is that this is not a safe way to
 accurately calculate an age - it's *almost* always right, but when that's
 not good enough, it shouldn't be used.

 Tim Snyder
 Consulting I/T Specialist
 U2 Lab Services
 Information Management, IBM Software Group
 ---
 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/