Search found 43 matches
- Wed Jun 06, 2012 12:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: usage of pxpivot stage for vertical pivot
- Replies: 5
- Views: 3188
usage of pxpivot stage for vertical pivot
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...
- Mon Dec 27, 2010 10:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC encoding issue with chinese character under AIX 6.1
- Replies: 8
- Views: 7392
- Mon Dec 27, 2010 12:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC encoding issue with chinese character under AIX 6.1
- Replies: 8
- Views: 7392
- Mon Dec 27, 2010 12:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC encoding issue with chinese character under AIX 6.1
- Replies: 8
- Views: 7392
- Sun Dec 26, 2010 9:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC encoding issue with chinese character under AIX 6.1
- Replies: 8
- Views: 7392
- Wed Dec 22, 2010 3:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC encoding issue with chinese character under AIX 6.1
- Replies: 8
- Views: 7392
ODBC encoding issue with chinese character under AIX 6.1
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...
- Tue Jan 19, 2010 8:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage freezing when opening Sequential File Stage
- Replies: 11
- Views: 5716
- Mon Jan 18, 2010 10:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: master sequence can not restart automatically
- Replies: 7
- Views: 4319
- Mon Jan 18, 2010 10:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: master sequence can not restart automatically
- Replies: 7
- Views: 4319
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 ...
- Mon Jan 18, 2010 9:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: master sequence can not restart automatically
- Replies: 7
- Views: 4319
master sequence can not restart automatically
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...
- Wed Jan 06, 2010 10:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: decimal number format issue in fixed length file
- Replies: 9
- Views: 5877
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 ...
- Wed Jan 06, 2010 2:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: decimal number format issue in fixed length file
- Replies: 9
- Views: 5877
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...
- Tue Jan 05, 2010 2:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: decimal number format issue in fixed length file
- Replies: 9
- Views: 5877
- Mon Jan 04, 2010 8:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: decimal number format issue in fixed length file
- Replies: 9
- Views: 5877
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...
- Mon Jan 04, 2010 7:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: decimal number format issue in fixed length file
- Replies: 9
- Views: 5877
decimal number format issue in fixed length file
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...