Search found 53125 matches

by ray.wurlod
Tue Jul 22, 2014 4:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: French character issue from serp stage output
Replies: 0
Views: 2360

And, in Canada, letters keep their accents when they are converted to upper case (which is not the case in France).
by ray.wurlod
Mon Jul 21, 2014 7:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to write fixed width to the sequential file stage in DS
Replies: 2
Views: 3141

The error is unrelated to fixed width, except that, when you finally get around to specifying how NULL is to be handled for this particular field, the value that you use (the Null Field Value property) needs to be of the same length as the field definition specifies. Other than that, every field nee...
by ray.wurlod
Mon Jul 21, 2014 2:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Japanese .xlsx data handling in DatStage 8.7
Replies: 10
Views: 5005

The apparent problem at source appears to have been resolved. You now need accurate knowledge about how the Japanese characters are encoded in the CSV file, and you must effect a binary transfer to guarantee that nothing in the file is changed during its transition to UNIX file system. This should a...
by ray.wurlod
Sat Jul 19, 2014 3:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Japanese .xlsx data handling in DatStage 8.7
Replies: 10
Views: 5005

What is the language setting on the Windows machine where you're saving the CSV file, for this seems to be at the heart of the problem. Can you (or have someone else) save the CSV file on a Japanese version of Windows?
by ray.wurlod
Fri Jul 18, 2014 6:47 pm
Forum: General
Topic: Adding Multiple script After job Sub Routine
Replies: 8
Views: 1727

Pretty sure natively. Certainly the redirection operators and unconditional pipeline operator (;) are native.
by ray.wurlod
Fri Jul 18, 2014 6:45 pm
Forum: General
Topic: dssh hang and client not able to connect
Replies: 4
Views: 1954

What service do you have configured to listen on port number 31539? Is this service actually running? Or, perhaps, is someone using an incorrect port number in the login credentials?
by ray.wurlod
Fri Jul 18, 2014 3:58 pm
Forum: General
Topic: Adding Multiple script After job Sub Routine
Replies: 8
Views: 1727

&& (and the other pipeline separators) work in DOS too.
by ray.wurlod
Thu Jul 17, 2014 9:17 pm
Forum: General
Topic: DataStage in the Cloud
Replies: 1
Views: 1869

DataStage in the Cloud

Has anyone any experience - especially production experience - with using DataStage in the cloud but where the data sources and targets are not in the cloud?

How were the data transferred to and from DataStage, and was the transfer mechanism a bottleneck?
by ray.wurlod
Thu Jul 17, 2014 9:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Stage - Flash Player
Replies: 9
Views: 6255

Soon I hope to be able to play with 9.1. My current client is still 8.7. :cry:
by ray.wurlod
Thu Jul 17, 2014 9:13 pm
Forum: General
Topic: Connect to MS SQL Server in Routine
Replies: 2
Views: 965

Search DSXchange for "BCI", then heed Craig's comment.
by ray.wurlod
Thu Jul 17, 2014 4:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Do not continue processing if no incoming rows
Replies: 3
Views: 1593

Build a sequence in which the first job counts the rows (for preference use a server job and place the count into its user status area). Downstream of that create a custom trigger that requires the count to be greater than zero to allow the actual processing job (which truncates the target) to proce...
by ray.wurlod
Thu Jul 17, 2014 4:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Timestamp with microseconds
Replies: 10
Views: 4880

Use the same metadata and format string for the target that you used for the source.
by ray.wurlod
Thu Jul 17, 2014 4:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Japanese .xlsx data handling in DatStage 8.7
Replies: 10
Views: 5005

How did you move the file to UNIX? If you used FTP, did you use BINARY mode?
by ray.wurlod
Thu Jul 17, 2014 4:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Stage - Flash Player
Replies: 9
Views: 6255

If I recall correctly, the Adobe flash player was only necessary for the animated lineage reports in Metadata Workbench (which can be invoked from Business Glossary), not for anything in DataStage.
by ray.wurlod
Thu Jul 17, 2014 4:13 pm
Forum: General
Topic: the host is not responding (81011)
Replies: 6
Views: 7195

Check that the hostname is correctly configured and that that host can be contacted by the client. If that is OK, check that all necessary firewall ports are open. If that is OK, check that the engine services are running.