[U2] Solonde Warehouse Workbench for u2
A friend of mine is evaluating ETL tools that might be useful for developing and maintaining an MS-SQL-based data warehouse where one major data source is u2-based. My friend is probably going to use DTS (recently renamed as SSIS in MS-SQL-2005), and is also evaluating some well known tools such as Altova MapForce, and some little known tools, such as from Solonde. The Solonde WWB looks interesting, but the company's small size and lack of marketing fail to inspire confidence, and may prevent corporate HQ from approving them as a vendor. On the other hand, they do have some notable client sites in Germany. Anybody care to share their Solonde experience, either here in public, or privately, off-line? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY: This communication, including attachments, is for exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, or distribution or the taking of any action in reliance upon this information is strictly prohibited. If you are not the intended recipient, please notify the sender immediately and delete this communication and destroy all copies. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Catastrophe in realloc
The release notes for Universe 9.5.2 mention that error message as the symptom of a GTAR that was supposedly fixed as of 9.5.2. Which version of 9.6 are you running? Also, if you're not getting the error message on your test system that might be related to system load and/or to different hardware, and/or to different configuration. Do you have enough paging space on your production system? (Maybe malloc is failing.) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Hutchings Sent: Wednesday, January 26, 2005 9:48 AM To: u2-users@listserver.u2ug.org Subject: [U2] Catastrophe in realloc Running on AIX 4.3.3, Universe 9.6 I have a job processing a sequential file in HOLD. It processes about a third of the file then halts with the error Catastrophe in realloc: invalid storage prointer IOT/Abort trap. I have looked through the probrams and files and nothing seems to be wrong. I was able to successfully process the file on our test system which runs on a separate server, same AIX, same Universe revisions. Does anyone recognize this error and can point me in a direction? Thanks, Ron --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY: This communication, including attachments, is for exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, or distribution or the taking of any action in reliance upon this information is strictly prohibited. If you are not the intended recipient, please notify the sender immediately and delete this communication and destroy all copies. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Trending numbers...
This might be a question for the *other* kind of Universe database - - a Business Objects database. Your stock market analogy might be valid. Another good analogy might be weather forecasting. As with stocks, some goods and services are naturally counter-cyclical or super-cyclical, so their doing better or worse than an index isn't what matters - - what matters is whether they're trending better or worse than predicted by your economic forecasting model. To see if a stock is moving in an unexpected way, for instance, you might correlate it against some index, and then see if the stock is more than one or two standard deviations away from expected. That just raises more questions, of course: Is the fluctuation merely stochastic? Or is there a fundamental reason for it? And as with stock market analysis, you may need to strengthen your signal-to-noise ratio by using moving averages instead of just looking at daily upticks and downticks. The modeling and forecasting of economic behavior can be a lot of fun. Pick BASIC might not be the best way to do it. You say your process is SLLLOWWW. How slow? Care to share any code snippets? Maybe your algorithms are okay but your data structures are a problem. For instance, if you're repeatedly updating a number stored in a dynamic array, then you're implicitly doing a lot of variable- type recasting, and that could be a problem. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY: This communication, including attachments, is for exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, or distribution or the taking of any action in reliance upon this immediately and delete this communication and destroy all copies. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] No Subject
What kind of web service provider and/or consumer do you want to create? (Unidata can be a server and/or a client.) *** Your other questions: You didn't specify Solaris/SPARC or Solaris/Intel. Yes, Unidata 6.1 is available for Solaris 7, 8, and 9 on Sun SPARC chips. If you're using the Intel chip version of Solaris, then you won't have IBM's blessing, or support, but you should be able to use the RedHat Linux version of Unidata, and the Linux compatibility option in Solaris. Click here http://ibm.com/software/data/u2/unidata for answers to most of your Unidata questions. Click here http://ibm.com/software/data/u2/unidata/ud61-ann.html for new features in Unidata 6.1. Click here http://publibfi.boulder.ibm.com/epubs/html/25124550/25124550.zip for the complete set of UDT reference manuals * 70 megabytes * Click here http://ibm.com/software/data/u2/support/u2techconnect for the main tech support page for Universe and Unidata, where you can click on product availability and see details about supported Linux kernel versions etc. (You're probably okay on kernel 2.4.20 or higher.) -Original Message- From: George Smith [mailto:[EMAIL PROTECTED] Sent: Friday, November 19, 2004 9:10 AM To: [EMAIL PROTECTED] Subject: Hi all, 1.Will Unidata 6.1 run on Solaris and/or Linux. 2.If you run on the above with the .Net client talk to the server running on the Solaris/Linux. 3.Where can I find so info on web services on Unidata 6.1 thanks George R Smith Programmer / Analyst 479.684.3382 direct 479.684.3403 fax www.budgetext.com http://www.budgetext.com/ CONFIDENTIALITY NOTICE: The materials in this electronic mail transmission (including all attachments) are private and confidential and are the property of the sender. The information contained in the material is privileged and is intended only for the use of the named addressee(s). If you are not the intended addressee, be advised that any unauthorized disclosure, copying, distribution or the taking of any action in reliance on the contents of this material is strictly prohibited. If you received this electronic mail message in error, please immediately notify the sender by telephone at 888-869-0366 or send an electronic message to [EMAIL PROTECTED], and thereafter, destroy the electronic message immediately. [demime 1.01d removed an attachment of type image/gif which had a name of image001.gif] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY: This communication, including attachments, is for exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, or distribution or the taking of any action in reliance upon this immediately and delete this communication and destroy all copies. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OT MV-Base
Are you doing a STOP and exiting to mvBase TCL? In UDT or UV, exiting to TCL would close all of your open o/s file handles, unless they were opened to labeled COMMON, but maybe mvBase doesn't work that way, for some reason. Did you try the mvBase UCLOSE statement? Did you try doing UOPEN to re-open the same filevariable but to a different file, which should force a close of the old file? -Original Message- From: Mark Johnson [...] MVbase running on W2k. UOPEN, UCREATE, UREAD, UWRITE etc. [...] process is complete and file should be available, you get an 'access denied' message that indicates that MVterm still 'owns' the PC file. Only by logging off and closing MVterm does the PC file become available. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY: This communication, including attachments, is for exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, or distribution or the taking of any action in reliance upon this immediately and delete this communication and destroy all copies. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UPS EDI 240 Solution
If you're looking for a u2-based solution, go to http://www.parcelshippingsystem.com and scroll down to New PSS Options and click on Delivery Confirmation and see if that might be something like what you want. Software Co-Op's customers speak quite favorably about PSS and about the people at Software Co-Op. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY: This communication, including attachments, is for exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, or distribution or the taking of any action in reliance upon this immediately and delete this communication and destroy all copies. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData UniCode??????????
Have you reviewed the UniData International reference manual? Reference manuals are at http://ibm.com/software/data/u2/pubs/library However, the manuals may not answer your question. For singly byte characters, the character set isn't really a database option. The character set is a terminal emulator (telnet client) option, and if you're lucky then everybody has been using the same character set, but you might be unlucky. I've seen databases where people from different countries were using different single byte character sets, but all updating the same database, with the result that no single character set could correctly list all the data in the database. I've also seen files that contained a mixture of ISO single byte character sets and Windows character sets and PC-DOS (different from Windows!) character sets. Multibyte character sets are another matter, and you should review the UniData International reference manual if you are using multibyte characters. -Original Message- From: Fawaz Ashraff Good Morning, Can any one of you tell me what character encoding unidata uses by default? Windows uses Unicode 1252 as its standard, do we know what unidata uses? Im trying to decode characters using ascii values, but they are not matching up. If I know the codeset then I will have a better chance at matching them. Any ideas? Thanks, Fawaz --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY: This communication, including attachments, is for exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, or distribution or the taking of any action in reliance upon this immediately and delete this communication and destroy all copies. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Typo leads to discovery of new feature
The general argument for rejecting a pattern of digits ending with a decimal point and not followed by any decimal places (e.g. 10.) is that such a pattern often indicates a typo. The argument for accepting such a pattern, representing an integer constant, is that we've always done it that way. I don't favor a change to the representation of numeric constants, but I'd favor a change to the BASIC compiler to eliminate the implicit FMT. The implicit FMT has historically been more costly than beneficial, and still is so. The compiler would catch more typos if the absence of an operator between 2 expressions were always flagged as an error. -Original Message- From: Barry Brevik [...] what seems odd to me is the . [...] UV accepts 10. to be the same as 10.0 or 10. Barry --- 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] JetDirect on HP-UX/HP9000
You probably don't need to use a target depot. Just install from the source depot (SD) file. Before you install a new version of JetDirect, use swlist to see if there's an old version, and, if so, use swremove to remove the old version. For more info, see http://www.hp.com/go/hppi_sw --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY: This communication, including attachments, is for exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, or distribution or the taking of any action in reliance upon this immediately and delete this communication and destroy all copies. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData index sort oddness
DESC is a keyword for the CREATE INDEX command in SQL. Try renaming your DESC attribute. -Original Message- From: Karjala Koponen CREATE.INDEX JOB CONO fourteen other fields DESC Karjala --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY: This communication, including attachments, is for exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, or distribution or the taking of any action in reliance upon this immediately and delete this communication and destroy all copies. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate keep-alives - we need this feature
For Keep-Alive problems, try using Ethereal to discover whether a firewall is the problem. If you're using the Cisco VPN client version 3.x, you must UNCHECK the stateful firewall option. You'd expect better from Cisco, but the firewall inside their VPN client is from ZoneLabs and the Cisco/ZoneAlarm firewall is surprisingly stupid and will block all the keep-alive packets. Luckily, you can disable the firewall option. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY: This communication, including attachments, is for exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, or distribution or the taking of any action in reliance upon this immediately and delete this communication and destroy all copies. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Comparison Unidata and Universe
I wrote: -Original Message- From: Rosenberg Ben UniVerse BASIC does have some ULT features (for example, ULT EXECUTE syntax) which are missing from UniVerse BASIC. Oops. I meant to say that UniVerse BASIC has some ULT features that are missing from *** UniData UniBASIC ***. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this e-mail message may be privileged and confidential information and is intended only for the use of the individual and/or entity identified in the alias address of this message. If the reader of this message is not the intended recipient, or an employee or agent responsible to deliver it to the intended recipient, you are hereby requested not to distribute or copy this communication. If you have received this communication in error, please notify us immediately by telephone or return e-mail and delete the original message from your system. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Comparison Unidata and Universe
Please post follow-ups to the U2-Community list. The two primary authorities on the origin of the letters NT are Dave Cutler and Mark Lucovsky. Dave Cutler has confirmed the WNT = VMS incremented urban legend, but Cutler's confirmation isn't very credible, and is probably one of his noted pranks. The credible, but much less fun, story is the version told by Mark Lucovsky, who says that NT meant N ten architecture, and refers to the RISC chip which was the original platform for NT OS/2 before moving to the x86 platform. Lucovsky's story is far more credible than Cutler's because the letters NT were being used in NT OS/2 *before* the product name was changed to Windows NT. Here's a nice little introduction to the world of Messrs Cutler and Lucovsky. Re-assemble the URL below (assuming it gets split into 2 lines by my email program.) http://www.microsoft.com/windows2000/server/evaluation/news/fromms/kanoarchi tect.asp -- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this e-mail message may be privileged and confidential information and is intended only for the use of the individual and/or entity identified in the alias address of this message. If the reader of this message is not the intended recipient, or an employee or agent responsible to deliver it to the intended recipient, you are hereby requested not to distribute or copy this communication. If you have received this communication in error, please notify us immediately by telephone or return e-mail and delete the original message from your system. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Listfile on Universe
No, the standard LISTF command doesn't have a cache and there's nothing for you to rebuild. You may want to have your sysadmin run the CLEAN.ACCOUNT verb to purge the obsolete F pointers from your VOC file. In a uniVerse account with a PICK-flavored or REALITY-flavored VOC, LISTFILES is a standard synonym for the uniVerse LISTF command. Somebody could have modified LISTFILES or LISTF on your machine. But probably not, and here's approximately what you should see on your machine if you have the standard LISTFILES and LISTF commands: 1 CT VOC LISTFILES LISTFILES 0001 Synonym for LISTF command 0002 LISTF 2 CT VOC LISTF LISTF 0001 Remote - LIST all files defined in the VOC file 0002 UNIVERSE.VOCLIB 0003 LISTF 3 CT UNIVERSE.VOCLIB LISTF LISTF 0001 PQ - LIST all files defined in the VOC file 0002 H*LISTFILES 0003 STON 0004 H 0005 P 4 LOGTO uv 5 VCATALOG BP *LISTFILES LISTFILES *LISTFILES verifies. 6 CT BP LISTFILES [not showing LISTFILES program - - but if you view it, you will see that it doesn't have a cache of file names.] - --- -- - The information contained in this e-mail message may be privileged and confidential information and is intended only for the use of the individual and/or entity identified in the alias address of this message. If the reader of this message is not the intended recipient, or an employee or agent responsible to deliver it to the intended recipient, you are hereby requested not to distribute or copy this communication. If you have received this communication in error, please notify us immediately by telephone or return e-mail and delete the original message from your system. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] major (?) @var security hole
Disregarding the issue of uniVerse subroutines that can corrupt some @vars. For current user name and current database location, don't use @LOGNAME and @ACCOUNT. Instead, use @AUTHORIZATION and @PATHNAME, which contain the effective owner name and the current location. It's generally preferable to use @AUTHORIZATION (current id) instead of using @LOGNAME (original id). @LOGNAME is the original login name but is not always the effective process owner. This isn't an issue on Windows servers, but on Unix and Linux most programs (such as Unix mail) use the effective id not the login id. Using @AUTHORIZATION gives the same result as executing id -un or whoami. That is, it give the first (and only, one hopes) name in /etc/passwd for the effective id. Also, it's generally preferable to use @PATHNAME instead of using @ACCOUNT. @ACCOUNT doesn't change when you do LOGTO and doesn't always show your current VOC location. But @PATHNAME does change after LOGTO and does show your current VOC location. -Original Message- From: Craig Bennett [mailto:[EMAIL PROTECTED] Sent: Sunday, September 12, 2004 8:21 PM To: [EMAIL PROTECTED] Subject: Re: [U2] major (?) @var security hole Importance: High If you need a value that won't change, try SYSTEM(27) or SYSTEM(28). These return the operating system user Id and effective user Id. You may need to parse the /etc/passwd file to match to a login name (but your LOGIN proc could store this too, before anyone has a chance to fiddle with @ACCOUNT). Craig --- 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] resizing VOC on UV
Using a sample of files with no very large records, or using id-only test files with null @RECORD, for each filename, do { CLEAR-FILE DATA HASH.AID.FILE for a sample of reasonable moduli, do { PHANTOM HASH.AID filename 2,18 mod sep } SORT HASH.AID.FILE BY-DSND LARGEST.GROUP to see the worst file types. } Here's a couple of tests using id patterns found at many sites. Try two-part ids where the prefix is always 001* and the suffix is a sequential number, and the evil types will probably be 9 and 8. Try two-part ids where the prefix is a sequential number and the suffix is always *001, and the evil types will probably be 5 and 4. I tried NEWACC and uv/VOC: The worst types were 9 and 5, though not bad enough to be called evil. Clif wrote: Hm. That kind of statement must be challenged. Please post test cases, with data, and results to support such a claim. Ben wrote: Never use file hashing type 4 or type 5 or type 8 or type 9. They're evil. --- --- --- -- The information contained in this e-mail message may be privileged and confidential information and is intended only for the use of the individual and/or entity identified in the alias address of this message. If the reader of this message is not the intended recipient, or an employee or agent responsible to deliver it to the intended recipient, you are hereby requested not to distribute or copy this communication. If you have received this communication in error, please notify us immediately by telephone or return e-mail and delete the original message from your system. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] AIX printers direct
Here are 2 ways to connect the UV spooler directly to your 600 network printers. 1. use hpnptyd to make a pseudo serial port device (/dev/pt...) for each printer. This would usually be done at boot time, with a separate hpnptyd process for each port, and you must wait until after all of those 600 processes have started, before you start your 2 spoolers (AIX and uv). 2. use universe spooler driver scripts that set the PRINTERNAME environment variable and that then call a common driver script that does something like cat | hpnpf -x ${PRINTERNAME} -w 2${PRINTERNAME}.logfile (you'll probably want some other stuff - - see the scripts that get installed on AIX when you install jetadmin.) *** My advice is to avoid both of the above methods. Don't connect your 600 printers directly to the UniVerse spooler. You'll save time and money if you get a dedicated Novell Netware print server. Netware 6 isn't as simple as good old Netware 3, but, for 600 printers, it would be your least cumbersome solution. The Netware server could handle all of your print jobs, not just the ones from UniVerse, but also the ones from other unix applications, and the ones from Windows workstations and Windows servers. If not Netware, then get a Windows 2003 server (or you might need a Windows server cluster) as a dedicated print server for all Windows and Unix applications, including UniVerse. Either way, using a Netware server or a Windows server (or Windows cluster), is going to make print job management easier than using the UniVerse and/or AIX spoolers. *** The information contained in this e-mail message may be privileged and confidential information and is intended only for the use of the individual and/or entity identified in the alias address of this message. If the reader of this message is not the intended recipient, or an employee or agent responsible to deliver it to the intended recipient, you are hereby requested not to distribute or copy this communication. If you have received this communication in error, please notify us immediately by telephone or return e-mail and delete the original message from your system. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [OT] Sarbanes-Oxley
Others have argued: See the thing is, we're letting the auditors drive this thing. Auditors don't drive this. Auditing is basic procedures plus statistical sampling of transactions ... *** No, no, no, that's what financial auditors do, not I.T. auditors. The word auditor is an overloaded descriptor, referencing either a financial auditor or an I.T. auditor, which are two very different animals. Financial auditors examine financial transactions and financial controls, and they verify samples of data. I.T. auditors look at the software that produces and uses that data, and look at how the software is controlled, and they also look at physical control of I.T. hardware. ** The Sarbanes-Oxley act specifically mandates both kinds ** ** of auditing, both financial auditing and I.T. auditing. ** The I.T. audits aren't much like financial audits. Instead, they are much like ISO-9000 audits, and require excruciatingly detailed documentation of I.T. quality assurance (or at least QA-ish) policies and procedures. As with ISO-9000, the costs of becoming compliant may be high, but sometimes there are good benefits. For instance, some I.T. departments which were scrambling to become compliant with SOX audits have found themselves accidentally becoming more compliant also with the SEI-CMM (Software Engineering Institute's Capability Maturity Model). *** The information contained in this e-mail message may be privileged and confidential information and is intended only for the use of the individual and/or entity identified in the alias address of this message. If the reader of this message is not the intended recipient, or an employee or agent responsible to deliver it to the intended recipient, you are hereby requested not to distribute or copy this communication. If you have received this communication in error, please notify us immediately by telephone or return e-mail and delete the original message from your system. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OT: Ardent.com
Ready for more fun? Click here. http://www.buydomains.com/index.jsp?wrap=%2Fservlet%2FPrivateSale%3Fdomain%3 Dunidata.com -Original Message- From: Karl L Pearson [mailto:[EMAIL PROTECTED] Just for those who remember, check out www.ardent.com or www.ardentsoftware.com. Someone's slip is showing... The information contained in this e-mail message may be privileged and confidential information and is intended only for the use of the individual and/or entity identified in the alias address of this message. If the reader of this message is not the intended recipient, or an employee or agent responsible to deliver it to the intended recipient, you are hereby requested not to distribute or copy this communication. If you have received this communication in error, please notify us immediately by telephone or return e-mail and delete the original message from your system. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Phone/TAPI Interface, D3/W2K
Telathena ( http://www.telathena.com ) has various ways of connecting u2 PHANTOM jobs to inbound and/or outbound call distribution systems. Some old versions of Telathena also ran on non-u2 Pick systems, but I think that the current versions of Telathena aren't compatible with Pick/d3. For instance, Telathena can drive a predictive dialer that dials out on many lines at once and only connects the few lines that are answered to the pool of operators, while the PHANTOM would automatically record the status of the other calls, and optionally queue those numbers for trying again later. Predictive dialers are designed to connect the human operator's headset in the middle of the o in Hello? if a another human answers the phone, and, simultaneously, the Telathena foreground client pops up the account info (from your u2 database) on the operator's PC. But it's not good to use a predictive dialer on multiple outbound lines with just a single dispatcher, because, too often, you'll get Hello? on 2 lines at once, and annoy one of your customers by just hanging up. Predictive dialers are for call centers with dozens of operators. Telathena can also drive simple local aux-port (or internal serial port) modems or dialers, but you may be able to do that yourself, by just using your terminal emulator's aux-port option. This can shave several seconds off of the time per call, which can be significant when there are lots of busies and no answers, or when the average call length is very short. For more options, see Call Center magazine. ( http://www.callcenter.com ) -Original Message- From: Mark Johnson Perhaps someone can lead me in the right direction. One of my clients, D3/W2K, dispatches 20-24 HVAC vans daily throughout our state with upwards of 100-120 calls per day. The dispatcher calls on nextel to inform the techs of their next appointment and uses a regular phone to call the customer for the upcoming visit. The question is if there's a way to interface this system (home/cell/alt phones in database) to an external phone system that could place an automated call to that customer and return a status code (ok, busy signal, no answer, answering machine) to the dispatcher so she doesn't have to have a phone handset permanently welded to her ear. Thanks in advance. Mark Johnson The information contained in this e-mail message may be privileged and confidential information and is intended only for the use of the individual and/or entity identified in the alias address of this message. If the reader of this message is not the intended recipient, or an employee or agent responsible to deliver it to the intended recipient, you are hereby requested not to distribute or copy this communication. If you have received this communication in error, please notify us immediately by telephone or return e-mail and delete the original message from your system. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] merge sort
EXECUTE MERGE.LIST 0 UNION 0 TO 0 will sort and de-dupe the current select list. -Original Message- From: Chuck Mongiovi Does anyone know where I can get code for a generic BASIC Merge SORT routine? -Chuck --- The information contained in this e-mail message may be privileged and confidential information and is intended only for the use of the individual and/or entity identified in the alias address of this message. If the reader of this message is not the intended recipient, or an employee or agent responsible to deliver it to the intended recipient, you are hereby requested not to distribute or copy this communication. If you have received this communication in error, please notify us immediately by telephone or return e-mail and delete the original message from your system. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [OT] SAP
SAP was once an acronym for simple as possible but now signifies the opposite of that. It's a great product though, and has helped many consultants to buy nice boats. -Original Message- There are rumblings around our company about moving to an SAP package. What is SAP all about? The information contained in this e-mail message may be privileged and confidential information and is intended only for the use of the individual and/or entity identified in the alias address of this message. If the reader of this message is not the intended recipient, or an employee or agent responsible to deliver it to the intended recipient, you are hereby requested not to distribute or copy this communication. If you have received this communication in error, please notify us immediately by telephone or return e-mail and delete the original message from your system. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse and 1GB Ethernet Cards...
If tcp/ip always ran smoothly in Windows, there wouldn't be so many products to tweak it. Lots of things can go wrong, such as expanding buffer sizes and thus triggering the Nagle effect. (isn't that what UDT.OPTIONS 109 fixes?) *** How would Universe support/not support a NIC? That's the OS's function, be it Unix or Windows. What's the OS's function? To provide an API to the application software, and an API to the NIC hardware driver, and to provide the tcp and ip layers, more or less, in the middle of the seven layer reference model. In *n*x, the API to a command shell vendor is simply stdin and stdout, with the O/S hiding the telnet (or telnet-like) services. Unlike *n*x, Windows doesn't provide telnet service to character-based (shell) applications, so the application vendors (e.g. the u2 folks in Denver) must supply and tweak their own telnet services, instead of simply reading from stdin and writing to stdout. Now add to that picture a NIC vendor who is, perhaps, tweaking their driver to get the edge in http benchmarks, at the expense of screwing up some non-http protocols. Still, things work pretty nicely nowadays, compared to the days of yon when computer networking in the USA meant trying to get IBM and ATT equipment to co-exist. The information contained in this e-mail message may be privileged and confidential information and is intended only for the use of the individual and/or entity identified in the alias address of this message. If the reader of this message is not the intended recipient, or an employee or agent responsible to deliver it to the intended recipient, you are hereby requested not to distribute or copy this communication. If you have received this communication in error, please notify us immediately by telephone or return e-mail and delete the original message from your system. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata 6 and Tru64
You mentioned convdata and convcode but not convidx. Did you run convidx? Then again, the problem could be in your software migration, not your data migration from AIX to Tru64. Unaligned access usually isn't fatal, by itself, but is sometimes caused by bugs that have other, and fatal, consequences. When unaligned access isn't fatal, you can speed up your system by just suppressing the unaligned messages via uac but that makes it hard to find and fix the associated bugs (sort of like the justly deprecated (S)uppress option in Pick). In the unaligned error messages, after the pid, what is (are) the name(s) of the program(s)? Is the program name always udt? If so, are you using makeudt and CALLC? -Original Message- From: Nick Southwell Anyone out there using Unidata with Tru64 on Alphas. We have having a lot of trouble with unaligned access pid messages. Open and Direct Group Limited London, EC4A 1BD The information contained in this e-mail message may be privileged and confidential information and is intended only for the use of the individual and/or entity identified in the alias address of this message. If the reader of this message is not the intended recipient, or an employee or agent responsible to deliver it to the intended recipient, you are hereby requested not to distribute or copy this communication. If you have received this communication in error, please notify us immediately by telephone or return e-mail and delete the original message from your system. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] building DICT items
Chuck wrote Specifically, I'm looking to pull a single Multi-Value ( like EXTRACT(@RECORD,5,5,0) ) using an A-type This is only for Universe, not for Unidata, because Unidata doesn't have the Pick-style A types. Using an A (or S) type of attribute definition in Universe, you can extract a single value by doing a translate back into the primary file. It's ugly but it works. Replace a and v with the real attribute number and value number. ED DICT filename FIELD-a.v New record. : I 0001= A 0002= 0 0003= 0004= 0005= 0006= 0007= 0008= Tfilename;X;;a,v 0009= L 0010= 20 0011= Bottom at line 10. : FI FIELD-a.v filed in file DICT filename. There is also an alternate syntax, with the value number appended to the translate opcode, in which case line 8 would look like 0008= Tfilename;Xv;;a For example, you could get value 9 of attr 35 of the INV file by doing either TINV;X;;35,9 or TINV;X9;;35 If possible, avoid this form and just use a simple I descriptor, or, if you're on SB+, just use /FD to define field number a.v (for example, field number 35.9). The information contained in this e-mail message may be privileged and confidential information and is intended only for the use of the individual and/or entity identified in the alias address of this message. If the reader of this message is not the intended recipient, or an employee or agent responsible to deliver it to the intended recipient, you are hereby requested not to distribute or copy this communication. If you have received this communication in error, please notify us immediately by telephone or return e-mail and delete the original message from your system. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] inserting European format dates using SQL
ICONV code DDMY (and variations such as DDMAY or DDMY2-) will always convert European-style dates correctly, no matter what your local settings are. Define an attribute alias with conversion code DDMY and use that alias definition for your input data. -- The information contained in this e-mail message may be privileged and confidential information and is intended only for the use of the individual and/or entity identified in the alias address of this message. If the reader of this message is not the intended recipient, or an employee or agent responsible to deliver it to the intended recipient, you are hereby requested not to distribute or copy this communication. If you have received this communication in error, please notify us immediately by telephone or return e-mail and delete the original message from your system. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/