DSXchange

What have you tried?

Can do.

How do you intend to find which columns are required in output?

Does the script run outside DS? i.e. from Unix

Maybe you are looking for
dsjob -lprojects

assuming you mean server and not job

You need one more stage.

How did you split the row and write into the same output dataset?

Have a look in the director log for any messages.

Maybe it is written with header

I think he is looking for > 1 rows

Start time of what?

Job start time is already available in macros.

Maybe you are converting the value.

The message tells you everything

"Career_DT"
Attempt to convert String value "0" to Timestamp type

The requirement is in the sequencer and not in the job.

IConv and OConv

Craig,

You are cheeky

I think you posted a similar question and was answered with a shell script.

Can you clarify why you specifically need a routine? Also what is the purpose?

Data Mirror can be configured to trace changes on specific columns.

If the input has more columns that you need, you can do an internal change-compare of redup to identify changes.

Anyway, you can update all columns so to keep up to date.