DSXchange

You don't, you write it in the UV stage. As noted. And searching the forums for SETFILE which should help with the VOC issue.

Still invisible. [sigh]

Seems like my post is invisible. [scratches head]

'SQL delete' means exactly what it sounds like it means, you would use sql to delete the records just like you would from a relational table.

I have no idea why one would post the exact same issue (with identical wording) under two different names minutes apart. FYI - I randomly picked one to nuke, the one from Milin16. You can carry on in this one.

I'll wager your "impersonation" quest is a red herring. Tell us more about your "execute dsjob" problem - off the top of my head it sounds like you just need to 'source' your dsenv file first to properly set the environment up. So... if you could post some details as to what exac...

Look at the options available in that column and see if that answers your question... that and think of it as the "Missing Column" option.

If the hashed files are in an account (or otherwise have a VOC record) you could use the UV stage and SQL to delete records from them.

Let's get the first comment that you were going to get from someone out of the way - DataStage is an ETL tool, not a BI tool and what you have is not an ETL task. Does your company not have access to a BI tool, some kind of 'report writer' that would do a proper job of this? Otherwise what you have ...

I'm surprised you were actually able to add it to a Server job without excessive shenanigans.

That derived data type - i.e. your count() result - would be considered to be NUMERIC which is a float when unbounded... and, as noted, too big for a BigInt.

The stage is doing the conversion for you. Add a peek stage and verify the date format you are building, probably easier to debug if you build it in a stage variable and then convert the end result.

Me, I have no such experience. It was a legitimate question as I was curious if you had read the docs yet. They are there for a reason and really should be your first resource rather than coming here and expecting people to regurgitate information from them. Nothing stopping anyone from doing that f...

I was under the impression that the Connectors would come to the Server side of the house... later.

... and here we are.

I had to guess at the particulars, please feel free to correct them.

First question would be why does it come into DataStage like that? That's an XML thing, how is that involved here? :? For the original question, perhaps you could escape the "&" or use the appropriate value in a CHAR() function to avoid the metacharacter action that seems to be going on.