[U2] IBM UniVerse Internals Course (UK)

2004-11-02 Thread John_Appleyard
shameless_plug I've registered for the UK UniVerse Internals Course which is due to commence on Monday, 15th November. http://www-5.ibm.com/services/learning/uk/ta-iris.nsf/(ExtCourseNr)/UV4 Apparently, I'm the ONLY person whose registered, and if that remains the case, the course won't run.

[U2] Jackie Burhans is out of the office.

2004-11-02 Thread Jackie Burhans
I will be out of the office starting 11/02/2004 and will not return until 11/03/2004. I am out of the office on vacation. I will have limited access to email or voicemail and will return your message when I return. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit

RE: [U2] Question about Triggers

2004-11-02 Thread Brian Leach
Jay, The following works for me: CREATE TRIGGER STUPID_TRIGGER BEFORE INSERT OR UPDATE OR DELETE ON STUPID-FILE FOR EACH ROW CALLING '*STUPID.TRIGGER'; Adding trigger STUPID_TRIGGER ED STUPID-FILE TEMP New record. : i 0001= HELLO 0002= Bottom at line 1. : fi Message from trigger

RE: [U2] Question about Triggers

2004-11-02 Thread Jay Falck
Thanks to everyone for their replies. If I had actually kept track of all the quote escaping I had tried I would have seen I missed the most obvious as it is working fine now. Guess I needed one more Diet Dr Pepper. :-) Jay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: [U2] [UD] UniObjects and Time zones

2004-11-02 Thread Burwell, Edward
Ken, Thanks for your reply. Here is what we ended up doing - We changed our environment TZ variable from EST5EDT1:00,M4.1.0/2:00:00,M10.4.0/2:00:00 to EST0EDT1:00,M4.1.0/2:00:00,M10.4.0/2:00:00(changed the offset from 5 to 0) And changed the hardware clock to the local time (EST). Now

[U2] Visual Basic .NET/UO.NET help needed

2004-11-02 Thread Jack Davis
I am running UniVerse 10.1 on a Windows 2000 server. I have a Visual Basic program written in VB 6 that has been working just fine for 4 years. It now needs some modification and would like to port it to VB .net. I have IBM's sample program working and can open files and list items. I am

Re: [U2][UV]telnet

2004-11-02 Thread Stu Glancy
Au contrair. Tom Firl was able to give me exactly what I needed. I was able to build a PAragraph with inputs that executed a sh -c script passing the inputs to allow login and execution of a shell script. I was after concept and Tom gave me concept. (See below.) I used echo to pass my

Re: [U2] Visual Basic .NET/UO.NET help needed

2004-11-02 Thread Ray Wurlod
You might like to check out http://galahtech.org/ (hunt down the MV forum and also check out the Micro$oft forums) and http://www.pickwiki.com/cgi-bin/wiki.pl --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/

[U2] telnet problem

2004-11-02 Thread George Smith
Hi all - need your help. I am trying to telnet to a windows 2003 machine that is running unidata 6.1 from the outside world. Having no success. Cox-internet -- static IP - cable modem - LinkSys BEFSR41 V3 router / hub - 3 machines One of the machines (windows 2003) has a static ip of

RE: [U2] telnet problem

2004-11-02 Thread Richard Taylor
Well, one thing I can see and that is the 192 address is internal only. The actual STATIC IP of your connection is the only thing the outside world sees. You will either need to setup the router to forward that port to the internal address you mentioned or enable VPN tunneling. I have a similar

RE: [U2] telnet problem

2004-11-02 Thread Derek Falkner
George, You have to tell your router to direct all calls to port 23 (telnet) to the internal IP address of your Windows 2003 server. Login to your router and select the ADVANCED tab. Next, select the FORWARDING tab and make an entry that looks like this ... Ext. Port TCP

RE: [U2] telnet problem

2004-11-02 Thread Alfke, Colin
The problem is that the address 192.168.1.201 is an internal address only. Your LinkSys router is the only thing on the outside that is able to see it. You need to set it up so that when you try connecting to it that it will pass through to your UniData box. Please realize that this is a fairly

RE: [U2] telnet problem

2004-11-02 Thread Bob Woodward
192.168.x.x is an internal network only class C IP group. Your LinkSys is the only visible device from outside unless you set it up to allow connections to your internal computer. That is way more than I'm going to go into in this message, though. Just remember, anything you open up to

RE: [U2] telnet problem

2004-11-02 Thread Maresh, Mel
I can quickly give you a few pointers. An IP of 192.168.1xxx means that the machine is connected to a router. You have to connect the static IP assigned by your internet service provider or, or if you have a dynamic IP, get a name from a company like TZO. Then your router will need to be

Re: [U2] telnet problem

2004-11-02 Thread Ron White
It is likely that this private IP address is behind a firewall/router and you will have to contact the administrator of this router to open the router to the IP address of your client machine. Ron White - Original Message - From: George Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

[U2] UPS EDI 240 Solution

2004-11-02 Thread Lee Messenger
Looking for options... Does anyone have an automated solution for processing high volumes of UPS EDI standards 240 (package delivery information) files? Currently we are pulling down weekly 210 invoice files from UPS for some of our clients, and I am looking at alternatives to retrieving the 240

RE: [U2][UD] merging data - fuzzy keys

2004-11-02 Thread Amy Cook
Wow...do you ever have overlap? A bill-to and ship-to with the same name, and in the same citybut different customer numbers in your production database? What if someone spelled something wrong or with a different abbreviation in your excel db than your production? If you had the key to your

RE: [U2] telnet problem

2004-11-02 Thread Logan, David (SST - Adelaide)
Please remember that this will open port 23 to everybody coming in from the outside. You should perhaps consider using ssh or similar secure access. If you are coming from a static IP perhaps you can restrict access to that IP only. Regards David Logan Database Administrator HP Managed Services

RE: [U2][UD] merging data - fuzzy keys

2004-11-02 Thread Alfke, Colin
You might want to look at www.parserat.com It's got some tools for extracting address that may help you get it organized Colin Alfke -Original Message- From: Amy Cook [mailto:[EMAIL PROTECTED] Wow...do you ever have overlap? A bill-to and ship-to with the same name, and in the

RE: [U2][UD] merging data - fuzzy keys

2004-11-02 Thread Bob Woodward
I worked at a place a long time ago and what we did there was to use the zipcode, first 5 chars of the last name, first letter of the first name, and the first numerics of the address line. This would result in things like: 98501woodwb1234 = Bob Woodward, 1234 Anystreet NW, Olympia, WA, 98501

Re: [U2] UPS EDI 240 Solution

2004-11-02 Thread Results
Lee, Have you considered offloading the EDI work to a third party who is set up for it and can give you the data already cleaned and multivalued. [AD] You might want to check with The Camry Group (212) 268-8675. x 105 [AD] - Chuck Offload Barouch Lee Messenger wrote: Looking for

Re: [U2][UD] merging data - fuzzy keys

2004-11-02 Thread Results
Steve, I hate to say it, but the best tool for this is a human being or three. I'd cut the lists by City and State, alphabetize by Name, and then hand it over to data entry people on a simple screen and let them match it up. Something like: Encino, CA Input list

RE: [U2][UD] merging data - fuzzy keys

2004-11-02 Thread Steve Kunzman
Amy, This data is downloaded from a company that provides fee/subscription based information about manufacturing companies. We are trying to build an industry based database for marketing to use. I am trying to programatically narrow down the list. The rest will have to be manually linked.

[U2] IBM U2 Techconnect problems

2004-11-02 Thread Andy Pflueger
Oops! Looks like IBM is having RBO problems with the server hosting the U2 Techconnect site at https://www-927.ibm.com/software/data/u2/support/login.asp. :) Error: 80004005 Can't connect to account 'unitrack' (9.29.46.33:8453) rc=-1 RedBack.RedPages.1 error '80004005' Property 'ContactID' not

[U2] Index problem

2004-11-02 Thread kafsat taiyus
We have one Unidata 5.1 data file with a virtual attribute. The virtual dictionary calls a Unibasic subroutine and returns a single value data from a multi value attribute from within the same file. We have an index on the virtual attribute. When new records are added to the file Unidata does

Re: [U2] Index problem

2004-11-02 Thread Results
Kafsat, Can you post the Dictionary Item and the BASIC code? - Charles Barouch [EMAIL PROTECTED] kafsat taiyus wrote: We have one Unidata 5.1 data file with a virtual attribute. The virtual dictionary calls a Unibasic subroutine and returns a single value data from a multi value attribute

RE: [U2] UPS EDI 240 Solution

2004-11-02 Thread Rosenberg Ben
If you're looking for a u2-based solution, go to http://www.parcelshippingsystem.com and scroll down to New PSS Options and click on Delivery Confirmation and see if that might be something like what you want. Software Co-Op's customers speak quite favorably about PSS and about the people at