RE: VOC corruption
Check if any of the following apply to your site (I think we had this problem, on a old release of UV): a) the VOC was 'accidentally' resized to a dynamic file (which isn't recommended) b) the VOC was very badly sized (the VOC contained a LOT of unused and unused/redundant records) Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Logan, David (SST - Adelaide) Sent: Wednesday, April 28, 2004 12:05 PM To: U2 List Subject: VOC corruption Hi Folks, Twice in the past month I have had a major server, with a business critical system, come to a halt with corruption of the VOC file. The first incident was tracked back to the possibility of errors on the SAN. Hardware was replaced and the file has been resized (I assume by this it has also been moved to a different area on the disk or disks) The following incident has no hardware indications in any log thus making it a little hard to trace where the issue occurred. The customer is, understandably, concerned this may happen again as unfortunately both incidents have had a major impact on their business. I am curious to find if any other sites have had a similar issue. Both incidents were backward link errors in the same items. As noted above, the file was resized between incidents and I assume is now in a different area on the SAN. I have found nothing to date in any log on the system. Any suggestions are welcome. Compaq Tru64 UNIX V5.1A (Rev. 1885); Thu Feb 20 14:06:32 EST 2003 UniVerse 10.0.8 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: ODBC Universe (Unix) to MS Access
Hervé On their Web front page, there is a announcement Progress Software Acquires DataDirect Technologies and links, including this one: http://phx.corporate-ir.net/phoenix.zhtml?c=86919p=IROL-NRTextt=Regularid =480278 Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Herve Balestrieri Sent: Tuesday, April 27, 2004 8:18 PM To: [EMAIL PROTECTED] Subject: RE: ODBC Universe (Unix) to MS Access David, Looking in DataDirect history from their web site at page : http://www.datadirect.com/aboutus/history/index.ssp shows that the company is still an independant company, and has not been purchased by Progress Software. Though, as quoted in their Strategic Partnership at page : http://www.datadirect.com/aboutus/strategicpart/index.ssp they demonstrate that many database and database management solutions vendors such as Progress Software and IBM (for Websphere and Websphere MQ) are embedding the DataDirect products into their products. The interesting point is that they are the ONLY licensed by Microsoft to have access to the source code and developments Microsoft does around ODBC, so they can port to UNIX and Linux the ODBC drivers developped by Microsoft. Hervé BALESTRIERI Support Technique Avancé - IBM Data Management - Produits U2 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Productivity metrics
Ah, yes...one of those reguar ...let's go around in circles and chase our tails debates...again! ;-) It must be Friday! Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bob Dubery Sent: Thursday, April 15, 2004 3:43 PM To: U2 Users Discussion List Subject: Re: Productivity metrics It is complex topic and more than a bit off-topic for this forum...also a very very dry subject. *Yawn* ;-) I'm not wanting to discuss the actual metric. We're having the regular debate about should we keep going with UV and if not what should we consider. One of the strengths of MV platforms has always been that they allow programmers to develop quickly. I'm hoping to be able to quantify that rather than give management the benefit of a gut feel. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to display a heading with a SELECT statement?
It's also in the online help... HELP FORCE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 3:34 PM To: [EMAIL PROTECTED] Subject: RE: How to display a heading with a SELECT statement? It does work with UV. I found it in the User Reference pdf on page 1-50: Use in any RetrieVe sentence to force the display of column headings and headers when no records are selected. AdrianW -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Objectcall headache...
Isn't InterCall available for UD? It's supposedly the underlying interface to UV for UO and UOJ. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ken Wallis I could be way off here, but I strongly suspect that ObjectCall has one important feature that these guys make use of that UniObjects gets nowhere near to - it runs on UNIX. Isn't InterCall available for UD? It's supposedly the underlying interface to UV for UO and UOJ. Regards, David -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Objectcall headache...
Ken Wallis wrote: InterCall definitely is available for UD. In my earlier post I think I erroneously called it UniCall. I do not believe that InterCall is the underlying interface for UO or UOJ. Those are based on UCI AFAIK. There is no UNIX client piece for UCI that I know of. Last time I looked, InterCall did not seem to plug into UCI at all. Ken, Well, we've been using UCI on Solaris and HP-UX for a number of years, so it is definitively available. InterCall is the UV version of the old INFORMATION Calling Interface (ICI) transmuted/ported over to UNIX and Windoze. It has direct equivalents to BASIC functions and statements. UCI does not. UCI being ODBC compliant API, I doubt it has any relationship to UO or UOJ. But it is definitive the first cousin to UV/ODBC and UniOLEDB. ;-) Regards, David -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Objectcall headache...
Ken Wallis wrote: Hona, David S wrote: Well, we've been using UCI on Solaris and HP-UX for a number of years, so it is definitively available. Sorry David, can you just confirm that for me? You have client 'C' or other language programs running on Solaris and HP-UX which use UCI as the API which allows them to connect into UniVerse on the same or another box? This is outside of UOJ - a direct interface to UCI (not BCI) that is available for UNIX platforms? Yes, I can confirm - we have two live client 'C' applications on Solaris and HP-UX servers - utilising the IBM UniCall Interface (UCI) library, to interface to another Solaris host server (where the UV DBMS resides). The interface works quite well, albeit with a couple quirks. :-) Regards, David -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Pro-4
TNT Australia was/is a big users of Pro-IV under MVS, I believe. http://www.proiv.com/p4web/home/index.xsp Sorry, don't know of any Pro-IV gurus. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Taylor Sent: Thursday, April 08, 2004 1:16 PM To: U2 Users Discussion List Subject: Re: Pro-4 Barry, Try contacting: www.northgate-is.com Rgds, Dave Dave Taylor Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (F) 310-377-3550 www.sysmarkinfo.com - Original Message - From: Barry Brooks [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 6:53 PM Subject: Pro-4 Hi all I'm looking for someone who maybe be able to assist with support of a customer using PRO-4 (ex McDonald Douglas ALL) I think. Support will be required in Sydney, Australia. Can anyone help ? Thanks ... Barry Brooks -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Unidata ODBC - Suborutine call form dictionary.
Does your subroutine have any dependencies? COMMON variables? Such previously open files, with the file variables stored in COMMON, etc., etc. If it does, you need to either remove these dependencies or work around them, some how...we've went through a similar exercise as yourself. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of kafsat taiyus Sent: Monday, April 05, 2004 4:16 PM To: 'U2 Users Discussion List' Subject: Unidata ODBC - Suborutine call form dictionary. Hi, We have published a Unidata File through ODBC view. One of the dictionaries published uses subroutine call to get data. The dictionary using subroutine call, does not work from ODBC, the rest of the dictionaries work fine. Is there anything we can do to fix it? Regards Kafsat -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Writing a RPC Service
This all sounds like an overkill. If you didn't want users / developers to do this, why would you want them to have access to the said server? I'm sure there is more to this, no? Furthermore, it would had overhead to the interface. Patching or intercepting calls to the UniRPC or servers it starts-up would be subject to breaking everytime IBM improved these interfaces. ;-) On the other hand, some sort of proxy-server/fire-wall software with packet sniffing (if such a beast exists) capabilities may work. Then again...overhead and likely to be broken by IBM, some time in the future. Perhaps he could consider turning all his accounts (or the ones he is most concerned about), into SQL Schemas (or just the files into SQL Tables)? Oh, of course maintaining SQL security on those isn't easy. But if they're serious about security, then you can't get more low-level or a per-user basis than that, at the UV database-level. Never tried it myself, but it could be a better and more economical solution. Next option, but don't bet on it coming soon...ask IBM to add this feature, to a future version of UV?!?! Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael McRae Sent: Friday, March 26, 2004 5:30 PM To: [EMAIL PROTECTED] Subject: Writing a RPC Service A customer has asked how he could implement some stringent security on the 'unirpc' services. In particular, he wants to only allow certain 'Requests' (like the 'Subroutine' method, etc.) from any users out there writing UniVerse Objects front-ends. To me, this means he wants unirpc to fire off uvserver when requested by UniObjects, but to have uvserver only forward on his allowed Methods (and no other). This would keep developers from writing code that could .Read, .Write, .Delete, etc, and force them to obey his security standards. 1) The first option I can think is to 'intercept' the uvserver executable. Has anyone any experience with writing their own Services for unirpc? 2) Next, how about distributing a cut-down version of the DLL (or is it OCX?) that his users will bind into their app? Hoping there's a chance... Michael McRae -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: SQL Server , UniOLEDB subtables
Gerry, Enter the values stated, separated by spaces, I believe. We're not having problems with our UCI connections, so have never needed to debug them. It's a new feature, so perhaps it doesn't actually work as documented! Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of gerry simpson Sent: Tuesday, March 09, 2004 10:52 PM To: U2 Users Discussion List Subject: Re: SQL Server , UniOLEDB subtables Thanks David the docs 'explain' how to enable server side uci logging via the UVHOME/serverdebug file this file doesn not currently exist and no format beyond 'column' values is given. do you know what the format of this file is ? what delimits a column , space , comma , tab , colon ? i've tried all 4 but have yet to see a debug log file appear. do we have to restart uci/uv to have changes take effect ? gerry - Original Message - From: Hona, David S [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 2:26 AM Subject: RE: SQL Server , UniOLEDB subtables I suggest you read-up on how to enable the UCI logging feature. As UniOLEDB uses UCI to communicate with UV. See 'Administrative Supplement for Client APIs' pages 3-21 and 3-22. Of course, this will just help with issues at the UV end. Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of gerry simpson Sent: Tuesday, March 09, 2004 5:38 AM To: [EMAIL PROTECTED] Subject: SQL Server , UniOLEDB subtables we have set up universe 10 in SQL Server 2K as a linked database via UniOLEDB. we have a test file set up that consists of 2 single valued fields 2 multi valued fields at the universe command prompt we can access both the table and the virtual table for the multi values : SELECT * FROM TEST.TAB ; [snip] any ideas ? does universe keep any type of log for oleDB access - i can't find one to see if the request is even getting to universe. gerry -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Change prompt?
Just a minor correction. Provided you have set your terminal type to a matching entry in the SYS.TERMINALS file, the correct keybindings will be mapped. For example, if your terminal type is set to vt220, this load the VT220.IKBIND from SYS.TERMINALS. This is the only one I have tested. Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S Sent: Tuesday, March 09, 2004 10:19 AM To: 'U2 Users Discussion List' Subject: RE: [UV] Change prompt? In UV 10.0.x and above (IIRC), the COMMAND.EDITOR was ported from Prime INFORMATION/PIOpen (albeit with more than a few bugs!). This command allows you to change the TCL prompt with a character string of your choice... COMMAND.EDITOR ON ALL MyAccount MyAccount COMMAND.EDITOR Allows you to use function keys (like cursor keys) to edit not your command-line (TCL), but also in BASIC programs (ie. at INPUT statements/prompts). It is also good for new users who keep press all those functions keys that do nothing except insert escape sequences everywhere! :-) Unfortunately, it doesn't seem to have implement all the nice features of the PI version and the keyboard mapping only seems to support fundamental mode (EMACS-style control-keys). Oh, well - you can't have everything! Regards David -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: SQL Server , UniOLEDB subtables
I suggest you read-up on how to enable the UCI logging feature. As UniOLEDB uses UCI to communicate with UV. See 'Administrative Supplement for Client APIs' pages 3-21 and 3-22. Of course, this will just help with issues at the UV end. Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of gerry simpson Sent: Tuesday, March 09, 2004 5:38 AM To: [EMAIL PROTECTED] Subject: SQL Server , UniOLEDB subtables we have set up universe 10 in SQL Server 2K as a linked database via UniOLEDB. we have a test file set up that consists of 2 single valued fields 2 multi valued fields at the universe command prompt we can access both the table and the virtual table for the multi values : SELECT * FROM TEST.TAB ; [snip] any ideas ? does universe keep any type of log for oleDB access - i can't find one to see if the request is even getting to universe. gerry -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Ever wondered how something works...
My VOC doesn't have these entries you mention...nor does the UV Account VOC (always a good place to check for such things - or the NEWACC file). However, looks like your application once resided on a Prime Computer, under PRIMOS and using Prime INFORMATION. L and LD are 'list directory' PRIMOS operating system commands. The VOC entry you showed was how you executed the commands from Prime INFORMATION PERFORM prompt (TCL). I believe field 3 PR indicated a PRIMOS command under PI. What you're seeing is a side-effect, rather than a 'feature' of UV TCL. Of course, there is no reason why you can clone 'L' from 'CLEARSELECT'. ;-) Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik Sent: Thursday, March 04, 2004 1:34 PM To: U2 list (E-mail) Subject: [UV] Ever wondered how something works... One day, I stumbled across an interesting behavior; at TCL, if I type 'L', it results in my current SELECT list being cleared. You get an error message, but it does not seem to hurt anything. This is great, because I hate typing in CLEARSELECT. But ever since, I've been wondering what it's really doing. Turns out that 'L' is one of only two similar VOC entries, the other being 'LD'. It looks like this: 0001: V 0002: L 0003: PR The error message you get reads: Unable to create new process. Will try again. Create Process failed (2). This is on NT. IIRC, on unix the message is different. Anybody know what this is doing, or if it is safe? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse 10 :Network writes not allowed within a transacton.
Do you have UV/Net installed on the remote server? Or are you using NFS? Apparently, you can't write to remote 'recoverable' (via UV/Net) files, during a transaction. I can't see any other restrictions, regarding UV/Net accessible files. Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ang Suan Yong Subject: UniVerse 10 :Network writes not allowed within a transacton. Dear U2 Users, Is anyone having idea regarding the uniVerse 10 when apply the Begin/End Transaction, it do not allow to write to the remote file. Once execute the program , it prompt the belowing messages Network writes not allowed within a transacton. Is it the security of the Database ? For eg , From Server A , having a program as below to access the remote file of Server B ( ie ASY.FV ) which is code within the Begin / End Transaction ... [snip] Error message is as follow FATAL: Network writes not allowed within a transacton. rolling back uncommitted transactions begun within this execution environment. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Variable never assigned a value warning
Actually Bill, PI/open and Prime INFORMATION (last couple of releases) had meaningful run-time and compile-time error/warning messages. Very similar to your examples with the variable/constant names. The online help also gave you more info for the error code that it displayed (sometimes useful :-)). Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. Sent: Thursday, March 04, 2004 5:41 AM To: U2 Users Discussion List Subject: RE: [UV] Variable never assigned a value warning Marco: A useful alternative, which noone has ever fixed in over 25 years, is the message: [B10] in program MyProgram, Line 106: Variable has not been assigned a value; zero used. or [B10] in program MyProgram, Line 106: Nonnumeric where numeric required; zero used. Why in the world hasn't it been fixed to display: [B10] in program MyProgram, Line 106: InvoiceNo has not been assigned a value; zero used. or [B10] in program MyProgram, Line 106: InvoiceNo = A; Nonnumeric where numeric required; zero used. Stupid questions for the exasperated business developer? Bill -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Wintegrate xterm or Linux emulation
xterm emulates a VT220, well it does for Hummingbird's Exceed X Emulator, which I use (although, not for U2 stuff). I guess your application has hardcoding for this Wyse 60 emulation? Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Adrian Merrall Sent: Tuesday, February 24, 2004 10:31 AM To: U2 Users Discussion List Subject: RE: Wintegrate xterm or Linux emulation Doesn't an xterm by default emulate vt? Not sure. I will compare the infocmp output on the two and see. And what are you trying to do? I don't understand the question ... For various historical reasons, we are currently using a hacked version of the wyse60 emulation. This works OK with our U2 app but fails on any other app that properly uses terminfo. We could hack the terminfo as well but of course the correct thing to do is get our use of eumlations right. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: SQL with UniObject
Your SQL SELECT query is invalid. FORM is a typo and should be FROM, also you haven't specified any column names. Fix those two problems and you should be in business. SELECT valid-column-name(s) TO SLIST select-list-number FROM table-name ; I suggest you always test your SQL queries from TCL first. If it won't work from TCL, it isn't going to work from UniObjects. If you're unfamilar with UV/SQL, you should refer to the UV SQL Reference Guide. It details the correct syntax. Manuals are online, here: http://www-306.ibm.com/software/data/u2/pubs/library/ Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Cesar Riba Sent: Tuesday, February 24, 2004 4:52 AM To: 'U2 Users Discussion List' Subject: RE: SQL with UniObject Hello, Your code is ok, but the SQL Command SELECT TO SLIST 0 FORM CUSTOMERS;, isn't generate a selectlist active. What is that ocurr?. This command don't functio from VB. Thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: COUNT modifying unix timestamp
You don't mention the file type, but I am assuming it is a dynamic file. If it is, this is normal. I recall the first release of reliable dynamic files had the feature of disallowing access to users without 'read and write' permission...which wasn't actually documented anywhere...ouch! I think you will find 'LIST' and other 'read-only' commands has the same effect. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Eves, David Sent: Tuesday, February 17, 2004 9:40 AM To: U2 Users Discussion List Subject: COUNT modifying unix timestamp We have a client running UV 10.0.16 on HPUX 11i who has noted that a Universe COUNT will modify the unix timestamp of a file. Has this always been the case? Why does a supposedly read-only operation like COUNT modify the timestamp but others such as LIST, SORT, etc. don't? Cheers, David Eves -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniOLEDB Threading issue
Nick, We use UV with talking Oracle (using UCI). We're mainly pushing the data from the Oracle end (trigger driven). In another interface to a Oracle-based application, we've got a Tuxedo middleware interface. Yet, again - mainly one-way traffic (from the Oracle end). I know there is a limitation in UV triggers, that you can't do an SQLConnect, etc (Using the SQL Basic Call Interface -BCI). UD Triggers may have a similar limitation, perhaps not. What platform/OS are you on? Have you looked at UniObjects for Java and the like? Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Nick Southwell Sent: Thursday, February 12, 2004 11:23 PM To: U2 Users Discussion List Subject: RE: UniOLEDB Threading issue Thanks David, I suppose we assumed as many would that an OLEDB driver would handle concurrent requests especially when the documentation talks about UniOLEDB's support for free threading. Frustrating as hell, looks like we will move to a SQL Server caching solution. I have the theory of bidirectional sync in my head, triggers from SQL populating Unidata and I'm thinking about triggers from Unidata populating a control table which SQL polls. Not sure if the Unidata - SQL can be done in a more efficient manner. Funny enough the first response from IBM was to use their wonderful redback product instead. Thanks Nick -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Secondary Indices on Distributed Files
There's a few postings on this very topic in the archives, such as this from Glenn Herbert... http://www.indexinfocus.com/dl/u2list/200106/15105.html -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 7:37 AM To: [EMAIL PROTECTED] Subject: Re: Secondary Indices on Distributed Files For some strange reason, the DICT of each Part File needed to contain copies of the I-Types from the Distributed File's DICT in order for CREATE.INDEX to work correctly. Next question... To avoid having to copy DICT items to all the Part Files each time a change is made, I updated the VOC pointer of each Part File to look at the DICT for the Distributed File. This seemed to work fine for the CREATE.INDEX, and each INDEX.000 record within each of the I_files (one for each Part File) has correct index information for the records within it's part file. From a Distributed File perspective, does anyone see a problem with changing the DICT pointers for each Part File to look at the DICT of the Distributed File? Each Part File belongs to only this one Distributed File. If not, then how about the Indices themselves when combined with Distributed Files? Would each Part File not using it's own DICT cause a problem? Thanks! -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: uvsql
Copying/manipulating UV dynamic files using operating system commands is asking for trouble. Unless you're very careful... A) Check the original dynamic file isn't being updated or isn't open - whilst you were doing the copy. B) Check the target pathname, that the file doesn't exist and isn't open or being updated. I have seen your problem happen, where the destination dynamic files already existed. This causes a mess, as the T30FILE table, still has header file details for the original file and not the one you just overwrote. Hence, UV is very confused at the location or status of the file. You can view open dynamic files, via the UV supplied command smat -d. Where ever possible, I prefer to have UV shutdown, before manipulating dynamic files with OS commands. Otherwise, do so at your own risk! Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Barry Rogen Sent: Saturday, February 07, 2004 12:00 AM To: [EMAIL PROTECTED] Subject: uvsql Question... I have a file, my live ORDER (type 30) file. Via unix, I copy this file to my test account - copy is fine, all records there - no problem If I take that same file, and move it to my uvsql account, all I get is a fraction of the file. I have tried this twice and got same results. Any ideas why this occurs and how I can get this file into the uvsql directory/account intact ? All comments appreciated, -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UCI Error
Ah, forgot to ask what your uvodbc.config (or is called uci.config in UV 10.x?) file looks like on the client side (your Oracle server). On one of our client servers the uvodbc.config has this section at the end of the file... these parameters are documented in the UCI manual (somewhere). [UNIVERSE] MAXFETCHBUFF = 32768 MAXFETCHCOLS = 1000 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Sidhu Sent: Wednesday, February 04, 2004 5:04 AM To: 'U2 Users Discussion List' Subject: RE: UCI Error UV version? UniVerse version - 10.0.6 OS version? UniVerse Box OS - HP/UX 11.0 What is the different server? Oracle Box OS - HP/UX 11.0 Does this query complete from the TCL prompt on the UV server? YES -Original Message- From: Hona, David S [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 9:32 PM To: 'U2 Users Discussion List' Subject: RE: UCI Error UV version? OS version? What is the different server? Does this query complete from the TCL prompt on the UV server? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Sidhu Sent: Tuesday, February 03, 2004 10:11 AM To: 'U2 Users Discussion List' Subject: RE: UCI Error Does anyone know if there is some time out variable in Universe that would cause this or maybe something that kicks my connection after a certain time (only a couple minutes) or kicks me due to memory faults? I'm connecting from a different Server to the Universe Server. I've never worked with Universe before so anything would help, Thanks, Dave -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 3:03 PM To: U2 Users Discussion List Subject: RE: UCI Error Hi David, The docs say IM985 Error in RPC interface I think I would be checking the network and/or ensuring your rpc daemon is still running. The error 81002 is a universe system error ED SYS.MESSAGE 081002 The file SYS.MESSAGE is read-only and cannot be updated. 2 lines long. : P 0001: unirpc: No Connection 0002: Bottom at line 2. : EX Hope this helps Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Sidhu Sent: Tuesday, 3 February 2004 9:23 AM To: 'U2 Users Discussion List' Subject: UCI Error Anyone know what this error is when using UCI? I got it after running a query numerous times with different id's. I checked the sql statement and the ID both are correct. Just after a four thousand iterations I get this error. ERROR!! SQLExecDirect Died in SQLExecDirect with SQLSTATE IM985 Native error: 81002 [IBM][SQL Client][RPC] error code = 81002 The Query is simply: SELECT A.MEM.ID, A.REG.BEG.DT, A.REG.END.DT, A.GROUP FROM MEM.REG.HIST A WHERE A.MEM.ID = 'X*01'; Where the X's is the id number. Thanks, Dave ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UCI Error
UV version? OS version? What is the different server? Does this query complete from the TCL prompt on the UV server? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Sidhu Sent: Tuesday, February 03, 2004 10:11 AM To: 'U2 Users Discussion List' Subject: RE: UCI Error Does anyone know if there is some time out variable in Universe that would cause this or maybe something that kicks my connection after a certain time (only a couple minutes) or kicks me due to memory faults? I'm connecting from a different Server to the Universe Server. I've never worked with Universe before so anything would help, Thanks, Dave -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 3:03 PM To: U2 Users Discussion List Subject: RE: UCI Error Hi David, The docs say IM985 Error in RPC interface I think I would be checking the network and/or ensuring your rpc daemon is still running. The error 81002 is a universe system error ED SYS.MESSAGE 081002 The file SYS.MESSAGE is read-only and cannot be updated. 2 lines long. : P 0001: unirpc: No Connection 0002: Bottom at line 2. : EX Hope this helps Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Sidhu Sent: Tuesday, 3 February 2004 9:23 AM To: 'U2 Users Discussion List' Subject: UCI Error Anyone know what this error is when using UCI? I got it after running a query numerous times with different id's. I checked the sql statement and the ID both are correct. Just after a four thousand iterations I get this error. ERROR!! SQLExecDirect Died in SQLExecDirect with SQLSTATE IM985 Native error: 81002 [IBM][SQL Client][RPC] error code = 81002 The Query is simply: SELECT A.MEM.ID, A.REG.BEG.DT, A.REG.END.DT, A.GROUP FROM MEM.REG.HIST A WHERE A.MEM.ID = 'X*01'; Where the X's is the id number. Thanks, Dave ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users