DSXchange

Split the data (Copy stage), use two Column Import stages, then Join the streams back together. Or use a Transformer stage.

1) Probably, but no promises.
2) You haven't needed to access TMPDIR before.

Welcome aboard.

You have not provided sufficient information to enable a cogent answer. What do you mean by "change"?

Have you had any DataStage training? If not, I strongly recommend that you get some, as soon as possible.

Use an Execute Command activity downstream of the Routine activity. In the Execute Command activity execute a command that will write the routine output - captured from the $ReturnValue activity variable - into the file. One easy way is an echo command with > or >> redirection as appropriate.

Is this an interview question? Factless fact tables typically record that an event has occurred, an event with which no measurables are associated. One example is in academia. A class may be presented by a presenter in a particular location on a particular date and time. (Possibly number of students...

Welcome aboard. What precisely is your problem? What precisely do you want to do if the command returns a non-zero exit status? To have the routine return null, set Ans = @NULL. But is this really what you want to do? Also, when THEN or ELSE is the last word on its line, a corresponding END is requi...

No problem. Just encase the double-quote constant in single quotes (you'll have to type this in manually) and concatenate.

As noted, I am no longer at that site. Further, I was not directly involved, therefore have no details even in my memory.

If I had I would have posted something.

A couple of clients ago there were some inexplicable "Failed to start job" messages - I believe they ended up getting a patch.

Since I'm no longer there I can't advise the patch number, but you could search on Fix Central.

That's an in-house system - DataStage Manager is a job title in your organization.

Use the looping construct in the Transformer stage. (You will need to be on version 8.5 for this.)

I beg to differ. This is not a typical requirement.

Read the entire line as a single VarChar field, then concatenate quote characters in a Transformer stage before parsing into separate fields.

Rumu, have you tried what Mike suggested?

orissajobs welcome aboard, but you'll need to be much more specific about what kind of help you are seeking.

Parse the source into separate columns using a Column Import or Transformer stage, then pivot using a Pivot Enterprise stage.