RE: [U2] Universe and Microsoft Data Transformation Services (SQL Server)

2007-10-23 Thread Brian Leach
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

RE: [U2] and PDF

2007-10-23 Thread 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. --Bill -Original Message- From: [EMAIL

RE: [U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?

2007-10-23 Thread Jerry Banker
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

RE: [U2] ODBC error

2007-10-23 Thread Mark Eastwood
? 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

Re: [U2] ODBC error

2007-10-23 Thread Jeff Schasny
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

[U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Baker Hughes
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

Re: [U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?

2007-10-23 Thread 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

Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Jeff Schasny
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

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Glen Batchelor
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

Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Kevin King
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

2007-10-23 Thread Jerry Banker
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

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]

2007-10-23 Thread 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

Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]

2007-10-23 Thread Moderator
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

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]

2007-10-23 Thread Janet Bond
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

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV

2007-10-23 Thread karlp
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

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Baker Hughes
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

RE: [U2] [AD] Fastest Bi-Directional data transfer btwn MV and no n MV dbms

2007-10-23 Thread Brutzman, Bill
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

2007-10-23 Thread Baker Hughes
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

RE: [U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?

2007-10-23 Thread Allen E. Elwood
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.?

Re: [U2] Fastest Bi-Directional data transfer btwn MV and non

2007-10-23 Thread Moderator
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

RE: [U2] and PDF

2007-10-23 Thread Tony G
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

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Tony G
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

Re: [U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?

2007-10-23 Thread Rex Gozar
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

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]

2007-10-23 Thread George R Smith
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:

Re: [U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?

2007-10-23 Thread Richard Nuckolls
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

Re: [U2] and PDF

2007-10-23 Thread Anthony W. Youngman
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

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]

2007-10-23 Thread Janet Bond
[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]

Re: [U2] Fastest Bi-Directional data transfer btwn MV and non

2007-10-23 Thread Craig Bennett
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

RE: [U2] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?

2007-10-23 Thread Bill Haskett
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