Thanks, all of you, for the clear explanation and alternatives. I
understand the issue now.
That information is very timely: the index I was considering adding
-could- have changed on the secondary file. I would have been chasing
that ghost for days :)
This message and all attachments are int
On 28/06/12 18:30, David A. Green wrote:
> Sure,
>
> Let's say you have a file "B" that has a customer number in the data and not
> the key.
>
> And you want to build a link from file "A" that also has a customer number
> in the data.
>
> You would build an index on file "B" for customer number.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, June 28, 2012 9:34 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Regarding: use of I - Descriptor
Could you expand on this?
-Original
Could you expand on this?
-Original Message-
From: David A. Green
To: 'U2 Users List'
Sent: Thu, Jun 28, 2012 8:26 am
Subject: Re: [U2] Regarding: use of I - Descriptor
An alternative method is to create an index on the secondary file then
reate an I-Desc SUBR to access
-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Bullard
Sent: Thursday, June 28, 2012 4:31 AM
To: U2 Users List
Subject: Re: [U2] Regarding: use of I - Descriptor
"You can even put alternate indexes on I-Desc, though this can lead to
se
a payment on a closed
transaction.
Brenda
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Bullard
Sent: Thursday, June 28, 2012 7:31 AM
To: U2 Users List
Subject: Re: [U2] Regarding: use of I - Descriptor
&qu
Of John Bullard
Sent: Thursday, June 28, 2012 7:31 AM
To: U2 Users List
Subject: Re: [U2] Regarding: use of I - Descriptor
"You can even put alternate indexes on I-Desc, though this can lead to serious
problems if you are indexing a translate."
I read this comment (from an earlier thre
"You can even put alternate indexes on I-Desc, though this can lead to
serious problems if you are indexing a translate."
I read this comment (from an earlier thread on this list) and started
worrying: I have a requirement to select records based on a field that
is not currently in the record. I
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Tuesday, 26 June 2012 3:24 AM
To: 'U2 Users List'
Subject: Re: [U2] Regarding: use of I - Descriptor
Satya,
Roughly speaking, and I-Desc is a way to manipulate the data so that you can select or
display data in
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Tuesday, 26 June 2012 3:24 AM
To: 'U2 Users List'
Subject: Re: [U2] Regarding: use of I - Descriptor
Satya,
Roughly speaking, and I-Desc is a way to manipulate the data so that you can
select or display data in
Another good source for self-training is here:
http://www.rocketsoftware.com/u2/resources/technical-resources
Also, something I do for some people, is to provide specialized
one-on-one customized training, if their needs are above and beyond what
anyone will do here. In other words, it isn't t
, 2012 12:44 PM
To: U2 Users List
Subject: Re: [U2] Regarding: use of I - Descriptor
Hi Martin,
Could you please let me know, to where i have to approach for Training.
or can you please suggest the best link to gain more knowledge on it
Thank you,
Satya.
On Mon, Jun 25, 2012 at 4:36 PM, Dawn
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips
Sent: Tuesday, June 26, 2012 11:48 AM
To: 'U2 Users List'
Subject: Re: [U2] Regarding: use of I - Descriptor
Hi Satya,
Although we deliver training to
: 26 June 2012 17:44
To: U2 Users List
Subject: Re: [U2] Regarding: use of I - Descriptor
Hi Martin,
Could you please let me know, to where i have to approach for Training. or
can you please suggest the best link to gain more knowledge on it
Thank you,
Satya.
On Mon, Jun 25, 2012 at 4:36 PM, Dawn
Hi Martin,
Could you please let me know, to where i have to approach for Training. or
can you please suggest the best link to gain more knowledge on it
Thank you,
Satya.
On Mon, Jun 25, 2012 at 4:36 PM, Dawn Wolthuis wrote:
> In SQL Server, I think it is called UDF = user-defined function
>
>
In SQL Server, I think it is called UDF = user-defined function
--dawn
On Mon, Jun 25, 2012 at 3:20 PM, Wols Lists wrote:
> On 25/06/12 17:47, Oaks, Harold wrote:
>> Hi Satya:
>>
>> An I-descriptor is the same as an I-type (or a V-type).
>>
>> It's like a little program in the DICT (dictionary)
On 25/06/12 17:47, Oaks, Harold wrote:
> Hi Satya:
>
> An I-descriptor is the same as an I-type (or a V-type).
>
> It's like a little program in the DICT (dictionary) of a file. It can
> do very complex things, but quite often is used for very simple things,
> but those simple things can be quit
Satya,
Roughly speaking, and I-Desc is a way to manipulate the data so that you can
select or display data in other ways. You can get data from another file,
perform some math on multiple fields, concatenate data, call a basic
subroutine, or any combination of these. You can have multiple com
I'll add a tidbit that some of the similar (not identical) names are:
virtual field
derived data
calculated field
computed column
user-defined function
stored procedure
--dawn
On Mon, Jun 25, 2012 at 11:47 AM, Oaks, Harold wrote:
> Hi Satya:
>
> An I-descriptor is the same as an I-type (or a V-t
Hi Satya,
These are really basic questions. You would be best to take a training course.
An I-descriptor is a calculated value based on other dictionary items. Field 2
holds an expression that can include most of the
things that you can do on the right hand side of an equals in an assignment
st
Hi Satya:
An I-descriptor is the same as an I-type (or a V-type).
It's like a little program in the DICT (dictionary) of a file. It can
do very complex things, but quite often is used for very simple things,
but those simple things can be quite helpful. Here is an example-
In the DICT of the I
21 matches
Mail list logo