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

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

[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

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

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

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

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

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

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-

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

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]

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

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. AD We developed

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

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

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 you

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 the

[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

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

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

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

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 Im working with that

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

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

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

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:

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:

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

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