headers
Robert Colquhoun | 1 Jul 2009 08:45
Picon

Re: [U2] UV UOJ hung sessions

On Tue, Jun 30, 2009 at 7:15 AM, Baakkonen, Rodney A (Rod)
46K<Rodney.Baakkonen <at> cigna.com> wrote:
>  Do you have truss or a trace command at UNIX that can track what the
> PID is doing.

I think on redhat/linux strace is the equivalent routine.  Also lsof
might be useful.

- Robert
_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Permalink | Reply | 0 comments |
headers
Debra Fedchin | 1 Jul 2009 17:36

Re: [U2] How do you do EDI?

Whoa!  Can't believe I made THAT error!

"Mark Eastwood" <marke <at> afsi.com> 
Sent by: u2-users-bounces <at> listserver.u2ug.org
06/20/2009 02:44 PM
Please respond to
U2 Users List <u2-users <at> listserver.u2ug.org>

To
"U2 Users List" <u2-users <at> listserver.u2ug.org>
cc

Subject
Re: [U2] How do you do EDI?

BTW, I think the web site is www.softshare.com (not softsearch).

-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org
[mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Debster
Sent: Saturday, June 20, 2009 8:33 AM
To: U2 Users List
Subject: Re: [U2] How do you do EDI?

BTW.....at www.Softsearch.com they have a free download of their EDI
Notepad
that is a great little desktop tool for anyone doing EDI.  It enables
you to
view any EDI and will alert you to any structural errors, including
improper
(Continue reading)

Permalink | Reply | 0 comments |
headers
iggchamp | 1 Jul 2009 19:31
Picon

[U2] Updating AS400 Data from Universe


Hi all, 

Anyone out there have any experience updating data on an AS400 directly from a Universe basic
program running on unix.  If so, I'd sure like to hear what steps were involved. 

Thanks much, 

Scott 
_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Permalink | Reply | 1 comment |
headers
Tony G | 1 Jul 2009 22:04
Picon
Favicon

Re: [U2] Updating AS400 Data from Universe

> Anyone out there have any experience updating data on an 
> AS400 directly from a Universe basic program running on unix. 
> If so, I'd sure like to hear what steps were involved. 
> Thanks much, 
> Scott 

Greetings, my friend:  I personally don't think it's a good idea
in any X/Y data transfer for X to be aware of the details of Y.
It restricts the Y people from making changes and forces the X
people to be aware of such details.  I prefer to use familiar
interfaces to transfer data to a middle-tier proxy which then
brokers transmission and protocol-specific details.

In other words, use web services or other standards that don't
require a new research effort for every project.  Don't hardcode
into every platform Y that you encounter.  Transaction turnaround
time can be slower but long-term maintenance is vastly
simplified.  If you absolutely need the fastest transactions
possible then you'll need to get closer to the metal.

I happen to know that you already have the tools onsite to do
exactly what you want functionally, just not in exactly the way
you suggest.  Let's see what our colleagues here have to say and
I'll be happy to talk with you about options.

HTH
T
Tony Gravagno
Nebula Research and Development
TG <at>  remove.pleaseNebula-RnD.com
(Continue reading)

Permalink | Reply | 0 comments |
headers
iggchamp | 2 Jul 2009 00:17
Picon

Re: [U2] Updating AS400 Data from Universe


Hi Tony, 

I agree with you totally.  Web services are the way to go.  The web service that you've developed for us
using VS and MV.NET absolutely screams!!!   We blew the service that my as400 counterparts
developed out of the water.  Thanks a ton for helping us look so good to the corporate folks.  I'm
really impressed with mv.net!!! 

I don't really have any control over what happens on the as400 side and I know their resources are limited at
this point.  I was hoping for a way of connecting to the 400 and issuing sql commands directly from
universe.  Any thoughts on that?  The only other thing I can think of is to ftp flat files to them and let
them take care of loading the data.  The sql idea would save people alot of work. 

Thanks, 

Scott 

----- Original Message ----- 
From: "Tony G" <1tlx6hz02 <at> sneakemail.com> 
To: u2-users <at> listserver.u2ug.org 
Sent: Wednesday, July 1, 2009 3:04:09 PM GMT -06:00 US/Canada Central 
Subject: Re: [U2] Updating AS400 Data from Universe 

> Anyone out there have any experience updating data on an 
> AS400 directly from a Universe basic program running on unix.  
> If so, I'd sure like to hear what steps were involved. 
> Thanks much, 
> Scott 

Greetings, my friend:  I personally don't think it's a good idea
(Continue reading)

Permalink | Reply | 4 comments |
headers
Tony G | 2 Jul 2009 01:14
Picon
Favicon

Re: [U2] Updating AS400 Data from Universe

(I swear folks, I don't pay for testomonials from happy clients.
LOL)

Scott - your check is in the mail.

Err, I mean... the following information may be overkill for this
specific situation but some of the info may help others who need
to exchange data bi-directionally between MV and non-MV
environments.

The easiest answer to your question is not to go direct from
Universe per-se, but to create an OS-level macro that does what
you want, and then call that from Universe.  So if you can write
a Windows BAT file or a Unix shell script that does what you
want, you're golden - jus pass that routine some dynamic input.

Sometimes you can't go direct.  To use your existing tools, AS400
has a .NET interface just like your Universe system via mv.NET.
We've written interfaces from MV to SQL Server, MySQL, and Oracle
using the principle described:
  MV <> MiddleTier <> Other

That MiddleTier has variations but it essentially does this:
1) Accept inbound transaction from source.
2) Reformat data to suit application-specific requirements.
3) Pass data to target.

Step 2 might be as simple as this:
  Server target = new Server(TargetID);
  target.Update(InboundData);
(Continue reading)

Permalink | Reply | 0 comments |
headers
Craig Bennett | 2 Jul 2009 01:42

Re: [U2] Updating AS400 Data from Universe

Hi Scott,

have you considered an ODBC link and using BCI (the UV calling interface 
to ODBC)?

A quick google suggests that ODBC interfaces are available for AS400.

regards,

Craig
_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Permalink | Reply | 2 comments |
headers
iggchamp | 2 Jul 2009 03:03
Picon

Re: [U2] Updating AS400 Data from Universe


Thanks much Craig,  I'll give that a look. 

----- Original Message ----- 
From: "Craig Bennett" <craig <at> amajuba.com> 
To: "U2 Users List" <u2-users <at> listserver.u2ug.org> 
Sent: Wednesday, July 1, 2009 6:42:46 PM GMT -06:00 US/Canada Central 
Subject: Re: [U2] Updating AS400 Data from Universe 

Hi Scott, 

have you considered an ODBC link and using BCI (the UV calling interface 
to ODBC)? 

A quick google suggests that ODBC interfaces are available for AS400. 

regards, 

Craig 
_______________________________________________ 
U2-Users mailing list 
U2-Users <at> listserver.u2ug.org 
http://listserver.u2ug.org/mailman/listinfo/u2-users 
_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Permalink | Reply | 1 comment |
headers
Dan McGrath | 2 Jul 2009 03:31
Picon

[U2] DIR-type files

I'm sure others have come across this before, but with directory type
files, you can specify relative paths as part of the record name to
access files stored elsewhere:

For example, say you have an account in /account
There is a VOC entry for:
<1> DIR
<2> BP
...
At ECL, if you type ED BP ../../etc/host
You get the /etc/host file in ED!

Obviously, that example required access to ECL and was quite contrived,
but it does not take much imagination to think of scenarios where not
being able to guarantee the file/directory data is being read
from/writing to can cause security headaches.

I didn't find anything when I searched the manuals about a Unidata
setting and we cannot deal with all the scenarios we have
programmatically in Unibasic... Aside from usual UNIX permissions, etc,
how have people dealt with this?

Kind Regards,
Dan M
###########################################################################################
The information transmitted in this message and attachments (if any) is intended only
for the person or entity to which it is addressed. The message may contain confidential
and/or privileged material.  Any review, retransmission, dissemination or other use of
or taking of any action in reliance upon this information by persons or entities other
than the intended recipient is prohibited.  If you received this in error, please
(Continue reading)

Permalink | Reply | 2 comments |
headers
Martin Phillips | 2 Jul 2009 10:03

Re: [U2] DIR-type files

Hi Dan,

> At ECL, if you type ED BP ../../etc/host
> You get the /etc/host file in ED!

This works in Unidata because it simply forms the operating system level 
name by merging the file name and record id.

UniVerse has name translation rules for restricted characters and your 
example would end up as
   ?..?\..?\etc?\host
and, if using type 1 files rather than type 19, would then get further 
transformation into a two level directory structure.

Both methods have their advantages and disadvantages.

Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200 

_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Permalink | Reply | 1 comment |

Gmane