Re: [U2] UniVerse Dictionary question

2014-02-07 Thread Colin Alfke
I got this from him a number of years ago: And thank you for the appreciation of AE! I really worked on that program, determined to get the best of the Pick and Prime Information editors together in one place, plus some innovations of my own, such as the EditValues (EV) command. UniData

Re: [U2] [UD] Who's locking a record

2014-01-28 Thread Colin Alfke
That's what we used to use. It's a little more of a pain as you have to parse through the output to find the correct record - but it should give you need. It's simply list.readu output in an array. Hth Colin -Original Message- From: David A. Green Sent: Tuesday, January 28, 2014 2:19 PM T

Re: [U2] [u2] Pick 7.3 What is this?

2014-01-10 Thread Colin Alfke
http://www3.rocketsoftware.com/rocketd3/support/patches/d3rs.jsp -Original Message- From: Wjhonson Sent: Friday, January 10, 2014 10:58 AM To: u2-users@listserver.u2ug.org Subject: [U2] [u2] Pick 7.3 What is this? On someone's resume I see "Pick 7.3". When I try to google for that, I ge

Re: [U2] Report Writer

2014-01-10 Thread Colin Alfke
We hooked Crystal Reports up to Unidata over 10 years ago - I'm sure it will still work (although there can be a fair bit of setup involved). We just setup an account with ODBC access then pretty much anything will work. Hth Colin -Original Message- From: u2-users-boun...@listserver.u2ug

Re: [U2] Stumped on a WRITE failure

2013-08-16 Thread Colin Alfke
Did you check the udterrorlog? We saw similar issues (although we didn't have an on error clause) when running a scheduled process overnight and it conflicted with the backup. The backup would lock the file at the operating system level and UniData would error out at the write statement (we could

Re: [U2] OPENSEQ

2013-08-05 Thread Colin Alfke
Ummm, if the file doesn't exist then it's *supposed* to take the else clause, when I'm creating new files I use THEN and put the "abort" in there. When you borrowed this code did it have all of the validation? I don't have my error codes handy - but if you let it continue does it let you do the w

Re: [U2] UniData PreStore to change the KEY of a record?

2013-05-28 Thread Colin Alfke
Sure, you should be able to write the record with the new key and then delete the existing record. The trouble comes in making sure another record doesn't already exist with the new key. Hth Colin -Original Message- From: David Wolverton Sent: Tuesday, May 28, 2013 11:48 AM To: 'U2 Users

Re: [U2] Selecting a special character in a SELECT (UV)

2013-05-16 Thread Colin Alfke
With UniData you can use GUIDE to find a character but I'm not sure of an easy way to find it with a select. Maybe by creating the select in basic (so you can put the actual character in the string) and executing it??? Hth Colin -Original Message- From: George Gallen Sent: Thursday, May 1

Re: [U2] select query..

2013-05-15 Thread Colin Alfke
That's what READLIST and WRITELIST are for. I've found writing the list as "MY.LIST000" to be relatively safe, when you read you would have to check for "MY.LIST000", then "MY.LIST001", etc. Sathya - as Mecki said, if you're using the @ID of the file you can do a straight read to check if it's the

Re: [U2] Exporting to Excel after upgrading to MS Excel 2007

2013-04-19 Thread Colin Alfke
This was fixed as of 5.4.2. It uses .TAB as the extension. Not sure what they did about the rename/move problem. -Original Message- From: Colin Alfke Sent: Friday, April 19, 2013 1:26 PM To: 'U2 Users List' Subject: Re: [U2] Exporting to Excel after upgrading to MS Excel 2007

Re: [U2] Exporting to Excel after upgrading to MS Excel 2007

2013-04-19 Thread Colin Alfke
I used the .txt extension (as the file is really a text file). The final DDE macro error is because when it opens the file it uses "compatibility" mode which uses a smaller sheet size than the newer version and the last step SBClient does is to copy the sheet to a new sheet with a different name. E

Re: [U2] Apparent Data Problem

2013-03-21 Thread Colin Alfke
It looks like the file variable is getting hammered. Is the VOC item OK? Are you using RCVR as a variable anyplace else? If you are re-opening the file you may need to close it first. Hth Colin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listse

Re: [U2] unidata env var

2013-03-21 Thread Colin Alfke
Then I'm not going to say anything about the 16384 we used to set it to :) Colin -Original Message- From: Dave Davis Sent: Thursday, March 21, 2013 7:38 AM To: U2 Users List Subject: Re: [U2] unidata env var Uppercase has always worked for me. $VFIELDSIZE and $vfieldsize are distinct va

Re: [U2] Replacements for Old SB?

2013-03-13 Thread Colin Alfke
What about Osmosis? -Original Message- From: Tony Gravagno Sent: Tuesday, March 12, 2013 2:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] Replacements for Old SB? I'm still running across sites that have 1990's versions of SystemBuilder on different DBMS platforms. What's the lates

Re: [U2] Replacements for Old SB?

2013-03-12 Thread Colin Alfke
I'm guessing he meant the decision to stop supporting SB+ on top of D3. We had already migrated most of our customer base to U2 by that point so it didn't hurt us too badly, but even then it seemed like a "cut off your nose to spite your face" type of decision Colin -Original Message-

Re: [U2] SB 5.5

2013-03-12 Thread Colin Alfke
It used to be in the TUSTATE file - not sure if it's changed now or not. It should be buried somewhere in your user account - likely under application data Colin -Original Message- From: Israel, John R. Sent: Tuesday, March 12, 2013 12:53 PM To: U2 Users List Subject: [U2] SB 5.5 OK

Re: [U2] Wally Terhune

2012-12-14 Thread Colin Alfke
Ditto - although I've never actually met you. Suddenly I'm glad that we're down to 1 last UniData customer Good luck and enjoy!!! Colin -Original Message- From: Brian Leach Sent: December 14, 2012 3:02 AM To: 'U2 Users List' Subject: Re: [U2] Wally Terhune Wally You *can't* retire

Re: [U2] Stripping line breaks from InfoTrieve output

2012-12-12 Thread Colin Alfke
When creating the file he would need to use WRITEBLK... :) The "TO" syntax will create an Aix file using the Aix linefeed char (10 or 13 - it's been a while). You will have to then have to join the lines together in the format required. It's whichever you find easiest - or is easier for the next

Re: [U2] SB Client question

2012-12-07 Thread Colin Alfke
Not anything that has happened to me. It may have to do with the terminal emulation you are using. You could try reset defaults under Setup, Keyboard. I`ve also found changing the SBClient terminal type to ANSI and back can also fix some strange problems. Hth Colin -Original Message- Fro

Re: [U2] Fwd: U2 Product Release: U2 DBTools vNOV2012

2012-11-30 Thread Colin Alfke
The "public" downloads are available at: http://u2.rocketsoftware.com/resources/downloads but the NOV2012 version isn't listed yet. You should be able to get it from the u2bc site. Hth Colin -Original Message- From: Bill Haskett Sent: November 30, 2012 10:19 AM To: U2 Mail List Subject:

Re: [U2] Fwd: [MailServer Notification]Content Filtering Notification

2012-11-22 Thread Colin Alfke
Nope - but I haven't sent anything to the U2 list either... Hth Colin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: November 22, 2012 12:40 PM To: U2 Mail List Subject: [U2] Fwd: [MailServer Noti

Re: [U2] Unidebugger

2012-10-26 Thread Colin Alfke
It is/was a windows based (thick client) editor for UniData and UniVerse. It has a number of standard "editor" features like syntax highlighting etc. It is/was included on the clients package. It integrated with dynamic connect which allowed a telnet window in your editor screen. It could use direc

Re: [U2] Selection Suggestions for using UV instead of SQL

2012-10-18 Thread Colin Alfke
In my first programming class in high school (on apple IIe's) we liked to use G$ (with the $ pronounced as string) Colin -Original Message- From: Bill Haskett Sent: October 18, 2012 12:24 PM To: U2 Users List Subject: Re: [U2] Selection Suggestions for using UV instead of SQL Sort of

Re: [U2] Unidata 7.1.16 Multiple Active Select Lists

2012-09-24 Thread Colin Alfke
vin King Sent: September 24, 2012 3:03 PM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Thanks for the information. It is unusual that the subroutine works fine without a list but it consumes the active select list if there is one when the subroutine EXECUTES the se

Re: [U2] Unidata 7.1.16 Multiple Active Select Lists

2012-09-24 Thread Colin Alfke
Kevin; The "problem" is that the initial list is list 0 so that your execute select uses it - regardless of pass/rtnlist. Like David said you will have to save the list items before your select and then restore it to list 0 when done. Another alternative is to use the unibasic select - which loses

Re: [U2] [UD] Determining number of users licensed

2012-09-12 Thread Colin Alfke
I've tracked the largest number of users logged in - but I didn't have to worry about the max. I had thought it was in the SYSTEM() somewhere - but a quick look through help didn't show it. You could try parsing it out of the @udtbin\smm.log file... It's in there for windows - not sure about HPUX

Re: [U2] [Windows]

2012-09-06 Thread Colin Alfke
With the proper security settings you could also see it in the windows event log. Not sure about how to query the Universe telnet server, in UniData there are a number of commands that are actually executables that you can run from a command prompt - like listuser. hth Colin -Original Message

Re: [U2] [ud] Sub-second delay?

2012-08-30 Thread Colin Alfke
I was just talking with a client this morning that was lamenting the fact that our proposed SQL solution would require 4 VM machines to run a comparable system to his current one on UniData that "doesn't have as much processing power as my iphone". (It may also not have as much memory, and is poss

Re: [U2] Problem running script from crontab

2012-06-30 Thread Colin Alfke
Perhaps. Anything that would have gone to the screen will go to the _PH_ record (note: if it's firing every 10 minutes you will want to automate a process to clean up the records). You could put some CRT's in your LOGIN/program process to track it better. From a previous note it looked like the

Re: [U2] Problem running script from crontab

2012-06-28 Thread Colin Alfke
The phantom command will run your login paragraph. Is it setup to allow this process to go through? There should be something in the _PH_ file/folder for when the cron fired off. hth Colin -Original Message- From: Charles_Shaffer Sent: June 28, 2012 10:19 AM To: U2-Users@listserver.u2ug.

Re: [U2] Regarding : Usage of the SEL.CMD

2012-06-08 Thread Colin Alfke
It's likely simply a variable being used to run various commands. Is it being used after EXECUTE/PCPERFORM/UDTEXECUTE statements? If so, you'll need to look up the commands that are being loaded into the variable. hth Colin -Original Message- From: satya satya Hi Everyone, Can any Expl

Re: [U2] Excel Worksheets

2012-06-01 Thread Colin Alfke
Or save yourself the trouble http://www. remove this nebula-rnd.com/products/xlite.htm - There isn't anything in the CSV "standard" that would create a new sheet and I haven't run across anything that Excel uses. hth Colin -Original Message- From: Israel, John R. I use xml for a few of o

Re: [U2] READU vs READ

2012-05-01 Thread Colin Alfke
Dave; A couple more things: - do you have any other processes running at the same time? I found (long ago) that a couple of our big processes ran 5X faster consecutively than they did concurrently. - subroutine calls with file opens. I inherited a process that was running for 3 days and was 65%

Re: [U2] EXIT ; EXIT inside a loop

2012-04-19 Thread Colin Alfke
Just note that this would execute the that I'm *assuming* the second exit was meant to avoid. I'm also assuming that somewhere in the logic either G or H is modified otherwise you should test them first and avoid the loops altogether. :) (niggly point - the use of exit makes your use of a2.done re

Re: [U2] UD - Account Permissions

2012-04-18 Thread Colin Alfke
It kind of looks like a missing write permission somewhere. I would try the VOC in "MyAccount", see if you can write to the 'Q' pointer. Telnet is a little different. I tells customers that they need to setup the telnet user so that they are able to login at the console. Older versions of Windows

Re: [U2] Can I automate Wintegrate BridgeCopy?

2012-04-17 Thread Colin Alfke
Can you not copy the index files as well (X_filename)? Otherwise, you could create script to create a "dummy" X_filename and running delete.index to simply remove the index (at this point you could also script the re-creation of the index if you would prefer). hth Colin -Original Message-

Re: [U2] UD - Account Permissions

2012-04-17 Thread Colin Alfke
Bill; There are a couple of windows permissions (log on locally, access this computer) that need to be enabled for the user for telnet user (at least as of 2003). hth Colin -Original Message- From: Bill Haskett Sent: April 17, 2012 10:27 AM To: U2 Mail List Subject: [U2] UD - Account Per

Re: [U2] Monitoring a U2 server?

2012-04-13 Thread Colin Alfke
UniAdmin has a fairly comprehensive monitoring system. You can look at it for inspiration (or show it as proof of concept, or just use it). I haven't checked XAdmin though. hth Colin -Original Message- From: Rutherford, Marc Sent: April 13, 2012 9:50 AM To: u2-users@listserver.u2ug.org Su

Re: [U2] UD - Export Telnet Registry Users (Win 2K3) and Import to Windows 2008 R2

2012-04-12 Thread Colin Alfke
I think there might be a technote on how to do this. I'm pretty sure Rocket has one and MS may as well... hth Colin -Original Message- From: Bill Haskett Sent: April 12, 2012 3:30 PM To: U2 Mail List Subject: [U2] UD - Export Telnet Registry Users (Win 2K3) and Import to Windows 2008 R2

Re: [U2] u2ug.net Website

2012-04-03 Thread Colin Alfke
Yeah, I thought .org redirected to .net at one point. I did ask in the website forum about email (as it's still using .org). I tried to ask Laura Hirsch why the change was made but was having trouble with my email and I don't think the question ever got out. Brian, if it's supposed to redirect - i

Re: [U2] u2ug.net Website

2012-04-03 Thread Colin Alfke
Can't get to Spectrum or u2ug.net? Brian's fixed the website - good job! I thought I convinced my boss a couple years back to send me "next year" - but then they sold the company to a SQL based competitor... -Original Message- From: John Thompson Sent: April 3, 2012 1:34 PM To: U2 Users L

[U2] u2ug.net Website

2012-04-03 Thread Colin Alfke
Anyone else unable to connect to www.u2ug.net? I'm getting the following error: Server Error 401 - Unauthorized: Access is denied due to invalid credentials. You do not have permission to view this directory or page using the credentials that you supplied. www.u2ug.org redirects to

Re: [U2] How to UPCASE in a Paragraph?

2012-03-28 Thread Colin Alfke
You may need an actual dictionary item rather than pulling something from the VOC -Original Message- From: George Gallen Sent: March 28, 2012 3:39 PM To: U2 Users List Subject: Re: [U2] How to UPCASE in a Paragraph? I have a records that match what I'm looking for..It's just not find

Re: [U2] odbc error "Unable to get UCI configuration file from Registry"

2012-03-16 Thread Colin Alfke
me, it's probably happened to someone else here, and I might be able to get this resolved reasonably quickly. And of course, it's not that I need ODBC access in and of itself, but rather that I need it to test something I'm developing... Thanks. On 3/16/2012 12:53 PM, Colin Alf

Re: [U2] odbc error "Unable to get UCI configuration file from Registry"

2012-03-16 Thread Colin Alfke
Sorry, haven't seen it. Are you sure your UCI config file is OK? In my UCI config file editor I have options to "Get Registry" and "Reset Registry" under File. Perhaps that will help hth Colin -Original Message- From: Allen Egerton Sent: March 16, 2012 10:29 AM To: .U2 List Subject: [

Re: [U2] SB Client PE download

2012-03-07 Thread Colin Alfke
ssage----- From: Colin Alfke I'm not sure if Dynamic Connect is still in the client download. It can work uite well - with some setting up of a new terminal type. It won't do GUI or ny of the "TU" applications (file transfer, Excel Downloads, etc) but it orks nic

Re: [U2] SB Client PE download

2012-03-07 Thread Colin Alfke
I'm not sure if Dynamic Connect is still in the client download. It can work quite well - with some setting up of a new terminal type. It won't do GUI or any of the "TU" applications (file transfer, Excel Downloads, etc) but it works nicely as a terminal program. hth Colin -Original Message--

Re: [U2] SB Client PE download

2012-03-07 Thread Colin Alfke
Sorry if I caused some confusion. I had thought Rocket was trying to get away from the SB+ naming conventions with SB/XA. When I said it won't work with SB+ I meant SB+ versions prior to the version in SB/XA. As Steve, David, and Dan have confirmed - SBClient 6 won't connect to prior versions of

Re: [U2] SB Client PE download

2012-03-07 Thread Colin Alfke
There is a version of SBClient in the SB/XA download although it's set to work with SB/XA and not SB+. hth Colin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Laura Hirsh Sent: March 7, 2012 8:52 AM To: 'U2 Users L

Re: [U2] Date Problem

2012-01-20 Thread Colin Alfke
Will's on the right track. @DATE (and @TIME) are set when the "original" program is executed. In most use cases @DATE is interchangeable with DATE() so most don't notice the difference. Although @DATE is available in dictionaries. It's likely that that one program can be traced back to a program ru

Re: [U2] SB Missing Screen

2011-12-23 Thread Colin Alfke
The problem's obvious: you're working during your vacation!! Sorry, I don't know how PRC pushes the updates - but I'd start with /XP or /MP and go through the processes to make sure everything's calling what I expect (guessing that PRC didn't overwrite a current process that is setting things so i

Re: [U2] Corrupted compiled code

2011-12-22 Thread Colin Alfke
I tried VCATALOG on a directly catalogued item and received the same error. The help does say it checks the global catalog file. I usually compare the time/date stamps on the original vs the compiled as we usually only compile immediately after saving the record. Colin -Original Message

Re: [U2] [UD] Corrupted compiled code

2011-12-20 Thread Colin Alfke
Ouch. I've never seen that. Did you check the time/date stamp on the compiled code? The only vaugely similar thing was data files getting corrupted. But that was only on writes and the problem was with some driver issues with the drive controller and network card. You may want to check with

Re: [U2] Extract first and last name from free-form name

2011-12-14 Thread Colin Alfke
Or you could use pre-packaged software to do it for you. I've used ParseRat for parsing report output and it worked really well - although the interface is getting extremely dated. Haven't tried it for names - but it would be way easier than reinventing the

Re: [U2] SB print output question

2011-12-12 Thread Colin Alfke
Taken from the help output: This outputs the report in DIFF format (comma delimited) in the xxWORK file. Item ids are 'SBDIF.':port:'.':page and are used to transfer SB+ database records into DOS speadsheet programs. It's built into the SB+ Report writer. It's the Data Interchange Format.

Re: [U2] Universe and SQL

2011-12-09 Thread Colin Alfke
DATE Can I do that in Universe 9.6 ? Or 10.2 ? And it will use the built-in SQL processor that comes with Universe ? Not to update the database, just to query from it? And if so, is there documentation on doing this query from an external database ? -Original Message----- From: Colin Alf

Re: [U2] Universe and SQL

2011-12-09 Thread Colin Alfke
Sure. They have EDA (originally a number of SQL type DB's but IBM reduced to DB2 and now Rocket is adding them back) and BCI - an ODBC connection directly from Basic. hth Colin Alfke Calgary, Canada -Original Message- From: Wjhonson I see a lot of stuff on Universe accessing it&

Re: [U2] End of Month date routine

2011-12-06 Thread Colin Alfke
That's better. It wasn't the ';' in the last one that caused the problem - especially with a generic routine - it was the reliance on the date format being m/d/y (which Dave's original noted). Not sure why you're trying so hard to compress the lines. This routine will easily fit in pretty much any

Re: [U2] End of Month date routine

2011-12-05 Thread Colin Alfke
Doesn't work for me :( Tried on UD 7.1.6 and UD 6.0.12. It works for December, but I changed it to March and it gave me January 3rd. UniData does have a nice function LAST_DAY(x) for using in virtual attributes to return the last day of the month for the date passed to it. hth Colin Calgary, Can

Re: [U2] Unidata 7.1 Unresponsive UO Connection

2011-12-01 Thread Colin Alfke
It probably does this to keep it simple. If the pooled connection had to keep logging to different accounts for each of its connection it would have to keep track of where it was and which connection used which account. This would likely slow it down and open an attach vector that could be exploite

u2-users@listserver.u2ug.org

2011-11-30 Thread Colin Alfke
UniData has the _PH_ file which is a DIR type file. There is the DIR() function that will return a lot of information for you without the expense of opening the file. Perhaps UniVerse has something similar. See for examples and code on how to use

Re: [U2] Converting an account from UniVerse to UniData

2011-11-24 Thread Colin Alfke
I thought Dave Taylor from Sysmark might reply to this. They have some tools for dumping accounts that may be what you are looking for. It also looks like Doug's Xlr8 editor may also do this now. hth Colin Alfke > From: David > > Does anyone have experience converting a Un

Re: [U2] UniVerse to UniData Conversion

2011-11-24 Thread Colin Alfke
Depending on what you are looking for the SCMP(x,y) function may be what you are looking for. Or you can always append a letter to each string you are comparing to "force" a string comparison. hth Colin Alfke Calgary, Canada > From: David > > I am converting some UniVe

Re: [U2] Code Collaboration

2011-11-16 Thread Colin Alfke
I take it you find the SB+ /COMPARE tool a little wanting -Original Message- From: Steve Romanow Something I have long desired is diff tool for mv records (that will use standard diff/patch output) so it can integrate with other tools. Maybe a packager for SB+ A diff tool for SB+ th

Re: [U2] OPENSEQ / WRITESEQ and UniObjects

2011-11-04 Thread Colin Alfke
I'd guess it was some type of permission error. Does the user you are connecting with through UniObjects have write permissions on the folder that the open/writeseq is writing on? hth Colin Alfke Calgary, Canada -Original Message- From: Holt, Jake It fails to write. It give

Re: [U2] UD Re-indexing

2011-11-01 Thread Colin Alfke
We don't use multi-level files, but usually when I see the permission denied it means a user has the file open at the OS level. I usually use PSTools to find it. When you delete.index ... ALL it actually deletes the X_... file so you get this message if someone has it open. hth Colin

Re: [U2] OPENSEQ and the LOCKED Option

2011-10-28 Thread Colin Alfke
You need to change line 6 to END ELSE (to end the locked clause) -Original Message- From: Al DeWitt Here is my admittedly simple test program and the results: 001: IMPORT.FILE = "FILE_IN.CSV" 002: CLOSE.IT = 1

Re: [U2] OPENSEQ and the LOCKED Option

2011-10-28 Thread Colin Alfke
I've usually only used it where I expect one user to be accessing the file at a time anyway. However, it should (mine does on UD 7.1.6) compile. You are using an "END" before the next THEN or ELSE - that might do it. hth Colin Alfke Calgary, Canada -Original Message-

Re: [U2] UniData AIX commands for commands like LIST.READU and LIST.QUEUE?

2011-10-21 Thread Colin Alfke
I've found UniAdmin can often connect and work when you're out of other licenses. hth Colin Alfke Calgary, Canada -Original Message- From: Kevin King Sent: October 20, 2011 6:15 PM To: U2 Users List Subject: Re: [U2] Unidata AIX commands for commands like LIST.READU and LIST.

Re: [U2] SB Icons

2011-10-14 Thread Colin Alfke
You can do it just for SBClient: 1. Right click on the SBClient Icon used to launch SBClient. 2. Select the 'Properties' option. 3. Select the 'Compatibility' Tab. 4. Check the settings box for 'Disable Desktop Composition'. hth Colin Alfke -Original Message---

Re: [U2] SB Icons

2011-10-14 Thread Colin Alfke
There is a technote on the availability matrix. hth Colin Alfke -Original Message- From: Israel, John R. Disabling Aero sounds familiar! It is Windows 7 - 64 bit. SB Client 5.4. HOW do I disable Aero w/ SB? Thanks John Israel -Original Message- From: Colin Alfke Try

Re: [U2] SB Icons

2011-10-14 Thread Colin Alfke
Try disabling Aero mode for SBClient. Which version of SBClient and is it 32 or 64 bit Windows 7? hth Colin Alfke Calgary, Canada -Original Message- From: Israel, John R. We have a user that just loaded SB onto a Windows 7 box. In GUI mode, she is not getting the icons at the top of

Re: [U2] Unidata 7.1.22 Index Issue

2011-10-13 Thread Colin Alfke
file (X_STUMAST). Then you can do the DELETE.INDEX STUMAST ALL. hth Colin Alfke Calgary, Canada -Original Message- From: regalit...@aol.com This information has been extremely helpful! I had 11 files have the indexes go bad on them, and they needed to be completely rebuilt. The only an

Re: [U2] PE72 Unidata will not start

2011-10-11 Thread Colin Alfke
with that. Double check with confprod.exe (in @udtbin) to make sure the license is correct and authorized. hth Colin Alfke Calgary, Canada -Original Message- From: Tom Gray Daniel McGrath writes: > > Okay, first, don't worried about RFS not being licensed. That is additiona

Re: [U2] Job scheduling in UniVerse

2011-09-13 Thread Colin Alfke
un whatever it is you are trying to run then you can skip the SB.LOGIN and run it directly (just make sure it won't then return to the SB.LOGIN). This will allow you to use the OS scheduling service which is much more robust than trying to get a phantom to sleep and restart itself H

Re: [U2] Lock Status

2011-09-08 Thread Colin Alfke
Just don't do what one of my old bosses did (he was having trouble with SB+ holding locks) - he found one of our main processes and put in "RELEASE". Our system relied heavily on pessimistic locking so this caused quite a bit of data loss. Of course, I was the one that had to clean it all up (he di

Re: [U2] udt dir file max key length

2011-07-22 Thread Colin Alfke
*From:* alfke > Maybe you should go windows :) > > Even 6.0.12 > :LIMIT > U_MAXFNAME: File name limit = 198 > > Hth > Colin Alfke > Calgary, Canada ___ U2-Users mailing list U2-Users@listserve

Re: [U2] Odd error message

2011-07-22 Thread Colin Alfke
pe 'p' it puts the data in the last element and the syntax results in the error. Hth Colin Alfke Calgary, Canada -Original Message- From: Wols Lists On 22/07/11 16:56, John Thompson wrote: > Never seen that one... > > My initial thought is: > > Is there a program tha

Re: [U2] udt dir file max key length

2011-07-22 Thread Colin Alfke
Maybe you should go windows :) Even 6.0.12 :LIMIT U_MAXFNAME: File name limit = 198 Hth Colin Alfke Calgary, Canada -Original Message- From: Symeon Breen Thanks - ud just has DIR type files no type 1 or 19

Re: [U2] Simple FMT question

2011-07-08 Thread Colin Alfke
lly* note when there are basictype differences but don't always make them clear. Good luck Colin Alfke Calgary, Canada -Original Message- From: Bob Woodward Hi Group, I don't know why this is kicking my butt but I'm trying to do a simple X = FMT(X,"4\0R") statemen

Re: [U2] Epicor and Eclipse

2011-07-08 Thread Colin Alfke
ever buy any application software from you. As I see it - I either buy a license for your application and separate ones for the database (U2) and development tools (SB+) or I won't buy from you at all, it's that simple! No wonder MV is struggling! On 08/07/2011 07:06, Colin Alfke

Re: [U2] Epicor and Eclipse

2011-07-07 Thread Colin Alfke
I believe our licences (as a VAR) with Rocket specify that when we sell UniData and SB+ it's "part of" the application and is only licenced to run the application it's sold with. So it sounds valid, although they may have the option to only sell UD and SB+ support. Colin > From: meckif > >

Re: [U2] Found something interesting.....Bug or No Bug....that is my question?

2011-07-07 Thread Colin Alfke
G_ID" 54 records selected to list 0. >select FILENAME "EXISTING_ID" REQUIRE.SELECT 1 records selected to list 0. >CLEARSELECT select FILENAME "EXISTING_ID" REQUIRE.SELECT No active select list. Processing terminated. Hth Colin Alfke Calgary, Canada -Original Me

Re: [U2] Installing UniObjects on Windows 2008 64 bit

2011-06-14 Thread Colin Alfke
hange the CPU type (in Visual Studio) to x86 from AnyCpu. The first sounds like it would help and the second doesn't look like it will help until you actually compile/create something. Take a look at the Rocket Knowledge base (or ask your support provider) for more info. hth Colin Alf

Re: [U2] SB Error

2011-06-07 Thread Colin Alfke
mv position and the 0 was pulling back the whole attribute instead of just the correct mv. You may also want to check your SB+ files.opened variables. Good luck Colin Alfke Calgary, Canada -Original Message- From: Israel, John R. The new stand-alone program is truly a program. It loops

Re: [U2] UniQuery Output to File

2011-06-02 Thread Colin Alfke
directory. As Wally says turn on UDT.OPTION 91 although I think dates are the only thing that really needs it. hth Colin Alfke Calgary Canada > From: mstrand > > > send UniQuery output to a file. > > Perhaps LIST TO DELIM? > > -- > TO [DELIM "char"]

Re: [U2] Video Quirk

2011-05-31 Thread Colin Alfke
I've found doing a CRT TERM.DEFN<14,1> resets the colours back to the defined background for the terminal type when I use the SB.INPUT routine in a standalone program. It may help here, but I've never seen this happen in an actual screen. Hth Colin Alfke Calgary, Canada -

Re: [U2] [UD] Extract a line with a CR and/or LF character in it.

2011-05-25 Thread Colin Alfke
at make more sense? Hht Colin Alfke Calgary, Canada > From: wphaskett > > I guess that's my problem. I can't use OSBREAD because the Cr/Lf > appears in different columns in the line. I can't guarantee where it > shows up (or what character position). Using READ

Re: [U2] [UD] Extract a line with a CR and/or LF character in it.

2011-05-25 Thread Colin Alfke
o use osopen and osbread. This will read a block of text (size of your choosing and I've found you have to play a bit to get good throughput). You then have to parse through the block literally character by character. hth Colin Alfke Calgary, Canada > From: wphaskett > > I'

Re: [U2] XAdmin

2011-05-17 Thread Colin Alfke
Good catch (or debugging skills). I've always been a little confused on how UniAdmin connects - I though it was UO for Java as you can run it as an applet, but I never see it logged in and it works even if you're out of licenses. Colin > Date: Tue, 17 May 2011 13:54:50 -0700 > From: wphaske

Re: [U2] XAdmin

2011-05-17 Thread Colin Alfke
e U2-logic editor back when it was free. It worked but I found the overhead of eclipse just a little too much. With U2 now with Rocket I wonder if they will still have the same incentive to use Eclipse Perhaps the port is being blocked at some point or the RPC service isn't active. H

Re: [U2] XAdmin

2011-05-16 Thread Colin Alfke
re. I didn't have time to take it any further. hth Colin Alfke Calgary, Canada > From: wphaskett > Subject: [U2] XAdmin > > Does the Eclipse-based XAdmin tool, provided by RS on the client CD, > only work with UniData 7.2 and higher? I can't seem to connect to any >

Re: [U2] [UD] How to get output-converted results from EXECUTESQL and READNEXTTUPLE?

2011-04-28 Thread Colin Alfke
at from the dict into HIRE_DATE_CNV and SALARY_CNV.) I think I like how the EXECUTESQL ... TO puts the data into memory somewhere as there is no file to clean up afterwards - like is created from the SQL> prompt. I guess it depends on the limits imposed on that structure. Good luck Colin Alfke C

Re: [U2] Trigger questions

2011-03-30 Thread Colin Alfke
pdates are allowed. 1 - Updates are allowed. 2 - Updates are allowed, using the return recordval. So if your before update trigger passes back a 0 as the execstat the write won't be performed. You'll just need to make sure the process calling the write can then deal with it. Hth

Re: [U2] Upgrading to latest UV/UD PE / Windows

2011-01-31 Thread Colin Alfke
to want to connect to earlier versions of UniData - hopefully this one will Good luck! Hth Colin Alfke Calgary, Canada -Original Message- From: Tony Gravagno A while back I posted a blog with details about upgrading Universe and Unidata. A lot of people found it to be helpful. nospa

Re: [U2] How to Clear Empty VM marks in Field

2011-01-28 Thread Colin Alfke
If you don't have to worry about associated fields and you're trying to clear null attributes or you want a count of the non-null attributes then trim is probably the easiest way (plus there are options to only clear leading,trailing,or all): FXI = TRIM(FXI,@VM) Hth Colin Alfke Calga

Re: [U2] CoRelating Two Arrays

2011-01-26 Thread Colin Alfke
You might also want to correct the spelling/variable name in: Receeived.Running.Total = 0 Hth Colin Alfke Calgary, Canada -Original Message- From: Brutzman Yup... Before the "exit" I need to Where.We.Left.Off = Receiver.Count Thanks to Allen, Larry, and Rober

Re: [U2] unidata

2011-01-09 Thread Colin Alfke
Just Rocket's term for VAR or solution provider. -Original Message- From: jeffrbeall Thanks for the reply, I'll try the "backup" thing. By the way, what is a ISV? Colin Alfke wrote: > > The personal editions can be downloaded from: > <http://www

Re: [U2] unidata

2011-01-08 Thread Colin Alfke
on is simplistic. If you e-mail u2as...@rs.com they should be able to help more. Hth Colin Alfke, Calgary Canada -Original Message- From: jeffrbeall I have a HPUX box running a unidata database. I would like to make another server running unidata as a backup, so if the HPUX box goes down,

Re: [U2] Dropping my UniVerse Session - Why?

2010-11-18 Thread Colin Alfke
I've seen similar errors in UniData with invalid keys (both length and characters). Usually it only happens on the write Hth Colin Alfke Calgary, Canada -Original Message- Dan Fitzgerald Attempting to write to an invalid memory address can come from a few issues. I've se

  1   2   3   >