[U2] UV - Replication on Solaris
Are any readers on the list using OS tools, or 3rd party products like Volume Manager + Volume Replicator to replicated UniVerse databases? Why was this approach better for you than using UniVerse Data Replication? Any thoughts, experiences appreciated. (We're running UV 10.0.8 on Solaris 8) Mark Hennessey --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OLEDB connection string
Very helpful. Thanks a lot Bill! Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Monday, June 26, 2006 6:04 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OLEDB connection string Nick: I created a new datasource as follows: Shared Data Source: Name--: UDOleDBReports Type--: OLE DB Connection string: Provider=IBM.UniOLEDB.1;Data Source=asidevud Connection Properties (via the [Edit] button in above dialog): Data Source: OLE DB (OLE DB) OLE DB Provider: UniOLEDB Provider Enter a server or file name: Server of file name: asidevud (in the uci.config item) Location---: leave blank (this messed me up for awhile) Log on to the server: Use a specific user name and password User name: valid Windows/UniData user (also in UniAdmin Network Service UDTelnet Server Users) Password-: valid Windows password for above user Allow saving password The connection string looks like: Provider=IBM.UniOLEDB.1;Data Source=asidevud;Persist Security Info=True;User ID=DataTrustNET I used the UCI Configurator to create the OleDB section. Although the tool seems to indicate this is only an ODBC tool the OleDB documentation, without mentioning it, assumed ODBC and OleDB sections are exactly the same. Hope this helps. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: Monday, June 26, 2006 12:04 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OLEDB connection string In the connection string, what is the Data Source? Is that the server that Universe resides on? What is the Location? Is that the account name? Is it the path to the account? No matter what values I put in these fields, I cannot get it to connect. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Saturday, June 24, 2006 3:26 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OLEDB connection string Nick: When I access UniOleDB from SQL Reporting Services my connection looks like: Provider=IBM.UniOLEDB.1;Data Source=asidevud And my uci.config item, on my client machine, looks like: asidevud DBMSTYPE = UNIDATA NETWORK = TCP/IP SERVICE = udserver HOST = MyDevServer ACCOUNT = E:\MyApps\Demo USERNAME = MyUserNET Maybe this helps. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: Friday, June 23, 2006 1:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] OLEDB connection string Can anyone provide me with a sample unioledb connection string that I could use in my .NET code? Thanks, Nick Cipollina Pick Programmer ACS Heritage, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)965-8294 --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SELECT stmts forbidden during Transaction in UODOTNET????
I'm not sure what documentation you are reading, the BASIC documentation says you CAN execute SQL statements from within a transaction. See page 96 of the Basic.pdf in you documentation under the heading Transaction Restrictions. It explicitly says you CAN EXECUTE a SELECT. And I do know that my problem lies within Universe (or rather the RPC call to universe, that's why I posted it here... It's a bug in UO .NET I can do a transaction in a PICK account using BASIC programming and have SELECT statements in it without any problem, however doing the same from UO .NET blows the program up. I'm just looking for anyone how has played with UO .NET that might know of a workaround? -Original Message- It's nothing to do with .NET; it's a restriction within UniVerse itself. You can read about what is and isn't allowed while a transaction is active in the UniVerse BASIC manual; it's too long to reproduce here. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 Web Product
It's part of the 'new' Redback. Version 4.3 has been renamed. Haven't seen it yet though. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, June 27, 2006 9:47 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 Web Product Apologies, but never heard of it. What is it? Karl quote who=Cooper, Rudy Hello List, I was curious if anyone was using IBM's U2 Web DE 4.3 product ? If so I wanted to know what you thought about the product. I know I could read about it on IBM's page, but I want to get someone's opinion who is using it. Thx, Rudy Rudy Cooper Technical Project Lead Sage Publications Information Technology Development (805) 410-7724 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- karl _/ _/ _/ _/_/_/ __o _/ _/ _/ _/_/ _-\._ _/_/_/ _/_/_/ (_)/ (_) _/ _/ _/ _/ .. _/ _/ arl _/_/_/ _/ earson[EMAIL PROTECTED] -- IT Director, ATS Industrial Supply, Inc. http://www.atsindustrial.com Toll-free: 800-789-9300 x29 Direct2Desk: 801-978-4429 Facsimile: 801-972-3888 -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 Web Product
That's the new name for Redback. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, June 27, 2006 8:47 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 Web Product Apologies, but never heard of it. What is it? Karl quote who=Cooper, Rudy Hello List, I was curious if anyone was using IBM's U2 Web DE 4.3 product ? If so I wanted to know what you thought about the product. I know I could read about it on IBM's page, but I want to get someone's opinion who is using it. Thx, Rudy Rudy Cooper Technical Project Lead Sage Publications Information Technology Development (805) 410-7724 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- karl _/ _/ _/ _/_/_/ __o _/ _/ _/ _/_/ _-\._ _/_/_/ _/_/_/ (_)/ (_) _/ _/ _/ _/ .. _/ _/ arl _/_/_/ _/ earson[EMAIL PROTECTED] -- IT Director, ATS Industrial Supply, Inc. http://www.atsindustrial.com Toll-free: 800-789-9300 x29 Direct2Desk: 801-978-4429 Facsimile: 801-972-3888 -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SELECT stmts forbidden during Transaction in UODOTNET????
I missed the original question triggering this thread, so I'm not sure if the following is on target or tangential since it has nothing to do with RPC or UO .NET. IIRC, in UV, with Transaction Logging enabled, SQL SELECT is allowed, but will implicitly do a BEGIN TRANSACTION and keep that transaction open for the duration. This, even if you merely extract data, not update. I do not know how to prevent this. As log files fill, they will remain in a NeedSynch state until the SQL SELECT is complete. So, if you have log files that fill within minutes, and SLECTs that run for 1 or 2 hours, you can get into trouble, filling all available logs where they cannot be saved to tape, released, and made available again. I hit this on UV10.0 running on HPUX. FWIW, cds From: Peter Veenhof I'm not sure what documentation you are reading, the BASIC documentation says you CAN execute SQL statements from within a transaction. See page 96 of the Basic.pdf in you documentation under the heading Transaction Restrictions. It explicitly says you CAN EXECUTE a SELECT. And I do know that my problem lies within Universe (or rather the RPC call to universe, that's why I posted it here... It's a bug in UO .NET I can do a transaction in a PICK account using BASIC programming and have SELECT statements in it without any problem, however doing the same from UO .NET blows the program up. I'm just looking for anyone how has played with UO .NET that might know of a workaround? -Original Message- It's nothing to do with .NET; it's a restriction within UniVerse itself. You can read about what is and isn't allowed while a transaction is active in the UniVerse BASIC manual; it's too long to reproduce here. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] A Generous Offer
All, We need your feedback. I just received this very generous offer from Nathan Rector (International Spectrum). We need to know who can attend, sooner the better. For the NJ event, I can commit to chairing the meeting. We are looking for a board member (past or present) to host the Ohio event. Both of these events are conditional on our having attendees. We don't want to waste Nathan's offer on a no-show event. The best way to respond is to reply to this announcement. [AD] From Nathan: International Spectrum would like to invite the U2 User Group to host a User Group meeting in Cincinnati, OH on Sept 25th and in New Jersey, Nov 14th. International Spectrum would like to support the U2 User group by providing a venue and dinner for your meeting. This meeting will be on the 1st night of the International Spectrum Regional Conferences in each of these cities. The fee for your members will be $35 for the dinner if they are not already attending the International Spectrum Conference. If they have registered and are attending the Conference, then their dinner will be included in their registration price. Nathan Rector, President International Spectrum, Inc [EMAIL PROTECTED] http://www.intl-spectrum.com https://207.156.243.15/exchweb/bin/redir.asp?URL=http://www.intl-spectrum.com [/AD] - Charles Barouch, Moderator U2-Users U2-Community RBSolutions SBSolutions Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse all' lists to maintain your access. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] A Generous Offer
Charles, I have a suggestion... have a users group meeting where people want to take a vacation! :-) There are beautiful places all over North Carolina from the beaches to the mountains. Who wants to go to New Jersey or Cincinnati in the summer? I moved away from Cincinnati to be here in NC. It is beautiful and there are lots of places to see. If IS will have a User Group meeting in Raleigh or Wilmington, NC, I will donate my time to help put it together. Swim, Fish, take part in a movie... etc. Kind regards, Patrick Williams 919 567-0042 u2ug wrote: All, We need your feedback. I just received this very generous offer from Nathan Rector (International Spectrum). We need to know who can attend, sooner the better. For the NJ event, I can commit to chairing the meeting. We are looking for a board member (past or present) to host the Ohio event. Both of these events are conditional on our having attendees. We don't want to waste Nathan's offer on a no-show event. The best way to respond is to reply to this announcement. [AD] From Nathan: International Spectrum would like to invite the U2 User Group to host a User Group meeting in Cincinnati, OH on Sept 25th and in New Jersey, Nov 14th. International Spectrum would like to support the U2 User group by providing a venue and dinner for your meeting. This meeting will be on the 1st night of the International Spectrum Regional Conferences in each of these cities. The fee for your members will be $35 for the dinner if they are not already attending the International Spectrum Conference. If they have registered and are attending the Conference, then their dinner will be included in their registration price. Nathan Rector, President International Spectrum, Inc [EMAIL PROTECTED] http://www.intl-spectrum.com https://207.156.243.15/exchweb/bin/redir.asp?URL=http://www.intl-spectrum.com [/AD] - Charles Barouch, Moderator U2-Users U2-Community RBSolutions SBSolutions Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse all' lists to maintain your access. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] MICR fonts with UniData
Thanks! -Original Message- From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Date: Mon, 26 Jun 2006 12:55:38 -0700 Subject: RE: [U2] MICR fonts with UniData John: If you install a MICR DIMM chip into the printer you can print the available fonts. If it is not listed the normal TROY font is: [esc](0Q[esc](s1p12v0s0b0T Then simply reference this in your output stream, like: [esc]a650h7725V to loca the printer cursor, then [esc](0Q[esc](s1p12v0s0b0TC0012002524C A123456789A12 3456789 019C[esc] ...where: 1) C0012002524C is the check ID used by the bank, 2) A123456789 is the Federal Reserve and bank routing#, and 3) 12 3456789 019C is the bank account#. Now reset the character set (or change the font) like [esc](8U. Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Varney Sent: Monday, June 26, 2006 10:28 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] MICR fonts with UniData That's a good start. Thanks! How is the MICR loaded into flash memory? Is it part of a DIMM for the pritner or do you load it like a PCL soft font? Thanks! -Original Message- From: Norman Morgan [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Date: Mon, 26 Jun 2006 10:48:09 -0500 Subject: RE: [U2] MICR fonts with UniData We do this. Our check stock is regular check safety paper with both top and bottom stubs. The center section has the security patterns, microprinting, etc., along with a color logo. Everything else added by the laser printer when we do the check printing with a UniBasic program. The printer has a MICR font stored in flash memory, along with a form overlay image and uses a MICR toner cartridge. The program lays out the text for the check, shifting in and out of the MICR font as appropriate, then just before adding a form feed, it sends the escape sequences to call the forms overlay which is stored as a PCL macro in the printers flash memory. Here are some code snips from the program: *** Define control info for laser printers ESC = CHAR(27); FORMFEED = CHAR(12) FORM.DEF = ESC:f112Y FORM.CALL = ESC:f3X SET.FONT.COURIER = ESC:(10U:ESC:(s0p10h0s0b4099T SET.FONT.MICR = ESC:(10O:ESC:(s0p8.00h11.0v0s0b70T SET.FONT.LINE.PRT = ESC:(10U:ESC:(s0p16.67h8.5v0s0b0T PRINTER.RESET = ESC:E SET.PRINTER.LANDSCAPE = ESC:l2a0o6d0S SET.PRINTER.PORTRAIT = ESC:(l2a1o0S PRINTER.FORM.SET = SET.PRINTER.LANDSCAPE : SET.FONT.COURIER PRINTER.FORM.SET := ESC:l1e64F:FORMFEED GOSUB PrintTopStub GOSUB PrintCheckBody GOSUB PrintBottomStub GOSUB PostGoodCheck PRINT FORM.DEF: PRINT FORM.CALL: PRINT FORMFEED: PrintCheckBody: *** Codes to position on form ** PRINT ESC:a2585v5328H: PRINT CKNOR%6 PRINT :CKNOR%6: :OCONV(DATE(),D2/)R#8: :VNOL#7 PRINT PRINT PRINT NET = TOT(3) GOSUB BuildWordAmount PRINT SPACE(4):WORD L#80 PRINT; PRINT IF NET+0 = 0 THEN NET = 000 PRINT SPACE(65):OCONV(NET,MD2)R2,*14 PRINT PRINT PRINT SPACE(11):VEND1 L#40 PRINT SPACE(11):VEND2 L#40 IF VEND3 # THEN PRINT SPACE(11):VEND3 L#40 IF VEND4 # THEN PRINT SPACE(11):VEND4 L#40 PRINT SPACE(11):VEND5,1:' ':VEND5,2:' ':VEND5,3 *** Select MICR font Position MICR line to Check # PRINT SET.FONT.MICR: PRINT ESC:a4730v1020H: *** Print Check Number PRINT CHAR(47):CKNOR%6:CHAR(47): : *** Print Routing Number PRINT CHAR(38):ROUTING.NUM:CHAR(38): : *** Print Account Number PRINT ACCOUNT.NUM:CHAR(47): *** Switch back to Courier Font PRINT SET.FONT.COURIER: RETURN === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === Why does mineral water that has trickled through mountains for centuries have a 'use by' date? === -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Monday, June 26, 2006 9:39 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] MICR fonts with UniData I thought you wanted it printed from Unidata? -Original Message- From: John Varney [mailto:[EMAIL PROTECTED] Sent: Monday, June 26, 2006 9:29 AM To: Jerry Banker Subject: RE: [U2] MICR fonts with UniData I wish I could do it that way, but the checks are coming directly from a unix box via a routine that uses PCL5 to format blank stock. As far as I can tell I have to either use a laser printer with the MICR font
RE: [U2] MICR fonts with UniData
Again, thanks Bill! -Original Message- From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Date: Mon, 26 Jun 2006 13:25:34 -0700 Subject: RE: [U2] MICR fonts with UniData John: Only if it's designed to do so. For instance, you can use the same DIMM chip on a 4000 4050. You need to contact them by going to www.troygroup.com. Or use Google to search for TROY DIMM chips. These chips are really very inexpensive. Some of the toner, on the other hand, is rather expensive. Depending on your output load, solutions are really inexpensive overall. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Varney Sent: Monday, June 26, 2006 11:47 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] MICR fonts with UniData I'm looking at that as one option. Do you know if those DIMMs can be used in more than one printer, for instance the laser printer with the DIMM goes down. Can I trnasplant the DIMM into another like printer (HP 8100, 9000, etc) to get checks out the door? -Original Message- From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Date: Mon, 26 Jun 2006 10:51:46 -0700 Subject: RE: [U2] MICR fonts with UniData John: Make you life easier and use a MICR font DIMM chip. They can be purchased from TROY and make programming much easier and are much more reliable. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Varney Sent: Monday, June 26, 2006 4:44 AM To: u2-users@listserver.u2ug.org Subject: [U2] MICR fonts with UniData Has anyone used a MICR soft font with UniData? I have a project to print checks and am wondering how other people hander the MICR font for account / routine numbers. Thanks. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] A Generous Offer
I can attend in NJ -Original Message- From: u2ug [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org, [EMAIL PROTECTED] Date: Tue, 27 Jun 2006 12:08:35 -0400 Subject: [U2] A Generous Offer All, We need your feedback. I just received this very generous offer from Nathan Rector (International Spectrum). We need to know who can attend, sooner the better. For the NJ event, I can commit to chairing the meeting. We are looking for a board member (past or present) to host the Ohio event. Both of these events are conditional on our having attendees. We don't want to waste Nathan's offer on a no-show event. The best way to respond is to reply to this announcement. [AD] From Nathan: International Spectrum would like to invite the U2 User Group to host a User Group meeting in Cincinnati, OH on Sept 25th and in New Jersey, Nov 14th. International Spectrum would like to support the U2 User group by providing a venue and dinner for your meeting. This meeting will be on the 1st night of the International Spectrum Regional Conferences in each of these cities. The fee for your members will be $35 for the dinner if they are not already attending the International Spectrum Conference. If they have registered and are attending the Conference, then their dinner will be included in their registration price. Nathan Rector, President International Spectrum, Inc [EMAIL PROTECTED] http://www.intl-spectrum.com https://207.156.243.15/exchweb/bin/redir.asp?URL=http://www.intl-spect rum.com [/AD] - Charles Barouch, Moderator U2-Users U2-Community RBSolutions SBSolutions Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse all' lists to maintain your access. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] MICR fonts with UniData
I was told that the placement of the routing and account number is very important. Thanks Colin! -Original Message- From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Date: Mon, 26 Jun 2006 14:05:27 -0700 Subject: RE: [U2] MICR fonts with UniData John; As Bill says - it's a lot easier to get the chip. I think all of our clients work that way. You also need to use the special MICR toner. Usually it's harder to move the toner to a different printer than the chip. Remember that the M in MICR is for magnetic. It's special toner. The best part is that they usually come with a template you can use to line up the MICR line. It has to be in a specific location and format for the automatic readers. Hth Colin Alfke Calgary Canada -Original Message- From: Bill Haskett John: Only if it's designed to do so. For instance, you can use the same DIMM chip on a 4000 4050. You need to contact them by going to www.troygroup.com. Or use Google to search for TROY DIMM chips. These chips are really very inexpensive. Some of the toner, on the other hand, is rather expensive. Depending on your output load, solutions are really inexpensive overall. Bill -Original Message- From: John Varney I'm looking at that as one option. Do you know if those DIMMs can be used in more than one printer, for instance the laser printer with the DIMM goes down. Can I trnasplant the DIMM into another like printer (HP 8100, 9000, etc) to get checks out the door? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] A Generous Offer
Bad idea, in my humble opinion. I like the idea of a dinner in the local areas. It does two things. First, it brings people from the area together for some good networking. Secondly, it may spawn a dynamic local group of users in the area. Creating a local source of information, communication and professional opportunities. Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat.t. roosevelt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of will Sent: Tuesday, June 27, 2006 1:17 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] A Generous Offer Charles, I have a suggestion... have a users group meeting where people want to take a vacation! :-) There are beautiful places all over North Carolina from the beaches to the mountains. Who wants to go to New Jersey or Cincinnati in the summer? I moved away from Cincinnati to be here in NC. It is beautiful and there are lots of places to see. If IS will have a User Group meeting in Raleigh or Wilmington, NC, I will donate my time to help put it together. Swim, Fish, take part in a movie... etc. Kind regards, Patrick Williams 919 567-0042 u2ug wrote: All, We need your feedback. I just received this very generous offer from Nathan Rector (International Spectrum). We need to know who can attend, sooner the better. For the NJ event, I can commit to chairing the meeting. We are looking for a board member (past or present) to host the Ohio event. Both of these events are conditional on our having attendees. We don't want to waste Nathan's offer on a no-show event. The best way to respond is to reply to this announcement. [AD] From Nathan: International Spectrum would like to invite the U2 User Group to host a User Group meeting in Cincinnati, OH on Sept 25th and in New Jersey, Nov 14th. International Spectrum would like to support the U2 User group by providing a venue and dinner for your meeting. This meeting will be on the 1st night of the International Spectrum Regional Conferences in each of these cities. The fee for your members will be $35 for the dinner if they are not already attending the International Spectrum Conference. If they have registered and are attending the Conference, then their dinner will be included in their registration price. Nathan Rector, President International Spectrum, Inc [EMAIL PROTECTED] http://www.intl-spectrum.com https://207.156.243.15/exchweb/bin/redir.asp?URL=http://www.intl-spectr um.com [/AD] - Charles Barouch, Moderator U2-Users U2-Community RBSolutions SBSolutions Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse all' lists to maintain your access. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] A Generous Offer
I live and work in Wilmington, NC. I would be happy to help arrange a conference here. :) Though, I have to admit that I'm not a pure U2 user. :/ --- Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 e-mail: [EMAIL PROTECTED] --- www.allspec.com --- -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of will Sent: Tuesday, June 27, 2006 1:17 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] A Generous Offer Charles, I have a suggestion... have a users group meeting where people want to take a vacation! :-) There are beautiful places all over North Carolina from the beaches to the mountains. Who wants to go to New Jersey or Cincinnati in the summer? I moved away from Cincinnati to be here in NC. It is beautiful and there are lots of places to see. If IS will have a User Group meeting in Raleigh or Wilmington, NC, I will donate my time to help put it together. Swim, Fish, take part in a movie... etc. Kind regards, Patrick Williams 919 567-0042 u2ug wrote: All, We need your feedback. I just received this very generous offer from Nathan Rector (International Spectrum). We need to know who can attend, sooner the better. For the NJ event, I can commit to chairing the meeting. We are looking for a board member (past or present) to host the Ohio event. Both of these events are conditional on our having attendees. We don't want to waste Nathan's offer on a no-show event. The best way to respond is to reply to this announcement. [AD] From Nathan: International Spectrum would like to invite the U2 User Group to host a User Group meeting in Cincinnati, OH on Sept 25th and in New Jersey, Nov 14th. International Spectrum would like to support the U2 User group by providing a venue and dinner for your meeting. This meeting will be on the 1st night of the International Spectrum Regional Conferences in each of these cities. The fee for your members will be $35 for the dinner if they are not already attending the International Spectrum Conference. If they have registered and are attending the Conference, then their dinner will be included in their registration price. Nathan Rector, President International Spectrum, Inc [EMAIL PROTECTED] http://www.intl-spectrum.com https://207.156.243.15/exchweb/bin/redir.asp?URL=http://www.intl- spectrum.com [/AD] - Charles Barouch, Moderator U2-Users U2-Community RBSolutions SBSolutions Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse all' lists to maintain your access. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] A Generous Offer
besides, NJ doesn't smell anymoreat least not that much :) I didn't follow the link, but where in NJ is the spectrum being held at? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Barry Rogen Sent: Tuesday, June 27, 2006 2:22 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] A Generous Offer Bad idea, in my humble opinion. I like the idea of a dinner in the local areas. It does two things. First, it brings people from the area together for some good networking. Secondly, it may spawn a dynamic local group of users in the area. Creating a local source of information, communication and professional opportunities. Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat.t. roosevelt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of will Sent: Tuesday, June 27, 2006 1:17 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] A Generous Offer Charles, I have a suggestion... have a users group meeting where people want to take a vacation! :-) There are beautiful places all over North Carolina from the beaches to the mountains. Who wants to go to New Jersey or Cincinnati in the summer? I moved away from Cincinnati to be here in NC. It is beautiful and there are lots of places to see. If IS will have a User Group meeting in Raleigh or Wilmington, NC, I will donate my time to help put it together. Swim, Fish, take part in a movie... etc. Kind regards, Patrick Williams 919 567-0042 u2ug wrote: All, We need your feedback. I just received this very generous offer from Nathan Rector (International Spectrum). We need to know who can attend, sooner the better. For the NJ event, I can commit to chairing the meeting. We are looking for a board member (past or present) to host the Ohio event. Both of these events are conditional on our having attendees. We don't want to waste Nathan's offer on a no-show event. The best way to respond is to reply to this announcement. [AD] From Nathan: International Spectrum would like to invite the U2 User Group to host a User Group meeting in Cincinnati, OH on Sept 25th and in New Jersey, Nov 14th. International Spectrum would like to support the U2 User group by providing a venue and dinner for your meeting. This meeting will be on the 1st night of the International Spectrum Regional Conferences in each of these cities. The fee for your members will be $35 for the dinner if they are not already attending the International Spectrum Conference. If they have registered and are attending the Conference, then their dinner will be included in their registration price. Nathan Rector, President International Spectrum, Inc [EMAIL PROTECTED] http://www.intl-spectrum.com https://207.156.243.15/exchweb/bin/redir.asp?URL=http://www.i ntl-spectr um.com [/AD] - Charles Barouch, Moderator U2-Users U2-Community RBSolutions SBSolutions Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse all' lists to maintain your access. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] MICR fonts with UniData
John - it's critical. Normally, we do a run of 20 cheques that we give to the bank which sends them to its testing centre. About a month later we get them back with a report detailing anything that is incorrect. They measure things like: MICR clear band, MICR character skew, MICR line skew, horizontal character position, vertical character position, character print quality, correct data, enough magnetic ink, etc. When we bought the MICR dimm we got a template that shows where everything needs to print. Good luck Colin Alfke Calgary, Canada -Original Message- From: John Varney I was told that the placement of the routing and account number is very important. Thanks Colin! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] A Generous Offer
At least one representative from Aptron Corporation will attend the NJ event. -Dianne u2ug wrote: All, We need your feedback. I just received this very generous offer from Nathan Rector (International Spectrum). We need to know who can attend, sooner the better. For the NJ event, I can commit to chairing the meeting. We are looking for a board member (past or present) to host the Ohio event. Both of these events are conditional on our having attendees. We don't want to waste Nathan's offer on a no-show event. The best way to respond is to reply to this announcement. [AD] From Nathan: International Spectrum would like to invite the U2 User Group to host a User Group meeting in Cincinnati, OH on Sept 25th and in New Jersey, Nov 14th. International Spectrum would like to support the U2 User group by providing a venue and dinner for your meeting. This meeting will be on the 1st night of the International Spectrum Regional Conferences in each of these cities. The fee for your members will be $35 for the dinner if they are not already attending the International Spectrum Conference. If they have registered and are attending the Conference, then their dinner will be included in their registration price. Nathan Rector, President International Spectrum, Inc [EMAIL PROTECTED] http://www.intl-spectrum.com https://207.156.243.15/exchweb/bin/redir.asp?URL=http://www.intl-spectrum.com [/AD] - Charles Barouch, Moderator U2-Users U2-Community RBSolutions SBSolutions Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse all' lists to maintain your access. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Dianne Ackerman Director, Application Development Support Aptron Corporation www.aptron.com P: 973/822-0700, ext. 105 F: 973/822-3234 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] A Generous Offer
I believe that the Cincinnati OH event is already being hosted by Ashwood Computer Company, Rod Owens. Contact would be [EMAIL PROTECTED] Mailings have already be made as have other arrangements. Tom Dodds [EMAIL PROTECTED] 513-563-2800 Cincinnati Office 708-234-9608 Chicago Office 630-235-2975 Anywhere Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of u2ug Sent: Tuesday, June 27, 2006 12:09 PM To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED] Subject: [U2] A Generous Offer All, We need your feedback. I just received this very generous offer from Nathan Rector (International Spectrum). We need to know who can attend, sooner the better. For the NJ event, I can commit to chairing the meeting. We are looking for a board member (past or present) to host the Ohio event. Both of these events are conditional on our having attendees. We don't want to waste Nathan's offer on a no-show event. The best way to respond is to reply to this announcement. [AD] From Nathan: International Spectrum would like to invite the U2 User Group to host a User Group meeting in Cincinnati, OH on Sept 25th and in New Jersey, Nov 14th. International Spectrum would like to support the U2 User group by providing a venue and dinner for your meeting. This meeting will be on the 1st night of the International Spectrum Regional Conferences in each of these cities. The fee for your members will be $35 for the dinner if they are not already attending the International Spectrum Conference. If they have registered and are attending the Conference, then their dinner will be included in their registration price. Nathan Rector, President International Spectrum, Inc [EMAIL PROTECTED] http://www.intl-spectrum.com https://207.156.243.15/exchweb/bin/redir.asp?URL=http://www.intl-spectrum.c om [/AD] - Charles Barouch, Moderator U2-Users U2-Community RBSolutions SBSolutions Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse all' lists to maintain your access. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] MICR fonts with UniData
We have been doing laser checks from different platforms for a long time. Don't forget a good quality secure check stock. We use a company ACOM.com which used to be Secure-A-Check who create a nice check stock form to print on, which has many security features so it is difficult to photocopy the check. http://www.orderprintersupplies.com/product_catalog.aspx?category_guid=2742c 57f-6b40-4acb-8920-17f5f444cf6a -Original Message- From: John Varney [SMTP:[EMAIL PROTECTED] Sent: Monday, June 26, 2006 4:44 AM To: u2-users@listserver.u2ug.org Subject: [U2] MICR fonts with UniData Has anyone used a MICR soft font with UniData? I have a project to print checks and am wondering how other people hander the MICR font for account / routine numbers. Thanks. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] A Generous Offer
Tom, It is hosted by Ashwood. I meant, someone to Host (chair) the U2UG dinner the night before the Spectrum show. I'm sorry if I wasn't clear. - Chuck Tom Dodds wrote: I believe that the Cincinnati OH event is already being hosted by Ashwood Computer Company, Rod Owens. Contact would be [EMAIL PROTECTED] Mailings have already be made as have other arrangements. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] A Generous Offer
I became clear, to me, when Heather explained that she knew of the U2 user group meeting. Thanks for the follow up. Tom Dodds [EMAIL PROTECTED] 513-563-2800 Cincinnati Office 708-234-9608 Chicago Office 630-235-2975 Anywhere Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Results Sent: Tuesday, June 27, 2006 5:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] A Generous Offer Tom, It is hosted by Ashwood. I meant, someone to Host (chair) the U2UG dinner the night before the Spectrum show. I'm sorry if I wasn't clear. - Chuck Tom Dodds wrote: I believe that the Cincinnati OH event is already being hosted by Ashwood Computer Company, Rod Owens. Contact would be [EMAIL PROTECTED] Mailings have already be made as have other arrangements. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [uv] Help with SQL select
Hi, Ibm trying to get a unique list from a delimited field into an XML document. If I use a SQL bDISTINCTb select it aborts half way through. In ReVise it bwouldb be SORT FILE BY COL1 BREAK.ON COL1 COL2 COL3 COL4 DET.SUP ID.SUP except that I canbt use a TOXML clause with this statement. In SQL itbs bSELECT DISTINCT COL1,COL2,COL3,COL4 FROM FILE ORDER BY COL1 TOXML;b. But Ibm finding when I run this from TCL that this stops halfway through with an bAborting!b error. All of the COLn fields are I-types which do a field() extract on a single delimitated attribute. (eg FIELD(@RECORD2,'/',2)). If I take out one of the columns or the DISTINCT clause in the SQL statement then it selects to the end of the table. If I add columns it aborts earlier. The ORDER.BY and the TOXML clauses donbt seem to make any difference. Is this a limitation on I-types in SQL selects? Has anyone come across this problem before and is there a work around? Alternatively, can someone suggest another way to do this using a single ReVise statement? This is on UV10.0.7/AIX, in an SB+ 5.0.4 account at real TCL. Thanks, Stuart Boydell ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re-Comile I-Descriptors ?
Several (working) legacy paragraph scripts yield errors on our new UniVerse server. The errors resemble... Conversion MD1 is incompatible with an INTEGER datatype. Do I need to re-compile I-Descriptors ? The legacy UniVerse is v 8.3.3; the new UV is v10. Both machines are HP-Ux. Suggestions would be appreciated. -Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re-Comile I-Descriptors ?
COMPILE-DICT It doesn't hurt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill Sent: Tuesday, June 27, 2006 8:05 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Re-Comile I-Descriptors ? Several (working) legacy paragraph scripts yield errors on our new UniVerse server. The errors resemble... Conversion MD1 is incompatible with an INTEGER datatype. Do I need to re-compile I-Descriptors ? The legacy UniVerse is v 8.3.3; the new UV is v10. Both machines are HP-Ux. Suggestions would be appreciated. -Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re-Comile I-Descriptors ?
Sounds like you've got INTEGER specified in field 8 (SQL Data) and MD1 specified in field 3 (Conversion) of the dictionary for the problematic field. Just removing INTEGER will fix the problem - but if you're using SQL on the file/table maybe you should replace INTEGER with the correct field type. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Wednesday, 28 June 2006 8:05 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Re-Comile I-Descriptors ? Several (working) legacy paragraph scripts yield errors on our new UniVerse server. The errors resemble... Conversion MD1 is incompatible with an INTEGER datatype. Do I need to re-compile I-Descriptors ? The legacy UniVerse is v 8.3.3; the new UV is v10. Both machines are HP-Ux. Suggestions would be appreciated. -Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/