Re: [U2] FTP

[Nancy Fisher]

Thanks Tony.

Nancy
[EMAIL PROTECTED]

- Original Message - 
From: "Tony Gravagno" <[EMAIL PROTECTED]>

To: 
Sent: Sunday, March 11, 2007 7:49 PM
Subject: RE: [U2] FTP



I see security has been mentioned a couple times but I hope that sinks in -
FTP is not a secure protocol.  Your EDI headers and detail are open for
viewing.  Seeing that you're in the trucking business someone might find 
it

worth their time to watch your packets or maybe even make modifications in
order to redirect or intercept shipments.  No, not paranoia, it happens.

In your case where you could be sending data from the client or the 
server,

I'd recommend using cURL, which has consistent cross-OS syntax (unlike
Windows FTP and *nix FTP which are different) as well as security via
OpenSSL.  I've used FTP from AccuTerm and I use AccuTerm for a lot of 
other

purposes, but there are limits to what we can do from the client,
especially in a dynamic environment.

Also, FTP itself is not a guaranteed protocol.  Any code you have written
around it should be able to recognize and handle faults.  As one simple
example, FTP may be blocked at any time by updates to Windows Firewall or
other firewall/anti-virus software or hardware.  A new PC may not be able
to FTP out.  Someone doing work from home may have completely different
network conditions.  Unless you capture the results of connections and
return them to the server, you may not know when errors happen.

In the trucking business you need to ensure that your transactions are
received and acknowledged.  This is why EDI has traditionally moved 
through

Value-Add Networks.  They are expensive but they do manage transactions
effectively.  If you don't use a VAN then be sure to code for faults, and
record successful transactions yourself to answer those "we didn't get it"
issues.

HTH
Tony Gravagno
Nebula Research and Development
TG@ removethisNebula-RnD.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] FTP

[Tony Gravagno]

I see security has been mentioned a couple times but I hope that sinks in -
FTP is not a secure protocol.  Your EDI headers and detail are open for
viewing.  Seeing that you're in the trucking business someone might find it
worth their time to watch your packets or maybe even make modifications in
order to redirect or intercept shipments.  No, not paranoia, it happens.

In your case where you could be sending data from the client or the server,
I'd recommend using cURL, which has consistent cross-OS syntax (unlike
Windows FTP and *nix FTP which are different) as well as security via
OpenSSL.  I've used FTP from AccuTerm and I use AccuTerm for a lot of other
purposes, but there are limits to what we can do from the client,
especially in a dynamic environment.

Also, FTP itself is not a guaranteed protocol.  Any code you have written
around it should be able to recognize and handle faults.  As one simple
example, FTP may be blocked at any time by updates to Windows Firewall or
other firewall/anti-virus software or hardware.  A new PC may not be able
to FTP out.  Someone doing work from home may have completely different
network conditions.  Unless you capture the results of connections and
return them to the server, you may not know when errors happen.

In the trucking business you need to ensure that your transactions are
received and acknowledged.  This is why EDI has traditionally moved through
Value-Add Networks.  They are expensive but they do manage transactions
effectively.  If you don't use a VAN then be sure to code for faults, and
record successful transactions yourself to answer those "we didn't get it"
issues.

HTH
Tony Gravagno
Nebula Research and Development
TG@ removethisNebula-RnD.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Universe/UniObjects and Visual Studio

[Victor St Clair]

You'll have to do two things.

In Visual Studio, in the Solution Explorer, right click on your project,
and choose Add Reference from the context menu.  When the Add Reference
dialog displays, choose the Browse tab.  Use that to navigate to where
ever your UODOTNET.dll file is located.

Second step is to add a compiler directive in your source code like
this,
Using UODOTNET; (assuming c#)  or Imports UODOTNET (using VB).

hth
 

Victor St. Clair
Jenkon
Sr. Analyst
[EMAIL PROTECTED]
360-256-4400 Phone
360-256-9623 Fax
www.jenkon.com

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony
Dzikiewicz
Sent: Sunday, March 11, 2007 6:34 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe/UniObjects and Visual Studio

Dave,
I was able to get the COM assembly in the solution explorer.  I am now
looking at the .Net.  How do I go about getting the .Net assembly in the
'game'.  What I have tried is to go into the control panel on the PC and
go under admin, .Net framework and config, and tried to add.  I pointed
to the c:\ibm\unidk\uonet\bin\uodotnet.dll.  Of course Im just winging
it here.  It seemed that this made sense.  However, it does not appear
in the solutions explorer when I try yo add a .Net reference.  So, I
tried but no cigar.  What is the right way to do this ?
Anthony

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Jordan
Sent: Sunday, March 11, 2007 8:53 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe/UniObjects and Visual Studio


Hi Anthony

Whilst UniObjects works with .Net, it is a COM assembly and needs to be
loads as a Comm Component.  IBM does provide a .Net assembly for U2, and
it would be better to use that.

You can add the Com or .Net attributes through the Add references in the
Solution Explorer.

Regards

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

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.8/716 - Release Date: 3/9/2007
6:53 PM
 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.8/716 - Release Date: 3/9/2007
6:53 PM
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Are 'Progress' or 'RedBrick' databases multi-value? {Unclassified}

[David Jordan]

Hi Mike

Progress is not Multivalue, it is an RDBM, although it has probably focused
a bit more on being a front end tool for other RDBMS.  It is not as
prominent as it used to be and fits in about the same market size as U2 and
is also an embedded database marketing methodology.

RedBrick is a Datawarehouse specialised product designed to handle Data
warehouse extractions, ie Star Schemas, etc.  I don't believe it has any
Multivalue, although it may look like it as it is designed to Processes Data
Cubes.  This was an Informix product, that has been swallowed by IBM and I
believe IBM feels that the new Version of DB2 does a better job.

Regards

David Jordan

Managing Consultant
[EMAIL PROTECTED]
Mobile: 0428 669 730

 
Phone: 61 2 9418 8329
Fax: 61 2 9427 2371
PO Box 909
Lane Cove
NSW 2066
Australia
www.dacono.com.au

CAUTION: This email and any attachments are confidential, may be privileged,
and are intended for use solely by the addressee. The confidentiality and/or
privilege in this email is not waived, lost or destroyed if it has been
transmitted to you in error. If you receive this email in error, please
notify Dacono by reply email immediately, delete the email and destroy any
printed copies. You must not disclose, disseminate, distribute, reproduce or
use the information contained in this email which may contain intellectual
property or copyright irrespective whether you are or are not the intended
recipient. The content and opinions contained in this email are those of the
individual sender and may not necessarily reflect the views and opinions of
Dacono. Dacono does not guarantee that this email is free from viruses,
errors, interception or interference. Use of this email and any attachments
is at the sole risk of the user. Dacono does not accept any liability for
any loss or damage to your computer system or network (including any
consequential damage) which may occur directly or indirectly from the use of
this email. 

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:owner-u2-
> [EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR
> Sent: Monday, 12 March 2007 10:34 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Are 'Progress' or 'RedBrick' databases multi-value?
> {Unclassified}
> 
> Folks,
> 
> I have been asked to find out if either 'Progress' or 'RedBrick'
> databases are multi-value.  Their web-sites don't say anything either
> way so far as a quick look told me, but we all know that many products
> are shy about any association with 'Pick'.
> 
> So, any information would be helpful.
> 
> 
> Thanks in advance
> 
> Mike
> 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/

RE: [U2] Universe/UniObjects and Visual Studio

[Anthony Dzikiewicz]

Dave,
I was able to get the COM assembly in the solution explorer.  I am now
looking at the .Net.  How do I go about getting the .Net assembly in the
'game'.  What I have tried is to go into the control panel on the PC and
go under admin, .Net framework and config, and tried to add.  I pointed
to the c:\ibm\unidk\uonet\bin\uodotnet.dll.  Of course Im just winging
it here.  It seemed that this made sense.  However, it does not appear
in the solutions explorer when I try yo add a .Net reference.  So, I
tried but no cigar.  What is the right way to do this ?
Anthony

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Jordan
Sent: Sunday, March 11, 2007 8:53 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe/UniObjects and Visual Studio


Hi Anthony

Whilst UniObjects works with .Net, it is a COM assembly and needs to be
loads as a Comm Component.  IBM does provide a .Net assembly for U2, and
it would be better to use that.

You can add the Com or .Net attributes through the Add references in the
Solution Explorer.

Regards

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

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.8/716 - Release Date: 3/9/2007
6:53 PM
 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.8/716 - Release Date: 3/9/2007
6:53 PM
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Are 'Progress' or 'RedBrick' databases multi-value? {Unclassified}

[Ken Hall]

Progress Open Edge is a full development environment that is not 
multi-valued. The database like the MV databases does not require 
variable typing and the data storage structures are controlled by the 
applications that write to the database. Open Edge includes GUI tools 
for application and database design and development.


It is NOT a part of the multi-value world.

Ken

At 04:33 PM 3/11/2007, you wrote:

Folks,

I have been asked to find out if either 'Progress' or 'RedBrick'
databases are multi-value.  Their web-sites don't say anything either
way so far as a quick look told me, but we all know that many products
are shy about any association with 'Pick'.

So, any information would be helpful.


Thanks in advance

Mike

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

Re: [U2] Old Dog, New Tricks

[MAJ Programming]

Interesting concept, putting the delimiter in the <1> position then deleting
it. Makes the IF within the LOOP not needed.
- Original Message -
From: "Anthony W. Youngman" <[EMAIL PROTECTED]>
To: 
Sent: Sunday, March 11, 2007 5:12 PM
Subject: Re: [U2] Old Dog, New Tricks


> In message <[EMAIL PROTECTED]>, Allen E.
> Elwood <[EMAIL PROTECTED]> writes
> >You can always test,
> >
> >IF TEMP = '' THEN TEMP = "NULL"
> >
> >and likewise on the end that processes after the ARRAY is completed.
> >
> >1~2~NULL~4~5~NULL~...
> >
> >on the receiving end would be
> >
> >IF ARRAY = "NULL" THEN ARRAY = ""
>
> If you're going to do that, use (I think) EREPLACE. I think it's that
> function, but there's certainly one to remove all occurrences of a
> particular text. The danger is that the letters NULL will be part of a
> value which then gets corrupted...
>
> I always did
>
> ARRAY := @FM : WHATEVER
>
> and then at the end did
>
> DEL ARRAY<1>
>
> 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 -  Open Source
Pick
> ---
> 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] Universe/UniObjects and Visual Studio

[Jeff Powell]

Anthony,

Here is a class I created for VB6 to retrieve line item information for
a given order. I don't know about using any toolbox items but I do add
the resources to the project then create the object.

This class is actually used at my company to create a label that is
affixed to a product. 

I hope you find some useful information here.

Jeff

On Sun, 2007-03-11 at 19:07 -0400, Anthony Dzikiewicz wrote:

> Hi guys,
> 
> I am messing with Visual Basic Express edition.  I was hoping to use
> UniObjects against my Universe Database.  The examples in the UniObjects
> Developers Guide are a little outdated.  How do I get the UniObjects to
> appear in the toolbar (if you can do this) ? They refer to Sub
> Form_Load, which I have seen in older versions of VB, but not VB 2005.
> Basically what I am looking for is a 'quick fix' for the 5 minute
> program example in the Developers Guide that has already taken me beyond
> that time frame.
> 
> Thanks
> Anthony
> 

VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
  Persistable = 0  'NotPersistable
  DataBindingBehavior = 0  'vbNone
  DataSourceBehavior  = 0  'vbNone
  MTSTransactionMode  = 0  'NotAnMTSObject
END
Attribute VB_Name = "ud-access"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False

Dim Uni As Object
Dim selList As UniSelectList
Dim dynArray As UniDynArray


Dim dynRec As Object

Dim ordFile As UniFile
Dim ordLineFile As UniFile
Dim relLineFile As UniFile
Dim custFile As UniFile
Dim catFile As UniFile
Dim prodFile As UniFile

Dim rs() As CLabelRecord


Public Sub GetRecords(stRefNum, Text1 As TextBox)

'On Error GoTo ErrorHandler
Set Uni = CreateObject(UV_SESSION_OBJECT)

Uni.AccountPath = "/ud/YOUR-LIVE-ACCOUNT"
Uni.HostName = "ud-server"
Uni.UserName = "user"
Uni.Password = "password"
' UniSession.DataBaseType = 2
iRecCount = 0
iReleaseMode = 0
' new flogic for scanner
' TUA7$PT$F$1/2
iStringEnd = InStr(1, stRefNum, "$")
If iStringEnd > 0 Then
stRefNum = Mid(stRefNum, 1, iStringEnd - 1)
Text1.Text = stRefNum
Text1.Refresh
End If
If Uni.Connect = True Then
'If Staging.Value = 1 Then
If InStr(1, stRefNum, "-") = 0 Then
strSql = "SELECT ORDER.LINE WITH ORD.NUM=""" &
UCase(stRefNum) & """  BY ZONE.IPS BY SEQ.NUM TO 1"
Else
strSql = "SELECT RELEASE.LINE WITH RELEASE.NUM=""" &
UCase(stRefNum) & """  BY ZONE.IPS BY SEQ.NUM TO 1"
iReleaseMode = 1
End If
If Uni.IsActive Then
Set ordFile = Uni.OpenFile("ORDER")
If ordFile Is Nothing Then MsgBox "ORDER not open"

Set ordLineFile = Uni.OpenFile("ORDER.LINE")
If ordLineFile Is Nothing Then MsgBox "ORDER.LINE not open"

Set relLineFile = Uni.OpenFile("RELEASE.LINE")
If relLineFile Is Nothing Then MsgBox "RELEASE.LINE not
open"

Set custFile = Uni.OpenFile("CUSTOMER")
If custFile Is Nothing Then MsgBox "CUSTOMER not open"

Set catFile = Uni.OpenFile("CATEGORY")
If catFile Is Nothing Then MsgBox "CATEGORY not open"

Set prodFile = Uni.OpenFile("PRODUCT")
If prodFile Is Nothing Then MsgBox "PRODUCT not open"

'DoMsg "Looking up " + UCase(Text1.Text)
Uni.Command.Text = strSql
Uni.Command.Exec
' Build the recordset from records received
Set selList = Uni.SelectList(1)
Set dynArray = selList.ReadList ' List of records
ReDim rs(dynArray.Count)

For iLineItemLoop = 1 To dynArray.Count
Set rs(iLineItemLoop) = New CLabelRecord
LineKey = dynArray.Value(iLineItemLoop, 0)
OrderKey = Mid(LineKey, 1, 11)
OrderNum = Mid(LineKey, 4, 8)

If iReleaseMode = 1 Then
relLineFile.RecordId = LineKey
relLineFile.Read
LineKey = relLineFile.Record.Value(2, 0)
End If

ordLineFile.RecordId = LineKey
ordLineFile.Read

ordFile.RecordId = OrderKey
ordFile.Read

' Get information from the Order Header
rs(iLineItemLoop).CustPoNum = ordFile.Record.Value(12,
0)   ' Customer PO Number
rs(iLineItemLoop).JobNum = ordFile.Record.Value(133, 0)
' Customer Job Number


rs(iLineItemLoop).OrderNum = OrderNum
rs(iLineItemLoop).RelNum = stRefNum
rs(iLineItemLoop).CustLnNum =
ordLineFile.Record.Value(92, 0)
rs(iLineItemLoop).CustProdNum =
ordLineFile.Record.Value(153, 0)
rs(iLineItemLoop).PckQty = ordLineFile.Record.Value(38,
0)
rs(iLineItemLoop).UnMeas = ordLineFile.Record.Value(103,
0)
rs(

RE: [U2] Universe/UniObjects and Visual Studio

[David Jordan]

Hi Anthony

Whilst UniObjects works with .Net, it is a COM assembly and needs to be
loads as a Comm Component.  IBM does provide a .Net assembly for U2, and it
would be better to use that.

You can add the Com or .Net attributes through the Add references in the
Solution Explorer.

Regards

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

[U2] Are 'Progress' or 'RedBrick' databases multi-value? {Unclassified}

[HENDERSON MIKE, MR]

Folks,

I have been asked to find out if either 'Progress' or 'RedBrick'
databases are multi-value.  Their web-sites don't say anything either
way so far as a quick look told me, but we all know that many products
are shy about any association with 'Pick'.

So, any information would be helpful.


Thanks in advance

Mike
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] Universe/UniObjects and Visual Studio

[Anthony Dzikiewicz]

Hi guys,

I am messing with Visual Basic Express edition.  I was hoping to use
UniObjects against my Universe Database.  The examples in the UniObjects
Developers Guide are a little outdated.  How do I get the UniObjects to
appear in the toolbar (if you can do this) ? They refer to Sub
Form_Load, which I have seen in older versions of VB, but not VB 2005.
Basically what I am looking for is a 'quick fix' for the 5 minute
program example in the Developers Guide that has already taken me beyond
that time frame.

Thanks
Anthony

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.8/716 - Release Date: 3/9/2007
6:53 PM
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Old Dog, New Tricks

[Anthony W. Youngman]

In message <[EMAIL PROTECTED]>, Allen E. 
Elwood <[EMAIL PROTECTED]> writes

You can always test,

IF TEMP = '' THEN TEMP = "NULL"

and likewise on the end that processes after the ARRAY is completed.

1~2~NULL~4~5~NULL~...

on the receiving end would be

IF ARRAY = "NULL" THEN ARRAY = ""


If you're going to do that, use (I think) EREPLACE. I think it's that 
function, but there's certainly one to remove all occurrences of a 
particular text. The danger is that the letters NULL will be part of a 
value which then gets corrupted...


I always did

ARRAY := @FM : WHATEVER

and then at the end did

DEL ARRAY<1>

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 -  Open Source Pick
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UD: Best way to convert GMT date/times to internal?

[Glen B]

 There's a couple of bugs in this code that I just found. Ick! Shame on me!
I've pasted the fixed code in-line.

Glen


> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Glen Batchelor
> Sent: Friday, February 23, 2007 12:49 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] UD: Best way to convert GMT date/times to internal?
>
>
>  I think this is posted a long time ago on the d3www/mvwww
> sourceforge site
> as well. Hack it up and mangle it all you want. This is to convert current
> time into GMT and pass the ISO zone difference as a standalone
> var. For your
> need, you'll have to reverse engineer it. This was written on D3, but it
> should be vanilla code.
>

  SUBROUTINE GMT(GMT,ISOZONEDIFF)
  !
  ! CONVERT CURRENT ZONE TIME TO GMT
  ! DAYLIGHT SAVINGS FOR NORTH AMERICA ONLY
  !
  ! ATL = 4 HOUR DIFFERENCE
  ! EST = 5 HOUR DIFFERENCE
  ! EDT = 4 HOUR DIFFERENCE
  ! CST = 6 HOUR DIFFERENCE
  ! CDT = 5 HOUR DIFFERENCE
  ! MST = 7 HOUR DIFFERENCE
  ! MDT = 6 HOUR DIFFERENCE
  ! PST = 8 HOUR DIFFERENCE
  ! PDT = 7 HOUR DIFFERENCE
  ! ALA = 9 HOUR DIFFERENCE
  ! HAW = 10 HOUR DIFFERENCE
  !
  SDAY = ''
  EDAY = ''
  ATL = "-04:00"
  ATLDIFF=4
  EST = "-05:00"
  ESTDIFF=5
  EDT = "-04:00"
  EDTDIFF=4
  CST = "-06:00"
  CSTDIFF=6
  CDT = "-05:00"
  CDTDIFF=5
  MST = "-07:00"
  MSTDIFF=7
  MDT = "-06:00"
  MDTDIFF=6
  PST = "-08:00"
  PSTDIFF=8
  PDT = "-07:00"
  PDTDIFF=7
  ALA = "-09:00"
  ALADIFF=9
  HAW = "-10:00"
  HAWDIFF=10
  !
  ! CHANGE THE FOLLOWING TWO NUMBERS TO REFERENCE YOUR HOURLY DIFFERENCE
  !
  ! DAYLIGHTSAVINGS (DST) VARIABLES CAN BE SET TO NULL, IF YOU SET THE
  ! DAYLIGHTSAVINGS FLAG TO ZERO. THIS SHOULD ONLY BE DONE FOR ZONES
  ! THAT DO NOT UTILIZE DST.
  !
  DAYLIGHTSAVINGS=1
  MYZONE=EST
  MYDSTZONE=EDT
  MYDIFF=ESTDIFF
  MYDSTDIFF=EDTDIFF
  !
  LOCALTIME = TIME()
  GMT=''
  YR=OCONV(DATE(),'DY')
  ! FIGURE OUT THE EXACT START AND END DATES FOR DAYLIGHT SAVINGS TIME
  ! FOR THIS YEAR
  !
  !#NORTH AMERICAN DST STARTS ON THE FIRST SUNDAY OF APRIL AND ENDS ON
  !#THE LAST SUNDAY OF OCTOBER.
  !
  !NORTH AMERICAN DST CHANGED TO SECOND SUNDAY IN MARCH -> FIRST SUNDAY
IN NOVEMBER
  ! AS OF 02/2007
  !
  IF DAYLIGHTSAVINGS=1 THEN
 TDT="03/01/":YR
 ITDT=ICONV(TDT,'D4/')
 TDTE="11/01/":YR
 IDTE=ICONV(TDTE,'D4/')
 SUNDAYS = 0
 FOR X = 1 TO 31
DOW=OCONV(ITDT,'DW')
MON=OCONV(ITDT,'DMA')
IF MON # "March" THEN GO 100
IF DOW = 7 THEN
   SUNDAYS = SUNDAYS + 1
END
IF SUNDAYS = 2 THEN
   SDAY = X
   GO 100
END
ITDT=ITDT+1
 NEXT X
 IF MON # "November" THEN GO 200
100
 FOR X = 1 TO 31
DOW=OCONV(IDTE,'DW')
MON=OCONV(IDTE,'DMA')
IF DOW = 7 THEN
   EDAY = X
   GO 200
END
IDTE=IDTE+1
 NEXT X
200
 EDTSTART = "03/":SDAY:"/":YR
 EDTSTART = ICONV(EDTSTART,'D4/')
 EDTEND = "11/":EDAY:"/":YR
 EDTEND = ICONV(EDTEND,'D4/')
 IF DATE() >= EDTSTART AND DATE() <= EDTEND THEN
LOCALTIME=TIME()
GMT=LOCALTIME+(60*60*MYDSTDIFF)
ISOZONEDIFF=MYDSTZONE
 END ELSE
LOCALTIME=TIME()
ISOZONEDIFF = MYZONE
GMT=LOCALTIME+(60*60*MYDIFF)
 END
  END
  !
  ! NO DAYLIGHT SAVINGS
  !
  IF DAYLIGHTSAVINGS = 0 THEN
 LOCALTIME=TIME()
 GMT=LOCALTIME+(60*60*MYDIFF)
 ISOZONEDIFF=MYZONE
  END
  RETURN


> ---
> Glen Batchelor
> IT Director
> All-Spec Industries
> phone: (910) 332-0424
> fax: (910) 763-5664
> e-mail: [EMAIL PROTECTED]
> ---
> www.allspec.com
> ---
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:owner-u2-
> > [EMAIL PROTECTED] On Behalf Of Raymond DeGennaro II
> > Sent: Friday, February 23, 2007 10:49 AM
> > To: u2-users@listserver.u2ug.org
> > Subject: Re: [U2] UD: Best way to convert GMT date/times to internal?
> >
> > >It seems to me that you've left out a great deal of what you are
> > >trying to get.
> >
> > Sorry, I'm looking to convert a GMT date/time group that is DST-less
> > and in Zulu-time to the local date/time (several timezones east and
> > potentially shifted another hour by DST).  The data is coming from a
> > service provider and we have no control over the format.  The data is
> > sent as ISO8601 DTG's like:  -MM-DDThh:mm:ss-00:00 (The time zone
> > offset is always 00:00) and a minimal char

Re: [U2] OT Employment: Will work for food or manye

[Dave R]

www.dice.com search on unidata or unibasic

http://seeker.dice.com/jobsearch/servlet/JobSearch?op=300&LOCATION_OPTION=2&A
REA_CODES=&ZIPCODE=&RADIUS=64.37376&COUNTRY=1525&METRO_AREA=33.78715899%2C-84
.39164034&TRAVEL=0&SORTSPEC=0&FRMT=0&DAYSBACK=30&NUM_PER_PAGE=30&N=1525+0&FRE
E_TEXT=unidata&Ntx=mode+matchall&x=38&y=1

Dave R

e Fax (815)4259364
P.O. Box 17811, Irvine CA 92623-7811

-- Charles Barouch <[EMAIL PROTECTED]> wrote:
Will,
 U2UG.org and/or the u2-user list. The more people who know what you
do, the better chance of getting a place to do it. I'd also mention that
some recruiters are on the lists, Software Search and 3D Tek come to
mind, and they are both good companies to deal with... so put it out there.

- Chuck

will wrote:
> THANKS! Both for your caring attitude and the ideas.
>
> I have my resume posted on some boards but didn't know there was one
> for MV... or do you mean on the U2 list?
>
> Kind regards,
>
> Will
>
>
>
> Charles Barouch wrote:
>> Will,
>> Willing to post your resume? If you want people to help, it might
>> help if they knew some of the details that make you worth promoting.
>> Also, as I just said in the Selling MV class I did at Spectrum:
>> "Sometimes you need to come in the door as the MS Office Trainer, the
>> Network Guru, etc." You may need to get in the door with secondary
>> skills and help a new shop convert to MV once they have faith in your
>> opinions.
>>
>>- Chuck
>>
>> will wrote:
>>> Looks like I am losing my last major contract and nothing new is
>>> developing in the MV world locally or telecommute.  If you have any
>>> leads you could help keep another disenfranchised MV professional
>>> off the streets... :-)
>>>
>>> Take care,
>>>
>>> Will
>>> ---
>>> 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/
>


--

Charles Barouch ([EMAIL PROTECTED])
www.KeyAlly.com (718) 762-3884 x 1
P. O. Box 540957, Queens, NY 11354
---
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/