DSXchange

Nice... double posts 36 minutes apart. Make sure you back up and see what you've missed.

Any idea what "getting stuck" actually means? An issue on the database side I would assume. Has your DBA monitored the job to see what happens when it runs?

Won't quite help as we need to modify the returned value to get rid of the field marks that are in it. If it doesn't like that array notation (depends on your exact version) then try this instead: Convert(@FM,"",Excmd_file.$CommandOutput) And see if it likes that expression (not 'express')...

It's sourced whenever a job starts, so I've found it unncessary for 99% of the changes that I've ever had to make. For whatever that is worth.

I'd also be curious if the existing "folder structure" was deleted first or you restored one on top of the other?

Ack... no-one ever mentioned using the concatenation operator and it never occurred to me you'd include the quotes after the full syntax had already been spelled out for you earlier. Oh well.

ps. Don't use the quotes that Arnd included, either.

Sainath.Srinivasan wrote:Also did you bounce your datastage instance after changes to dsenv ?

FYI - unnecessary.

How exactly did you "roll back"?

Explain what "not using key columns" means, are you saying there are no "where" clauses in your lookups?

Also, do any of them return more than a single record? If so, that would throw a kink into replacing them with hashed files.

Oh goodness, no wonder. Hashed files are the heart and soul of Server jobs, especially as reference lookups and you really need to learn how to leverage those. Direct database lookups are the slowest 'solution' you can use here. Do you have anyone there working with you who can help set you on the r...

Google Toolbar spell checker, that's what me use online. Too bad not grammar checker two.

Sai posted almost exactly the same steps that I did, which I find a little odd as it won't help at all at this point. Kamal - you need to answer Arnd's rather simple question: this "k_ftch" parameter you have in your job, what type is it? String, Pathname, what? And please confirm for me t...

What other errors are logged? I'm assuming that's your "From previous run..." message after you reset it, yes?

Yikes! All of that for CDD? You need to investigate the use of a NullToValue() transform and the CRC32 function. But again you need to make sure you identify the true bottleneck in your processing - is it one particular lookup? The stage variables? The database itself? You really need to break thing...

Still have no clue and generally when one asks a question they use one of these - "?". Give it a try sometime!

If no-one here can answer the question, then I'd still suggest asking it of your official support provider.