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

[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 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.NAMES<1,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.TYPES<1> SETTING CC.PTR THEN
> CRT 'Account name: ':VALID.CC.NAMES<1,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.NAMES2<1,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.TYPES2<1> SETTING CC.PTR THEN
> CRT 'Account name: ':VALID.CC.NAMES2<1,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/

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

[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 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] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]

[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] [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] and PDF

[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 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 -  Open Source Pick
---
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?

[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 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] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]

[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: 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?

[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 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

[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 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.


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] and PDF

[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 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

[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
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 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.?

*=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 MV dbms

[Baker Hughes]

Janet,
 

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.


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] [AD] Fastest Bi-Directional data transfer btwn MV and no n MV dbms

[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

[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. 

 sort of refreshing to be called a troll, I stand 6'8" and
usually draw other names from folks 

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] 

Is it just me or does it smell like troll in here all of a
sudden
---
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

[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


> 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 [AD]

[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
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 dbms [AD]

[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 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]

[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/

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

[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] 

Is it just me or does it smell like troll in here all of a 
sudden
---
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

[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

[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 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

[Jeff Schasny]

Is it just me or does it smell like troll in here all of a 
sudden

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] curious EQUATE issue - SOLVED Just want to know if anyone understands WHY?

[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/

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

[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 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] ODBC error

[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 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/

RE: [U2] ODBC error

[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 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

[Anthony Youngman]

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/

RE: [U2] and PDF

[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 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?

[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 
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.NAMES<1,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.TYPES<1> SETTING CC.PTR THEN
 CRT 'Account name: ':VALID.CC.NAMES<1,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.NAMES2<1,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.TYPES2<1> SETTING CC.PTR THEN
 CRT 'Account name: ':VALID.CC.NAMES2<1,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

[Jeff Schasny]

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/

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

[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 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/