DSXchange

... just had to go google up what exactly a "VARGRAPHIC" field might be. Not something I've run across before.

Vargraphic? That's... interesting. Glad you figured it out.

Does that mean you are running the 8.1 version?

Well, that's odd... what happened to your second post, the one I replied to? It basically said that this "worked in 8.5 but not in 8.1", hence my question...

Let me expand on this just so (hopefully) I'm being clear to whomever is reading this. And understand that I'm not trying to pick on you here, just attempting to do my job as a Moderator and explain How Things Work Here... We are obviously here to help people, the number of years and posts that many...

Your question is fine, it's just that I for one have no idea what the answer might be. I thought the name of the job was only in the DSJOB table as the NAME field, I'm not familiar with the gory details of the JOBRUN and JOBEXEC tables. If your filter is working it must be present there in some fash...

OK, I've fixed your post, marked it as a Parallel job. "Like a password"? You mean the DataStage encryption that an encrypted Job Parameter field would use, say for a password? If that's what you meant, it is not published. I would suggest you stick with one of the native DB2 encryption fu...

Define "encrypt". Were you told how it needs to be encrypted? There are quite a number of choices out there, including DB2 functions I would imagine. I'd also be curious if this is a Server job as the post is marked or a Parallel job based on the forum we're in...

Can you post the entire "handle" error message or was that it?

Interesting, a registry hack. My only concern might be that it is not specific to DataStage but will effect your entire Windows installation.

:? All of these generic questions with made up examples and zero explanation of what you've tried or what real world problem you are trying to solve look suspiciously like you are fishing for interview answers. That is something we do not condone here. I'm this close to going back and either removin...

I seriously doubt that example actually represents the incoming data such that you can assume the last field will always match the row number. A generic answer would be to count() the delimiters and pull the "count+1" field from the "_" delimited string.

You don't need to make the output name field 50, it should match the size of a single input name field. What 8.x version do you have? Are you using the Pivot Enterprise stage?

That would be an 8.5+ feature.

They're not "junk" but probably EOR markers in your file. Make sure your file format matches the target system, meaning create it as a DOS file if you're going to send it as an email attachment.

It reads the job's current status which is stored in the RT_STATUSnnn table.