RE: [U2] UD to SMS

2005-07-27 Thread Robert Paterson
We did something similar a few years back and was managed by using URL manipulation - pretty much as you seem to be doing using CallHTTP. Unfortunately the company we were working with is no more and I can't pass on our code - but it was pretty straightforward - biggest challenge was finding

RE: [U2] UVODBC procedure call from VBScript

2005-07-27 Thread Dave Tabor
Hi, Mr. Jordan. I've been considering using ODBC instead of UniObjects for our web project, too, but am unfamiliar with . Could you please include a small, very generic, code snippet to show what you mean here. It would be much appreciated! Thanks, Dave -Original Message- From:

RE: [U2] Connecting SQL server from Universe

2005-07-27 Thread Metherall, Arthur
We're using Easysoft ODBC-ODBC-Bridge, on our AIX using UniData connecting to MSSQL 2K, for database inquiries. I don't see why it wouldn't work for uniVerse also, you would just need write UVBASIC code to use GCI/BCI? to interface with the ODBC driver. The code is pretty simple, with BCI

[U2] Win2003 Serial Printers

2005-07-27 Thread Brian Leach
All, One of my UniVerse clients is changing over from UNIX to Windows. They currently have a number of serial printers attached to their UNIX box using Xylogic Annex terminal servers. Since these are as old as the hills and not supported on Win2003, can anyone recommend a suitable replacement?

RE: [U2] UVODBC procedure call from VBScript

2005-07-27 Thread u2ug
I don't have a problem retreiving record sets. Actually calling the procedure is what I'm having a problem with. The procedure calls fail with an error of not a valid SQL command when I use a statement like sql = {CALL LIST VOC} or in my case I'd like it to be a subroutine but this is something

RE: [U2] UVODBC procedure call from VBScript

2005-07-27 Thread Brian Leach
Dave: AFAIR this is documented in the less-than-obvious location of the UCI Guide. Here is a quick example using local UniVerse SQL in a subroutine as a stored procedure. I've used this with OleDB though not with ODBC, using the SQL CALL statement. NOTE that if you are using ODBC, I've found

RE: [U2] Win2003 Serial Printers

2005-07-27 Thread George Gallen
yes. Whatabout hooking up a USB hub, then hook each printer to a USB - Serial adapter. If there a number of printers, then put in a PCI/USB card just for the printers, so it won't slow down any other USB traffic. George This should be a fairly inexpensive option. The Hub should be about $40-$50

Re: [U2] Win2003 Serial Printers

2005-07-27 Thread u2
[EMAIL PROTECTED] wrote: All, One of my UniVerse clients is changing over from UNIX to Windows. They currently have a number of serial printers attached to their UNIX box using Xylogic Annex terminal servers. Since these are as old as the hills and not supported on Win2003, can anyone

RE: [U2] Win2003 Serial Printers

2005-07-27 Thread Brutzman, Bill
0. Consider new printers altogether. 1. Consider contacting the original printer manufacturer. The printers probably have (EPT ?) parallel ports. 2. Together with an HP JetDirect print server, Digi has perhaps the most robust serial-to-ethernet converters for ~$200 each. 3. Printronix (free)

RE: [U2] UVODBC procedure call from VBScript

2005-07-27 Thread u2ug
Brian, This is exactly what I wantto do. However the VBScript syntax is where I'm getting stuck. How do I set the arguments... I know with uvobj sub calls you need to set the parameter values for the routine. I'm assuming the same is true here. But this is what I have : dim cnn

[U2] UV 10.1.3 and Windows 2003 service pack 1

2005-07-27 Thread Anthony Caufield
Has anybody installed service pack 1 for server 2003 on a box running 10.1.3 and if so did you have any issues. Thanks Tony Caufield IS Manager Harbor Wholesale Grocery Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UV] Select Question

2005-07-27 Thread FFT2001
In a message dated 7/25/2005 11:38:53 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: The distinction with using an EOF variable is that it is not referenced, until the next READNEXT. Each new variable that is read into memory will push the EOF variable further to the back. This

Re: [U2] Win2003 Serial Printers

2005-07-27 Thread Ken Hall
Brian - We have very successfully used Equinox ESP-8 port terminal devices to connect our serial printers over a WAN and LAN. These are inexpensive and easy to administer devices (admin through a web interface). I highly recommend them for connecting all serial devices to U2 systems. Ken

Re: [U2] Win2003 Serial Printers

2005-07-27 Thread Dave Taylor
Brian, Several of our customers have used the D-Link serial/parallel print server with excellent success. Also, if you connect a printer to another PC on the network acting as a print server (rather than directly to a print server), you must install that printer on your Universe server using an

Re: [U2] [UV] Select Question

2005-07-27 Thread Charlie Rubeor
If you really want to debate the issue, contact either Ian Sandler or Harvey Rodstein. The syntax came from one of their books. Personally, I'm looking into the future and seeing a THREAD CLOSED message from the moderator. Charlie Rubeor Unix/Database Admin The Wiremold Company 800.338.1315

RE: [U2] UVODBC procedure call from VBScript

2005-07-27 Thread Brian Leach
Ok, Try the following. This works for me, all other routes seem to fall over :-( - Use a ? to substitute for each subroutine argument - Create an ADODB parameter for each argument - Set the value of the ADODB parameter - Append that parameter to the command Parameters collection NOTE: Using the

RE: [U2] Win2003 Serial Printers

2005-07-27 Thread Brian Leach
Thanks for all the responses, I'll pass these on to the client. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: 27 July 2005 14:21 To: u2-users@listserver.u2ug.org Subject: [U2] Win2003 Serial Printers All, One of

Re: [U2] UVODBC procedure call from VBScript

2005-07-27 Thread Brian Grayson
Hi, I don't see that you're passing any arguments. Assuming that you are in fact connecting, try: SQL = CALL MYSUB ('ARG1','ARG2'); IMHO, the UV docs really should contain an example for every definition. Brian Grayson [EMAIL PROTECTED] wrote: Brian, This is exactly what I wantto do.

[Fwd: Re: [U2] [UV] Select Question]

2005-07-27 Thread Moderator
Original Message Subject:Re: [U2] [UV] Select Question Date: Mon, 25 Jul 2005 21:23:44 -0400 From: Moderator [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org THREAD CLOSED. --- u2-users mailing list

[U2] Unidata Data Replication - RECONFIG command

2005-07-27 Thread Shaun.Ferguson
Hello all! Unidata 6.1.10 on Unix - I am doing a preliminary investigation of Data Replication and will be setting up a test environment. The guide says that I can install it manually (creating files, updating a table, setting the REP_FLAG in udtconfig), but, it also says that the system is

Re: [U2] Unidata Data Replication - RECONFIG command

2005-07-27 Thread Wally Terhune
the doc can be a little confusing on this. I would call 'reconfig' an argument of the 'ud_repadmin' command. syntax: ud_repadmin reconfig The administration interface for Replication from UniAdmin client is excellent, also. Note: ud_repadmin was originally named 'repadmin' - but there appeared

RE: [U2] UVODBC procedure call from VBScript

2005-07-27 Thread David Jordan
Hi, Mr. Jordan. I've been considering using ODBC instead of UniObjects for our web project, too, but am unfamiliar with . Could you please include a small, very generic, code snippet to show what you mean here. It would be much appreciated! Thanks, Dave Hi Dave Brian has provided examples,

[U2] Open Excel and Import a file or execute a command from a local PC

2005-07-27 Thread Ralph Burton
Are there any utilities to pass as comma delimited file from Unidata/Universe and have it open/imported into Excel? Any way to execute a command from a local PC workstation? Thanks, Ralph - Start your day with Yahoo! - make it your home

[U2] Index and Print servers

2005-07-27 Thread David Tod Sigafoos
A friend asked me recently about the need or Print and Index servers on Unidata. As I don't work with Unidata that much, or at least not to the infrastructure level, I thought I would pass this on to the knowledge trust here. They are running 'current' unidata on Sun OS box. They have around

Re: [U2] Open Excel and Import a file or execute a command from a localPC

2005-07-27 Thread Lee Beel
Ralph, I am not familiar with a utility that will send a file to windows, but, Accuterm will do this for you. Lee [EMAIL PROTECTED] 07/27/05 04:06PM Are there any utilities to pass as comma delimited file from Unidata/Universe and have it open/imported into Excel? Any way to execute a

Re: [U2] Open Excel and Import a file or execute a command from a local PC

2005-07-27 Thread Bruce Nichol
Goo'day, At 16:06 27/07/05 -0700, you wrote: Are there any utilities to pass as comma delimited file from Unidata/Universe and have it open/imported into Excel? If you're using the normal terminal emulators, eg AccuTerm, wIntegrate and whatever HostAccess is called these days, there are the

RE: [U2] Open Excel and Import a file or execute a command from a local PC

2005-07-27 Thread David Scoggins
Ralph, You may be looking for something a little more elegant, but if you generate a comma delimited file and give it a .csv suffix, Excel will just open it. From there you can save as any of the various file types that Excel supports. As for executing a command - I presume you mean *on* the

RE: [U2] Open Excel and Import a file or execute a command from a local PC

2005-07-27 Thread Allen E. Elwood
In Unidata you can do it with the LIST command using the TO and DELIM clause hth, Allen LIST Syntax LIST [DICT] filename [record_IDs] [selection_criteria] [sorting_criteria] [attributes | ALL] [format_options] [report_options] [TO [DELIM char]text_file [ELEMENTS] [WITHDTD] [XMLMAPPING

RE: [U2] Index and Print servers

2005-07-27 Thread Ken Wallis
David Tod Sigafoos wrote: A friend asked me recently about the need or Print and Index servers on Unidata. As I don't work with Unidata that much, or at least not to the infrastructure level, I thought I would pass this on to the knowledge trust here. They are running 'current' unidata on

Re[2]: [U2] Index and Print servers

2005-07-27 Thread David Tod Sigafoos
Ken, thanks for the info .. your 'little idea what you mean by .. ' tells me a lot. I believe it is 6.x but they are looking to make sure. My friend just got there and found a company with no 'support' for these system, no knowledge of what is or was there. So she is digging through everything

[U2] Where's the FAQ for UV/PE on Linux

2005-07-27 Thread Ross Ferris
I downloaded the 163Mb tar I extracted I can see a stack of what appear to be executables Figured STARTUP would be a good place to start (as DOCS did nothing) Maybe something I'm missing ? On RH9 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit

[U2] UV PE/Linux FAQ

2005-07-27 Thread Ross Ferris
I downloaded the 163Mb TAR ball I extracted see what appear to be executables DOC doesn't work, but STARTUP sort of does (well, actually it fails to - but at least it did SOMETHING that looked like an install program running) Does UV work over RH9 ? If someone can point me to some kind of

RE: [U2] Where's the FAQ for UV/PE on Linux

2005-07-27 Thread Perry Taylor
You need the installation guide. http://www-306.ibm.com/software/data/u2/pubs/library/100univ/univ_101.html -Original Message- From: Ross Ferris [mailto:[EMAIL PROTECTED] Sent: Thu Jul 28 00:03:47 2005 To: u2-users@listserver.u2ug.org Subject:[U2] Where's the FAQ for

[U2] Text extraction.

2005-07-27 Thread Mark Johnson
Is there any downside to having a very large number that exceeds the actual length of a string to indicate the balance of the string in the [] function. I see: NEW=ABC:REC[15,LEN(REC)-15] versus NEW=ABC:REC[15,100] Just curious. Thanks. --- u2-users mailing list

RE: [U2] Where's the FAQ for UV/PE on Linux

2005-07-27 Thread Ross Ferris
Thanks Perry ! I Know, I Know - RTFM Wha I hadn't twigged to was the fact that I needed to set my 'tape names' to the directory where I'd unloaded everything Thanks once more -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor Sent:

RE: [U2] Text extraction.

2005-07-27 Thread Ken Wallis
Mark Johnson wrote: Is there any downside to having a very large number that exceeds the actual length of a string to indicate the balance of the string in the [] function. I see: NEW=ABC:REC[15,LEN(REC)-15] versus NEW=ABC:REC[15,100] Not that I know of, but anybody who's had to fix

RE: [U2] UD to SMS

2005-07-27 Thread Bruce Lunt
Thanks! This is a great start. I will have to spend some time with this whole thing before I know what we'll do but the cdp thread help a lot. Thanks again. From: Tony Gravagno [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD to