Re: [U2] Web Services Developer

[Geoff Mitchell]

(This did not seem to go through the first time I sent it.  I think maybe my
list subscription was from the wrong account?  Hopefully, it is fixed now.)

If you are just wanting a mock version of the web service to test against,
take a look at SoapUI (www.soapui.org).  It's free and does exactly what I
think you want.  You can give it a wsdl, and tell it to run a service matching
that wsdl.  You can make calls against it and see what is passed by the
caller.  You can also use it in the reverse direction to test your own web
services.

On 12/15/2008 at 12:14 PM, iggch...@comcast.net wrote:
No, someone had given me a wsdl from an as400 that I need to communicate
with.B  Not knowing much about webservices, I was hoping I could, somehow,
load that into the u2 web services developer, create a matching subroutine,
and be flying.B  Probably not that simple eh?



Thanks




- Original Message -
From: David S Hona david.h...@eds.com
To: u2-users@listserver.u2ug.org
Sent: Friday, December 12, 2008 12:42:32 AM GMT -06:00 US/Canada Central
Subject: RE: [U2] Web Services Developer

Do you mean an existing WSDL file, that you have previously
defined/created using U2WSD, but you're moving from a different PC?


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of
iggch...@comcast.net
Sent: Friday, 12 December 2008 7:27 AM
To: u2-Users
Subject: [U2] Web Services Developer

Hi All,



Does anyone know of a way to import an existing wsdl into the Web
Services Developer?



Thanks in advance for any info provided.
---
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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] UV/SQL syntax

[Geoff Mitchell]

(This did not seem to go through the first time I sent it.  I think maybe my
list subscription was from the wrong account?  Hopefully, it is fixed now.)

DELETE FROM FILE_ASSOCIATION where @ID=FRED;

If there is not an appropriate association, you can use each dictionary name
to clear them one at a time.

The key is that in SQL, the association (or un-associated MV field) is treated
as a sub table.  What you want is to remove records from the sub-table.

On 12/11/2008 at 9:37 PM, Boydell, Stuart stuart.boyd...@spotless.com.au
wrote:
I have an item with several related MV attributes which I want to set to
null using SQL.

001 Some data I want to keep
002 a]b]c]d
003 desc a]desc b]desc c]desc d
004 Some more data I want to keep

If I use UPATE FILE SET ATT2 = '',ATT3 = '' WHERE @ID = 'FRED' I get

001 Some data I want to keep
002 ]]]
003 ]]]
004 Some more data I want to keep

When what I really want is:

001 Some data I want to keep
002
003
004 Some more data I want to keep

Is there a way to do this?

Many thanks,
Stuart Boydell



**
This email message and any files transmitted with it are confidential and
intended solely for the use of addressed recipient(s). If you have received
this communication in error, please reply to this e-mail to notify the sender
of its incorrect delivery and then delete it and your reply.  It is your
responsibility to check this email and any attachments for viruses and
defects
before opening or sending them on. Spotless collects information about you to
provide and market our services. For information about use, disclosure and
access, see our privacy policy at http://www.spotless.com.au
Please consider our environment before printing this email.
**
---
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/