Search found 53125 matches

by ray.wurlod
Tue Apr 03, 2007 10:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Modify Stage Column Name Change
Replies: 9
Views: 18485

Modify stage certainly can change a column name. For example:

Code: Select all

Specification:  newcolumn=oldcolumn

As you note, the problem is reading from Oracle. Are you using direct read or SQL as the extraction method?
There may also be a problem in the Modify stage, but solve the Oracle issue first.
by ray.wurlod
Tue Apr 03, 2007 10:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Shared Container runtime error
Replies: 1
Views: 884

Welcome aboard. :D
It appears that your parameter is not being resolved correctly. Please verify that it is correctly spelled and cased, and an appropriate value is being passed from the job that is using the shared container.
by ray.wurlod
Tue Apr 03, 2007 10:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Operate in MetaStage proxy mode
Replies: 1
Views: 775

DataStage can still operate in MetaStage proxy mode. It's just that the data will build up on disk as the process metabroker doesn't kick in to move them. You would have to uninstall MetaStage completely to get rid of the check box.
by ray.wurlod
Tue Apr 03, 2007 10:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Stage
Replies: 2
Views: 917

Is the first run still going when you start the tenth?
by ray.wurlod
Tue Apr 03, 2007 10:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Windows vs Unix for DS Server
Replies: 5
Views: 1106

An operating system that you need to reboot once every couple of years rather than once every couple of hours?

One that can handle files larger than 2GB (ok, 3GB with some fiddling) - like into the TB range?
by ray.wurlod
Tue Apr 03, 2007 10:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using Hash File in job sequence with multiple instances
Replies: 5
Views: 1301

You might use a hash file in Amsterdam. In DataStage you use a Hashed File stage, which works with a hashed file.
by ray.wurlod
Tue Apr 03, 2007 10:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XFM problem due to fixed width file delimited
Replies: 7
Views: 1983

Right click on a row in the Columns grid and choose Edit Row from the menu. You can also double click on the row number in the Columns grid. In the Sequential File stage there is a horizontal scroll bar at the bottom that will get you to where Craig suggested you go.
by ray.wurlod
Tue Apr 03, 2007 10:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Migration from datastage version 5.2 to 7.5.2
Replies: 1
Views: 925

Welcome aboard. :D Etiquette Note We don't do "urgent" or "asap" here. DSXchange is an all-volunteer site, no-one gets paid for posting. If you need urgent support, sign up with your support provider for premium service. Also, it's late night in the USA, so few of the posters from there will be chec...
by ray.wurlod
Tue Apr 03, 2007 10:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Component DSSE_ServerEngine problem
Replies: 9
Views: 3240

What it means is that you're on your own. It may work, but the total amount of support you'll get from IBM is a round number.
by ray.wurlod
Tue Apr 03, 2007 10:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job delete
Replies: 6
Views: 1479

Running a computer without making backups is like bungy jumping without a rope.

Learn from the experience.

Export your projects daily.

Is the server backed up? It may yet be possible to recover your work.
by ray.wurlod
Tue Apr 03, 2007 10:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to list the Job names under the category?
Replies: 17
Views: 3972

The wrapping occurs because the names you chose are longer than the default column display width. Override with the FMT keyword.

Code: Select all

SELECT NAME FMT '48L' FROM DS_JOBS WHERE CATEGORY LIKE '<<Category Name>>%' AND NAME NOT LIKE '\\%';
by ray.wurlod
Tue Apr 03, 2007 10:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: transaction grouping
Replies: 12
Views: 3725

Welcome aboard. :D

Please describe exactly where you find the term "on skip".
by ray.wurlod
Tue Apr 03, 2007 10:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Failed to open RT_CONFIGXXXXX, RT_LOGXXXXetc.............
Replies: 7
Views: 2566

That advice is valueless if the file system is full. They won't be able to create the new hashed files in the Repository. It would be like trying to pour the fifth gallon into a two gallon container.
by ray.wurlod
Tue Apr 03, 2007 10:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running Jobs in two seperate Projects
Replies: 6
Views: 1142

They ARE in your control. You are there as the (senior?) DataStage developer. Push back when the requirements are silly and solvable by sensible means.
by ray.wurlod
Tue Apr 03, 2007 10:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem while passing parameter from one job to another
Replies: 5
Views: 1692

Use DSJ.PARAMVALUE instead of DSJ.PARAMTYPE.STRING