RE: [U2] Unidata File Error

2005-05-19 Thread Alfke, Colin
I had a similar problem a little while ago. I ended up creating a new file (with a completely new modulo and blocksize and copying all of the records into it. Deleting the original and renaming the new file back to the original. I then recreated the index on the file. IBM did want a copy of the fil

RE: [U2] UniData Indexes

2005-05-09 Thread Alfke, Colin
You could do a x = FILEINFO(file.var,13) to see if there is an index - or sort the directory looking for X_ files, but then you would have to watch out for Dynamic files. You can use the INDICES function to return the index arguments. It will also tell you if an index is there or not. You can do

RE: [U2] [UV] Detecting Command-line Arguments to uv

2005-05-06 Thread Alfke, Colin
In UniData there is the @COMMAND variable you can check. I'm not sure what the UniVerse version is. hth Colin Alfke Calgary, Canada -Original Message- From: Perry Taylor Is anyone aware of a way to detect if uv (uvsh) was started with any

RE: [U2] Creating Unidata Triggers

2005-05-05 Thread Alfke, Colin
You need exclusive access to the file. If another user has the file "open" then you might have problems. Recently, I've been seeing this message - but the trigger has still been added and works. Not sure why. Hth Colin Alfke Calgary Canada "where is hasn't snowed in almost a week" >-Origina

RE: [U2] Software development - MVTools

2005-05-04 Thread Alfke, Colin
Sorry, I haven't used MVTools. There are a couple of things you can do: 1. Create a windows version of the unix commands. Example: ED LVDIR WHOAMI.BAT Top of "WHOAMI.BAT" 001: ECHO %USERNAME% This is a bat file in the directory that gets shelled to that provides the user name. 2. Load something

RE: [U2] Validating an email adress

2005-05-03 Thread Alfke, Colin
>From: [EMAIL PROTECTED] > >In a message dated 5/3/2005 4:43:20 AM Pacific Daylight Time, >[EMAIL PROTECTED] writes: > >> GoodEmail = ( Convert("_.1234567890","",Email) Matches >> "1A0A'@'1A0A") > >Change that patter to 1X0X'@'1X0X'.'1X0X > >1A0A Would mean you're disallowing emails ad

RE: [U2] Off topic - resizing open files in Advanced Pick/AIX

2005-04-29 Thread Alfke, Colin
Yes, as of about version 6. I didn't know it was possible in UniVerse. It's not in UniData :-( Colin Alfke Calgary, Canada >-Original Message- >From: Joe Walter > >Wondering if anyone out there knows it it's ok, possible to >resize open files in advanced pick running on AIX? > >In Univ

RE: [U2] uvo.net UvBasic .Net

2005-04-29 Thread Alfke, Colin
I'm always appalled at what seems to be the general consensus around here that a GUI interface and fast, efficient, effective data entry are mutually exclusive. Colin "what the HE - double-hockey sticks is going on here" Alfke Calgary, Canada >-Original Message- >From: Don Kibbey > >If y

RE: [U2] uvo.net

2005-04-26 Thread Alfke, Colin
I'm sure I found a bunch of vb.net examples on IBM's support site. I haven't had a chance to look at them yet. I ran across them looking for something else and downloaded them as I can never seem to find things again. I might have been in "my support" rather than techconnect. hth Colin Alfke

RE: [U2] MvInternet - IBM Licensing Requirement

2005-04-18 Thread Alfke, Colin
Much dittoing I know there have been some changes in the recent versions of U2 to try to prevent the type of multi-plexing that IBM really had a problem with - the use of (unlicensed) phantoms to service these requests. Current versions require phantoms to use a license if they perform certai

RE: [U2] Unidata dynamic file problem

2005-04-18 Thread Alfke, Colin
See the section: File Corruption in the Administering UniData on Unix manual. They don't really get into the specifics of the errors - just the techniques to find and correct problems. There is also some good information on the U2 Survival CD. Hth Colin Alfke Calgary, Canada >-Original Messa

RE: [U2] Hold-file to CSV

2005-04-15 Thread Alfke, Colin
>From _HOLD_ (which in UniData is an O/S level directory) I just use an external program (like www.parserat.com) to do this for me. There are lots of others. Hth Colin Alfke Calgary, Canada >-Original Message- >From: Mark Johnson > >I'm at the threshold of wanting (needing) to convert pr

RE: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Alfke, Colin
you recall any details of >why this might have been so? > >-Original Message- >From: Alfke, Colin > >Ooops, I thing I forgot to mention. On some versions of UniData >(5.2.4?) doing a /TCL in SB+ will cause UniData to not output >information with LIST.READU. I don'

RE: [U2] Logon Banner

2005-04-14 Thread Alfke, Colin
This used to work in older versions of UniData. For some reason it's broken now. I haven't figured out a way around it. Let me know if you do. Colin Alfke Calgary, Canada >-Original Message- >From: Bob Woodward > >I hope this is a simple question. When going into Uniadmin, >in the Netw

RE: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Alfke, Colin
Ooops, I thing I forgot to mention. On some versions of UniData (5.2.4?) doing a /TCL in SB+ will cause UniData to not output information with LIST.READU. I don't recall if there is also a problem with GETREADU() - plus it's already in an array so you don't have to trim and parse (truncated) data (

RE: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Alfke, Colin
Like Mike said, you want to use LIST.READU (or LIST.QUEUE) to see the locks. However, UniData, unlike UniVerse does have the file name and not just the number. The Status() after a readu gives you the UID (pid) of the process that has the record locked. You can parse it out of the array returned w

RE: [U2] UD, NFA

2005-04-14 Thread Alfke, Colin
I have done this with Windows - without NFA. I simply setup a VOC item to the "remote" directory: :CT VOC CA.REMOTE VOC: CA.REMOTE: DIR \\DEV\D\unidata\current\qa\CAPROGS \\DEV\D\unidata\current\qa\d_CAPROGS The IP address also works. The "D" is a shared directory. Running the program "locally

RE: [U2] Complicated Select

2005-04-12 Thread Alfke, Colin
Generally, we use a program to generate a single statement; however if you may be able to use sql on the file with the UNNEST command to do this in a single statement. This will mean you will have make sure your file and dicts are SQL/ODBC naming compliant. There is a fair amount of documentation

RE: [U2] Print job with writeseq

2005-04-12 Thread Alfke, Colin
I think Ed's right. Really, once you add the printer control sequences, which as Richard pointed out - you need to preface with the code, you have a pcl document and not a text document. There are a number of PCL viewers that will do this - the ones I found were either good or cheap. If you're

RE: [U2] Unidata file corruption

2005-04-11 Thread Alfke, Colin
Since you are in a testing account the first thing to try is a resize of the file. It's quick and easy (unless it's a really big file) and actually "fixes" a number of problems. Make sure no one accesses the file during the resize - it will just make it worse. I would then try running guide on the

RE: [U2] duplicate messages

2005-04-08 Thread Alfke, Colin
Thank goodness. I updated my Outlook this morning and suddenly started to get duplicates. I was afraid to ask since I forgot to wear my flame-proof spidey-man undies today... Colin >-Original Message- >From: Roger Glenfield > >No, it's not you. First duplicate message seems to be from

RE: [U2] **** The Windows Versions of U2 Personal Editions Are Live ****

2005-04-01 Thread Alfke, Colin
For April Fools Day - you sure are taking me literally ;-) Lots of patience. Just trying to think of the poor folks at u2ask us that will have to field all the calls. I want them to have lots of time to answer mine :-). Have a great weekend. Colin Alfke >-Original Message- >From: Ler

RE: [U2] **** The Windows Versions of U2 Personal Editions Are Live ****

2005-04-01 Thread Alfke, Colin
Sorry, I don't expect the personal editions in the matrix. My point was only that the page (https://www-927.ibm.com/software/data/u2/support/u2techconnect/matrix.asp) has a notice that they are not available (Notice: U2 Personal Editions have been temporarily removed from this site. We expect

RE: [U2] **** The Windows Versions of U2 Personal Editions Are Live ****

2005-04-01 Thread Alfke, Colin
That's great Leroy. It's good that you sent the link. The techconnect and availability matrix pages still state they are not available... Colin Alfke >-Original Message- >From: Leroy Dreyfuss > >Dear All, > >UniVerse 10.1.10 Personal Edition and UniData 6.1.7 Personal >Edition are >now

RE: [U2] Q-pointers to system folder

2005-03-23 Thread Alfke, Colin
Actually, I did test this, it just says the dict is a synonym, asks for confirmation, then removes the VOC entry and the directory, but leaves the D_VOC item alone Colin Alfke Calgary, AB >-Original Message- >From: Don Verhagen > >I wouldn't use D_VOC for the dictionary because if

RE: [U2] Q-pointers to system folder

2005-03-23 Thread Alfke, Colin
You can do the same thing in UniData; however you should put DIR in line 1 instead of F and use CREATE.FILE DICT TEXTFILES 1 to create the dict item. I also tend to put D_VOC in line 3 instead of doing the CREATE.FILE. You can also use things like @UDTHOME and @UDTBIN in the path. I do this to

RE: [U2] UD: ODBC/OleDB access to selected records in a file

2005-03-15 Thread Alfke, Colin
There are a couple of ways around that: you can use a different file for each user or you can put some sort of identifier in the key for each user. We did find some neat functionality in Crystal that meant we could use multiple data files with one report. I forget what their terminology for it w

RE: [U2] RE:

2005-03-15 Thread Alfke, Colin
I'll second the motion. Other solutions: 1. Determine some method to keep the current box. 2. Print out reports. Pray that you have all you need and retire the box. - this can be to paper or a report "data extraction" program. 3. Migrate the application to the current versions of Aix/Solaris/Un

RE: [U2] UD: ODBC/OleDB access to selected records in a file

2005-03-15 Thread Alfke, Colin
Sorry, I haven't played much with our Crystal reports, but I think we had a similar problem. However, we didn't have the large library of paragraphs that we felt compelled to re-use. I didn't think it was all that slow. We did figure out how to do some neat things with Crystal though. What abo

RE: [U2] [UD] disconnected index

2005-03-14 Thread Alfke, Colin
I've only seen this when moving around files at the OS level. I certainly wouldn't trust this index and would delete and rebuild it. Colin Alfke Calgary, AB >-Original Message- >From: Josh Marcus > >Has anyone ever seen a UniData file have its index become disconnected >from the data fi

RE: [U2] [UV] "non-numeric" error after passing (ANS MATCHES '0N' & ANS>0)

2005-03-10 Thread Alfke, Colin
Yes, I'm on UniData (testing on 5.1.27). We don't have the !matches version. However, I did test some very large values in the array and didn't get the non-numeric error. Some more of those things that are almost the same between UniData and UniVerse but not quite. No wonder they don't want to t

RE: [U2] [UV] "non-numeric" error after passing (ANS MATCHES '0N' & ANS>0)

2005-03-10 Thread Alfke, Colin
Because num() will OK 1.1, -22 etc that you wouldn't want to use in an array expression. Colin Alfke >-Original Message- >From: John Solie > > >I'm wondering why y'all are using a ...MATCHES "0N"... >Usually, I'll use >the NUM() function. The code snippet in one of the first >messag

RE: [U2] [UV] "non-numeric" error after passing (ANS MATCHES '0N' & ANS>0)

2005-03-10 Thread Alfke, Colin
I found ANS = '':@VM will pass. I didn't try any combinations/derivatives. I also saw another post where a very long number passed the test but failed in the array assignment. Colin Alfke >-Original Message- >From: Stevenson, Charles > >> Could your ANS variable have contained Char(2

RE: [U2] [UV] "non-numeric" error after passing (ANS MATCHES '0N' & ANS>0)

2005-03-09 Thread Alfke, Colin
Right, but I wasn't sure how UniVerse would handle them. A quick check with ANS = "":@VM passed the test though. Any possibility of that kind of problem? hth Colin Alfke Calgary, AB >-Original Message- >From: Stevenson, Charles > > >> In UniData the '.' and '-' will evaluate as nume

RE: [U2] [UV] "non-numeric" error after passing (ANS MATCHES '0N' & ANS>0)

2005-03-08 Thread Alfke, Colin
In UniData the '.' and '-' will evaluate as numeric. You might want to check how these would fall through your logic in UniVerse. hth Colin Alfke -Original Message- From: Stevenson, Charles The relevant code (& I am VERY sure source matches o

RE: [U2] broken dynamic file on UDT

2005-03-08 Thread Alfke, Colin
Thanks Wally. I keep forgetting that I can use fileview. The good thing about UniData is that I don't need it nearly as often :-). Dump is just like a hex file viewer. Plus will follow the links backwards and forwards. Read only so not dangerous. I meant to not give quite enough details to act

RE: [U2] broken dynamic file on UDT

2005-03-08 Thread Alfke, Colin
Chuck, I feel your pain. I've spent the good part of the last two weekends fixing a similar problem. I'm not sure how big *very* large is in your world is, in mine it was about 3GB. Guide didn't find an error in the file but it would coredump when certain items were "fi"led. Programs trying to

RE: [U2] RE: [UD] CREATE.FILE

2005-03-05 Thread Alfke, Colin
You can simply start with CREATE.FILE SHAWN.TEST 46061,1 and then resize if you're really worried about it. This is pretty much the most room it would take (unless the keys hashed VERY poorly). There are algorithms you can use in the manuals to determine file size. You haven't given enough inf

RE: [U2] [UD] Aix filesystem

2005-03-03 Thread Alfke, Colin
al Message- From: Ken Wallis > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Alfke, Colin > Does anyone know if there is a limit on the size of a > filesystem in Aix?

RE: [U2] [UD] import fixed-width file

2005-03-03 Thread Alfke, Colin
Here is a quick example that should get you started. This is assuming that the records in the file are delimited with a line feed. If not you would have to look at the osopen and osbread commands. OS.FILE = "C:\DATA\MYFILE.TXT" NUM.COLUMNS = 5 COLUMN.WIDTH = 10 UD.FILE = MYFILE * OPEN UD.FILE T

[U2] [UD] Aix filesystem

2005-03-03 Thread Alfke, Colin
Does anyone know if there is a limit on the size of a filesystem in Aix? Aix 5.1 UD 6.0.8 Thanks Colin Alfke Calgary, AB --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UD] D3 Filesave Load on Unidata

2005-03-03 Thread Alfke, Colin
Generally, I would see char(0) problems when the block sizes were different between the devices. I don't recall seeing any char(211)'s though. You may want to try a different block size. It may solve the problem - and be faster. I had a Aix box that I restored the data onto and then I did the a

RE: [U2] HTML printing

2005-02-14 Thread Alfke, Colin
I found these in Word Help (but I also have MSDN and Visual Studio loaded, which may have helped). I will agree that Word doesn't do that great of a job on HTML files - and can really bloat the source. I just thought it may give you better ideas for printing. HTML doesn't usually print at the b

RE: [U2] HTML printing

2005-02-13 Thread Alfke, Colin
Here is some VBScript that will use Word to print a document. Simply pass the document and printer names (or plug them into the script). You can either use whatever terminal emulator you have to execute the script on the Client (of course putting the documents on the client or where the client c

RE: [U2] Universe to Web interface

2005-02-09 Thread Alfke, Colin
Yes, from the Win2000 help: Call Calls one batch program from another without causing the parent batch program to stop. The call command now accepts labels as the target of the call. In this case UDT is in the path, so if the UV/UVSH isn't in your path you would need the full path. If you are

RE: [U2] [UD] Personal Edition - Using the Floppy

2005-02-08 Thread Alfke, Colin
I think I got it to work in the distant past on Win2000 using SETTAPE 1 A: A: 512 Do you need to access the floppy? Can you copy the file to the hard drive and deal with it there? -- Colin Alfke Calgary, Alberta Canada "Just because something isn't broken doesn't mean that you can't fix it"

RE: [U2] Universe to Web interface

2005-02-08 Thread Alfke, Colin
Will; We execute a .bat from the command scheduler every night on UniData. I'm hoping this might point you in the right directions (as I've never tried it on UV nor from an IIS application). The .bat file simple changes to the correct directory and then does a: CALL UD PHANTOM "" The phantom m

RE: [U2] [UD] D3 Filesave Load on Unidata

2005-02-08 Thread Alfke, Colin
Kevin; I've done this lots. 1: Restore tape. Make sure block size on UNIX device is the same as the original tape: lsattr -El rmt0 (according to Pick a "q" device needs a unix blocking factor of 512 while a "d" or "v" device uses 0). Caution restore-accounts hammered the Pick system (needed F

RE: [U2] Universe full screen editor

2005-02-07 Thread Alfke, Colin
Only if you're working in "gui" mode. In character mode it works for VM's (but for some strange reason - perhaps my emulation) it doesn't work for SVM's. Colin Alfke >-Original Message- >From: Marilyn Hilb > >Colin.. Thanks. I did notice that in reading these responses. >That there we

RE: [U2] Universe full screen editor

2005-02-07 Thread Alfke, Colin
SE is an SB+ product. P.S. you can add value marks using the +253 (numeric keypad) combination. Colin Alfke >-Original Message- >From: Marilyn Hilb > >I use SE which is like any windows product, use arrows or >mouse click to move around etc. You'll see the VM's in there. >But in SE

RE: [U2][UD] Using Environmental Variables in VOC...

2005-01-28 Thread Alfke, Colin
If you're going to do this in a program with the GETENV you could simply just OPENSEQ the file then as well and not have to worry about the VOC entry at all. Colin Alfke >-Original Message- >From: Don Verhagen > >It works on UNIX, however, you could have a program get the >environment

RE: [U2][UD] Using Environmental Variables in VOC...

2005-01-28 Thread Alfke, Colin
Try: UDTBIN: DIR @UDTHOME\BIN D_VOC or more specifically: UDT_SAVED_LOGS: DIR @UDTHOME\BIN\saved_logs D_VOC hth Colin Alfke >-Original Message- >From: David Wolverton > >How can I get this to work as I would like: > >

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: http://members.aol.com/_ht_a/mbtraining/index.html";>http://members.aol.com/

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

2005-01-18 Thread Alfke, Colin
Do you mean you're trying to do an <> prompt through an ODBC connection? You're a brave soul. I would prompt for imput in the 3rd party client and pass the full string through... hth Colin Alfke -Original Message- From: Amy Cook I know this issue has been r

RE: [U2] Determining compile date and time

2005-01-18 Thread Alfke, Colin
Look in the directory where they are compiled. The compiled version of the program begins with an underscore. The time/date stamp on that file is the time/date of the last compile for that program. hth Colin Alfke >-Original Message- >From: Bruce Lunt > >Hi All, > >We would like to de

RE: [U2] unidata bci commands not compiling

2005-01-17 Thread Alfke, Colin
We encountered similar errors when doing a "proof of concept" with the new xml functions. The problem is that the documentation has the functions in mixed case but UD won't compile them like that. You have two options: 1. Change SQLBindParameter to SQLBINDPARAMETER etc 2. Compile with the -I o

RE: [U2] Passing parameters to a paragraph?

2005-01-13 Thread Alfke, Colin
The Using Unidata (udtu.pdf) has Chapter 7 UniData Paragraphs that explains inline prompting. You can search for "inline prompt" to find further references. Colin Alfke in 'I can't believe it got even colder' Calgary >-Original Message- >From: Stevenson, Charles > >Wendy, > [snip] >Docu

RE: [U2] Re: WinteGrate

2005-01-12 Thread Alfke, Colin
George might be onto something. In DOS the & character needs to be "escaped" using the ^. Try changing all of the & in the url to ^&. hth Colin Alfke in way too cold Calgary >-Original Message- >From: George Gallen > >do you need to quote the URL? with all those &'s and ?'s maybe >winte

RE: [U2] Named Common Issues in UV

2005-01-11 Thread Alfke, Colin
In UniData (not sure about UniVerse) the named common name is only significant for the first 7 digits. So your VBNOTEPAGE3 will be the same as VBNOTEPAGE1. IE. you may think the name is unique but the system doesn't. The name looks like there might be others with a similar name so this could be

[OT] RE: [U2] How to "exit" out mulitple loops?

2005-01-10 Thread Alfke, Colin
Dang, I hate it when the list is quiet and my e-mail server is slow. Although I hadn't thought of the gosub solution Colin Alfke >-Original Message- >From: Alfke, Colin > >What about using the FOR Q=1 to 6 UNTIL DONE.Q.LOOP form and >then set DONE.Q.LOOP wher

RE: [U2] How to "exit" out mulitple loops?

2005-01-10 Thread Alfke, Colin
What about using the FOR Q=1 to 6 UNTIL DONE.Q.LOOP form and then set DONE.Q.LOOP where you currently have the EXIT. You may be able to use the same variable on each loop - I've never had the occasion to "nest" them before like that. Just don't forget to initialize it to 0 each time through the

RE: [U2] UniData index behavior

2005-01-10 Thread Alfke, Colin
If you're sure these are the only six then you could copy them to a temp file with a (D option and then copy them back - assuming you don't have any triggers that this would confuse. To be very sure you could also delete all of the indices and rebuild them. There is a guide_ndx, I can't remembe

RE: [U2] free txt-to-pdf converter

2005-01-06 Thread Alfke, Colin
>-Original Message- >From: David Wolverton [snip] >So - if it's formatted for use via PCL, you may or may not get >what you want >- we ended up with 'line creep' on most all of the 'free' pdf >products - or >with the rightmost data cut off on really wide/full page >utilized items! [s

RE: [U2] getting undefined errors when varible look defined (UV/unix)

2004-12-20 Thread Alfke, Colin
Right, and the easiest way is to do a MAT DTOTALS = "" after the DIM statement. At least in UniData, hopefully in UV as well. hth Colin Alfke Calgary >-Original Message- >From: George Gallen > >DTOTALS is a two dimensional array, which has been dimensioned, > however, not all the sl

RE: [U2] [UD]WRITESEQ quirkiness

2004-12-17 Thread Alfke, Colin
I've written some pretty big records/files with writeseq that I don't think you're coming anywhere close to. I use the else to notify me in case the system (writeseq append) isn't at the end of the file where I think it should be. Help says that: ELSE executes if the WRITESEQ is not successful

RE: [U2] Data Corruption

2004-12-17 Thread Alfke, Colin
We have a "NULL" save list that we do a get-list and then edit with (if the key is null). If it's not actually null and there aren't too many records you could just ED OP * and go through them all until you find it. Of course, this assumes that there is no actual corruption of the file. In UD

RE: [U2] PE downloads have been pulled from IBM's site

2004-12-17 Thread Alfke, Colin
Marilyn; I'm not sure how different they are - they hadn't been changed in a while. The windows version is a simple "setup.exe" install. Feel free to let me know if you need any further help. Colin Alfke Calgary >-Original Message- >From: Marilyn Osaka > >Hi, I downloaded the files fo

RE: [U2] Capturing screen output in Unidata Enviornment

2004-12-13 Thread Alfke, Colin
I usually just use the tools on my terminal emulator to do this. Otherwise my best suggestion is to write a program that executes the paragraph and use the capturing/returning to get the data. Does that help? Colin -Original Message- From: Bright, Frank Good Morning All: I would like y

RE: [U2] UD file indexing

2004-12-08 Thread Alfke, Colin
I think the key is SB.EXECUTE. Are you trying to create the index at the SB+ TCL prompt or the UniData ECL prompt? Try it from the ECL prompt and make sure nothing has overwritten your create.index verb. If you're using SB+ also make sure that your dictionary works at the ECL level. hth Colin A

RE: [U2] Session Virus ?

2004-12-06 Thread Alfke, Colin
Any new network hardware? I've seen similar type connection problems with a Broadcom Gigabit network card in the server. Colin Alfke in dang cold Calgary >-Original Message- >From: Brutzman, Bill > >Beginning last week, the unthinkable keeps happening. >XP/NT4/Win98 Dynamic >Connect /

RE: [U2] [UD] Conversion tools

2004-11-30 Thread Alfke, Colin
I found some documentation of the conversion utilities in my 1996 version of the UniData manual. It appears to load an account UCONV3 that requires: a C compiler, and the unix lex and yacc utilities. I didn't see a reference to it in my current manuals. I'm not sure what happened to it. Colin A

RE: [U2] Unidata Odbc

2004-11-25 Thread Alfke, Colin
fyi - we've encountered some problems with this on NT. If the user is a member of the administrators group then all members of the administrators group are deemed to be owners of the view and have full permissions. VSG just takes the user that you logged in as. It also appears to change the OS

RE: [U2] Resizing All Files in a System

2004-11-24 Thread Alfke, Colin
I wrote a routine that would run guide with the -R option to create a report file. It then parsed the file and did a memresize on the files that required resizing. I had some logic so that "work" files that were empty weren't resized smaller. It wasn't that hard. I know that when you do an ACCT

RE: [U2] Greetings

2004-11-23 Thread Alfke, Colin
much snippage >-Original Message- >From: Norman Morgan [mailto:[EMAIL PROTECTED] > >I am brand new to UniData after using Pick/D3 >with SB+ for 9 years >Over the last 9 years, I have accumulated about 1000 Basic >programs that I must now convert to UD. I have looked for a >concise li

[U2] RE:

2004-11-19 Thread Alfke, Colin
>-Original Message- >From: George Smith [mailto:[EMAIL PROTECTED] > > >Hi all, > >1. Will Unidata 6.1 run on Solaris and/or Linux. According to https://www-927.ibm.com/software/data/u2/support/u2techconnect/matrix.asp Yes. >2. If you run on the above with the .Net client talk to

RE: [U2] t-load on Unidata

2004-11-19 Thread Alfke, Colin
try: settape 0 \\.\fd0 \\.\fd0 512 (or whatever block size mvBase uses) first to define the device. I have never done this with a floppy, and only once with a tape which took so long I re-did the Pick account save to a "pseudo tape" and did the restore from the file (which I've done lots of tim

RE: Unclassified RE: [U2] SSH and wIntegrate

2004-11-19 Thread Alfke, Colin
Ooops mea culpa. That's what happens when I post in a hurry to get out of the office. Colin Alfke >From snowy Calgary :( >-Original Message- >From: HENDERSON MICHAEL MR [mailto:[EMAIL PROTECTED] > >Unfortunately NOT! > >Ken wants SSH, but wIntegrate and the U2 server products support SSL

RE: [U2] SSH and wIntegrate

2004-11-18 Thread Alfke, Colin
This was in the latest DB2 newsletter: Announcing wIntegrate 6.0 IBM wIntegrate, version 6.0, will be generally available on December 10, 2004. This feature rich release of wIntegrate delivers device independent deployment of MultiValue applications, advanced support of the Secure Sockets Layer

RE: [U2] Unidata and UniBasic training

2004-11-10 Thread Alfke, Colin
Yes, I live in Calgary. I'm in LA for another week. I'll be happy to give you a hand. You can reach me by e-mail at alfke121 - hotmail.com. Hth Colin Alfke Calgary Alberta Currently in sunny LA Celebrity sightings: 1 -Original Message- From: Marilyn Osaka [mailto:[EMAIL PROTECTED] Sent:

RE: [U2] Timeout settings for a phantom job?

2004-11-10 Thread Alfke, Colin
Do you mean no error on the screen, in the error logs, or in the _PH_ file for the phantom process? The _PH_ file is the best place to look first for any notifications. We run a number of these that can run for over 8 hours overnight. Generally the only two problems we have that cause it to stop

RE: [U2] Unidata and UniBasic training

2004-11-10 Thread Alfke, Colin
IBM holds some classes in Denver on occasion or will send someone on-site it you like (read want to pay for it). I may also be able to lend you a hand. Depending on how far north you are Malcolm Bull has a number of really good resources, I have some more in my favourites - but I'm not at h

RE: [U2] Printing an RTF file from Universe

2004-11-08 Thread Alfke, Colin
Could you not execute a statement to print the document by Word? You would have to have it installed on the server and perhaps pay attention to concurrent access but I would think that would be easiest. Depending on your terminal emulator you should also be able to use the Word installed on the cl

RE: [U2] UVODBC conflict

2004-11-08 Thread Alfke, Colin
I think the problem is with the u2*.* programs. I seem to recall there was an issue with SBClient as the licensing DLL started with U2 and conflicted with Crystal as it assumed that all programs that start with U2 belong to Crystal. (Or something silly like that). IBM renamed the DLL that was causi

RE: [U2] Index problem

2004-11-03 Thread Alfke, Colin
I believe it's even in the documentation that UniData will only update an index on the file that is being updated and not any other files that may have an index that references that file. Another work around is to have a trigger on the header file re-file the detail items that reference it so t

RE: [U2] [UD] Files from UD Unix to UD Windows

2004-11-03 Thread Alfke, Colin
Yes, we used to do it all of the time - until we converted most of our Unix clients to Windows. It sounds like you did a binary transfer, but you also may need to run convdata from the O/S command line. help convdata in UD will provide the proper syntax. However the "current language group" err

RE: [U2][UD] merging data - fuzzy keys

2004-11-02 Thread Alfke, Colin
You might want to look at www.parserat.com It's got some tools for extracting address that may help you get it organized Colin Alfke >-Original Message- >From: Amy Cook [mailto:[EMAIL PROTECTED] > >Wow...do you ever have overlap? A bill-to and ship-to with the same >name, and in the

RE: [U2] telnet problem

2004-11-02 Thread Alfke, Colin
The problem is that the address 192.168.1.201 is an "internal" address only. Your LinkSys router is the only thing on the outside that is able to see it. You need to set it up so that when you try connecting to it that it will pass through to your UniData box. Please realize that this is a fairl

RE: [U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST)

2004-11-01 Thread Alfke, Colin
You can use @LOGNAME to get the NT user that the phantom is logged in as. Do you really need to open the same file as the select? You can use fileinfo after you open it to show your permissions on it. What if you tried setting up a different VOC entry for that file? Maybe (but I doubt it) you c

RE: [U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST)

2004-10-29 Thread Alfke, Colin
Perhaps it's the user you're running the phantom as. Maybe there is a permission issue in the list directory. Hth Colin -Original Message- From: Doyen Klein [mailto:[EMAIL PROTECTED] Well suggested Charles and Colin . I had tried all lowercase knowing of the Pick flavor issue, but

RE: [U2][UV]telnet

2004-10-28 Thread Alfke, Colin
Many emulators have scripting built-in. You may have to start a session that automatically runs your script. In effect, your execute statement would start the emulator which would run your script to do what you want. This doesn't really seem like a good solution. If you let the list know what you

RE: [U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST)

2004-10-28 Thread Alfke, Colin
What if you lowercase the first letter of the gET.LIST and mERGE.LIST commands to force them to use the UniData parser? The phantom will go through the login VOC item so make sure you're not exiting it prior to the setup stuff when it's a phantom. Is this a UniData phantom or an SB+ phantom - it

RE: [U2] Trying to run VSG to view data in the test account

2004-10-20 Thread Alfke, Colin
Sorry, I don't have access to my documentation now and I can't remember exactly what 81002 means. One of the key things to remember though is that if you treat EVERYTHING as case-sensitive it solves a lot of problems. Especially the name you have in the uci.config file. There is a required format o

RE: [U2] [OT] LA

2004-10-19 Thread Alfke, Colin
Sure, 181 days without rain - and it has to rain our last day at Disneyland!! Colin Now in sunny Albuquerque -Original Message- From: Allen E. Elwood [mailto:[EMAIL PROTECTED] Sent: Sat 16/10/2004 11:14 AM To: [EMAIL PROTECTED] Cc: S

RE: [U2] [UD] running a subroutine

2004-10-15 Thread Alfke, Colin
Coming from D3 I have a subroutine that lets me input the routine and any arguments so I haven't actually tried it. I do know that you can run a subroutine directly (unlike D3). You could try updating the subroutine to check the variables (if not(assigned(arg1)) and do a tclread Colin Curren

RE: [U2] writeseq

2004-10-14 Thread Alfke, Colin
It's been around for quite a while. I did some basic performance testing vs. writeseq and *if* the optimal settings were used it was a little faster. I didn't think it was enough of a gain to worry about - especially since you need to do testing to get the optimal settings to get it to run faster.

RE: [U2] writeseq

2004-10-13 Thread Alfke, Colin
Or is it something as simple as having the word processor you are using to look at the file wrapping at just the wrong spot. I use writeseq a lot and have never had this problem. My bet is with Kevin's solution Colin -Original Message- From: Kevin King [mailto:[EMAIL PROTECTED] Do

RE: [U2] [UD] udtconfig TMP param

2004-10-07 Thread Alfke, Colin
That would be great for windows as well. With version 6 we noticed a difference in where the temp variable was being pulled from. If you used to set a system variable you were OK - but that is no longer quite true. This caused us a fair bit of grief trying to get the SB+ network file transfer goi

RE: [U2] Fancy Printer

2004-10-06 Thread Alfke, Colin
We did a similar thing. We had some basic routines that we called that set everything up. Print.portrait and print.landscape were the two most common. For the "English" reports we even updated the list and sort verbs to call the routines (we renamed list and sort, made list/sort basic routines tha

RE: [U2] UniData index sort oddness

2004-10-06 Thread Alfke, Colin
Did you change any UDT.OPTIONs? I seem to recall that there was one we had to set to get the proper handling of numbers like 001 - although we weren't working with an index at the time. Sorry, I don't recall which option it was Hth Colin Alfke -Original Message- From: Karjala Koponen

RE: [U2] [UD] - I-Desc IF, THEN, ELSE or SUBR -IFS

2004-09-21 Thread Alfke, Colin
Here is the dict item we use to do precisely this. This is actually built by SB+ so could be cleaned up a bit 001: V 002: @ID; '*'; F1; SUBR('-CATS',REUSE(@2),@3); SUBR('-CATS', REUSE(@1), @4) 003: 004: Remote Key 005: 20L 006: MV Please note that F1 is actually a D type dict in the file an

  1   2   >