Search found 53125 matches

by ray.wurlod
Fri Nov 02, 2007 7:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: server routine for eliminating headers
Replies: 7
Views: 1864

How about just encapsulating this command as the filter command in your Sequential File stage?

Code: Select all

grep -v Country_Code #SourceFile#
by ray.wurlod
Fri Nov 02, 2007 4:46 am
Forum: General
Topic: DataStage Director Log for each job need in specified path
Replies: 6
Views: 4555

Director has a Print to File option.
You can create a "dump log to file" routine.
You can use dsjob to dump the log contents and redirect its output into a file of your choice.
There's three possibilities.
by ray.wurlod
Fri Nov 02, 2007 4:35 am
Forum: General
Topic: DataStage Director Log for each job need in specified path
Replies: 6
Views: 4555

The DataStage job log is a database table in the Repository - it is not a file. The best you can do is to dump the log into a file - you can not "maintain" the log in any sense.
by ray.wurlod
Fri Nov 02, 2007 4:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sum of column decimal(26,3)
Replies: 1
Views: 1585

The Double has 31 significant digits.
Decimal has 26.
The message tells you that you can't shoehorn the one into the other.
Can you investigate reducing the size of the Double?
by ray.wurlod
Fri Nov 02, 2007 4:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Decimal to Integer
Replies: 4
Views: 2501

Of course you can. You will also need a specification, and therefore some logic, to define what happens with any out-of-range values.
by ray.wurlod
Fri Nov 02, 2007 4:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: The Section Leader on node node1 has terminated unexpectedly
Replies: 6
Views: 7926

Use the Configurations editor to test your configurations file. If that tests out OK, we've eliminated one possible cause of the compilation problem.
by ray.wurlod
Fri Nov 02, 2007 4:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Creating Header / Detail file in CFF stage
Replies: 1
Views: 879

Not in version 7.
Create them separately and combine them afterwards.
by ray.wurlod
Fri Nov 02, 2007 4:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Aborting Fatal Error
Replies: 1
Views: 1216

The first is an alert, about which you can search for information on the forum. The second is a message apparently from a Transformer stage. You will need to provide a lot more information about what this stage is doing - and some job context information as well - in order for us to have any chance ...
by ray.wurlod
Fri Nov 02, 2007 3:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Schedule Error [b]Status code = -3 DSJE_BADPARAM[/b]
Replies: 9
Views: 2679

DSJE.BADPARAM means that you have tried to use a parameter name that is not defined in the job. Step back and simplify. Don't try to use environment variables' values as default values. That doesn't work. Use environment variables as job parameters. Click the Add Environment Variable... button in th...
by ray.wurlod
Fri Nov 02, 2007 3:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob
Replies: 37
Views: 10817

The dsjob executable is in .../DSEngine/bin, not in .../DSEngine.
by ray.wurlod
Fri Nov 02, 2007 3:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing parameters to a sequence via text file
Replies: 5
Views: 1594

Why not just have the job sequence read the file into User Variables and use those downstream? There are a couple of techniques. One is to read the entire file as a string, parsing out the param=value pairs. This is easily done in a Routine activity. Field() functions can then be used as the derivat...
by ray.wurlod
Fri Nov 02, 2007 3:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reg:Datastage error
Replies: 8
Views: 3701

Do you REALLY have an "=" character in a pathname? What is the value of APT_CONFIG_FILE environment variable?
by ray.wurlod
Fri Nov 02, 2007 3:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: BOSource
Replies: 6
Views: 1443

Why not let Windows Explorer search for it?
by ray.wurlod
Fri Nov 02, 2007 3:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem with fixed width file
Replies: 4
Views: 2622

Where do you get your metadata? Ask the mainframe folks for the COBOL file definition, and import the table definition from that. At the very least it ought to match the data you are receiving. Then you might contemplate using either a Sequential File stage with fixed-width format, or perhaps a Comp...
by ray.wurlod
Fri Nov 02, 2007 3:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Implement how to split MultiList values of a column
Replies: 15
Views: 3850

Nah. Just parse each row into columns then use a Pivot stage. Too easy: it's an exact fit. Where are the data sourced?