DSXchange

As long as your sql is correct, it doesn't matter what your column names are in the stage. They usually match, of course, allowing the stage to generate the DML but with custom sql all things are possible. And since dashes are invalid in column names in a job, you don't have much choice there. Still...

Can you... quote the field names in your sql?

No, because it won't help. There is no "script", everything is stored in database tables in the repository. You need to export/import job designs from a client PC to implement change management. Search the forums for "dscmdexport" and "dscmdimport" for previous conversations on the subject. Now, if ...

Sure, but that depends entirely on what kind of support your company has purchased, if any. It could be with IBM directly or through a third-party. You need to ask your management.

OK, what about Ray's query?

"Space" in a fork error is memory space, not scratch space. It could mean disk, however, if you ran out of swap space on the node. Check with a SysAdmin for the time the job ran.

AFAIK, you need to 'read' all columns, even the ones you don't 'need'. And make sure their 'Display' size is correct in the stage as that is what drives how many bytes it reads per record.

Sounds like you haven't setup the XPath Expressions correctly. How did you generate them? Manually or did you import the metadata from an xsd or dtd? How much XML experience do you have?

Well... Disaster Recovery is different from High Availability. It's one thing to rebuild / transfer everything from one server to another (typically physically separated) to failing specific applications from one node of a cluster to another. You should be able to search for "high availability" as I...

How about you tell us why you think you need to know this? What problem are you trying to solve that you think this information will help with?

In other words, make sure you've specified a valid directory path and hashed file name, and that you have permissions to create files in that directory.

If I knew that, I would have posted the answer. Perhaps wrong, but I'm assuming the process isn't the same anymore in the 8.x release, something I don't have access to. I'm sure someone else will wander along and help out. If no-one does, then open a case with your official support provider and post...

bikan wrote:I want to know that what is output of command which is getting returned to routine A.

Execute it yourself from the command line. You'll have your answer.

This particular feature being discussed is at the Activity level in a Sequence job. For your other (unrelated) question, please start a new post here.