I have seen odd things happen if you specify the exact date conversion
for ICONV. I have never had a problem getting the correct results for
an ICONV on a date by just using D. It is the most understanding and
graceful.
John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard
I agree with Brian. Blink errors are VERY bad.
If you can get the 2 dbs in a stable state with no users on either
system, copying is fine. Other than that, Brian has the right idea.
Blink errors can be the kiss of death, so be careful.
John Israel
Sr. Programmer/Analyst
Dayton Superior
Blink = Backward Link. Mumbo jumbo for the internal guts of how the
pieces of the file all hook together.
I have seen different results on different versions on UniVerse.
However, in the worse case scenario (which was the most common), we
could never recover cleanly and had to reload from a
Whatever you are doing crashes, you get a nasty message on the screen
with the word blink in it somewhere.
My experience (including direct tech support from IBM) was we were out
of luck! Get out the backup tape or some other way to restore.
I used to be with IBM at a customer site (IBM did all
I worked at a site that actually used SourceSafe to check in/out
programs. This worked fairly well in a lot of ways, but it is a shift
in how source code is stored and accessed. The nicest thing is the
historic versioning and comparing features.
John Israel
Sr. Programmer/Analyst
Dayton
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Israel, John R.
Sent: Thursday, May 15, 2008 2:01 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] locking code question
I worked at a site that actually used SourceSafe to check in/out
programs
PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Israel, John R.
Sent: Thursday, May 15, 2008 2:47 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] locking code question
Yes and no. Since basic program files are just Unix Dirs and the source
code is just text, you could map these files via
Catalog locally and you will never need to re-catalog (assuming local
cataloging is acceptable).
or
Catalogging hundreds of pgms should not be a big deal.
SELECT BP (or SELECT BP_O)
CATALOG BP FORCE
John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH 45342
Write a simple tester subroutine that passes the name of the
original/standard program.
This subroutine reads a control record that uses your
user_id:*CODETESTING as the key (thus unique to each user). If not
found (which would be the case for most users), return the original
program name. If
to be done
1. logic added to each program for this tester subroutine
2. the program would have to have a different name from the original
program
while step one would be a lot of work, I can see it working pretty well
once the logic is in most of the programs
thanks!
dougc
Israel, John R. wrote
After doing a data refresh (from Unix, remove the old data account/dir,
copy the live data account to the test account, fix VOC pointers as
needed, etc.), I am no longer able to get Redback and System Builder to
link up. We have done data refreshes many times in the past w/o any
problems. In a
OK, I admit I never thought of that, but my other accounts are working,
so initially, this does not sound like it would be the problem.
However, after a month, I am willing to try anything!
How do I find the licensing info for Redback?
John Israel
Sr. Programmer/Analyst
Dayton Superior
Have you tried to copy on both boxes (push from box 1 to box 2, or pull
from box 2 against box1)?
John Israel
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: Friday, May 30, 2008 2:54 PM
To: 'u2-users@listserver.u2ug.org'
Subject:
At a prior job, we used dynamic files for everything. Some of our files
were HUGE.
If you know the rough size a file will hang at (or have some other
indicator), we found it best to set these files with a min mod. This
was esp. helpful when building a new file and then populating it with
I am not sure about a system variable, but as I understand it, rbadmin
is the one doing the communication on the PICK box. If someone does not
have a better idea, you could EXECUTE !whoami and if you are rbadmin
(or some other pre-defined user) you could ignore the prompt.
John Israel
Sr.
I have always preferred dynamic files. In the long run, they are easier to
deal with. You should still determine the best block size. Also, if you are
going to bulk load it, you should set the min mod so that it does not start
splitting right off the bat. You still want the basic size to be
Note that if the array is big, you would get much better performance by loading
it into a DIM array, so the sort of sort below, then put the results back into
a dynamic array.
Dynamic arrays are much easier to use, but when used wisely, dimensioned arrays
can be MUCH faster. This is true for
PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R.
Sent: Tuesday, July 22, 2008 10:44 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] RE: Basic SORT() Function not avail in UniVerse?
When I need an array to be sorted, I always build it that way using the LOCATE
command
Your doomed.
John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH 45342
937-866-0711 x44380
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of JPB-U2UG
Sent: Tuesday, July 22, 2008 4:14 PM
To:
Of Israel, John R.
Sent: Tuesday, July 22, 2008 10:26
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] Basic SORT() Function not avail in UniVerse?
Note that if the array is big, you would get much better performance by
loading it into a DIM array, so the sort of sort below, then put
Honestly, I have always just used the native editor (ED or AE). For things in
Unix dirs, I have mapped netwok drives to key places to my PC, then I use and
Window editor that strikes my fancy.
Note that AE has some nice features like exploding multi-value into fields for
viewing/editing.
We are also running Epicor's Avanti. I looked at my program vs. what you had
written. I noticed 2 things, neither one of which should cause such a serious
error, but it might point you in some direction.
1) we are running unaltered software, and the WRITE statement you mentioned is
on a
I got the following at my home E-mail, and am passing this on to anyone
interested. I have no more details than what I am including. It could be good
- it could be bogus.
==
I'm in need of someone for a West Palm Beach client...They have a 40 hour a
week strictly telecommute position. The
You need the double quotes on the outside of the ...
SELECT FILE WITH FIELD LIKE ...LLOYD'S...
Alternatively, you can often get away with no quotes. Loosely speaking, you
only NEED quotes on the outside if you have spaces in your search string,
though if you have a single quote in your search
] On Behalf Of Anthony W.
Youngman
Sent: Wednesday, August 06, 2008 7:26 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RE: SELECT problem with quote characters
In message
[EMAIL PROTECTED],
Israel, John R. [EMAIL PROTECTED] writes
You need the double quotes on the outside of the ...
SELECT
I tried using the lower case SELECT/LIST to use native UniData syntax, and
that did not work.
Try writing a simple program to convert the double quotes to something else
(like a tilda) then search the I-desc for that.
ED BP TILDA
SUBROUTINE TILDA(RTN.VAL, ORIG.VAL)
RTN.VAL = CONVERT(ORIG.VAL,
Or simply use a lower case LIST (i.e. list) to force it to ECLTYPE U for
that one statement. This works for list ..., select ..., etc. This is a
VERY useful way to use U flavored syntax in a P environment.
There is a similar command for compiling basic programs. Make the first line
of your
I am tasked with building an log file for our customers using our web site
(Redback). I have figured out how to grab what I need, but am not sure the
best way to make the file structure.
I need to track the user (their E-mail address), the web page, the various
request options, the date and
I used to work at a large IBM site where the customer was running UniVerse on
AIX (no clue what versions). Every night, a cron job would run that would
change the owner to xx1 and the group to xx2 (I don't recall the actual names)
for all the files (and programs) in the UniVerse realm. I
Write a simple pgm to EXECUTE !listuser and capture the output. Filter out
the info as needed.
Ignoring the blank lines, the 1st line will give you the headers and the 2nd
will give you the counts.
To manually see this, type !listuser | more.
We do this every 15 minutes via cron and track
Jeff,
That sounds kinda cool.
If you are agreeable, would you send me copies of these so I can look at this?
While this will not change what we do here, it sounds very interesting and I am
always wanting to learn.
John Israel
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL
When I need to build an export file, I always build each row as a FM delimited
array. This allows me to take advantage of all the basic commands. When I am
ready to write the row to disk (via WRITESEQ), I always run a common piece of
code to:
Convert all tabs to spaces
Convert all vms to
Do an index on SA to find the beginning position, then an index on /SA
to find the end.
Extract that info (i.e. CHUNK = REC[START.POS, ((END.POS-START.POS) + 1)]
Change all AR to @FM:AR .
Rip out everything before the first AR and the last /AR so you only
have an array of the sub-data.
We use UniData on HP Unix, so I am not sure how much of this will transfer
over, but here are things we found:
1) Triggers must be globally cataloged. This means that if you have a
development account on that same box, you have to play games if you want to
make changes. We have both a
There is still a hole to the wrapper approach.
Assuming you are trying to catch folks that use the ED (or AE) command, we
have to assume that these folks have access to TCL. If you can get to TCL, and
you are wanting to hide your tracks, you could still copy your record to a dir
file, then
My 2 cents:
I only use FOR/NEXT loops if I am dealing with data that I know is small.
Technically, LOOP/REMOVE are faster, but for something small I just keep it
simple.
I would think the LOOP/REMOVE or basic SELECT would both be very fast. The
SELECT has the advantage of not needing to test
Just chiming in on the debugging in a web page which might also help here since
you loose the ability to interact.
I have written a universal E-mailing program that can be called from any
UniData program. It will work with both simple text or HTML depending on how
much effort the programmer
Put a DELETE trigger on the VOC file and in the code, specifically test for
just the VOC item that keeps getting deleted (i.e. ignore any others). When
you get a hit, immediately send your self an E-mail with all the info in
question.
Remember that triggers must be globally cataloged, but
, December 29, 2008 5:19 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Program Name
Israel, John R. wrote:
In some access, SYSTEM(40) returns the dir/pgm_name (ex: BP/_HELLO.WORLD)
while at other times, it returns the full Unix path for the SAME program (ex:
/av1/igi/avante94/floprogs
I am confused by the SORT, but I am guessing that something like this would
work:
LIST =
(some selection criteria)
LOOP
WHILE READNEXT KEY
LOCATE KEY IN LIST1 BY AL SETTING POS ELSE
INS KEY BEFORE LISTPOS
END
REPEAT
This builds you list and sorts it all at once.
Based on the
We are running UniData on HP-UX and I capture Unix info regularly.
Rather than using a COMO, just do it with the EXECUTE command like so:
STMT = !ls -lia (or whatever you need to capture)
EXECUTE STMT CAPTURING UNIX.TXT
Then loop through UNIX.TXT as needed. If the results can be big, use
Could you have the first PHANTOM fire off the 2nd PHANTOM when that critical
point is reached?
John Israel
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Tom Whitmore
Sent: Thursday, February 26, 2009 7:57 AM
To:
We are looking to do a big upgrade on our hardware and software, and I was
hoping to get any positive or negative feedback folks might have had.
CURRENT
HP Ux 11i v1
UniData 6.0.4
SB 5.2
RedBack 4.2.6
DataStage 7.5
PROPOSED
HP Ux 11i v3
UniData 7.1.17
SB 5.2.4
U2 WEB DE 4.4
If you might also want to play with putting the WHILE... line just before the
REPEAT. This would be dependent upon your actual program (might need to
consider if the loop starts with a failed condition). Your mileage may vary.
John Israel
-Original Message-
From:
I agree completely with David. I make it a habit to have one way in and one
way out for my loops and subroutines. It makes it much easier to enhance/debug
in the future (which is what most of us spend most of our time doing). I will
not say I NEVER break this rule, but it is rare.
John
In all your examples, you support my position. 1 way in, 1 way out. Though to
your point, you have clean, concise clean code.
John Israel
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of MAJ Programming
Sent: Friday,
Our UniData database is on a Unix box. I have mapped the key dirs to my PC.
This allows me to use any PC editor I wish. I usually use SlickEdit because
that is an editor that lots of other folks here use for other applications, but
I have also used Primal Script (the 2nd most popular editor
I have just encountered an inconsistency between the native UniData select and
the PICK flavored select.
From a PICK flavored account, it I use the lower case sselect to force
native UniData syntax, I get:
sselect ITMMST WITH F2 LIKE ...J1A... (6,213 keys - wrong)
If I immediately follow this
Subject: Re: [U2] Select Problem
Is it taking 1A as a mask? One Alphanumeric character? How many do you
get with ...J...?
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
Israel, John R. johnisr...@daytonsuperior.com
Sent by: owner-u2-us...@listserver.u2ug.org
04/14/2009 11:06 AM
Please
Point well taken. However, in this case it is a partial part description
search from a web page, so the user could type anything. I have locked this
down every way I can think of (I have to deal with it otherwise and I hate
addressing the same issue more than once). There is other criteria
This sounds very interesting and a worthy concept. But as others have stated,
there are already packages of one kind or another in place. Even if yours is
better, it will be a huge hurtle to get them to convert and getting them to do
duel entry (current system plus your new system) simply
You can set a min modulo on a dynamic file when you build it (or rebuild it).
In theory, this will reduce the splitting until you hit that min modulo. This
does of course assume your files hash fairly evenly, etc, etc.
However, if you purge the file, it will still take up all that space based
By default, selecting uses the default of select list 0.
In the 2nd/internal subroutine, have the SELECT use a different select # and
then read from that select #.
For example:
STMT = SELECT WIGETS TO 4
EXECUTE STMT
LOOP
WHILE READNEXT KEY FROM 4
(your code)
REPEAT
John Israel
Sr.
After all my advice, I do agree with Jeff that doing selects within I-desc
creates a LOT of overhead and in general, is not a good idea. If you can get
around this and put it all in one piece of code, you will get better results.
I was assuming you had a reason for doing it the way you
Beloit, Wisconsin
608-363-2290 wel...@beloit.edu 608-363-2100 (fax)
*---*
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Friday
Is this done from a SB+ screen? If so, you should be able to pull from one of
their variables. If not, you would have to do a select on the DICT to find the
one you want. The problem here is what to do it you get multiple hits or no
hits?
John Israel
Sr. Programmer/Analyst
Dayton Superior
Just to be 100% clear - it's not just indexes on subroutines that will get out
of sync. Even indexing a simple TRANS statements will cause problems.
This is because the index is updated whenever the primary file (the one with
the index) is updated. If the data is in the 2nd file (the TRANS or
I wrote something like this a while ago. It has a driver program that prompts
for what you want (includes, calls, etc) and what program to start on, then
calls the main external subroutine.
This external subroutine recursively calls itself for each call and include.
The trick to this is to
,
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Wednesday, 27 May 2009 6:50 AM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] UV BASIC Flowing Charting Tools
I wrote something like this a while
Set your page size to 99 and send results to _HOLD_ via SETPTR. You will
have one header at the top.
John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH 45342
937-866-0711 x44380
From:
Exactly! But also set the page length to something huge (99) so that you
only have 1 header. Scrape the first couple of lines (if needed) and the reset
is raw text.
John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH 45342
937-866-0711 x44380
Our on-again/off again upgrade has finally been approved and we are moving
ahead (money on the table). After a lot of back and forth, we have chosen the
hardware and software that we want. Unfortunately, our vendor has just told us
that they do not support the OS we want. We are pushing hard
I believe the newest version of Redback (called WEB DE) uses Eclipse to develop
ASP web pages. In fact, IBM is saying you can convert all your SB+ stuff over
to ASP! That could be a big savings on SB licenses, but unless you have a home
grown system, your vendor is not likely to support this
We have lots of programs that export our data from UniData to tab-delimited
text files. Some of these are opened by Excel (which has its faults), some are
imported into other databases. These files will be 1) E-mailed as attachments
or written to specific location on the network.
If I know
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John
R.
Sent: 22 June 2009 14:56
To: 'U2 Users List'
Subject: [U2] Simple Export to Excel
We have lots of programs that export our data from UniData to
tab-delimited text files. Some of these are opened by Excel (which has
: [U2] Simple Export to Excel
Dunno, how about converting double quotes in the data to single quotes?
Or stripping them out entirely?
Ed
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John
R.
Sent: 22 June
This took some tweaking of my test program, but I think with all the needed
tests and data scrubbing, this is the way to go. It took some playing around
with the commas and quotes (the raw data could have either or both of these
conditions). It also deals with putting multiple lines in a
data.
Israel, John R. wrote:
This took some tweaking of my test program, but I think with all the needed
tests and data scrubbing, this is the way to go. It took some playing around
with the commas and quotes (the raw data could have either or both of these
conditions). It also deals
I use all upper case for everything except comments.
This ensures that if I am looking for code via an ESEARCH, I will have a better
chance to find it. Some of my tools don't case, but some do.
It will also be backward compatible.
John Israel
Sr. Programmer/Analyst
Dayton Superior
I agree completely. However, 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. Sure, I can put quotes around them, but when the
the = method, =1234567890,=001234,=01234,=1234
Will cause the import to treat as literalswhich might be a downside.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Monday, July 06, 2009 10:15 AM
UniData has a 2 gig limit on hashed files. What is the exact limit? Is it
really 2,147,483,648 (2**32)or is 2 gig a loose term. What is the true
threat level? Is it truly 2**31, or is it something else?
We will need to do something soon, but how soon is what I am trying to
determine.
Since it's a subroutine, shouldn't you RETURN to get out, not STOP?
Also, once you get this running, be sure to CLOSE any files that it OPENs or
you will have problems.
Here is another tip: triggers need to be cataloged globally. However, they can
call other subroutines that are cataloged
in the RETURN cleared up the error.
Thanks
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Monday, July 13, 2009 11:04 AM
To: 'U2 Users List'
Subject: Re: [U2] UV and triggers
To be safe, yes.
John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH 45342
937-866-0711 x44380
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Monday, July
In your program, do a CRT @(-1) at the top of the program to disable the paging.
John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH 45342
937-866-0711 x44380
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
Company
On 7/13/2009 10:25 AM, Israel, John R. wrote:
It has been my experience that you can RETURN out any program or subroutine.
If it is the top-level code, it simply stops. If it was called, it simply
returns back to the calling routine.
John Israel
Sr. Programmer/Analyst
Dayton
The first pass on a file has to start from scratch. Once it has been read and
is still fresh in memory, a 2nd pass will run much faster.
John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH 45342
937-866-0711 x44380
-Original Message-
From:
If you dig enough, you will find that ESC is defined somewhere as CHAR(27). It
may be buried in INCLUDES.
John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH 45342
937-866-0711 x44380
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
We are migrating from UniData 6.0.4 to UniData 7.2.1. Can we do a simple UNIX
cp from the old box to the new box, or have the guts of the UniData files
changed in some minor way? Thus far, it looks like it will work, but I don't
want to be a month into a LIVE deployment and find there is some
it might be a good idea to rebuild all index's. Do you have a var
doing the upgrade or an IBM rep? The docs probably address this.
Israel, John R. wrote:
We are migrating from UniData 6.0.4 to UniData 7.2.1. Can we do a simple
UNIX cp from the old box to the new box, or have the guts
I put all my standard code in various INCLUDES. One of these includes standard
bailout values (EX,Q,EXIT,...), the name of the program running:
THIS.PROGRAM = SYSTEM(40)
CONVERT / TO @FM IN THIS.PROGRAM
NO.FLDS = DCOUNT(THIS.PROGRAM, @FM)
THIS.PROGRAM = THIS.PROGRAMNO.FLDS[2,99]
and
There are 5 arguments passed with a trigger:
STATUS.FLAG
DICT.FLAG
File Pointer
Key
Record
The File Pointer is a handle to the OPENED file, not the NAME of the file. How
would I determine the name of the file that has the trigger assigned to it?
Purpose:
We have MANY triggers. Due to
Of Israel, John
R.
Sent: 06 August 2009 16:39
To: 'U2 Users List'
Subject: [U2] Mass Disabling Triggers
There are 5 arguments passed with a trigger:
STATUS.FLAG
DICT.FLAG
File Pointer
Key
Record
The File Pointer is a handle to the OPENED file, not the NAME of the
file. How would I determine the name
I am using SB 5.4 on Vista64 w/o any problems.
John Israel
Senior Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Miamisburg, OH 45342
937-866-0711 x44380
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On
What is your source? It is not on the http://www.rocketsoftware.com/ web site
(at least not that I have found).
John Israel
Senior Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Miamisburg, OH 45342
937-866-0711 x44380
-Original Message-
From:
I agree.
I am also a little disappointed that nobody from Rocket has chimed in to this
group. I know they may not be able to say anything officially, but they ought
to say SOMETHING!!!
John Israel
Senior Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Miamisburg, OH 45342
Link did not work.
John Israel
Senior Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Miamisburg, OH 45342
937-866-0711 x44380
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of BraDav
Sent: Tuesday,
If I understand your question, you are simply wanting a dump of every field in
a file because, potentially, you do not know all the field names.
Try:
LIST filename ALL
However, this has several issues:
1 - you can have synonyms for the same field - how would the command know which
one to
Dattatraya,
What do you mean by the 3 hidden columns? Are they fields that exist in the
DATA files but have no DICT that defines the fields? If that is the case, you
should determine what program is updating these fields, what type of data it
is, then build the missing Dicts. This is simply
Here is an unlikely reason for the missing Dicts (I am assuming they are
missing):
Whoever created the fields did not want people to easily access them. For
example, un-encrypted passwords.
I seriously doubt this is the situation, but I thought I would just throw it
out.
My vote is still
for you that your system works well, but I hope I never have to
come in after you all retire! ;-)
Susan Lynch
- Original Message -
From: Israel, John R. johnisr...@daytonsuperior.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: 10/14/2009 12:14 PM
Subject: Re: [U2] Unibasic: Sample
I agree with both setting a min modulus AND doing a CLEARFILE if the file is
empty.
Just remember that if an empty file has a big modulus, it can still take some
time for the select to chug through all the groups. That time will be
determined by the mod and the performance of your machine.
It's been a long time since I did one of these, but UniData has a conversion
tool to switch DICTs. It's pretty good, but as always, you need to verify.
John Israel
Senior Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Miamisburg, OH 45342
937-866-0711 x44380
-Original
I believe that someone mentioned in a post a few days ago that this limit is
1.5.
John Israel
Senior Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Miamisburg, OH 45342
937-866-0711 x44380
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
This looks a bit dangerous.
It is converting all @AMs and @VMs to pipes. This is assuming that the number
of AMs and VMs will be consistent for each REC - a very bad idea in general
considering the whole concept of multi-values (and for that matter,
multi-attributes).
To extract just
We use the UniData guide51 command to test the integrity of our files each
night and whenever our system takes a hit.
We are also using alternate indexing on some of our larger files.
Does guide51 test alternate index files?
If not, is there anything that DOES test the alternate index files?
Is
, Suite 400 **Denver, CO 80237 **USA
Tel: +1.720.475.8055
Email: wterh...@rs.com
Web: www.rocketsoftware.com/u2
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Wednesday, December 16, 2009 6:21 AM
...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Thursday, December 17, 2009 6:35 AM
To: U2 Users List
Subject: Re: [U2] UniData Guide Command
Wally,
Thanks for the help on the guide stuff.
My co-worker ran the guide_ndx command on all of the indexed files. He is
getting an error on one of the files
the NO.NULLS index setting?
Israel, John R. johnisr...@daytonsuperior.com 12/17/2009 10:39 AM
I believe I have the solution.
1) The field in question, ALT.BILL.TO, is not being used on our system.
2) It is indexed to speed up SELECT statements that came from the vendor (ex:
SELECT filename
1 - 100 of 340 matches
Mail list logo
