RE: [U2] Universe and Microsoft Data Transformation Services (SQL Server)
And a couple of others: Are you posting to binary, text, or date columns? If you set up a table with purely varchar or nvarchar cols, can you post to that? I've seen similar errors when updating SQL Server directly (not using DTS) while trying to access binary or date/time columns where it could not interpret the type correctly. Brian Let's start with the basics: 1) What version of the UV/ODBC driver are you using to push the data from SQL Server into UV? 2) UV version and OS platform 3) Not really applicable in this particular issue, but: if on UNIX platform: what ODBC driver manager are using and the version? Have you re-linked UV with the ODBC driver manager? 4) have you ever had this work before? 5) have you successfully connected to UV from SQL server, if so - at what point does it fail? David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, 21 October 2007 6:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe and Microsoft Data Transformation Services (SQL Server) Hi, I am trying use the Microsoft Data Transformation Services (SQL Server) to get some records from a Oracle table and put into a Universe file, but when I try to connect to Universe it shows to me two errors, after verify the log file I can identify them : UCI SQLSetConnectOption(NLS) returned -1 SQLSTATE : S1009 Native Error : 0 [IBM][SQL Client]An illegal option value was specified Facility: DBCAPERR Severity: ERROR Error ID: 43 Extern error: 0 Message: Invalid connection or statement option value. UCI SQLSetConnectOption(LOC) returned -1 SQLSTATE : S1009 Native Error : 0 [IBM][SQL Client]An illegal option value was specified Facility: DBCAPERR Severity: ERROR Error ID: 43 Extern error: 0 Message: Invalid connection or statement option value. Somebody know how do I do do solve this problem? Somebody have used Data Transformation Services with Universe? --- 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] and PDF
The Son-Of-Boss joined the company and expressed disappointment that all of our forms are not pdfs. Right now, most of our forms are HP-GL/2. Also, none of the other end-users are looking to do things like eMail Purchase.Orders to suppliers. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Hona, David S Sent: Friday, October 19, 2007 7:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] and PDF What does 'manage' mean? Do you need barcodes, table of contents, graphics, charts, etc? Do you have a budget? The sky is the limit, of course! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Friday, October 19, 2007 2:03 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] and PDF What products are available to be able to create and manage Adobe pdf documents in a world of UniVerse, HP-Ux, and wIntegrate and Dynamic Connect clients? --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?
We are running in Reality flavor on UniVerse 10.2.4 and Red Hat Linux AS3. Here is a test of the code using the two forms of LOCATE: EQU VALID.CC.TYPES TO 'A':@VM:'B':@VM:'D':@VM:'M':@VM:'S':@VM:'V' EQU VALID.CC.NAMES TO 'American Express':@VM:'Carte Blanche':@VM:'Diners Club':@VM:'Mastercard':@VM:'Discover':@VM:'Visa' EQU VALID.CC.TYPES2 TO 'A]B]D]M]S]V' EQU VALID.CC.NAMES2 TO 'American Express]Carte Blanche]Diners Club]Mastercard]Discover]Visa' CC.ACCT.TYPE = 'A' CRT 'Equate with @VM: ':VALID.CC.TYPES CRT 'Equate with @VM: ':VALID.CC.NAMES CRT CRT 'Equate with `253: ':VALID.CC.TYPES2 CRT 'Equate with `253: ':VALID.CC.NAMES2 CRT CRT 'Account type: ':CC.ACCT.TYPE CRT CRT 'FIRST WAY' LOCATE(CC.ACCT.TYPE, VALID.CC.TYPES, 1 ; CC.PTR) THEN CRT 'Account name: ':VALID.CC.NAMES1,CC.PTR END ELSE CRT 'Account name: NOT FOUND' END CRT 'Position: ':CC.PTR CRT CRT 'SECOND WAY' LOCATE CC.ACCT.TYPE IN VALID.CC.TYPES1 SETTING CC.PTR THEN CRT 'Account name: ':VALID.CC.NAMES1,CC.PTR END ELSE CRT 'Account name: NOT FOUND' END CRT 'Position: ':CC.PTR CRT CRT 'THIRD WAY' LOCATE(CC.ACCT.TYPE, VALID.CC.TYPES2, 1 ; CC.PTR) THEN CRT 'Account name: ':VALID.CC.NAMES21,CC.PTR END ELSE CRT 'Account name: NOT FOUND' END CRT 'Position: ':CC.PTR CRT CRT 'FOURTH WAY' LOCATE CC.ACCT.TYPE IN VALID.CC.TYPES21 SETTING CC.PTR THEN CRT 'Account name: ':VALID.CC.NAMES21,CC.PTR END ELSE CRT 'Account name: NOT FOUND' END CRT 'Position: ':CC.PTR END And here are the results when you run the test program. Equate with @VM: A}B}D}M}S}V Equate with @VM: American Express}Carte Blanche}Diners Club}Mastercard}Discover}Visa Equate with `253: A}B}D}M}S}V Equate with `253: American Express}Carte Blanche}Diners Club}Mastercard}Discover}Visa Account type: A FIRST WAY Account name: American Express}Carte Blanche}Diners Club}Mastercard}Discover}Visa Position: 1 SECOND WAY Account name: NOT FOUND Position: 2 THIRD WAY Account name: American Express Position: 1 FOURTH WAY Account name: American Express Position: 1 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC error
? HS.UPDATE.FILEINFO -Original Message- If you did that, in that order, then the answer's simple. You need to update the cache AFTER updating HS_FILE_INFO. Can't remember the name of the command, but it's something like you need to run HS.UPDATE in the same account as HS_FILE_INFO in order to publish the changes. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] ODBC error
Tried that. Same error. I'm also getting the same error on the Sales Service demo accounts which are installed activated and updated. The truly strange part is that the ODBC configuration test in ODBC setup insists that the configuration is OK. I just downloaded the free WinSQL client program and it connects just fine so this may be an Office 2003/old UV PE/old ODBC client issue. My other computer which connects just fine is running Office 2000. I suppose I should get the latest UV PE version and associated clients and try that. Sounds like a plan. Anthony Youngman wrote: If you did that, in that order, then the answer's simple. You need to update the cache AFTER updating HS_FILE_INFO. Can't remember the name of the command, but it's something like you need to run HS.UPDATE in the same account as HS_FILE_INFO in order to publish the changes. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny Sent: 23 October 2007 14:54 To: u2-users@listserver.u2ug.org Subject: Re: [U2] ODBC error The connectivity tests in Universe ODBC setup work fine for all data sources. This is a new installation of both Universe and the ODBC clients on a new PC. I have installed these same UV PE version and ODBC clients on another PC and they work just fine. These were my install steps: New PC, Windows XP Pro, Windows firewall disabled Universe PE with matching ODBC client rev installed. Created new account and a couple files Created @ @SELECT items in the dictionaries of the new files Logto HS.ADMIN: Enabled ODBC access for the new account. Updated file information cache for the new account. Created new ODBC data source which tests clean. Tested Sales and Service demo data sources and they test clean. Added entries to HS_FILE_INFO with READ rights for the new files in the new accounts. Hona, David S wrote: Are you able to successfully complete the ODBC connectivity tests to the demo accounts on your server? If not, fix that first and then if that's not the problem it's probably related to a UV configuration problem. Check your unirpcservices config file and check there is no conflict with any other service on your server. BTW...has it ever worked? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny Sent: Monday, 22 October 2007 11:32 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ODBC error UV 10.0.10 and ODBC driver 3.07.02.7013 This same combination of UV and ODBC driver are working just fine on my personal laptop also under XP Pro I get the same error from HS.SALES, HS.SERVICE and my newly created account. Hona, David S wrote: What are UV server and client releases? Can you get a list of files from the built-in demo accounts: UV/ODBC Sales sample (HS.SALES) and UV/ODBC Service Sample (HS.SERVICE)? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Jeff Schasny - Denver, Co, USA jeff at schasny dot com --- 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/ -- Jeff Schasny - Denver, Co, USA jeff at schasny dot com --- 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] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?
Allen, In your example, you use a variable in an EQUATE statement. This references the variable's pointer, not its value. So the code: TEMP = CHANGE('A.B.D.M.S.V','.',@VM) EQU VALID.CC.TYPES TO TEMP TEMP = SOMETHINGELSE ;* change TEMP's value DISPLAY VALID.CC.TYPES will display SOMETHINGELSE, not the valid cc types as intended. rex --- 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
humorIs it just me or does it smell like troll in here all of a sudden/humor Since the question as defined in the sentence below is pretty generic I'll respond in kind. Sockets. Inter process communication across disparate platforms and applications is just what they were made for. Low overhead, high throughput, and completely neutral as to data format. Baker Hughes wrote: Hey, What is the fastest and lowest cpu overhead method of transferring data between U2/MV databases, and other data sources? [snip] -- Jeff Schasny - Denver, Co, USA jeff at schasny dot com --- 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
Baker, There is a happy medium between CPU overhead and bandwidth usage. If you use compression of some kind, then CPU overhead is going to be higher than an uncompressed stream. Cached disk writes are normally going to be faster than network writes, unless you have a fiber backbone or dedicated gigabit link. I can't give benchmarks for any of the integration I've done here, but I can say that: 1) XML is really wasteful all-around, but it can make your data considerably more portable. 2) SQL is a norm these days and some servers optimize on the query language and storage mechanism relating to it. MySQL is quite fast, in my limited experience. I can't afford to play with MS SQL Server. SQL implementations in MV may still leave a lot to be desired, though. 3) ASCII data from MV can be highly compressed, but once again there's the CPU usage. Raw/compressed ASCII is extremely portable, if the means and will are there to implement a custom communication protocol. (see my unfinished RFC for a stepping stone [http://mvdevcentral.com/MV-RFC.txt]) Some people may think I'm wierd, but I'm quite fond of SMTP services for large-block data transferring. It's not exactly real-time bi-directional, so I'm not sure if it fits your question. You decide. MTA servers like Postfix were written with efficiency in mind and have built-in routing logic and access control(mail boxes and aliases). A pop client can easily be written in most BASIC flavors, or a CLI client can be downloaded for free, which you can use to obtain new mail. MIME envelopes don't have to always contain text, photos, and HTML. They can contain a compressed image of an entire file's worth of MV data(within mail storage limitations) or the last 5 minute's transactional changes. Food for thought, even though I didn't exactly spell out a solution. Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 E-mail: [EMAIL PROTECTED] Web: http://www.all-spec.com Blog: http://blog.all-spec.com -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, October 23, 2007 11:58 AM To: u2-users@listserver.u2ug.org Subject: [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/ --- 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
Sockets. If you have a consumer that can accept a socket connection, I believe that'll provide the most efficient throughput. --- 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
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/
RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]
Hello Baker, Please email me. 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. Thanks, Janet Bond FusionWare Corporation Sales Operation Manager 1.866.266.2326 x159 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, October 23, 2007 8:58 AM To: u2-users@listserver.u2ug.org Subject: [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/ --- 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]
Janet, When posting as a vendor or service provider, please use [AD] brackets [/AD] in your response as a courtesy to others. - Charles Barouch, Moderator Janet Bond wrote: 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. --- 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]
I added it in the Subject should it be somewhere else? Please accept my apologies if I have offended anyone. Janet -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Moderator Sent: Tuesday, October 23, 2007 11:15 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD] Janet, When posting as a vendor or service provider, please use [AD] brackets [/AD] in your response as a courtesy to others. - Charles Barouch, Moderator Janet Bond wrote: 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. --- 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
I still have a copy of PK Harmony on 5.25 diskette. Of course I can't use it anywhere. It was a pretty good tool for us back in the day. Thanks for opening that part of my brain today. Karl quote who=Janet Bond Hello Baker, Please email me. 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. Thanks, Janet Bond FusionWare Corporation Sales Operation Manager 1.866.266.2326 x159 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, October 23, 2007 8:58 AM To: u2-users@listserver.u2ug.org Subject: [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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- 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] [AD] Fastest Bi-Directional data transfer btwn MV and no n MV dbms
There is www.OnGroup.com... --Bill --- 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/
RE: [U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?
Hi Rex, Interesting, never tried it before. I've only used it when I've had stuff that wouldn't go directly into EQU such as @(-1) in MvBASE. In that case I did: CCLR = @(-1) EQU CLR TO CCLR Wonder if EQU VALID.CC.TYPES TO CHANGE('A.B.D.M.S.V','.',@VM) Would work or error out.? *=aee=* -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rex Gozar Allen, In your example, you use a variable in an EQUATE statement. This references the variable's pointer, not its value. So the code: TEMP = CHANGE('A.B.D.M.S.V','.',@VM) EQU VALID.CC.TYPES TO TEMP TEMP = SOMETHINGELSE ;* change TEMP's value DISPLAY VALID.CC.TYPES will display SOMETHINGELSE, not the valid cc types as intended. rex --- 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
Janet, Fault is mine. The right edge of the title wasn't displaying on my screen so I assumed it was untagged. Janet Bond wrote: I added it in the Subject should it be somewhere else? Please accept my apologies if I have offended anyone. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] and PDF
When I was at Raining Data back in 1999 I created a demo which allows data entered in a PDF form to be posted to D3 via FlashCONNECT, and a simple web page is returned to confirm that data. The demo is available here: http://flashconnect.rainingdata.com/fcdemos/index.html Click the PDF demo. The DBMS is irrelevant as is the pipe from client to server. The same functionality is available with U2 and any of the common pipes used for web development. Is this the sort of functionality that you're looking for? If so, info is available there to help you work out how to do it on your own. Let me know if you'd like help with this or your other document processing/communications. Tony Gravagno Nebula Research and Development TG@ removethisNebula-RnD.com Blogging about southern California fires affecting local MV businesses: removeNebula-RnD.com/blog/cosmos/earth/2007/10/local-fires1.html Map updated at least every half hour. From: Brutzman, Bill The Son-Of-Boss joined the company and expressed disappointment that all of our forms are not pdfs. Right now, most of our forms are HP-GL/2. Also, none of the other end-users are looking to do things like eMail Purchase.Orders to suppliers. --- 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
What is the fastest and lowest cpu overhead method of transferring data between U2/MV databases, and other data sources? Our esteemed colleague and moderator Chuck Barouch has/had a product called Zeus which does/did transfers like this. If he can avoid self-censorship for a moment I would invite him to respond to this inquiry with his own experience in this area. As time permits I have been writing demos to show an MV DBMS populating SQL Server. As I said in another post today, the communications pipe is unimportant as is the DBMS. The same demo can be used for any MV DBMS and for any RDBMS, all someone needs to do is change the SQL query or stored procedure, and match the RDBMS fields to fields retrieved from the MV side. It comes down to a simple bit of X-to-Y mapping of fields and ensuring data types are properly managed. I'm sorry that I do not yet have a video of this on our website but I did show this demo and others along with code in my recent presentation to SAPUG. Maybe I can kick off a discussion of numbers: Without any optimization and on an over-burdened 2GHz laptop I'm getting about 200 records per second extracted from MV and Inserted into SQL Server. SQL Updates on the same data is roughly about 1/2 that. Amongst other business responsibilities I'm trying to find time to optimize the queries on both sides and run on a system which is more likely to generate production-quality numbers. I have a 3GHz dual core Athlon that should yield some good numbers soon. I'd appreciate it if someone else can provide some other realistic numbers so that I have a goal for acceptability. As a low-priority development project, and driven by common requests we find here, we have a package which moves data from any MV environment to any RDBMS. It allows for construction of a query string for about 15 different relational sources and that X/Y mapping of fields and data types. I wish this were further along so that I could provide some numbers about transfers from U2 to Excel, QM to Oracle, D3 to DB2, Reality to Interbase, etc. I would welcome discussion with someone who can help to drive this development. minor_rant If that's too subtle, and at the risk of soliciting, we can't proactively develop tools like this unless we get financing, and you only get people to fund projects if you ask. That's not an ad, it's a fact of business. More solutions would be available for common problems if this community were more willing to match supply/talent with the demand of ongoing business needs. As it is, for years we continue to see the same data transfer problems presented every week as though it's the first time someone is asking the question. / Tony Gravagno Nebula Research and Development TG@ removethisNebula-RnD.com Active updates of local fires in southern California, with map: removeNebula-RnD.com/blog/cosmos/earth/2007/10/local-fires1.html --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?
Allen, EQU VALID.CC.TYPES TO CHANGE('A.B.D.M.S.V','.',@VM) does compile and it will protect the value of VALID.CC.TYPES from being unintentionally changed -- which is the reason for using EQU to declare constants in the code. I just wanted to remind people that equating to a variable does not set an unchanging, constant value; this can be a source of hard-to-find bugs. rex --- 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]
Gee Janet all you had to do was put This is not an ad, it's a fact of business in your posting and you would have been alright. grs -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Janet Bond Sent: Tuesday, October 23, 2007 1:37 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD] I added it in the Subject should it be somewhere else? Please accept my apologies if I have offended anyone. Janet -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Moderator Sent: Tuesday, October 23, 2007 11:15 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD] Janet, When posting as a vendor or service provider, please use [AD] brackets [/AD] in your response as a courtesy to others. - Charles Barouch, Moderator Janet Bond wrote: 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. --- 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] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?
regarding the example below: EQU VALID.CC.TYPES TO CHANGE('A.B.D.M.S.V','.',@VM) The problem with this is that the CHANGE within the EQU will get evaluated at run time, so it will be done repeatedly if placed within a LOOP or FOR structure. You would be better off with the earlier suggestion of EQU VALID.CC.TYPES TO ('A':@VM:'B':@VM:'D':@VM:'M':@VM:'S':@VM:'V') The concatenation will be done by the compiler, and the parenthesis will protect the LOCATE field designator, 1,1 from being interpreted as an extraction. This does compile, by the way. -Rick On Oct 23, 2007, at 2:04 PM, Rex Gozar wrote: Allen, EQU VALID.CC.TYPES TO CHANGE('A.B.D.M.S.V','.',@VM) does compile and it will protect the value of VALID.CC.TYPES from being unintentionally changed -- which is the reason for using EQU to declare constants in the code. I just wanted to remind people that equating to a variable does not set an unchanging, constant value; this can be a source of hard-to- find bugs. rex --- 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] and PDF
In message [EMAIL PROTECTED], Brutzman, Bill [EMAIL PROTECTED] writes The Son-Of-Boss joined the company and expressed disappointment that all of our forms are not pdfs. Oh ... PHBs following the latest fad springs to mind ... :-) Right now, most of our forms are HP-GL/2. Seeing as you're on AIX, the solution other users have mentioned seems about right - set up a print queue using ghostscript that accepts HP-GL and chucks out pdfs. imho HP-GL and PCL are much better :-) but I've had a few nasty experiences with postscript drivers ... Also, none of the other end-users are looking to do things like eMail Purchase.Orders to suppliers. Ah - a solution looking for a problem :-) Cheers, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- 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]
[AD] Okay, let's play nice Chuck did say he missed the last letters of the subject. I will have Robert/Antoon Houben provide a comment for you all as they have a wealth of information and history with MultiValue systems. /AD Thank you, Janet -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George R Smith Sent: Tuesday, October 23, 2007 3:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD] Gee Janet all you had to do was put This is not an ad, it's a fact of business in your posting and you would have been alright. grs -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Janet Bond Sent: Tuesday, October 23, 2007 1:37 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD] I added it in the Subject should it be somewhere else? Please accept my apologies if I have offended anyone. Janet -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Moderator Sent: Tuesday, October 23, 2007 11:15 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD] Janet, When posting as a vendor or service provider, please use [AD] brackets [/AD] in your response as a courtesy to others. - Charles Barouch, Moderator Janet Bond wrote: 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. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Fastest Bi-Directional data transfer btwn MV and non
Baker, if you want something that will run pretty much anywhere, high throughput and all the transport level thinking done for you why not IBM MQSeries (Websphere MQ). Pretty easy to integrate into any of the MV's through the C libraries and IBM already make it available in UV/UD. Maybe not as fast as pure sockets but: - Flexible - Batch, Realtime, Send Receive, Send Forget, Publish Subscribe - Probably already works with your DB/Platform of choice - VERY reliable - Data format neutral -- send XML, Fixed Width, Dynamic Arrays, SQL statements whatever best fits your needs Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?
Jerry: I hate to mention the obvious, but one should not equate anything unless they intend both sides of the equate to change when either variable changes. For instance, DIM MYREC(30) EQUATE MYREC.DATE TO MYREC(1) EQUATE MYREC.NAME TO MYREC(2) --etc-- Thus, whenever MYREC changes, due to a new record read, so does MYREC.DATE, etc. Alternatively, you simply have to alter MYREC.DATE to make sure the MYREC record has been changed too. To fix the problems you've encountered try: VALID.CC.TYPES = 'A':@VM:'B':@VM:'D':@VM:'M':@VM:'S':@VM:'V' VALID.CC.NAMES = 'American Express':@VM:'Carte Blanche':@VM:'Diners Club':@VM:'Mastercard':@VM:'Discover':@VM:'Visa' VALID.CC.TYPES2 = 'A]B]D]M]S]V' VALID.CC.NAMES2 = 'American Express]Carte Blanche]Diners Club]Mastercard]Discover]Visa' ...the output looks like: 3 Dev (0)- RUN DTABP TEST Equate with @VM: A2B2D2M2S2V Equate with @VM: American Express2Carte Blanche2Diners Club2Mastercard2Discover2V isa Equate with `253: A2B2D2M2S2V Equate with `253: American Express2Carte Blanche2Diners Club2Mastercard2Discover2 Visa Account type: A FIRST WAY Account name: American Express Position: 1 SECOND WAY Account name: American Express Position: 1 THIRD WAY Account name: American Express Position: 1 FOURTH WAY Account name: American Express Position: 1 In all the years I've been doing this I've never run into these kinds of problems because I follow the basic guideline noted. So, use an equate if both sides can change. If that's not what you want make a simple assignment. There is no reason, with today's machines, to create more complexity of syntax in order to accomplish this simple task. Just my $.02 :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, October 23, 2007 7:06 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY? We are running in Reality flavor on UniVerse 10.2.4 and Red Hat Linux AS3. Here is a test of the code using the two forms of LOCATE: EQU VALID.CC.TYPES TO 'A':@VM:'B':@VM:'D':@VM:'M':@VM:'S':@VM:'V' EQU VALID.CC.NAMES TO 'American Express':@VM:'Carte Blanche':@VM:'Diners Club':@VM:'Mastercard':@VM:'Discover':@VM:'Visa' EQU VALID.CC.TYPES2 TO 'A]B]D]M]S]V' EQU VALID.CC.NAMES2 TO 'American Express]Carte Blanche]Diners Club]Mastercard]Discover]Visa' CC.ACCT.TYPE = 'A' CRT 'Equate with @VM: ':VALID.CC.TYPES CRT 'Equate with @VM: ':VALID.CC.NAMES CRT CRT 'Equate with `253: ':VALID.CC.TYPES2 CRT 'Equate with `253: ':VALID.CC.NAMES2 CRT CRT 'Account type: ':CC.ACCT.TYPE CRT CRT 'FIRST WAY' LOCATE(CC.ACCT.TYPE, VALID.CC.TYPES, 1 ; CC.PTR) THEN CRT 'Account name: ':VALID.CC.NAMES1,CC.PTR END ELSE CRT 'Account name: NOT FOUND' END CRT 'Position: ':CC.PTR CRT CRT 'SECOND WAY' LOCATE CC.ACCT.TYPE IN VALID.CC.TYPES1 SETTING CC.PTR THEN CRT 'Account name: ':VALID.CC.NAMES1,CC.PTR END ELSE CRT 'Account name: NOT FOUND' END CRT 'Position: ':CC.PTR CRT CRT 'THIRD WAY' LOCATE(CC.ACCT.TYPE, VALID.CC.TYPES2, 1 ; CC.PTR) THEN CRT 'Account name: ':VALID.CC.NAMES21,CC.PTR END ELSE CRT 'Account name: NOT FOUND' END CRT 'Position: ':CC.PTR CRT CRT 'FOURTH WAY' LOCATE CC.ACCT.TYPE IN VALID.CC.TYPES21 SETTING CC.PTR THEN CRT 'Account name: ':VALID.CC.NAMES21,CC.PTR END ELSE CRT 'Account name: NOT FOUND' END CRT 'Position: ':CC.PTR END And here are the results when you run the test program. Equate with @VM: A}B}D}M}S}V Equate with @VM: American Express}Carte Blanche}Diners Club}Mastercard}Discover}Visa Equate with `253: A}B}D}M}S}V Equate with `253: American Express}Carte Blanche}Diners Club}Mastercard}Discover}Visa Account type: A FIRST WAY Account name: American Express}Carte Blanche}Diners Club}Mastercard}Discover}Visa Position: 1 SECOND WAY Account name: NOT FOUND Position: 2 THIRD WAY Account name: American Express Position: 1 FOURTH WAY Account name: American Express Position: 1 --- 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/