[U2] Haydon Bishop is out of the office.
I will be out of the office starting 11/08/2006 and will not return until 29/08/2006. I will respond to your message when I return. ___ The information contained in this message is intended for the addressee only and may contain confidential and/or privileged information. If you are not the addressee, please delete this message and notify the sender. You should not copy or distribute this message or disclose its contents to anyone. E-mail transmissions cannot be guaranteed to be secure or free of errors or viruses. Therefore, no reliance may be placed on this message without written confirmation from an authorized representative of its contents. Copyright ) 2006 Donovan Data Systems Ltd. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe ODBC driver performance issues {Unclassified}
Chris are you pulling data into SQL Server from UniVerse through an ODBC connection or are you pushing the data to the SQL Server through BCI. Regards David Jordan Managing Consultant [EMAIL PROTECTED] Chris is transferring on average about 360 (2.6M / 2 / 3600) records per second. If the records are ~200 chars, then he's getting about 700kb/sec (that's kb, not kB), or about 1.5% of the throughput you might hope for on a 100Mbps Ethernet pipe! So I'd say Chris does have an issue here. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Files reporting as changing during backup...
I will need to look more into the SUSPEND.FILES . -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Jenkins Sent: Wednesday, August 09, 2006 5:40 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Files reporting as changing during backup... SUSPEND.FILES ON - this is a minimum. What you are seeing is fairly predictable if the database is not quiescent. Best Bets: 1. SUSPEND.FILES ON Then one of: a. a SAN snap while suspended After just yesterday having one of our mirrored drives fail (although it wasn't an actual drive failure, but the RAID controller was screaming none the less. (we are atrributing this to a power fluctuation problem on the motherboard - just one more reason we need to replace our equipment ASAP). I'm not so keen on breaking any mirrors just at this time, because I KNOW, one of those drive will fail, while the mirror is broken. b. split a mirror while suspended - backup the mirror offline - and re-sync c. tar backup to a disk file [ fastest online method ] Is there a way to transfer a tarballed file on disk to tape, so that it can be untarred from tape as if it were originally backed up to tape? Then SUSPEND.FILES OFF I suppose, we could put restrictions during the 45 min it takes to tar up no one could work. Optionally you could uvbackup to a disk file and then tar backup the uvbackup separately (possibly after a compress). However while this will give you file integrity it will also take longer to run (it respects locks) and will not maintain referential integrity if the database is still being updated. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [U2C] FW: Opening
In like Flint and Our man Flint were movies with James Coburn in the 60's. Spoofs on the 007 movies. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 10, 2006 7:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: [U2C] FW: Opening OK - we're going to be asked to move over to the U2 community pages, but... Is it In Like Flynn or In Like Flint? The phrase is 'In Like Flynn' as in Errol Flynn, the actor from the 1930's. http://www.imdb.com/name/nm0001224/bio He had a flambouyant style and was arrested and subsequently charged with statutory rape (three times). After being aquitted on all charges, the phrase 'In Like Flynn' became popular. Jeff Butera Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 You're not right, Daddy my 3-year old showing her wisdom --- 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] Universe ODBC driver performance issues {Unclassified}
Mike,
The NIC is reporting 1-2% busy. Can you explain I-Type Dictionary
items? Is an I-Type Dictionary Item equivalent to a I-descriptor?
Sorry I am new to UniVerse, Thanks for your patience!!!
Chris
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE,
MR
Sent: Thursday, August 10, 2006 6:22 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe ODBC driver performance issues {Unclassified}
John,
Chris is transferring on average about 360 (2.6M / 2 / 3600) records per
second. If the records are ~200 chars, then he's getting about
700kb/sec (that's kb, not kB), or about 1.5% of the throughput you might
hope for on a 100Mbps Ethernet pipe!
So I'd say Chris does have an issue here.
I can see how increasing the block size would make the network traffic
less inefficient, it would be interesting to see what percent busy the
network card reports.
One of the other issues can be that the data contains, on the UV side,
complicated I-Type Dictionary items that mean that the exported data
isn't nearly as simple as it looks. This can cause an unexpectedly
large amount of I/O on the UV side.
Mike
-Original Message-
From: [EMAIL PROTECTED] On Behalf Of John Hester
Sent: Friday, 11 August 2006 08:39
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe ODBC driver performance issues
-Original Message-
From: [EMAIL PROTECTED] Behalf Of Chris Brooks
Sent: Thursday, August 10, 2006 8:21 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Universe ODBC driver performance issues
I am new to the group and to UniVerse. We are experiencing issues in
UniVerse 10.1.3 downloading data via the ODBC connection to SQL
Server.
2.6 mil records can take 2 hours to complete. We are currently using
the default settings for the ODBC driver. I will soon make changes to
increase the prefetch and threshold values. Any experience with the
ideal settings? From my testing the best performance seems to be at
prefetch = 16383 and threshold = 4096 on the ODBC driver. At this
settings seem to get a 30% performance increase. I would like to see
it improve even more.
During the download the CPU is utilized less than 10%.
Sounds like you're I/O bound, although 2.6 million records in 2 hours
isn't all that bad in my experience. Is it possible you're hitting the
threshold of your NICs, or competing with a lot of other network
traffic? If both machines have multiple NICs, you could reserve one on
each machine for only talking to the other. You could add an entry to
the hosts file on each so it would only know the other machine by the
reserved NIC's IP, then just make sure the reserved IP addresses don't
exist in DNS so no other machines will use them. If the machines are
physically close, a crossover cable from NIC to NIC would eliminate any
switch performance issues. At that point a rough calculation of your
throughput based on the average size of each record would tell you if
you're utilizing the available bandwidth, or if there's some other
bottleneck.
-John
---
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/
RE: [U2] Universe ODBC driver performance issues {Unclassified}
John,
It is abysmal because the NIC and the Ethernet are both gigabit.
Thanks,
Chris
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John Hester
Sent: Thursday, August 10, 2006 7:19 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe ODBC driver performance issues {Unclassified}
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON
MIKE, MR
Sent: Thursday, August 10, 2006 4:22 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe ODBC driver performance issues
{Unclassified}
John,
Chris is transferring on average about 360 (2.6M / 2 / 3600) records
per second. If the records are ~200 chars, then he's getting about
700kb/sec (that's kb, not kB), or about 1.5% of the throughput you
might hope for on a 100Mbps Ethernet pipe!
So I'd say Chris does have an issue here.
ODBC is known to be very chatty and inefficient, so you have to add
quite a bit of overhead for the protocol itself (though I don't know how
much). Even so, you're right, that's pretty poor performance over 100MB
ethernet and it would be abysmal for a gigabit link.
-John
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [U2C] FW: Opening
Here's the 'official' statement on the matter: http://www.worldwidewords.org/qa/qa-inl1.htm Matti -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of JPB Sent: 11 August 2006 14:40 To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: [U2C] FW: Opening In like Flint and Our man Flint were movies with James Coburn in the 60's. Spoofs on the 007 movies. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 10, 2006 7:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: [U2C] FW: Opening OK - we're going to be asked to move over to the U2 community pages, but... Is it In Like Flynn or In Like Flint? The phrase is 'In Like Flynn' as in Errol Flynn, the actor from the 1930's. http://www.imdb.com/name/nm0001224/bio He had a flambouyant style and was arrested and subsequently charged with statutory rape (three times). After being aquitted on all charges, the phrase 'In Like Flynn' became popular. Jeff Butera Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 You're not right, Daddy my 3-year old showing her wisdom --- 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] too many constants near line ...
Any ideas how to stop this, without refactoring a *very* big programme, it seems to be complaining about the number of strings we have defined, commenting out a sufficient number seems to solve it. I am hoping there is a setting that can be set to change the number of constants allowed in a programme? -- Management-speak, an occasional series where the names have been removed to shield the guilty. You would be killing one bird but giving birth to another with the same stone. -- * This message has been scanned for viruses and dangerous content by * Blairs of Scotland MailScanner, and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to which they * are addressed. * * If you have received this email in error please notify us at Blairs * of Scotland via email at [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [U2C] FW: Opening
I am not sure if I agree with the term 'dumped'. The former owners bought the company back and it flourished again in my opinion. But as former employee, you can take that for what it is worth. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Debster Sent: Thursday, August 10, 2006 10:38 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: [U2C] FW: Opening I'm just wondering how many vendors have purchased M2k to resell it...Once upon a time ADP had purchased it, then dumped it -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson Sent: Thursday, August 10, 2006 7:11 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: [U2C] FW: Opening Is it In Like Flynn or In Like Flint? - Original Message - From: Allen E. Elwood [EMAIL PROTECTED] To: Eric Armstrong [EMAIL PROTECTED] Cc: U2Users u2-users@listserver.u2ug.org; U2Community [EMAIL PROTECTED] Sent: Thursday, August 10, 2006 2:05 PM Subject: [U2] RE: [U2C] FW: Opening Hi Eric Andy is just a friend that I sent this email on behalf of, and isn't actually a member of this group. By M2K he meant Manage-2000 which is now owned by Epicor. This product has been around since 1978, and at last count had something like 700 menus. Never bothered counting the number of programs but it's probably around 10 to 12 thousand programs/subroutines. http://www.epicor.com/www/products/manufacturing/manage2k/ And on the other subject of 'good programming skills' if anyone here has ever seen one of Andy's programs they would know what he meant. He almost redesigns the language with his custom functions, so if you don't have a good handle on Unidata you might be lost for a month or so. I imagine that if you had 5 to 7 years of Unidata programming you'd be in like Flynn. M2k has a huge number of Utilities but they are fairly easy to learn, so the familiarity with Unidata would be more important, imho... hth, Allen -Original Message- From: Eric Armstrong [mailto:[EMAIL PROTECTED] Sent: Thursday, August 10, 2006 09:19 To: [EMAIL PROTECTED] Subject: FW: [U2C] FW: Opening Andrew, What did you mean by M2K? Did you mean W2K? Eric Armstrong Programmer/Analyst Lobel Financial 714.816.1207 714.995.7012 fax -Original Message- From: Allen E. Elwood [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 11:01 AM To: U2Users; U2Community Subject: [U2C] FW: Opening -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew McLaughlin Sent: Thursday, August 03, 2006 13:18 To: [EMAIL PROTECTED] Subject: [ManageUG2K] Opening Howdy all, First of all, a quick note to let everyone know, I've decided to resign from Shurflo and get back in to full time Java development. Woohoo! :) My last day here is 8/11. Now, my position will be open and we're interested in interviewing a suitable replacement. Anyone with M2K experience and good programming skills is a candidate. The office is located in beautiful Cypress, CA (Orange County). If you or someone else you know is interested, please send resume or CV directly to: [EMAIL PROTECTED] Thanks, Andrew __._,_.___ Messages in this topic (1) Reply (via web post) | Start a new topic Messages | Files | Photos | Links | Database | Polls | Members | Calendar You are receiving Individual Emails Change Delivery Settings Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe Visit Your Group SPONSORED LINKS a.. Business application software b.. Business application development c.. Business application d.. Epicor Yahoo! HotJobs Be Discovered! Employers find you Upload your resume New web site? Drive traffic now. Get your business on Yahoo! search. Y! Messenger Talk it up - free! Call your friends worldwide - free! . __,_._,___ u2-community mailing list [EMAIL PROTECTED] 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: [U2C] FW: Opening
END OF THREAD - Let's move this to U2-Community (Instructions below). Matti Lamprhey wrote: Here's the 'official' statement on the matter: http://www.worldwidewords.org/qa/qa-inl1.htm Matti -- - Charles Barouch, Moderator U2-Users U2-Community RBSolutions SBSolutions Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse all' lists to maintain your access. For non-U2UG e-mail: [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [U2C] FW: Opening
Larry has no place in this forum. - Is it In Like Flint? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe ODBC driver performance issues {Unclassified}
David
We are pulling data into SQL Server from UniVerse through an ODBC
connection.
Thanks
Chris
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Jordan
Sent: Friday, August 11, 2006 4:44 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe ODBC driver performance issues {Unclassified}
Chris are you pulling data into SQL Server from UniVerse through an ODBC
connection or are you pushing the data to the SQL Server through BCI.
Regards
David Jordan
Managing Consultant
[EMAIL PROTECTED]
Chris is transferring on average about 360 (2.6M / 2 / 3600) records
per second. If the records are ~200 chars, then he's getting about
700kb/sec (that's kb, not kB), or about 1.5% of the throughput you
might hope for on a 100Mbps Ethernet pipe!
So I'd say Chris does have an issue here.
---
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] Universe ODBC driver performance issues {Unclassified}
Does anyone have experience changing the MAXFETCHCOLS and MAXFETCHBUFF.
Are they change on both the client and the server?
Thanks
Chris
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Jordan
Sent: Friday, August 11, 2006 4:44 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe ODBC driver performance issues {Unclassified}
Chris are you pulling data into SQL Server from UniVerse through an ODBC
connection or are you pushing the data to the SQL Server through BCI.
Regards
David Jordan
Managing Consultant
[EMAIL PROTECTED]
Chris is transferring on average about 360 (2.6M / 2 / 3600) records
per second. If the records are ~200 chars, then he's getting about
700kb/sec (that's kb, not kB), or about 1.5% of the throughput you
might hope for on a 100Mbps Ethernet pipe!
So I'd say Chris does have an issue here.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [U2C] FW: Opening
Well... ok...dumped in the sense that the project in ADP's hands was so mismanaged that was how it was viewed..albeit incorrectly -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Friday, August 11, 2006 10:29 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] RE: [U2C] FW: Opening I am not sure if I agree with the term 'dumped'. The former owners bought the company back and it flourished again in my opinion. But as former employee, you can take that for what it is worth. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Debster Sent: Thursday, August 10, 2006 10:38 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: [U2C] FW: Opening I'm just wondering how many vendors have purchased M2k to resell it...Once upon a time ADP had purchased it, then dumped it -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson Sent: Thursday, August 10, 2006 7:11 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: [U2C] FW: Opening Is it In Like Flynn or In Like Flint? - Original Message - From: Allen E. Elwood [EMAIL PROTECTED] To: Eric Armstrong [EMAIL PROTECTED] Cc: U2Users u2-users@listserver.u2ug.org; U2Community [EMAIL PROTECTED] Sent: Thursday, August 10, 2006 2:05 PM Subject: [U2] RE: [U2C] FW: Opening Hi Eric Andy is just a friend that I sent this email on behalf of, and isn't actually a member of this group. By M2K he meant Manage-2000 which is now owned by Epicor. This product has been around since 1978, and at last count had something like 700 menus. Never bothered counting the number of programs but it's probably around 10 to 12 thousand programs/subroutines. http://www.epicor.com/www/products/manufacturing/manage2k/ And on the other subject of 'good programming skills' if anyone here has ever seen one of Andy's programs they would know what he meant. He almost redesigns the language with his custom functions, so if you don't have a good handle on Unidata you might be lost for a month or so. I imagine that if you had 5 to 7 years of Unidata programming you'd be in like Flynn. M2k has a huge number of Utilities but they are fairly easy to learn, so the familiarity with Unidata would be more important, imho... hth, Allen -Original Message- From: Eric Armstrong [mailto:[EMAIL PROTECTED] Sent: Thursday, August 10, 2006 09:19 To: [EMAIL PROTECTED] Subject: FW: [U2C] FW: Opening Andrew, What did you mean by M2K? Did you mean W2K? Eric Armstrong Programmer/Analyst Lobel Financial 714.816.1207 714.995.7012 fax -Original Message- From: Allen E. Elwood [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 11:01 AM To: U2Users; U2Community Subject: [U2C] FW: Opening -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew McLaughlin Sent: Thursday, August 03, 2006 13:18 To: [EMAIL PROTECTED] Subject: [ManageUG2K] Opening Howdy all, First of all, a quick note to let everyone know, I've decided to resign from Shurflo and get back in to full time Java development. Woohoo! :) My last day here is 8/11. Now, my position will be open and we're interested in interviewing a suitable replacement. Anyone with M2K experience and good programming skills is a candidate. The office is located in beautiful Cypress, CA (Orange County). If you or someone else you know is interested, please send resume or CV directly to: [EMAIL PROTECTED] Thanks, Andrew __._,_.___ Messages in this topic (1) Reply (via web post) | Start a new topic Messages | Files | Photos | Links | Database | Polls | Members | Calendar You are receiving Individual Emails Change Delivery Settings Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe Visit Your Group SPONSORED LINKS a.. Business application software b.. Business application development c.. Business application d.. Epicor Yahoo! HotJobs Be Discovered! Employers find you Upload your resume New web site? Drive traffic now. Get your business on Yahoo! search. Y! Messenger Talk it up - free! Call your friends worldwide - free! . __,_._,___ u2-community mailing list [EMAIL PROTECTED] 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/ --- 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] Unicommand Paragraphs
Still working on trying to get the paragraphs to work. no success with ENVINIT or ST.JUMPSTART. May be initializing them incorrectly. DG On 8/10/06, Wendy Smoak [EMAIL PROTECTED] wrote: On 8/10/06, gibboda [EMAIL PROTECTED] wrote: I am using UniObjects for Java. I am working on trying to run datatel query paragraphs using the Unicommands. I have successfully been able to run select statements, list statements and download statements individually with the unicommands. But I have several queries in paragraph forms and having trouble getting the unicommands to execute them. Any suggestions will be helpful. Before you do anything Datatel-related, make sure you execute 'ENVINIT' and FR.JUMPSTART'. (That's for Benefactor. It might be ST.JUMPSTART for the student system, etc.) My guess is that an I-Descriptor in one of your paragraphs expects the Envision environment to be there. -- Wendy --- 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] Universe ODBC driver performance issues {Unclassified}
Hi Chris Why don't you try pushing the data to SQL server using UvBasis and BCI, this may overcome some of the inefficiencies of ODBC Regards David Jordan Managing Consultant David We are pulling data into SQL Server from UniVerse through an ODBC connection. Thanks Chris --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
