Re: [U2] 2gig limit sticking into bash shell
ulimit is a limit on system resources that can be set on a per user base. This command is on all versions of *nix that I know of. Depending on the operating system the values under the ulimit may differ. Dan Goble Sr. Programmer Analyst -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, July 06, 2009 2:23 PM To: U2 Users List Subject: Re: [U2] 2gig limit sticking into bash shell I'm on UV 10.0.2 on Redhat, I did a shell, and my ulimit was unlimited. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, July 06, 2009 1:57 PM To: U2 Users List Subject: Re: [U2] 2gig limit sticking into bash shell Symeon: Would you consider this a bug? I wonder if the same problem exists on Windows? Bill Symeon Breen said the following on 7/6/2009 8:07 AM: Yes that is the one - ulimit -f is unlimited but when i shell out of udt it is set to 2gig, so i just need to reset this in my command So from tcl i have !ulimit -f unlimited;unzip UPLOAD/000855.zip And this works ! :) Thanks. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: 06 July 2009 14:59 To: U2 Users List Subject: Re: [U2] 2gig limit sticking into bash shell You may want to check the ulimit for the user. Shell down to Unix and perform a ulimit -f this will tell you if there is a max file size set on this specific user. Dan Goble Sr. Programmer Analyst RATEX Business Solutions, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, July 06, 2009 6:01 AM To: 'U2 Users List' Subject: Re: [U2] 2gig limit sticking into bash shell Thanks for the pointers, Sorry i mislead you a bit - when i tried this myself it does indeed work if you come out of udt and run it, it is only if you shell out from within udt that it fails. The set command before and while in udt shows quite a few diffs, these mainly look to be udt config params tho :- diff set.out set2.out 2c2,9 BASH=/bin/bash --- AIMG_BUFSZ=102400 AIMG_FLUSH_BLKS=2 AIMG_MIN_BLKS=10 ARCHIVE_TO_TAPE=0 ARCH_FLAG=0 ARCH_WRITE_SZ=0 AVG_TUPLE_LEN=4 BASH=/bin/sh 8a16,20 BGINPUTTIMEOUT=0 BIMG_BUFSZ=102400 BIMG_FLUSH_BLKS=2 BIMG_MIN_BLKS=10 BPF_NFILES=80 10c22,24 COLORS=/etc/DIR_COLORS.xterm --- CENTURY_PIVOT=1930 CHECK_HOLD_EXIST=0 CHKPNT_TIME=300 11a26,27 COMPACTOR_POLICY=1 CONVERT_EURO=0 12a29 EFS_LCKTIME=0 14a32,34 EXPBLKSIZE=16 FCNTL_ON=0 GLM_MEM_SEGSZ=4194304 15a36,37 GRPCMT_TIME=5 GRP_FREE_BLK=5 23c45,46 IFS=$' \t\n' --- IFS=' ' 24a48,49 JRNL_MAX_FILES=400 JRNL_MAX_PROCS=1 25a51,52 KEYDATA_MERGE_LOAD=40 KEYDATA_SPLIT_LOAD=95 26a54,55 LB_FLAG=1 LCT_NUM=8 29a59 LOCKFIFO=0 34a65,102 MAX_CAPT_LEVEL=2 MAX_DSFILES=1000 MAX_FLENGTH=1073741824 MAX_LRF_FILESIZE=134217728 MAX_NEXT_HOLD_DIGITS=4 MAX_OBJ_SIZE=307200 MAX_OPEN_FILE=500 MAX_OPEN_OSF=100 MAX_OPEN_SEQF=150 MAX_REP_DISTRIB=1 MAX_REP_SHMSZ=33554432 MAX_RETN_LEVEL=2 MERGE_LOAD=40 MGLM_BUCKET_SIZE=50 MIN_MEMORY_TEMP=64 NFA_CONVERT_CHAR=0 NFILES=1019 NSEM_PSET=8 NULL_FLAG=0 NUSERS=40 N_AFT=200 N_AFT_BUCKET=101 N_AFT_MLF_BUCKET=23 N_AFT_SECTION=1 N_AIMG=2 N_ARCH=2 N_BIG=233 N_BIMG=2 N_FILESYS=200 N_GLM_GLOBAL_BUCKET=101 N_GLM_SELF_BUCKET=23 N_PARTFILE=500 N_PGQ=10 N_PUT=8192 N_REP_OPEN_FILE=8 N_SYNC=0 N_TMAFT_BUCKET=19 N_TMQ=10 39a108 PART_TBL=/usr/ud71/parttbl 41,44c110,113 PIPESTATUS=([0]=0) PPID=7616 PROMPT_COMMAND='echo -ne \033]0;${us...@${hostname%%.*}:${PWD/#$HOME/~}\007' PS1='[...@\h \W]\$ ' --- PIPESTATUS=([0]=0 [1]=2) POSIXLY_CORRECT=y PPID=10236 PS1='\s-\v\$ ' 47c116,122 PWD=/home/symeon --- PWD=/usr/ud/accounts/cust855 REP_FLAG=0 REP_LOG_PATH=/usr/ud71/replog SBCS_SHM_SIZE=1048576 SB_FLAG=0 SETINDEX_BUFFER_KEYS=0 SETINDEX_VALIDATE_KEY=0 49,50c124,140 SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive- comments: monitor SHLVL=1 --- SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive- comments: monitor:posix SHLVL=3 SHM_ATT_ADD=0 SHM_FIL_CNT=2048 SHM_FREEPCT=25 SHM_GNPAGES=32 SHM_GNTBLS=40 SHM_GPAGESZ=131072 SHM_LBA=4096 SHM_LCINENTS=100 SHM_LMINENTS=32 SHM_LPAGESZ=4096 SHM_LPINENTS=10 SHM_MAX_SIZE=33554432 SHM_MIN_NATT=4 SHM_NFREES=1 SPLIT_LOAD=60 52,55c142,151 SSH_CLIENT=':::87.115.26.230 3539 22' SSH_CONNECTION=':::87.115.26.230 3539
Re: [U2] 2gig limit sticking into bash shell
What user was assigned to udt when it was installed? Check that user's ulimit. We run UV, and some commands (create-file, SH -c, etc.) run as the user assigned to UV during the install, not as the user that is actually logged in. Shelling out with sh gives you your own environment variables, but running a temporary shell command from TCL is done with the UV user's environment variables. I would assume udt would work with the same type of scenario. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, July 06, 2009 1:23 PM To: U2 Users List Subject: Re: [U2] 2gig limit sticking into bash shell I'm on UV 10.0.2 on Redhat, I did a shell, and my ulimit was unlimited. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, July 06, 2009 1:57 PM To: U2 Users List Subject: Re: [U2] 2gig limit sticking into bash shell Symeon: Would you consider this a bug? I wonder if the same problem exists on Windows? Bill Symeon Breen said the following on 7/6/2009 8:07 AM: Yes that is the one - ulimit -f is unlimited but when i shell out of udt it is set to 2gig, so i just need to reset this in my command So from tcl i have !ulimit -f unlimited;unzip UPLOAD/000855.zip And this works ! :) Thanks. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: 06 July 2009 14:59 To: U2 Users List Subject: Re: [U2] 2gig limit sticking into bash shell You may want to check the ulimit for the user. Shell down to Unix and perform a ulimit -f this will tell you if there is a max file size set on this specific user. Dan Goble Sr. Programmer Analyst RATEX Business Solutions, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, July 06, 2009 6:01 AM To: 'U2 Users List' Subject: Re: [U2] 2gig limit sticking into bash shell Thanks for the pointers, Sorry i mislead you a bit - when i tried this myself it does indeed work if you come out of udt and run it, it is only if you shell out from within udt that it fails. The set command before and while in udt shows quite a few diffs, these mainly look to be udt config params tho :- diff set.out set2.out 2c2,9 BASH=/bin/bash --- AIMG_BUFSZ=102400 AIMG_FLUSH_BLKS=2 AIMG_MIN_BLKS=10 ARCHIVE_TO_TAPE=0 ARCH_FLAG=0 ARCH_WRITE_SZ=0 AVG_TUPLE_LEN=4 BASH=/bin/sh 8a16,20 BGINPUTTIMEOUT=0 BIMG_BUFSZ=102400 BIMG_FLUSH_BLKS=2 BIMG_MIN_BLKS=10 BPF_NFILES=80 10c22,24 COLORS=/etc/DIR_COLORS.xterm --- CENTURY_PIVOT=1930 CHECK_HOLD_EXIST=0 CHKPNT_TIME=300 11a26,27 COMPACTOR_POLICY=1 CONVERT_EURO=0 12a29 EFS_LCKTIME=0 14a32,34 EXPBLKSIZE=16 FCNTL_ON=0 GLM_MEM_SEGSZ=4194304 15a36,37 GRPCMT_TIME=5 GRP_FREE_BLK=5 23c45,46 IFS=$' \t\n' --- IFS=' ' 24a48,49 JRNL_MAX_FILES=400 JRNL_MAX_PROCS=1 25a51,52 KEYDATA_MERGE_LOAD=40 KEYDATA_SPLIT_LOAD=95 26a54,55 LB_FLAG=1 LCT_NUM=8 29a59 LOCKFIFO=0 34a65,102 MAX_CAPT_LEVEL=2 MAX_DSFILES=1000 MAX_FLENGTH=1073741824 MAX_LRF_FILESIZE=134217728 MAX_NEXT_HOLD_DIGITS=4 MAX_OBJ_SIZE=307200 MAX_OPEN_FILE=500 MAX_OPEN_OSF=100 MAX_OPEN_SEQF=150 MAX_REP_DISTRIB=1 MAX_REP_SHMSZ=33554432 MAX_RETN_LEVEL=2 MERGE_LOAD=40 MGLM_BUCKET_SIZE=50 MIN_MEMORY_TEMP=64 NFA_CONVERT_CHAR=0 NFILES=1019 NSEM_PSET=8 NULL_FLAG=0 NUSERS=40 N_AFT=200 N_AFT_BUCKET=101 N_AFT_MLF_BUCKET=23 N_AFT_SECTION=1 N_AIMG=2 N_ARCH=2 N_BIG=233 N_BIMG=2 N_FILESYS=200 N_GLM_GLOBAL_BUCKET=101 N_GLM_SELF_BUCKET=23 N_PARTFILE=500 N_PGQ=10 N_PUT=8192 N_REP_OPEN_FILE=8 N_SYNC=0 N_TMAFT_BUCKET=19 N_TMQ=10 39a108 PART_TBL=/usr/ud71/parttbl 41,44c110,113 PIPESTATUS=([0]=0) PPID=7616 PROMPT_COMMAND='echo -ne \033]0;${us...@${hostname%%.*}:${PWD/#$HOME/~}\007' PS1='[...@\h \W]\$ ' --- PIPESTATUS=([0]=0 [1]=2) POSIXLY_CORRECT=y PPID=10236 PS1='\s-\v\$ ' 47c116,122 PWD=/home/symeon --- PWD=/usr/ud/accounts/cust855 REP_FLAG=0 REP_LOG_PATH=/usr/ud71/replog SBCS_SHM_SIZE=1048576 SB_FLAG=0 SETINDEX_BUFFER_KEYS=0 SETINDEX_VALIDATE_KEY=0 49,50c124,140 SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive- comments: monitor SHLVL=1 --- SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive- comments: monitor:posix SHLVL=3 SHM_ATT_ADD=0 SHM_FIL_CNT=2048 SHM_FREEPCT=25 SHM_GNPAGES=32 SHM_GNTBLS=40 SHM_GPAGESZ=131072 SHM_LBA=4096 SHM_LCINENTS=100 SHM_LMINENTS=32
Re: [U2] 2gig limit sticking into bash shell
In your diff comparison below, it appears that the first shell is /bin/bash and the second shell (started as a subshell of Universe) is /bin/sh. Wondering if that's where your problem is. You could try changing the UV Verb SH from /bin/sh to /bin/bash and see if that helps. Thanks for the pointers, Sorry i mislead you a bit - when i tried this myself it does indeed work if you come out of udt and run it, it is only if you shell out from within udt that it fails. The set command before and while in udt shows quite a few diffs, these mainly look to be udt config params tho :- diff set.out set2.out 2c2,9 BASH=/bin/bash --- AIMG_BUFSZ=102400 AIMG_FLUSH_BLKS=2 AIMG_MIN_BLKS=10 ARCHIVE_TO_TAPE=0 ARCH_FLAG=0 ARCH_WRITE_SZ=0 AVG_TUPLE_LEN=4 BASH=/bin/sh 8a16,20 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [UV] Using the fixtool utility.
Hello, I am trying the following command: /u1/uv/bin/fixtool -file /resize/FOOBAR -logging -logpath /resize/loggin The directory: /resize/FOOBAR contains: -rwxrwxrwx 1 root sys 1256974336 Jul 3 07:33 DATA.30 -rwxrwxrwx 1 root sys 7190597632 Jul 3 07:33 OVER.30 The directory /resize/loggin Already exists however when I use the command: /u1/uv/bin/fixtool -file /resize/FOOBAR -logging -logpath /resize/loggin I get the message: An error has occurred when running. Error: Unable to create the logging directory I get the same error if I delete the directory /resize/loggin It would be nice if the error message would print out the the name of the directory it is unable to create. Any ideas of how I should change the command ? I'd like to run a diagnostics before I use the fix command. (The file I want to fix is 64 bits). This is on a HP-UX machine. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] 2gig limit sticking into bash shell
Hi, On most linux systems /bin/sh is a sym link to /bin/bash It just turns out that ulimit is inherited from the shell above and 32 bit udt does change it, hence why i get my issue. So i can work round that now by resetting ulimit. Thanks for everyones insight. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Michael Pflugfelder Sent: 07 July 2009 17:38 To: U2 Users List Subject: Re: [U2] 2gig limit sticking into bash shell In your diff comparison below, it appears that the first shell is /bin/bash and the second shell (started as a subshell of Universe) is /bin/sh. Wondering if that's where your problem is. You could try changing the UV Verb SH from /bin/sh to /bin/bash and see if that helps. Thanks for the pointers, Sorry i mislead you a bit - when i tried this myself it does indeed work if you come out of udt and run it, it is only if you shell out from within udt that it fails. The set command before and while in udt shows quite a few diffs, these mainly look to be udt config params tho :- diff set.out set2.out 2c2,9 BASH=/bin/bash --- AIMG_BUFSZ=102400 AIMG_FLUSH_BLKS=2 AIMG_MIN_BLKS=10 ARCHIVE_TO_TAPE=0 ARCH_FLAG=0 ARCH_WRITE_SZ=0 AVG_TUPLE_LEN=4 BASH=/bin/sh 8a16,20 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Export to Excel
The csv 'standard' for fields containing a quote is double quote So for the data Col1 = col1data Col2 = col 2 is here !, and it is good Col3 = end You have a csv of col1,col 2 is here !, and it is good,end -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: 06 July 2009 16:21 To: U2 Users List Subject: Re: [U2] Simple Export to Excel Excel has the nasty habit of doing things to the data. For example, leading zeros are removed from numeric data. This is a bad thing if you have valid data like 123, 0123 00123. Excel will make then all 123. I agree. You can quote text values, but this is problematic if the data itself contained quotes. It helps some if you define the fields as text instead of general in the import screen. But there are still problems. I have tried to convince users not to overuse Excel, but they usually act like I just ran over their favorite puppy. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] General guidelines on indexing
Our primary application hasn't needed the performance gains offered by indexing, but our database has grown large and complex enough that we're looking at it seriously. Having only dabbled with indexing in test environments, I've got a few general and best practice questions. I've seen some comments in the archives on some of the pitfalls, e.g. the dangers of indexing remote files and indexing on correlatives with subroutines. But posts I found are at least a year old. I'm guessing there may be updated information out there. Feel free to point out that everything I'm asking is in the archives and send me there. Some questions: * Are there guidelines for how many indices is too many for one file (assuming disk space isn't an issue)? * Does BUILD.INDEX with the ONLINE parameter work as advertised? Can it really be run while the file is being updated? * How about data consistency? I seem to remember there being concerns in earlier days of an index not always being updated correctly. * How about indexing multi/subvalued fields? I don't know that we'd want to, but is it advisable? Valuable? * We use EMC to clone our production account so we can run nightly reports off-line. The account is renamed in this process. Might that cause any index issues? The clone is read-only, so there are no updates, just queries. * I've seen mention of index corruption. Is it obvious when an index is corrupt or can it be subtle? If subtle, are there ways to detect issues before our users do? * Performance is what we're after, but are there benefits to indexing other than performance? AIX 5.3 UniData 7.1 All thoughts, comments, observations are most appreciated. Brad Schrag U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Export to Excel
The csv 'standard' for fields containing a quote is double quote So for the data Col1 = col1data Col2 = col 2 is here !, and it is good Col3 = end You have a csv of col1,col 2 is here !, and it is good,end Does the ! in front of the comma in Col2 make it escape the comma. In other words, does it prevent an extra column from being created? Is the 'standard' a documented standard? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Export to Excel
There is a standard RFC4180 with iana. The standard is to have any commas enclosed within the double quotes. Only the Double quotes are escaped with double quotes. hth Colin Alfke Calgary, Canada From: Charles_Shaffer The csv 'standard' for fields containing a quote is double quote So for the data Col1 = col1data Col2 = col 2 is here !, and it is good Col3 = end You have a csv of col1,col 2 is here !, and it is good,end Does the ! in front of the comma in Col2 make it escape the comma. In other words, does it prevent an extra column from being created? Is the 'standard' a documented standard? Charles Shaffer _ Internet explorer 8 lets you browse the web faster. http://go.microsoft.com/?linkid=9655582 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Using the fixtool utility.
It is not the case, I used the uv user which has root permissions and my directories have 777 permissions. From: IT-Laure Hansen lhan...@redwoodcity.org To: Jacques G. jacque...@yahoo.com Sent: Tuesday, July 7, 2009 2:23:54 PM Subject: RE: [U2] [UV] Using the fixtool utility. My (wild) guess is this has to do with permissions in your /resize/loggin directory. Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.org Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribe -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: Tuesday, July 07, 2009 11:21 AM To: U2-Users@listserver.u2ug.org Subject: [U2] [UV] Using the fixtool utility. Hello, I am trying the following command: /u1/uv/bin/fixtool -file /resize/FOOBAR -logging -logpath /resize/loggin The directory: /resize/FOOBAR contains: -rwxrwxrwx 1 root sys 1256974336 Jul 3 07:33 DATA.30 -rwxrwxrwx 1 root sys 7190597632 Jul 3 07:33 OVER.30 The directory /resize/loggin Already exists however when I use the command: /u1/uv/bin/fixtool -file /resize/FOOBAR -logging -logpath /resize/loggin I get the message: An error has occurred when running. Error: Unable to create the logging directory I get the same error if I delete the directory /resize/loggin It would be nice if the error message would print out the the name of the directory it is unable to create. Any ideas of how I should change the command ? I'd like to run a diagnostics before I use the fix command. (The file I want to fix is 64 bits). This is on a HP-UX machine. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Export to Excel
There is a standard RFC4180 with iana. The standard is to have any commas enclosed within the double quotes. Only the Double quotes are escaped with double quotes. Got it. Thanks everyone. I didn't know that. I still think I'll stick with tab delimiters though. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Calculation on multi-valued elements
Hello all, I'm hoping this is a good place to find the error of my ways. I thought it was possible to do tabulations on multivalued fields within a dictionary item. I've included the dictionary, a sample of the output and a sample of the item. We've already resolved it another way, but thought this would have worked, but it appears to function only on the first multivalue Thanks for looking! RUN_TIME 0001 I 0002 IF (@RECORD3 - @RECORD2) LT 0 THEN ((@RECORD3 - @RECORD2) + 86400) ELSE (@RECORD3 - @RECORD2) 0003 MTS 0004 Run Time 0005 10R 0006 M Listing Sample LIST STATS START FINISH RUN_TIME 03:03:19pm 07 J STATSRun Time.. 1516402:49:58 -18:06:50 -21:09:00 -13:35:38 -13:36:53 -20:49:57 Item Sample 0002 76202²69001²76202²76202²76201²76201 0003 ²3791²62²27264²27188²1204 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Export to Excel
charles_shaf...@ntn-bower.com wrote: Got it. Thanks everyone. I didn't know that. I still think I'll stick with tab delimiters though. lol, standards are made to be broken :) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Calculation on multi-valued elements
Is it because of the IF statement? @record3-...@record2 tabulates correctly for each value position. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Morrissey Sent: Tuesday, July 07, 2009 3:40 PM To: U2 Users List Subject: Re: [U2] Calculation on multi-valued elements You want to look at IFS, LTS, and REUSE... On Tue, Jul 7, 2009 at 1:27 PM, David Ward damad...@comcast.net wrote: Hello all, I'm hoping this is a good place to find the error of my ways. I thought it was possible to do tabulations on multivalued fields within a dictionary item. I've included the dictionary, a sample of the output and a sample of the item. We've already resolved it another way, but thought this would have worked, but it appears to function only on the first multivalue Thanks for looking! RUN_TIME 0001 I 0002 IF (@RECORD3 - @RECORD2) LT 0 THEN ((@RECORD3 - @RECORD2) + 86400) ELSE (@RECORD3 - @RECORD2) 0003 MTS 0004 Run Time 0005 10R 0006 M Listing Sample LIST STATS START FINISH RUN_TIME 03:03:19pm 07 J STATSRun Time.. 1516402:49:58 -18:06:50 -21:09:00 -13:35:38 -13:36:53 -20:49:57 Item Sample 0002 76202²69001²76202²76202²76201²76201 0003 ²3791²62²27264²27188²1204 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Export to Excel
Got it. Thanks everyone. I didn't know that. I still think I'll stick with tab delimiters though. lol, standards are made to be broken :) We used to joke about the RS-232 'standard.' It was such a great standard because there were so many different ways to implement it. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Calculation on multi-valued elements
Using LTS gets you to compare each element of an array to each of another. Reuse will repeat the last element if you have an unequal number of elements in each array. It could also be a problem that this dictionary has an MTS conversion. It is probably comparing a time to zero. By the way, use (ICONVS, OCONVS) on a multivalue field. Or make another dictionary without the conversion, but pointing at the same data. also look up (CATS, GES, GTS, LES, LTS, EQS, ORS, ANDS, MULS, NUMS, FMTS, LENS, and so on.) From: damad...@comcast.net To: u2-users@listserver.u2ug.org Date: Tue, 7 Jul 2009 15:43:53 -0500 Subject: Re: [U2] Calculation on multi-valued elements Is it because of the IF statement? @record3-...@record2 tabulates correctly for each value position. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Morrissey Sent: Tuesday, July 07, 2009 3:40 PM To: U2 Users List Subject: Re: [U2] Calculation on multi-valued elements You want to look at IFS, LTS, and REUSE... On Tue, Jul 7, 2009 at 1:27 PM, David Ward damad...@comcast.net wrote: Hello all, I'm hoping this is a good place to find the error of my ways. I thought it was possible to do tabulations on multivalued fields within a dictionary item. I've included the dictionary, a sample of the output and a sample of the item. We've already resolved it another way, but thought this would have worked, but it appears to function only on the first multivalue Thanks for looking! RUN_TIME 0001 I 0002 IF (@RECORD3 - @RECORD2) LT 0 THEN ((@RECORD3 - @RECORD2) + 86400) ELSE (@RECORD3 - @RECORD2) 0003 MTS 0004 Run Time 0005 10R 0006 M Listing Sample LIST STATS START FINISH RUN_TIME 03:03:19pm 07 J STATS Run Time.. 15164 02:49:58 -18:06:50 -21:09:00 -13:35:38 -13:36:53 -20:49:57 Item Sample 0002 76202²69001²76202²76202²76201²76201 0003 ²3791²62²27264²27188²1204 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ Windows Live™: Keep your life in sync. http://windowslive.com/explore?ocid=TXT_TAGLM_WL_BR_life_in_synch_062009 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Calculation on multi-valued elements
As already stated, IFS, LTS, REUSE, and a bunch more are MultiValue Handling Functions documented in Universe Basic manual. Don't know where UD documents them. They can be called from I-descriptors. Unidata is similar, but I think you might need to call them from I-descriptors via SUBR(). This is a difference between Prime-style I-descriptors Pick-style correlatives. For correlatives, you write as if single-value the correlative handler feeds the appropriate values from the mv to the correlative. For I-desc, you have to write like you would in UV/UD Basic. E.g., @RECORD3 refers to the entire @vm-delineated dynamic array. The following should all work on UV if I were capable of typing it correctly. This parallels your own style: 0002: IFS( LTS( @RECORD3, @RECORD2 ), @RECORD3-...@record2+ REUSE( 86400 ), @RECORD3-...@record2 ) for Unidata I *think* you need to do something like this: 0002: SUBR( '-IFS', SUBR( '-LTS', @RECORD3, @RECORD2 ), @RECORD3-...@record2 + REUSE( 86400 ), @RECORD3-...@record2 ) You can use the dict names START FINISH instead of @RECORD2, @RECORD3 I prefer: 0002: (FINISH - START) + ( LTS( START, FINISH ) * REUSE( 86400 ) ) To handle the 1st pair of values, where FINISH is blank because the job is still running, you might wrap the whole thing inside another IFS: 0002: IFS( NES( FINISH, '' ), [one of the calculations listed above], [ '' or REUSE( 'running' ) or whatever] ) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Calculation on multi-valued elements
Thanks for the input all. Using those functions is the path one of our other developers took. TST 0001 I 0002 LTS(@RECORD3,@RECORD2); MULS( @1, REUSE(86400)) ; ADDS(@RECORD3, @2) ; SUBS(@, @RECORD2) 0003 MTS 0004 0005 10R 0006 M -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jo Lester Sent: Tuesday, July 07, 2009 4:48 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Calculation on multi-valued elements Using LTS gets you to compare each element of an array to each of another. Reuse will repeat the last element if you have an unequal number of elements in each array. It could also be a problem that this dictionary has an MTS conversion. It is probably comparing a time to zero. By the way, use (ICONVS, OCONVS) on a multivalue field. Or make another dictionary without the conversion, but pointing at the same data. also look up (CATS, GES, GTS, LES, LTS, EQS, ORS, ANDS, MULS, NUMS, FMTS, LENS, and so on.) From: damad...@comcast.net To: u2-users@listserver.u2ug.org Date: Tue, 7 Jul 2009 15:43:53 -0500 Subject: Re: [U2] Calculation on multi-valued elements Is it because of the IF statement? @record3-...@record2 tabulates correctly for each value position. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Morrissey Sent: Tuesday, July 07, 2009 3:40 PM To: U2 Users List Subject: Re: [U2] Calculation on multi-valued elements You want to look at IFS, LTS, and REUSE... On Tue, Jul 7, 2009 at 1:27 PM, David Ward damad...@comcast.net wrote: Hello all, I'm hoping this is a good place to find the error of my ways. I thought it was possible to do tabulations on multivalued fields within a dictionary item. I've included the dictionary, a sample of the output and a sample of the item. We've already resolved it another way, but thought this would have worked, but it appears to function only on the first multivalue Thanks for looking! RUN_TIME 0001 I 0002 IF (@RECORD3 - @RECORD2) LT 0 THEN ((@RECORD3 - @RECORD2) + 86400) ELSE (@RECORD3 - @RECORD2) 0003 MTS 0004 Run Time 0005 10R 0006 M Listing Sample LIST STATS START FINISH RUN_TIME 03:03:19pm 07 J STATS Run Time.. 15164 02:49:58 -18:06:50 -21:09:00 -13:35:38 -13:36:53 -20:49:57 Item Sample 0002 76202²69001²76202²76202²76201²76201 0003 ²3791²62²27264²27188²1204 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ Windows Live: Keep your life in sync. http://windowslive.com/explore?ocid=TXT_TAGLM_WL_BR_life_in_synch_062009 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Export to Excel
Let's not forget what the RS stands for. In addition, there were many applications that went far beyond anything contemplated by it, kind of like off-label uses for prescription drugs. Your mileage will vary. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Tuesday, July 07, 2009 1:51 PM To: U2 Users List Subject: Re: [U2] Simple Export to Excel Got it. Thanks everyone. I didn't know that. I still think I'll stick with tab delimiters though. lol, standards are made to be broken :) We used to joke about the RS-232 'standard.' It was such a great standard because there were so many different ways to implement it. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Calculation on multi-valued elements
The semi-colon way of writing is more readable, but UV does not let you reference such an I-descriptor (as reusable code) from some future one. For example, next year you want to know how fast/slow certain programs run during certain times of the day. You'll want to use the RUN_TIME result within a second I-descriptor. UV won't let you if it uses multiple buffers as written below. I think this is a serious defect dating back to Prime but since it has never been changed, I'm guessing it would require tremendous rewrite. Does anyone know when MULS and ADDS would ever be necessary, since +,-,*,/ are already vectored? Don't forget about DLIST for debugging I-descriptors. Don't know if the above applies to UD. David Ward wrote: Thanks for the input all. Using those functions is the path one of our other developers took. TST 0001 I 0002 LTS(@RECORD3,@RECORD2); MULS( @1, REUSE(86400)) ; ADDS(@RECORD3, @2) ; SUBS(@, @RECORD2) 0003 MTS 0004 0005 10R 0006 M ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users