Re: [U2] Null character causes odd UV behaviour

Indeed. I'd call IBM or my VAR if I were you. And thanks for the mention! Laure Hansen, City of Redwood City I.T. Tel: 650-780-7087 Cell: 650-207-3235 - Original Message - From: u2-users-boun...@listserver.u2ug.org To: U2 Users List Sent: Wed Sep 16 17:54:12 2009 Subject: Re: [U2] Null

Re: [U2] Help with encryption

I keep getting binary data displayed, despite the OCONV(RESULT,'MX') Anyone have an idea how to turn the RESULT into a string of Hex characters? Replies are much appreciated, thanks. IT-Laure Hansen wrote: > > Does anyone know how to cause MD5 hashing in Universe? UV 10.2.3 on

Re: [U2] Universe just quits

Suggestions: 1. Turn COMO ON before starting the job. This may catch something helpful. 2. Look at the UV error log to try and locate something at the time of the failure 3. How large are your text files? There may be a memory fault above a certain size (we get around that by using OPENSEQ/READSE

Re: [U2] Send output from query to text file

Add COUNT.SUP, COL.SUP, HDR.SUP to suppress record count at the bottom, column headers and report header. note that if longer than 32K lines there will be a char(12) (page break) inserted. Excel does not handle that as a page break. Laure Hansen, City of Redwood City I.T. Tel: 650-780-7087 Cell:

RE: [U2]

EXECUTE "SELECT DICT (This.File) WITH F2 = (This.Field.Nbr)" CAPTURING OUTPUT IF @SELECTED <= 0 THEN you have a problem READNEXT DICT.ID ELSE (get out) EXECUTE "CLEARSELECT" ; Get out (since you're happy with the 1st hit) Laure Hansen, City of Redwood City - Information Technology 1017 Middlefiel

RE: [U2] Help with encryption

on do what you're looking for? - Josh -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of IT-Laure Hansen Sent: Tuesday, May 12, 2009 5:17 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Help with encrypti

RE: [U2] Help with encryption

...@listserver.u2ug.org] On Behalf Of Dave Greer Sent: Tuesday, May 12, 2009 12:43 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with encryption I'm only aware of RC5 and some des. See ENCRYPT function in Basic Ref. -Original Message- From: IT-Laure Hansen [mailto

[U2] Help with encryption

Does anyone know how to cause MD5 hashing in Universe? UV 10.2.3 on Win2003 server. I am hoping for a Basic command that I can run on a desired piece of data. Reading documentation so far hasn't helped, am I wanting to do something that is not available to me? Thanks in advance! Laure Hansen, Cit

RE: [U2] UV resize error

In my experience, anything that is accessing the file(s) in question - and not just Universe processes - can cause the error. If the file is opened by any other process, that would be sufficient for the exclusive use check to fail. So things to look out for extend beyond just Universe. This could i

RE: [U2] Uniobjects

How long do you need it to remain open? There is a data file that contains the default timeout parameter for this in Universe (not sure at all about UniData). I can send you the info on what to change to extend the timeout, if it seems like it would solve things for you. Thanks, Laure Hansen,

[U2] UniObjects connection timeouts?

UV 10.2.3 on Windows 2003 server. UniObjects calls in Windows Forms (.Net 2.0) using VB.Net. UniObjects are supposed to have a default no-time-out. I am not modifying any properties or parameters, and per UniObjects developers doc: Timeout This property specifies the length of the timeout for a

RE: [U2] Ssh connections to Universe DB?

n SSH into the WinSSHD server which forwards our telnet communication to the UD dbms server. Pretty seemless, but not the IBM way with SSL. I think WinSSHD is about $100 USD. HTH, Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen

[U2] Ssh connections to Universe DB?

I apologize in advance if this has already been covered, but a quick search did not give me what I need (quickly - the inevitable quantifier); that, and a lost battle with the IBM knowledge bases access controls: Universe 10.2.3 on Windows server 2003. Are ssh connections possible? What would it

RE: [U2] [UV] Editing Subsequent Value Marks

Either should work. When you are editing the record, type ^ (shift+6) alone then press (Enter) to reveal the hidden or mysterious codes. It may be that what looks like ^253^253 is not truly that. Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, C

RE: [U2] RE: English phrases

You can use the underscore at the end of attributes 2 to 9 to indicate continuation on Universe. Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 [EMAIL PROTECTED] o
 Please thin

RE: [U2] Universe scaling on Windows

Hi Susan, UV 10.2.3 on Windows 2003 with 110 users. Runs very well. Contact me off list if you'd like specifics. Thanks, Laure Hansen, City of Redwood City Information Technology 1017 Middlefield Road Redwood City, CA 94063 Tel 650-780-7087 Cell 650-207-3235 Fax 650-556-9204 [EMAIL PROTECTED]

RE: [U2] locking question

Is the rule of thumb about the value of GSEMNUM valid for other systems? We are running UV 10.2.3 on Win2003 server with a 110 UV user license. Our VAR set GSEMNUM to 97. Is this likely to cause any problems? I hasten to say we have no locking issues on our system. Thanks, Laure Hansen, City of

RE: [U2] Friday query logic

Use "WHEN" instead of "WITH" on MV fields? Laure Hansen, City of Redwood City Information Technology 1017 Middlefield Road Redwood City, CA 94063 Tel 650-780-7087 Cell 650-207-3235 Fax 650-556-9204 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

RE: [U2] RE: U2 Users Digest V1 #2120

me an email and I'll send you a word document that provides greater details. Tom RATEX Business Solutions Plymouth Meeting, PA ---------- Date: Mon, 17 Mar 2008 10:58:54 -0700 From: "IT-Laure Hansen" <[EMAIL PROTECTED]&

RE: [U2] Windows 2003 server security on new users

ibe? I'm wondering if these profiles shouldn't be maintained in another directory like "E:\UVProfiles\%username%". Bill >-Original Message----- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen >Sent: Monday, March 17, 2

[U2] Windows 2003 server security on new users

Universe 10.2 on Win2003 server SP2 (but was happening before SP2 as well): our set-up requires that users get created with the path to a valid Universe account in the user's profile tab. As soon as I do this, using the admin login on the server, the original permissions on the account are removed

RE: [U2] [UB] Beep Error

CRT CHAR(7) Laure Hansen, City of Redwood City Information Technology 1017 Middlefield Road Redwood City, CA 94063 Tel 650-780-7087 Cell 650-207-3235 Fax 650-556-9204 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent:

RE: [U2] Excel downloads

Comma delimited fields are always a bit of an issue in this case. The correct way to program CSVs is to place quotes around the fields, to account for just this - but then: what if you have quotes in your fields? Tab is usually a "safer" delimiter for the simple reason that it is rarely stored as s

[U2] Thanks to everyone for replies to "Excel download" post

I have quite a few options to look into. Thanks again to everyone. Laure Hansen, City of Redwood City Information Technology 1017 Middlefield Road Redwood City, CA 94063 Tel 650-780-7087 Cell 650-207-3235 Fax 650-556-9204 [EMAIL PROTECTED] --- u2-users mailing list u

RE: [U2] Excel downloads

Hi Louie, You are correct, it does - however I am dealing among others with a set of files that contain about 85000 individual records: too much for Excel in the first place, and also, updating the MITS data source takes simply too much time, especially when adding break/sort fields. A simple Univ

RE: [U2] Excel downloads

al Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen Sent: Tuesday, February 12, 2008 12:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] Excel downloads Hello, We are looking for a simple way to drop aggregate totals type reports out of Universe into

RE: [U2] Excel downloads

Sent: Tuesday, February 12, 2008 11:42 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Excel downloads > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure > Hansen > Sent: Tuesday, February 12, 2008 9:10 AM > To: u2-users@l

[U2] Excel downloads

Hello, We are looking for a simple way to drop aggregate totals type reports out of Universe into Excel. Our users are using AccuTerm and we also have MITS Reports installed. But, neither one does the trick for summarized reports that use the DET-SUP option. Having the detail and forcing the users

[U2] RBO properties lose their values (RedBack 4.3)

Hello, Starting a few days ago, if user reports are to be trusted, we've been encountering a mysterious on-and-off loss of values in some RBO properties. The issue seems to be, simply, that the GetProperty returns a blank when a value should be gotten. I cannot find evidence of loss of connectivit

RE: [U2] LIST DICT F11

Are you on Universe? If so, the F1 etc records need to exist in VOC (not DICT VOC - just VOC) to be accessible in all list commands. Laure Hansen, City of Redwood City Information Technology 1017 Middlefield Road Redwood City, CA 94063 Tel 650-780-7087 Fax 650-556-9204 [EMAIL PROTECTED] -O

RE: [U2] RE: Get a grip - was ads - was U2 University Last

I agree as well. Am a little more on the fence when it comes to rules: yes, some basic ones are needed; no, not that many. But where you draw the line is likely to become an almost personal matter. The present flurry of e-mails on the subject is in response to what, considering my experience of the

RE: [U2] [u2] : Cleaner Case Statement

Use Case Ans matches "2]B", using the MV separator between the 2 and the B Laure Hansen, City of Redwood City Information Technology 1017 Middlefield Road Redwood City, CA 94063 Tel 650-780-7087 Fax 650-556-9204 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: [U2] [Fwd: UniObjects Disconnect Issue]

Sorry: we're a Universe shop here and I don't know Unidata at all. Laure Hansen, City of Redwood City Information Technology 1017 Middlefield Road Redwood City, CA 94063 Tel 650-780-7087 Fax 650-556-9204 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECT

RE: [AD] [U2] Basic developments "reverse engineering" tool ?

I have been trying to track Joe Toledo and/or someone at his company Toledo Inc. (who used to distribute SoftWhere) but all e-mails have come back undeliverable. The company's web site is also down. That's just too bad. Laure Hansen, City of Redwood City Information Technology 1017 Middlefield Ro

RE: [U2] Reverse calculating taxes

Since you are talking calculation of taxes, I recommend you check with the tax agencies: feds, state etc. Or at the very least with a tax accountant. The U2 group can give you coding tips, but I don't think it has the authority to give you tax tips. I do payroll programming, including tax calculat

[U2] New user on Win2003/UV 10.2.3

I just got the scare of my life: create a new active directory user on my brand new server, then started getting calls from users unable to use options in one account. After some research, it turns out the creation of the new user caused the permission of the account assigned as the user's home di

RE: [U2] Universe on Windows login setup

No, not necessarily. I have my answers, no need to spend more efforts on this. Thanks very much to all who responded. Laure Hansen, City of Redwood City Information Technology www.redwoodcity.org 1017 Middlefield Road Redwood City, CA 94063 Tel: 650-780-7087 Fax: 650-556-9204 [EMAIL PROTECTED]

RE: [U2] Universe on Windows login setup

his - for ex. Try www.realvnc.com). Please be aware you may > need > to make adjustments to your firewall(s) to permit this remote access. > In > addition, I have run across issues with VNC not working properly if you > are > using Microsoft Virtual Server (it appears to also use VNC unde

RE: [U2] Universe on Windows login setup

NC under the covers). HTH. Best regards, Jim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen Sent: Tuesday, April 24, 2007 5:11 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe on Windows login setup Hello, A vendor is asking m

[U2] Universe on Windows login setup

Hello, A vendor is asking me to set up a login on our Universe server (Win2003 server/UV 10.2.3) with "direct access to the OS" when logging in via Telnet. Pretty much no matter how I set it up, the login ends up at a TCL prompt. I can't picture the login ending at a DOS prompt considering that Un

RE: [U2] UniVerse I-descriptor Help

Bingo! Perfect. Thanks very much. Laure Hansen, City of Redwood City Information Technology www.redwoodcity.org 1017 Middlefield Road Redwood City, CA 94063 Tel: 650-780-7087 Fax: 650-556-9204 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Beh

RE: Spam:[U2] Universe I-descriptor help

org Subject: Re: Spam:[U2] Universe I-descriptor help INT((CONS / REUSE(UNITS)) + 0.5) - Original Message ----- From: "IT-Laure Hansen" <[EMAIL PROTECTED]> To: Sent: Monday, March 26, 2007 1:00 PM Subject: Spam:[U2] Universe I-descriptor help > Hello, > &g

[U2] Universe I-descriptor help

Hello, I'm trying to avoid having to write a subroutine to, basically, always round up the result of a division between a multi-value field and a single-value one, in an I-descriptor (UV 10.1). My MV field is named CONS, my single value one is names UNITS, the formula is CONS / REUSE(UNITS). The

RE: [U2] UniVerse I-descriptor Help

Oh, duh! Thanks! Laure Hansen, City of Redwood City Information Technology www.redwoodcity.org 1017 Middlefield Road Redwood City, CA 94063 Tel: 650-780-7087 Fax: 650-556-9204 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Norman Mor

RE: [U2] RE: [uv] 10.2

We're running it on a test & dev server and so far are fine - nothing to report. OS is Win2003 server. I'm also curious to read anything about this before we go live. Laure Hansen, City of Redwood City Information Technology www.redwoodcity.org 1017 Middlefield Road Redwood City, CA 94063 Tel: 650

FW: [U2] Uniobjects.net READU Question

[EMAIL PROTECTED] -Original Message- From: IT-Chuck Smith Sent: Thursday, March 01, 2007 1:27 PM To: IT-Laure Hansen Subject: RE: [U2] Uniobjects.net READU Question The pre dot.net uniobjects did not have exceptions (more accurately, the pre dot.net VB did not have exceptions) so you

RE: Spam:RE: [U2] Index Problem

Another possible diagnostic method: Write a VOC that selects on each of the indexes, saves into lists, then selects again with the NO.INDEX clause, and saves that into separate lists. Then, LIST.DIFF between each with and without index selection. Report only if the resulting list is not empty. Or,

RE: [U2] RedBack Scheduler

We are experiencing the exact same problem here with the exact same versions of UV, the OS and RedBack, and we haven't found any information on it. We also are running Universe and IIS on separate servers. RedBack 4.1 is supposed to be extremely stable, and the upgrade to 4.2 is not supposed to br

RE: [U2] What Good Are Associations?

Yes, a lot. It allows to keep associations in sync when you list (with or without a WHEN clause). Laure Hansen, City of Redwood City Information Technology www.redwoodcity.org 1017 Middlefield Road Redwood City, CA 94063 Tel: 650-780-7087 Fax: 650-556-9204 [EMAIL PROTECTED] -Original Messa

RE: [U2] [UV] TEXT box subroutine

I would really like it if all parties could give arguments to support their opinion of it: is it solid? Satisfying to the users? Supported or not on certain platforms? Working best or worst with certain types of programs? etc. I would help me and hopefully others cut through some time and efforts.

[U2] Logout and release license on stuck session?

Universe 10.1.11 on Windows 2003 server: I have a dead session that I cannot log out using MASTER OFF (logged in as administrator, of course). I get no error, however the tool is not doing anything. Same with the GUI tool of UVAdmin. Can someone point me to a way to log the session off and release

[U2] Replication and disaster planning/recovery

Hi! What have you/are you using for data replication across NT Universe servers? Do you have any specific feedback on the replication tool that comes with Universe? Any input on BrightStore's product? How else do you handle disaster planning and recovery? Thanks in advance. Laure Hansen, City of

[U2] Installing UV 10.1 onto Windows 2003 server

Has anyone encountered a problem running Universe 10.1 on Windows 2003 server, besides that identified previously in this group by Mr. Alonso of Quiter Servicios Informaticos (no release of UV user licenses on dropped connections)? There are several scary-sounding documents in the tech notes about

RE: [U2] How release UVCS sessions in Win2003?

Hello, I'm unclear on one point: is the MASTER OFF successful or not? I think this may change the situation. Thanks, Laure Hansen, City of Redwood City Information Technology www.redwoodcity.org 1017 Middlefield Road Redwood City, CA 94063 Tel: 650-780-7087 Fax: 650-556-9204 [EMAIL PROTECTED]

[U2] Secured checks printing solutions

Hello, The City of Redwood City is running its own, custom, legacy financial system on Universe (NT). We are also currently set up with Standard Register and running Linkup v. 5.1 for checks and secured forms design and printing. We would like to explore other solutions, that would hopefully make