RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms
Glen, snip You always get the good ones, doncha? What does the warehouse control system use as a database? How many different O/S are we looking at here? The first idea that comes to mind is transactional queuing and inspection. A FIFO updating situation will not work, since you have logic that is updating data on all sides of the triangle, potentially at the same time. You need all 3 facets of the system to contact and update a single data store. I would recommend either another MS SQL server or a MySQL server. With UV, you can access SQL tables as MV files, right?(MV triggers to update SQL maybe) Can you get the warehouse control system to read/write from that SQL database, too? As far as MS SQL, is there a reason that will prevent you from linking the existing MS SQL table structures to a central data store that will contain the (moved) data? I don't think you're going to get out of this without some major internal tweaking, data relocation, and application code changes. /snip Well, I was actually only tasked with making the ATS more real time for our Asia sales office. Since they're entering orders during our night, they always get the short end of the stick, ATS may or may not be right; the batch updates are all timed/tuned for US timezone (and work pretty accurately heretofore). Anyway... we all hate partial solutions ... so one gets to contemplating, and one thing leads to another. I don't have enough clout around here to convince them to add yet another data store to their enterprise, but I agree with you - you must establish referential integrity to go real time with this cluster. UniVerse is presently the quasi-reference point [UniVerse is the center of our world - figure that out isaac asimov], but it's only perfectly accurate once a day. Answers to your questions: a) WCS uses an ISAM db b) Unix Windows I like your solution to the puzzle Glen. ... clear thinking as always. rgds, -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD}
synchronization issues - they may be unavoidable, but where they aren't they can cost you big time - Use multi-threading to mitigate end-to-end delay Robert Houben CTO Logo: FusionWare Corporation - Enterprise Service Bus (ESB), Service-Oriented Architecture (SOA) 604-633-9891 #158 mailto:[EMAIL PROTECTED] http://www.fusionware.net /AD -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, October 23, 2007 12:15 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms Janet, snip/ I can setup a conference call with one of Developers. We have been in the transferring MultiValue data to other data sources since the early 80's (PK Harmony to start with, anyone remember). We may have some good input for you. /snip I'm not in a position to buy anything, really just trying to think through the questions posted. It would be lovely to have your developer join the thread and describe how PKH/FW does it's magic. Not expecting him to share code, of course, just a few thoughts about your approach is all. Sorry to draw you into the cross fire, that's why I said what I did about ads; maybe I should've put it at the top though. sincere regards, -Baker --- 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] Fastest Bi-Directional data transfer btwn MV and non MV dbms
Hey, What is the fastest and lowest cpu overhead method of transferring data between U2/MV databases, and other data sources? Assumed: a) no restrictions on underlying OS - whichever best facilitates your proposed method. b) no restrictions on Database of choice - I know this is a U2 list and we all have commitments to it, but if someone else (QM, Cache, D3...) is doing something that we ought to be doing in U2, name the db and feat they are accomplishing. C) Production system - the system must also support your OLTP users, not dedicated to data serving The primary concern is throughput, screaming fast throughput. Dogs that won't hunt: 1) if you want to take a potshot at methods that are in your estimation - tired dogs - take aim. 2) beneficent and ruthless honesty - so that this doesn't descend into a religious war please be honest yet charitable. 3) No Ads - don't respond with [just] a product name, tell what it does, the underlying method / technology We are after the technically superior destination, emotions aside, barring past development investments. I'm trying to take a clean white board approach to this question and appreciate your help in answering it. A few to consider [just as starters]: i) old jacks - WRITE/READBLK from MV triggered by whatever signal/method ii) Ajax - Async jscript Xml iii) ODBC / JDBC Thanks so much, -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms
Thanks Jerry for the introduction. Pleased to meet you Jeff. I don't post everyday, sort of ebbs and flows with workload, so you may not have seen me before... and I probably post more questions than answers ... just glad to be a part. humor sort of refreshing to be called a troll, I stand 6'8 and usually draw other names from folks grin/humor Jeff - your response about sockets, along with Kevins, are noted. Thanks. Have a great day, -Baker Hughes -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, October 23, 2007 12:10 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms Not likely, Baker Hughes has been in the PICK arena for many moons and is one of the founders of the Texas users group. -Original Message- From: Jeff Schasny [mailto:[EMAIL PROTECTED] humorIs it just me or does it smell like troll in here all of a sudden/humor --- 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] Fastest Bi-Directional data transfer btwn MV and non MV dbms
Janet, snip/ I can setup a conference call with one of Developers. We have been in the transferring MultiValue data to other data sources since the early 80's (PK Harmony to start with, anyone remember). We may have some good input for you. /snip I'm not in a position to buy anything, really just trying to think through the questions posted. It would be lovely to have your developer join the thread and describe how PKH/FW does it's magic. Not expecting him to share code, of course, just a few thoughts about your approach is all. Sorry to draw you into the cross fire, that's why I said what I did about ads; maybe I should've put it at the top though. sincere regards, -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [U2C] New poll for Texas area
Still trolling for Multi-Value people in TEXas or adjacent states I trust our other colleagues will view our efforts beneficently and rejoice at the activity among local user groups. Warm regards, -Baker TEXMUG Moderator --- Enter your vote today! A new poll has been created for the texas_mug group: What Multi-Value platforms have you become proficient on? Check all those that you have supported or developed on. Please do not limit your response to current involvements. We'd like to know your whole historical picture. (Some of the earlier MV implementations are still in use so you're not showing your age necessarily). Responses to this poll are anonymous, like the last one. In the next poll we'll ask for total years in Multi-Value. o OpenQM / QM from Ladybridge o Cache' from InterSystems o Arev / Revelation o OpenInsight / JOI o Pick R83 o GA R91 or Power95 o AP/PRO or Advanced Pick o D3 (any ver.) o Adds Mentor / Mentor Pro o jBase o GA Zebra or other GA not listed o mvBase o mvEnterprise / mvPro o MaVerick o Sequoia / SeqPro o Ultimate / UltPlus o UniVision (Via Systems) o Honeywell running any Pick db o Siemens Nixdorf o Fujitsu running any Pick db o Prime Information or PI/Open o Reality - any native on McD hardware o Realityx (on any Winx or *nix) o UniVerse (any ver.) o UniData (any ver.) To vote, please visit the following web page: http://groups.yahoo.com/group/texas_mug/surveys?id=2280264 Note: Please do not reply to this message. Poll votes are not collected via email. To vote, you must go to the Yahoo! Groups web site listed above. Thanks! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Over-coming EDitor shortcomings
/snip FIX 0001 PA 0002 FORMAT BP I2,Enter BP item 0003 ED BP I2,Enter BP item 0004 HUSH ON 0005 DELETE BP.O I2,Enter BP item 0006 HUSH OFF 0007 BASIC BP I2,Enter BP item My 2 bits on this topic. Karl snip\ Which is why I like the AE [alternate] editor. Once you've executed a format command in your logon session, you simply type 'FOR' at any time the rest of the day, in any edit session, to format with the same parameters. FOR -I3 -M3 [Indention of 3, margin of 3] BTW, If you're chasing a pesky bug that's hidden in a 14 tier nested LOOP,IF,CASE,Whatever then use this: 'FOR -TRACE' it will put pipes in for you where we used to draw lines with our ruler to trace the logical flow. Then when your done and want to compile: 'FIBR' will file it, compile it, and run it [don't get to habitual with the 'R' if your in a sub]. The AE invoked compiler removes the old source when it starts, that way if the compile produces no object, it doesn't run the old object code. At least this is the behavior on UV 10 or higher. 356: 357:IF HOLD # '' AND NOT(ALARM) THEN *--: FOR -I3 -M3 Margin=3, Indentation=3, -incase !! *--: FOR Margin=3, Indentation=3, -incase !! *--: FIB Filed DOE.WRITE.SUB.F1675 in file BHB. Compiling: Source = '/system1/dev.programs/BHB/DOE.WRITE.SUB.F1675', Object = '/system1/dev.programs/BHB.O/DOE.WRITE.SUB.F1675' *** 000671 Compilation Complete. Of course, you could stack the FORmat command and the FIBR command into a saved prestore that you recall when you begin your edit session, but that's another subject. FWIW, -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Green Screen Dev. Environment
You should take a look at Nucleus. It generates a characters screen, an Accuterm GUI screen, or .Net GUI all from the same code. Develop character screens in minutes, and If you ever decide to go GUI, just do it, no rollout to clients. (your desktop group will love you for this) binary-removethis-star.com Although we use their source safe solution we haven't begun using their IDE yet, but it is impressive. It appears the learning ramp is shorter than SB. I have no connection with Binary Star, just a Developer at a licensed site. HTH, -Baker Hi list, I know we can use gui tools like VS, MV.net, etc, but our transactional system is all character based and that's what we want to stick with for the time being. I know AREV and SB+ are out there, but are there others that anyone is using that is not 'home grown'? And if you are using AREV or SB+ how do you like it? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Telnet error 1067 in Universe PE
Hey y'all, A couple of us are trying to help a new UV site nearby get a copy of PE going for a development machine. This is the same issue that Charles B. first introduced some weeks back. I took a look at the IBM Thinkpad last night. Here is the skinny. OS is XPpro. He has un-installed and re-installed PE-UV 10.2 with same results: UniVerse will start when machine boots, but not telnet. When you attempt to start manually, you get Telnet error 1067. We looked in system.Ini to see if anything is actually bound to port 23 - nothing appears to be. He also ran TCPview to see if anything is listening on port 23 - nothing. We thought of changing the telnet port from 23 to something else, but when we try to start UniAdmin we get an RPC error. He checked the windows event log and it records the UV telnet service not starting with an error WSA Error 10038. These folks are extremely happy with UniVerse and the application that is helping grow their business. PE offers the best option for their getting more familiar with UV and speeding future development. Please help. The right answer will make you guest of honor at the next TEXMUG meeting Nov 1 (free meal!)[travel not included ;-) ] Sincere thanks, -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Telnet error 1067 in Universe PE
Our Texas User now reports that he got PE-UV running fine when installing on a pretty fresh laptop running XPpro. Apparently, something on both a Win2k desktop and a XPpro laptop wasn't playing nice with PE. He's up going for now but we're still hoping for resolution/understanding. Glen - Just clarifying, you think maybe there's a bug in the UV code regarding the listener? Thanks for your input. I hope this isn't a leap but could this be related to Augusto's issue, Subj:Denial of Service in UVRPC... Thanks. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glen Batchelor Sent: Wednesday, September 19, 2007 1:26 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Telnet error 1067 in Universe PE Winsock 100038 is Error - that is not a socket. Something, in the code, is trying to listen on a non-socket file descriptor. Naughty Naughty! Glen Batchelor UniVerse will start when machine boots, but not telnet. When you attempt to start manually, you get Telnet error 1067. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Telnet error 1067 in Universe PE
Man, we nailed this issue, thanks to Glen, and Bill, and Martin, and Drew, and Tony G, and Dick. Fantastic research, help, historical links. As they say in Yewston, 'you guys 'er ALL-som !' ;-) -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Moving Average Cost
Thanks to each who replied. Between Larry's response below, and additional analysis by a comrade in-shop, I am convinced Formula A is correct. ABSolute values should not be used. I'm thankful to be surrounded by thinkers ... on those brain tired afternoons. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Hiscock Sent: Tuesday, August 28, 2007 4:12 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Moving Average Cost Don't use absolute value, or you'll screw up your average costs. When you're adjusting inventory out, you're REDUCING the total value of your inventory. The average cost for whatever's left should be the new inventory total value divided by the new quantity on hand. For example: if you receive 10,000 at cost X, then adjust 10,000 out at the same cost, your average cost should be what it was before you did the initial receipt. If you use absolute values, your average cost will go up, and your inventory will be overstated. Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, August 28, 2007 11:33 AM To: u2-users@listserver.u2ug.org Subject: [U2] Moving Average Cost Hey, I have a distribution/manufacturing question. Could some of you share your formula for calculating Moving Average Cost. Consider: Assume you are receiving stock into the warehouse, and recalculating your new average cost upon each receipt (which later serves as basis for your cost-plus price quote, but that's immaterial to the formula). Since you also have negative stock movements (cycle count inventory adjustments, or adjust quantities on- purchase receipts) should you not use the absolute qty and absolute cost of the movement, when calculating your moving avg cost? Formula A: Extended.Cost.Rcpt = Qty.Rcvd * Cost.Ea Total.Inventory.Value = (Qty.OH * Old.Avg.Cost) + Extended.Cost.Rcpt Total.QOH = Qty.OH + Qty.Rcvd New.Avg.Cost = Total.Inventory.Value / Total.QOH Ex. 1 - a positive Qty Received: Extended.Cost.Rcpt = 10,000 * 2.8242 [28,242.00] Total.Inventory.Value = (11,000 * 2.8215) + Extended.Cost.Rcpt [59,278.50] Total.QOH = 11,000 + 10,000 [21,000] New.Avg.Cost = 59,278.5 / 21,000 [2.8227] Ex. 2 - a negative Qty Received (Adjusted): Extended.Cost.Rcpt = -10,000 * 2.8242 [-28,242.00] Total.Inventory.Value = (11,000 * 2.8215) + Extended.Cost.Rcpt [2,794.50] Total.QOH = 11,000 - 10,000 [1,000] New.Avg.Cost = 2,794.50 / 1,000 [2.7945] Formula B: Extended.Cost.Rcpt = ABS(Qty.Rcvd) * ABS(Cost.Ea) Total.Inventory.Value = (Qty.OH * Old.Avg.Cost) + Extended.Cost.Rcpt Total.ABS.QOH = Qty.OH + ABS(Qty.Rcvd) New.Avg.Cost = Total.Inventory.Value / Total.ABS.QOH With Formula B the new.avg.cost would be the same for both Ex. 1 2 TIA, -Baker --- 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] Moving Average Cost
Hey, I have a distribution/manufacturing question. Could some of you share your formula for calculating Moving Average Cost. Consider: Assume you are receiving stock into the warehouse, and recalculating your new average cost upon each receipt (which later serves as basis for your cost-plus price quote, but that's immaterial to the formula). Since you also have negative stock movements (cycle count inventory adjustments, or adjust quantities on- purchase receipts) should you not use the absolute qty and absolute cost of the movement, when calculating your moving avg cost? Formula A: Extended.Cost.Rcpt = Qty.Rcvd * Cost.Ea Total.Inventory.Value = (Qty.OH * Old.Avg.Cost) + Extended.Cost.Rcpt Total.QOH = Qty.OH + Qty.Rcvd New.Avg.Cost = Total.Inventory.Value / Total.QOH Ex. 1 - a positive Qty Received: Extended.Cost.Rcpt = 10,000 * 2.8242 [28,242.00] Total.Inventory.Value = (11,000 * 2.8215) + Extended.Cost.Rcpt [59,278.50] Total.QOH = 11,000 + 10,000 [21,000] New.Avg.Cost = 59,278.5 / 21,000 [2.8227] Ex. 2 - a negative Qty Received (Adjusted): Extended.Cost.Rcpt = -10,000 * 2.8242 [-28,242.00] Total.Inventory.Value = (11,000 * 2.8215) + Extended.Cost.Rcpt [2,794.50] Total.QOH = 11,000 - 10,000 [1,000] New.Avg.Cost = 2,794.50 / 1,000 [2.7945] Formula B: Extended.Cost.Rcpt = ABS(Qty.Rcvd) * ABS(Cost.Ea) Total.Inventory.Value = (Qty.OH * Old.Avg.Cost) + Extended.Cost.Rcpt Total.ABS.QOH = Qty.OH + ABS(Qty.Rcvd) New.Avg.Cost = Total.Inventory.Value / Total.ABS.QOH With Formula B the new.avg.cost would be the same for both Ex. 1 2 TIA, -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Credit Card Processing
Scott, We use Chase Paymentech to process our CC transactions. They are pretty decent to deal with. They are pretty big so having a good acct manager to get what you need makes all the difference. They handle all card brands and multiple currencies (if connecting your web portal). Just a thought as you approach your implementation: You bring a whole new world of data security requirements to bear on your business app if you bring credit card data directly into it. It's a beautiful thing to wed a CC interface right to your application, and we have the upper hand in the MV world, but the Payment Card Industry Data Security Standard is a nasty document that will cost your organization quite a bit to comply, and you get zero ROI (IMHO), except perhaps some clout for your company brand as being PCI compliant. I doubt your store front customers, in a brick and mortar setting, are going to be impressed that your business app is PCI compliant. You might be best served by looking for a POS credit card app on a stand-alone server, that is the system of record for all CC transactions/data and does your data at rest encryption. Then just communicate with that server from UV about whether the CC Auth went through, was deposited, etc. HTH, -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, August 06, 2007 2:42 PM To: u2-Users Subject: [U2] Credit Card Processing Hi all, Does anyone have any good recommendations for credit card processing companies? Currently our company does not accept credit cards but will be doing so in the near future as we open a new store front. It would be nice to come up with a solution that I could easily interface to our Universe 10.1 business application. Thanks much, Scott Thompson Lead Programmer Southern Wine Spirits of Illinois --- 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] Off topic: PCI Compliance
As Bob noted, the DSS is a global initiative by the major card brands. It is huge, and produces negligible ROI for all your effort, except it protects your brand name, which is no small thing. At least 1/2 of your effort is going to be other than in-house coding. a) Reviewing / Re-writing business processes/procedures in light of the standard. (Which will precipitate other code mods, not directly involved in your PCI implementation) b) Network scanning - initially and at regular intervals. c) Attack simulation - test your defenses. d) Response planning - in the event of successful penetration And if you are a service provider, the ante is even higher (if you process payment card transactions directly with banks, for others). Although the deadline has passed, there are more non-compliant merchants and suppliers than the PCI Council can bludgeon effectively. That, according to what our compliance officer is reading. However, this default mercy would naturally evaporate the second someone penetrates your data security. (Fine$) As for the encryption piece - it is reportedly easier with UV 10.2 but I still have questions about key management. Maybe someone who is on 10.2 or the UniData version that has 'Data-at-Rest' encryption at the database level, can respond and explain how it works, and fulfills the PCI DSS requirements. GPG provides the DES3 minimum requirement, and coming/expected AES requirement. The UniVerse ENCRYPT and ENCODE functions (10.0 or higher) are pretty good. Encrypt will do DES3 but won't handle key certificates. I have a simple workaround for outstanding IBM issue 8088. But these were only designed for 'Data-in-motion', not at rest. HTH, -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Thursday, April 26, 2007 9:56 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Off topic: PCI Compliance No we are looking at PCI DSS too The Issuers are trying to get it in globally I have a full spec if you would like it Main problem we can see is the encryption, rest of it is pretty straightforward -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brenda Price Sent: 26 April 2007 15:32 To: u2-users@listserver.u2ug.org Subject: [U2] Off topic: PCI Compliance Just wondering with any other companies are trying to deal with PCI compliance and if this is only limited to the US. Brenda --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list 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] Skype - how safe is it ?
Recent projects have led me do more reading in the realm of data security. I was actually reading the PCI article in this magazine and they did a piece on Skype. The writer raises some valid concerns. -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Skype - how safe is it ?
the link http://www.insecuremagazine.com/INSECURE-Mag-8.pdf Recent projects have led me do more reading in the realm of data security. I was actually reading the PCI article in this magazine and they did a piece on Skype. The writer raises some valid concerns. -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Single Signon for U2 - Identity Management ?
You know how when you go to bed sometimes and your brain keeps thinking about some problem... I've been thinking this isn't possible in U2 environment, but sometime during the night I resolved to ask the question. Does anyone know of an Identity Management Suite that is U2 aware? This data security issue represents the next frontier for programmers, for solution providers, for network analysts. Who is the frontiersman in the U2/MV space? What we need - single signon and immediate access to those systems, servers, storage that your identity allows. Whatever you don't have rights to, you can't see (an old Novell concept that Microslop still doesn't get). Does anyone know about an IDM solution that interoperates with the major *nix OS's that U2 is ported to? Thanks for any guidance. -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Single Signon for U2 - Identity Management ?
Les, It's been a *few* years since I focused more on network and desktop support, but aren't you talking more about desktop delivery with the Citrix application server? Whereas, I'm looking for an IDM solution to authenticate a User and give them access to the Enterprise assets they have permissions to. These are related, but different. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Les Hewkin Sent: Thursday, April 19, 2007 10:18 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Single Signon for U2 - Identity Management ? Hi, Are you looking for something like a CITRIX server? With CITRIX you publish to users the applications they are allowed to have. We run Wintegrate, word ... Etc as well as our VB apps from just one place. Les Sherlock Hewkin Project Manager - Financial Systems 01604 592289 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: 19 April 2007 14:49 To: u2-users@listserver.u2ug.org Subject: [U2] Single Signon for U2 - Identity Management ? You know how when you go to bed sometimes and your brain keeps thinking about some problem... I've been thinking this isn't possible in U2 environment, but sometime during the night I resolved to ask the question. Does anyone know of an Identity Management Suite that is U2 aware? This data security issue represents the next frontier for programmers, for solution providers, for network analysts. Who is the frontiersman in the U2/MV space? What we need - single signon and immediate access to those systems, servers, storage that your identity allows. Whatever you don't have rights to, you can't see (an old Novell concept that Microslop still doesn't get). Does anyone know about an IDM solution that interoperates with the major *nix OS's that U2 is ported to? Thanks for any guidance. -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML --- 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] Single Signon for U2 - Identity Management ?
Thanks Bjorn, Do you have any experience with this, with a MV DB server? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, April 19, 2007 10:02 AM To: u2-users@listserver.u2ug.org Subject: SV: [U2] Single Signon for U2 - Identity Management ? Sun has the Sun java System Identity Manager. http://catalog.sun.com/productinfo.xml?site=SE_SWEcatalogue=FCsegment= FC_Ritem=FC_SC_CATgroup=2014fid=5136id=13394 -Ursprungligt meddelande- Fren: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Baker Hughes Skickat: den 19 april 2007 15:49 Till: u2-users@listserver.u2ug.org Dmne: [U2] Single Signon for U2 - Identity Management ? You know how when you go to bed sometimes and your brain keeps thinking about some problem... I've been thinking this isn't possible in U2 environment, but sometime during the night I resolved to ask the question. Does anyone know of an Identity Management Suite that is U2 aware? This data security issue represents the next frontier for programmers, for solution providers, for network analysts. Who is the frontiersman in the U2/MV space? What we need - single signon and immediate access to those systems, servers, storage that your identity allows. Whatever you don't have rights to, you can't see (an old Novell concept that Microslop still doesn't get). Does anyone know about an IDM solution that interoperates with the major *nix OS's that U2 is ported to? Thanks for any guidance. -Baker --- 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] RE: [U2C] U2 / Cache
Thanks, Dawn, for that thorough response. You mention the helpdesk project at IBM. Susie S. told the Spectrum gathering at Long Beach that the embedded db is UniVerse. Perhaps we're not speaking of the same project. I was also told by others this is the coming app to manage all software and hardware calls for IBM, worldwide. Kind of you to share your investigation with the group. This give us lots to think about, when the time comes. All the best for your new venture. -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: [U2C] U2 / Cache
If you don't want to use their own 'Zen' object stuff, can you use whatever you want? C#, VB, Java ? How does it like ODBC, ADO or other methods of getting to the Cache data? We've all had our days hemmed into a proprietary environment. I hope I'm wrong for the sake of my comrades like Dawn, but I haven't heard anything to make me think otherwise, but that your development efforts will be dependent on that 1 company, and tied to their survival. Just some questions: If it's so good then what vertical apps are porting to it? (from MV or RDMS spaces) Why are they going after the MV market so strongly ? After you've written your killer app, and the buyer wants a different db, what are your options? (can you do a [somewhat] simple data/dict conversion and take it to some *other* MV database? Have you seen any dollar figures on their RD investment, compared to other 2NF db providers? -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn Wolthuis Sent: Monday, April 16, 2007 2:36 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 / Cache I should perhaps put this on the U2C list, but I'll second some of Tony's impressions of Cache'. I am starting a new venture (adventure) and have selected Cache', using their MV tools as well as their AJAX tools, for the platform. In my case, I have done a few talks here and there in the past couple of years, with my primary focus in two areas: MV and AJAX. It was shocking and delightful to see that there was a company spending a large amount of its RD dollars on two primary projects during this time: MultiValue implementation and AJAX integration. So, I had to take a look. Their MUMPS technology (with objects added, just as they added object features to MultiValue BASIC) is renamed Cache' Object Script. It is at least as unimpressive at first glance to a non-MUMPS developer as Pick might be to a non-Pick developer. But they set up the MV implementation so that, in theory (I'm guessing there are exceptions), anywhere that you can write MUMPS code, you can now write DataBASIC (Cache' MultiValue BASIC). Very cool. Cache' classes can be developed, looking similar to Java and other object languages, that generate MultiValue dictionaries. These classes then work with the rest of their AJAX implementation (named Zen). Any Cache' class with methods in it can have those methods written in MultiValue BASIC. As a sometimes Java developer, it is pretty interesting to see this blend of OOP and MV. Feel free to ask me any questions about the product or my decision on this, if desired, especially as we get into more hands-on with the product this summer (the devil is in the details and all). Of course, there will always be a place in my heart for U2, but I had to make the best decision for the new software we will be building and InterSystems with their Cache' offering that now includes MultiValue just feels more like the future, with their 24-7 approach, scalability etc. There was really good energy at the conference and in discussions with key Intersystems folks. I like the U2 group too, but they do not have the same level of corporate-wide backing for their MV product that Cache' has, so the innovations are not in the same place either. Cheers! --dawn -- Dawn M. Wolthuis Tincat Group, Inc. tincat-group.com Take and give some delight today --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: Spam:[U2] Texas U2 Members listening?
Jerry, There used to be the St Louis user group, but I don't think it was extant when I arrived there in '95. We are calling this Texas Area MV User Group (TXAMUG, for now anyway) to leave the door open for anyone in states nearby who want to join with us. You are right about Texas being a bit large (you can drive from Dallas to Sioux Falls, SD faster than driving from El Paso to Texarkana). However, most of the towns we think we will be drawing members from are 3 to 5 hours from DFW. If we move our meetings to something slightly S. of Dallas/Fort Worth then the circle is even tighter. It may be a bit of driving for some, but we find folks in Texas are used to some driving. I think the most important factor will be to offer something in our meetings that makes the required effort a good bargain. One such discussion is blending MV with newer technologies - if we pick topics and spawn discussions along this line we are offering an intimate experience/personal development/business development that touches our daily tasks, and affects our future mutual survival. FWIW. BTW - Sunset Beach, Mo is not too far from DFW, given today's speed limit thru Oklahoma. 8-) -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Sent: Wednesday, March 28, 2007 2:07 PM To: u2-users@listserver.u2ug.org Subject: Re: Spam:[U2] Texas U2 Members listening? I wonder if we have anything like this in the Missouri or the central states area. With a state the size of Texas you will probably have one heck of a job with people making a commitment having people from Houston to Amarillo, Texarkana to El Paso. A meeting would probably mean a plane ride and an overnight stay. How you going to do it. - Original Message - From: Baker Hughes [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, March 27, 2007 1:46 PM Subject: Spam:[U2] Texas U2 Members listening? At the recent International Spectrum MV conference in Long Beach a new Texas Area Multi-value User Group was launched. If you are located in or around Texas we invite you to join by going to the yahoo group: http://tech.groups.yahoo.com/group/texas_mug/ If you want to email me off-list I will send you a pre-approved invitation link. This is a private group, only members can post to it, view archives, etc. I would ask, therefore, that you give a few sentences or syllables about yourself [your involvement in U2 or MV] so we can validate all our members. This is for the security of our membership. Our first TXAMUG meeting is scheduled for June 28th, which will commence quarterly meetings thereafter. Our aims for TXAMUG: -- Get face time with others who are using the MV database model to share knowledge and experiences. -- Provide a technical and advisory resource to 'mutually aid' one another in our respective daily tasks. -- Develop regional venues to disseminate knowledge and products for the MV database. -- Personally advance in our MV expertise through educational presentations by TXAMUG Group members and other training providers. -- Spread the news that the MV database model is not just surviving but evolving into more interoperability and robustness, while retaining it's 'business-intuitive' structure. Just for clarification, TXAMUG is intended to complement the role of the U2 and CDP groups in the MV community, by providing periodic physical meetings with some of the same friends you interact with on these worthy technical forums. Cordial Welcome, -Baker Hughes, Moderator, texas_mug http://tech.groups.yahoo.com/group/texas_mug/ --- 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] Texas U2 Members listening?
At the recent International Spectrum MV conference in Long Beach a new Texas Area Multi-value User Group was launched. If you are located in or around Texas we invite you to join by going to the yahoo group: http://tech.groups.yahoo.com/group/texas_mug/ If you want to email me off-list I will send you a pre-approved invitation link. This is a private group, only members can post to it, view archives, etc. I would ask, therefore, that you give a few sentences or syllables about yourself [your involvement in U2 or MV] so we can validate all our members. This is for the security of our membership. Our first TXAMUG meeting is scheduled for June 28th, which will commence quarterly meetings thereafter. Our aims for TXAMUG: -- Get face time with others who are using the MV database model to share knowledge and experiences. -- Provide a technical and advisory resource to 'mutually aid' one another in our respective daily tasks. -- Develop regional venues to disseminate knowledge and products for the MV database. -- Personally advance in our MV expertise through educational presentations by TXAMUG Group members and other training providers. -- Spread the news that the MV database model is not just surviving but evolving into more interoperability and robustness, while retaining it's 'business-intuitive' structure. Just for clarification, TXAMUG is intended to complement the role of the U2 and CDP groups in the MV community, by providing periodic physical meetings with some of the same friends you interact with on these worthy technical forums. Cordial Welcome, -Baker Hughes, Moderator, texas_mug http://tech.groups.yahoo.com/group/texas_mug/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Texas U2 Members listening?
Thank you Brian. Your sentiments are warmly received, and strengthening. Thanks also to Chuck 'danced across the trade floor to get us vendor backing' Barouch, Charles Stevenson for encouraging counsel, the folks at IBM who let us commandeer their booth to hash it out, Nathan Rector who is getting behind this in tangible ways, and Dick Thiot who is doing the 'Executive Level' legwork to get the word out. We're still pecking our way out of the shell but we thank you all for the help thus far. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Tuesday, March 27, 2007 1:58 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Texas U2 Members listening? Baker May we wish you and your new group every success. The more of us shouting that message, the more people will hear us. Keep flying the MV flag! Brian Leach --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Passing of Bruce Nichol - Talon Computer Services
This is sad to hear. When his obit appears in the paper, perhaps Ross or one of our friends down under will send us the link? peace on his family and friends, -Baker -Original Message- From: Ross Ferris I have just learned that Bruce Nichol of Talon Computer Services (Albury/NSW/Australia), a frequent contributor to this forum long time pick advocate, has passed away. He will be sorely missed --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Calling all Texas U2'ers
Is there any interest among U2 or Multi-value people in Texas or neighboring states to start a Texas Multi-value user group? I haven't heard anything from the Metro Area DataBase User's Group (MADBUG) in Dallas since 1995, so I'm assuming it is not extant. The MV market has gone through quite a bit of stabilizing and perhaps some growth since that time. I believe there are enough subjects of common interest to a broad audience that we could have some profitable (useful) discussions. My place of business is just south of DFW metro area, which could be easy for folks in Houston to get to, without having to traverse DFW area. I could probably obtain meeting space for at least some exploratory meetings; we could set future direction from there. If there are others from this area going to the International Spectrum conference next week in Long Beach, I would like to meet with you there to discuss this. Other list readers - if you have any counsel for us in this enterprise, say on. Respond off list, or on list with the moderators blessing. Also posting to cdp. -Baker Hughes bakerdothughesat mouserdotcom --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Email Archive Search
I had the same issue when I attempted to show some colleagues the U2UG site the other day. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vance E Alspach (JL - SFD) Sent: Friday, January 19, 2007 10:11 AM To: u2-users-help (u2-users@listserver.u2ug.org) Subject: [U2] Email Archive Search Is anybody else having problems searching the email archive? I keep getting 'The webpage cannot be found' Vance This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any copies of it. Thank you. --- 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] Straw Poll - what GUI do you/would you use?
Perhaps this question should've gone to the community list but I didn't want to miss the technical readers, nor their technical input. I'm conducting a straw poll about the 'preferred' graphical user interface. Please, no vendors or software providers. [We like you, we just want to hear from those who actually are in the trenches with your tools. Thanks. ;-) ] Would you mind responding to any of the following 3 questions: 1) In a perfect world, assuming UniVerse or UniData has the requisite hooks/services, what development environment would you use to put a graphical user interface on a character based application? Be concise if responding on-list. Rants are welcome to my direct email. 2) What was your *best* experience GUI-izing a character application? What language/tool? How long did it take? Was business logic already separated from presentation layer? 3) What was your *nightmare* experience GUI-izing a character application? What language/tool? How long did it take? Was project abandoned/completed? Was business logic already separated from presentation layer? Please forgive any repetition with previous threads, some of which I've read. Thanks exceedingly for any response. If you don't 'name names' this will be of no use, yet we are hoping this will not degrade into a trashing spree. We are grateful to all those providers/vendors who are contributing to the synergy of our market, wherever their toolset is along the continuum of perfection. There are likely factors, beyond the toolset itself, that contributed to the *nightmares* - please give credit where due. R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] System() Trace equivalent
Bill, Thanks for sharing the code. The answer was in there - SYSTEM(9001) for UV, which gives me this - from which I can find what I need: 001: 5 LOCAL.SUBROUTINES.O/DATA.SECURITY.BSUB 0x7be 002: 4 LOCAL.SUBROUTINES.O/DOE.HEADER.SUB 0x3282 003: 3 /system1/dev/DEVPROG/SUBROUTINES.O/DOE.USER.SUB 0x100e 004: 2 /system1/dev.programs/BHB.O/DOE.USER 0x1c2 005: 1 /system1/dev/DEVPROG/BP.O/MOUSER.MENU 0xd6a Thanks so much. -Baker /snip * ProgramStack = SYSTEM(9001) ; ** UV version * ProgramStack = SYSTEM(33) ; ** D3 version --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Why does the IF statement think these values are different?
Steve, a couple suggestions: a) It shouldn't make a lick of difference, but enclose the math in parans, just to insure the precedence you desire in the operation.. IF (INTREC+PRNREC) # (INTPAY+PRNPAY) THEN b) if that doesn't change things, try something like: WHATSUP = ABS((INTREC+PRNREC) - (INTPAY+PRNPAY)) IF WHATSUP 0 THEN ERRMSG='ACCT/CALCULATOR MISMATCH' HTH, -Baker HI All, I don't understand why the IF statement THEN clause is executed in the following code: CUSTOMCALC: 447: IF INTREC+PRNREC#INTPAY+PRNPAY THEN :: S CUSTOMCALC: 448: ERRMSG='ACCT/CALCULATOR MISMATCH: ':(INTREC+PRNREC)'R2':'/':(INTPAY+PRNPAY)'R2' :: INTREC/ NUMBER: 24016.35 :: PRNREC/ NUMBER: 978.56 :: INTPAY/ NUMBER: 24016.35 :: PRNPAY/ NUMBER: 978.56 :: ERRMSG/ STRING: T r L=42 `ACCT/CALCULATOR MISMATCH: 24994.91/24994.91' --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2][UV] System() Trace equivalent
Does anyone know I want to report in a logging process the originating calling program - this would be the lowest level, or root level of the 'T'race command in RAID debugger. Normally, it's enough to report the calling subroutine, but in this case I need either the root program in the stack, or the whole Trace stack so I can parse it out of there. If this System() function exists, it will be undocumented. If you know of another way to arrive at this (without adding a COMMON or Call parameter) that would be appreciated to. Thanks for any thoughts. -Baker [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Why does the IF statement think these values are different?
I'm reaching back to my Reality days... would there be any value of a PRECISION statement in that particular subroutine? I don't know the default precision for your implementation but if you forced it to something higher before your compare, maybe it would work, as written. HTH. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Ferries Sent: Monday, November 06, 2006 1:22 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2][UV] Why does the IF statement think these values are different? HI All, First, thank you for your responses. Here is an update: It is UniVerse. I removed the 'R2' format but the values come out the same: CUSTOMCALC: 451: ERRMSG='ACCT/CALCULATOR MISMATCH: ':(INTREC+PRNREC):'/':(INTPAY+PRNPAY) :: INTREC/ NUMBER: 24016.35 :: PRNREC/ NUMBER: 978.56 :: INTPAY/ NUMBER: 24016.35 :: PRNPAY/ NUMBER: 978.56 :: ERRMSG/ STRING: T r L=42 `ACCT/CALCULATOR MISMATCH: 24994.91/24994.91' I then proceed with the suggestions that there are unseen decimals and changed the values via the debugger, and the THEN clause is skipped: CUSTOMCALC: 449: IF INTREC+PRNREC#INTPAY+PRNPAY THEN :: INTREC/ NUMBER: 24016.35 :: INTREC!24016.35 INTREC was NUMBER: 24016.35 . Now is STRING: T r L=8 `24016.35' :: PRNREC/ NUMBER: 978.56 :: PRNREC!978.56 PRNREC was NUMBER: 978.56 . Now is STRING: T r L=6 `978.56' :: INTPAY/ NUMBER: 24016.35 :: INTPAY!24016.35 INTPAY was NUMBER: 24016.35 . Now is STRING: T r L=8 `24016.35' :: PRNPAY/ NUMBER: 978.56 :: PRNPAY!978.56 PRNPAY was NUMBER: 978.56 . Now is STRING: T r L=6 `978.56' :: S CUSTOMCALC: 455: IF PFLAG THEN So, how does one display the floating point values that are stored but unseen? Thanks, Steve --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Weird Logging Issue
I've seen similar erratic behavior when a phantom process set locks for a possible update, but then didn't clear the lock when no update occurred. I'm suggesting you have a locking issue but the out of memory behavior is identical - it waits for available memory before it can perform the next read. In our case the lock table was consuming the memory - with yours something else is consuming and not releasing the memory. HTH -Baker quote who=Kevin King I am supporting a phantom program that uses PRINTs to output information to _PH_ for a log. When this log starts getting near 3MB, the phantom begins performing very strange. For example, sometimes a READ in the phantom will be successful, but the variable that was read is null (even though the record itself is intact). It seems like a memory issue as restarting the phantom (and getting a new log) seems to clear everything up. Does anyone have any experience to support or discredit this theory? -Kevin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Weird Logging Issue
Corrected posting - sorry... I've seen similar erratic behavior when a phantom process set locks for a possible update, but then didn't clear the lock when no update occurred. I am NOT suggesting you have a locking issue but the out of memory behavior is identical - it waits for available memory before it can perform the next read. In our case the lock table was consuming the memory - with yours something else is consuming and not releasing the memory. HTH -Baker quote who=Kevin King I am supporting a phantom program that uses PRINTs to output information to _PH_ for a log. When this log starts getting near 3MB, the phantom begins performing very strange. For example, sometimes a READ in the phantom will be successful, but the variable that was read is null (even though the record itself is intact). It seems like a memory issue as restarting the phantom (and getting a new log) seems to clear everything up. Does anyone have any experience to support or discredit this theory? -Kevin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] IBM Conference travel tips
snip Is there nothing that man doesn't know??? /snip There are but he's ignorant of them. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] NLS - localization Accuterm
Hi all, Has anyone done a globalization/localization project, using U2 NLS, with Accuterm as your client? Accuterm has some nifty subroutine calls to present a listbox or msgbox to the user. We'd like to use these but wonder what will happen if we pass it arguments that contain other languages. We're wading into a localization project and had some thoughts about using the listbox to have User select the applicable ISO currency code and country code. The Accuterm client actually creates the vb box whenever it detects certain escape sequences. I'm just wondering how it behaves with Chinese characters, or other languages? Anything you can share would be helpful. TIA -Baker R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. [EMAIL PROTECTED] * --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Position available - Texas, USA
Contract or perm, no telecommute. We have need of another programmer, or/also an experienced DBA, maybe more. Some big projects in the mill. Fast growing electronic components distributor. Email me off list and I'll direct you to the contact person. UniVerse 10.0 on AIX 5.1 Homegrown distribution system. Thanks, R. Baker Hughes Mouser Electronics, Inc. [EMAIL PROTECTED] * --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] George wants opinions about UD on Solaris
Hey, George S. asked for input about how good a development platform UD on a Sun Sparc is. I like that platform myself. I would think its a little better, economically, than say an RS6000 these days, but I haven't compared of late. I would for sure take UniData or UniVerse on Solaris before I deployed on wIndoze, much more stable (is it NOT(PC) to say this?)[...sorry for the dbl pun.] Perhaps, if a windoze shop is more familiar with NT style admin and printing and not wanting to learn *nix tools for this, UV on Win is a good fit, if it will make them consider an MV db. What does anyone else have to say? I know Pick Professionals in St Louis use the Solaris platform quite a bit, although now also a certified MS shop. They might be contacted www.pickpro.com for their take on the question (no royalties rec'd for plug.) -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Thursday, September 14, 2006 10:39 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Debugging a program using distributed files causes core dump How about a bad data record? If I was the one running this, I'd be putting in a number of DISPLAY statements at key points, like a before and after message on statements like WRITEs or CALLs. Probably on READs, too, ensuring you show the record key in the before message. Then let it rip! If you put the displays in correctly, you should be able to pin down where in your program you're hitting your bump in the road. I use things like POINT 1, KEY=xxx and POINT 1, EXIT You just increment the 1 for each pair. Be sure to keep in mind when you complete a loop that you may not get to your EXIT message. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: Thursday, September 14, 2006 7:13 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Debugging a program using distributed files causes core dump This happens in 2 different programs. Straight compile and local catalog, no options with DEBUG statements embedded in the code. Then the program is executed, processing stops when it hits the debug, I step through the program until I get to where I want to it continue and hit C to continue. Sometimes it is am immediate dump, sometimes a few seconds later. If I am only working with a small list of items, then it does not happen. If I have selected the whole file it does. I do not use RAID to run the program. In one program the indices are turned off when I am debugging it. The other program just reads the records in the file and does calculations on the data as it is verifying the conversion data. The first program builds the data in the DF files, reads and writes. The second does a sort select of one of the files, then readnext loops. Brenda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, September 13, 2006 8:18 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Debugging a program using distributed files causes core dump Does the process continue through a program where the source file is pointing to the object file ... like the DF algorithm ... the debugger could maybe be trying to display or traverse binary where it expects source? Or through a program compiled with source symbols suppressed or raid suppression on or source code removed?? Just some random thoughts. Stuart Boydell --- 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] Debugging a program using distributed files causes core dump
I trust some mates more familiar with distributed files will also respond... but you might try this just to get you going: UniVerse handles things differently if you do OPEN '','CUST' TO FILENAME ELSE GOSUB DEALWITHIT SELECT FILENAME LOOP WHILE READNEXT more.stuff REPEAT or EXECUTE 'SSELECT CUST BY FIELD29 BY WHATEVER' CAPTURING SCREEN.IO CRT @SELECTED: Custs to Service LOOP I won't attempt to answer the internals of how these are handled by the kernal but the latter example lends itself more to debugging activity. In the first example you don't always have the entire selection 'at the ready', even in a non-distributed file system. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: Wednesday, September 13, 2006 10:17 AM To: u2-users@listserver.u2ug.org Subject: [U2] Debugging a program using distributed files causes core dump This is our first experience with distributed files. While debugging programs that have selected the whole file I get core dumps sometimes when I tell it to continue. As long as I am stepping through the program I am ok, as soon as I hit continue it blows up. I can take the debug statement out and run the programs without them blowing up. I've tracked back and found it is never on the same record when it blows. These files do have indices on them. We are stumped as to what is causing this behavior. This is not a critical error at this time because this is a conversion project. However, if this behavior continues after we are converted to this new method of business, it will be a big a problem the first time we have to get into the debugger to fix something during our critical processing and it blows up. Any idea's? On Universe 10.1.12, Reality flavor, Linux Advanced Server 3. Brenda Price Affiliated Acceptance Corporation --- 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] Convert to date and Time
Krish I found this old post on comp.databases.pick http://groups.google.com/group/comp.databases.pick/browse_thread/thread/ 2808b1db159fc2e6/a5df053ce372b7e5?lnk=gstq=internal+data+excelrnum=1#a 5df053ce372b7e5 Salient excerpt: The base date for Excel for Windows is January 1, 1900 and for Excel on the Mac it is January 1, 1904. (Don't ask me why there is a difference. It's 'cause Bill said so.) So, the conversion factors are 24,837 and 23,375 respectively. So to convert from Excel to Pick internal date you would subtract that factor from the Excel date. To convert from Pick to Excel, simply add the factor to the value in question. R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. (817) 804-3598 * [EMAIL PROTECTED] * -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, August 29, 2006 8:53 AM To: [EMAIL PROTECTED] Subject: [U2] Convert to date and Time I need to convert a Multivalue field to Date and Time format in MS Excel. The Mutivalue filed has the following description and the value next to that. Date_Time_Qty: 14121*31190.858 Any suggestion is appreciated. Thanks. Krish --- 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] Encrypt Algorithms
John, Thanks for your useful insights. From what I read, DES-III was indeed cracked in 1999 by a brute force attack, by a program that generated 199 billion keys per second. http://gilchrist.ca/jeff/distrib-des3.html And as you've noted, Joe Hacker doesn't usually have enough hardware, time, or resources to check over 72,057,594,037,927,936 keys to find yours. For those interested in encrypting some 'data at rest', I learned from Nik @ IBM today that UV 10.2 will have auto encryption. Some on this list have probably already read this from the 10.2 release highlights but this was news to me. In UV 10.2 (not sure the UD version that will have the same) you will simply specify what files or fields you want encrypted when at rest. When you write or read UV will encrypt/decrypt as part of the intrinsic i/o methodology. This is good news - now to weigh the other heart aches that may be involved in an upgrade oh yes ... 10.1 and 10.2 have the AES 256bit cipher. Which is what the US Fed govt has standardized on http://csrc.nist.gov/publications/fips/fips197/fips-197.pdf -Baker I believe DES was cracked in a day using massively parallel computing. I don't know about DES3. We're using the DES3 capability built into UV. I think any encryption is going to be crackable given enough time and money on the part of the cracker. You have to ask yourself how valuable is the data I'm encrypting, and who is it valuable to. If you want to keep your data hidden from the intelligence services of a major government (eg. you work for a DOD sub-contractor), then you've got your work cut out for you. If you want to keep some credit card numbers hidden from Joe Hacker, probably any 128-bit encryption method is enough to send him looking for easier prey. This is all just my opinion of course. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Encrypt issue 8088
RESULT[1] does work the same, at least on UV10.0 - maybe some have concern on cross-platform portability. And Symeon - thanks for your code fragment. That, and a nights rest helped me to get things going. I'll post the encryption code that's now working if anyone is interested. It may be of use to anyone who later faces the same unresolved issue 8088. Many thanks. R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. (817) 804-3598 * [EMAIL PROTECTED] * -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David A. Green Sent: Friday, August 25, 2006 10:07 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Encrypt issue 8088 Why do programmers use result[LEN(result),1]? Doesn't result[1] do the same thing but easier, quicker, and more readable? Thanks, David A. Green DAG Consulting www.dagconsulting.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Friday, August 25, 2006 1:06 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Encrypt issue 8088 Here is my standard crypt sub FUNCTION AD.CRYPT(Word,key,iv) * Function to crypt something i.e. a password * a2c limited, Oct2005 Crypt=Word Err='';result='';resLoc=1;salt='' algorithm=rc2-cbc Err=ENCRYPT(algorithm,2,Word,1,key,1,1,salt,iv,result,resLoc) IF NOT(Err) THEN IF result[LEN(result),1]=CHAR(10) THEN result=result[1,LEN(result)-1] ;* IBM ISSUE 8088 Crypt=result END RETURN Crypt --- 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] Encrypt issue 8088
Symeon, others, I tested every 128+ bit cipher available with Encrypt and here are the results: All the ciphers work with encoding but require the workaround (remove extra LF). None work without encoding - the decrypt side either adds a random character, or craters altogether, and Decrypted string never matches raw string. If anyone wants a copy of my test program 'ENCRYPT.THIS' write me off-line. I also have spreadsheet of the testing results, comparing the accuracy/functionality of the ciphers. Encryption Testing program :ENCRYPT.THIS Choose from one of the available Ciphers 1) rc4 2) des-ede3-cbc 3) des-ede3-cfb 4) des-ede3-ofb 5) rc2-cbc 6) rc2-ecb 7) rc2-cfb 8) rc2-ofb 9) rc5-cbc 10) rc5-cfb 11) rc5-ecb 12) rc5-ofb Enter Cipher choice 1 - 12 :1 Enter Action - 1=Encrypt only, 2=Encrypt Decode :2 Data String :40550111 ___Encrypting___ ___ There was an extra line feed, now removed from result. Encrypted Successfully ! The Encrypt result is fdYWmfhZkszPfLGo+XsPQA== ___Decrypting___ ___ Decrypted Successfully ! Decrypted result is 40550111 Original data and decrypted data match, hooray! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Friday, August 25, 2006 1:06 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Encrypt issue 8088 Here is my standard crypt sub FUNCTION AD.CRYPT(Word,key,iv) * Function to crypt something i.e. a password * a2c limited, Oct2005 Crypt=Word Err='';result='';resLoc=1;salt='' algorithm=rc2-cbc Err=ENCRYPT(algorithm,2,Word,1,key,1,1,salt,iv,result,resLoc) IF NOT(Err) THEN IF result[LEN(result),1]=CHAR(10) THEN result=result[1,LEN(result)-1] ;* IBM ISSUE 8088 Crypt=result END RETURN Crypt --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Encrypt Algorithms
Does anyone have an opinion about which are the best encryption algorithms to use? If you have any technical doc citations this is very useful. Would you NOT use the U2 Encrypt function simply because it doesn't offer the algorithm you need (or one mandated by your client/employer)? Would you NOT use the U2 Encrypt function simply because it doesn't offer 256 or 512 bit encryption? (Only goes to 168.) Do you think a certain algorithm should be AVOIDed because it's been cracked? I've heard des3 has been cracked, but not sure which mode (cbc, cfb, or ofb) was cracked, or whether it matters. The discussion can take in other encryption methods, openssl, gpg, etc. U2 offers rc4, des3, rc2, rc5 - I'm not listing anything 128 bit. TIAA, R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. (817) 804-3598 * [EMAIL PROTECTED] * --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Encrypt issue 8088
Hi, Can anyone share a code fragment for removing the extra Char(10) characters from the Encrypt function. I've studied the IBM articles (2) on U2 Encryption, and read the previous posts on this list. I've tried to remove the extra LF with less than sterling results. I can't find the char(10), whether I do or don't encode. If I add an extra char(10) for Decrypt it overruns the expected length and craters. Before I resort to shelling out to Unix and running Openssl I'd like to exhaust the native U2 Encrypt possibility. We are on UniVerse 10.0 - the articles by Nik Kesic speculate that the Encrypt patch will arrive in 10.2, but I'm not certain when/if we'll load 10.2 anyway. Always enlightening reading this list. I'm thankful for you guys (in the NY sense of the word, inclusive of gals)[Y'all, for other Southerners.] TIA, -Baker R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. (817) 804-3598 * [EMAIL PROTECTED] * --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Encrypt issue 8088
George, Thanks for this help. I'll save this in case we have to resort to a Unix script and run openssl. We are rather strict about not allowing a user logon 'EXECUTE' a Unix shell script with UniVerse. But, if I can't find a solution for the UV native ENCRYPT function [issue 8088] then we may have to write a Unix script that would be called from a subroutine. Thanks for your contribution, and for the -a -A flag point you make. R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. (817) 804-3598 * [EMAIL PROTECTED] * -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of george r smith Sent: Thursday, August 24, 2006 11:22 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Encrypt issue 8088 Baker, I don't know if you are trying to do this via a Unibasic subroutine call or by using EXECUTE. I could not use the Unibasic because the Unidata version was not 7.1 so I used the following. I had a lot of trouble with char(10) also until I found the -a -A flags. This works well on Solaris and Unidata 6.0. I sure you can see the command we are EXECUTING and capturing the result. george CMD = CMD = echo : PKT CMD := |openssl enc -a -A CMD := -iv : IV CMD := -: ALGORITHM CMD := -K : KEY CMD := -out : PATH CMD := /: FILE.NAME CMD = CMD = openssl enc -d -a -A CMD := -iv : IV CMD := -: ALGORITHM CMD := -K : KEY CMD := -in : PATH CMD := /: FILE.NAME -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Thursday, August 24, 2006 9:35 AM To: u2-users@listserver.u2ug.org Subject: [U2] Encrypt issue 8088 Hi, Can anyone share a code fragment for removing the extra Char(10) characters from the Encrypt function. I've studied the IBM articles (2) on U2 Encryption, and read the previous posts on this list. I've tried to remove the extra LF with less than sterling results. I can't find the char(10), whether I do or don't encode. If I add an extra char(10) for Decrypt it overruns the expected length and craters. Before I resort to shelling out to Unix and running Openssl I'd like to exhaust the native U2 Encrypt possibility. We are on UniVerse 10.0 - the articles by Nik Kesic speculate that the Encrypt patch will arrive in 10.2, but I'm not certain when/if we'll load 10.2 anyway. Always enlightening reading this list. I'm thankful for you guys (in the NY sense of the word, inclusive of gals)[Y'all, for other Southerners.] TIA, -Baker R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. (817) 804-3598 * [EMAIL PROTECTED] * --- 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] UV - Globalization studies, relative to U2
Has anyone seen a study, a white paper, or anything which discusses Globalization in the MV arena? We need to provide currency translation in the near future, and eventually content localization. If someone has some links to read, or documents it would give us a leg up. I'm sure some of you have done this. Where did you start? Did you buy a solution, write your own? TIA, Baker Hughes --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Pushing envelope on openSocket
Bob, Thank you for this account of your experience, very helpful. I will share this with our development team. R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Monday, February 20, 2006 2:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Pushing envelope on openSocket Hi I am using sockets to run stored procedures in MS SQL and bring back the results in our telesales area We do literally thousands of interactions a day the loop is protocolLogging(,OFF,10) openSocket(SERVER.IP.ADDRESS,SOCKET.PORT,BLOCKINGMODE,TIMEOUT,SOCKETHAND LE1) writeSocket(SOCKETHANDLE1,SRDATA,TIMEOUT,BLOCKINGMODE, readSocket(SOCKETHANDLE1,CLDATA,CDATLEN,TIMEOUT,BLOCKINGMODE,ACTSIZ) RcloseSocket(SOCKETHANDLE1) We have absolutley no problems At the same time we are clearing credir cards thru our bank systems These interactions are longer but again we do hundreds a day with no problems at all Bob - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Pushing envelope on openSocket
Thanks Lembit. This is very helpful, and gives us greater confidence in our strategy. R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lembit Pirn Sent: Friday, February 17, 2006 12:19 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Pushing envelope on openSocket We are running UDT (6.x) on Solaris RH and normally we have around 200 k open/close sockets a day without any issues. And we started to use sockets already since 2003 (don't remember even ;-) ) with version udt 5.x. It may be different of course for UV. Good luck ! Baker Hughes wrote: Hey friends, Is it true that you can only do 6k to 10k openSocket's (non-persistent) before having to reboot? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Pushing envelope on openSocket
Thanks, Glen. This provides some useful things to consider if we encounter this supposed 'ceiling' on sockets. I can see where the SO_REUSEADDR could cause problems if you have a multi-threaded app placing concurrent calls. We're going to write a little benchmark code and try to hammer the host with a kazaillion sockets and see who yells 'uncle'. R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glen Batchelor Sent: Thursday, February 16, 2006 5:01 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Pushing envelope on openSocket I can't speak from a U2 stand point, regarding limits on socket handles. I just don't have the experience. Thus my off the wall note. The O/S is typically responsible for cleaning up client and server sockets. If U2 is performing O/S level socket functions, then the O/S will be the deciding factor in a lot of it. Many of the MV flavors I've studied or used have wrapped the socket functions, to allow for cross-OS coding. Socket functions on Win32 are not the same as Unix. That, by itself, can cause problems if the wrapped code is performing blind operations from BASIC code calls. I have never heard of O/S level client sockets being problematic after X cycles. That's not the same as listening sockets, though. The SO_REUSEADDR flag, which is available on most platforms, tells the socket subsystem to reuse the same memory address for all incoming connections for a specific port. An example bad situation would be, listen()-accept()-I/O Error-crash-start-listen(). That kind of issue is known to cause Error-crash-start-address stacking on Windows. When a listening server crashes upstream and doesn't release the socket handle properly, the addresses that are in-use will stack up until no more addresses are available. That's why a Windows reboot is required every so often, when the startup of listening sockets begin to return in-use errors. I've also read about shutdown() and close() being misused interchangeably. Close() releases the file handle, but the socket address may or may not be released in the network subsystem. That can also lead to a pile-up of allocated, but unused socket addresses. The only fix there is a system reboot, or to wait it out until the O/S forces all unused, inactive, sockets to be cleaned up. That can take an hour or 3 days, depending on the O/S and how it manages the network. --- Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 e-mail: [EMAIL PROTECTED] --- www.allspec.com --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Newbies need love too
Well said Nick. And Marcie is a master at customizing a course to fit your in-house skill set and expertise. She excels at relating the material to the paradigm your people already have, given their IS background. We had her out more than once, years ago [I won't say how many ;-P ] and we were never disappointed. I was with a public safety agency then, and if she can teach cops and fire fighters computer stuff, hey, you know she's good ;-). R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. Check out http://www.discoverycomputersystems.com/ I got my Universe training at Marcie's school. She now only does onsite training, but she is definitely one of the best instructors I have ever had. She has a lot of experience, and was one of the trainers at PICK. Thanks, Nick Cipollina What about the newbies? Don't we get any love? I have went through every google term I could think of to come up with a simple This is how you get started with a UniVerse. Walter Vaughan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Newbies need love too
Walter Team, I'm sure you're going to get flooded with posts now, because there is quite a lot of passion about the Multi-value database model, and you'll find this community extremely helpful. I am so glad y'all are considering an MV based app. Installing PE UV was an excellent start. For your staff to look around and start creating some files [read Tables] you ought to buy a copy of How To Access, by Harvey Rodstein. Talk to Monica at International Spectrum and she will send you the electronic version, just released. http://www.intl-spectrum.com Here is a link to some on-line publications: http://www.jes.com/olbooks.html Especially helpful to your programmers would be Jonathan Sisk's Programmer's Guide. This would be your starting point to understand the UV-Basic language, and how to play with multi-values (nested tables in Oracle [8 or later] lingo). If you want to see a pretty exhaustive list of all books ever written on the subject, go to: http://www.jes.com/picklist.html This list has not been updated in recent years, I don't think, so there may be additions. The best news about your initial steps, is that whatever you learn from Harv's book, or commands you pick up by even gleaning non-UniVerse publications - will work on UV. There are many nuances of the various 'flavors' of the MV db model, but only worry about that when you get alot deeper. Only when your programmers get seasoned and begin to leverage the UV nuances do you need to worry with that. If you can navigate one MV database, you can navigate them all. If you want to see something about the [sometimes spicey] history of the MV model, go to: http://www.tincat-group.com/mv/familytree.html BTW - [in somewhat hushed tone] this all started as something called Pick but everyone around here prefers to speak of either Multi-value industry or the U2 (standing for UniData and UniVerse, both now owned by IBM but have divergent genealogy). Pick is now D3 and well let some other folks check in now. Hope you have fun. MV is a blast. R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. I have 23 and 28 year old programers that will have to live with this solution for the next 20 years. They're bright, but in order to get them excited about this platform I need to let them experiment. Any website pointers will be appreciated. Walter Vaughan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PROC question
Bob, This is from memory, so I trust someone will affirm/correct my prognosis, but isn't the PIB (primary input buffer) cleared when you execute the program. So when you return, A (or answer, A1 assumed) is now null? -Baker My problem is when I come back from one of the PROGxx.PROC's, I'm not getting the menu choice value back to execute the G 10 command. Instead it displays the error message at the bottom. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Log Process ID for Phantom in UV 10
I seem to recall in UD a SYSTEM(nn) function that holds the Unix PID. I can't find the UV equivalent. It doesn't show in the docs to have one. When a phantom is spawned I want that phantom to write it's PID to a control item, along with start time, and later, the end time. Thanks Y'all. R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Log Process ID for Phantom in UV 10
Poifect. Thanks James. R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. There is a GCI call, getpid(), that you can use to get your process id. DECLARE GCI getpid CRT getpid() END James --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Log Process ID for Phantom in UV 10
Thanks Tim. That's a 2nd witness ... confirms our plan. R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. In UniData it's @USERNO. In UniVerse you have to use a GCI call. Try the following: DECLARE GCI getpid pid = getpid() Tim Snyder --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] System Migration issues
Could you T-Load them to a virtual tape file (.vtf) and then ftp that to wherever you want? R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. I am migrating an old AIX server running U2 to RH Linux. Because of the server's limitations, I need to transfer files between the two devices via FTP and then converting the files for Linux use. After doing so, my distributed files are getting corrupted. It looks like the IBM provided fixtool utility repairs the files, but it's taking way too long for my larger distributed files. Making a HUGE assumption that it's the file transfer responsible for the file corruption, is there a preferred method for copying data files? Steve --- 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] UniVerse call to Java class
Thanks to Wendy, JayJay, and Kevin who responded to my previous posts about Java. Your replies, and the docs, all indicate that the U2 Java API only accommodates calls TO UV or UD databases, or Basic subroutines. From the code examples (found, thanks Wendy), and docs, it appears there is no UV call to a Java class, from within a Basic subroutine. In this credit card project, the UV host is actually the client, calling a Java API which communicates with a Linux host running Live Processor software (by Retail Decisions). The LP server then passes the Auth request or settlement to the actual credit card processor across a frame. We can run the Java client (a testing shell script) from the Unix command line and test the connection and run Test scenarios. That all works. What I need help on is some elegant way to make the client call from UV Basic, hopefully passing/receiving some arguments/parameters. The client is multi-threaded so the connection is persistent for the life of each call, returning a Transaction ID and various response codes (decline/approval why, etc.). Thanks for taking the time. I'm thankful for this community. TIA. R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse call to Java class
On 1/11/06, Wendy wrote: I may have edited it out, but one question I had was, what kind of volume are we talking about here? Five transactions an hour? A minute? A second? More? 300 authorizations an hour, max; 2 thousand a day, max. This is growing steadily though. You do *not* want to do the equivalent of: PCPERFORM java com.exampleMyClass param1 param2 either directly, or indirectly by calling a script that does the same thing. It's going to create a JVM (Java Virtual Machine) every time. That won't scale at all. That's wild, a separate JVM for each thread? I thought it was been slow to load but... So, I just kicked off a runLPClientTest.sh and set the thread count to 18. Then from another session I did 'ps -eaf | grep java' Only 1 process was spawned. Doesn't this mean just 1 jvm? I'm finding it hard to believe that a Java API is the only way to talk to the LiveProcessor software _and_ that all you can do with the Java API is make a call to process a single transaction. But assuming that's all true, I'd approach this one of two ways: They have a C API as well. Do you think that would be faster/thinner? I see now, UV is much more prepared to do a C call, than a Java call. In-house talent pool was leaning us toward the Java API. I'd still lean towards a sockets-based solution. UV would use CallHTTP to talk to an instance of Jetty or Tomcat running a little Servlet that picks up HTTP request parameters, makes the call to the LP server, gets that response, and then sends a response back to UV. We are doing something like this now to perform an extended search on a webservice for parts lookup, but it seems rather slow. Maybe it's just the 492kz+ parts it's searching through. I don't like this as much: Have UV write a record to a table with the transaction information. From Java, with UOJ, constantly read records from that table, process the transactions, and write back to it. Make sure you lock the records properly. This would be a single threaded solution? (1 phantom or cron to control) and require polling? (which means the next batch can't start until the last one ends) The reason I thought we should make 1 auth = 1 call is to immediately service each Auth request, as soon as CSR hits Rtn key to File order (or whatever trigger we invent in order taking process, though CSR will not be waiting, necessarily, for response. We close the sale whether/not Auth has been received, leave it to Credit to mop up later). I don't see why you can't talk directly to the LiveProcessor software with CallHTTP or a plain Socket, though. Their Java client has to be connecting somehow... The Java client is connecting with TCP to the LP software. Thanks for help, it's keeping the cranial juices flowing. -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Java CallableStatement help
Happy new projects in the New Year (may we each have all we can handle, and may they all pay). I'm still trying to wrap my mind around the UniVerse implementation of Java. I need to trigger a call, from UV, to a Java API, sending Credit Card data to our processor. From what I can read, the CallableStatement in UV looks like what I need. Does anyone have any fragment or code example of this, or other call to a Java interface? BTW, if you see any extra rainclouds, send them to Texas. Thanks, R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. [EMAIL PROTECTED] * --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Java CallableStatement help
Wendy wrote: IBM provides an implementation of the JDBC specification, (a JDBC driver,) as well as a proprietary Java API known as UniObjects for Java. Yes, I was reading the docs on it, but no code samples there, so things still a bit fuzzy. If you mean the the JDBC CallableStatement, you would use that to talk to UV from Java. Oh. From the docs, it sounded to me like that was the call from UniBasic to Java. Thanks for the paradigm correction. It sounds like you want to use UniBasic to call a Java program. Is that correct? Yes. What does the call to the credit card processor's Java API look like? Depending on how you interact with their API, there are lots of ways to do this. And if you name the processor or the API you're using, quite possibly someone here has already done it. I'm trying to call the Live Processor (from Retail Decisions) Java API. LPTransaction() has these methods: clear() Clears/Resets all the properties in this transaction. getField(java.lang.String keyword) Retrieves the value of the specified property identified by keyword. process(LPClient client) Sends the request to LiveProcessor server for processing and gets the response. setField(java.lang.String keyword, java.lang.String value) Assigns the specified value to the property identified by keyword. Methods inherited from class java.lang.Object equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait Thanks Wendy, and all. - Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] JDBC from UV 10 on AIX - ease of setup?
Forgive if I'm asking something that may be extracted from past posts - a project was just switched from an ftp batch file process to writing a Java client. I'm trying to get up to speed in the shortest possible time. We have to write an interface to Live Processor credit card processing software, which has a Java API. The LP server then passes the transactions to Payment-Tech across a frame relay. Can anyone give me some guidance about the setup issues required to use the jDBC driver in UV? What are the pitfalls to avoid? Any licensing issues? What must be loaded on the AIX server to make this happen? Any other questions I should ask but haven't learned enough to know the right questions? BakerremoveHughes MouserCom --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] records with unprintable characters
Carl, We faced this recently with data coming from our E-commerce portal, here's a function we put in our Standard.Variables Include, so we can do this from any program: FUNCTION CLEAN.STRING(STRING.IN) RESULT = '' LEN.STR = LEN(STRING.IN) FOR STR.POS = 1 TO LEN.STR STR.CHAR = STRING.IN[STR.POS,1] DEC.VAL = SEQ(STR.CHAR) BEGIN CASE CASE DEC.VAL LT 32 NULL CASE DEC.VAL LT 126 RESULT := STR.CHAR CASE 1 NULL END CASE NEXT STR.POS RETURN(RESULT) usage - after we receive input from screen, or data load: RESP = CLEAN.STRING(RESP) BakerDOTHughes ATMouserDOTCom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carl Sadlier Sent: Tuesday, December 13, 2005 9:18 AM To: u2-users@listserver.u2ug.org Subject: [U2] records with unprintable characters Does anyone have a program or suggestions on how to clean up a file that has control characters and unprintable characters that are not Subvalue,Value or Field markers? Thanks, Carl --- 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] More Credit Card Info
From what I'm told, we can send/receive batch XML to their Live-Processor server (which will be on-site, within our WAN) and the LP server will handle the connection/communication to the PaymentTech gateway. This is all in process here so I'm still trying to wrap my brain around it. I'm writing the Programming Spec, as we speak. Maybe the socket approach you speak of is for the real-time authorizations, which we are not going to do in Phase One. bakerdothughes atmouser dotcom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Friday, December 02, 2005 7:16 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] More Credit Card Info I don't know if Paymentech has a drop file interface; it's been my experience that they prefer the socket interface. Even the settlement file is transferred and responses received over a socket interface. --- 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] Mod10 Credit Card Checksum
Say, has anyone written some code to validate a Credit Card number, using the Mod10 (nicknamed) or ANSI X4.13 (realname) LUHN formula? I was just told today get this installed yesterday, so I'm naturally looking to see if some kind-hearted fellow MV'ver has something already written (it is the season for giving ;-) ). I searched ansi.org and only got hits on meeting agendas - [in session 4.13 discuss blah blah] I found the previous u2ug posting that used Mod10 to validate a UPC, but it looks a bit different from algorithm described elsewhere to validate CCnumbers, and doesn't look agreeable to variable lengths (different you know based on each card type). I'm really thankful for U2UG, and glean much from the postings. I'd contribute more answers but I've only been at this 14 years and someone more seasoned invariably gives a thoroughly enlightening response. TIA. -Baker bakerdothughes atmouser dotcom --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Mod10 Credit Card Checksum
Thanks to each of you for the good postings. You've got me going now. I may miss their target date of yesterday but Tuesday is looking pretty good. Now, if anyone has an algorithm to speed up the QA dept things will shake out rather nicely. We'll be using something which follows very closely on James Thompson's subroutine. I wasn't going to check the prefix against card type, but before I got the final END on my subroutine, more requirements came in !-\ -Baker bakerdothughes atmouser dotcom --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/