[Jack Plumb]

Charlie/Jim,

Thanks for the response. We ended up using Charlie’s suggestion.

I did not have an oppportunity to test Jim’s theory but will do that tomorrow.

Thanks again,

Jack

[Jack Plumb]

Actually I chose to use the IF ne @null and it works fine for

this particular case.

Thanks for the advice on the = sign.

Jack

[Jack Plumb]

Danial,

Well as luck would have it my concat works fine but of course the vendor can’t take the value if any of the inbound fields are blank. So if PV1-3.1, 3.2, 3.3 are blank I don’t want the concat to envoke.

I have tried various things in the IF statement (with the concat underneath) but my inexperience with Quovadx is getting in the way and can’t make it work.

What I need to do is NOT envoke the concat IF PV1-3.1, PV1-3.2 and PV1-3.3 are BLANK.

Any suggestions would be appreciated.

Jack

[Jack Plumb]

Daniel,

That did the trick. Thanks for the help.

Jack

[Jack Plumb]

Jim,

Ver 5.3

Unix

Not using bulkcopy

I checked the outbound variant an no fields are

set to be required an in the xlate the NK1, AL1, and

DG1  fields are set to optional. But there are other

segments that are NOT beging generated and are

part of the msg (A08). I did not change any values

from the standard A08 from the library.

I have found out that this seems to be a global issue not

just with my site.

Jack

[Author]

Replies