RE: Uniobjects Asp
Nick, Depends on how you far you need to scale, and if you are looking to support large numbers of users. UniObjects is NOT thread safe, but you can roll your own connection pooling - ie. write your logic into a DLL that maintains a series of connections with some form of semaphoring, and call that from your ASP pages rather than calling UniObjects directly. There's something to be said for keeping your logic in a DLL anyway as ASP coding tends to fragment quite highly, and complex pages can be more of a pain to maintain than a complex DLL! Otherwise, your best bet is to use RedBack, which is designed explicitly to support the ASP model, and provides connection pooling and thread safety with a pretty decent level of performance and high scalability. We have put together a number of applications running across RedBack supporting large numbers of users for a local government, including call centres, billing and other fairly intensive applications and performance has not been an issue. Regards, Brian Leach -Original Message- From: Cooper, Rudy [mailto:[EMAIL PROTECTED] Sent: 26 February 2004 21:46 To: [EMAIL PROTECTED] Subject: Uniobjects Asp Hello Everyone, I have a requirement to use Asp with Uniobjects. Our OS is W2K and the backend is UV 10.0.10. I was thinking about creating ActiveX Dll's in VB6 that would do things like create a UV session, instantiate subr object, etc. I read in the u2-users list archive something to the effect of Uniobjects not being thread safe. Does that still hold true ? If so how do you make it thread safe ? thx, rudy -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users __ __ This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: mvQuery's MVQUERY_LOGIN MVQUERY_ABORT features
Denny, Please send any mvQuery questions to [EMAIL PROTECTED] - we'll be happy to help you out! I use MVQUERY_LOGIN and MVQUERY_ABORT (on UniVerse) frequently as a means of testing mvQuery by COMOing trace output and setting DATE.FORMAT. Here are my paragraphs: ED VOC MVQUERY_LOGIN 3 lines long. : p 0001: PA 0002: DATE.FORMAT ON 0003: STARTCOMO Bottom at line 3. ED VOC MVQUERY_ABORT 2 lines long. : p 0001: PA 0002: COMO OFF Bottom at line 2. If you are getting problems with these we'll need to know: a) which transport you are using (UniObjects or UniLink) b) which database you are using C) which version of mvQuery you are running (client and server) We have discovered that if you are using UniObjects against UniData, certain specific commands you might choose to put inside MVQUERY_LOGIN (notably DATE.FORMAT) are lost by the UniData environment (this relates to an issue with UniObjects). If this is your configuration there is a patch we can ship you. Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Denny Watkins Sent: 26 February 2004 21:20 To: [EMAIL PROTECTED] Subject: mvQuery's MVQUERY_LOGIN MVQUERY_ABORT features I'm trying to use the MVQUERY_LOGIN MVQUERY_ABORT features and just can't get them to work. Would any mvQuery users have any sample MVQUERY_LOGIN MVQUERY_ABORT paragraphs they could share with me? You can send them directly to me unless you feel some other mvQuery users could benefit. Thanks, Denny Watkins Director Computer Services Morningside College 1501 Morningside Ave Sioux City, Ia 51106-1717 Phone: 1-712-274-5250 Email: mailto:[EMAIL PROTECTED][EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users __ __ This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Redback vs Raining Data's .Net Data Provider
We are currently converting from IBM UniOLEDB to PDP and all the tests we've run so far suggest better concurrency and faster speeds. The increase of course is proportional to the complexity of what you want to do with it but I have no bad news as yet! Cheers Nick -Original Message- From: Mike Randall [mailto:[EMAIL PROTECTED] Sent: 27 February 2004 01:58 To: 'U2 Users Discussion List' Subject: Redback vs Raining Data's .Net Data Provider Being longtime Redback developers, we are about to evaluate Raining Data's .Net Data Provider. Anybody out there with any experience or comments about the product? Thanks, Mike Randall -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Universe File Corruption
Our system is running on UV 9.4.1.3B on SCO Unix 5.0.5. I have encoutered the following error message when I SELECT a file 'INVOICE' File /disk3/MYDATA/INVOICE Computed blink of 0x312e3134 does not match expected blink of 0x158800 Detected within group starting address 0x27e1e00 ! Internal data error. Anybody over there can tell me how can I fix the problem and save all data? Please describe details Thks TM -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Universe File Corruption
do you have this on the system anywhere ./usr/lpp/uv/bin/uvfixfile bob -Original Message- From: TELRIS MAN [mailto:[EMAIL PROTECTED] Sent: 27 February 2004 15:04 To: [EMAIL PROTECTED] Subject: Universe File Corruption Our system is running on UV 9.4.1.3B on SCO Unix 5.0.5. I have encoutered the following error message when I SELECT a file 'INVOICE' File /disk3/MYDATA/INVOICE Computed blink of 0x312e3134 does not match expected blink of 0x158800 Detected within group starting address 0x27e1e00 ! Internal data error. Anybody over there can tell me how can I fix the problem and save all data? Please describe details Thks TM -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ Confidentiality Notice: This e-mail and any attachments are intended solely for the addressee and may contain confidential or privileged information. If you are not the named addressee, or the person responsible for delivering the message to the named addressee, please notify the sender as soon as possible and delete the material from your computer. This message will be protected by copyright. If it has come to you in error, you must not take any action based on its contents nor must you copy or show the message to any person other than the intended recipient. __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Universe File Corruption
'uvfixfile' won't touch this (bitter experience speaking here). You really need fixtool and for that you'll need to have UV10.0.x (I think the 'x' is 15 or higher, not totally sure) or, even better, v10.1, installed. The versions of fixtool prior to that were not as sophisticated as the current one, which can actually (usually) successfully fix something like this. It can be fixed manually, but that would take a lot more than an email to spell out the details :-( and then only if you are extermely comfortable with bit buckets and reading/modifying hex values, etc. There have been emails on some of this before - search the archives. In the meantime, if you need it fixed fast, call Universe support and be prepared to pay a few hundred bucks. Gary Eppel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Friday, February 27, 2004 10:21 AM To: 'U2 Users Discussion List' Subject: RE: Universe File Corruption do you have this on the system anywhere ./usr/lpp/uv/bin/uvfixfile bob -Original Message- From: TELRIS MAN [mailto:[EMAIL PROTECTED] Sent: 27 February 2004 15:04 To: [EMAIL PROTECTED] Subject: Universe File Corruption Our system is running on UV 9.4.1.3B on SCO Unix 5.0.5. I have encoutered the following error message when I SELECT a file 'INVOICE' File /disk3/MYDATA/INVOICE Computed blink of 0x312e3134 does not match expected blink of 0x158800 Detected within group starting address 0x27e1e00 ! Internal data error. Anybody over there can tell me how can I fix the problem and save all data? Please describe details Thks TM -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ Confidentiality Notice: This e-mail and any attachments are intended solely for the addressee and may contain confidential or privileged information. If you are not the named addressee, or the person responsible for delivering the message to the named addressee, please notify the sender as soon as possible and delete the material from your computer. This message will be protected by copyright. If it has come to you in error, you must not take any action based on its contents nor must you copy or show the message to any person other than the intended recipient. __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE This message and any included attachments are from Cerner Corporation and are intended only for the addressee. The information contained in this message is confidential and may constitute inside or non-public information under international, federal, or state securities laws. Unauthorized forwarding, printing, copying, distribution, or use of such information is strictly prohibited and may be unlawful. If you are not the addressee, please promptly delete this message and notify the sender of the delivery error by e-mail or you may call Cerner's corporate offices in Kansas City, Missouri, U.S.A at (+1) (816)221-1024. -- -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Universe File Corruption
Or, assuming you have good backups, delete the file and restore it from backups -Original Message- From: Eppel,Gary [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 8:34 AM To: U2 Users Discussion List Subject: RE: Universe File Corruption 'uvfixfile' won't touch this (bitter experience speaking here). You really need fixtool and for that you'll need to have UV10.0.x (I think the 'x' is 15 or higher, not totally sure) or, even better, v10.1, installed. The versions of fixtool prior to that were not as sophisticated as the current one, which can actually (usually) successfully fix something like this. It can be fixed manually, but that would take a lot more than an email to spell out the details :-( and then only if you are extermely comfortable with bit buckets and reading/modifying hex values, etc. There have been emails on some of this before - search the archives. In the meantime, if you need it fixed fast, call Universe support and be prepared to pay a few hundred bucks. Gary Eppel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Friday, February 27, 2004 10:21 AM To: 'U2 Users Discussion List' Subject: RE: Universe File Corruption do you have this on the system anywhere ./usr/lpp/uv/bin/uvfixfile bob -Original Message- From: TELRIS MAN [mailto:[EMAIL PROTECTED] Sent: 27 February 2004 15:04 To: [EMAIL PROTECTED] Subject: Universe File Corruption Our system is running on UV 9.4.1.3B on SCO Unix 5.0.5. I have encoutered the following error message when I SELECT a file 'INVOICE' File /disk3/MYDATA/INVOICE Computed blink of 0x312e3134 does not match expected blink of 0x158800 Detected within group starting address 0x27e1e00 ! Internal data error. Anybody over there can tell me how can I fix the problem and save all data? Please describe details Thks TM -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ Confidentiality Notice: This e-mail and any attachments are intended solely for the addressee and may contain confidential or privileged information. If you are not the named addressee, or the person responsible for delivering the message to the named addressee, please notify the sender as soon as possible and delete the material from your computer. This message will be protected by copyright. If it has come to you in error, you must not take any action based on its contents nor must you copy or show the message to any person other than the intended recipient. __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE This message and any included attachments are from Cerner Corporation and are intended only for the addressee. The information contained in this message is confidential and may constitute inside or non-public information under international, federal, or state securities laws. Unauthorized forwarding, printing, copying, distribution, or use of such information is strictly prohibited and may be unlawful. If you are not the addressee, please promptly delete this message and notify the sender of the delivery error by e-mail or you may call Cerner's corporate offices in Kansas City, Missouri, U.S.A at (+1) (816)221-1024. -- -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: New Listserver on the air (or is U2 Community working?)
There have been at least 60 messages on U2 community since the Welcome Back message was sent. Karjala - Original Message - From: Kathy Tymoczko [EMAIL PROTECTED] To: U2 Community Discussion List [EMAIL PROTECTED] Sent: Friday, February 27, 2004 7:09 AM Subject: Re: New Listserver on the air Although I appear to be subscribed to the u2-community list, I don't think I've gotten any messages from that list since you switched mail list managers. Has there really been no traffic on that list for the last month? I am getting the messages from the u2-users list. At 03:10 AM 1/24/2004, you wrote: Welcome Back, everyone! The new list server is active for: datastage-users u2-community u2-users ... -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Universe File Corruption
Once upon a time, I repaired uniVerse files fairly often. I was taught by Mark Baldridge and later took a refresher course from Joel Yates. Fixing the file at v9.4.n.n (pre fixtool days) will require manual file work at the OS level using filepeek. Since filepeek doesn't prompt for errors, writing the wrong data can destroy the file. Incidently, if everyone is off the system and there are no processes running against the INVOICE file, uvfixfile may very well work just fine. It fails if there is any activity against the file. In later releases, uvfixfile wouldn't even run if there was file activity, similar to RESIZE. As for you question about not losing data, sometimes you don't lose data if the link is from a duplicate 'forward link' to 2 different groups. Fixing the Blink error will allow the hashing algorhythm for the correct group to be seen. There is a very real chance that you will lose the one record where the Blink error is and possibly the records that come after the error in the affected group. If the corrupt file is a type 30 file (dynamic on UV), then the repair is more difficult, but still relatively easy for someone with experience. Karl Pearson On Fri, 2004-02-27 at 08:04, TELRIS MAN wrote: Our system is running on UV 9.4.1.3B on SCO Unix 5.0.5. I have encoutered the following error message when I SELECT a file 'INVOICE' File /disk3/MYDATA/INVOICE Computed blink of 0x312e3134 does not match expected blink of 0x158800 Detected within group starting address 0x27e1e00 ! Internal data error. Anybody over there can tell me how can I fix the problem and save all data? Please describe details Thks TM -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 888-972-3182 x29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UniVerse to excel feeds
Hi All, We are looking for a process, where a report run in UniVerse can feed direct into excel, with no human action being taken - or as little as possible. If you have a process or tool where you can do this, and are willing to share this information, please e-mail. We are on UniVerse 10.0.19 and AIX 5.2 Thank you in advance for your suggestions. Thanks and have a great day! Donald H. Cutting A. N. Deringer, Inc. D. B. A. / Systems Analyst Tel. (802)524-8172 Fax. (802)524-8297 www.anderinger.com Our Service Recommends Us! -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UniVerse to excel feeds [AD]-ish
Don, We have a tool which can be automated to pull data at a specified time (or multiple times) from UniVerse and push it out in CSV (which can be read directly by excel). If that's a close enough fit, let me know. The product is called Zeus Data Integration and it retails for less than $1K. - Charles Barouch [EMAIL PROTECTED] Don Cutting wrote: Hi All, We are looking for a process, where a report run in UniVerse can feed direct into excel, with no human action being taken - or as little as possible. If you have a process or tool where you can do this, and are willing to share this information, please e-mail. We are on UniVerse 10.0.19 and AIX 5.2 Thank you in advance for your suggestions. Thanks and have a great day! Donald H. Cutting A. N. Deringer, Inc. D. B. A. / Systems Analyst Tel. (802)524-8172 Fax. (802)524-8297 www.anderinger.com Our Service Recommends Us! -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse to excel feeds
Well, here is one way, given you are running Unix and want to use windows... If you just want to load data into Excel and you only want to do this on one windows machine. There is a lpd/lpr daemon program I use (www.brooksnet.com) called RPM which when setup on a windows machine, looks like a remote printer to unix. It has the ability to take a print job, and force-feed it into an application. You can set it up so it will stick put an .csv extension on the temp file (print job) it receives and will then launch Excel, which will in turn read the data and display it. On the unix side, you just create a ASCII csv file and print it to the remote printer. As discussed earlier, if you use XML, then you can get excel (newer versions) to do a bit of formatting as well, just change the lpd/lpr program to add an .xml extension. This is fairly low cost solution (I think a single license is about $100-150.00) If you want this on mulitple machines, a different method might be to write a small PERL program that runs as a service on windows, that when it receives a file via sockets, it then launches excel with that file. Have a Unix side first determine IP of requesting machine (another discussion :)) and open a socket to that IP and send the data to the PERL program. George -Original Message- From: Don Cutting [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 11:22 AM To: U2 Users Discussion List Subject: UniVerse to excel feeds Hi All, We are looking for a process, where a report run in UniVerse can feed direct into excel, with no human action being taken - or as little as possible. If you have a process or tool where you can do this, and are willing to share this information, please e-mail. We are on UniVerse 10.0.19 and AIX 5.2 Thank you in advance for your suggestions. Thanks and have a great day! Donald H. Cutting A. N. Deringer, Inc. D. B. A. / Systems Analyst Tel. (802)524-8172 Fax. (802)524-8297 www.anderinger.com Our Service Recommends Us! -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Printing to local printer
In a message dated 2/26/2004 12:07:35 PM Pacific Standard Time, [EMAIL PROTECTED] writes: We use AUX ON / AUX OFF for local printers already. The problem is, we want to be able to specify which local printer to use as the AUX. So, when the user is printing a CC receipt, it would print to the printer attached to the PC that is defined as the CC receipt printer. But, when the user is trying to print a report, it would print to the local laser printer (which could also be a networked printer). One way to do this is to have the user switch the local printer within SmartTerm, but we wanted to try to handle this in the software, if possible, because...well, you know how users are. Dana I'm a little confused. You are using local printers using Aux on/Aux off. This means that the printer must be directly connected to the terminal/PC right? So I thought it sounded like you wanted to have two printers directly attached to one terminal/PC. If this is *not* what you want to do, then why not just network all your printers? If it *is* what you want, you also have the option of using two serial ports off your terminal/PC. Some terminals have two serial and one parallel port as well. And for PCs you can always add another serial or parallel card to add another port. So can you tell us how many CC printers you have, and can each device that needs to print to one have its own? Or do you have something like 100 terminals wanted to print and only 12 CC printers? Thanks Will Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Uniobjects Asp
Does anyone know if Uniobjects.net will be thread safe ? thx, rudy From: Cooper, Rudy [mailto:[EMAIL PROTECTED] Sent: 26 February 2004 21:46 To: [EMAIL PROTECTED] Subject: Uniobjects Asp I have a requirement to use Asp with Uniobjects. Our OS is W2K and the backend is UV 10.0.10. I was thinking about creating ActiveX Dll's in VB6 that would do things like create a UV session, instantiate subr object, etc. I read in the u2-users list archive something to the effect of Uniobjects not being thread safe. Does that still hold true ? Date: Thu, 26 Feb 2004 23:08:23 - From: Nick Southwell [EMAIL PROTECTED] Subject: RE: Uniobjects Asp No. Let me try and prevent the pain I had to go through. We avoided Uniobjects because by design its use is for client/server -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse to excel feeds
Don: I have written a program called BEXCEL which takes in a command, formats a csv file, and then uses an ftp process (we have pi/open on hpux) to send this file to a place where the users can open it. For example, the command BEXCEL INMATE | LNAME FNAME MNAME DOB AKA.LN AKA.FN | IRPT1 | ALL | Y reads the INMATE file then outputs a file named myloginIRPT1.csv with columns LNAME, FNAME, MNAME, DOB, AKA.LN, and AKA.FN to the designated network site via an ftp transfer. The AKA fields are multivalued and are handled. All records were selected, but in the place of 'ALL' one could have put the name of a select list. The final parameter Y means to put a space between records in the csv file. I have the companion programs HEXCEL, which outputs a .htm file for your browser and has additional parameters to specify headlines, and TEXCEL which is the interactive version where users enter file name, fields desired, etc for Ad Hoc reporting. I have embedded calls to BEXCEL in a few programs (send report to Excel) and it works fine. There is a little 'local' coding in each of these, but I will be happy to take that code out. You do need to set up a couple of VOC entries (easy) and also set up the ftp process to get the file automatically sent to the desired network directory (I needed my network guys to do this for me). Free if you would like to take a look. Harold Oaks Don Cutting wrote: Hi All, We are looking for a process, where a report run in UniVerse can feed direct into excel, with no human action being taken - or as little as possible. If you have a process or tool where you can do this, and are willing to share this information, please e-mail. We are on UniVerse 10.0.19 and AIX 5.2 Thank you in advance for your suggestions. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Universe File Corruption
I keep pushing it but The UniVerse Internals course teaches you how to repair files for yourself. The cost of the course is far lower than IBM's standard minimum charge for fixing a file for you so it's money well spent. The next Internals course in the UK is scheduled for the week starting 15 March but will only run if there is sufficient interest. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Uniobjects Asp
From documentation I have seen Uniobjects.net will be thread safe, however I have not heard anything recently regarding a release date. Does anyone have any update on when this will be available? Greg snip Does anyone know if Uniobjects.net will be thread safe ? snip thx, rudy -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse to excel feeds
For an example of what's possible, see these links: http://Nebula-RnD.com/products/analysis.htm http://Nebula-RnD.com/demos/nebulanalysis/ (audio/video presentation) Unattended, all Pick BASIC, no CSV files or XML or other file I/O or translations, full formatting with charts and all other features of Excel. Internally I've written a COM-AddIn for Excel that listens for socket calls and processes the requests - that's a fast and direct pipe, no intermediate formatting. Another benefit of this is that many users in an office can share a single copy of Excel on a given host, or the MV server can use the Excel that's on the MV client PC. NebulAnalysis is not being offered over U2 at this time as a product but I am willing to implement the features as a service. It's been a long time since I've done anything with this, honestly because most people are quite happy with the traditional mess of writing a CSV, doing some manual import, then manually reformatting after they've done the import. In a world where people want everything automated I really don't understand this intense desire to do everything manually with Excel. Inquiries welcome. Tony, Nebula RD [EMAIL PROTECTED] (Moderator for Spectrum, Las Vegas) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Cutting Sent: Friday, February 27, 2004 8:22 AM To: U2 Users Discussion List Subject: UniVerse to excel feeds Hi All, We are looking for a process, where a report run in UniVerse can feed direct into excel, with no human action being taken - or as little as possible. If you have a process or tool where you can do this, and are willing to share this information, please e-mail. We are on UniVerse 10.0.19 and AIX 5.2 Thank you in advance for your suggestions. Thanks and have a great day! Donald H. Cutting A. N. Deringer, Inc. D. B. A. / Systems Analyst Tel. (802)524-8172 Fax. (802)524-8297 www.anderinger.com Our Service Recommends Us! -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
When is developing with UniObjects the correct approach?
Can someone lay out, in relatively simple terms for a simple guy, when using UniObjects is the correct approach to developing an application using one of the U2 databases? And, perhaps, when UniObjects would seem attractive but is not, in reality, a good choice? And, yes, I am sure that reality has lots of 'it depends ...'. Thanks, Karjala -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: When is developing with UniObjects the correct approach?
From my experience, I really haven't encountered a situation where I'd recomment not using UniObjects when accessing a U2 database from an outside application. I've heard people say you shouldn't use it directly from ASP because of threading issues, but I've successfully gotten around that by insulating the UniObjects objects within my own COM objects. ASP calls my COM object, my COM objects creates a UniObjects object, does what it needs, closes and releases the object, life is good. I've never even actually tried instantiating the UniObjects directly from ASP to know for sure it's a problem...just went with what others had told me. For straight data access where ODBC is fine, UniData's ODBC works fine. It's just a bit of a PITA to set up initially. I think the biggest benefit of using UniObjects is the ability to utilize existing subroutines in your U2 system. Even going forward, I find it easier to do a lot of my business rules in U2 subs and call those subs from UniObjects. Makes for a pretty elegant n-tiered development environment. Anyway, that's my $.02 -Original Message- From: Karjala Koponen [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 1:45 PM To: [EMAIL PROTECTED] Subject: When is developing with UniObjects the correct approach? Can someone lay out, in relatively simple terms for a simple guy, when using UniObjects is the correct approach to developing an application using one of the U2 databases? And, perhaps, when UniObjects would seem attractive but is not, in reality, a good choice? And, yes, I am sure that reality has lots of 'it depends ...'. Thanks, Karjala -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse to excel feeds
Don: If you have wIntegrate, terminal emulation and host-based application, you can accomplish your task. I did, but it was about five years ago. Maybe a current wIntegrate user could chime in. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 27, 2004 11:47 AM To: [EMAIL PROTECTED] Subject: RE: UniVerse to excel feeds Don: I have written a program called BEXCEL which takes in a command, formats a csv file, and then uses an ftp process (we have pi/open on hpux) to send this file to a place where the users can open it. For example, the command BEXCEL INMATE | LNAME FNAME MNAME DOB AKA.LN AKA.FN | IRPT1 | ALL | Y reads the INMATE file then outputs a file named myloginIRPT1.csv with columns LNAME, FNAME, MNAME, DOB, AKA.LN, and AKA.FN to the designated network site via an ftp transfer. The AKA fields are multivalued and are handled. All records were selected, but in the place of 'ALL' one could have put the name of a select list. The final parameter Y means to put a space between records in the csv file. I have the companion programs HEXCEL, which outputs a .htm file for your browser and has additional parameters to specify headlines, and TEXCEL which is the interactive version where users enter file name, fields desired, etc for Ad Hoc reporting. I have embedded calls to BEXCEL in a few programs (send report to Excel) and it works fine. There is a little 'local' coding in each of these, but I will be happy to take that code out. You do need to set up a couple of VOC entries (easy) and also set up the ftp process to get the file automatically sent to the desired network directory (I needed my network guys to do this for me). Free if you would like to take a look. Harold Oaks Don Cutting wrote: Hi All, We are looking for a process, where a report run in UniVerse can feed direct into excel, with no human action being taken - or as little as possible. If you have a process or tool where you can do this, and are willing to share this information, please e-mail. We are on UniVerse 10.0.19 and AIX 5.2 Thank you in advance for your suggestions. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[UV] XML conversion in UV 10.1
We're planning a platform migration to UV 10.1 and hope to utilize the built-in XML functionality to exchange data with our trading partners. From what I read on the IBM U2 site it appears that XML can be created from standard UV files in 10.1. Are there also tools that enbable data to go the other direction - from XML to a standard UV file? Sorry if I'm not being specific enough, but I'm a newbie to XML. Also, since UV 10.1 has not been ported to our chosen platform yet, can anyone recommend an XML to CSV parsing tool? I'm looking for something that can be run in batch mode, preferably on a unix server. Thanks, John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] XML conversion in UV 10.1
Not sure about Unix tools but Excel 2003 is fully XML aware. Going from XML to CSV is as simple as Save As. If you are into .Net, Microsoft has introduced a very power API called Visual Studio Tools for Office that will allow full programmatic control over Excel (Word too) from within VB.Net. Smooth and easy automation. Through Redback into the mix and Excel/Word take on new life from .Net in regards to using them with U2 data. Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Hester Sent: Friday, February 27, 2004 3:41 PM To: U2 Users Discussion List Subject: [UV] XML conversion in UV 10.1 We're planning a platform migration to UV 10.1 and hope to utilize the built-in XML functionality to exchange data with our trading partners. From what I read on the IBM U2 site it appears that XML can be created from standard UV files in 10.1. Are there also tools that enbable data to go the other direction - from XML to a standard UV file? Sorry if I'm not being specific enough, but I'm a newbie to XML. Also, since UV 10.1 has not been ported to our chosen platform yet, can anyone recommend an XML to CSV parsing tool? I'm looking for something that can be run in batch mode, preferably on a unix server. Thanks, John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UDCS sessions
Hi all - We are a Unidata site just bringing up WebAdvisor. I have seen udcs sessions hang out in the listuser listing for hours. We have our unirpcservices set to: udcs /usr/ud60/bin/udapi_server * TCP/IP 0 3600 Why do they hang out? How do I tell if someone is connected to the session before I stop it? Bill Pizer Assistant Director of MIS and Benefactor System Administrator The Sage Colleges 45 Ferry St Troy, NY 12180 518-244-2087 518-244-2085 (fax) Forgot your SageNet/CampusCruiser/Blackboard password? You can now visit a href=http://www.sage.edu/password/; http://www.sage.edu/password//a -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse to excel feeds
I have a subroutine that works with both Accuterm and Wintegrate. It's fairly easy to integrate into an existing report. You can put column headings, set column widths, add formulas, multiple sheets, multiple books. It does quite a bit. I'd be glad to share it with the group if somebody would tell me where to put it. I should also put an example of a program that calls it. Let me know. Ronnie -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce McAdoo Sent: Friday, February 27, 2004 3:26 PM To: 'U2 Users Discussion List' Subject: RE: UniVerse to excel feeds Don: If you have wIntegrate, terminal emulation and host-based application, you can accomplish your task. I did, but it was about five years ago. Maybe a current wIntegrate user could chime in. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 27, 2004 11:47 AM To: [EMAIL PROTECTED] Subject: RE: UniVerse to excel feeds Don: I have written a program called BEXCEL which takes in a command, formats a csv file, and then uses an ftp process (we have pi/open on hpux) to send this file to a place where the users can open it. For example, the command BEXCEL INMATE | LNAME FNAME MNAME DOB AKA.LN AKA.FN | IRPT1 | ALL | Y reads the INMATE file then outputs a file named myloginIRPT1.csv with columns LNAME, FNAME, MNAME, DOB, AKA.LN, and AKA.FN to the designated network site via an ftp transfer. The AKA fields are multivalued and are handled. All records were selected, but in the place of 'ALL' one could have put the name of a select list. The final parameter Y means to put a space between records in the csv file. I have the companion programs HEXCEL, which outputs a .htm file for your browser and has additional parameters to specify headlines, and TEXCEL which is the interactive version where users enter file name, fields desired, etc for Ad Hoc reporting. I have embedded calls to BEXCEL in a few programs (send report to Excel) and it works fine. There is a little 'local' coding in each of these, but I will be happy to take that code out. You do need to set up a couple of VOC entries (easy) and also set up the ftp process to get the file automatically sent to the desired network directory (I needed my network guys to do this for me). Free if you would like to take a look. Harold Oaks Don Cutting wrote: Hi All, We are looking for a process, where a report run in UniVerse can feed direct into excel, with no human action being taken - or as little as possible. If you have a process or tool where you can do this, and are willing to share this information, please e-mail. We are on UniVerse 10.0.19 and AIX 5.2 Thank you in advance for your suggestions. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse to excel feeds
Sounds like a great tool Ronnie. http://www.PickSource.com is a great place for stuff like this. I'll be happy to host it at http://Nebula-RnD.com/freeware, just e-mail me a zip, and please include a ReadMe. Good luck in any case. Tony Nebula RD -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ronnie Adams Sent: Friday, February 27, 2004 8:28 PM To: 'U2 Users Discussion List' Subject: RE: UniVerse to excel feeds I have a subroutine that works with both Accuterm and Wintegrate. It's fairly easy to integrate into an existing report. You can put column headings, set column widths, add formulas, multiple sheets, multiple books. It does quite a bit. I'd be glad to share it with the group if somebody would tell me where to put it. I should also put an example of a program that calls it. Let me know. Ronnie -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce McAdoo Sent: Friday, February 27, 2004 3:26 PM To: 'U2 Users Discussion List' Subject: RE: UniVerse to excel feeds Don: If you have wIntegrate, terminal emulation and host-based application, you can accomplish your task. I did, but it was about five years ago. Maybe a current wIntegrate user could chime in. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 27, 2004 11:47 AM To: [EMAIL PROTECTED] Subject: RE: UniVerse to excel feeds Don: I have written a program called BEXCEL which takes in a command, formats a csv file, and then uses an ftp process (we have pi/open on hpux) to send this file to a place where the users can open it. For example, the command BEXCEL INMATE | LNAME FNAME MNAME DOB AKA.LN AKA.FN | IRPT1 | ALL | Y reads the INMATE file then outputs a file named myloginIRPT1.csv with columns LNAME, FNAME, MNAME, DOB, AKA.LN, and AKA.FN to the designated network site via an ftp transfer. The AKA fields are multivalued and are handled. All records were selected, but in the place of 'ALL' one could have put the name of a select list. The final parameter Y means to put a space between records in the csv file. I have the companion programs HEXCEL, which outputs a .htm file for your browser and has additional parameters to specify headlines, and TEXCEL which is the interactive version where users enter file name, fields desired, etc for Ad Hoc reporting. I have embedded calls to BEXCEL in a few programs (send report to Excel) and it works fine. There is a little 'local' coding in each of these, but I will be happy to take that code out. You do need to set up a couple of VOC entries (easy) and also set up the ftp process to get the file automatically sent to the desired network directory (I needed my network guys to do this for me). Free if you would like to take a look. Harold Oaks Don Cutting wrote: Hi All, We are looking for a process, where a report run in UniVerse can feed direct into excel, with no human action being taken - or as little as possible. If you have a process or tool where you can do this, and are willing to share this information, please e-mail. We are on UniVerse 10.0.19 and AIX 5.2 Thank you in advance for your suggestions. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse to excel feeds
you're also quite welcome to post it to http://www.pickwiki.com along with any docs you might have. the more, the merrier! -Original Message- From: Tony Gravagno [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 8:41 PM To: 'U2 Users Discussion List' Subject: RE: UniVerse to excel feeds Sounds like a great tool Ronnie. http://www.PickSource.com is a great place for stuff like this. I'll be happy to host it at http://Nebula-RnD.com/freeware, just e-mail me a zip, and please include a ReadMe. Good luck in any case. Tony Nebula RD -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ronnie Adams Sent: Friday, February 27, 2004 8:28 PM To: 'U2 Users Discussion List' Subject: RE: UniVerse to excel feeds I have a subroutine that works with both Accuterm and Wintegrate. It's fairly easy to integrate into an existing report. You can put column headings, set column widths, add formulas, multiple sheets, multiple books. It does quite a bit. I'd be glad to share it with the group if somebody would tell me where to put it. I should also put an example of a program that calls it. Let me know. Ronnie -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce McAdoo Sent: Friday, February 27, 2004 3:26 PM To: 'U2 Users Discussion List' Subject: RE: UniVerse to excel feeds Don: If you have wIntegrate, terminal emulation and host-based application, you can accomplish your task. I did, but it was about five years ago. Maybe a current wIntegrate user could chime in. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 27, 2004 11:47 AM To: [EMAIL PROTECTED] Subject: RE: UniVerse to excel feeds Don: I have written a program called BEXCEL which takes in a command, formats a csv file, and then uses an ftp process (we have pi/open on hpux) to send this file to a place where the users can open it. For example, the command BEXCEL INMATE | LNAME FNAME MNAME DOB AKA.LN AKA.FN | IRPT1 | ALL | Y reads the INMATE file then outputs a file named myloginIRPT1.csv with columns LNAME, FNAME, MNAME, DOB, AKA.LN, and AKA.FN to the designated network site via an ftp transfer. The AKA fields are multivalued and are handled. All records were selected, but in the place of 'ALL' one could have put the name of a select list. The final parameter Y means to put a space between records in the csv file. I have the companion programs HEXCEL, which outputs a .htm file for your browser and has additional parameters to specify headlines, and TEXCEL which is the interactive version where users enter file name, fields desired, etc for Ad Hoc reporting. I have embedded calls to BEXCEL in a few programs (send report to Excel) and it works fine. There is a little 'local' coding in each of these, but I will be happy to take that code out. You do need to set up a couple of VOC entries (easy) and also set up the ftp process to get the file automatically sent to the desired network directory (I needed my network guys to do this for me). Free if you would like to take a look. Harold Oaks Don Cutting wrote: Hi All, We are looking for a process, where a report run in UniVerse can feed direct into excel, with no human action being taken - or as little as possible. If you have a process or tool where you can do this, and are willing to share this information, please e-mail. We are on UniVerse 10.0.19 and AIX 5.2 Thank you in advance for your suggestions. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users