RE: [U2] [UV][SB+] International

[U2]

Dear Mike,

No experience in SB+, only in UV

Look into the documentation on NLS 

1) Date
- does the date display / entry need to be localized.
2) Multi-byte characters
- printing will be an issue that need to be tested throughly. Using command
like PRINT MYCHAR 'L#10' will NOT align the multi-byte characters correctly,
need to use command PRINT FMTDP(MYCHAR,'L#10'). I think there is a patch
from IBM on this issue (VLIST ???)
- Storing of data: you can store the data in either ASCII or UNICODE but if
you need to access the data in HP-UX (e.g. &HOLD& file), you need to store
it in ASCII (with relevant file map table)
- Command like LEN will return the number of characters instead number of
character that take up spaces. If an issue, then need to change to LENDP.
- Indexing: if you need to index multi-byte characters, your file mapping
must be NONE (no file mapping) , otherwise the index on the multi-byte
character field will be wrong.

In addition, certain UV commands might not behave as documented.
- RESIZE: will not work on file with NLS map.
- ACCOUNT.FILE.STATS: will not report the file stats correctly due to
additional line in command ANALYZE.FILE. Need to change program BP
ACCT.STAT.B to ignore the additional line.

HTH,
js

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Farrant

My environment:

Unix VersionHP-UX  B.11.11
Universe Version  9.6.1.6
SB+ Version3.4.0/7

My Question:

How 'international' is my environment?  Our business is likely to roll out
to Eastern Europe, Russia perhaps and even places like Turkey and Isreal.
To my knowledge I think HP-UX can cope with the different characters used by
at least some of these countries, but what about Universe & SB+?

Does anyone have any experience with this?

Thanks in advance,

Mike Farrant
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Out of office

[Tony Gravagno]

I filter "out of the office" messages, and this entire thread was pulled
from my U2 folder and dumped in a "don't bother" area.  I'm SO happy I did
bother.  BTW, Disclaimers of confidentiality in a public forum area about
as annoying as out of office notices. ;)

T

Andy Moore wrote:
> DISCLAIMER:
> This email and any files transmitted with it are
> confidential and intended solely for the use of the
> individual or entity to whom they are addressed.
[snip]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Re: U2 Users Digest V1 #881

[Jeff Fitzgerald]

Russ,

You didn't give us your cell phone number!  We'd all like to call
you just to say, "Hi!," since you went to the trouble to let everyone on the
list know about your schedule.

Jeff 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Russ DeWitt
Sent: Friday, October 14, 2005 12:59 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Re: U2 Users Digest V1 #881

I will be out of the office on business, Friday 10/14/2005 thru Monday
10/17/2005. During this time I will not have access to my email. If you need
to contact me, please call me on my cell phone.

Thanks,

Russ
---
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] Out of office

[Bob Woodward]

If someone has his number, we could call and find out.  Oh, and I'll be
out of the office Saturday and Sunday, too.  

BobW

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:owner-u2-
> [EMAIL PROTECTED] On Behalf Of Shawn Waldie
> Sent: Friday, October 14, 2005 7:41 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Out of office
> 
> I just have one question:
> Is Richard Taylor out of the office today?
> ---
> 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] Out of office

[Allen E. Elwood]

I'm sure he's sipping from his pina-colada on the beach in Mexico wondering
why his ears are ringing.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of George Gallen
Sent: Friday, October 14, 2005 11:36
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Out of office


> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Larry Hiscock
> Sent: Friday, October 14, 2005 1:40 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Out of office
>
> 2) There WON'T be 10 days worth of messages, as Mr Taylor has been
> unsubscribed.
>

Good. I don't mind one or two, but EVERY day to remind us that he
is NOT working and we are.that's just mean :)

George
---
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] connection from UniBasic to a SQL database

[Wendy Smoak]

From: "Metherall, Arthur" <[EMAIL PROTECTED]>


 We're running AIX and have found Easysoft ODBC-ODBC Bridge
software to be great!  (granted we're only pulling information from
MS SQL into UniData, but that's ALL we need it for.)


As soon as I hear from someone for whom it works on HP-UX on Itanium, we'll 
be there. :)


--
Wendy 
---

u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UD] UniQuery virtual field question

[Kathy Tymoczko]

Thanks much!  Changing the subvalue marks to some other character did the 
trick!


At 11:32 AM 10/14/05, Stevenson, Charles wrote:

TRANS( file, mv.ids, mv.target.fld, 'X'); CONVERT( @SM, '~', @); SUBR(
'-FIELDS', @, '~',1,1)
  or
SUBR( '-FIELDS', CONVERT( @SM, '~', TRANS( file, mv.ids, mv.target.fld,
'X' )), '~', 1, 1 )

Explanation:  Since FIELDS &  the other multivalued handling subroutines
break things out by and other delimiters, you can't get it to act On the
delimiters themselves.

So convert the system-delimiter you are interested in (in your case
subvalue marks, I believe) to a not-system-delimiter that will not
appear in the data and act on that.

cds

P.S.  I don't have UD, only UV, so I'll leave it to the UD gurus to
correct any subtle distinctions.

P.P.S.

I often find it useful for debugging purposes, to temporarilly cocnvert
alll the delimiters to visible characters, just to see what I'm dealing
with:

  01: I
  02: [some buggy multi-(sub)valued calc]
  03: MD2
  04:
  05: 10R
  06: M

temporarilly becomes

  01: I
  02: [some buggy multi-(sub)valued calc];CONVERT(
@IM:@AM:@VM:@SM:@TM,'iavst',@ )
  03:
  04:
  05: 50L
  06: S
---


Kathy Tymoczko
Information Technology Services
Wabash College, Crawfordsville, Indiana 47933
[EMAIL PROTECTED] 765-361-6440 
---

u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Re: U2 Users Digest V1 #881

[Russ DeWitt]

I will be out of the office on business, Friday 10/14/2005 thru Monday
10/17/2005. During this time I will not have access to my email. If you
need to contact me, please call me on my cell phone.

Thanks,

Russ
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Universe running on Linux/SuSE

[Anthony Dzikiewicz]

We have been running for just over a year.  We converted from DG/UX
(intel platform).

We went from intel to intel, so we didn't have the 'endian' issues.  I
did recompile and catalog all code and recreate all indexes on our files
for safe keeping.

Printers were pretty much the same ol', same ol'  we don't do anything
complicated so it was easy.

Cron is still cron.  There was a bug in RHEL where cron had problems
with daylight savings time.  This was a big problem for us, because all
of our nightly processing depends on cron.  Im happy to say that it is
fixed.

Linux is just as stable as DG/UX.  The only thing I can comment on is
that DG/UX did not change and it was rare to get updates.  Linux is
updating all the time.  So in that respect, I guess you have more
opportunity to make thing unstable.  Don't update unless you have to.

We are running 10.1.1 and the only issue Im affected by is that you can
no longer do a MASTER OFF ALL - it doesn't work.

Anthony

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rob Thometz
Sent: Thursday, October 13, 2005 1:49 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Universe running on Linux/SuSE


We have a finance system with around 200 users running Universe 9.6 on
Sun Solaris OS 8. For various reasons, we are considering moving to a
Red Hat Enterprise Linux or SuSE Enterprise Linux environment. The
Universe/Linux OS release combinations we are initially considering are
as follows:

Universe 10.1.1 with RHEL V3
Universe 10.1.12 with SuSE EL

Just wondering how many of you have gone through similar Unix to Linux
OS changes? What issues should we be aware of prior to this change? More
specifically: 

- Are there issues when converting Universe data files from Unix/Solaris
OS to Linux?
- Is there difficulty getting printers to function properly on Linux?
- Are changes required to any scripts and/or cron daemons running
scripts on Linux?
- Has Linux proven to be more or less stable than Unix?
- Has anyone had success running the Universe/Linux combinations listed
above or had success running other combinations?
- Any major issues with Universe 10.1.1/10.1.12?

I apologize in advance if my questions are a bit too broad. I am simply
interested in gaining basic knowledge on the feasibility of running
Universe on Linux, and any pitfalls to be aware of. Any information
provided will prove valuable as we continue our discussions on a
possible move from Unix to Linux.

Thank you in advance for your comments!

Rob Thometz
Info Tech Analyst
City of St. Paul, Minnesota 
---
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] Out of office

[George Gallen]

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Larry Hiscock
> Sent: Friday, October 14, 2005 1:40 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Out of office
> 
> 2) There WON'T be 10 days worth of messages, as Mr Taylor has been
> unsubscribed.  
> 

Good. I don't mind one or two, but EVERY day to remind us that he 
is NOT working and we are.that's just mean :)

George
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified}

[Metherall, Arthur]

Wendy,

  Not sure I cut your original message out of the messages correctly, but here 
goes.

  As someone else mentioned for unix you need to 'acquire' 3rd party software 
in order to access non-unix databases from unix, i.e., MS SQL, Oracle, Sybase, 
etc.

  We're running AIX and have found Easysoft ODBC-ODBC Bridge software to be 
great!  (granted we're only pulling information from MS SQL into UniData, but 
that's ALL we need it for.)

  Check out their website at www.easysoft.com, their inexpensive especially 
compared to certain other 3rd parties.

  It's easy to install and setup. Contact me off list if you have any questions.

  Hope this is helpful,

Arthur


Arthur Metherall
Courier Corporation


-Original Message-

From: [EMAIL PROTECTED] On Behalf Of Wendy Smoak
Sent: Friday, 14 October 2005 09:10
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] connection from UniBasic to a SQL database [was What are you 
using to develop your web pages...] {Unclassified}


 We're on HP-UX.  At the moment I'm reading from Sybase with their JDBC

 driver then using UniObjects for Java to write records into UniData.
 It's working fine, but it would be
 *really* nice to connect directly to Sybase from a UniBasic program.

 --
 Wendy Smoak
 ---
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Out of office

[Larry Hiscock]

1) There is a way to either set most email clients a) not to respond to list
messages, or b) to send only a single "away" message to any given email
address.

2) There WON'T be 10 days worth of messages, as Mr Taylor has been
unsubscribed.  There may be a few more over the next hour or so, as messages
may already be in the pipeline.

Larry Hiscock
Moderator


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andy Moore
Sent: Friday, October 14, 2005 8:02 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Out of office

DISCLAIMER:
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error, please delete it and notify the
sender immediately.  Please note that there is no guarantee that this email
or any attachment is virus free or has not been intercepted or amended.

There'll be 10 days of out of office emails, surely there's a way to set out
of office systems to not respond to U2 user group emails? 


Andy Moore
Selima Software Ltd.

-Original Message-
From: Shawn Waldie [mailto:[EMAIL PROTECTED]
Sent: 14 October 2005 15:41
To: u2-users@listserver.u2ug.org
Subject: [U2] Out of office

I just have one question:
Is Richard Taylor out of the office today?
---
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] connection from UniBasic to a SQL database

[Wendy Smoak]

From: "HENDERSON MIKE, MR" <[EMAIL PROTECTED]>


I've written stuff to read from a SQL database into UniBasic using the
BCI.

UV 10.0.15 to MS SQL Server 2000, all on Windows, using the MS SQL
Server driver.


I hear it does work on Windows.  On HP-UX, however, no one I know of has 
found the magic combination of driver manager and driver that actually 
works.


--
Wendy Smoak 
---

u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UD] UniQuery virtual field question

[Nick Cipollina]

One thing you might want to do is use
RAISE(TRANS('filename',field,field,'X'))  The reason for this is that
when you use a file translate in an I-Descriptor, it drops fields to
multi-values, multi-value to sub-values etc...

Thanks,
 
Nick Cipollina
 
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kathy Tymoczko
Sent: Friday, October 14, 2005 11:42 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UD] UniQuery virtual field question

I'm trying to make an i-descriptor that does the following:  From a 
multi-valued field, TRANS to another multi-valued field in a second
file, 
and return just the first subvalue of that field for each record pointed
to 
by the second field.

In the FILE1, I have a multi-valued field that is a list of pointers to
the 
FILE2.  And in that file is a multi-valued list of IDs.  I only want the

first one of those.  So that instead of a list that looks like:

FILE1 IDFILE2 IDS   IDS
1234557 12345   0123456
 0748923
 13467   0003456
 13578   0034569
 0143434

I would have a list that looks like:

FILE1 IDFILE2 IDS   IDS
1234557 12345   0123456
 13467   0003456
 13578   0034569

I've read the entire chaper on virtual fields in the "Using Unidata" 
manual, but nothing I've tried (FIELD, SUBR('-FIELDS'), EXTRACT among
other 
things) has worked.

Any suggestions would be greatly appreciated.



Kathy Tymoczko
Information Technology Services
Wabash College, Crawfordsville, Indiana 47933
[EMAIL PROTECTED] 765-361-6440 
---
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] Richard Taylor/VERTIS is out of the office.

[Richard Taylor]

I will be out of the office starting  10/14/2005 and will not return until
10/24/2005.

I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UD] UniQuery virtual field question

[Stevenson, Charles]

TRANS( file, mv.ids, mv.target.fld, 'X'); CONVERT( @SM, '~', @); SUBR(
'-FIELDS', @, '~',1,1)
  or  
SUBR( '-FIELDS', CONVERT( @SM, '~', TRANS( file, mv.ids, mv.target.fld,
'X' )), '~', 1, 1 )
 
Explanation:  Since FIELDS &  the other multivalued handling subroutines
break things out by and other delimiters, you can't get it to act On the
delimiters themselves.

So convert the system-delimiter you are interested in (in your case
subvalue marks, I believe) to a not-system-delimiter that will not
appear in the data and act on that.

cds

P.S.  I don't have UD, only UV, so I'll leave it to the UD gurus to
correct any subtle distinctions.


P.P.S.


I often find it useful for debugging purposes, to temporarilly cocnvert
alll the delimiters to visible characters, just to see what I'm dealing
with:

  01: I
  02: [some buggy multi-(sub)valued calc]
  03: MD2 
  04:  
  05: 10R
  06: M
 
temporarilly becomes

  01: I
  02: [some buggy multi-(sub)valued calc];CONVERT(
@IM:@AM:@VM:@SM:@TM,'iavst',@ )
  03:  
  04:  
  05: 50L
  06: S
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Basic vs Execute Select

[Mark Johnson]

Not an actual application, just something that's come up every once and a
while and I've used a temp file to flag those processed and re-selected.

I guess the only pure way is on a dormant system.

Thanks for all the replies.
MarkJohnson
- Original Message -
From: "Ralph Burton" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, October 12, 2005 1:48 PM
Subject: Re: [U2] Basic vs Execute Select


> From what I understand, you need to make sure new records are processed...
then create
> a second file where the keys are written at the same time the original
record is written.
>
>  Then set up a continous loop to read through the file,
> removing the keys when they are processed.
> Use the sleep command to slow down your loop.
> You could set a flag in a table that the program could read to end the
loop... etc.
>
> It would be easier if there was more info about the actual application...
>
>
> Ralph Burton <[EMAIL PROTECTED]> wrote:
> I would use a straight Select in basic program and not use an Execute or
Perform.
>
> OPEN "FILES" TO F.FILES ELSE ...
>
> SELECT F.FILES
>
>
>
> Mark Johnson wrote:
> You're kidding. I requested 'counted for', not counted.
>
> The earlier SELECT thread brought up the concept of records added during
the
> processing. Thus, how could you insure that all records were processed,
even
> those latecomers.
>
> Mark Johnson
> - Original Message -
> From: "Ralph Burton"
> To:
> Sent: Tuesday, October 11, 2005 1:32 PM
> Subject: Re: [U2] Basic vs Execute Select
>
>
> > EXECUTE "COUNT FILENAME"
> >
> >
> > Mark Johnson wrote:
> > A recent thread debated the speed of these 2 SELECT methods.
> >
> > My question is what would be the preferred way to insure that all
records
> may
> > be counted for on an active system instead of a dormant system.
> >
> > Thanks in advance.
> > Mark Johnson
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> >
> >
> > -
> > Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
> > ---
> > 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/
>
>
> -
> Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
>
>
> -
>  Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
> ---
> 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] Basic vs Execute Select

[Mark Johnson]

Yes, accounted for. Sorry if Ralph interpeted 'counted for' as 'counted'.
- Original Message - 
From: "Bill_H" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, October 12, 2005 12:07 PM
Subject: RE: [U2] Basic vs Execute Select


> Mark:
> 
> Do you mean "accounted for"?
> 
> Bill 
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] 
> > [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> > Sent: Wednesday, October 12, 2005 7:58 AM
> > To: u2-users@listserver.u2ug.org
> > Subject: Re: [U2] Basic vs Execute Select
> > 
> > You're kidding. I requested 'counted for', not counted.
> > 
> > The earlier SELECT thread brought up the concept of records 
> > added during the processing. Thus, how could you insure that 
> > all records were processed, even those latecomers.
> > 
> > Mark Johnson
> > - Original Message -
> > From: "Ralph Burton" <[EMAIL PROTECTED]>
> > To: 
> > Sent: Tuesday, October 11, 2005 1:32 PM
> > Subject: Re: [U2] Basic vs Execute Select
> > 
> > 
> > > EXECUTE  "COUNT FILENAME"
> > >
> > >
> > > Mark Johnson <[EMAIL PROTECTED]> wrote:
> > > A recent thread debated the speed of these 2 SELECT methods.
> > >
> > > My question is what would be the preferred way to insure that all 
> > > records
> > may
> > > be counted for on an active system instead of a dormant system.
> > >
> > > Thanks in advance.
> > > Mark Johnson
> > > ---
> > > u2-users mailing list
> > > u2-users@listserver.u2ug.org
> > > To unsubscribe please visit http://listserver.u2ug.org/
> > >
> > >
> > > -
> > >  Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
> > > ---
> > > 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] connection from UniBasic to a SQL database

[Peter Gonzalez]

Hello Bob.   I would like to see a sample of how you do that.   You don't 
have to give away your source, but giving us an ideal of how it works.


thanks.





-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney
Sent: Thursday, October 13, 2005 11:13 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] connection from UniBasic to a SQL database [was What
are you using to develop your web pages...] {Unclassified}

Wendy:

We talk to ms sql all the time thru OpenLink ODBC drivers using the BCI

It works fine and the only problems we had was with the ODBC driver

Have routines that do it if you'd like to look

Bob

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of gerry-u2ug
Sent: 14 October 2005 01:48
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] connection from UniBasic to a SQL database [was What
are you using to develop your web pages...] {Unclassified}


things are not this simle on unix - 3rd party odbc drivers need to be
purchased , installed & configured.
I have never worked with a client who has gone this route, it never
seems to be worth the bother & expense.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of HENDERSON MIKE,
MR
Sent: Thursday, October 13, 2005 06:11 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] connection from UniBasic to a SQL database [was What
are you using to develop your web pages...] {Unclassified}


Wendy

> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of Wendy Smoak
> Sent: Friday, 14 October 2005 09:10
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] [AD] What are you using to develop your web pages?
> JavaScript? PHP? .Net?
>
> From: "Symeon Breen" <[EMAIL PROTECTED]>
>
> > it is easy to read/write mysql from your Unibasic.
>
> Really?  So far we have not been successful getting a connection from
> UniBasic to a SQL database.  What are you using?  (My guess is that
> you're on Windows.)

I've written stuff to read from a SQL database into UniBasic using the
BCI.
There's no conceptual difference between reading & writing, it's just a
matter of using a SQL INSERT or MODIFY instead of a SELECT in the string
passed to SQL.  I do have some doubts about how to set up transactions
to allow simultaneous SQL & UV updates, but that's functionality we
don't need yet.

The BCI documentation is sparse and the example code execrable, but it
does work and performance is not too bad, either.

UV 10.0.15 to MS SQL Server 2000, all on Windows, using the MS SQL
Server driver.

Mike

>
> We're on HP-UX.  At the moment I'm reading from Sybase with their JDBC

> driver then using UniObjects for Java to write records into UniData.
> It's working fine, but it would be
> *really* nice to connect directly to Sybase from a UniBasic program.
>
> --
> Wendy Smoak
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
>
The information contained in this Internet Email message is intended for
the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence
Force.
If you are not the intended recipient you must not use, disclose, copy
or distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
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/

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
__

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
__
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified}

[Noah Hart]

Bob,

I'd like to see those routines,

Thanks,

Noah

 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney
Sent: Thursday, October 13, 2005 11:13 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] connection from UniBasic to a SQL database [was What
are you using to develop your web pages...] {Unclassified}

Wendy:

We talk to ms sql all the time thru OpenLink ODBC drivers using the BCI

It works fine and the only problems we had was with the ODBC driver

Have routines that do it if you'd like to look

Bob

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of gerry-u2ug
Sent: 14 October 2005 01:48
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] connection from UniBasic to a SQL database [was What
are you using to develop your web pages...] {Unclassified}


things are not this simle on unix - 3rd party odbc drivers need to be
purchased , installed & configured.
I have never worked with a client who has gone this route, it never
seems to be worth the bother & expense.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of HENDERSON MIKE,
MR
Sent: Thursday, October 13, 2005 06:11 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] connection from UniBasic to a SQL database [was What
are you using to develop your web pages...] {Unclassified}


Wendy 

> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of Wendy Smoak
> Sent: Friday, 14 October 2005 09:10
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] [AD] What are you using to develop your web pages? 
> JavaScript? PHP? .Net?
> 
> From: "Symeon Breen" <[EMAIL PROTECTED]>
> 
> > it is easy to read/write mysql from your Unibasic.
> 
> Really?  So far we have not been successful getting a connection from 
> UniBasic to a SQL database.  What are you using?  (My guess is that 
> you're on Windows.)

I've written stuff to read from a SQL database into UniBasic using the
BCI.
There's no conceptual difference between reading & writing, it's just a
matter of using a SQL INSERT or MODIFY instead of a SELECT in the string
passed to SQL.  I do have some doubts about how to set up transactions
to allow simultaneous SQL & UV updates, but that's functionality we
don't need yet.

The BCI documentation is sparse and the example code execrable, but it
does work and performance is not too bad, either.

UV 10.0.15 to MS SQL Server 2000, all on Windows, using the MS SQL
Server driver.

Mike

> 
> We're on HP-UX.  At the moment I'm reading from Sybase with their JDBC

> driver then using UniObjects for Java to write records into UniData.  
> It's working fine, but it would be
> *really* nice to connect directly to Sybase from a UniBasic program.
> 
> --
> Wendy Smoak
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> 
The information contained in this Internet Email message is intended for
the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence
Force.
If you are not the intended recipient you must not use, disclose, copy
or distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
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/

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
__

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
__
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] [UD] UniQuery virtual field question

[Kathy Tymoczko]

I'm trying to make an i-descriptor that does the following:  From a 
multi-valued field, TRANS to another multi-valued field in a second file, 
and return just the first subvalue of that field for each record pointed to 
by the second field.

In the FILE1, I have a multi-valued field that is a list of pointers to the 
FILE2.  And in that file is a multi-valued list of IDs.  I only want the 
first one of those.  So that instead of a list that looks like:

FILE1 IDFILE2 IDS   IDS
1234557 12345   0123456
 0748923
 13467   0003456
 13578   0034569
 0143434

I would have a list that looks like:

FILE1 IDFILE2 IDS   IDS
1234557 12345   0123456
 13467   0003456
 13578   0034569

I've read the entire chaper on virtual fields in the "Using Unidata" 
manual, but nothing I've tried (FIELD, SUBR('-FIELDS'), EXTRACT among other 
things) has worked.

Any suggestions would be greatly appreciated.



Kathy Tymoczko
Information Technology Services
Wabash College, Crawfordsville, Indiana 47933
[EMAIL PROTECTED] 765-361-6440 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Richard Taylor/VERTIS is out of the office.

[Richard Taylor]

I will be out of the office starting  10/14/2005 and will not return until
10/24/2005.

I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Out of office

[rlsmith]

Why no I was not aware of that.

Thanks...



What a minute..


Who's Richard Taylor???

:)

LOL

Randy Smith Programmer/Analyst
[EMAIL PROTECTED]

" I used to be an Optimist until I knocked over the glass. "

http://resumes.hotjobs.com/randy_lee_smith/main
http://users.adelphia.net/~lee_crystal/
http://www.sopranoboy.com

Zaner Bloser
http://www.zaner-bloser.com



"Shawn Waldie" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED]
10/14/2005 10:40 AM
Please respond to
u2-users@listserver.u2ug.org


To

cc

Subject
[U2] Out of office






I just have one question:
Is Richard Taylor out of the office today?
---
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] Out of office

[Dave Walker]

I imagine that if you wait a couple of minutes, he might let you know.

--
Dave Walker
8..7 4(())  -:&:-
  -:&:-8.74 .74(())
 ((88.74  ..74  -:&:-
((88.74   * Peace

 

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Shawn Waldie
> Sent: Friday, October 14, 2005 10:41 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Out of office
> 
> 
> I just have one question:
> Is Richard Taylor out of the office today?
> ---
> 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] Out of office

[Andy Moore]

DISCLAIMER:
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error, please delete it and notify
the sender immediately.  Please note that there is no guarantee that
this email or any attachment is virus free or has not been intercepted
or amended.

There'll be 10 days of out of office emails, surely there's a way to set
out of office systems to not respond to U2 user group emails? 


Andy Moore
Selima Software Ltd.

-Original Message-
From: Shawn Waldie [mailto:[EMAIL PROTECTED] 
Sent: 14 October 2005 15:41
To: u2-users@listserver.u2ug.org
Subject: [U2] Out of office

I just have one question:
Is Richard Taylor out of the office today?
---
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] Out of office

[Shawn Waldie]

I just have one question:
Is Richard Taylor out of the office today?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Richard Taylor/VERTIS is out of the office.

[Richard Taylor]

I will be out of the office starting  10/14/2005 and will not return until
10/24/2005.

I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified}

[Symeon Breen]

MySql is easy - i understand it is perhaps not as easy if you are
talking MS sql and your U2 is on unix - as said above third party
drivers are required or an odbc bridge !


On 10/14/05, Mats Carlid <[EMAIL PROTECTED]> wrote:
> gerry-u2ug wrote:
>
> >things are not this simle on unix - 3rd party odbc drivers need to be 
> >purchased , installed & configured.
> >I have never worked with a client who has gone this route, it never seems to 
> >be worth the bother & expense.
> >
> >
> >
> >
> Price shouldn't be a problem with mysql:
>
> > *MySQL Connector/ODBC* (also known as MyODBC) allows you to connect to
> > a MySQL database server using the ODBC database API on all Microsoft
> > Windows and most Unix platforms, including through such applications
> > and programming environments such as Microsoft Access, Microsoft
> > Excel, and Borland Delphi.
> >
> >
> >   Features
> >
> > *Standards compliant*
> >
> > The production-ready version of Connector/ODBC is compliant with
> > the ODBC 2.50 specification, Level 0 (with some Level 1 and 2
> > features). The stable version, is compliant with the ODBC 3.51
> > specification, Level 1 (complete Core API and Level 2 features).
> >
> > *Cross-platform*
> >
> > Connector/ODBC is available for Microsoft Windows, as well as many
> > Unix systems (including Linux, Sun Solaris, HP-UX, IBM AIX, and
> > Mac OS X).
> >
> >
> >   Downloads, Licensing, and Support
> >
> > Two versions of MySQL Connector/ODBC are available for download:
> >
> > * MySQL Connector/ODBC 3.51
> >    is the
> >   production-ready version of the driver, and is available under
> >   the GPL.
> > * MySQL Connector/ODBC 2.50
> >    is the
> >   old production-ready version of the driver, and is available
> >   under the LGPL.
> >
> > MySQL Connectors are available under the MySQL AB "dual licensing"
> > model. Under this model, users may choose to use MySQL products under
> > the free software/opensource GNU General Public License
> > 
> > (commonly known as the "GPL") or under acommercial license
> > .
> >
> from  www.mysql.com/products/connector/odbc
>
> -- mats
> ---
> 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] What are you using to develop your web pages? JavaScript? PHP? .Net?

[Symeon Breen]

Hi unidata 6 and now 7 on linux - if you have a unix odbc driver then
it should be fairly easy. If there is only a windows one available
then you can use an odbc bridge (i think easysoft or similar do one) -
it is basicaly a unix odbc driver that attaches to a windows server
end then onto a windows odbc.



On 10/13/05, Wendy Smoak <[EMAIL PROTECTED]> wrote:
> From: "Symeon Breen" <[EMAIL PROTECTED]>
>
> > it is easy to read/write mysql from your Unibasic.
>
> Really?  So far we have not been successful getting a connection from
> UniBasic to a SQL database.  What are you using?  (My guess is that you're
> on Windows.)
>
> We're on HP-UX.  At the moment I'm reading from Sybase with their JDBC
> driver then using UniObjects for Java to write records into UniData.  It's
> working fine, but it would be *really* nice to connect directly to Sybase
> from a UniBasic program.
>
> --
> Wendy Smoak
> ---
> 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] UniOleDB - Delphi

[Brian Leach]

Claus,

If you have set up your config file correctly (looks ok, did you use the
horrible UCI Config editor to make sure it is saved in the right place ?)
your connection string should just read:

"Provider=IBM.UniOLEDB.1;Persist Security Info=False;Data
Source=TESTFAMIS;Password={your_password_here}"

To test this outside of Delphi, try the following bit of VBScript

(open notepad, paste in and save as test.vbs. That extension should be
associated with WSCRIPT.EXE ...)

Dim dbConn
Dim dbCmd
Dim dbRS

Set dbConn = CreateObject("ADODB.Connection")
dbConn.ConnectionString="Provider=IBM.UniOLEDB.1;Persist Security
Info=False;Data Source=TESTFAMIS;Password={your_password_here}"
dbConn.Open



Set dbCmd = CreateObject("ADODB.Command")
Set dbCmd.ActiveConnection = dbConn
dbCmd.CommandText = "SELECT * FROM {your_test_table_here}"
Set dbRS = dbCmd.Execute

dbRS.MoveFirst
Msgbox dbRS.Fields(1)


Not the best VBScript in the world but it should fall over quickly if there
are errors 

Brian
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Richard Taylor/VERTIS is out of the office.

[Richard Taylor]

I will be out of the office starting  10/14/2005 and will not return until
10/24/2005.

I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] UniOleDB - Delphi

[Claus Derlien]

Hi, 

I'm trying to make a connection from Delphi with UniOleDB to our UniVerse 
database, but i am stucked with not being able to connect..

Here is what i have done :

1)  Via HS.ADMIN as root made the account visible to UniOleDB, also ran 
HS.SCRUB on a few files so i had  
  something to work with, no problems

2)  UniDK kit was already installed, so i edited the uci.config file so now 
it looks like this :

[ODBC DATA SOURCES]


DBMSTYPE = UNIVERSE
account = /data1/FAMIS
host = 10.9.200.20
network = TCP/IP
service = uvserver
username = CD
  
  I have removed the section with UniData as we only run UniVerse  
the above section 'TESTFAMIS' is build by following the 'Using 
UniOLEDB' manual

3.  Next i made a DELPHI6 project with an empty form and dropped an ADO 
connection component
  using the connection string builder i made this conn. string :

  Provider=IBM.UniOLEDB.1;Persist Security Info=False;User ID=CD;
Data Source=TESTFAMIS;Location=FAMIS;Mode=ReadWrite

No matter what i have tried i get the same error string in return when trying 
to connect :

   Died UCI::SQLConnect() with SQLSTATE IM976, Native error:0 [IBM][SQL 
CLient]UCI connections to 
   non UniVerse databases is not allowed..

I guess there is a bond between the uci.config file and the connection string, 
but i havent figured it out yet.

Can anyone show me the right path ? 


best regards from Denmark

Claus Derlien

Frie Funktionfrer - faglig organisation og tvfrfaglig a-kasse - www.f-f.dk

***
Denne email og alle filer vedlagt som bilag kan indeholde fortroligt materiale, 
der kun er beregnet for adressaten,
og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en 
fejltagelse modtaget denne email, bedes
De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa forhaand 
tak.
***
This email and any files transmitted with it may contain confidential 
information intended for the addressee(s) only.
The information is not to be surrendered or copied to unauthorised persons. If 
you have received this
communication in error, please notify us immediately by telephone: +45 6313 
8550. Thank you.
***
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Richard Taylor/VERTIS is out of the office.

[Richard Taylor]

I will be out of the office starting  10/14/2005 and will not return until
10/24/2005.

I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Richard Taylor/VERTIS is out of the office.

[Richard Taylor]

I will be out of the office starting  10/14/2005 and will not return until
10/24/2005.

I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Richard Taylor/VERTIS is out of the office.

[Richard Taylor]

I will be out of the office starting  10/14/2005 and will not return until
10/24/2005.

I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Richard Taylor/VERTIS is out of the office.

[Richard Taylor]

I will be out of the office starting  10/14/2005 and will not return until
10/24/2005.

I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] [UV][SB+] International

[Mike Farrant]

My environment:

Unix VersionHP-UX  B.11.11
Universe Version  9.6.1.6
SB+ Version3.4.0/7

My Question:

How 'international' is my environment?  Our business is likely to roll
out to Eastern Europe, Russia perhaps and even places like Turkey and
Isreal.  To my knowledge I think HP-UX can cope with the different
characters used by at least some of these countries, but what about
Universe & SB+?

Does anyone have any experience with this?

Thanks in advance,

Mike Farrant
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Richard Taylor/VERTIS is out of the office.

[Richard Taylor]

I will be out of the office starting  10/14/2005 and will not return until
10/24/2005.

I will respond to your message when I return.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Printer problems on UV PE under Windows XP

[Brian Leach]

Eric,

A couple more points:

1. You can specify a share name to SETPTR so long as the printer has been
locally added to the system. The share name cannot contain spaces.

2. SOME printers will work if you use a generic/text only driver and install
them locally, however ...

3. You may need to specify GDI mode. Not all printers will work with a
generic/text only driver. One of mine ( a Konica Minolta colour laser) only
works in GDI using the correct Konica drivers.

i.e.

SETPTR AT \\myserver\KONICA,GDI

Where KONICA is the share name on myserver.

Brian 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Universe running on Linux/SuSE

[Brian Leach]

Rob,

As a comment, at my last company all our development was (and as far as I am
aware still is) done using UniVerse on Linux. This was a combination we used
for over 10 years. Stable certainly. 

Brian 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

SV: [U2] Universe running on Linux/SuSE

[Claus Derlien]

We have been running Uv 10.1.0 for just about 2 years now on RH 8.0
uptime on our production machine is 261 days, and last downtime was only to 
insert another scsi controller to external backup.

We came from a Digital Alpha running Thru64 4.0e so no fnuxi was needed on the 
files..

We have attached about 15 printers, some of them cant have different logical 
units, so i had stair stepping
problems on them, but was able to solve it by modifying the jobs on the spooler.

No real problems have been experienced, even our cron file ran unmodified...

I did spend some time to setup ssh, and to change a few perl scripts to support 
the new environment
but with CPAN it's a matter of minutes to get your perl inst. up to speed :-)

I have tried the same setup on fedora 4, gentoo, debian 3.1 testing, centos 
(rhes 3 without the redhat).
if you check required glibc/libc on IBM's website against the linux you plan to 
run on and you have same or higher version then you should have no problems...
Universe does not require a certain distro, all that is needed is a minimum 
version of glibc/libc

There is a small difference between the way redhat/suse systems handle the 
uv.rc script
suse does everything according to the unix way, whereas the redhat dudes had no 
clues about unix when they started, so they adopted their own standard, but if 
you choose redhat, then the inst. script is made for redhat

best regards from a happy linux user

Claus Derlien


-Oprindelig meddelelse-
Fra: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] vegne af Rob Thometz
Sendt: 13. oktober 2005 19:49
Til: u2-users@listserver.u2ug.org
Emne: [U2] Universe running on Linux/SuSE


We have a finance system with around 200 users running Universe 9.6 on
Sun Solaris OS 8. For various reasons, we are considering moving to a
Red Hat Enterprise Linux or SuSE Enterprise Linux environment. The
Universe/Linux OS release combinations we are initially considering are
as follows:

Universe 10.1.1 with RHEL V3
Universe 10.1.12 with SuSE EL

Just wondering how many of you have gone through similar Unix to Linux
OS changes? What issues should we be aware of prior to this change? More
specifically: 

- Are there issues when converting Universe data files from
Unix/Solaris OS to Linux?
- Is there difficulty getting printers to function properly on Linux?
- Are changes required to any scripts and/or cron daemons running
scripts on Linux?
- Has Linux proven to be more or less stable than Unix?
- Has anyone had success running the Universe/Linux combinations listed
above or had success running other combinations?
- Any major issues with Universe 10.1.1/10.1.12?

I apologize in advance if my questions are a bit too broad. I am simply
interested in gaining basic knowledge on the feasibility of running
Universe on Linux, and any pitfalls to be aware of. Any information
provided will prove valuable as we continue our discussions on a
possible move from Unix to Linux.

Thank you in advance for your comments!

Rob Thometz
Info Tech Analyst
City of St. Paul, Minnesota 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

 
Denne mail er blevet scannet af http://www.virus112.com 


Frie Funktionfrer - faglig organisation og tvfrfaglig a-kasse - www.f-f.dk

***
Denne email og alle filer vedlagt som bilag kan indeholde fortroligt materiale, 
der kun er beregnet for adressaten,
og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en 
fejltagelse modtaget denne email, bedes
De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa forhaand 
tak.
***
This email and any files transmitted with it may contain confidential 
information intended for the addressee(s) only.
The information is not to be surrendered or copied to unauthorised persons. If 
you have received this
communication in error, please notify us immediately by telephone: +45 6313 
8550. Thank you.
***
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified}

[Mats Carlid]

gerry-u2ug wrote:

>things are not this simle on unix - 3rd party odbc drivers need to be 
>purchased , installed & configured.
>I have never worked with a client who has gone this route, it never seems to 
>be worth the bother & expense.
>
>
>  
>
Price shouldn't be a problem with mysql:

> *MySQL Connector/ODBC* (also known as MyODBC) allows you to connect to 
> a MySQL database server using the ODBC database API on all Microsoft 
> Windows and most Unix platforms, including through such applications 
> and programming environments such as Microsoft Access, Microsoft 
> Excel, and Borland Delphi.
>
>
>   Features
>
> *Standards compliant*
>
> The production-ready version of Connector/ODBC is compliant with
> the ODBC 2.50 specification, Level 0 (with some Level 1 and 2
> features). The stable version, is compliant with the ODBC 3.51
> specification, Level 1 (complete Core API and Level 2 features).
>
> *Cross-platform*
>
> Connector/ODBC is available for Microsoft Windows, as well as many
> Unix systems (including Linux, Sun Solaris, HP-UX, IBM AIX, and
> Mac OS X).
>
>
>   Downloads, Licensing, and Support
>
> Two versions of MySQL Connector/ODBC are available for download:
>
> * MySQL Connector/ODBC 3.51
>    is the
>   production-ready version of the driver, and is available under
>   the GPL.
> * MySQL Connector/ODBC 2.50
>    is the
>   old production-ready version of the driver, and is available
>   under the LGPL.
>
> MySQL Connectors are available under the MySQL AB "dual licensing" 
> model. Under this model, users may choose to use MySQL products under 
> the free software/opensource GNU General Public License 
>  
> (commonly known as the "GPL") or under acommercial license 
> .
>
from  www.mysql.com/products/connector/odbc

-- mats
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified}

[Bob Witney]

Wendy:

We talk to ms sql all the time thru OpenLink ODBC drivers using the BCI

It works fine and the only problems we had was with the ODBC driver

Have routines that do it if you'd like to look

Bob

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of gerry-u2ug
Sent: 14 October 2005 01:48
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] connection from UniBasic to a SQL database [was What
are you using to develop your web pages...] {Unclassified}


things are not this simle on unix - 3rd party odbc drivers need to be purchased 
, installed & configured.
I have never worked with a client who has gone this route, it never seems to be 
worth the bother & expense.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of HENDERSON MIKE,
MR
Sent: Thursday, October 13, 2005 06:11 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] connection from UniBasic to a SQL database [was What
are you using to develop your web pages...] {Unclassified}


Wendy 

> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of Wendy Smoak
> Sent: Friday, 14 October 2005 09:10
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] [AD] What are you using to develop your web 
> pages? JavaScript? PHP? .Net?
> 
> From: "Symeon Breen" <[EMAIL PROTECTED]>
> 
> > it is easy to read/write mysql from your Unibasic.
> 
> Really?  So far we have not been successful getting a 
> connection from UniBasic to a SQL database.  What are you 
> using?  (My guess is that you're on Windows.)

I've written stuff to read from a SQL database into UniBasic using the
BCI.
There's no conceptual difference between reading & writing, it's just a
matter of using a SQL INSERT or MODIFY instead of a SELECT in the string
passed to SQL.  I do have some doubts about how to set up transactions
to allow simultaneous SQL & UV updates, but that's functionality we
don't need yet.

The BCI documentation is sparse and the example code execrable, but it
does work and performance is not too bad, either.

UV 10.0.15 to MS SQL Server 2000, all on Windows, using the MS SQL
Server driver.

Mike

> 
> We're on HP-UX.  At the moment I'm reading from Sybase with 
> their JDBC driver then using UniObjects for Java to write 
> records into UniData.  It's working fine, but it would be 
> *really* nice to connect directly to Sybase from a UniBasic program.
> 
> --
> Wendy Smoak
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> 
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
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/

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/