DSXchange

It's helpful to include the error message you received. Without it, the forum members are left to guess or assume. One thing to point out: Your example string data has a decimal point between the seconds and microseconds ("45.798181"), but your format string has a semicolon between the sec...

You may be able to get it to work by using the ssh command in the ExecCommand activity: ssh hostname scriptname Pull the hostname from the values returned by sequencer.sh. If you're feeling adventurous, pull a hostname from one of the node entries in the config file returned by sequencer.sh :) Regar...

But that time the job is getting aborted

And you have yet to provide us with what that error is. Also, it would be of help to know the value present in the variable and how you reference that variable in your job.

Regards,

The ELFCLASS32 error is referring to the object RCOM.o. I expect that your transformer is calling a custom parallel routine which is compiled as a 32-bit object. You will need to recompile that routine as a 64-bit object.

See this thread for a similar problem.

Regards,

Is there a particular reason/need to run the script on a compute node rather than the head node? Sequence jobs, because they are at heart server jobs, can run only on the head node (the Engine server or tier). The ExecCommand activity, as well as BeforeJob and AfterJob ExecSH functions (I believe so...

As the parameter is already part of a parameter set, there is no need to also add it to the job parameters: you have discovered what will happen when you do so. What errors did you receive originally? Those are the errors you need to resolve. Perhaps it's how you reference the parameter or the data ...

Perhaps YearWeekFromDate's results are based upon a week starting on the weekday of the first day of the year being examined? So, if the year started on a Wednesday, then you would see the week number advance on every Wednesday of that year. Simply a hypothesis: I don't have access to a DS server at...

Assuming that your data is comprised of whole numbers, you can change it to an Integer datatype before the output file (expanding on Priyad's suggestion). Alternatively, you have the option of specifying a format string (C_format or Out_format options) in the column's metadata in the output sequenti...

A quick search in the forum for the failure code turns up a couple of threads that may be related. Also, a Google search for the failure code turns up at least one IBM technote concerning the failure code. If neither result is applicable to your situation, you may wish to contact your official suppo...

Does "properly configured" mean that the system meets the minimum documented requirements for the installed tiers and nothing more? If so, you may have hit a situation where the actual usage of the system demands more than the minimum requirements for running the software. Look into the va...

Although the documentation for the DSGetVarInfo doesn't specifically state so, I am going to hazard a guess that this will work properly only for a Server job. By the time the AfterJob routine is executed, the parallel job has shut down and the operator tasks no longer exist in memory. To the best o...

Poor choice of words on my part...sorry.

Regards,

If the values are whole numbers (as in your provided examples), simply convert them to integer data types before writing them to the flat file.

Regards,

The answer to question 2 is no. You would not even be able to register an older version of the DataStage engine to a later version of the Services tier. Also, 9.1 and 8.5 do not support the same versions of WAS. The answer to question 1 is maybe. You could possibly do it with two completely separate...

In the grand scheme of All Things DataStage, wasn't this a relatively recent change? v8.0, I believe, so 5-6 years. I used the padding method plenty of times in 7.0/7.5 development and fondly bid it farewell when not necessary. Substring's good if all the OP needs to do is reformat the date string,...