RE: UniOLEDB Threading issue
Nick, We use UV with talking Oracle (using UCI). We're mainly pushing the data from the Oracle end (trigger driven). In another interface to a Oracle-based application, we've got a Tuxedo middleware interface. Yet, again - mainly one-way traffic (from the Oracle end). I know there is a limitation in UV triggers, that you can't do an SQLConnect, etc (Using the SQL Basic Call Interface -BCI). UD Triggers may have a similar limitation, perhaps not. What platform/OS are you on? Have you looked at UniObjects for Java and the like? Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Nick Southwell Sent: Thursday, February 12, 2004 11:23 PM To: U2 Users Discussion List Subject: RE: UniOLEDB Threading issue Thanks David, I suppose we assumed as many would that an OLEDB driver would handle concurrent requests especially when the documentation talks about UniOLEDB's support for free threading. Frustrating as hell, looks like we will move to a SQL Server caching solution. I have the theory of bidirectional sync in my head, triggers from SQL populating Unidata and I'm thinking about triggers from Unidata populating a control table which SQL polls. Not sure if the Unidata - SQL can be done in a more efficient manner. Funny enough the first response from IBM was to use their wonderful redback product instead. Thanks Nick -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: multi-currency
SNIP Hello, I we have been given the task of redesigning our existing software to handle multiple currencies. This means that at any time on the screen you could switch from USD to EUR, or USD to SGD (Singapore dollar) and back again. i was thinking of using FUNCTION. /SNIP I'd be looking for a lot more detail on requirement before expressing an opinion on implementation. What sort of system ? Accounting requirements ? etc For eg, think of a foreign news report quoting $10bn (= £6bn UK) - obviously needs an exchange rate but the precise rate doesn't matter. If your system just handles information like that then a simple solution would work On the other hand if you've got a transaction based system, suppose you issue a quote in local currency, the order may not come in for a month, when it does which rate do you use ? quoted or today's ? If you issue an invoice do you use local or base (US $) currency ? do you accept payment in local or base currency ? if there's any element of local then you've got to consider how you handle rate changes between the time the invoice is issued and the time it gets paid, and what you do with the money you've made or lost. Any true multi-currency accounting system is going to have to store base amount plus currency and exchange rate (or local amount) on all transactions (or timestamp them and keep a full history of applicable rates to reconstruct) my 2 pence ( = 3.8 cents today) Piers -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: wIntegrate Trial Version
The current version of wintegrate ships with a client server version as well as the standard telnet. The thin client requires the wintegrate server to be installed on a network server. The thin client installs only 30k on the desktop PC. Advantages to the wintegrate server is that there is a single point of maintainence, and tight control over sessions and configurations. It acts as a true client server environment with all of the COM/DCOM and other client server perks. It also enables you to visibly monitor and control other user's sessions, sort of like Tandem in the Unix version of Universe, but in a GUI setting. It's really nice when you're using the wintegrate GUI language independent of the MV host. Disadvatages are that the telnet traffic hits the wintegrate server first before going to the thin client on the desktop, plus if the wintegrate server goes down, everyone loses wintegrate. IMHO, the wintegrate server is great in a very large scale and geographically dispersed environment and using SMS, but if you're in a user setting of under 50 the additional overhead is overkill. The Host routines that load onto Universe are a separate function and are independent of the client server environment. I think they come loaded with the trial version, but I don't recall. -Original Message- From: Mark Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, February 12, 2004 11:18 PM To: U2 Users Discussion List Subject: Re: wIntegrate Trial Version As far as i know, there isn't a server portion of wintegrate, rather it is a client session to telnet to a MV system. The magic comes with matching term settings, ie vt100, addsvp etc. my 1 cent. - Original Message - From: Glenn W. Paschal [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 12, 2004 5:07 PM Subject: wIntegrate Trial Version Ok, first, I am new to wIntegrate. I downloaded the trial version, and installed it on an XP pro machine which also runs the UniVerse personal edition. Note:trial version can be obtained at: https://www-927.ibm.com/software/data/u2/support/u2techconnect/wintlist. asp? newreg=1 How do I get the server portion of wIntegrate installed? If it is due to the personal edition of UV, is there a way to install the server portion of wIntegrate trial on a real UV license? (this would be UV 10). I've looked through the manuals, and I am obviously missing something. Can someone point me in the right direction? Thanks for your help. --Glenn -- 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: Hashing Algorithm
Could anyone let me know where can I found information about the way the Hash Algorithm Works with each one of the File Types in UniVerse? It does, of course, lead to the question of why you want to know! Why not? .. I'd bet on simple (or not so simple) curiousity .. Aren't we all pretty much tech geeks here? .. Maybe he wants to see the hashing mathematics for himself and then check out a high speed data structures book and see if they're all they're cracked up to be .. -Chuck -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Hashing Algorithm
Why not? .. I'd bet on simple (or not so simple) curiousity .. Aren't we all pretty much tech geeks here? .. Maybe he wants to see the hashing mathematics for himself and then check out a high speed data structures book and see if they're all they're cracked up to be .. I have the algorithms (from a legal source long before IBM acquired the product) but because they are now secret I cannot divulge the details. They are, however, extremely simple except for the dynamic algortihms which are rather more exciting. 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: multi-currency
Piers, An interesting question. Some years ago my company developed an auto-rental system for the Hertz franchisee in Jamaica. An unusual aspect was that the rental contract was based on the exchange rate in effect at the time the contract was entered, however the final charges were booked at the exchange rate in effect when the vehicle was returned (or wound up in a gullie from a crash-down). This necessitated keeping daily exchange rates for each currency pair that was encountered in payment of a rental contract. Of course there was the opportunity to exchange Jamaican dollars for US dollars on the black market, but that's a very different chapter ;-)) Lee Bacall http://www.binarystar.com Phone: +1 (954) 791-8575, emergency# 954-937-8989 - Original Message - From: Piers Angliss [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, February 13, 2004 7:56 AM Subject: RE: multi-currency SNIP Hello, I we have been given the task of redesigning our existing software to handle multiple currencies. This means that at any time on the screen you could switch from USD to EUR, or USD to SGD (Singapore dollar) and back again. i was thinking of using FUNCTION. /SNIP I'd be looking for a lot more detail on requirement before expressing an opinion on implementation. What sort of system ? Accounting requirements ? etc For eg, think of a foreign news report quoting $10bn (= £6bn UK) - obviously needs an exchange rate but the precise rate doesn't matter. If your system just handles information like that then a simple solution would work On the other hand if you've got a transaction based system, suppose you issue a quote in local currency, the order may not come in for a month, when it does which rate do you use ? quoted or today's ? If you issue an invoice do you use local or base (US $) currency ? do you accept payment in local or base currency ? if there's any element of local then you've got to consider how you handle rate changes between the time the invoice is issued and the time it gets paid, and what you do with the money you've made or lost. Any true multi-currency accounting system is going to have to store base amount plus currency and exchange rate (or local amount) on all transactions (or timestamp them and keep a full history of applicable rates to reconstruct) my 2 pence ( = 3.8 cents today) Piers -- 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: Hashing Algorithm
[EMAIL PROTECTED] 02/13/2004 8:49:08 AM Could anyone let me know where can I found information about the way the Hash Algorithm Works with each one of the File Types in UniVerse? It does, of course, lead to the question of why you want to know! Would knowing the algorithms allow you to write a program that would accept parameters about your file, or even walk the file, to determine which file type would be best for that file? Karjala -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Hashing Algorithm
From: Karjala Koponen [EMAIL PROTECTED] Would knowing the algorithms allow you to write a program that would accept parameters about your file, or even walk the file, to determine which file type would be best for that file? Years ago I wrote a FTN program that analyzed PR1ME INFORMATION files and recommended file types and modulos. Problem with it was that it required a reasonably in-depth understanding of the data structures, and they changed in some releases. When HASH.HELP became robust enough I quit using my program as I couldn't justify the development time/effort. Instead I wrote a front-end which generated paragraphs consisting primarily of HASH.HELP %filename% statements. The paragraphs included COMO statements, and the final statement ran a program to interpret the output from the HASH.HELP and execute an appropriate RESIZE command. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Payroll computations
I'm trying to write a program that will give a estimate (fairly close estimate) for determine what amount of money deducted pre-taxed, will cause your taxable income to drop a tax bracket. What I'm looking for is an excel file for tax rates on salary income. I'm assuming you take the gross * (# payperiods in year) for annualized salary and use that as a base (depending on the # of dependants on the w4) would give you the % to charge for fed inc tax. Is that how it works? (Annualized Salary - pre tax $) * (% based on dedecutions from table) = Fed withholding $ I'm not looking to include state / FICA at this point Is the above the correct method for determining taxable income for a paycheck, and if it is via tables where can I get the table in computer readable format. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - An innovative information, education and management company http://www.slackinc.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: multi-currency
Pretty major thing. Not quite as simple as it looks on the surface. The major concept that throws a wrench into the works is the varying conversion rates. Pretty simple to flip-flop transactions at the current exchange rate. It gets real sticky at the G/L level where for any given transaction you would have gains or losses due to currency fluctuations. Your $1000 booked invoice only nets you the equivalent of $950 when paid. The other little pain is showing old transactions. What rate do you use? It gets to be quite interesting. My 2 cents (or 1.8 depending on today's exchange rate). Mike Randall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Gonzalez Sent: Thursday, February 12, 2004 2:57 PM To: U2 Users Discussion List Subject: multi-currency Hello, I we have been given the task of redesigning our existing software to handle multiple currencies. This means that at any time on the screen you could switch from USD to EUR, or USD to SGD (Singapore dollar) and back again. i was thinking of using FUNCTION. then depending on the customer's currency code redisplay the amount. obviously i need to read some control file that contains the conversion factor for that particular day. btw: i have decided that is better to write amounts in USD, since our accounting will be done is USA. does anybody have any suggestions, opinions??? any feed back will be appreciated. At 01:18 PM 2/12/04 -0600, you wrote: Could anyone let me know where can I found information about the way the Hash Algorithm Works with each one of the File Types in UniVerse? Thanks in advance ABDP José Luis Gutiérrez de la Peza Director General Asesores en Bases de Datos Profesionales, S.A. de C.V. Tel. (52) 55-59-12-44 y/o (52) 55-75-21-29 Móvil (044) 55 52-48-33-87 www.abdp.com.mx -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Thank you, Peter Gonzalez Senior Programmer -- 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: Payroll computations
You could start here: http://taxes.yahoo.com/rates.html -Original Message- From: George Gallen [mailto:[EMAIL PROTECTED] Sent: Friday, February 13, 2004 8:40 AM To: 'Ardent List' Subject: Payroll computations I'm trying to write a program that will give a estimate (fairly close estimate) for determine what amount of money deducted pre-taxed, will cause your taxable income to drop a tax bracket. What I'm looking for is an excel file for tax rates on salary income. I'm assuming you take the gross * (# payperiods in year) for annualized salary and use that as a base (depending on the # of dependants on the w4) would give you the % to charge for fed inc tax. Is that how it works? (Annualized Salary - pre tax $) * (% based on dedecutions from table) = Fed withholding $ I'm not looking to include state / FICA at this point Is the above the correct method for determining taxable income for a paycheck, and if it is via tables where can I get the table in computer readable format. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - An innovative information, education and management company http://www.slackinc.com -- 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: Payroll computations
George, Goto (no flames please) the IRS website and download Circular E (http://www.irs.gov) Website Path: Side Menu: Contents, Businesses Side Menu: Resources, Forms And Publications Body Link: PUBLICATIONS AND NOTICES (not forms) Circular E, Page 35-37 Donald Verhagen 1690 S Congress Avenue, Suite 210 [EMAIL PROTECTED] Delray Beach, FL 33445 USA Tandem Staffing Solutions, Inc. Voice Phone: 561.454.3592 Senior Programmer Fax Phone: 561.454.3640 --- [EMAIL PROTECTED] 10:40:19 AM 02/13/2004 I'm trying to write a program that will give a estimate (fairly close estimate) for determine what amount of money deducted pre-taxed, will cause your taxable income to drop a tax bracket. What I'm looking for is an excel file for tax rates on salary income. I'm assuming you take the gross * (# payperiods in year) for annualized salary and use that as a base (depending on the # of dependants on the w4) would give you the % to charge for fed inc tax. Is that how it works? (Annualized Salary - pre tax $) * (% based on dedecutions from table) = Fed withholding $ I'm not looking to include state / FICA at this point Is the above the correct method for determining taxable income for a paycheck, and if it is via tables where can I get the table in computer readable format. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - An innovative information, education and management company http://www.slackinc.com -- 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: Payroll computations
thanks for the path directions, I searched for circular e and it didn't come up with anything. ok. Looks like I got enough to get me started for some rough numbers.. Thanks -Original Message- From: Don Verhagen [mailto:[EMAIL PROTECTED] Sent: Friday, February 13, 2004 10:52 AM To: [EMAIL PROTECTED] Subject: Re: Payroll computations George, Goto (no flames please) the IRS website and download Circular E (http://www.irs.gov) Website Path: Side Menu: Contents, Businesses Side Menu: Resources, Forms And Publications Body Link: PUBLICATIONS AND NOTICES (not forms) Circular E, Page 35-37 --- - Donald Verhagen 1690 S Congress Avenue, Suite 210 [EMAIL PROTECTED] Delray Beach, FL 33445 USA Tandem Staffing Solutions, Inc. Voice Phone: 561.454.3592 Senior Programmer Fax Phone: 561.454.3640 --- [EMAIL PROTECTED] 10:40:19 AM 02/13/2004 I'm trying to write a program that will give a estimate (fairly close estimate) for determine what amount of money deducted pre-taxed, will cause your taxable income to drop a tax bracket. What I'm looking for is an excel file for tax rates on salary income. I'm assuming you take the gross * (# payperiods in year) for annualized salary and use that as a base (depending on the # of dependants on the w4) would give you the % to charge for fed inc tax. Is that how it works? (Annualized Salary - pre tax $) * (% based on dedecutions from table) = Fed withholding $ I'm not looking to include state / FICA at this point Is the above the correct method for determining taxable income for a paycheck, and if it is via tables where can I get the table in computer readable format. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - An innovative information, education and management company http://www.slackinc.com -- 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: Hashing Algorithm
It does, of course, lead to the question of why you want to know! I used to have a program I calledthat would take a select list sort it according to the group order of the file it was going to be applied to. For really big lists it made a really big difference because subsequent file i/o flowed sequentially through the file with several consecutive groups read into memory by the os, (yes, except for overflow) then all records from those groups processed. I would use it whenever I had a big select list that was built independently of the file it was going to process and the processing order did not really matter. It worked on Pick, where their one algorithm is well-know and easily duplicated, and on Prime, which gave us the !HASHID function. (I think that's what it was called, but I may be remembering !HUSHIT, which my dyslexic brain would always turn around, sticking the ! on the back end and associating the SH with the IT that followed instead of with the preceding HU, which dyslexia somehow converted into OH, anyway.) I wouldn't care about their algorithms, per se, but I wish IBM would give us a similar function: GROUP.NO = HASHID( TYPE, MOD, SEP, ID ) Sort of like the RECORD verb, except that actually goes out and does file i/o: RECORD VOC ASDASDF Record ASDASDF hashes to group 233 but was not found. RECORD VOC SYS.HELP Record SYS.HELP hashes to group 847 and was found. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Out of office messages - from list?
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of kevin zollinger Sent: Friday, February 13, 2004 7:50 AM To: [EMAIL PROTECTED] Subject: Re: Out of office messages - from list? Glenn W. Paschal [EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]: Is anyone else getting several out of office messages? I've been getting several from people I don't know, and it seems to have started when I joined the list. Could there be a problem? You are getting these responses from other listers who failed to tell their auto-attendent that it shouldn't reply to list messages. I think we can give everyone a little slack given the recent listserv change, but I would hope that we will see a decrease in the number of such messages over time. ~ kevin zollinger [EMAIL PROTECTED] - Kevin, Wouldn't auto-responders reply to the list? These are coming to my own mailbox, with my e-mail in them. Please understand, I am not trying to point blame, just trying to check things out. My e-mail server was hijacked not too long ago, and it causes one to be extra careful. Thanks, --Glenn. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Memo: RE: multi-currency
Pretty major thing. Not quite as simple as it looks on the surface. The major concept that throws a wrench into the works is the varying conversion rates. Pretty simple to flip-flop transactions at the current exchange rate. It gets real sticky at the G/L level where for any given transaction you would have gains or losses due to currency fluctuations. Your $1000 booked invoice only nets you the equivalent of $950 when paid. The other little pain is showing old transactions. What rate do you use? It gets to be quite interesting. yes, that can trip you up. The standard way of dealing with this is to have a currency revaluation routine that posts currency differences to the general ledger currency control account for that currency _ This transmission has been issued by a member of the HSBC Group HSBC for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Memo: RE: multi-currency
Pretty major thing. Not quite as simple as it looks on the surface. The major concept that throws a wrench into the works is the varying conversion rates. Pretty simple to flip-flop transactions at the current exchange rate. It gets real sticky at the G/L level where for any given transaction you would have gains or losses due to currency fluctuations. Your $1000 booked invoice only nets you the equivalent of $950 when paid. The other little pain is showing old transactions. What rate do you use? It gets to be quite interesting. sorry about the previous post - I must have hit the send button on a draft. Here is what I meant to say: You have to have a currency control account in the general ledger, usually one for each currency. Then you have currency revaluation process that runs periodically and calcualates the difference between the value on the transaction and the value at the current exchange rate. You adjust the transaction by that amount and also post it to the currency control account. HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ Registered in England - Number 14259 Authorised and Regulated by the Financial Services Authority Member of the HSBC Bank marketing group. We sell life assurance, pensions and collective investment schemes and advise only on our own range of these products. _ This transmission has been issued by a member of the HSBC Group HSBC for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Payroll computations
I'm only looking for rough numbers, not exacts (being off by $5.00 or $10.00 is acceptable), since this won't be actually used for peoples paychecks. George -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Friday, February 13, 2004 11:06 AM To: U2 Users Discussion List Subject: RE: Payroll computations Oh crumbs. We sell software that does EXACTLY that. I might even be able to email you an out-of-date copy (several years out-of-date ...) To try and explain how it works ... We first look at the first-priority tax bands, and build an array of gross2net at each kink. Let's say you pay 10% on the first 10K, 20% on the next 10K, and 30% on the next... Gross Net 0 0 10K9K 20K17K 30K24K Now let's say that, on your net of tax income, you now have to pay 5% of the first 10K in health premiums, and 10% of the next 10K. Gross Net1 Net2 0 0 10K9K 10K9.5K 20K17K 20K19.5K 30K24K For each tax in turn, you now add a new column to the right, and extrapolate back to the left. It's easy. That's what our program does. And you end up with, in the gross column, the exact gross for every point at which the marginal tax rate changes. Our ex-IT-manager once demonstrated this program at a beauty contest, up against one of the big accountancy firm. Their guy didn't believe him when he said he could do a net to gross calculation instantaneously, so they tried it. Our program was instant, while you could watch their program iterating down towards the correct result :-) Of course, in truth, our program didn't do it instantly. But as you exit the these taxes apply setup screen, it calculates this table on the way out. Then, when you actually enter the net, it simply interpolates to get the gross, then does a forward calculation to report all the taxes etc. (By the way, no offence to the others who've replied, but do those spreadsheets etc that you've referred to allow you to enter what taxes apply? And (as in our case) might George possibly want to use the same technique for other countries? After all, he did ask for the technique ...) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: 13 February 2004 15:40 To: 'Ardent List' Subject: Payroll computations I'm trying to write a program that will give a estimate (fairly close estimate) for determine what amount of money deducted pre-taxed, will cause your taxable income to drop a tax bracket. What I'm looking for is an excel file for tax rates on salary income. I'm assuming you take the gross * (# payperiods in year) for annualized salary and use that as a base (depending on the # of dependants on the w4) would give you the % to charge for fed inc tax. Is that how it works? (Annualized Salary - pre tax $) * (% based on dedecutions from table) = Fed withholding $ I'm not looking to include state / FICA at this point Is the above the correct method for determining taxable income for a paycheck, and if it is via tables where can I get the table in computer readable format. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - An innovative information, education and management company http://www.slackinc.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- 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: Hashing Algorithm
When HASH.HELP became robust enough I quit using my program as I couldn't justify the development time/effort. Instead I wrote a front-end which generated paragraphs consisting primarily of HASH.HELP %filename% statements. The paragraphs included COMO statements, and the final statement ran a program to interpret the output from the HASH.HELP and execute an appropriate RESIZE command. Many users do this. But beware that HASH.HELP is not perfect. There is one bug, for example, that we exploit in an example in the UK UniVerse training courses, where HASH.HELP gets it hopelessly wrong but which is easy to fix by hand. Personally, I am a great believer in dynamic files. About five years ago I did a migration from PI/open to UniVerse for a site with over 13000 files. There was absolutely no way that I was going to do file calculations for all of those so I made the lot dynamic and said that I would tune up any that presented performance problems. I visited the site last week. They are still overjoyed with performance, have spent absolutely NO time on file tuning, and have experienced no problems with these files. Of course, I have lost a good source of income providing a regular file tuning service! 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: Hashing Algorithm
I used to have a program I calledthat would take a select list sort it according to the group order of the file it was going to be applied to. For really big lists it made a really big difference What a great idea! I wish IBM would give us a similar function On UniData you can use the UniBasic HASH function to get the group a record would hash to, without performing any I/O. Just supply the key, modulo, and file type. Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services Office (717) 545-6403 (rolls to cell phone) [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Hashing Algorithm
Exactly, I want to know the calculations of the algorithm for each file type to determine which file type is the best for any file. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Karjala Koponen Enviado el: viernes, 13 de febrero de 2004 8:48 Para: [EMAIL PROTECTED] Asunto: RE: Hashing Algorithm [EMAIL PROTECTED] 02/13/2004 8:49:08 AM Could anyone let me know where can I found information about the way the Hash Algorithm Works with each one of the File Types in UniVerse? It does, of course, lead to the question of why you want to know! Would knowing the algorithms allow you to write a program that would accept parameters about your file, or even walk the file, to determine which file type would be best for that file? 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: Memo: RE: multi-currency
our accounting will be keep in USD. there is a control file that has an item id of USD*13191, EUR*13191, SGD*13191 (currency*internal date). rates will be supplied by the bank of london. USD*13193 attribute1 = the conversion rate for that currency and date attribute2 = currency sign ($) if customer purchases 3,000.00 EUR of parts, that will convert to some USD amount and written to our files in USD. when the customer pays 3,000.00 EUR for the parts, we will convert to USD based on the day that the order was placed. At 04:30 PM 2/13/04 +, you wrote: Pretty major thing. Not quite as simple as it looks on the surface. The major concept that throws a wrench into the works is the varying conversion rates. Pretty simple to flip-flop transactions at the current exchange rate. It gets real sticky at the G/L level where for any given transaction you would have gains or losses due to currency fluctuations. Your $1000 booked invoice only nets you the equivalent of $950 when paid. The other little pain is showing old transactions. What rate do you use? It gets to be quite interesting. sorry about the previous post - I must have hit the send button on a draft. Here is what I meant to say: You have to have a currency control account in the general ledger, usually one for each currency. Then you have currency revaluation process that runs periodically and calcualates the difference between the value on the transaction and the value at the current exchange rate. You adjust the transaction by that amount and also post it to the currency control account. HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ Registered in England - Number 14259 Authorised and Regulated by the Financial Services Authority Member of the HSBC Bank marketing group. We sell life assurance, pensions and collective investment schemes and advise only on our own range of these products. _ This transmission has been issued by a member of the HSBC Group HSBC for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Thank you, Peter Gonzalez Senior Programmer -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
D3 and use of compares on indices
On D3 VERION 7.3 what is the syntax to use compares other than = if you are using an indexed dictionary in the statement. It seems to return the correct items if it is simply looking for an equal condition but anything other, such as etc. It appears that it does not use the index, but rather scans the entire file when these operators are used. This becomes a problem especially when a date field has been indexed since that is the most common application. Has anyone else experienced this problem? This is D3 on W2k -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Swap array values? In UV
I understand why this works, but honestly, that's nasty. array(x)=BITXOR(array(x),array(y)); array(y)=BITXOR(array(y),array(x)); array(x)=BITXOR(array(x),array(y)); No temp variable used. Our company accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. 11/29/2003 ACE Software, LLC -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[OT] RE: Out of office messages - from list?
Glenn W. Paschal [EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]: Wouldn't auto-responders reply to the list? These are coming to my own mailbox, with my e-mail in them. Please understand, I am not trying to point blame, just trying to check things out. My e-mail server was hijacked not too long ago, and it causes one to be extra careful. What do you mean when you say with my e-mail in them? Are you saying that you are getting email that is unrelated to this list? Or are you saying that when you post to the list it comes back as an Out of office message? Or are you saying that you get messages that other people have posted with an OOO auto-reply? If it is the last then Clif has already asked that we fix our autoreplies, if the second then it is the same as it has always been and if the first then there maybe be something more serious going on -- ~ kevin zollinger [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV write fatal error
Permissions? All the preceding steps (Open, BSCAN) can be done without write permission. Write, needless to add, cannot. -Original Message- From: Jimi DeRouen [mailto:[EMAIL PROTECTED] I am attempting to write a record to a type 25 file and apparently getting a fatal error. The platform is UV 9.5.1.1b Pick flavor on W2K SP4. I have constructed the WRITE statement to include all possible (I think) branching, yet the program goes to the command prompt when the WRITE is executed without following any of the branches. The WRITE statement is as follows: [SNIP] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [OT] RE: Out of office messages - from list?
What I was seeing was, when I posted a reply to the list I would receive OOO messages from a few folks directly to my email address (not via the list), with my post to the list referenced. Don't know if this is what Glenn had happen. Jim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of kevin zollinger Sent: Friday, February 13, 2004 1:59 PM To: [EMAIL PROTECTED] Subject:[OT] RE: Out of office messages - from list? Glenn W. Paschal [EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]: Wouldn't auto-responders reply to the list? These are coming to my own mailbox, with my e-mail in them. Please understand, I am not trying to point blame, just trying to check things out. My e-mail server was hijacked not too long ago, and it causes one to be extra careful. What do you mean when you say with my e-mail in them? Are you saying that you are getting email that is unrelated to this list? Or are you saying that when you post to the list it comes back as an Out of office message? Or are you saying that you get messages that other people have posted with an OOO auto-reply? If it is the last then Clif has already asked that we fix our autoreplies, if the second then it is the same as it has always been and if the first then there maybe be something more serious going on -- ~ kevin zollinger [EMAIL PROTECTED] -- 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: Swap array values? In UV
*lol* i agree it's nasty and not readily obvious as to it's intent, but that wasn't the question posed... sometimes it's just to exercise the mind At 02:36 PM 02/13/2004, you wrote: I understand why this works, but honestly, that's nasty. array(x)=BITXOR(array(x),array(y)); array(y)=BITXOR(array(y),array(x)); array(x)=BITXOR(array(x),array(y)); No temp variable used. Our company accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. 11/29/2003 ACE Software, LLC -- 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: Swap array values? In UV
UniVerse 10.0.x and higher have the SWAP command in BASIC. Please refer to our documentation regarding its use. -- original message -- Is there a command to swap two array contents? Like matswap array(x,y) will swap the contents of array(x) - array(y) and array(y) - array(x) Without using a temp varible. Yes I know I can do it that way. Thanks George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - An innovative information, education and management company http://www.slackinc.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Regards, LeRoy F. Dreyfuss Advanced Technical Services - UniVerse IBM U2 Data Management Solutions Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2/support www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Swap array values? In UV
Sorry Leroy, but swap only swaps non array values, and the mat portion will swap one array with another array I want to swap two values inside an array. I tried swap a(1),a(2) but it did nothing tried. dim a(10) a(1)=5 a(2)=6 print a(1),a(2) swap a(1),a(2) print a(1),a(2) and got: 5 6 5 6 but it did compile. I tried swap mat a(1),mat a(2), that did not compile. -Original Message- From: Leroy Dreyfuss [mailto:[EMAIL PROTECTED] Sent: Friday, February 13, 2004 5:18 PM To: [EMAIL PROTECTED] Subject: RE: Swap array values? In UV UniVerse 10.0.x and higher have the SWAP command in BASIC. Please refer to our documentation regarding its use. -- original message -- Is there a command to swap two array contents? Like matswap array(x,y) will swap the contents of array(x) - array(y) and array(y) - array(x) Without using a temp varible. Yes I know I can do it that way. Thanks George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - An innovative information, education and management company http://www.slackinc.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Regards, LeRoy F. Dreyfuss Advanced Technical Services - UniVerse IBM U2 Data Management Solutions Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2/support www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! -- 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: Swap array values? In UV
I miss understood you. No, UV doesn't provide the facility to do that within an array of any type- dynamic or dimensioned- that is not its purpose. It will work if the arrays are different, such as: DIM A(10),B(10) MAT A = '' MAT B = '' A(1) = 678 B(1) = 234 CRT 'BEFORE:' CRT 'A(1) = ':A(1), 'B(1) = ':B(1) SWAP A(1),B(1) CRT 'AFTER:' CRT 'A(1) = ':A(1), 'B(1) = ':B(1) C = '' D = '' C1 = 1234 C2 = 334 D1 = 5678 D2 = 778 CRT 'BEFORE:' CRT 'C1 = ':C1, 'C2 = ':C2 CRT 'D1 = ':D1, 'D2 = ':D2 SWAP D, C CRT 'AFTER:' CRT 'C1 = ':C1, 'C2 = ':C2 CRT 'D1 = ':D1, 'D2 = ':D2 BEFORE: A(1) = 678 B(1) = 234 AFTER: A(1) = 234 B(1) = 678 BEFORE: C1 = 1234 C2 = 334 D1 = 5678 D2 = 778 AFTER: C1 = 5678 C2 = 778 D1 = 1234 D2 = 334 Since a variable can be considered a dynamic array with a only a single attribute (our docs show a variable and not a dynamic array), I used a dynamic array to illustrate the entire array gets swapped with another array. Regards, LeRoy F. Dreyfuss Advanced Technical Services - UniVerse IBM U2 Data Management Solutions Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2/support www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! George Gallen [EMAIL PROTECTED] Sorry Leroy, but swap only swaps non array values, and the mat portion will swap one array with another array I want to swap two values inside an array. I tried swap a(1),a(2) but it did nothing tried. dim a(10) a(1)=5 a(2)=6 print a(1),a(2) swap a(1),a(2) print a(1),a(2) and got: 5 6 5 6 but it did compile. I tried swap mat a(1),mat a(2), that did not compile. -Original Message- From: Leroy Dreyfuss [mailto:[EMAIL PROTECTED] Sent: Friday, February 13, 2004 5:18 PM To: [EMAIL PROTECTED] Subject: RE: Swap array values? In UV UniVerse 10.0.x and higher have the SWAP command in BASIC. Please refer to our documentation regarding its use. -- original message -- Is there a command to swap two array contents? Like matswap array(x,y) will swap the contents of array(x) - array(y) and array(y) - array(x) Without using a temp varible. Yes I know I can do it that way. Thanks George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - An innovative information, education and management company http://www.slackinc.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Regards, LeRoy F. Dreyfuss Advanced Technical Services - UniVerse IBM U2 Data Management Solutions Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2/support www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! -- 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 Regards, LeRoy F. Dreyfuss Advanced Technical Services - UniVerse IBM U2 Data Management Solutions Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2/support www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Swap array values? In UV
Ok, I love brainteasers, but to be honest, I don't see how this works, possibly because I am one of those who has never used BITXOR, and so don't readily understand it. Please elaborate! Thanks, --Glenn. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glenn Herbert Sent: Friday, February 13, 2004 2:25 PM To: U2 Users Discussion List Subject: RE: Swap array values? In UV *lol* i agree it's nasty and not readily obvious as to it's intent, but that wasn't the question posed... sometimes it's just to exercise the mind At 02:36 PM 02/13/2004, you wrote: I understand why this works, but honestly, that's nasty. array(x)=BITXOR(array(x),array(y)); array(y)=BITXOR(array(y),array(x)); array(x)=BITXOR(array(x),array(y)); No temp variable used. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Swap array values? In UV
Glen, XOR means Exlusive OR. Example: 00110 BITXOR 10011 yields 10101 because 0 XOR 1 = 1, 0 XOR 0 = 0, 1 XOR 0 = 1, (here's the tricky one) 1 XOR 1 = 0 (because it needs to be exclusive), and 0 XOR 1 = 1 10 1 0 1 The example is still hard to read, even when you understand XOR, because it is a counter-intuitive approach. It is, however, frighteningly clever. - Charles 'Exclusive' Barouch Glenn W. Paschal wrote: Ok, I love brainteasers, but to be honest, I don't see how this works, possibly because I am one of those who has never used BITXOR, and so don't readily understand it. Please elaborate! Thanks, --Glenn. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glenn Herbert Sent: Friday, February 13, 2004 2:25 PM To: U2 Users Discussion List Subject: RE: Swap array values? In UV *lol* i agree it's nasty and not readily obvious as to it's intent, but that wasn't the question posed... sometimes it's just to exercise the mind At 02:36 PM 02/13/2004, you wrote: I understand why this works, but honestly, that's nasty. array(x)=BITXOR(array(x),array(y)); array(y)=BITXOR(array(y),array(x)); array(x)=BITXOR(array(x),array(y)); No temp variable used. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Using OpenOffice with UniVerse/Unidata - request for U2 users to be involved
I have been actively pursuing the use of OpenOffice.org (OOo) as an alternative to MS Office on both Linux and Microsoft platforms with reasonable success; from initially working with StarOffice 5.2 which worked well with UniVerse ODBC, through the beta versions of OOo where the developers actively responded to my requests by sending patches for the OOo ODBC interface (would that other company do that for you without a business case) , making changes to their implementation of tablename aliasing (because UniVerse does'nt support aliasing a tablename to itself), The current status is that the dba group of OOo at my request have downloaded UniVerse PE to test why the JDBC does not appear to work consistently from OOo version 1.0.3 to 1.1. They have run into a few issues getting into UniVerse to run but are willing to persist as long as they have some support. The fact is that if more of the U2 community were to report problems, request support for UniVerse/UniData ODBC/JDBC etc the OOo team would realise that there is a large community that they would be catering to. Also, it would ensure that the U2 community have an alternative, cost effective solutions to offer. Although I have requested IBM to look at some of the issues associated with OOo and U2 it would appear that the 'not invented here' syndrome prevents them from doing anything constructive; this is not a criticism, just an observation. I am surprised though that with IBM really pushing the Linux strategy that OOo is not seen as an alternative to MS Office for Linux on the desktop. (I heard a rumour, apparently confirmed in the press, and perhaps the IBMers on this list could comment, that by end 2005 IBM will be Linux wall-to-wall internally on the desktop - some of us just want to get there sooner) There are areas of the product though that do not work well with UniVerse, and, depending on who you talk to, it would appear that UniVerse ODBC for example, is not keeping up with developments as it implements ODBC 2.0 and OOo provides for ODBC 3. It has to date not been possible to get information from IBM whether theU2 ODBC driver will be enhanced, whereas OOo have made attempts to support ODBC 2.0 via patches. Unfortunately in recent releases of OOo(1.1.0) and StarOffice 7 ODBC and JDBC fails when accessing metadata. The good news is that OOo are actively looking at this problem for a single U2 user - me. That is impressive. My plea (oh, what a little pleader) is for all/many/some in the U2 community and especially those on this list to participate in the OOo development by logging issues related to database access; the OOo team have shown that they are willing to address issues but the larger the interest from outside the greater the focus will be on providing a solution. You don't have to do anything other than register with OOo and report where OOo does'nt work with U2. To make it easy I'll give you the list of things I've found. Some have referred to OOo on this list - if you are using OOo and have UniVerse/UniData please contact me. For those that don't know OOo yet there are some really powerful features we can utilise from within UniVerse eg XML designed forms (invoices, purchase orders) automated conversion of documents to pdf format, automated emailing etc. For the java people - OpenOffice can provide powerful services to your applications and is worth looking at. There is a largish site in Cape Town that has migrated most of the users to Linux thin-client and OOo and the users don't miss that other suite at all. Here's to hoping that this gets your support :). Thanks Ian Stuart -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users