DSXchange

First you need to dump it as that's not automatic and without that there's nothing to examine. Did you trying searching as suggested? For example:

viewtopic.php?t=123551

You could pull some keywords from there and continue to drill into the information that is here.

Either of the "Developer's Guide" pdfs have a section on the Command Line Interface which fully explains the dsjob command line executable that runs DataStage jobs, including its syntax. There you'll find that parameters are passed as "name value" pairs with the -param tag. So......

Commands for environment variables? You mean the commands to create and display their values? That would be "set" and "echo", respectively. And there's no need to "pass" them as they are part of the environment and thus available to any process running in that environme...

Post that question in the Enterprise Edition forum and mark the job type as 'Parallel'. Better yet, try searching that forum as you aren't the first person to ask questions about how to dump and read a score, so what you seek is out there already.

Again, you need to be more specific in your questions. Examples help as well. While parameters can be overridden from the command line, and you can "automate" this with a script, you really need to explain what you mean by automate - what it is that you are attempting to accomplish so peop...

Sorry but you'll need to explain what "automate the process of Envirnomental variables" means, command line or otherwise, before anyone can really help.

Server jobs don't have a "score".

Of course, the timesaving aspect would come from how many times you needed to do this, assuming many times then yes. Once or twice... not so much.

shamshad wrote:I assume what Tej needs has been already answered by MK.

I would make no such assumption, especially considering the questions asked so far and the shear amount of guessing going on in what is being posted.

OK. If you want to pursue your original methodology, here's how I would attempt it. First take some saved metadata of the type you need to create and save it through the Manager into a .dsx file. Make sure you have a representative sample of the various types you need. Open and study the .dsx file a...

And just to confirm, this is what kind of metadata... meaning, metadata for what? I was assuming for a sequential file but did you mean table metadata delivered in a sequential file? Or something else?

So... you don't have an Excel spreadsheet of csv data but rather one with the appropriate metadata? Something like one row per field? If that's the case, you won't be able to import it as the importer is expecting to determine the data types / lengths / etc from the actual data that it sees in the f...

Tell us what the actual hex values of these "square boxes" are.

Hmmm... isn't a "primary" index by definition unique?

Pretty much what I meant... thinking perhaps this is more of a "logical" data validation outside of what the schema would catch.

igorlp - can you post an specific example or two of your issue? XML, xsd, errors/warnings, whatever you can.