[U2] Out of office
I just have one question: Is Richard Taylor out of the office today? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DOWNLOAD 7.13 is available
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Wednesday, September 21, 2005 8:01 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] DOWNLOAD 7.13 is available > > > In a message dated 9/21/2005 5:18:23 AM Pacific Standard Time, > [EMAIL PROTECTED] writes: > > Version 7.13 of DOWNLOAD is available from: > ftp.cedarville.edu > > > Is this freeware? Yep. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] get program name
I don't know about UV, but I use SYSTEM(40) on UD to return the absolute path of the object file currently being executed; then pick out the name from this. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Dianne Ackerman > Sent: Friday, July 29, 2005 11:17 AM > To: U2 List Server > Subject: [U2] [UV] get program name > > > Is there a way in basic to get the name of the program you're in? I want to pass the name of the program to a subroutine > for error reporting and I don't want to have to set a variable PROG.NAME = "THIS.PROG.NAME" in every program. I was > hoping for some kind of @PROGNAME variable, but I can't find one. > Thanks! > -Dianne --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Select on an attribute
I could write a subr to fetch these, but I don't know how to do it with uniquery only. I think Noah is saying that he wants to... SELECT all File2 items if FILE1_ID can be found in the savedlist containing the IDs from File1. In this case, won't BLAH still contain IDs from File1? > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jim Bullock > Sent: Monday, July 25, 2005 10:18 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] [UD] Select on an attribute > > > (If "BLORP" is your savedlist from File1) > GET.LIST BLORP TO 1 > SELECT FILE2 SAVING FILE1_ID TO 2 > MERGE.LIST 1 INTERSECTION 2 TO 3 > SAVE.LIST BLAH FROM 3 > > "BLAH" will contain the IDs you want, if I understand your > question correctly.) > > > --- Noah Hart <[EMAIL PROTECTED]> wrote: > > > Select question: > > > > Assume that I have 2 files, such as customer and invoice > > > > File1: has 1 attribute, ID > > File2: has 2 attributes, ID and FILE1_ID > > > > I have a savedlist with ID numbers from file1. > > > > I want to select all records in file2 which have FILE1_ID > matching the > > savedlist I already have. > > > > Is this possible? > > > > Thank you, > > > > Noah > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > > > > > "...a livable wage is a moral value. Affordable health care > is a moral value. A decent education is a moral value. A > common sense foreign policy is a moral value. A healthy > environment is a moral value. The feeling of community that > comes from full participation in our democracy is a moral > value. It is a moral value to make sure that we do not saddle > our children and grandchildren with our debt." > > -Howard Dean > > __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] New U2 Personal Editions posted
Any special considerations for x86_64? -Original Message- From: Leroy Dreyfuss [mailto:[EMAIL PROTECTED] Sent: Sunday, May 08, 2005 11:24 PM To: u2-users@listserver.u2ug.org Subject: [U2] New U2 Personal Editions posted Folks, UniVerse 10.1.11 PE has been posted to the Website, as well as UniData 6.1.9. Both are for Windows. UniData 6.1.10 PE for Linux (x86) has also been posted. UniVerse 10.1 PE for Linux (x86) will be posted in a week or two, when it's ready. You will find them at http://www.ibm.com/software/u2/, where under the Highlights section is a graphic that links to the U2 Trials and Betas site. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Weird looking record
This is what's there: ^013// Thanks, Gentlemen. -Original Message- From: Shawn Waldie Sent: Thursday, March 31, 2005 12:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] Weird looking record Notice field #14 below. What would cause it to display like that? AE PERSON 177 Top of "177" in "PERSON", 141 lines, 393 characters. *--: P 001: 002: 003: 004: 005: 006: 162 007: 008: 009: 010: 011: 012: F 013: //4: 015: 016: import The DICT item is defined as: AE DICT PERSON BIRTH.DATE Top of "BIRTH.DATE" in "DICT PERSON", 6 lines, 52 characters. *--: P 001: D Date this person was born 002: 14 003: D4/MDY 004: Birthday 005: 10R 006: S Bottom. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Weird looking record
Notice field #14 below. What would cause it to display like that? AE PERSON 177 Top of "177" in "PERSON", 141 lines, 393 characters. *--: P 001: 002: 003: 004: 005: 006: 162 007: 008: 009: 010: 011: 012: F 013: //4: 015: 016: import The DICT item is defined as: AE DICT PERSON BIRTH.DATE Top of "BIRTH.DATE" in "DICT PERSON", 6 lines, 52 characters. *--: P 001: D Date this person was born 002: 14 003: D4/MDY 004: Birthday 005: 10R 006: S Bottom. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [ud] TRANS
Scenario: Say I'm LISTing from file1 and I want to return the value of field4 from file4...and I have to go through 2 "intermediate" files to get what I need. I define an idesc like: TRANS('file2',pointer,'field2','X');TRANS('file3',@1,'field3','X');TRANS ('file4',@2,'field4','X') ...and field2 is mv'd. I would probably write a subr for this in most cases, but I just wanted to see what the list had to say. What are the gotchyas, and are there some other UD function combos that can do this job more efficiently? TIA * * Shawn Waldie Programmer/Analyst * * SUNGARD Collegis, Inc. * * serving * * San Juan College * * 4601 College Blvd * * Farmington, NM 87402 * * Email: [EMAIL PROTECTED] * * Phone: (505)566-3072* * --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: [UD] CREATE.FILE
I don't think it will take that much room to store this once all the extra spaces are removed. -Original Message- From: Shawn Waldie Sent: Friday, March 04, 2005 10:03 PM To: 'u2-users@listserver.u2ug.org' Subject: [UD] CREATE.FILE I have fixed-width records in a text file that I want to import to a UD hashed file, but have to create this file first. If the text file is 46,061 KB, and the UD file would not be added to, what "CREATE.FILE" specs should I use to create this file? TIA Shawn --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] CREATE.FILE
I have fixed-width records in a text file that I want to import to a UD hashed file, but have to create this file first. If the text file is 46,061 KB, and the UD file would not be added to, what "CREATE.FILE" specs should I use to create this file? TIA Shawn --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] import fixed-width file
Would anyone be willing to share an algorithm that imports a fixed-width text file to UD? TIA Shawn --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] EVAL keyword -- was: uv pe
That works. Thank you. SW -Original Message- From: Martin Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, February 18, 2005 12:31 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] EVAL keyword -- was: uv pe For some reason (a bug?), the var syntax does not work in Unidata I-types and hence EVAL expressions. You need to write this as EVAL "EXTRACT(@RECORD,n,0,0)" Maybe one day someone will fix this. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] EVAL keyword -- was: uv pe
I tried the 'EVAL "@RECORD"', but can't seem to get it to work. I've always had to resort to referencing the DICT ID for that loc, and we're using UD. Is there an options setting that would enable this for me? SW -Original Message- From: Pingilley, Ron [mailto:[EMAIL PROTECTED] Sent: Friday, February 18, 2005 9:00 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] EVAL keyword -- was: uv pe John, Per the Unidata 6.1 manual on the IBM web site: EVAL Syntax EVAL "expression" Description --- The UniQuery EVAL keyword allows you to define a virtual attribute expression for the current execution of a UniQuery statement only. expression can be any expression valid in a virtual attribute. You must enclose expression in single or double quotation marks. Note: UniQuery only supports the EVAL keyword in ECLTYPE U. -- You could do something like this (at least in UniVerse :) SELECT blah WITH EVAL "UPCASE(@RECORD)" LIKE "...HELLO..." That would create an on-the-fly virtual field for the comparison. --Ron P. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] i-desc mystery
Thanks, Charles. I should have known betterthe CATS function just came to mind. I assumed that since XPTD.POSITION.ID was defined as mv'd, the system would handle that aspect of it. -Original Message- From: Stevenson, Charles [mailto:[EMAIL PROTECTED] Sent: Friday, January 21, 2005 7:35 PM To: u2-users@listserver.u2ug.org Cc: Shawn Waldie Subject: RE: [U2] [UD] i-desc mystery 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 marks anywhere in the array. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] i-desc mystery
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 20104415235340 14.00 13515*H*559*1 1270TPFACMGR_2 TPFAC 10103612705450 23.88 1270TPFACMGR_210176849755458 23.87 13515*H*0001222*1 1900CLCINST_2 CLCIN 10105019005233 0.00 1900CLCPRODE_210105019005450 31.50 Given the following definitions: AE DICT PAYTODAT PTD.POSITION.ID Top of "PTD.POSITION.ID" in "DICT PAYTODAT", 7 lines, 87 characters. *--: P 001: D The position ID associated with the earnings line item. 002: 75 003: 004: Position ID 005: 14L 006: M 007: PTDEARN Bottom. AE DICT PAYTODAT XPTD.POSITION.ID Top of "XPTD.POSITION.ID" in "DICT PAYTODAT", 9 lines, 104 characters. *--: P 001: I 002: PTD.POSITION.ID[5,5] 003: 004: 005: 6L 006: M 007: PTDEARN Bottom. Why does XPTD.POSITION.ID show only single-values? I expected this list to look, instead, like: PAYTODAT.. Position ID... XPTD.P Earnings Acct Hours... 13515*H*076*1 1523PTINST_2 PTINS 10104414705340 14.00 1523PTINST_2 PTINS 20104415235340 14.00 13515*H*559*1 1270TPFACMGR_2 TPFAC 10103612705450 23.88 1270TPFACMGR_2 TPFAC 10176849755458 23.87 13515*H*0001222*1 1900CLCINST_2 CLCIN 10105019005233 0.00 1900CLCPRODE_2 CLCPR 10105019005450 31.50 ******** * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * * * * HP-UX 11.11 UniData 6.0.4Colleague R17 * --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Precision
My thanks to all for the responses. Shawn -Original Message- From: Shawn Waldie Sent: Tuesday, November 30, 2004 1:37 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Precision I see a strong potential for "penny-creep" here unless I add/truncate some zeros before/after I make calculations. I would like to minimize this as much as possible; and I thought there might be a convention/standard that others are using. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Precision
I see a strong potential for "penny-creep" here unless I add/truncate some zeros before/after I make calculations. I would like to minimize this as much as possible; and I thought there might be a convention/standard that others are using. -Original Message- From: Kevin King [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 12:55 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Precision Define "a little more rigorous"? Other than some rounding/truncation issues, what exactly are you going for? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Precision
I need some help from you payroll pros out here. Background: I've developed a subroutine that will read an "externally-maintained" dir-type file (insurance prem. table) for every employee when payroll is run. This table contains monthly insurance premiums for different types of covereage, i.e., 27748 64074 76278 29236 68088 80620 33368 75076 89396 538 10161494 178822772342 The OCONV() for these is "MD2". The subroutine will find the appropriate premium in this table based on other criteria. Pertinent part: -Based on the employees' salary, the employer will pay either 80, 70, or 60 percent of this premium; with the employee paying the difference. -The Paychecks are issued semi-monthly. Here's my logic so far: MO.PREM = PREM.TBL BEGIN CASE CASE X.SALARY LT 3; * Employer pays 80% X.EMPLYR.AMT = MO.PREM * 8 / 10 X.EMPLYE.AMT = MO.PREM - X.EMPLYR.AMT CASE ((X.SALARY GE 3) AND (X.SALARY LT 4)); * Employer pays 70% X.EMPLYR.AMT = MO.PREM * 7 / 10 X.EMPLYE.AMT = MO.PREM - X.EMPLYR.AMT CASE X.SALARY GE 4; * Employer pays 60% X.EMPLYR.AMT = MO.PREM * 6 / 10 X.EMPLYE.AMT = MO.PREM - X.EMPLYR.AMT CASE 1 END CASE * Divide these amounts by two since since employees are payed twice per month. X.EMPLYR.AMT = X.EMPLYR.AMT / 2 X.EMPLYE.AMT = X.EMPLYE.AMT / 2 This is all working out satisfactorily, but I want to ensure that the accounting folks are happy at the end of the year, so I need something a little more rigorous. The internal format of X.EMPLYR.AMT & X.EMPLYE.AMT that is returned to the calling process must be such that if viewed 'externally', the conversion would MD2 For example, if the monthly premium is 425 Monthly premium: $425 Employer (mo)..: 340 - 80% Employee (mo)..: 85 - 20% Per check - Employer: $170 Employee: 42.50 X.EMPLYR.AMT = 17000 X.EMPLYE.AMT = 4250 Suggestions welcome! ******** * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] running a subroutine
I've always used some variation of most of these approaches to test my subroutines. I was hoping there might be a more efficient (read easier - I'm getting lazy) way. I see a couple that I need to take a stab at. Thanks, everyone. Shawn --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] running a subroutine
Wondering if there is a way to execute a subroutine from the colon prompt. Let's say I have a subroutine that is defined as having 2 input args like: SUBROUTINE subr.name(arg1,arg2). I would like to test it from the colon prompt without having to hard-code the values of arg1/arg2...something like: :RUN BP subr.name "value.of.arg1" "value.of.arg2" Is something like this possible? What I've tried so far hasn't worked. **** * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * * * * HP-UX 11.11 UniData 6.0.4Colleague R17 * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: gvim on UD
Before I tried gvim, I used UniDebugger to edit code on my windows pc, then ftp'd it over to the unix host. I always express ascii mode when making these transfers, and did the same after using gvim to edit. The CR was still there. -Original Message- From: Scott Ballinger [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 11:05 AM To: [EMAIL PROTECTED] Subject: RE: [U2] RE: gvim on UD Instead of changing your windows gvim configuration, you could ftp as ascii instead of binary- that will convert crlf to lf when sending from dos to unix (and vice-versa). Scott Ballinger Pareto Corporation Edmonds WA USA 425 670 0831 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: gvim on UD
With gvim, I'm editing on my windows pc; then I ftp the source over to the unix host. I'll give Paul's suggestion a shot. -Original Message- From: Ken Wallis [mailto:[EMAIL PROTECTED] Sent: Thursday, October 07, 2004 5:20 PM To: [EMAIL PROTECTED] Subject: RE: [U2] RE: gvim on UD Where are you editing the programs with gvim? On a windows box somewhere, or on UNIX? If running on windows, but accessing a unix file, then you may find that gvim has decided to put in a CRLF instead of just a linefeed at the end of each line. gvim is infinitely configurable, and I'm sure there'll be a way to make it behave the way you need it to. Cheers, Ken --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: gvim on UD
Hi Allen. Your assumption is correct. Gvim is the gui-vim (I think). I fixed my program by editing it with AE: SB startline finishline CB/^013// The compiler didn't have any more problems. There must be a way to keep vim from entering a CHAR(13) after every line. I just haven't found it yet. -Original Message- From: Allen E. Elwood (CA) [mailto:[EMAIL PROTECTED] Sent: Thursday, October 07, 2004 3:00 PM To: [EMAIL PROTECTED] Subject: RE: [U2] RE: gvim on UD I don't know what gvim is, but if you're getting compiler errors on blank lines, just change them to *. I'm assuming that you put the blank lines in to make the code more readable? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: gvim on UD
This may be common knowledge to most of you, but I just looked at a program that I wrote without gvim and there are no CRs. So the million dollar question is: how do I keep those from existing when editing with gvim/vim? -Original Message- From: Shawn Waldie Sent: Thursday, October 07, 2004 1:23 PM To: '[EMAIL PROTECTED]' Subject: gvim on UD I modified a program using gvim (for the first time) this morning, but the compiler returns several errors, the first of which is due to a line with nothing but a CR. I obviously need to tweak something. Has anyone out here encountered this? **** * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * * * * HP-UX 11.11 UniData 6.0.4Colleague R17 * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] gvim on UD
I modified a program using gvim (for the first time) this morning, but the compiler returns several errors, the first of which is due to a line with nothing but a CR. I obviously need to tweak something. Has anyone out here encountered this? * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * * * * HP-UX 11.11 UniData 6.0.4Colleague R17 * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD]
Yes, but I have several subroutines that will be very similar and this will allow me to return values based on the name of the subroutine being called...and I can keep the mods made to each to a minimum. -Original Message- From: Jamnadas, Bhupendra [mailto:[EMAIL PROTECTED] Sent: Monday, October 04, 2004 2:23 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] But wouldn't one know the name of subroutine that the code is getting executed? Have define a variable with a value that is the name of the subroutine and read this variable whenever one needs to use the subroutine name anywhere within the code. BJ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD]
Is there a way to reference the name of a subroutine within the code of said subroutine? For example: FIRST.FOUR.CHARS.OF.SUBR = name.of.subr[1,4] TIA * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * * * * HP-UX 11.11 UniData 6.0.4Colleague R17 * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UD] Create file/record if it does not exist
If you're using Datatel's Colleague, you may want to check their subrs for opening/closing/reading, etc. sequential files: S.OPEN.SEQ S.READ.SEQ S.WRITE.SEQ S.CLOSE.SEQ -Original Message- From: Chauhan, Savita [mailto:[EMAIL PROTECTED] Sent: Monday, September 20, 2004 3:37 PM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] Create file/record if it does not exist This is how I open my file. X.EXT.FILE = '_HOLD_/XHR.PLINK.BENDED.EXTRACT' OPENSEQ X.EXT.FILE TO f.xhr.plink.bended.extract ELSE ERR.MSG = "Error Opening XHR.PLINK.BENDED.EXTRACT. Error code ":STATUS() CRT ERR.MSG RETURN END This code aborts with a status() of 0 if the file/record doesn't exist under the _HOLD_ dicrecotry. The successful read is 0 too. So I don't know how to check the existence or non-existence of this file/record. Please help. Thanks. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniDebugger won't let me in.
Ok, folks, I think I know at least part of the "why". My DBA, who is out today, is testing LDAP to authenticate users logging into the unix box against the network AD. Because of this, I know longer have my own /home directory. To make a connection using uniobjects, is my /home directory required? If so, is there a work-around. TIA Shawn ...and apologies for the previous blank. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniDebugger won't let me in.
-Original Message- From: Shawn Waldie Sent: Thursday, September 16, 2004 1:17 PM To: [EMAIL PROTECTED] Subject: RE: [U2] UniDebugger won't let me in. I recently changed my password. However, only when I attempt to access my source code using UDB am I denied...so I know it can't be a permissions problem. I'll try changing my password. So it looks like the user/password you are using on the "editor" side isn't valid or doesn't have the correct permissions to access the account. I did have some trouble with an example project that I got from IBM not liking certain characters in the password. I haven't seen that type of trouble with the UniDebugger but at this point it's worth a shot --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniDebugger won't let me in.
I recently changed my password. However, only when I attempt to access my source code using UDB am I denied...so I know it can't be a permissions problem. I'll try changing my password. So it looks like the user/password you are using on the "editor" side isn't valid or doesn't have the correct permissions to access the account. I did have some trouble with an example project that I got from IBM not liking certain characters in the password. I haven't seen that type of trouble with the UniDebugger but at this point it's worth a shot --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniDebugger won't let me in.
I'm good here, too. -Original Message- From: kafsat taiyus [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 4:41 PM To: '[EMAIL PROTECTED]' Subject: RE: [U2] UniDebugger won't let me in. Permission on the source code. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniDebugger won't let me in.
This is what's so strange. I can log in through other "windows". I have UniDebugger running right now, and I can access my source code through the wIntegrate pane (on the right). However, I get the error message when I attempt to access my source code with the editor pane (on the left). I've always used uniobjects in the past, but ftp won't work either. I can even telnet in from the cmd line of my workstation. -Original Message- From: Adrian Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, September 16, 2004 1:06 AM To: [EMAIL PROTECTED] Subject: RE: [U2] UniDebugger won't let me in. If you have wIntegrate installed then UniDebugger uses that for the embedded terminal window rather than Dynamic Connect (which is a stripped down wIntegrate). A long winded way of saying that if you can already log on and edit the source code in wIntegrate then it should be fine in UniDebugger. It's not as basic as having the wrong username/password in the UniDebugger settings? You can change your view to "host" mode and login with the telnet client UniDebugger users - some sort of stripped Dynamic Connect. You may have a connection script setup that is incorrect. Or is this when you are trying to read your source code? If you are on HP-UX then you will need to use either ftp or UniObjects to grab your code from the server. Your user may not be setup to ftp into the server. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniDebugger won't let me in.
I can log in using wintegrate, and I can even telnet in, but an error message is returned stating "invalid username or password" when I try to access my source code using unidebugger. Any suggestions on where to look first? TIA **** * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * * * * HP-UX 11.11 UniData 6.0.4Colleague R17 * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Can't find a character in my source code
That's what I love about this line of work...and this list: you learn something new just about every day. It turns out that Unidata has the same feature, and it took me right to the culprit...on line 258. Thanks, everyone. Shawn -Original Message- From: Stevenson, Charles [mailto:[EMAIL PROTECTED] Sent: Friday, September 10, 2004 12:39 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Can't find a character in my source code On UV, I would compile it with the -X option and then look at the cross-reference map. >BASIC BP PGM -X >ED BP.L PGM ---: F X That would show all lines where variable X is referenced, assigned, etc. I think you have something similar in UD. cds --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Can't find a character in my source code
The program will successfully compile, but it gives me a warning stating that "Variable 'X' never assigned a value"; but I don't see it. With AE, I would like to use 'L' to find it, so was wondering if I can enforce a pattern with it, i.e. 'X' and only 'X'. TIA **** * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Precision question...
...and real-world examples REALLY help drive the concept home. Thanks again. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, August 27, 2004 7:53 AM To: [EMAIL PROTECTED] Subject: Re: [U2] Precision question... If you recall, the "decimal" portion of a number can be represented as a sum of negative powers of 10 (e.g., .58 = (5 * 10^-1) + (8 * 10^-2)). In a binary storage system, this must be converted to negative powers of 2. A close approximate value using 10 bits is 2^-1 + 2^-4 + 2^-6 + 2^-9 = (0.5 + 0.0625 + 0.015625 + 0.001953125) = 0.58078125 Even if I increase the binary precision, I would still have that trailing 25 at the far end of my representation. While this might not seem significant, when you total hundreds, thousands or millions of transactions, you will eventually be off in a significant digit. Accountants don't like that... --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Precision question...
He has a way of doing that. The reason for storing a unix date is certainly intuitive. However, I was unaware that integer math could be performed more quickly. Thanks for the clarificationmom. 8^) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Debster Sent: Friday, August 27, 2004 9:09 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Precision question... Chuck you said it all so eloquently, meI would have gotten flustered and replied with the unadorned Mommy answer (especially since my son's name is Sean) "Just Because..." --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Precision question...
Since storage space is relatively cheap these days, what's the advantage of storing numbers without decimal points? Or is that not even the issue? -Original Message- From: Allen E. Elwood (CA) [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 1:46 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Precision question... Ahh...apparently the system you work with is actually storing the decimal point. The systems I've worked with do not store the actual decimal point, so therefore the MD82 dealy-bob wouldn't be applicable. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UNIDATA - SAVING UNIQUE and LIST.ALGEBRA
Disregard if this doesn't answer the pertinent question. To save all unique pointers to ROOM.ASSIGNMENT from PST.ROOM.ASSIGNMENTS: SELECT PERSON.ST BY.EXP PST.ROOM.ASSIGNMENTS SELECT PERSON.ST REQUIRE.SELECT SAVING UNIQUE PST.ROOM.ASSIGNMENTS SAVE.LIST UNIQUE.ROOM.ASSIGNMENT.IDS This should produce a SAVEDLISTS record with one ROOM.ASSIGNMENT.ID per attribute. -Original Message- From: Philippe Parent [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 9:48 AM To: [EMAIL PROTECTED] Subject: RE: [U2] UNIDATA - SAVING UNIQUE and LIST.ALGEBRA I checked the dict and AE'd a few records and it only contains ROOM.ASSIGNMENT IDs. The saving unique seems to be placing the extra info... Phil --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Sorting
There is obviously a consensus here. A LOCATE/INSERT loop it shall be. Thanks so much, gentlemen. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Waldie Sent: Friday, August 20, 2004 9:46 AM To: [EMAIL PROTECTED] Subject: [U2] [UD] Sorting I have records that contains a mv list of dates, i.e., 13200:@VM:13312:@VM:13176. I need to store these values in ascending order, so I: a) convert the VMs to AMs, b) perform a FORMLIST, SAVE.LIST, SORT.LIST; and c) load the values back into the attribute. There has to be a more efficient way. Any suggestions? TIA * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * * * * HP-UX 11.11 UniData 6.0.4Colleague R17 * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Sorting
Thank you for your thoughts, gentlemen. This is what I wrote before the suggestions reached me: WRITELIST XL.NEW.LIST ON X.SAVEDLIST EXECUTE X.SORT.SAVEDLIST GETLIST X.SAVEDLIST TO 1 THEN READLIST XL.SORTED.DATES FROM 1 ELSE XL.SORTED.DATES = "" END CLEARSELECT 1 END SWAP @AM WITH @VM IN XL.SORTED.DATES DELETELIST X.SAVEDLIST But I'll change it if it's much less efficient. What do ya think? -Original Message- From: Shawn Waldie Sent: Friday, August 20, 2004 9:46 AM To: [EMAIL PROTECTED] Subject: [U2] [UD] Sorting I have records that contains a mv list of dates, i.e., 13200:@VM:13312:@VM:13176. I need to store these values in ascending order, so I: a) convert the VMs to AMs, b) perform a FORMLIST, SAVE.LIST, SORT.LIST; and c) load the values back into the attribute. There has to be a more efficient way. Any suggestions? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Sorting
I have records that contains a mv list of dates, i.e., 13200:@VM:13312:@VM:13176. I need to store these values in ascending order, so I: a) convert the VMs to AMs, b) perform a FORMLIST, SAVE.LIST, SORT.LIST; and c) load the values back into the attribute. There has to be a more efficient way. Any suggestions? TIA * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * * * * HP-UX 11.11 UniData 6.0.4Colleague R17 * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
FW: [U2] How do we get unique records from Universe file(Table)
OR :SELECT file1 SAVING EVAL "ATTRx:'*':ATTRy" -Original Message- From: Shawn Waldie Sent: Thursday, August 12, 2004 2:53 PM To: '[EMAIL PROTECTED]' Subject: RE: [U2] How do we get unique records from Universe file(Table) Try :SELECT file1 SAVING EVAL "ATTRx:ATTRy" where ATTRx:ATTRy is the the key to file2 >SELECT file2 REQUIRE.SELECT SAVING UNIQUE @ID --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do we get unique records from Universe file(Table)
Try :SELECT file1 SAVING EVAL "ATTRx:ATTRy" where ATTRx:ATTRy is the the key to file2 >SELECT file2 REQUIRE.SELECT SAVING UNIQUE @ID -Original Message- From: Chauhan, Savita [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 1:53 PM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) Yes, I am trying to build a key to another file. I tired what some of you suggested. It gives me an error. On : SELECT ORDERS SAVING UNIQUE EVAL "MFG.NO:'*':PART.NO" It gives me following error: : Illegal attribute name for sort: MFG.NO:'*':PART.NO Btw, my doubts are related to Unidata. I have been working on UniData/UniBasic only for 3 weeks now and I presumed that Universe and Unidata have similar syntax. Excuse me for my ignorance, if it works only for Universe and not for Unidata. Savita Chauhan, Programmer/Analyst x:1754 Central Texas College. --- Change is the only Constant. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Waldie Sent: Thursday, August 12, 2004 2:24 PM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) Are trying to build a key to another file? -Original Message- From: Chauhan, Savita [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 11:56 AM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) Can this (selecting only those order IDs which have unique combination of Mfg.No and Part.No) be done "without" having to create an intermediate dictionary item? Savita Chauhan, Programmer/Analyst x:1754 Central Texas College. --- Change is the only Constant. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do we get unique records from Universe file(Table)
Are trying to build a key to another file? -Original Message- From: Chauhan, Savita [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 11:56 AM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) Can this (selecting only those order IDs which have unique combination of Mfg.No and Part.No) be done "without" having to create an intermediate dictionary item? Savita Chauhan, Programmer/Analyst x:1754 Central Texas College. --- Change is the only Constant. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] READU
My thanks to all! Using a dimensioned array was the answer. -Original Message- From: Karjala Koponen [mailto:[EMAIL PROTECTED] Sent: Monday, July 19, 2004 3:09 PM To: [EMAIL PROTECTED] Subject: Re: [U2] [UD] READU Shawn, Somebody else will undoubtedly answer more technically but a file variable is a beast you cannot put in a dynamic array and expect to be read correctly. Use a dimensioned array. Karjala --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] READU
I'm attempting to use READU in the following fashion, but the code won't compile. However, all is well and runs well when I replace File.Vars with f.var1 - in the READU statement. ERROR.RET = "" ERROR.MSG = "" f.var1= "" CALL OPEN.FILE(f.var1,"actual file name",ERROR.RET,ERROR.MSG) File.Vars<1> = f.var1 File.Vars<2> = f.var2 FOR I = 1 TO I.END READU R.record FROM File.Vars,rec.ID THEN ...load attribute vars END NEXT I The compiler returns this message: main program: syntax error at or before READU R.record FROM File.Vars,rec.ID THEN ^ Expecting: ELSE Suggestions are most welcome. **** * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * * * * HP-UX 11.11 UniData 6.0.4Colleague R17 * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Cedarville Download Program
Use to use it all the time, and loved it. -Original Message- From: Dave S [mailto:[EMAIL PROTECTED] Sent: Friday, July 16, 2004 10:19 AM To: U2 USERS Subject: [U2] Cedarville Download Program I was wondering if anyone here is using the Cedarville Download program. We installed it on a test server running Unidata and are very impressed with it so far. ftp://ftp.cedarville.edu/download/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: Subject: RE: [U2] Cost of Oracle vs PICK
Thanks, James. That's a thorough explanation. I don't know 1st-hand what a copy of Oracle costs (+ user licenses & maint.), but from what I've heard, the cost difference alone would make me lean more toward giving Unidata a shot - especially considereing most schools don't have a lot of money to play around with. -Original Message- From: Yeatrakas,James [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 6:36 AM To: [EMAIL PROTECTED] Subject: Subject: RE: [U2] Cost of Oracle vs PICK effort they are expending on this is the kind of response that other companies in the same predicament might consider to stay viable in the 21st century. I believe had they not chosen this path, competitors with less name recognition, but with more 'current' technology would have begun to steal their market. This was borne out by the grumbling at the user group conferences. Now at least, the users are willing to see what they come up with for the future. Though not what you would consider a 'developer' I have enough experience working with SQL to know I much prefer writing code in UniBasic (RevBasic?) then PLSQL or doing interminable joins when I could be building simple Symbolics. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: Subject: RE: [U2] Cost of Oracle vs PICK
Oops. Apologies. That was suppose to go to James. -Original Message- From: Shawn Waldie Sent: Wednesday, May 19, 2004 8:31 AM To: '[EMAIL PROTECTED]' Subject: RE: Subject: RE: [U2] Cost of Oracle vs PICK Thanks, James. That's a thorough explanation. I don't know 1st-hand what a copy of Oracle costs (+ user licenses & maint.), but from what I've heard, the cost difference alone would make me lean more toward giving Unidata a shot - especially considereing most schools don't have a lot of money to play around with. -Original Message- From: Yeatrakas,James [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 6:36 AM To: [EMAIL PROTECTED] Subject: Subject: RE: [U2] Cost of Oracle vs PICK effort they are expending on this is the kind of response that other companies in the same predicament might consider to stay viable in the 21st century. I believe had they not chosen this path, competitors with less name recognition, but with more 'current' technology would have begun to steal their market. This was borne out by the grumbling at the user group conferences. Now at least, the users are willing to see what they come up with for the future. Though not what you would consider a 'developer' I have enough experience working with SQL to know I much prefer writing code in UniBasic (RevBasic?) then PLSQL or doing interminable joins when I could be building simple Symbolics. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] Cost of Oracle vs PICK
It looks like 'ignorant' might be a better descriptor than 'naove'. 8^) ...but still, aren't there any mv-type systems that can bring this "guarantee" to the table? -Original Message- From: James Canale, Jr. [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 2:38 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Cost of Oracle vs PICK You may not, but many companies do care about the tools/methods that a vendor uses. For instance, companies involved in the healthcare industry need to know how their vendors systems handle data collection, privacy/security concerns, and conformity to government regulations. If they use an application that has gone through regulatory testing already, it provides a benefit as opposed to having to start from scratch to make sure it is an adequate solution. Regards, Jim --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] Cost of Oracle vs PICK
...should this be on the other list? Maybe I'm just naove, but it comes as a surprise to me that a prospect considering to buy what I have to sell them would be concerned with the tools I use to make the delivery, including IT. If I were on the buying end, I think I would only be concerned with 1)the quality of the product/service, 2)the cost, 3)on-time delivery. I couldn't care less about the methods/tools the vendor used to make that happen...unless, of course, they were exploiting child labor, or something dreadful like that -Original Message- From: James Canale, Jr. [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 12:04 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Cost of Oracle vs PICK To me, this means that if you are going to use your database/application as your primary competitive edge, it is certainly worth the effort to go all out (you win, all others lose). If it is not and you will focus on other differentiators, then it does make sense to not be different and go with what everyone else is doing (can't lose - move on). Regards, Jim --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] MV Fad
For reasons detailed on this list in many previous posts, I see lack of constraints in MV as a benefit. Since their presence is necessary, they can be built in to the app. I look at MV as sort of the libertarians (in the U.S. anyway) of DBMSs - there's a lot of freedom so discipline is required in order to thrive. But for those who "feel" safer with significantly more restrictions, then MV is probably not for you. -Original Message- From: Jeremy Adell [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 12:35 PM To: [EMAIL PROTECTED] Subject: RE: [U2] MV Fad Stiletos? Pink shoes? i can definitely see what these two have in common with a database:) I've heard that PICK programmers are too arrogant to recognize a threat...maybe that is why their database is losing to Oracle?:) Of course now I will be labelled a heretic by the 12th century Catholic Church of database programmers, but really, look at those who designed the pick systems. To last at anything, you have to be realistic about your threats and weaknesses. Look at a legacy Oracle system with required database standards built in and compare it to a PICK db with no standards and 20 years of maintenance. At the PICK convention in Vegas this year, maybe 500 people showed up. I heard 5 years ago there more like 5,000. Sound like a fad anyone? Maybe IBM can fix it. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users