Re: [U2] by.exp when
Two Dictionary lessons in one day. Other problem solved when 'DICT' was removed from the dictionary. Among the 400+ dictionary items in my file, one of them is 'WHEN', as in when the record was posted. I copied the VOC WHEN to DWHEN and everything works as expected. Thanks all Roger Brian Leach wrote: Roger For what it's worth, I've done an equivalent query in prime flavor using my demo database and as you would expect, it works fine: Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Roger Glenfield Sent: 09 February 2008 15:48 To: u2-users@listserver.u2ug.org Subject: Re: [U2] by.exp when Again. This is PRIME FLAVOR. I've tried these commands on both 9.5 and 10.2 1) SORT FILE BY.EXP CHARGE.CODE EQ "01" CHARGE.CODE TOTAL REV.AMT 0 records selected. 2) SORT FILE BY.EXP CHARGE.CODE = "01" CHARGE.CODE TOTAL REV.AMT 0 records selected. 3) SORT FILE BY.EXP CHARGE.CODE WITH CHARGE.CODE EQ "01" CHARGE.CODE TOTAL REV.AMT 0 records selected. 4) SORT FILE BY.EXP CHARGE.CODE WHEN CHARGE.CODE EQ "01" CHARGE.CODE TOTAL REV.AMT 0 records selected. 5) SSELECT FILE BY.EXP CHARGE.CODE x records selected LIST FILE CHARGE.CODE TOTAL REV.AMT WHEN CHARGE.CODE EQ "01" 0 records selected. ditto for WITH CHARGE.CODE EQ "01" but SORT FILE BY.EXP CHARGE.CODE CHARGE.CODE TOTAL REV.AMT FILE CHARGE.CODE REV.AMT 1000110.01 10101 1.11 10201 2.23 10301 100.55 10002 1.00 10102 1.01 you get the idea. I can remember the original version of Pr1me Information. It was earlier then BY.EXP. Like Pick pre-r80, it didn't really do MV very well. The WHEN clause is documented in the current Release 10 Retrieve manual about a page or two after BY.EXP. By the way, 1,2,3,4 all work in Pick or Ideal flavor. Any ideas? thanks Roger --- 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] File Sizing for Unidata on Windows
Fast is a great product and will save you time in resizing files. !guide is a great tool too. You don't need to purchase fast and can use guide instead. that's your choice. Laura Hirsh <[EMAIL PROTECTED]> wrote: Hi all, I'm working on a project, and wanted to get some feedback regarding others experiences. The issue is resizing files for a substantial database. Im curious about what tools and experiences people use when trying to do the same thing. What rules of thumb are being used to calculate modulo and block size? How often do people schedule file resizes? Is it system wide, or on a subset of files? How do folks manage scheduling resizes in a 24x7 shop? Some folks recommend FAST, other folks have suggested using the information available via !guide or file.stats, and then do a !memresize. The interesting thing is that each of these methods seems to come up with a different new size recommendation, and as a result, there is a lot of trial and error. Anyone want to share their experiences? Id love to hear them. Thanks in advance, Laura --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - Looking for last minute shopping deals? Find them fast with Yahoo! Search. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] release notes (was: SLEEP 60 slept only 53 seconds, or else TIMEDATE() is wrong)
>Where on IBM's massive web site can I find what was fixed on what > version of universe? > This thread got me wondering if some weird issues I have seen have > already been fixed on a new versions of universe (we are running on > AIX if that matters) > As well as what new features have been added to new versions of universe It's not all nicely in one place, but a good starting place is http://www-306.ibm.com/software/data/u2/contacts/ You'll find links to manuals, knowledgebase, product availability, [EMAIL PROTECTED], etc., etc.. Each major release is usually accompanied with an update on the manuals, including a "New Features at Release X.0" sort of thing. "U2 Product Availability page" page is linked from the above url. https://www-927.ibm.com/software/data/u2/support/matrix.asp There is a "readme" for any given release from the base x.0 release forward. Caution: You'll see that IBM continues to make fixes to later versions of UV10.1.x after UV10.2.0 was released. So if you read about a fix in such a release, you have to look carefully to make sure that same fix was applied to a later 10.2.y you might be interested. I use UV as an example, but I think the advice is good anywhere. There have been a few conference and Web presentations that IBM has made about new releases. Maybe others can say where to find them. Or [EMAIL PROTECTED] There is no place where IBM will tell you a list of acknowledged open issues, their disposition, suggested workarounds, projected fix dates. They hold that close to the chest, to the detriment of clients who get bit by a bug that they otherwise would have worked around. (Am I bitter? A little.) Chuck Stevenson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] File Sizing for Unidata on Windows
We are on UNIX, but this gives you an idea of what we do. We have a 'cron' that looks at the date/time stamp on files at a Unix level (UNIX 'find' command using -mtime -1). If the file was updated in the last 24 hours, then we have a Unidata program go through and figure out if the file is a Unidata file. If it is a Unidata file, it puts it in a UNIX flat file called 'guide.input. Then a 'guide -i guide.input -d3 -r /usr/ud/RAW/STAT-FILE' is run to build a database of Unidata file stats in STAT-FILE. Once a month we have an 8 hour outage to do sever maintenance and any file resizing is done at that point based on what 'guide' recommends. That works fine for static files. Dynamic files are a different issue, as 'guide' does not help much with recommendations with dynamic files. I usually look at a UNIX level to see how many 'overxxx' parts I have in the file directory. If I have more than 1 or 2, I look at recreating the file. I don't use 'memresize' for dynamic files, as it has a number of short comings. It works, but it does things like create an 'overxxx' part for every 'datxxx'. I have one file that has 31 'dat' segments and just one 'overxxx' part, over001. If I used memresize, I would also have 31 'overxxx' parts. memresize also does not allow for use of the TMPPATH parameter. So you need to be able to hold 2 copies of the file you are resizing in the file system where it lives. So I instead create a new file in another file system with the MOD and Blocksize that I want. Then we have a verb called PHANTOM.COPY. PHANTOM.COPY will use a Unidata list to do the copy. It breaks the list up into how many ever PHANTOMS I specify to use. So the statement in Unidata would look like: PHANTOM.COPY FILEA FILEB LIST.NAME 12. This would take LIST.NAME, break it up into 12 lists and pass each list into another PHANTOM that would copy 1/12 of FILEA into FILEB. So I have 12 simultaneous copies running building the new file. It turns out to be almost as fast as 'memresize' and I don't have all the extra 'overxxx' parts in the file directory. Which in turn makes it easier for me to monitor whether my dynamic files need attention. Since you are on Windows, this maybe does not help much. But maybe there are ways on Windows to do something similar. - Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Laura Hirsh Sent: Friday, February 15, 2008 11:24 AM To: u2-users@listserver.u2ug.org Subject: [U2] File Sizing for Unidata on Windows Hi all, I'm working on a project, and wanted to get some feedback regarding others experiences. The issue is resizing files for a substantial database. Im curious about what tools and experiences people use when trying to do the same thing. What rules of thumb are being used to calculate modulo and block size? How often do people schedule file resizes? Is it system wide, or on a subset of files? How do folks manage scheduling resizes in a 24x7 shop? Some folks recommend FAST, other folks have suggested using the information available via !guide or file.stats, and then do a !memresize. The interesting thing is that each of these methods seems to come up with a different new size recommendation, and as a result, there is a lot of trial and error. Anyone want to share their experiences? Id love to hear them. Thanks in advance, Laura --- 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] USING stopped working
That was it! Thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Eastwood Sent: Friday, February 15, 2008 12:44 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] USING stopped working Look for an item "DICT" in Dictionary of either of your files. Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of roy Sent: Friday, February 15, 2008 10:33 AM To: u2-users@listserver.u2ug.org Subject: [U2] USING stopped working Can anyone explain what happened to the USING verb in retrieve? UV 10.1.14 and UV 10.2.7 both reject it. Pick flavor on AIX PRODUCT and BAR-CYCLE are valid files with valid DICTS >LIST BAR-CYCLE USING DICT PRODUCT KEY ON-HAND DESC RetrieVe: syntax error. Unexpected symbol. Token was "DICT". Scanned command was LIST BAR-CYCLE USING DICT --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] USING stopped working
Can anyone explain what happened to the USING verb in retrieve? LIST BAR-CYCLE USING DICT PRODUCT KEY ON-HAND DESC Have you tried moving the USING clause to the end of the statement? LIST BAR-CYCLE KEY ON-HAND DESC USING DICT PRODUCT I've not had any problem with the above syntax - and would be in huge trouble if ever it stopped working...! Colin. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] USING stopped working
Let me add that is was working in 10.2.0 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of roy Sent: Friday, February 15, 2008 12:33 PM To: u2-users@listserver.u2ug.org Subject: [U2] USING stopped working Can anyone explain what happened to the USING verb in retrieve? UV 10.1.14 and UV 10.2.7 both reject it. Pick flavor on AIX PRODUCT and BAR-CYCLE are valid files with valid DICTS >LIST BAR-CYCLE USING DICT PRODUCT KEY ON-HAND DESC RetrieVe: syntax error. Unexpected symbol. Token was "DICT". Scanned command was LIST BAR-CYCLE USING DICT --- 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] USING stopped working
Look for an item "DICT" in Dictionary of either of your files. Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of roy Sent: Friday, February 15, 2008 10:33 AM To: u2-users@listserver.u2ug.org Subject: [U2] USING stopped working Can anyone explain what happened to the USING verb in retrieve? UV 10.1.14 and UV 10.2.7 both reject it. Pick flavor on AIX PRODUCT and BAR-CYCLE are valid files with valid DICTS >LIST BAR-CYCLE USING DICT PRODUCT KEY ON-HAND DESC RetrieVe: syntax error. Unexpected symbol. Token was "DICT". Scanned command was LIST BAR-CYCLE USING DICT --- 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/
[U2] USING stopped working
Can anyone explain what happened to the USING verb in retrieve? UV 10.1.14 and UV 10.2.7 both reject it. Pick flavor on AIX PRODUCT and BAR-CYCLE are valid files with valid DICTS >LIST BAR-CYCLE USING DICT PRODUCT KEY ON-HAND DESC RetrieVe: syntax error. Unexpected symbol. Token was "DICT". Scanned command was LIST BAR-CYCLE USING DICT --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] File Sizing for Unidata on Windows
Hi all, I'm working on a project, and wanted to get some feedback regarding others experiences. The issue is resizing files for a substantial database. Im curious about what tools and experiences people use when trying to do the same thing. What rules of thumb are being used to calculate modulo and block size? How often do people schedule file resizes? Is it system wide, or on a subset of files? How do folks manage scheduling resizes in a 24x7 shop? Some folks recommend FAST, other folks have suggested using the information available via !guide or file.stats, and then do a !memresize. The interesting thing is that each of these methods seems to come up with a different new size recommendation, and as a result, there is a lot of trial and error. Anyone want to share their experiences? Id love to hear them. Thanks in advance, Laura --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Piping to a unix command with echo
Yes You're right - but anyway You should be better off with single quotes. -- mats Marco Manyevere skrev: Problem is STR1 may contain a "'", then echo will not know where the string ends, hence the need to escape it. - Original Message From: Mats Carlid <[EMAIL PROTECTED]> To: u2-users@listserver.u2ug.org Sent: Friday, 15 February, 2008 3:02:59 PM Subject: Re: [U2] Piping to a unix command with echo Unix is supposed to not process any special characters inside single quotes so drop the change commands and use SQUOTE . -- mats --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] CSV output
Here are a couple of other examples I have seen float around. Create dict item COMMA like this >ED DICT POLI COMMA COMMA 001: I 002: "," 003: 004: , 005: 1T The use COMMA between every field listed: >LIST file BUYER COMMA PO.DATE COMMA 1 COMMA 2 COMMA LIST file EVAL "FIELD(@ID,"*",2):",":@RECORD<1>:",":@RECORD<2>:",":@RECORD<5>:",":@RECO RD<6>" FMT "55L" COL.HDG "DATA" ID.SUPP I got this courtesy of Mark over at AFS. Tony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Monday, February 11, 2008 3:37 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] CSV output If you want to make the DICT entry more readable, put CHAR(009) in field 2 of your TAB dictionary record. Also, in field 4: if you put value marks between each tab then you can have three-line column headings (the UniVerse max) that will also be correctly tabbed: CHAR(009)^253CHAR(009)^253CHAR(009) Same methodology works for commas. Just replace CHAR(009) with CHAR(044). -- Louie Bergsagel --- 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] Piping to a unix command with echo
Problem is STR1 may contain a "'", then echo will not know where the string ends, hence the need to escape it. - Original Message From: Mats Carlid <[EMAIL PROTECTED]> To: u2-users@listserver.u2ug.org Sent: Friday, 15 February, 2008 3:02:59 PM Subject: Re: [U2] Piping to a unix command with echo Unix is supposed to not process any special characters inside single quotes so drop the change commands and use SQUOTE . -- mats Marco Manyevere skrev: > Im trying to process the contents of a string generated in Universe with an > external program by shelling out to the OS as follows: > > CHANGE '\' TO '\\' IN > STR1 > CHANGE '"' TO '\"' IN STR1 > SH.CMD = 'SH -c echo ':QUOTE(STR1):' | > ./myscript' > EXECUTE SH.CMD CAPTURING RESULT > > STR1 can contain any characters > so to avoid interpratation by the shell I put the two CHANGE statements but it > seems some situations are still not covered, for example when STR1 contains > \008, the output is wrong. Does anyone know how I can make this foolproof or > an alternate method? I am able to get consistent results by writing STR1 to a > temp file then running my script with input and output redirection but I want > to cut down on unnecessary disk IO. > > Another question: While STR1 is > guaranteed not to exceed 4k, does anyone know the maximum size of the command > I can run in this way? Im on AIX. > > Marco. > __ > Sent from Yahoo! > Mail - a smarter inbox http://uk.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/ __ Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UB] Beep Error
Tim: You are right. The beep-beep was added to the standard one-second-screen-blank when keyboard errors occur. It will be interesting to learn user's reactions to the beep-beep-and-sleep as it is rolled-out over time here. The one-second-screen-blank has been out there for a year and I have not heard hardly... a peep. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tim Stokes Sent: Thursday, February 14, 2008 4:57 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UB] Beep Error [not-secure] Just a side note. If there is a problem with the speaker or the user has an hearing problem the bell with not be heard. Users may also grow 'upset' with hearing a bell. I tend to lean towards visual clues (error messages). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Piping to a unix command with echo
Unix is supposed to not process any special characters inside single quotes so drop the change commands and use SQUOTE . -- mats Marco Manyevere skrev: Im trying to process the contents of a string generated in Universe with an external program by shelling out to the OS as follows: CHANGE '\' TO '\\' IN STR1 CHANGE '"' TO '\"' IN STR1 SH.CMD = 'SH -c echo ':QUOTE(STR1):' | ./myscript' EXECUTE SH.CMD CAPTURING RESULT STR1 can contain any characters so to avoid interpratation by the shell I put the two CHANGE statements but it seems some situations are still not covered, for example when STR1 contains \008, the output is wrong. Does anyone know how I can make this foolproof or an alternate method? I am able to get consistent results by writing STR1 to a temp file then running my script with input and output redirection but I want to cut down on unnecessary disk IO. Another question: While STR1 is guaranteed not to exceed 4k, does anyone know the maximum size of the command I can run in this way? Im on AIX. Marco. __ Sent from Yahoo! Mail - a smarter inbox http://uk.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/