Help

Barak Griffis
Assistant Systems Administrator
Affinity Plus Federal Credit Union



On Jan 29, 2011, at 2:00 PM, "[email protected]" 
<[email protected]> wrote:

> Send U2-Users mailing list submissions to
>    [email protected]
>
> To subscribe or unsubscribe via the World Wide Web, visit
>    http://listserver.u2ug.org/mailman/listinfo/u2-users
> or, via email, send a message with subject or body 'help' to
>    [email protected]
>
> You can reach the person managing the list at
>    [email protected]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of U2-Users digest..."
>
>
> _____________________________________________________________________
> This message has been checked for all known viruses by the MessageLabs Virus 
> Scanning Service (www.messagelabs.com/stats.asp).
> <Today's Topics (21 messages)>
> The only thing I'm using it for is to get currency exchange rates.
>
> On Fri, Jan 28, 2011 at 1:50 PM, David Wolverton <[email protected]> wrote:
>> What uses have you found for CallHTTP for in your applications?
>>
>> Are you 'eating' someone else's data with it - like doing lookups against a
>> web service call?
>>
>> Or are you using it to 'serve' data to others?  Rocket says you can do this,
>> but I can't see how it would work offhand and would like to know the
>> scenario.
>>
>> How complex have you found it and how stable?
>>
>> Thanks for your thoughts!
>>
>>
>>
>>
>>
>> _______________________________________________
>> U2-Users mailing list
>> [email protected]
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>>
>
> On 28/01/11 19:21, Bill Haskett wrote:
>> Arnold:
>>
>> I'm not sure about UV but in UD, when I change windows permissions, they
>> immediately work through UD.  This is because UD uses Windows
>> permissions and doesn't have their own security (well, limited anyway).
>
> Are you confusing user and file permissions? This should be a Windows
> thing, nothing to do with the app.
>>
>> I didn't realize UV was different.
>
> On nix, user rights are allocated at login. Change groups, etc and you
> have to log in again to get the new rights. I'd be very surprised if UV
> caches user groups etc and UD doesn't.
>
> But regardless of OS or DB, changing FILE permissions should take effect
> immediately (barring the app having the file already open and caching
> the file descriptor).
>>
>> Bill
>
> Cheers,
> Wol
>
> We're using it to consume address verification web services.
>
> Larry Hiscock
> Western Computer Services
>
>
> On Fri, Jan 28, 2011 at 1:50 PM, David Wolverton <[email protected]> wrote:
>> What uses have you found for CallHTTP for in your applications?
>>
>> Are you 'eating' someone else's data with it - like doing lookups against
> a
>> web service call?
>>
>> Or are you using it to 'serve' data to others?  Rocket says you can do
> this,
>> but I can't see how it would work offhand and would like to know the
>> scenario.
>>
>> How complex have you found it and how stable?
>>
>> Thanks for your thoughts!
>>
>
>
>
> BUILD.INDEX has to be able to get exclusive access to the primary file to 
> start.
> It then blocks updates to the primary file (reads allowed) until it is 
> finished.
> This is the long-time default behavior.
>
> Of course, you can use BUILD.INDEX ... ONLINE to avoid that requirement.
> This is a bit slower, but you can do it.
>
> Wally Terhune
> U2 Support Architect
> Rocket Software
> 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA
> Tel: +1.720.475.8055
> Email: [email protected]
> Web: www.rocketsoftware.com/u2
>
>
>
> -----Original Message-----
> From: [email protected] 
> [mailto:[email protected]] On Behalf Of Jeffrey Butera
> Sent: Friday, January 28, 2011 12:12 PM
> To: Susan Lynch
> Cc: U2 Users List
> Subject: Re: [U2] Unidata can't build index
>
>  On 01/28/11 14:11, Susan Lynch wrote:
>> Jeff, did you do a CREATE.INDEX H08.PERSON.LOOKUP XPL.PERSON.ID first?
>>
>
> Yes, LIST.INDEX properly displayed all the indices including
> XPL.PERSON.ID which was new (but not built).
>
> --
> Jeff Butera, Ph.D.
> Manager of ERP Systems
> Hampshire College
> [email protected]
> 413-559-5556
>
> "...we must choose between what is right and what is easy..."
>                                       Dumbledore
>
> _______________________________________________
> U2-Users mailing list
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
> On 1/28/2011 1:50 PM, David Wolverton wrote:
>> What uses have you found for CallHTTP for in your applications?
> None whatsoever.
>> Are you 'eating' someone else's data with it - like doing lookups against a
>> web service call?
>>
>> Or are you using it to 'serve' data to others?  Rocket says you can do this,
>> but I can't see how it would work offhand and would like to know the
>> scenario.
>>
>> How complex have you found it and how stable?
>>
> Too complex, not sure about stability.
>
> I am following someone on c.d.p's lead from 2006 and using curl.  I have
> also used wget in the past for a dictionary items to do a filecheck on
> web images.  You can use wget in --spider mode and it will just give you
> back an http 200 if the file resolves, but will not actually download it.
>> Thanks for your thoughts!
>>
>>
>>
>>
>>
>> _______________________________________________
>> U2-Users mailing list
>> [email protected]
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>
> CallHTTP is used to call someone else's http service like a webservice or an
> actual web page,  we use it to communicate with web services, rss feeds, and
> also html documents that we analyse.
>
>
>
> In order to serve data to others you would not use callhttp - you should use
> the sockets interface - or preferably write a webservice in say .net and use
> uniobjects.net - it really is 20 lines of code.
>
>
>
> From: [email protected]
> [mailto:[email protected]] On Behalf Of David Wolverton
> Sent: 28 January 2011 18:50
> To: 'U2 Users List'
> Subject: [U2] What do you do with CallHTTP?
>
>
>
> What uses have you found for CallHTTP for in your applications?
>
> Are you 'eating' someone else's data with it - like doing lookups against a
> web service call?
>
> Or are you using it to 'serve' data to others?  Rocket says you can do this,
> but I can't see how it would work offhand and would like to know the
> scenario.
>
> How complex have you found it and how stable?
>
> Thanks for your thoughts!
>
>
>
>
>
> _______________________________________________
> U2-Users mailing list
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>  _____
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1204 / Virus Database: 1435/3408 - Release Date: 01/28/11
>
>
> I tried to but we are still using AIX 4.3.3 and UV 9.6
>
> Garry L. Smith
> Dir Info Systems
> Charles McMurray Company
> V# 559-292-5782   F# 559-346-6169
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Steve Romanow
> Sent: Friday, January 28, 2011 1:29 PM
> To: U2 Users List
> Subject: Re: [U2] What do you do with CallHTTP?
>
> On 1/28/2011 1:50 PM, David Wolverton wrote:
>> What uses have you found for CallHTTP for in your applications?
> None whatsoever.
>> Are you 'eating' someone else's data with it - like doing lookups
>> against a web service call?
>>
>> Or are you using it to 'serve' data to others?  Rocket says you can do
>
>> this, but I can't see how it would work offhand and would like to know
>
>> the scenario.
>>
>> How complex have you found it and how stable?
>>
> Too complex, not sure about stability.
>
> I am following someone on c.d.p's lead from 2006 and using curl.  I have
> also used wget in the past for a dictionary items to do a filecheck on
> web images.  You can use wget in --spider mode and it will just give you
> back an http 200 if the file resolves, but will not actually download
> it.
>> Thanks for your thoughts!
>>
>>
>>
>>
>>
>> _______________________________________________
>> U2-Users mailing list
>> [email protected]
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
> _______________________________________________
> U2-Users mailing list
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>
> Which twenty?
>
>
>
>
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: Symeon Breen <[email protected]>
> To: 'U2 Users List' <[email protected]>
> Sent: Fri, Jan 28, 2011 2:18 pm
> Subject: Re: [U2] What do you do with CallHTTP?
>
>
> CallHTTP is used to call someone else's http service like a webservice or an
>
> actual web page,  we use it to communicate with web services, rss feeds, and
>
> also html documents that we analyse.
>
>
>
>
>
>
>
> In order to serve data to others you would not use callhttp - you should use
>
> the sockets interface - or preferably write a webservice in say .net and use
>
> uniobjects.net - it really is 20 lines of code.
>
>
>
>
>
>
>
> From: [email protected]
>
> [mailto:[email protected]] On Behalf Of David Wolverton
>
> Sent: 28 January 2011 18:50
>
> To: 'U2 Users List'
>
> Subject: [U2] What do you do with CallHTTP?
>
>
>
>
>
>
>
> What uses have you found for CallHTTP for in your applications?
>
>
>
> Are you 'eating' someone else's data with it - like doing lookups against a
>
> web service call?
>
>
>
> Or are you using it to 'serve' data to others?  Rocket says you can do this,
>
> but I can't see how it would work offhand and would like to know the
>
> scenario.
>
>
>
> How complex have you found it and how stable?
>
>
>
> Thanks for your thoughts!
>
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
>
> U2-Users mailing list
>
> [email protected]
>
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>
>
>  _____
>
>
>
> No virus found in this message.
>
> Checked by AVG - www.avg.com
>
> Version: 10.0.1204 / Virus Database: 1435/3408 - Release Date: 01/28/11
>
>
>
> _______________________________________________
>
> U2-Users mailing list
>
> [email protected]
>
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>
>
>
>
>
> Somewhere embedded in those 20 lines are the two special instructions:
> RMM (read my mind)
> DWIM (do what I meant)
>
> :)
>
> -----Original Message-----
> From: [email protected] 
> [mailto:[email protected]] On Behalf Of [email protected]
> Sent: Friday, January 28, 2011 3:05 PM
> To: [email protected]
> Subject: Re: [U2] What do you do with CallHTTP?
>
>
> Which twenty?
>
>
>
>
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: Symeon Breen <[email protected]>
> To: 'U2 Users List' <[email protected]>
> Sent: Fri, Jan 28, 2011 2:18 pm
> Subject: Re: [U2] What do you do with CallHTTP?
>
>
> CallHTTP is used to call someone else's http service like a webservice or an
>
> actual web page,  we use it to communicate with web services, rss feeds, and
>
> also html documents that we analyse.
>
>
>
>
>
>
>
> In order to serve data to others you would not use callhttp - you should use
>
> the sockets interface - or preferably write a webservice in say .net and use
>
> uniobjects.net - it really is 20 lines of code.
>
>
>
>
>
>
>
> From: [email protected]
>
> [mailto:[email protected]] On Behalf Of David Wolverton
>
> Sent: 28 January 2011 18:50
>
> To: 'U2 Users List'
>
> Subject: [U2] What do you do with CallHTTP?
>
>
>
>
>
>
>
> What uses have you found for CallHTTP for in your applications?
>
>
>
> Are you 'eating' someone else's data with it - like doing lookups against a
>
> web service call?
>
>
>
> Or are you using it to 'serve' data to others?  Rocket says you can do this,
>
> but I can't see how it would work offhand and would like to know the
>
> scenario.
>
>
>
> How complex have you found it and how stable?
>
>
>
> Thanks for your thoughts!
>
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
>
> U2-Users mailing list
>
> [email protected]
>
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>
>
>  _____
>
>
>
> No virus found in this message.
>
> Checked by AVG - www.avg.com
>
> Version: 10.0.1204 / Virus Database: 1435/3408 - Release Date: 01/28/11
>
>
>
> _______________________________________________
>
> U2-Users mailing list
>
> [email protected]
>
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>
>
>
>
> _______________________________________________
> U2-Users mailing list
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>> From: David Wolverton
>> What uses have you found for CallHTTP for in your applications?
>
>
> David, as you know, I use web services every day and have written
> articles, products, and interfaces for clients based on them.
>
> The modern world is all about The Cloud, Virtualization, Software
> As A Service, the Service Oriented Architecture, and Web
> Services.  A significant percentage of code these days is
> dedicated to exchanges via SOAP, XMLRPC, REST, and other
> protocols over HTTP.  To the rest of the world, this is simply
> the way things are now done, whether we're talking about moving
> documents, requesting services, controlling devices, or storing
> data.
>
> I encourage you to elevate the question past "What uses have you
> found" in an MV-based forum.  In this market some people are
> still kicking the tires on paradigms that have been accepted in
> the rest of the world for over a decade.  Look to the mainstream
> for examples of web services (particularly REST).  You'll find a
> lot of inspiration there, and it will apply to your MV work as
> much as it applies to anyone else.
>
> The CallHTTP interface is just a tool.  HTTP interfaces can be
> done in many ways.  Once you have a better feel for the scope of
> applications, you'll have your answer about CallHTTP in
> particular, and you can consider that as one possible tool for
> implementation.  (This concept applies to All tools in the MV
> world.)
>
> As to how you send data to a trading partner with CallHTTP, the
> payload is in your query.  You should be able to push out any
> information that can be provided in a URL, or via a GET/POST
> request from a browser form.
>
> HTH
>
> Tony Gravagno
> Nebula Research and Development
> TG@ remove.pleaseNebula-RnD.com
> Nebula R&D sells mv.NET and other Pick/MultiValue products
> worldwide, and provides related development services
> remove.pleaseNebula-RnD.com/blog
> Visit PickWiki.com! Contribute!
> http://Twitter.com/TonyGravagno
>
>
>
> FXI  = 1ýý
>
> DCount(FXI,VM) returns 3
> Is there function to clear the blank value marks so that FXI = 1     and then 
> DCOUNT would return 1
>
> TIA
>
> Garry L. Smith
> Dir Info Systems
> Charles McMurray Company
> V# 559-292-5782   F# 559-346-6169
>
> -----Original Message-----
> From: Garry Smith
> Sent: Friday, January 28, 2011 2:04 PM
> To: 'U2 Users List'
> Subject: RE: [U2] What do you do with CallHTTP?
>
> I tried to but we are still using AIX 4.3.3 and UV 9.6
>
> Garry L. Smith
> Dir Info Systems
> Charles McMurray Company
> V# 559-292-5782   F# 559-346-6169
>
> -----Original Message-----
> From: [email protected] 
> [mailto:[email protected]] On Behalf Of Steve Romanow
> Sent: Friday, January 28, 2011 1:29 PM
> To: U2 Users List
> Subject: Re: [U2] What do you do with CallHTTP?
>
> On 1/28/2011 1:50 PM, David Wolverton wrote:
>> What uses have you found for CallHTTP for in your applications?
> None whatsoever.
>> Are you 'eating' someone else's data with it - like doing lookups
>> against a web service call?
>>
>> Or are you using it to 'serve' data to others?  Rocket says you can do
>> this, but I can't see how it would work offhand and would like to know
>> the scenario.
>>
>> How complex have you found it and how stable?
>>
> Too complex, not sure about stability.
>
> I am following someone on c.d.p's lead from 2006 and using curl.  I have also 
> used wget in the past for a dictionary items to do a filecheck on web images. 
>  You can use wget in --spider mode and it will just give you back an http 200 
> if the file resolves, but will not actually download it.
>> Thanks for your thoughts!
>>
>>
>>
>>
>>
>> _______________________________________________
>> U2-Users mailing list
>> [email protected]
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
> _______________________________________________
> U2-Users mailing list
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>> From: Symeon Breen
>> In order to serve data to others you would not use
>> callhttp - you should use the sockets interface - or
>> preferably write a webservice in say .net and use
>> uniobjects.net - it really is 20 lines of code.
>
>> From: fft2001
>> Which twenty?
>
> Symeon - I know you know this, just clarifying...  It seems you
> wanted to make sure someone didn't think CallHTTP was a server
> component.  But as a client CallHTTP is OK to push data out to
> another site.
>
> Will - I have a video on my site that shows how to create web
> service clients and servers for MV with .NET.  It really can be
> trivial, and yes, less than 20 lines of code of "functional" code
> which you can see in the video.  I'm using mv.NET but the UO.NET
> is very close.
>
> nospam.pleaseNebula-RnD.com/products/gallery.htm
>
> T
>
> Purists can consider the above an AD, though the rest of us can
> see it's free. ;)
>
>
>> From: Symeon Breen
>> In order to serve data to others you would not use
>> callhttp - you should use the sockets interface - or
>> preferably write a webservice in say .net and use
>> uniobjects.net - it really is 20 lines of code.
>
>> From: fft2001
>> Which twenty?
>
> Symeon - I know you know this, just clarifying...  It seems you
> wanted to make sure someone didn't think CallHTTP was a server
> component.  But as a client CallHTTP is OK to push data out to
> another site.
>
> Will - I have a video on my site that shows how to create web
> service clients and servers for MV with .NET.  It really can be
> trivial, and yes, less than 20 lines of code of "functional" code
> which you can see in the video.  I'm using mv.NET but the UO.NET
> is very close.
>
> nospam.pleaseNebula-RnD.com/products/gallery.htm
>
> T
>
> Purists can consider the above an AD, though the rest of us can
> see it's free. ;)
>
>
> On 1/28/2011 3:49 PM, Larry Hiscock wrote:
>> We're using it to consume address verification web services.
>>
>> Larry Hiscock
>> Western Computer Services
>>
> Can you recommend a company for CASS verification?
>
> We've long had a "strip nulls" subroutine we use to do this sort of thing. 
> You'd have to write a program to select the records, read, strip and write 
> out the data.
>
> Jeff Butera
> Sent from my iPhone
>
> On Jan 28, 2011, at 7:29 PM, "Garry Smith" <[email protected]> wrote:
>
>> FXI  = 1ýý
>>
>> DCount(FXI,VM) returns 3
>> Is there function to clear the blank value marks so that FXI = 1     and 
>> then DCOUNT would return 1
>>
>> TIA
>>
>> Garry L. Smith
>> Dir Info Systems
>> Charles McMurray Company
>> V# 559-292-5782   F# 559-346-6169
>>
>> -----Original Message-----
>> From: Garry Smith
>> Sent: Friday, January 28, 2011 2:04 PM
>> To: 'U2 Users List'
>> Subject: RE: [U2] What do you do with CallHTTP?
>>
>> I tried to but we are still using AIX 4.3.3 and UV 9.6
>>
>> Garry L. Smith
>> Dir Info Systems
>> Charles McMurray Company
>> V# 559-292-5782   F# 559-346-6169
>>
>> -----Original Message-----
>> From: [email protected] 
>> [mailto:[email protected]] On Behalf Of Steve Romanow
>> Sent: Friday, January 28, 2011 1:29 PM
>> To: U2 Users List
>> Subject: Re: [U2] What do you do with CallHTTP?
>>
>> On 1/28/2011 1:50 PM, David Wolverton wrote:
>>> What uses have you found for CallHTTP for in your applications?
>> None whatsoever.
>>> Are you 'eating' someone else's data with it - like doing lookups
>>> against a web service call?
>>>
>>> Or are you using it to 'serve' data to others?  Rocket says you can do
>>> this, but I can't see how it would work offhand and would like to know
>>> the scenario.
>>>
>>> How complex have you found it and how stable?
>>>
>> Too complex, not sure about stability.
>>
>> I am following someone on c.d.p's lead from 2006 and using curl.  I have 
>> also used wget in the past for a dictionary items to do a filecheck on web 
>> images.  You can use wget in --spider mode and it will just give you back an 
>> http 200 if the file resolves, but will not actually download it.
>>> Thanks for your thoughts!
>>>
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> U2-Users mailing list
>>> [email protected]
>>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>>
>> _______________________________________________
>> U2-Users mailing list
>> [email protected]
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>> _______________________________________________
>> U2-Users mailing list
>> [email protected]
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
> I suspect that there is no canned function.
>
> I little homemade sub could look like
>
> SUBROUTINE SUB.XM.Counter(FXI, XM.Count)
>
> XM.Count = 0
>                Total.String.Length = len(FXI)
> For Posn = 1 to Total.String.Length
>
>  Next = Posn + 1
>
>  This.Char = FXI[Posn, 1]
>  Next.Char = FXI[Next, 1]
>
>  Begin case
>        Case This.Char = VM  ;  begin case
>                                              Case This.Char = Next.Char  ;  
> null
>                                      Case 1                      ;  XM.Count 
> += 1
>                               End    case
>  End   case
>
> Next Posn
>
> return
> END
>
> I hope that I made no speling mistakes this time...
>
> --Bill
>
> -----Original Message-----
> From: [email protected] 
> [mailto:[email protected]] On Behalf Of Garry Smith
> Sent: Friday, January 28, 2011 7:30 PM
> To: U2 Users List
> Subject: [U2] How to Clear Empty VM marks in Field
>
> FXI  = 1ýý
>
> DCount(FXI,VM) returns 3
> Is there function to clear the blank value marks so that FXI = 1     and then 
> DCOUNT would return 1
>
> TIA
>
> Garry L. Smith
> Dir Info Systems
> Charles McMurray Company
> V# 559-292-5782   F# 559-346-6169
>
> -----Original Message-----
> From: Garry Smith
> Sent: Friday, January 28, 2011 2:04 PM
> To: 'U2 Users List'
> Subject: RE: [U2] What do you do with CallHTTP?
>
> I tried to but we are still using AIX 4.3.3 and UV 9.6
>
> Garry L. Smith
> Dir Info Systems
> Charles McMurray Company
> V# 559-292-5782   F# 559-346-6169
>
> -----Original Message-----
> From: [email protected] 
> [mailto:[email protected]] On Behalf Of Steve Romanow
> Sent: Friday, January 28, 2011 1:29 PM
> To: U2 Users List
> Subject: Re: [U2] What do you do with CallHTTP?
>
> On 1/28/2011 1:50 PM, David Wolverton wrote:
>> What uses have you found for CallHTTP for in your applications?
> None whatsoever.
>> Are you 'eating' someone else's data with it - like doing lookups
>> against a web service call?
>>
>> Or are you using it to 'serve' data to others?  Rocket says you can do
>> this, but I can't see how it would work offhand and would like to know
>> the scenario.
>>
>> How complex have you found it and how stable?
>>
> Too complex, not sure about stability.
>
> I am following someone on c.d.p's lead from 2006 and using curl.  I have also 
> used wget in the past for a dictionary items to do a filecheck on web images. 
>  You can use wget in --spider mode and it will just give you back an http 200 
> if the file resolves, but will not actually download it.
>> Thanks for your thoughts!
>>
>>
>>
>>
>>
>> _______________________________________________
>> U2-Users mailing list
>> [email protected]<mailto:[email protected]>
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
> _______________________________________________
> U2-Users mailing list
> [email protected]<mailto:[email protected]>
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> _______________________________________________
> U2-Users mailing list
> [email protected]<mailto:[email protected]>
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>
> On 1/28/2011 7:29 PM, Garry Smith wrote:
>> FXI  = 1ýý
>>
>> DCount(FXI,VM) returns 3
>> Is there function to clear the blank value marks so that FXI = 1     and 
>> then DCOUNT would return 1
>
>
> If your field is associated with any other fields, simply removing all
> value marks preceding null fields will potentially de-synchronize (is
> there such a word?) the relationships.  That is, you can remove any
> trailing VMs, but not any embedded ones.
>
> If I were doing this, I'd start with the base rule that we're working
> from the end of the string and rolling backwards until we hit a
> character that isn't a VM, and keeping everything up to there.
>
> So, using your example of "FXI  = 1ýý";
> here's a code sample:
>
> 0001       fxi = "a": @vm: @vm
> 0002       crt "fxi = ": fxi
> 0003       crt "dcount = ": dcount(fxi, @VM)
> 0004       len.fxi = len(fxi)
> 0005       if (len.fxi) then
> 0006          for i.char = len.fxi to 1 step -1
> 0007             if (fxi[i.char, 1] ne @vm) then exit
> 0008          next i.char
> 0009          *
> 0010          if (i.char lt len.fxi) then
> 0011             fxi = fxi[1, i.char]
> 0012          end
> 0013       end
> 0014       crt "fxi = ": fxi
> 0015       crt "dcount = ": dcount(fxi, @VM)
> 0016       crt "done"
> 0017       stop
> 0018    end
>
> And here's the output from it:
>> RUN PGMS TT
> fxi = aýý
> dcount = 3
> fxi = a
> dcount = 1
> done
>
>
>
> If you don't have to worry about associated fields and you're trying to
> clear null attributes or you want a count of the non-null attributes then
> trim is probably the easiest way (plus there are options to only clear
> leading,trailing,or all):
>
> FXI = TRIM(FXI,@VM)
>
> Hth
> Colin Alfke
> Calgary, Canada
>
> -----Original Message-----
> From: Allen Egerton
>
> On 1/28/2011 7:29 PM, Garry Smith wrote:
>> FXI  = 1ýý
>>
>> DCount(FXI,VM) returns 3
>> Is there function to clear the blank value marks so that FXI = 1     and
> then DCOUNT would return 1
>
>
> If your field is associated with any other fields, simply removing all
> value marks preceding null fields will potentially de-synchronize (is
> there such a word?) the relationships.  That is, you can remove any
> trailing VMs, but not any embedded ones.
>
>
>
> Garry,
>
> Since you described a simple situation, I'll provide a simple solution.
>
> FXI  = 1ýý
>
> DCOUNT(TRIM(FXI,@VM),@VM) should return 1.
>
> Best Regards,
> Richard Lewis
>
>
> On Fri, Jan 28, 2011 at 5:29 PM, Garry Smith 
> <[email protected]>wrote:
>
>> FXI  = 1ýý
>>
>> DCount(FXI,VM) returns 3
>> Is there function to clear the blank value marks so that FXI = 1     and
>> then DCOUNT would return 1
>>
>> TIA
>>
>> Garry L. Smith
>> Dir Info Systems
>> Charles McMurray Company
>> V# 559-292-5782   F# 559-346-6169
>>
>>
>> _______________________________________________
>> U2-Users mailing list
>> [email protected]
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>>
>
> We use Qualified Address (http://www.qualifiedaddress.com).  They offer both
> Address Verification as a web service and batch address scrubbing with full
> CASS certification.
>
> Larry Hiscock
> Western Computer Services
>
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Steve Romanow
> Sent: Friday, January 28, 2011 4:53 PM
> To: [email protected]
> Subject: Re: [U2] What do you do with CallHTTP?
>
> On 1/28/2011 3:49 PM, Larry Hiscock wrote:
>> We're using it to consume address verification web services.
>>
>> Larry Hiscock
>> Western Computer Services
>>
> Can you recommend a company for CASS verification?
> _______________________________________________
> U2-Users mailing list
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>
> On 29/01/11 04:33, Colin Alfke wrote:
>> If you don't have to worry about associated fields and you're trying to
>> clear null attributes or you want a count of the non-null attributes then
>> trim is probably the easiest way (plus there are options to only clear
>> leading,trailing,or all):
>>
>> FXI = TRIM(FXI,@VM)
>
> I was wondering if trim could do that...
>
> But my immediate reaction was matparse, matbuild. They all strip
> trailing delimiters by default.
>>
>> Hth
>> Colin Alfke
>> Calgary, Canada
>
> Cheers,
> Wol
>
> <Digest Footer>

_____________________________________________________________________
This message has been checked for all known viruses by the MessageLabs Virus 
Scanning Service (www.messagelabs.com/stats.asp).  
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to