Search found 53125 matches

by ray.wurlod
Tue May 27, 2008 11:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: I can not set up proper ROLE restrictions
Replies: 2
Views: 870

You get the union of all roles for all groups to which you belong. Check whether you also belong to a group to which the developer role has been assigned.
by ray.wurlod
Tue May 27, 2008 8:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Vertical Pivot
Replies: 17
Views: 3360

But I thought you wanted to accumulate a comma-delimited list in Col2.
by ray.wurlod
Tue May 27, 2008 8:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Vertical Pivot
Replies: 17
Views: 3360

But I thought you wanted to accumulate a comma-delimited list in Col2.
by ray.wurlod
Tue May 27, 2008 8:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Working with SQL Server
Replies: 4
Views: 975

I only remembered it because of all the "s" characters in the driver library name.
:oops:
by ray.wurlod
Tue May 27, 2008 3:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP Enterprise stage
Replies: 3
Views: 1007

Yes or no. The FTP stage can certainly move data, but it does not deposit the same on the DataStage server; if the FTP stage is performing a GET, the bytestream is fed directly into a DataStage job.

If you want to FTP files from one platform to another, use an ftp command, not an FTP stage.
by ray.wurlod
Tue May 27, 2008 3:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Working with SQL Server
Replies: 4
Views: 975

Nah. The DataDirect drivers that ship with DataStage include one for SQL Server.
by ray.wurlod
Tue May 27, 2008 3:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Vertical Pivot
Replies: 17
Views: 3360

The If test within the derivation of svCol2 refers to svCol2.
by ray.wurlod
Tue May 27, 2008 3:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Scheduling more than one instance of same Job does nothing
Replies: 6
Views: 1863

Can you take a look at your crontab entries on UNIX, to see whether it's a problem in how Director's schedule view is working?
by ray.wurlod
Tue May 27, 2008 3:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need Datastage job (.dsx) location
Replies: 3
Views: 2020

There is no place in UNIX that you can "see" your jobs in any sense. Design objects are stored within a database, not in files. But the job itself does not exist. A program that runs jobs uses data stored in database tables to determine what to do. The closest you will get to seeing anything is the ...
by ray.wurlod
Tue May 27, 2008 2:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job aborts everytime unless debugger is running
Replies: 7
Views: 2300

I suspect (with no evidence whatsoever) that the Debugger does not bother to use hashed file cache.

After all, there would be nothing to be gained. Cache is about speed. Debugger is about slow.
by ray.wurlod
Tue May 27, 2008 2:51 pm
Forum: General
Topic: Using of ROUND function
Replies: 4
Views: 2021

Not in a parallel job (unless in a BASIC Transformer stage).
by ray.wurlod
Tue May 27, 2008 2:50 pm
Forum: General
Topic: dynamic lookup property in datastage
Replies: 9
Views: 9717

Slowly Changing Dimension stage does all that.
by ray.wurlod
Tue May 27, 2008 7:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need Datastage job (.dsx) location
Replies: 3
Views: 2020

A ".dsx" file is never stored on the server. It is an EXPORT file, and is always stored on a client. It is not a "job file" - indeed there is no such thing as a "job file".

"UV repository" is something that ceased to exist in 2001. Don't worry about it.
by ray.wurlod
Tue May 27, 2008 6:51 am
Forum: General
Topic: Look Up file set
Replies: 3
Views: 1494

What's a "lookup file"?
by ray.wurlod
Tue May 27, 2008 6:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Change Capture stage
Replies: 20
Views: 4967

The environment variable name is APT_STRING_PADCHAR.