DSXchange

People probably thought you'd worked it out since it's been some time. I for one can't help, being unfamiliar with both DB2 and why View Data would work but a job run would not.

Have you involved your official support provider yet?

Escape the quotes. What actually works seems to vary with people and their specific version, but the first thing I'd try would be the standard "\" if "quoting the quotes" didn't work for you.

They can't be or you wouldn't be receiving this message. Riddle me this: do you have "colnam1" on the Columns tab of the stage?

You have a mismatch between the number of columns in the stage and the number of "?" bind variables. Remove "column1" from the stage since the stage will not be populating it.

No reason for anything like that, if both the source and target are a "date" data type as (as noted) there are no format to dates, they are stored internally in binary. Now if only one end or the other is a Date or there are two Strings involved then those functions are the way to go.

devesh_ssingh wrote:the op1 is not propely appering

it have huge space between columns, somehow its appering incorrect!!!

You need to get used to how forums like this work - any "extra" whitespace is automatically removed. The only way to preserve it is to use the "code" tags... like so.

Can you explain, please, how your choice of subject is related to the question that you asked?

The FTP stage is metadata driven, works record by record, and thus is not something you can use to transfer a zipped file.

More information, please. For example, what exactly is your "user defined update" sql? From what I recall, there should also be a final entry logged for the target stage in question here with details on records written, etc - can you post that as well?

An exact search here for "Error compiling Job Control Subroutine" found 12 other posts, some marked as resolved. See if any of those help you.

Do an exact search here for "Controller problem: Unhandled failure", it has been discussed here quite a number of times.

As to your question, I'm curious how you would handle this outside of DataStage? And I'm also wondering what is the goal here and why you'd need to do such a thing in an ETL tool? From a quick google: SqlServerWriter: The SqlServerWriter writer is a VSS (Volume Shadow Copy Service) Writer for SQL Se...

OK, so much for the you edit part... I'll take care of that now. And just so you know, there's no such release as "8.2", they went straight from 8.1 to 8.5.

Details! How exactly are you performing this conversion? Source, target, transformations, etc etc.

Done and working, I assume, so marking as Resolved.