Binary Fields and Sql Query's in Flows

Try casting your binary value to char or numeric, e.g.

CAST(SUM(DISTR_FTE) AS NUMERIC (16,3)) GL_FTE,
CAST(SUM(PrtWageAmount) AS DECIMAL(9,0)) TotWages
CAST(S.EMPLOYEE AS CHAR) EMPLOYEE,

Hi Mikep,
That didn't work. It's strange that it works in Sql Manager, but not when I use the same query in a Process Flow. Thank you for the response.

Are you getting incorrect results from the Cast, or a SQL syntax error?

Hi JimY,

You don't mention what database you're using, or what you are wanting to do with the agent value, so I'm not sure if this will help you. However, we use DB2, and using HEX(AGENT) converts the value into a string. However, if you are just joining to another binary value then you can leave it in the original format, even though it isn't pretty in the log. I'd think in MSSQL then MikeP is correct, the CAST or maybe CONVERT(varchar(64),AGENT,0) should work.

Good Luck!

It is Microsoft Sql Server. I tried to put the values here, but they don't display correctly. Sql Manager displays the value correctly, but Process Automation does not. The cast did not work in Process Automation, but did work in Sql Server Manager. I have opened a ticket with Infor to see what they have to say.

I was able to resolve this by using a Landmark Query Node. It took some time to get the quoting correct, but it work great.