Re: [U2] Unclassified Performance, Shared Memory Tuning on a UV /Windows system

2005-01-21 Thread Ray Wurlod
Given that PORT.STATUS can report on ODBC.CONNECTIONS for a particular USER, I would have to assume that that information is in the printer shared memory segment for the user. I don't have access to my UniVerse materials at the moment, as I'm away from home working in a DataStage site.

Re: [U2] Universe account Name/ID

2005-01-21 Thread Ray Wurlod
@WHO is impacted by the IAM command. 0001: PROGRAM VARIABLES 0002: * To test the effect of IAM on @WHO AND @ACCOUNT 0003: PRINT @WHO = : @WHO : , @ACCOUNT = : @ACCOUNT 0004: PERFORM IAM SILLY 0005: PRINT @WHO = : @WHO : , @ACCOUNT = : @ACCOUNT 0006: STOP 0007:

RE: [U2] K = K

2005-01-21 Thread chris . dyson
Doh ! And there I was thinking u2 related to any multi-value/post-relational/pick-derived or whatever it's generically called database. Thanks for the correction. And many thanks for those who pointed out the $OPTIONS EXT. This is a great help to me, not only with REMOVE but also with stuff like

[U2] UV - Error with PAGE statement.

2005-01-21 Thread Carolina Lizama
I have the following error when running a Program on UV 9.6 / AIX 5.1 Program PRINT.CLI.DET: Line 322, Read operation failure. [EBADF] Bad file number A fatal error has occurred in UniVerse. Unable to re-open operating system file TEMP/PRINT.CLI.DET Error code 0 On line line 322, I have the PAGE

Re: [U2] Re: Uniobjects automation error

2005-01-21 Thread brian
Jonathan is right, but I'd suggest going one stage further removed. Creating a reference is version sensitive - it expects a specific version of UniObjects. For safety I would use a CreateObject. Plus this has the advantage that you can use it inside VBScript (which in case anyone doesn't know

RE: [U2] UV - Error with PAGE statement.

2005-01-21 Thread Adrian Matthews
That's the default setting and I'd say is far too low for most systems (ours is currently 750). As a first rough setting you need to work out how many files the average session will have open and set MFILES to that (look at T30FILES as well if you have dynamic files). Search on

[U2] UV-piopen TRANS function

2005-01-21 Thread Andrea Charles
Thanks for all the suggestions. I think I am going to bite the bullet and add the RAISE to all i-descriptors. Think I can come up with a BASIC program to accomplish this. And learned about K=K in the process. IBM's response is that this is a documented difference between UniVerse and PIopen and

Re: [U2] UV-piopen TRANS function

2005-01-21 Thread Allen Egerton
From: Andrea Charles [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, January 21, 2005 8:31 AM Subject: [U2] UV-piopen TRANS function Thanks for all the suggestions. I think I am going to bite the bullet and add the RAISE to all i-descriptors. Think I can come up with a BASIC

RE: [U2] UV-piopen TRANS function

2005-01-21 Thread Tim Franklin
Do you have sub values in your data? if not it maybe useful to write a program to select each file and execute all I-Descriptors that use the TRANS function on each record looking for @SVM in the result. This may take some time to run but will ensure all TRANS have been converted. -Original

[U2] Unidata Training

2005-01-21 Thread Jimmy Dixon
Greetings one and all: I have to admit that I have been lurking around the list for the past several months, in an effort to see what the list is all about. I am new to the Unidata arena, and from what I am seeing, there is a lot to be learned to use it effectively. Our accounting system is

RE: [U2] UV-piopen TRANS function

2005-01-21 Thread Andrea Charles
I like the idea of a replacement function, unfortunately, the filename is not quoted in the i-desc so using my replacement function for TRANS will not compile. I may be stuck with adding the RAISE. snip If you're going to programmatically change a bunch of dictionaries, you might want to

[U2] UV and Fedora Core 3

2005-01-21 Thread George Gallen
FYI, UV 10 seems to work just fine on FC3. I had a test machine running on FC2, and upgraded that machine to FC3. So far it seems to be running fine. The UV version I loaded on FC2 was made to run on Redhat 7.2 / 8.0, which also loaded on RH 9.0 George George Gallen Senior Programmer/Analyst

RE: [U2] Unidata Training

2005-01-21 Thread Marc Harbeson
IBM offers training. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jimmy Dixon Sent: Friday, January 21, 2005 9:48 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata Training Greetings one and all: I have to admit that I have been lurking

RE: [U2] Unidata Training

2005-01-21 Thread Kevin King
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jimmy Dixon I am wondering what type of getting started with Unidata information is out there. If y'all have suggestions on resources that I can learn Unibasic that would be great. Precision Solutions (my

RE: [U2] Unidata Training

2005-01-21 Thread Ed Clark
are you already familiar with any other multivalued databases like universe/jbase/d3/pick? If yes, then you can get the undata manuals online at http://www-306.ibm.com/software/data/u2/pubs/library/61unidata/ and go from there If not, check out: pickwiki: http://www.pickwiki.com/cgi-bin/wiki.pl

Re: [U2] [UV] Device Licensing

2005-01-21 Thread Dianne Ackerman
Oh, the uvdls command must be what's going on! I'm on a linux system. Thanks, thanks, thanks! -Dianne Kevin P Lynch wrote: Diane, As stated the uvlictool will show you the list of pids and what ip they are connected with, a pid without an ip/computer name is a pid that is connected from a

Re: [U2] Unidata Training

2005-01-21 Thread Martin Phillips
You do not say where you are so what follows is probably irrelevant. Ladybridge Systems provide a range of on site training for UniVerse and Unidata in the UK. We also deliver IBM's courses at their UK training centre. If this is of interest, visit www.ladybridge.com for details. Martin

Re:[AD] [U2] Wintegrate ML-SEND

2005-01-21 Thread FFT2001
Tony you know as well as the rest of us that [AD] goes into the header. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UV] Time Output Conversion

2005-01-21 Thread FFT2001
In a message dated 1/21/2005 2:31:23 AM Pacific Standard Time, [EMAIL PROTECTED] writes: Nick Cipollina [EMAIL PROTECTED] wrote on 20.01.2005, 19:00:47: Is there an output conversion for time that will include the milliseconds? If I have a time that is 10:35:14 am and there are 35

[U2][UD] - ODBC/VSG

2005-01-21 Thread Chauhan, Savita
We upgraded from Unidata 5.2.27 to 6.0 and now I cannot access my databases through VSG. It gives following error message: SQLSTATE S1001(the manual says this is Memory Allocation failure) SCHEMA_VERSION_CHECK. While on 5.2, I had generated schema for the database. Can someone pls tell me

RE: [U2] UniData ODBC / Prompt for selection criteria

2005-01-21 Thread Amy Cook
Just to let everyone know, this is a bug. It was reported to IBM back in 2002, and it's still not fixed. They now have a new eCase for it, 7477, which is apparently in 'Advanced Tech Support' awaiting prioritization, etc... If this is something you might like to do (a fairly standard request for

RE: [U2] Unidata Training

2005-01-21 Thread Alfke, Colin
Malcolm Bull also has a large number of items that you may find useful. I cut the following out of one of his sigs... Colin Alfke + Books MB-Master Self-Tuition courses for users of Pick MultiValue systems: A

RE: [U2] [UV] Time Output Conversion

2005-01-21 Thread Kevin King
Following this discussion about a special time conversion code, I've been wondering... Are many people writing custom conversion subroutines? You know what I mean, the Uname subroutines? It seems to me that with this we have access to create any conversion we can dream up - no matter how wacky -

RE: [U2] Unidata Training

2005-01-21 Thread Brutzman, Bill
My favorite resource is... The Pick Programming Language: Basic , Malcolm Bull, Chapman + Hall, c.1994, ISBN 0-412-46660-0. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jimmy Dixon Sent: Friday, January 21, 2005 9:48 AM To:

RE: [U2] Unidata Training

2005-01-21 Thread D Averch
We are running a Unidata Programming/Administration course in 3-5 weeks in Denver, well actually Henderson a suburb of Denver. We be happy to have other students. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Friday, January 21,

RE: [U2] UV - Error with PAGE statement.

2005-01-21 Thread Carolina Lizama
Thanks for your suggestion Adrian. It indeed solved my problem. Carol. From: Adrian Matthews [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV - Error with PAGE statement. Date: Fri, 21 Jan 2005 12:50:11 - That's the default setting

[U2] [AD] Employment Opportunity

2005-01-21 Thread Perry Taylor
ZirMed is the preeminent Web-based healthcare transaction services company in the country, as evidenced by our ongoing explosive growth. We are seeking a highly skilled individual to fill a Senior Multi-Value Developer position in our Information Technology Department. This position is a

RE: [U2] [SQL] How to access the current date

2005-01-21 Thread Ray Wurlod
If it's UniVerse all you have to do is to include the I-descriptor name in the @SELECT phrase in the dictionary (or, if you don't have an @SELECT phrase, in the @ phrase). If the file is an SQL table, then it must be that @SELECT phrase. - Original Message - From: Noah Hart [EMAIL

[U2] [UV] Custom Conversion

2005-01-21 Thread Ray Wurlod
I've created a few over the years. One handles casing in punctuated names with exceptions (MacDonald but Machin, ffolkes, etc.). Another generates a number in words. Yet another generates a military format date/time stamp. - Original Message - From: Kevin King [EMAIL PROTECTED] To:

[U2] [UD] i-desc mystery

2005-01-21 Thread Shawn Waldie
This is the LISTing: LIST PAYTODAT PTD.POSITION.ID XPTD.POSITION.ID PTD.GL.NOS PTD.HOURS 16:30:19 Jan 21 2005 1 PAYTODAT.. Position ID... XPTD.P Earnings Acct Hours... 13515*H*076*1 1523PTINST_2 PTINS 10104414705340 14.00 1523PTINST_2

[U2] Universe 10 fnuxi problem

2005-01-21 Thread Jay Falck
I need to move some regular Universe files from a Unix platform (HPUX) to Windows. These files have triggers and fnuxi by itself will not work. I've tried FORMAT.CONV -export on the HPUX box but it indicates the file is not a SQL table. If I just ftp the file to my Windows platform and try fnuxi

RE: [U2] [UD] i-desc mystery

2005-01-21 Thread Stevenson, Charles
Shawn, In your mystery, PTD.POSITION.ID references the _e_n_t_i_r_e_ 75th attribute. It is a dynamic array. It may (or may not) contain value marks. PTD.POSITION.ID[5,5] does a substring extraction, the 5th thru 9th characters of the array, regardless of where or whether there are any value

RE: [U2] [UD] i-desc mystery

2005-01-21 Thread Ray Wurlod
Does UniData have the same MV handling functions as UniVerse? The OP specified [UD] in the subject line. - Original Message - From: Stevenson, Charles [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] i-desc mystery Date: Fri, 21 Jan 2005 21:35:28 -0500 snip

Re: [U2] Universe 10 fnuxi problem

2005-01-21 Thread karlp
quote who=Jay Falck I need to move some regular Universe files from a Unix platform (HPUX) to Windows. These files have triggers and fnuxi by itself will not work. I've tried FORMAT.CONV -export on the HPUX box but it indicates the file is not a SQL table. If I just ftp the file to my Windows