[U2] ODBC question
Hi, While we're talking Unidata ODBC... I'm having trouble getting UNIDATA ODBC working here. Server is Tru64 Unix. Client is windows. UCI seems to be set up correctly. I can access the data and create views, etc with VSG. But, when I try to import or link to the data from Access or Excel, I get the following error: The ODBC screen pops up with most of the parameters filled in, except my password. I put in the password (and yes, I've tried it a million times and the password is correct!) and an error pop-up says: [Ardent][Unidata ODBC Driver][IBM][SQL Client][UNIDATA]Server is not authorized Anyone have any suggestions? 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] ODBC question
Hi Marc, Good question. Yes we have licenses for both Unidata and ODBC, however, our server crashed hard a few months ago and I had to re-install Unidata (and just about everything else). I haven't tried using ODBC since then. It could be that the ODBC license wasn't re-installed correctly. Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: Thursday, June 08, 2006 8:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC question Do you have a license to use ODBC? Or Is your UniData licensed? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dana Baron Sent: Thursday, June 08, 2006 8:11 AM To: U2-Users Subject: [U2] ODBC question Hi, While we're talking Unidata ODBC... I'm having trouble getting UNIDATA ODBC working here. Server is Tru64 Unix. Client is windows. UCI seems to be set up correctly. I can access the data and create views, etc with VSG. But, when I try to import or link to the data from Access or Excel, I get the following error: The ODBC screen pops up with most of the parameters filled in, except my password. I put in the password (and yes, I've tried it a million times and the password is correct!) and an error pop-up says: [Ardent][Unidata ODBC Driver][IBM][SQL Client][UNIDATA]Server is not authorized Anyone have any suggestions? 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] ODBC question
Hi, While we're talking Unidata ODBC... I'm having trouble getting UNIDATA ODBC working here. Server is Tru64 Unix. Client is windows. UCI seems to be set up correctly. I can access the data and create views, etc with VSG. But, when I try to import or link to the data from Access or Excel, I get the following error: The ODBC screen pops up with most of the parameters filled in, except my password. I put in the password (and yes, I've tried it a million times and the password is correct!) and an error pop-up says: [Ardent][Unidata ODBC Driver][IBM][SQL Client][UNIDATA]Server is not authorized Anyone have any suggestions? 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] Changes to the List
I would like to make a suggestion. The u2 users list has been in existence for a LONG time. Currently, the list is managed by the U2 User Group. (Up until yesterday, I was a member of the u2ug board, but my term expired). I would suggest that the u2ug board appoint a small team of people to investigate the options for communication to the u2 communities and come back with recommendations to the board. The investigation should look at all available options, listing the pros and cons of each. And it should include polling of the user community. This clearly a topic of interest to a lot of people. I imagine there are even a few people out there who wouldn't mind serving on this suggested team. 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] Escaping a Quote
You can use single quotes in the SELECT statement. Example: SELECT FILE.NAME WITH @ID EQ '1234' will select the record with an id equal 1234 in quotes. (I tried it and it worked) Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Monday, February 27, 2006 12:32 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Escaping a Quote Unidata 6.1: Is there a way to escape a character in a SELECT literal? Though I can't see it in the documentation, I know you can quote with the or \ characters, but what if the literal contains both and \ characters? What then? Or what if the value contains a ^ or [ or ? that aren't to be interpreted by the query engine? ??? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.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/
[U2] CC encrypting for unidata
Anyone have or know of software to encrypt credit card numbers in Unidata. (Probably someone has already asked this on this list - sorry) 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] [OT] Where's my voting instructions?
For those of you on this list who are U2UG members, you should be receiving instructions for voting in this year's board election soon. Due to technical difficulties (mostly caused by me), the election has been delayed. Stay tuned! Thanks for your patience, Dana Baron U2UG Nominations Elections --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] openseq question
Several years ago I created a little utility to open sequential files as needed. It's pretty robust; hasn't given me much trouble over the years. Like Kevin, I've had problems with the full path version of openseq, so my utility converts full path mode to VOC pointer mode and creates the VOC pointer if it doesn't already exist. I'll include it below and attach it in text form. Dana Baron System Manager Smugglers' Notch Resort SUBROUTINE OPEN_UNIX_FILE (UNIX.FN, MODE, UNIX.FILE, ERR.CODE) !** ! SYSTEM: AHS ! MODULE: UTILITY ! PROGRAM:OPEN_UNIX_FILE ! ! DESCRIPTION:This subroutine opens a sequential file. Sequential ! files can be used to export Unidata data to UNIX. ! ! Notes: The parameters passed to this routine are: ! ! UNIX.FN - the full file name of the file to open. ! MODE - expects the following choices: ! C - create a new file ! U - update existing file (error message if not there) ! UC- update the file if it exists, create a new file if ! it doesn't exist. ! UNIX.FILE - the file reference num returned to calling program ! ERR.CODE - Error code to indicate results as follows: ! 0 = No error. Everthing is OK. ! 1 = (Fatal) Can't open the VOC item for the directory ! 2 = (Info) VOC item for directory already defined ! 3 = (Info) In C mode, file exists so renamed ! 4 = (Warning) In U mode, file does not exist ! 5 = (Fatal, calling program bug) Invalid mode parameter ! !** ! MODIFICATION HISTORY ! ! EDIT DATE WHO REASON/DESCRIPTION ! ! 07/12/96 GDB Created ! ! 11/14/97 GDB Added UC mode to update file if it exists, create ! the file if it doesn't exist. ! ! 02/15/01 GDB Copied OPEN_VMS_FILE to OPEN_UNIX_FILE and modified ! to work in Unix as part of conversion from VMS to Unix. !** TRUE = 1 FALSE = 0 ERR.CODE = 0 OPEN ,VOC TO VOC.FILE ELSE PRINT CANT OPEN VOC!!! ERR.CODE = 1 ABORT END !DEBUG NUM.SLASH = DCOUNT(UNIX.FN, /) UNIX.DIR = UNIX.ID = FIELD(UNIX.FN,/,NUM.SLASH) FOR II = 2 TO NUM.SLASH - 1 UNIX.DIR = UNIX.DIR : / : FIELD(UNIX.FN,/,II) NEXT II VOC.ITEM = DIR:@AM:UNIX.DIR READ TEST.ITEM FROM VOC.FILE , UNIX.DIR THEN IF (TEST.ITEM2) = UNIX.DIR THEN NULL END ELSE PRINT VOC ITEM ':UNIX.DIR:' DEFINED IN VOC AS : PRINT '' : TEST.ITEM : '' ERR.CODE = 2 END END ELSE WRITE VOC.ITEM ON VOC.FILE , UNIX.DIR END BEGIN CASE CASE MODE = C PASS = 1 RENAME = FALSE DONE = 0 NEW.UNIX.ID = UNIX.ID LOOP UNTIL DONE DO OPENSEQ UNIX.DIR, NEW.UNIX.ID TO UNIX.FILE THEN PRINT FILE ALREADY EXISTS...RENAMING NEW.UNIX.ID = UNIX.ID : _ : PASS RENAME = TRUE PASS = PASS + 1 ERR.CODE = 3 END ELSE DONE = 1 END REPEAT IF RENAME = TRUE THEN PRINT FILE RENAMED TO : NEW.UNIX.ID END CASE MODE = U DONE = 0 OPENSEQ UNIX.DIR, UNIX.ID TO UNIX.FILE ELSE PRINT FILE DOES NOT EXIST ERR.CODE = 4 END CASE MODE = UC DONE = 0 OPENSEQ UNIX.DIR, UNIX.ID TO UNIX.FILE ELSE ! File doesn't exist. A new file is created END CASE -1 PRINT Function called with a bad Mode parameter. ERR.CODE = 5 END CASE RETURN SUBROUTINE OPEN_UNIX_FILE (UNIX.FN, MODE, UNIX.FILE, ERR.CODE) !** ! SYSTEM: AHS ! MODULE: UTILITY ! PROGRAM:OPEN_UNIX_FILE ! ! DESCRIPTION:This subroutine opens a sequential file. Sequential ! files can be used to export Unidata data
RE: [U2] Help!
It's now Sunday, so hopefully Wally Terhune and U2 support helped you get your system back up and healthy. Greetings, Thanks to everyone for their support, moral and technical, throughout this ordeal. The U2 support folks were GREAT!, especially Paul Chang and Jim Abshire. I'm not out of the woods yet, but I'm in much better shape now than yesterday at this time! Some things that helped: I ran a sys_check after the first crash, which saved a lot of important information in a .html file Almost all of my Unidata install was on a separate disk which was unaffected by the crash After the second crash, we saw where we were headed and had everyone start preparing for the worst while the system was available And excellent support from both IBM (UniData) and HP (the OS) Some things I still have to figure out: Print queues seem to be set up correctly, but they're not printing (jobs hang in the queue) We're running on a 40-user 30-day temporary license. Gotta fix that Monday. Our normal login routines aren't working. (see below) And I have to rebuild a lot of OS startup files, etc Login procedure problem: We used to point user logins to a udt startup script by naming it as the shell in /etc/passwd. So, for example, a user name TEST would have as the default shell in /etc/password something like /unidata/local/bin/udtlogin. That script would set UDTBIN, UDTHOME, etc then cd to the unidata account directory, then start unidata. The advantage of this is that the user never gets to the Unix command prompt. When they leave Unidata, their session goes away. It doesn't work now for some reason. It never goes into Unidata. Instead the session starts up then ends abruptly. OK, back to work I go. 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] Help!
Hi folks, Here's your worst nightmare come true: your production system crashes with a bad system disk. You find that the backups you've been doing every day don't backup the system, only the data. Now you have to get up and running - fast. Well, that's where I'm sitting right now. I think I'm going to need some help from UniData, but it may be hard to reach them on a Saturday so I thought I'd try the list. Here's what I have: There is a new hard disk in the system. I'm installing a clean OS (Tru64 Unix) right now. The data, including most of the Unidata install, is on a disk array and appears to be safe for now. After the OS install finishes, I need to get UniData up and running. One component I will be missing is the stuff in /usr/ud511, which includes udtconfig. Anything else I might need? Anyone know where I can get a good udtconfig for this? I have the UniData CD, but I don't want to re-install this unless I have to. Thanks in advance. I am a most embarrassed... 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] Help!
Hi Steve, Thanks for the moral support. I'm actually making some progress and it's just about time to call U2 support. Here goes. Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stephen O'Neal Sent: Saturday, August 13, 2005 9:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Help! Call 800-729-3553 (U2 Support phone number) and tell them you have a down system. U2 support is staffed 24X7 for stuff like this. We'll say a prayer too. Hope it goes a well as possible considering the circumstances. Steve Stephen M. O'Neal, CDP IBM U2 Certified Services Sales Specialist North America U2 Lab Services Information Management, IBM Software Group 303.471.8227 [EMAIL PROTECTED] Ross Ferris [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/13/2005 09:23 AM Please respond to u2-users To u2-users@listserver.u2ug.org cc Subject RE: [U2] Help! JOLT may be better than coffee for Sunday :-( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dana Baron Sent: Saturday, 13 August 2005 10:17 PM To: U2-Users (E-mail) Subject: [U2] Help! Hi folks, Here's your worst nightmare come true: your production system crashes with a bad system disk. You find that the backups you've been doing every day don't backup the system, only the data. Now you have to get up and running - fast. Well, that's where I'm sitting right now. I think I'm going to need some help from UniData, but it may be hard to reach them on a Saturday so I thought I'd try the list. Here's what I have: There is a new hard disk in the system. I'm installing a clean OS (Tru64 Unix) right now. The data, including most of the Unidata install, is on a disk array and appears to be safe for now. After the OS install finishes, I need to get UniData up and running. One component I will be missing is the stuff in /usr/ud511, which includes udtconfig. Anything else I might need? Anyone know where I can get a good udtconfig for this? I have the UniData CD, but I don't want to re-install this unless I have to. Thanks in advance. I am a most embarrassed... 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-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] Help!
Hi Wally, What are you doing working on a Saturday? Thanks for the advice. I'll give it a try. I may need some help with tuning and user counts. Support has been great so far! Thanks, Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wally Terhune Sent: Saturday, August 13, 2005 11:12 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help! reinstalling is simple. If you have your $UDTHOME directory - just tar down the tape and run updatesys builds a default udtconfig. May need to be tuned for your user count, etc Wally Terhune Manager - U2 Advanced Technical Services IBM Information Management Solutions Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] Check out the details of the special 3 day SMB offer available for U2 customers and Partners to attend the IBM DB2 Information Management Technical Conference on September 11-16, 2005 in Orlando, Florida. See the complete listing of exciting U2 technical sessions that will be offered. Attend several of the no-charge U2 pre-conference tutorials on Sunday the 11th. Sign up for no-charge U2 certification exams that are taking place throughout the conference. Attend one of our brand new Usability Lab sessions on External Database Access (EDA) or U2 Web Builder and offer your valuable feedback on product design and functionality. http://www.ibm.com/software/data/u2/offers Dana Baron [EMAIL PROTECTED] m To Sent by: U2-Users (E-mail) [EMAIL PROTECTED] u2-users@listserver.u2ug.org stserver.u2ug.org cc Subject 08/13/2005 06:17 [U2] Help! AM Please respond to u2-users Hi folks, Here's your worst nightmare come true: your production system crashes with a bad system disk. You find that the backups you've been doing every day don't backup the system, only the data. Now you have to get up and running - fast. Well, that's where I'm sitting right now. I think I'm going to need some help from UniData, but it may be hard to reach them on a Saturday so I thought I'd try the list. Here's what I have: There is a new hard disk in the system. I'm installing a clean OS (Tru64 Unix) right now. The data, including most of the Unidata install, is on a disk array and appears to be safe for now. After the OS install finishes, I need to get UniData up and running. One component I will be missing is the stuff in /usr/ud511, which includes udtconfig. Anything else I might need? Anyone know where I can get a good udtconfig for this? I have the UniData CD, but I don't want to re-install this unless I have to. Thanks in advance. I am a most embarrassed... Dana Baron System Manager Smugglers' Notch Resort --- 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 image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic10958.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- 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] AUTOLOGOUT
remember that you need to 'exec' uv to overlay the current process or it will create a subprocess to run UniVerse. In which case, the autologout will simply be returning them to their calling shell. We take a shortcut on using startup files like .profile. Instead, we put an entry into /etc/passwd for users that we want going directly to Unidata. In the field used to designate the user's shell, we put a reference to a login file that starts up Unidata. Since this then becomes the user's shell, once the shell ends, the process goes away. For example: juser:*:238:15:Joe User,Reservations Dept,1131,:/usr/users/juser:/unidata/local/bin/udtlogin The last entry points to a udtlogin which sets all the necessary environment variable, changes directory to the top of our Unidata application menu, then starts udt: # Define environment variables and set PATH, then start udt # PRINTER=system; export PRINTER UDTHOME=/unidata/ud5211; export UDTHOME UDTBIN=/unidata/ud5211/bin; export UDTBIN UDTLOCBIN=/unidata/local/bin; export UDTLOCBIN UDT_EDIT=emacs; export UDT_EDIT INTERFACE=/unidata/interface; export INTERFACE # LD_LIBRARY_PATH=/var/opt/DAU200/connect/lib; export LD_LIBRARY_PATH PATH=$PATH:$UDTBIN:$UDTLOCBIN:LD_LIBRARY_PATH:/opt/odbc/odbc.ini; export PATH ODBCINI=/opt/odbc/odbc.ini; export ODBCINI ODBCHOME=/var/opt/DAU200/connect; export ODBCHOME EDITOR=/usr/bin/emacs; export EDITOR # alias ED=emacs alias PRINT=lp alias print=lp alias edit=emacs alias EDIT=emacs # umask 000 # cd /unidata/SMUGGLER/AHS udt 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] UniBasic Line Continuation
So, Dana, which one of us is going to forward this to the U2UG Product Enhancements Committee? grin Since it works just fine for me, I guess you'll have to forward it! Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Clifton Oliver Sent: Wednesday, May 25, 2005 3:52 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniBasic Line Continuation -- Regards, Clif On May 25, 2005, at 11:49 AM, Dana Baron wrote: Works in Unidata though: :ED RS.BP TEST A = 1 B = 2 C = A + | B * 2 PRINT C END :BASIC RS.BP TEST Compiling Unibasic: /unidata/SMUGGLER/AHS_SOURCE/RS_BP/TEST in mode 'p'. compilation finished :RUN RS.BP TEST 5 :LO Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Clifton Oliver Sent: Wednesday, May 25, 2005 1:28 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniBasic Line Continuation Apparently not on UniVerse: RELLEVEL 001 X 002 10.0.10 003 NEWACC 004 005 10.0.10 ED BP TEST 4 lines long. : D99 : I 0001= A = 1 0002= B = 2 0003= C = A + | 0004= B * 2 0005= END 0006= Bottom at line 5. : FI TEST filed in file BP. BASIC BP TEST Compiling: Source = 'BP/TEST', Object = 'BP.O/TEST' 03C = A + | ^ '|' unexpected, Was expecting: '*', '+', '-', '/', '', '[', '^' 04B * 2 ^ '*' unexpected, Was expecting: Assignment Operator 2 Errors detected, No Object Code Produced. On May 25, 2005, at 10:32 AM, Dana Baron wrote: The vertical bar (|) functions as a continuation character in UniBasic. Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill Sent: Wednesday, May 25, 2005 12:28 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] UniBasic Line Continuation In some mV implementations, there is a ... thing to help with code readability. Is there any way? We are on UV. --Bill --- 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] UniBasic Line Continuation
The vertical bar (|) functions as a continuation character in UniBasic. Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill Sent: Wednesday, May 25, 2005 12:28 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] UniBasic Line Continuation In some mV implementations, there is a ... thing to help with code readability. Is there any way? We are on UV. --Bill --- 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] Unidata on 64 bit
No - we don't provide a utility to recompile all user application programs. But recompiling all, or a subset, of Basic programs is very easy. Where Basic programs are stored in a directory referred to as BP: SELECT BP (WITH any criteria) BASIC BP 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] Unidata on 64 bit
We run Unidata 5.1 on a DEC Alpha with Tru64 unix. However, DEC - Compaq - HP has announced the end of life for the Alpha and Tru64 unix. Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, April 14, 2005 10:17 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata on 64 bit Hello all. Anyone running Unidata on a 64 bit OS? We are running Unidata 6.1.0.3 on AIX 5.2 32bit currently, but are interested in 64 bit. 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/
[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
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
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] Subroutine utility
Hi Kevin, I came to this thread late, but it looks interesting. Could you send me your CCE or the link to where its posted? Thanks, Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin King Sent: Wednesday, February 23, 2005 11:26 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Subroutine utility CCE was written ~15 years ago and I'm not sure if it was on an Ultimate or NCR, but either way it was an old, old implementation. If I knew back then... Anyway, it runs from a proc: 001 PQ 002 HRUN filename CCE 003 P This is the routine you were asking about, right? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jef Lee Sent: Wednesday, February 23, 2005 5:58 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Subroutine utility Me too please? Jef Lee IT Vision Level 3 Kirin Centre, 15 Ogilvie Road, APPLECROSS, WA 6153 Tel: (08) 9315 7000 Fax: (08) 9315 7088 P O Box 881, Canning Bridge, WA 6153 A.C.N. 068 914 867 --- 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 CCE] [demime 1.01d removed an attachment of type application/octet-stream which had a name of SENTENCE] [demime 1.01d removed an attachment of type application/octet-stream which had a name of OPTIONS] --- 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] Writeseq quirkiness - the answer
Greetings, And the prize goes to Kevin King! He came up with the write answer to solve my writeseq problem. Of course, he had an advantage since he helped write the application in the first place. Still, I was stumped and his answer worked. Thank you (once again!), Kevin. For those who care: To understand the solution, you need a little more background. The code segment I sent is part of an application that manages the interface between my Unidata application and a third-party device, which in turn manages the interface with a bunch of other devices. When I want to send data out of my application, I create a file with a .out extension and write the appropriately formatted data to the file. A program written by Kevin King sits out there looking for files with .out extensions. When it finds one, it reads the file and sends the data to the third-party device. It then deletes the file. And this is wherein lay the problem, and the solution. What was happening was, my program would open the file (OPENSEQ) and Kevin's program would come along and try to read it, then delete it, then I'd try to write to it (WRITESEQ), but by then it was gone. I changed the code a little bit to open the file with a .tmp extension, write to that, then rename it to .out. Works great! There are still a few mysteries: why does the original code work for just about every situation, then suddenly fail for one new situation that is seemly the same as all the others? But heck, it works so I'll go with it. Thanks to everyone who responded with a solution. And the u2 list comes through again! Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD]WRITESEQ quirkiness
Here's a puzzler: what is it that causes the ELSE clause to be executed in a WRITESEQ block when the only apparent change is the content of the data to be written. I've included a section of code below followed by the output from two subsequent calls. In the first, the code executes the THEN clause and prints SENDING... In the second, the ELSE clause is executed producing the ERROR WRITING... results. Any thoughts? Could it be that there is a limit to the size of the data that wan be written using WRITESEQ? This code segment: ** SAVE_MESSAGE_FILE: UNIX_DIR = /unidata/lodginglink/ SAVE_DIR = /unidata/lodginglink/save/ DATE_PART = DATE() TIME_PART = TIME() MSG_PART = UHLL.ITEMUHLL.TXN.ID.AMC : UHLL.ITEMUHLL.SEQ.NUM.AMC FILE_NAME = DATE_PART:TIME_PART:MSG_PART:.out OPENSEQ UNIX_DIR, FILE_NAME TO FILE_POINTER THEN OK_TO_CONTINUE = TRUE. END PRINT OPENSEQ STATUS IS : PRINT STATUS() MSG_HEX = OCONV(MSG_OUT,MX) WRITESEQ MSG_HEX ON FILE_POINTER THEN IF TRACE.ON THEN PRINT SENDING: : MSG_OUT END END ELSE PRINT ERROR WRITING PRINT ASCII MESSAGE IS : MSG_OUT PRINT HEX MESSAGE IS : MSG_HEX PRINT FILE NAME IS : FILE_NAME END CLOSESEQ FILE_POINTER SAVE_MESSAGE_FILE_EXIT: RETURN *** Produces this output: OPENSEQ STATUS IS 0 SENDING: ^B4519038^C1 OPENSEQ STATUS IS 0 ERROR WRITING ASCII MESSAGE IS ^B2544436008019DISHONGH, GEORGIA L1060091*1163482144001015100101740043801175003SY11770010^C0 HEX MESSAGE IS 02323534343430303030333639393939303038303139444953484F4E47482C2047454F524749 41204C313036303039312A313136333438323134343030313031353130303130313734303034 33383031313735303033535931313737303031300330 FILE NAME IS 13501458970036.out Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD]WRITESEQ quirkiness
Hi Kevin, Thanks for the reply. The data to be written is not very big. Its shown below. It is HEX data, don't know if that makes a difference. This has been working fine but suddenly its not, but only for one type of message, and I don't know what changed. These are the messages that I'm writing to be picked up by the java routine you wrote for us to move data from our Unidata system to another system. Only they're not getting written successfully by Unidata. There must be something odd about the data, though I can't see anything different. HEX MESSAGE IS 02323534343430303030333639393939303038303139444953484F4E47482C2047454F524749 41204C313036303039312A313136333438323134343030313031353130303130313734303034 33383031313735303033535931313737303031300330 Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD]Printing to Fargo card printers from UD
Does anyone have experience printing from Unidata to Fargo card printers, especially from Unix? Would you be willing to provide some assistance in getting started? Thanks, Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How is the voting going?
I think we're getting a great response. We currently have about 170 votes cast. After subtracting out those of us on the establishing board, that still leaves about 160 other people who are interested in what we're doing. Thanks! Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, October 05, 2004 10:58 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject:[U2] How is the voting going? I was wondering if you are getting a good response to the Charter voting. Jerry Banker --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How is the voting going?
Well, we still have about 5 days left in the voting period, so we may see another 800 votes, but I doubt it. In fact our turnout is roughly equivalent to the US election turnout you mentioned. While a 20% turnout for the US national elections is a pretty sad state of affairs, given the nature of this vote, that's actually pretty good. I'm just glad to find that there are at least a few people out there who think that what we're doing is valuable enough to pay some attention. And thanks again for your support. Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: U2 User's Group Charter
Bill, On the left-hand side of the home page, there is a group of links with the heading Main Menu. In that list you will find a link to the charter as the fourth (and last) item in the list. Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Tuesday, September 28, 2004 8:47 AM To: '[EMAIL PROTECTED]' Subject:RE: [U2] RE: U2 User's Group Charter Where exactly is the charter on the website? After logging in and after ten minutes of looking, I gave up. --Bill [demime 1.01d removed an attachment of type application/octet-stream which had a name of Brutzman, Bill.vcf] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UD] ODBC to UniData
Here's a look at our uci.config file. It doesn't have any database path information, just the four required fields. AHS2 DBMSTYPE = UNIDATA network = TCP/IP service = udserver host = xxx.xxx.xxx.xxx On our system, the database path information is kept on the Unidata server in a file called /usr/unidata/include/ud_database. Here's what that looks like: DATABASE=AHS UDTHOME=/unidata/ud5211 UDTACCT=/unidata/SMUGGLER/AHS_SQL TRACE_LEVEL=0 Do you have a ud_database file? Where is it and what are the permissions to get to it? Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata Personal Edition
Hi, This should be a simple question: how do I download UDPE? I went to the IBM website where I was informed that I could download UDPE, but I found no link and no instructions. On the TechConnect site I found a form to fill out to download UDPE. I filled out the form - twice - and still I did not get a link or instructions for download. I followed this up with a question in the Feedback area. I got a reply: Someone will get back to you shortly. That was five days ago. Hopefully someone on this list can point me in the right direction. Thanks Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata Personal Edition
Thanks Wally and Bob, I tried it again today and it worked. (I swear it didn't work (twice) last Friday). Anyway, I have it now. Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wally Terhune Sent: Tuesday, August 24, 2004 9:45 AM To: [EMAIL PROTECTED] Subject: Re: [U2] Unidata Personal Edition I just went thru the steps myself to test. PE download seems to be functioning fine at the moment. Wally Terhune Manager - U2 Advanced Technical Services IBM DB2 Information Management Software Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! Don't miss out on the IBM DB2 Information Management Technical Conference September 19-24, 2004 - Las Vegas, NV Dana Baron [EMAIL PROTECTED] m To Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] Unidata Personal Edition 08/24/2004 06:29 AM Please respond to u2-users Hi, This should be a simple question: how do I download UDPE? I went to the IBM website where I was informed that I could download UDPE, but I found no link and no instructions. On the TechConnect site I found a form to fill out to download UDPE. I filled out the form - twice - and still I did not get a link or instructions for download. I followed this up with a question in the Feedback area. I got a reply: Someone will get back to you shortly. That was five days ago. Hopefully someone on this list can point me in the right direction. Thanks Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic06017.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata 6 and Tru64
Nick, According to IBM the unaligned access message is normal and is disabled by adding uac p noprint to the user profile. We use Unidata 5.2 on Tru64 and I've never seen the unaligned access message you refer to and we don't have uac p noprint in the profile. Is this behavior specific to Unidata 6? Will we have issues if we ever upgrade to UD 6? I suppose these are questions more appropriately directed to IBM, but your experience has me wondering. Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] U2UG Needs You
Greetings, If you're on this e-mail list, you're probably at least vaguely aware of the existence of a nascent U2 users group. And if you're mildly curious, you may be asking yourself, and others, whatever happened to that group. Well there has been a lot going on behind the scenes. We have a founding board working to create an international organization with by-laws, elections and such. Here are some of the things the board has been doing so far, some visible, some not: 1. In May Clif Oliver handed over the management of this list to the U2UG. 2. There is a U2UG website: http://www.u2ug.org/ 3. The U2UG is organizing a general meeting to coincide with the IBM Data Management Conference in September (see the web site for details). 4. The board has been working on ways to share information about U2 beyond the lists and the web site. All of this with just 13 members of the founding board! And that's the reason for this message. We've reached the point where we need help. Your help. Here is a list of the volunteer opportunities available to you in helping to bring this valuable organization into a thriving existence. 1. Nominations committee - We need people to help run the nominating committee. They will help conduct an honest election. We need to begin this process by September 2004. 2. Web site help - help us manage the content on the web site. 3. We also need everyone to consider contributing content. We need your success stories, funny stories about the SORT verb, articles about multivalue database theory, whatever you have. 4. Newsletter - we need department editors and contributors. 5. U2 Promotion - We need people who are willing to put a U2UG member sticker and link on their home pages (personal and corporate) and otherwise promote these powerful products. Looking forward to your support, Dana Baron System Manager Smugglers' Notch Resort (and U2 Founding Board Member) P.S. - If you received two copies of this message its probably because you are a member of both the U2-community and U2-users lists. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/