DSXchange

That's called 'hi-jacking'. Please don't jump on the end of someone else's thread with a completely different problem. And don't do it to yourself, either.

You both need to start new threads on these two new subjects.

You mean to say that even if we don't give the .csv extension it will result to a csv file when the 'record delimiter and final delimiters' is set to default values...!! Of course. There's no requirement that a 'comma separated value' file have a .csv extention, or even that a file with a .csv exte...

Correct. FYI - You can make it default to unchecked in the VC options settings.

True, it is optional. However, never really been sure what goes on under the covers if you uncheck that option as I never do. Does VC promote the run time components as well? Would make sense now that I think about it and simple enough to check, I suppose...

DataStage won't care what extension you give a sequential file. It's up to you to make them meaningful if you so desire. In this case you would just need to ensure that the field/column delimiter defined in the output stage was set to a comma, which would be the default I would think. Don't have acc...

I would like to know if it is possible without having to edit the other 2 sequential files and removing their 1st lines. No, not really. You'll need to find a way to strip the header record from the second and third file during (or before) the concatenation. Either that or a way to recognize and sk...

It may depend on the exact DS version you have as earlier ones didn't quite work.

It is required to have all columns bound into the query. So with four columns, your query would need to have :1, :2, :3 and :4 in it somewhere.

If you do not need to update a particular column, do not include it in the stage.

Yup... got a couple of ideas on how to work around this. We'll see.

FYI:

No PX here, but as far as I know it would be required on all servers, as VC promotes the source and then recompiles everything.

There are no hardware requirements. It's just another client tool like Designer or Director and 'attaches' to any given project in the same manner. That client connection is what is used to Initialize from a project or to Promote to a project.

Exactly.

Maybe. It is the preferred solution now that the stage is available.

We know. Run it from the command line... does it work then?