DSXchange

How are your scripting skills? Or in case you truly have a Windows server and have some DOS knowledge, how are your batch file writing skills? You would need some in order to automate something like this from the command line using dsjob. You could also code something up in DataStage BASIC and use t...

I think Ray may be thinking of StringToDate rather than StringToDecimal, the former needs a format string to know where all of the date/time components are, the latter doesn't need one. It does, however, support an optional rtype argument if there is any type of rounding that needs to occur. You're ...

Have you involved your official support provider for the XML issue? As to the membership, it can take two or three days to activate, when did you purchase it? If it has been longer than that, the posts in the Site forum note you should be contacting "editor@dsxchange.net" nowadays. Give th...

Funny... I mention that and nothing. Ray echoes it and then it gets tried. [sigh]

Here's one discussion on the Windows version of that. There are plenty of others.

Obviously something is different between the two environments. Unless you have doubts as to your promotion process then the primary difference is the database you are connecting to which I why I suggested starting there. I can't tell you how many times over the years that while working my way up the...

Database. Check the permissions associated with the connection user in that environment, also the structure of the target. Compare them to the environment where things worked.

That's where I'd start.

Even though the first line executed immediately, but the next line was triggered only after the shell receives the return value of the previous command execution status. Of course, that's How Things Work, DataStage or otherwise. If you don't want it to wait for anything, send the command off into t...

Not to sound facitious but you could ask someone who does. Another option is for the Master Sequence to send out an email when it aborts, that can automatically list which jobs completed and which failed. Make sure you are one of the people it is sent to. Out of curiousity, what kind of access do yo...

Yes... mostly. You are right about the stage but the dsjob command will only wait when you specify one of the two 'wait' options. By default it doesn't wait.

Now the Sequencer is aborting after the JA1 (job1) execution itself without triggering job2 and job3. So the information you'll need should be in the Sequence's log and should also mean it is either a problem with the User Variables stage or the inability to find/start JA2. If you're not sure what ...

It's generated SQL, so it will only put fields into the WHERE clause when they are marked as Key fields. I'm assuming that is what was meant by 'selected in the target ODBC connector stage' but please verify.

Still curious why the table name is parameterized.

Curious why your table name is parameterized... will all tables being updated by this job have identical metadata?

I'd also be curious if you (as a test) replace the parameter with an actual table name, if the error goes away.

OK... any idea what changed?

Sure... still just wondering where that 'bytes per record' value came from.