RE: [U2] uniVerse COPY command and the UVTEMP directory

The UV COPY verb is intended for copying records from hashed files. However the UV "COPY" verb was originally a UNIX executable (pre UV v7, I think). Hence, it didn't have the memory limitations of the existing UV/BASIC application (COPY.B). I understand that it would required significant re-en

RE: [U2] [Uv 10.2] Connection Pooling Working?

Hi David, Yep, I have the license activated on Universe. But I don't think pooling is actually being invoked from .NET. - Many Thanks, Charles -- View this message in context: http://www.nabble.com/-Uv-10.2--Connection-Pooling-Working--tp19544504p19545579.html Sent from the U2 - Users maili

RE: [U2] [Uv 10.2] Connection Pooling Working?

>From TCL, type "CONFIG". If it is licensed then you will have a entry for "-CONNPL" displayed somewhere in the output. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of charles ferguson Sent: Thursday, 18 September 2008 1:08 PM To: u2-users

RE: [U2] cannot fnuxi a file with a trigger...

Thanks Bernard, I'll pass this information about UV.ACCESS to the administrator. On our version (10.2) I can drop the triggers and save/restore/fnuxi the file but I obviously can't do this on the production files. Now I might be able to investigate if triggered files uvrestore okay. Note to IBM:

[U2] [Uv 10.2] Connection Pooling Working?

Hi all, I'm connecting to a Universe 10.2 db via a C# .NET app using UniObjects. It works fine using a standard user-license and now I'm looking at implementing a connection pool. Problem is, when I use the code from the 10.2 manual: UniObjects.UOPooling = true; I get: 'IBMU2.UODOTNET.UniObjec

Re: [U2] Next UniVerse Release

From the UV account, you can use the TCL command SUSPEND.FILES {ON | OFF}. From the OS level use uv -admin -L and -U to resume. SUSPEND.FILES by itself or uv -admin -R will report whether suspend is on or off. UVSUSPEND.B source is in the UV account's APP.PROGS, if you want to have a lo

RE: [U2] cannot fnuxi a file with a trigger...

Stuart, We have the same issue when copying files from AIX to Linux or vice-versa, if there are triggers attached. Even dropping the trigger does not work. The only work around that we use is to create a new copy of the file on the originating server, then send that file instead. I have been told

RE: [U2] [UD] Crystal Reports and UniData

We do have one client using UniData against Crystal Reports. We use ODBC for the connection and I'm not sure which version of CR they are using - but it does seem to work well. hth Colin Alfke Calgary Canada> From: dwolvert> [snip] > That said, before I actually told the client I"m working with th

RE: [U2] uniVerse COPY command and the UVTEMP directory {Unclassified}

I have come across this limitation before, too. One work-around is to use READSEQ and WRITESEQ, that seems to work OK even when COPY and ED fail. Also, the item size limit on the Windows implementation of UV was much larger than that on Unix last time I participated in a conversion (it may even ha

Re: [U2] [UD] Crystal Reports and UniData

I agree with you 100% Tony from the independence makes things 'better' for people who are platform agnostic -- we're talking a 100% UniData solution in all cases, and the issue we're seeing more and more is that prospects want to see that the 'core engine' supports the ability to use BI tools th

RE: [U2] access to mvBase VTF files

> Tony, Funny thing about consultants .. first thing > they want to do is write a program instead of finding > a pre-existing solution. Dave, anything I suggest is (usually) well considered before I hit the reply button. Having done this thing for (I believe) almost as long as you have, I'm fam

RE: [U2] [UD] Crystal Reports and UniData

> From DAVID WOLVERTON > > And to make sure I'm clear -- Tony - you are proposing a > 'middleware' tool to make U2 do something that in theory it > should be already intrinsic to the product - is that right? Let's (un)define terms. "Middleware" - Something that is outside of the DBMS. This m

[U2] Wintegrate Query Builder

Hi, I have some notes that are stored in a MV field. My application, (Dataflo) keeps the lines in order. However, I use Wintegrate Query Builder to export them. I have found that the notes don't necessarily come out in the proper sequence. For example: I am going to The park today And then I Wi

Re: [U2] uniVerse COPY command and the UVTEMP directory

That happens to me all the time when I try to COPY a &HOLD& file/record to another directory. My reports are often 230mb or larger. I asked IBM, and they said "COPY always had a size limit." Can't ED it either, as Dan observed. So I just wrote a program to select the records, and copy them using

RE: [U2] uniVerse COPY command and the UVTEMP directory

It's something else. you've probably exceeded the available memory (RAM) for that user. Now, the question is "why"? 200Mb isn't all that much, so I'd look to see if there was a problem with that record's structure, insofar as UV is concerned. Of course, you'll probably get the same error when yo

Re: [U2] [UD] Crystal Reports and UniData

Does this email thread confirm that U2's OLE-DB has an issue with Crystal Reports 2008 (or any 'current version' of Crystal Reports)? Do it confirm that it is not working anywhere? And to make sure I'm clear -- Tony - you are proposing a 'middleware' tool to make U2 do something that in theory

[U2] uniVerse COPY command and the UVTEMP directory

Does the uniVerse COPY command use the UVTEMP directory for workspace? I have a program that is creating a >200MB XML file in the &HOLD& file. It then transfers (or attempts to transfer) that file to another file using "COPY FROM &HOLD& TO OTHERFILE TMP41904 OVERWRITING". When this command is i

Re: Re[2]: [U2] access to mvBase VTF files

David, I do not know of any way to read/write vtf files or account saves or file saves between mvBase and Universe. We do have a tool that will convert D3 account saves so they can be restored by Universe - if you can get your mvBase account save restored to a D3 machine. We developed th

RE: [U2] [UD] Crystal Reports and UniData

Exactly. Doing it WITHOUT an AS keyword (as is happening in my case) will cause it to blow up. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: 17 September 2008 16:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD]

RE: [U2] [UD] Crystal Reports and UniData

Usually, the AS keyword is in use... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, September 17, 2008 10:18 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] Crystal Reports and UniData But won't it then disa

RE: [U2] [UD] Crystal Reports and UniData

But won't it then disappear up its own backside with ambiguous field names? Iiuc, listing multiple file names does a cross-product, and as a result if you repeat the same file name, EVERY field will be ambiguous and the SQL will be unable to resolve. Cheers, Wol -Original Message- From

RE: [U2] [UD] Crystal Reports and UniData

SELECT FIELDS FROM TABLE_ASSOC TABLE_ASSOC could just as well read SELECT FIELDS FROM TABLE_ASSOC MY_SELECTED_TABLE It does conform to SQL... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, September 17, 2008 4:14 AM To

Re: [U2] I need a correlative, just like the correlative...

I don't know how to do that in a correlative i.e. Pick/SMA style dictionary entry. Any help would be appreciated. Allen E. Elwood wrote: > Which is why I always just use a subr. The real cost to the client is the > cost creation and maintenance. Subr's are just *so* easy to understand. > > a

RE: [U2] [UD] Crystal Reports and UniData

If IBM knows "CR has not worked right since Version 9" you would think IBM would have adapted their interface to strip quotes... Obviously CR running in other OLE-DB environments IS compliant. :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wol

Re: [U2] Next UniVerse Release

Clifton Oliver wrote: Based on the posting on this topic from Steve O'Neal, it appears we have our answer. Always do a "sync" after pausing the database. how does on "pause" the database in universe? thanks dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe pleas

Re: [U2] AIX Socket Command?

The way I would do it, is as follows: 1. login as root 2. run netstat -Aan | grep LISTEN you will see something similar to the following: # netstat -Aan | grep LISTEN f1f302506b58 tcp4 0 0 *.13 *.*LISTEN f1f302502358 tcp0 0 *.21

RE: [U2] cannot fnuxi a file with a trigger...

Hi Stuart The best way I've found is to actually zero the pointer in the file header to the location of the SICA block, effectively removing the trigger and constraint details, then running fnuxi. Not good. Otherwise I have a utility program that builds a backup image of an account, set of accoun

[U2] cannot fnuxi a file with a trigger...

First question, just wondering how others get around this issue. We're copying files from Aix (Risc) production to Linux (x86) scratch for use in dev and test environments. The files which have triggers on them are interpreted as sql files and cannot be fnuxied. For the moment I am just copying the

RE: [U2] [UD] Crystal Reports and UniData

I looked at that SQL and thought "what's wrong with double quotes?" (but then I don't know SQL that well). I thought quoting field names was mandatory if they contained spaces and optional otherwise. Or should it be single quotes and double is the problem? I'm still having problems with the dou

RE: [U2] If you run UV, Read This !!! Change to UV Backup Recommendations

Stephen Many thanks for researching and clarifying this. Regards Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Stephen O'Neal > Sent: 16 September 2008 19:47 > To: u2-users@listserver.u2ug.org > Subject: [U2] If you run UV, Read This