RE: [U2] UD: Unidata Help Function

2008-09-18 Thread Colin Alfke
It works fine on my 7.1.6 and 7.2.0. Any error messages? VOC entries for HELP or HELP.FILE invalid? (HELP is globally catalogues and HELP.FILE is in the sys sub-directory). hth Colin Alfke Calgary, Canada> From: David_Wademan > > In the past that we can used HELP at the colon prompt to get inform

RE: [U2] Wintegrate Query Builder

2008-09-18 Thread Colin Alfke
Here are 2 dicts I created for the CUSTOMER file in the DEMO account. I didn't try them with ODBC though. They both work with the CATEGORIES_LIKED field in <9> of the CUSTOMER file. :AE DICT CUSTOMER ALL_CATEGORIES CL_POS CATLINK This one puts everything in one "blob" with the MV lines now separa

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

2008-09-18 Thread David Wolverton
Yup - I received your email -- And I'm glad this is moving up the chain. The bigger question to the User Group -- Are there 3rd party products that we as vendors and users **need** IBM to ensure work at some base level? Are there 'natural use' products that IBM really does need to test and assure

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

2008-09-18 Thread David Tod Sigafoos
TG> Dave wrote: >> And i would think that anyone running from 'Tiger >> Logic' (just another group of sales people selling >> something they don't make?) TG> "Tiger Logic" is simply a name change from "Raining Data" (IMO TG> only one of two good business decisions they've mad

Re: [U2] .net uniobjects error 39204

2008-09-18 Thread Clifton Oliver
Here's the error. I got this from the UniDK/include/Uvoaif file. UVE_SR_SLAVE_EXEC_FAIL = 39204' The slave failed to start correctly Unfortunately, just as an out of context error message, I don't know what it means. Maybe someone else can pick it up from here. Regards, Clif -- W. Clif

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

2008-09-18 Thread David Peters
I wanted to send a note on this much earlier, but have been tied up until now. We can't certify that other solutions, such as C.R., will work with our products, but we really do want them to work. It sort of makes sense that we would, because if our customers can't succeed with their solution

[U2] UD: Unidata Help Function

2008-09-18 Thread DAVID WADEMAN
In the past that we can used HELP at the colon prompt to get information about UniQuery or UniBASIC functions. Once we switch over from 6.x to 7.1.8 and now we lost the HELP function. Any ideas why this happen or this is something that Unidata is doing? David Wademan Senior DB Programmer / Syst

RE: [U2] access to mvBase VTF files

2008-09-18 Thread Tony G
Dave wrote: > And i would think that anyone running from 'Tiger > Logic' (just another group of sales people selling > something they don't make?) "Tiger Logic" is simply a name change from "Raining Data" (IMO only one of two good business decisions they've made in recent years). They acquired

RE: [U2] Wintegrate Query Builder

2008-09-18 Thread Bruce Ordway
Hi Colin, Your idea sounds like it would fix my problem. >You can either create an associated I-desc that has the mv position Can you show me an example? I have built some simple I-desc's, but I'm pretty weak at it. >or use a dict that combines all of the MV's into one block. This would be grea

[U2] .net uniobjects error 39204

2008-09-18 Thread Doug Chanco
I cannot seem to find any reference to this error number, the documentation goes from 39204 to 39210 Does anyone know what this error means? Thanks Dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

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

2008-09-18 Thread Bill Haskett
Charles: Isn't there a little .NET program on the IBM site that will test connection pooling? I'm sure I downloaded it and ran it to test the pooling license I have. Unfortunately, I upgraded my HDD and reloaded what I use every day but not this code. HTH, Bill -Original Message- From

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

2008-09-18 Thread David Tod Sigafoos
>> Tony, Funny thing about consultants .. first thing >> they want to do is write a program instead of finding >> a pre-existing solution. TG> Dave, anything I suggest is (usually) well considered before I TG> hit the reply button. Having done this thing for (I believe) TG>

RE: [U2] Wintegrate Query Builder

2008-09-18 Thread Colin Alfke
Remember - in the SQL world the order of data in the file is defined as unimportant. The MV's imply an order that is lost when "converted" to SQL. You can either create an associated I-desc that has the mv position (instead of actually adding the field for the line counter - which we actually have

RE: [U2] Wintegrate Query Builder

2008-09-18 Thread Anthony Youngman
Bear in mind that ODBC is relational is set-oriented. There is NO CONCEPT WHATSOEVER of "order" in sets, therefore if stuff comes out correctly ordered it *must* *be*, *by* *definition*, down to pure chance (or an accident of implementation). If you want to guarantee it, you need to add an extr

RE: [U2] Wintegrate Query Builder

2008-09-18 Thread Caryl Lange
We have that same issue with our ODBC connection and Access. We have tried adding a field for a line counter, which works but is cheesy. We also have one or two that we write twice, one MV and one SV. Neither solution is that graceful. Caryl -Original Message- From: [EMAIL PROTECTED] [mai

[U2] U2UG Board

2008-09-18 Thread jpb-u2ug
I want to thank you for the offer to join the Board of Directors of U2UG. It was an honor to be chosen. Unfortunately, with a recent shortage of programmers and increased work load here at work, I will have to respectfully decline the offer at this time. I would not have the time to give the job th

Re: [U2] Universe Lock Error

2008-09-18 Thread Allen Egerton
Bjorn Behr wrote: Morning All We are running on UV 10.2.11 and have encountered an error. Scenario: PROGRAM MAIN_PROG OPEN "FILE" TO FILE ELSE STOP 201,"FILE" CALL READ_PROG CRT "YOU SHOULD BE HERE...": INPUT X RELEASE FILE, "TESTER" PROGRAM READ_PROG (A) OPEN "FILE" TO FILE ELSE STOP

Re: [U2] Universe Lock Error

2008-09-18 Thread Martin Phillips
Hi Bjorn, This is how the language is defined to work. A lock is, to some extent, associated with a particular opening of a file via its file variable. Closing the file either explicitly or as a result of discarding the file variable on leaving the subroutine will give away any locks taken ag

RE: [U2] Universe Lock Error

2008-09-18 Thread Brian Leach
Bjorn That is working as it should. To preserve the lock, pass the file variable to the called routine or hold it open in common. Locks are released when a file is explicitly closed or the file variable goes out of scope. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[

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

2008-09-18 Thread John Bullard
Thanks, guys. As usual, the list was full of useful information. I came in this morning and changed my program to use OS-level copy commands instead of the UV COPY and it worked perfectly. I had always used the COPY command (even on type 1 and type 19 files) in my programs and it never occurred

[U2] RE: Universe Lock Error

2008-09-18 Thread Anthony Youngman
Closing a file apparently releases all the locks. There's an implied close in read_prog, therefore the lock gets released. To fix it, you need to remove the OPEN in read_prog, either by opening the file in COMMON or passing the file pointer as an argument. Yup, I agree that behaviour *might* be

[U2] Universe Lock Error

2008-09-18 Thread Bjorn Behr
Morning All We are running on UV 10.2.11 and have encountered an error. Scenario: PROGRAM MAIN_PROG OPEN "FILE" TO FILE ELSE STOP 201,"FILE" CALL READ_PROG CRT "YOU SHOULD BE HERE...": INPUT X RELEASE FILE, "TESTER" PROGRAM READ_PROG (A) OPEN "FILE" TO FILE ELSE STOP 201,"FILE" READU R

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

2008-09-18 Thread Hona, David S
Oops, sorry Charles - I miss read your query... here's app.config from an IBM supplied Connection Pooling code. It seems to work fine for me. --- Set pooling programmatically (VB.NET): [snip] Private m_IsPooling As Boolean = False [snip] UniObjects.UOPooling = m_IsPooling [snip] --- set pooling v

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

2008-09-18 Thread Anthony Youngman
Which *ix? A philosophy (which I tend heartily to agree with) is "if it ain't broke, don't fix it". Unfortunately, that also often leads to vendors saying "it works for everyone else, why do you need it changed?". Wonder what the limit is on RHEL? That's an *ux rather than an *ix so it *should*