DSXchange

Hi, I found our current datastage installation there is a enterprise pivot (pxpivot) stage for parallel job. But the documentation I have is only for horizontal pivot for the pxpivot stage. But I do see there is an option for vertical pivot in the pxpivot stage. Can someone show me how to usage vert...

ray.wurlod wrote:You have marked this thread as Resolved. Please advise HOW it was resolved, to aid future searchers. ...

I already mentioned it in my previous post.
Here it is again.

select unicode from the Extended column of the column tab.

I am migrating jobs from windows environment to AIX 6.1 environment.
There are many jobs with the same issue.

I know I can manually edit each odbc stage and select "unicode" from extended column. Man, that's a lot of work.

Any hint how to accomplish it in a clever way?
Thanks a lot!

In Columns tab of ODBC stage, select unicode from the Extended column,
the issue is magically solved

I mean the chinese character can be read from the odbc data source and written into the sequential file, but in the sequential file these chinese character become "?" instead of the one in the data source. This is very likely to be an encoding issue, from my past experience. I was wonderin...

We tried both ODBC Enterprice stage and ODBC connector stage to read data from MS SQL Server database into a sequential file. For chinese characters, they can not be read correctly. We saw ? instead of original chinese characters in the seqential file. But for ascii chacaters we have no problem. I s...

Thanks a lot. I also encountered similar problem is aggregator stage. After following your suggestion, it is solved now.

Reset can only be had from a controlling sequence. If you build a controlling sequence that does not abort, then it could run your master sequence as "reset if required, then run". That could well b ... Ray, thanks for the reply. Is it possible to configure a controlling sequence that wil...

Hi, Your reset button is present in the Director (to the right of the stop button) on the toolbar. If you are not interested in the previous run's logs you can achieve the same status by compiling the sequence. Regards, Novak Can we automatically reset the master sequence? I know you can click the ...

We came across an issue running a scheduled sequence job. The sequence is scheduled to run on a daily basis. One day the master (top level) sequence failed due to some reason, then all the following days the master sequence can not start as scheduled. And in the log we saw something like this. Job X...

Yes, expected. Declare your output field as Char and then use DecimalToString() to get whatever output format you desire. ... Ok. Many thanks chulett. I used your approach to define the output as char with appropriate length. The workaround I use to add the trailing sign is to check if the decimal ...

Change it to a string within your DataStage job. ... Still confused :cry: Since I wanted to write decimal to sequential files, if I know how to convert the source decimal to string, I am very happy now. After hours of fiddling with this issue, below is what I have observed for sequential file stage...

chulett wrote:Define the field as a string, then you have full control over its format. ...

But my source field is decimal, can you elaborate a little bit on how to
do this?

Yes. In server job, I can use Iconv to get the desired results. Another question. For parallel job, I noticed by default, the sign is in the leading place. For example, number 1.0, using specification 6.11, I got _000001.00000000000 in the output ( notice the leading space ). What I actually want is...

Hi, folks: In one of my job, I need to generate fixed length files, and I had some issue with decimal numbers. The requirement is as follows. 1. for decimal number specification like 6.11, I need to generate a number that has 6 numbers before the decimal point, and 11 numbers after the decimal point...