Re: [U2][UV] UO.NET beginner question
Don Kibbey wrote: (this won't compile and is not meant to) Have a look in the UniObjects .Net pdf file for more info on this, but here's how you can change the port number used for the connection. public UniSession uSession; uSession.HostPort = 12345; uSession = UniObjects.OpenSession(Server, LoginName, PassWord, uvAccount, uvcs); Although (see http://article.gmane.org/gmane.comp.db.u2.general/30536 ) there's a chicken and egg problem here - this won't compile because you can't set the hostPort until you've instantiated your session. Simon --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] UO.NET beginner question
Here is the code I am trying to use: us1 = null ; us1.HostPort = 7200; try { us1 = UniObjects.OpenSession(Server,LoginName,Password,uvAccount,uvcs ); It is compiling just fine, I am getting an error when I run it though. Any suggestions? Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Monday, February 28, 2005 7:11 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] UO.NET beginner question (this won't compile and is not meant to) Have a look in the UniObjects .Net pdf file for more info on this, but here's how you can change the port number used for the connection. public UniSession uSession; uSession.HostPort = 12345; uSession = UniObjects.OpenSession(Server, LoginName, PassWord, uvAccount, uvcs); On Mon, 28 Feb 2005 16:35:35 -0500, Nick Cipollina [EMAIL PROTECTED] wrote: How exactly can I do this?. (I'm new to .NET). Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Monday, February 28, 2005 3:29 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] UO.NET beginner question Check the UniSession property HostPort. I believe that if you set it to match your host settings you should be OK. On Mon, 28 Feb 2005 14:46:52 -0500, Nick Cipollina [EMAIL PROTECTED] wrote: Our rpc port is set to 7200. Is there something I need to change within .NET to tell it to look for that port? Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Monday, February 28, 2005 2:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] UO.NET beginner question Make sure the remote machine has the uniobjects port enabled and there are no firewalls between you and it that also block this port. On an HP-UX machine this is port 31438. Have a look at the services file in /etc and make sure this line is in there somewhere. uvrpc 31438/tcp # uvNet rpc port On Mon, 28 Feb 2005 12:49:04 -0500, Nick Cipollina [EMAIL PROTECTED] wrote: Hello all, I've got a dumb UO.NET question to ask. I am trying to write a simple UO.NET program to connect to one of our UniVerse servers and I am getting the following error: No connection could be made because the target machine actively refused it. Any ideas what I am missing? Thanks. Nick Cipollina Pick Programmer ACS - Heritage Information Systems, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)644-8707 x 314 --- 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-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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2][UV] UO.NET beginner question
Are you on the same physical network as the target machine? Is there a firewall between you and it? What is the reasoning behind changing the rpc port to 7200? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] UO.NET beginner question
What have you declared us1 as? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: 01 March 2005 13:42 To: u2-users@listserver.u2ug.org Subject: RE: [U2][UV] UO.NET beginner question Here is the code I am trying to use: us1 = null ; us1.HostPort = 7200; try { us1 = UniObjects.OpenSession(Server,LoginName,Password,uvAccount,uvcs ); It is compiling just fine, I am getting an error when I run it though. Any suggestions? Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Monday, February 28, 2005 7:11 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] UO.NET beginner question (this won't compile and is not meant to) Have a look in the UniObjects .Net pdf file for more info on this, but here's how you can change the port number used for the connection. public UniSession uSession; uSession.HostPort = 12345; uSession = UniObjects.OpenSession(Server, LoginName, PassWord, uvAccount, uvcs); On Mon, 28 Feb 2005 16:35:35 -0500, Nick Cipollina [EMAIL PROTECTED] wrote: How exactly can I do this?. (I'm new to .NET). Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Monday, February 28, 2005 3:29 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] UO.NET beginner question Check the UniSession property HostPort. I believe that if you set it to match your host settings you should be OK. On Mon, 28 Feb 2005 14:46:52 -0500, Nick Cipollina [EMAIL PROTECTED] wrote: Our rpc port is set to 7200. Is there something I need to change within .NET to tell it to look for that port? Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Monday, February 28, 2005 2:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] UO.NET beginner question Make sure the remote machine has the uniobjects port enabled and there are no firewalls between you and it that also block this port. On an HP-UX machine this is port 31438. Have a look at the services file in /etc and make sure this line is in there somewhere. uvrpc 31438/tcp # uvNet rpc port On Mon, 28 Feb 2005 12:49:04 -0500, Nick Cipollina [EMAIL PROTECTED] wrote: Hello all, I've got a dumb UO.NET question to ask. I am trying to write a simple UO.NET program to connect to one of our UniVerse servers and I am getting the following error: No connection could be made because the target machine actively refused it. Any ideas what I am missing? Thanks. Nick Cipollina Pick Programmer ACS - Heritage Information Systems, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)644-8707 x 314 --- 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-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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] UO.NET beginner question
Yes. No. I'm not sure if there was a reason. I would still like to know how to point to a different port, even if I could change it back to 31438. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Tuesday, March 01, 2005 9:52 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] UO.NET beginner question Are you on the same physical network as the target machine? Is there a firewall between you and it? What is the reasoning behind changing the rpc port to 7200? --- 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] UO.NET beginner question
Sorry, Private UniSession us1; Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Tuesday, March 01, 2005 10:01 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2][UV] UO.NET beginner question What have you declared us1 as? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: 01 March 2005 13:42 To: u2-users@listserver.u2ug.org Subject: RE: [U2][UV] UO.NET beginner question Here is the code I am trying to use: us1 = null ; us1.HostPort = 7200; try { us1 = UniObjects.OpenSession(Server,LoginName,Password,uvAccount,uvcs ); It is compiling just fine, I am getting an error when I run it though. Any suggestions? Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Monday, February 28, 2005 7:11 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] UO.NET beginner question (this won't compile and is not meant to) Have a look in the UniObjects .Net pdf file for more info on this, but here's how you can change the port number used for the connection. public UniSession uSession; uSession.HostPort = 12345; uSession = UniObjects.OpenSession(Server, LoginName, PassWord, uvAccount, uvcs); On Mon, 28 Feb 2005 16:35:35 -0500, Nick Cipollina [EMAIL PROTECTED] wrote: How exactly can I do this?. (I'm new to .NET). Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Monday, February 28, 2005 3:29 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] UO.NET beginner question Check the UniSession property HostPort. I believe that if you set it to match your host settings you should be OK. On Mon, 28 Feb 2005 14:46:52 -0500, Nick Cipollina [EMAIL PROTECTED] wrote: Our rpc port is set to 7200. Is there something I need to change within .NET to tell it to look for that port? Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Monday, February 28, 2005 2:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] UO.NET beginner question Make sure the remote machine has the uniobjects port enabled and there are no firewalls between you and it that also block this port. On an HP-UX machine this is port 31438. Have a look at the services file in /etc and make sure this line is in there somewhere. uvrpc 31438/tcp # uvNet rpc port On Mon, 28 Feb 2005 12:49:04 -0500, Nick Cipollina [EMAIL PROTECTED] wrote: Hello all, I've got a dumb UO.NET question to ask. I am trying to write a simple UO.NET program to connect to one of our UniVerse servers and I am getting the following error: No connection could be made because the target machine actively refused it. Any ideas what I am missing? Thanks. Nick Cipollina Pick Programmer ACS - Heritage Information Systems, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)644-8707 x 314 --- 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-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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe
RE: [U2][UV] UO.NET beginner question
I thought this was a bug in UV.NET, it can only use port 31438. Les -Original Message- From: Nick Cipollina [mailto:[EMAIL PROTECTED] Sent: 01 March 2005 15:43 To: u2-users@listserver.u2ug.org Subject: RE: [U2][UV] UO.NET beginner question Yes. No. I'm not sure if there was a reason. I would still like to know how to point to a different port, even if I could change it back to 31438. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Tuesday, March 01, 2005 9:52 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] UO.NET beginner question Are you on the same physical network as the target machine? Is there a firewall between you and it? What is the reasoning behind changing the rpc port to 7200? --- 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/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2][UV] UO.NET beginner question
Nick Cipollina wrote: Here is the code I am trying to use: us1 = null ; us1.HostPort = 7200; try { us1 = UniObjects.OpenSession(Server,LoginName,Password,uvAccount,uvcs ); It is compiling just fine, I am getting an error when I run it though. Any suggestions? OK - it will compile, but the us1.HostPort = 7200 bit is doing absolutely nothing. The us1 returned by UniObjects.OpenSession is a new session with no connection to the us1 with HostPort = 7200. This came up last November on the list, and IBM said that a fix would be available shortly: http://article.gmane.org/gmane.comp.db.u2.general/30538/ Simon --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] UO.NET beginner question
Bug, or feature? Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Les Hewkin Sent: Tuesday, March 01, 2005 11:27 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2][UV] UO.NET beginner question I thought this was a bug in UV.NET, it can only use port 31438. Les -Original Message- From: Nick Cipollina [mailto:[EMAIL PROTECTED] Sent: 01 March 2005 15:43 To: u2-users@listserver.u2ug.org Subject: RE: [U2][UV] UO.NET beginner question Yes. No. I'm not sure if there was a reason. I would still like to know how to point to a different port, even if I could change it back to 31438. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Tuesday, March 01, 2005 9:52 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] UO.NET beginner question Are you on the same physical network as the target machine? Is there a firewall between you and it? What is the reasoning behind changing the rpc port to 7200? --- 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/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- 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] UO.NET beginner question
I thought I remembered something about this. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simon Lewington Sent: Tuesday, March 01, 2005 11:50 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] UO.NET beginner question Nick Cipollina wrote: Here is the code I am trying to use: us1 = null ; us1.HostPort = 7200; try { us1 = UniObjects.OpenSession(Server,LoginName,Password,uvAccount,uvcs ); It is compiling just fine, I am getting an error when I run it though. Any suggestions? OK - it will compile, but the us1.HostPort = 7200 bit is doing absolutely nothing. The us1 returned by UniObjects.OpenSession is a new session with no connection to the us1 with HostPort = 7200. This came up last November on the list, and IBM said that a fix would be available shortly: http://article.gmane.org/gmane.comp.db.u2.general/30538/ Simon --- 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] [UV] Hashed file size
I seem to recall a limitation on the size of a hashed file. I believe it was 2gigs. I've tried looking for an explaination in the U2 library on the IBM site , but haven't come across anything regarding UV file limitations. Can someone please refresh this aging memory of mine or link me to the appropriate documentation. thx, rudy Rudy Cooper Sage Publications I.T Development Thousand Oaks, California (805) 499-0721 #7724 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] LINE.ATT for attaching serial line
Greetings, I'm trying to write a Unidata program to interface with another system via the serial port (/dev/tty01) on a Compaq Tru64 system. I'm wondering if anyone has any experience with this that may be able to offer some advice. Specifically, according to the published protocol, I need to wait for an ENQ (ascii 5) and I reply with ACK (ascii 6). It goes on from there but I won't bore you with the details. Until today, I couldn't get the other system to recognize my ACK. Today I got it working by making a small change to the LINE.ATT command that attaches the line - I added the DELAY parameter. This got it working for the first exchange but not for subsequent exchanges. All of this is by way of asking: Does anyone have any more detail on how LINE.ATT with DELAY works or is supposed to work? (the page from the manual is shown below. Not much detail.) Thanks, Dana Baron System Manager Smugglers' Notch Resort Page from manual for LINE.ATT command: LINE.ATT Syntax LINE.ATT line [DELAY] Synonym LINE-ATT Description The ECL LINE.ATT command attaches a communication line to the current process. The attaching process then has exclusive use of that line until it is detached with the LINE.DET command. A single process can attach up to five resources per UniData session. Warning On some platforms, you must specify DELAY in LINE.ATT to avoid problems with subsequent UniBasic SEND commands overlaying data. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] LINE.ATT for attaching serial line
what is on the other side of the tty port? a modem or device? If a modem, what is on the other end of the modem? Is this a PPP/SLIP or just system - system. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dana Baron Sent: Tuesday, March 01, 2005 1:24 PM To: U2-Users (E-mail) Subject: [U2] [UD] LINE.ATT for attaching serial line Greetings, I'm trying to write a Unidata program to interface with another system via the serial port (/dev/tty01) on a Compaq Tru64 system. I'm wondering if anyone has any experience with this that may be able to offer some advice. Specifically, according to the published protocol, I need to wait for an ENQ (ascii 5) and I reply with ACK (ascii 6). It goes on from there but I won't bore you with the details. Until today, I couldn't get the other system to recognize my ACK. Today I got it working by making a small change to the LINE.ATT command that attaches the line - I added the DELAY parameter. This got it working for the first exchange but not for subsequent exchanges. All of this is by way of asking: Does anyone have any more detail on how LINE.ATT with DELAY works or is supposed to work? (the page from the manual is shown below. Not much detail.) Thanks, Dana Baron System Manager Smugglers' Notch Resort Page from manual for LINE.ATT command: LINE.ATT Syntax LINE.ATT line [DELAY] Synonym LINE-ATT Description The ECL LINE.ATT command attaches a communication line to the current process. The attaching process then has exclusive use of that line until it is detached with the LINE.DET command. A single process can attach up to five resources per UniData session. Warning On some platforms, you must specify DELAY in LINE.ATT to avoid problems with subsequent UniBasic SEND commands overlaying data. --- 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] Hashed file size
The 2 gig limit is the unix file size limit. Cooper, Rudy wrote: I seem to recall a limitation on the size of a hashed file. I believe it was 2gigs. I've tried looking for an explaination in the U2 library on the IBM site , but haven't come across anything regarding UV file limitations. Can someone please refresh this aging memory of mine or link me to the appropriate documentation. thx, rudy Rudy Cooper Sage Publications I.T Development Thousand Oaks, California (805) 499-0721 #7724 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Stu Glancy Senior Analyst AMOI 7001 Peachtree Industrial Blvd. Norcross, GA 30101 678-282-6531 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] LINE.ATT for attaching serial line
There actually are Unidata commands to send/receive data through a port. This is how I did modem EDI transfers on NT. I don't recall the exact commands.. Try looking for the commands SEND RECEIVE. Also yes. The LINE.ATT is also needed. Thanks, Marilyn A. Hilb Value Part, Inc Direct: 847-918-6099 Fax: 847-367-1892 [EMAIL PROTECTED] www.valuepart.com -Original Message- From: Dana Baron [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 01, 2005 12:24 PM To: U2-Users (E-mail) Subject:[U2] [UD] LINE.ATT for attaching serial line Greetings, I'm trying to write a Unidata program to interface with another system via the serial port (/dev/tty01) on a Compaq Tru64 system. I'm wondering if anyone has any experience with this that may be able to offer some advice. Specifically, according to the published protocol, I need to wait for an ENQ (ascii 5) and I reply with ACK (ascii 6). It goes on from there but I won't bore you with the details. Until today, I couldn't get the other system to recognize my ACK. Today I got it working by making a small change to the LINE.ATT command that attaches the line - I added the DELAY parameter. This got it working for the first exchange but not for subsequent exchanges. All of this is by way of asking: Does anyone have any more detail on how LINE.ATT with DELAY works or is supposed to work? (the page from the manual is shown below. Not much detail.) Thanks, Dana Baron System Manager Smugglers' Notch Resort Page from manual for LINE.ATT command: LINE.ATT Syntax LINE.ATT line [DELAY] Synonym LINE-ATT Description The ECL LINE.ATT command attaches a communication line to the current process. The attaching process then has exclusive use of that line until it is detached with the LINE.DET command. A single process can attach up to five resources per UniData session. Warning On some platforms, you must specify DELAY in LINE.ATT to avoid problems with subsequent UniBasic SEND commands overlaying data. --- 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] Hashed file size (Unclassified)
Rudy, Any 32-bit file (UV or anything else) is limited to 2GB. UV supports 64-bit files, but your O/S may need special configuration to support that. (What O/S are you using?) UV also supports distributed files, the parts of which may be 32-bit or 64-bit. Also, a UV Dynamic file has two parts, DATA.30 OVER.30, each of which can get to 2GB, but this is a bit of a kludge as you may not be able to control how much data goes into DATA.30 and how much into OVER.30. HTH Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cooper, Rudy Sent: Wednesday, 2 March 2005 06:47 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Hashed file size I seem to recall a limitation on the size of a hashed file. I believe it was 2gigs. I've tried looking for an explaination in the U2 library on the IBM site , but haven't come across anything regarding UV file limitations. Can someone please refresh this aging memory of mine or link me to the appropriate documentation. thx, rudy Rudy Cooper Sage Publications I.T Development Thousand Oaks, California (805) 499-0721 #7724 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 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/
RE: [U2] [UD] LINE.ATT for attaching serial line
George Gallen wrote: what is on the other side of the tty port? a modem or device? If a modem, what is on the other end of the modem? Is this a PPP/SLIP or just system - system. This is part of an effort to interface with a Squirrel POS system. The tty port connects to a Systech brand serial port server. It's a box that sort of converts serial to Ethernet. It has an IP address that is known by the Squirrel server. Data going back and forth between the two systems is sent over the network between the server and the serial port server. It's then converted to/from serial. The interface protocol defines the structure and content of the messages between machines. It's all based on serial communications, with ASCII characters used to control the signaling (ENQ, ACK, NAK, STX, ETX, etc). Until now, I've been frustrated in my attempts to get the Squirrel system to understand my ACK response to its ENQ. It usually figures it out after the fourth or fifth try, but by then it's too late. Working with Squirrel support, I learned that the buffer had data other than my ACK in it when it arrived. I tried using the DELAY parameter on the LINE.ATT command and suddenly Squirrel understood the ACK on the first try. The Unidata manual says: Warning On some platforms, you must specify DELAY in LINE.ATT to avoid problems with subsequent UniBasic SEND commands overlaying data. So, I guess I'm having problems with my SEND commands overlaying data. Now I'd like more detail on what this means and how to get around it. (And to think, some people get to play around with UniObjects and other cool things!) Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] LINE.ATT for attaching serial line
are both system tru64? Why not setup a SLIP connection in tru64 (man slattach and man SLIP) on both sides. Then you open a port directly to the other machine, just like it was connected to the network, except...the main network of the tru64 machine can not access this SLIP connection. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dana Baron Sent: Tuesday, March 01, 2005 2:28 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] LINE.ATT for attaching serial line George Gallen wrote: what is on the other side of the tty port? a modem or device? If a modem, what is on the other end of the modem? Is this a PPP/SLIP or just system - system. This is part of an effort to interface with a Squirrel POS system. The tty port connects to a Systech brand serial port server. It's a box that sort of converts serial to Ethernet. It has an IP address that is known by the Squirrel server. Data going back and forth between the two systems is sent over the network between the server and the serial port server. It's then converted to/from serial. The interface protocol defines the structure and content of the messages between machines. It's all based on serial communications, with ASCII characters used to control the signaling (ENQ, ACK, NAK, STX, ETX, etc). Until now, I've been frustrated in my attempts to get the Squirrel system to understand my ACK response to its ENQ. It usually figures it out after the fourth or fifth try, but by then it's too late. Working with Squirrel support, I learned that the buffer had data other than my ACK in it when it arrived. I tried using the DELAY parameter on the LINE.ATT command and suddenly Squirrel understood the ACK on the first try. The Unidata manual says: Warning On some platforms, you must specify DELAY in LINE.ATT to avoid problems with subsequent UniBasic SEND commands overlaying data. So, I guess I'm having problems with my SEND commands overlaying data. Now I'd like more detail on what this means and how to get around it. (And to think, some people get to play around with UniObjects and other cool things!) Dana Baron System Manager Smugglers' Notch Resort --- 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] [UD] LINE.ATT for attaching serial line
It sounds like you have most of the pieces. You're doing a LINE-ATT and using GET and SEND to talk to the systech box. The device is sending you an ENQ and you respond with an ACK that it doesn't recognize. So, 2 questions: first, are you seeing the ENQ (and is there any associated data with the ENQ?); second, what is the baud rate/parity of the systech, and where are you setting it? If you are getting the ENQ and sending an ACK that's unrecognized, maybe you've got the wrong parity. Finally, it sounds like your POS is using tcp to talk to the systech, and then you're using serial for the systech to talk to unidata. Would it be possible to use tcp sockets and go directly from the POS to unidata without the impediment of a serial link? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dana Baron Sent: Tuesday, March 01, 2005 2:28 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] LINE.ATT for attaching serial line George Gallen wrote: what is on the other side of the tty port? a modem or device? If a modem, what is on the other end of the modem? Is this a PPP/SLIP or just system - system. This is part of an effort to interface with a Squirrel POS system. The tty port connects to a Systech brand serial port server. It's a box that sort of converts serial to Ethernet. It has an IP address that is known by the Squirrel server. Data going back and forth between the two systems is sent over the network between the server and the serial port server. It's then converted to/from serial. The interface protocol defines the structure and content of the messages between machines. It's all based on serial communications, with ASCII characters used to control the signaling (ENQ, ACK, NAK, STX, ETX, etc). Until now, I've been frustrated in my attempts to get the Squirrel system to understand my ACK response to its ENQ. It usually figures it out after the fourth or fifth try, but by then it's too late. Working with Squirrel support, I learned that the buffer had data other than my ACK in it when it arrived. I tried using the DELAY parameter on the LINE.ATT command and suddenly Squirrel understood the ACK on the first try. The Unidata manual says: Warning On some platforms, you must specify DELAY in LINE.ATT to avoid problems with subsequent UniBasic SEND commands overlaying data. So, I guess I'm having problems with my SEND commands overlaying data. Now I'd like more detail on what this means and how to get around it. (And to think, some people get to play around with UniObjects and other cool things!) Dana Baron System Manager Smugglers' Notch Resort --- 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] [UD] LINE.ATT for attaching serial line (unclassified)
Dana, So, you've got a Squirrel POS system on an Ethernet LAN connecting to a UniData system on a (presumably different) Ethernet LAN and you're trying to connect them via serial ports? Wouldn't a LAN-level [router] connection be easier? Then you could try some XML, or HTTP, or sockets programming. Or even BCI and stuffing data into / snatching data out of the Squirrel database. Gotta be more fun than serial ports, even if not quite as 'cool' as UniObjects! ;-) Worth thinking about? Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dana Baron Sent: Wednesday, 2 March 2005 08:28 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] LINE.ATT for attaching serial line This is part of an effort to interface with a Squirrel POS system. The tty port connects to a Systech brand serial port server. It's a box that sort of converts serial to Ethernet. It has an IP address that is known by the Squirrel server. [snip] (And to think, some people get to play around with UniObjects and other cool things!) Dana Baron System Manager Smugglers' Notch Resort 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/
Re: [U2] [UV] Hashed file size
Hi Stu (and Rudy), If you're running on HP-UX, you might want to look at: http://docs.hp.com/en/5964-5283/ch02s09.html At 10.10 the limit (for individual files) was 2GB. At 10.20 (and up) the limit has been increased to 128GB. At least for HP-UX, the limitation is most definitely NOT the OS... Alan Walters Director of I.T. Royce Medical -Original Message- Date: Tue, 01 Mar 2005 13:47:44 -0500 From: Stu Glancy [EMAIL PROTECTED] Subject: Re: [U2] [UV] Hashed file size The 2 gig limit is the unix file size limit. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Hashed file size
So does that mean there is no limit on a w2k box ? rudy Date: Tue, 01 Mar 2005 13:47:44 -0500 From: Stu Glancy [EMAIL PROTECTED] Subject: Re: [U2] [UV] Hashed file size The 2 gig limit is the unix file size limit. Cooper, Rudy wrote: I seem to recall a limitation on the size of a hashed file. I believe it was 2gigs. I've tried looking for an explaination in the U2 library Rudy Cooper Sage Publications I.T Development Thousand Oaks, California (805) 499-0721 #7724 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] LINE.ATT for attaching serial line
Ed Clark wrote: So, 2 questions: first, are you seeing the ENQ (and is there any associated data with the ENQ?); I'm seeing the ENQ fine. Unfortunately, I need to work with Squirrel support to help debug this, but they report that they're seeing my ACK embedded in other data, things like CR LF, etc, but the data is not consistent. They look only at the first character and if its not an ACK, they ignore it. Once I changed to use DELAY, Squirrel recognized the ACK on the first try. second, what is the baud rate/parity of the systech, and where are you setting it? If you are getting the ENQ and sending an ACK that's unrecognized, maybe you've got the wrong parity. It seems that the baud and parity are all fine since I can see the data correctly at both ends, it just isn't matching the protocol, and as I said above the data I'm sending is getting mixed up with other stuff. And the DELAY parameter on the LINE.ATT helps sort things out, at least for the first SEND. Finally, it sounds like your POS is using tcp to talk to the systech, and then you're using serial for the systech to talk to unidata. Would it be possible to use tcp sockets and go directly from the POS to unidata without the impediment of a serial link? I've explored that option with Squirrel (the POS brand), and unfortunately it's a no go. I can't understand why not in this day and age, but I'm playing with their toys. Thanks for the follow-up questions. Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] LINE.ATT for attaching serial line
So, you've got a line of code something like SEND ACK: TO PORT ELSE GOTO DISASTER: and the POS is seeing other stuff besides your ACK? If you left out the colon after the ACK then you will be sending extra line feeds--you might want to check that. You also might want to check and replace the serial cable going from the systech to your com port--if there's a short in it, one end or the other can see echoed or trash characters. And, speaking of echo, do you have an ECHO OFF in your program? The GET that you're using to look for the ENQ might be echoing back what the POS sends. I seriously doubt you need the DELAY. It sounds like the DELAY would be used if you were talking to a named pipe, but not for a standard serial connection. I'm assuming here that the serial connection is full duplex. Do you have a dumb terminal or pc with terminal emulation that you could connect to your com port and to the systech so that you might step through the protocol manually and see what's really going back and forth, without having to rely on tech support to tell you what they think they are getting? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dana Baron Sent: Tuesday, March 01, 2005 3:47 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] LINE.ATT for attaching serial line Ed Clark wrote: So, 2 questions: first, are you seeing the ENQ (and is there any associated data with the ENQ?); I'm seeing the ENQ fine. Unfortunately, I need to work with Squirrel support to help debug this, but they report that they're seeing my ACK embedded in other data, things like CR LF, etc, but the data is not consistent. They look only at the first character and if its not an ACK, they ignore it. Once I changed to use DELAY, Squirrel recognized the ACK on the first try. second, what is the baud rate/parity of the systech, and where are you setting it? If you are getting the ENQ and sending an ACK that's unrecognized, maybe you've got the wrong parity. It seems that the baud and parity are all fine since I can see the data correctly at both ends, it just isn't matching the protocol, and as I said above the data I'm sending is getting mixed up with other stuff. And the DELAY parameter on the LINE.ATT helps sort things out, at least for the first SEND. Finally, it sounds like your POS is using tcp to talk to the systech, and then you're using serial for the systech to talk to unidata. Would it be possible to use tcp sockets and go directly from the POS to unidata without the impediment of a serial link? I've explored that option with Squirrel (the POS brand), and unfortunately it's a no go. I can't understand why not in this day and age, but I'm playing with their toys. Thanks for the follow-up questions. Dana Baron System Manager Smugglers' Notch Resort --- 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] Using an I descriptor in a UniBasic program
Hello all. Being new to UniData, I hope that maybe someone can help me. How do you read an I descriptor in a UniBasic program? The IBM manual gives me a hint (looking at the CALCULATE command), but the example given uses a select on the entire file. I am looking for a way to read the actual data and the I descriptor within a loop without using a select. I'm familiar with opening, reading, updating, etc. the data portion of a file, but not the dictionary. Can anybody point me in the right direction? Thanks --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Using an I descriptor in a UniBasic program
Hello all. Being new to UniData, I hope that maybe someone can help me. How do you read an I descriptor in a UniBasic program? The IBM manual gives me a hint (looking at the CALCULATE command), but the example given uses a select on the entire file. I am looking for a way to read the actual data and the I descriptor within a loop without using a select. I'm familiar with opening, reading, updating, etc. the data portion of a file, but not the dictionary. Can anybody point me in the right direction? Thanks --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Using an I descriptor in a UniBasic program
The way to do this is with two read statements...something like... read R.PO from F.PO, This.PO else R.PO = '' This.Supplier = R.PO4 read R.Supplier from F.Supplier, This.Supplier else R.Supplier = '' This.Contact.Name = R.Supplier7 In other words, forget about using I-Descriptors from within UniBasic. Even if it is possible, to me, it would be bad practice, inefficient, etc. The technique given above is akin to... bread and budder. Regards, --Bill Bill Brutzman, Mgr IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644-0775 973.471.7770 x145 973.471.9666 [EMAIL PROTECTED] www.hkMetalCraft.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bill Stinocher Sent: Tuesday, March 01, 2005 5:19 PM To: [EMAIL PROTECTED] Subject: [U2] Using an I descriptor in a UniBasic program Hello all. Being new to UniData, I hope that maybe someone can help me. How do you read an I descriptor in a UniBasic program? The IBM manual gives me a hint (looking at the CALCULATE command), but the example given uses a select on the entire file. I am looking for a way to read the actual data and the I descriptor within a loop without using a select. I'm familiar with opening, reading, updating, etc. the data portion of a file, but not the dictionary. Can anybody point me in the right direction? Thanks --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/octet-stream which had a name of Brutzman, Bill.vcf] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Using an I descriptor in a UniBasic program
OPEN DICT,MY.FILE TO @DICT ELSE STOP (@DICT is required to work with virtual fields) READ @RECORD FROM F.MY.FILE,KV.MY.FILE ELSE PRINT ERROR F.MY.FILE: ID = :KV.MY.FILE (@RECORD required. Virtual fields are in MY.FILE) CLIENT.NAME = {DONOR.NAME} (Uses virtual field DONOR.NAME in MY.FILE) HTH JohnC * * John ChristianDEC ALPHA 4100 5/400* * Lutheran Church-Missouri Synod (LCMS) Tru64 UNIX 4.0F ENV 4.7.1 * * St Louis MO UniData 5.2.16 BEN 5.1* * [EMAIL PROTECTED] 314-317-4248 UNIX migration: 8/30/99 * * Hello all. Being new to UniData, I hope that maybe someone can help me. How do you read an I descriptor in a UniBasic program? The IBM manual gives me a hint (looking at the CALCULATE command), but the example given uses a select on the entire file. I am looking for a way to read the actual data and the I descriptor within a loop without using a select. I'm familiar with opening, reading, updating, etc. the data portion of a file, but not the dictionary. Can anybody point me in the right direction? Thanks --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] ODBC driver for accessing MS-SQL from AIX running unix
Hello, Is anyone using a unix ODBC driver, other than DataDirect, that can be installed onto an AIX box that will connect to MS-SQL 2000? I need to pull information from the MS-SQL 2000 database into my UniData environment for reporting using BCI. Thanks, Arthur - - - - - - - - - - Arthur Metherall Courier Corporation 978-251-6213 - - - - - - - - - - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Using an I descriptor in a UniBasic program
Bill Stinocher wrote: How do you read an I descriptor in a UniBasic program? The IBM manual gives me a hint (looking at the CALCULATE command), but the example given uses a select on the entire file. I am looking for a way to read the actual data and the I descriptor within a loop without using a select. I'm familiar with opening, reading, updating, etc. the data portion of a file, but not the dictionary. Can anybody point me in the right direction? Take a look at ITYPE() However... I usually just rewrite the logic in UniBasic. I have no control over the dictionaries and don't want to risk one of the report writers changing a dictionary item and breaking one of my programs. If it's complicated, then it probably belongs in a subroutine that gets called from both the I-Descriptor and the UniBasic program. -- Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Using an I descriptor in a UniBasic program
Bill, This is an example from Universe. I *think* it works on UniData, too. Look at lines 1,2, 8,9,10 of the program. This is a simple example. I use DICT VOC TYPE, because everyone is probably familiar with it. ED CDS.BP BILL 15 lines long. : P 0001: OPEN 'DICT VOC' TO VOC.DCT ELSE STOP 0002: READ TYPE.IDESC FROM VOC.DCT, 'TYPE' ELSE STOP 0003: OPEN 'VOC' TO VOC.FVAR ELSE STOP 0004: SELECT VOC.FVAR 0005: LOOP 0006: READNEXT VOC.ID ELSE EXIT 0007: READ VOC.REC FROM VOC.FVAR, VOC.ID ELSE STOP 0008: @RECORD = VOC.REC 0009: @ID = VOC.ID 0010: TYPE = ITYPE( TYPE.IDESC ) 0011: CRT VOC.ID, TYPE 0012: INPUT Q 0013: UNTIL Q = 'Q' 0014: REPEAT 0015:END Bottom at line 15. : Q ED DICT VOC TYPE This is a Type I Descriptor last compiled on 07/29/03 at 15:35. 20 lines long. : P7 0001: I 0002: IF F1[1,1]='P' THEN F1[1,2] ELSE F1[1,1] 0003: 0004: 0005: 2L## 0006: S 0007: : Q RUN CDS.BP BILL HASH.TEST V ? QUIT.KEY X ? CLEAR.LOCKS V ?Q -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Stinocher Sent: Tuesday, March 01, 2005 2:19 PM To: [EMAIL PROTECTED] Subject: [U2] Using an I descriptor in a UniBasic program Hello all. Being new to UniData, I hope that maybe someone can help me. How do you read an I descriptor in a UniBasic program? The IBM manual gives me a hint (looking at the CALCULATE command), but the example given uses a select on the entire file. I am looking for a way to read the actual data and the I descriptor within a loop without using a select. I'm familiar with opening, reading, updating, etc. the data portion of a file, but not the dictionary. Can anybody point me in the right direction? Thanks --- 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] ODBC driver for accessing MS-SQL from AIX running unix
Arthur, If you're up to it, have a look at using the IIS interface SQLXML. If you are using a release of U2 which supports http functions then there's nothing to install on the U2 side. It basically just needs to have the interface set up under SQL. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/intro_3tbm.asp Data can be retrieved as easily as: url = 'http://sqlsvr/u2source'?SQL=select%20*%20from%20mytable%20for%20xml%20auto' crt createRequest(url,'GET',sessionHandle) crt submitRequest(sessionHandle,1,'',httpHeaders,response,httpStatus) *// optionally use the u2 xml functions or hard-parse the returned xml in response. It's pretty efficient too. A quick test on a sql server sitting on the other side of our DMZ took 3 minutes to write a program and 2.5 secs to return 10mb of data. Cheers, Stuart -Original Message- Metherall, Arthur Hello, Is anyone using a unix ODBC driver, other than DataDirect, that can be installed onto an AIX box that will connect to MS-SQL 2000? I need to pull information from the MS-SQL 2000 database into my UniData environment for reporting using BCI. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SBClient escape sequences
Ed, SBClient supports the standard VT220 sequences - you should be able to google a reference pretty easily. Page 2 of the SB+ terminal definition screen (/TERM.DEFN) has some, also F6 - Cursor will show you the base terminal addressing sequences. Most of the base functions can be accessed through either the BASIC @() terminal addressing functions, or from the SBPlus common TERM.DEFN variable. Without actually knowing what you want to do I would suggest that these provide much better (read 'flexible') cross-emulation capabilities than hard coding any of the escape sequences. Regards, Stuart Boydell -Original Message- From: Ed Clark Does anyone have documentation on what escape sequences sbclient supports (I'm most interested in the vt220 mode). The programmer's manual has a list of extended sequences, but I need to know the basic sequences supported as well. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/