Search found 53125 matches

by ray.wurlod
Thu Dec 27, 2018 3:19 pm
Forum: General
Topic: Datastage infosphere 11.5 compatibility windows server 2016
Replies: 6
Views: 1803

Re: Datastage infosphere 11.5 compatibility windows server 2

Welcome aboard.
GKETLDEV wrote:Is infosphere 11.5 compatible with windows server 2016 (In IBM installation guide Windows server 2016 is available in list for 11.7 not for 11.5 ) ?
You've answered your own question.
by ray.wurlod
Tue Dec 25, 2018 1:22 am
Forum: Site/Forum
Topic: Message from the Editor
Replies: 1
Views: 3750

Message from the Editor

Can the message from the editor on the home page please be updated? It's spruiking an event that was four months ago. There are other exciting things that could be mentioned, such as Think 2019, the UG&I event in Kansas City, and even the roadmap for DSXchange!
by ray.wurlod
Tue Dec 25, 2018 1:18 am
Forum:
Topic: Importing non infosphere metadata into the Metadata Workbenc
Replies: 6
Views: 4100

Depending on how "standard" the other sources are, Open IGC might be overkill. IMHO, of course.
by ray.wurlod
Fri Dec 21, 2018 12:15 pm
Forum: General
Topic: I do not see the ESDB, DSODB, or SRDUSER schemas in the XMET
Replies: 3
Views: 2000

Craig is correct. These are optionally installed. Scripts for creating them are supplied on the installation media.
by ray.wurlod
Wed Dec 19, 2018 5:49 pm
Forum:
Topic: Importing non infosphere metadata into the Metadata Workbenc
Replies: 6
Views: 4100

It rather depends on how your other metadata are described. The bridges that come with Information Server, and other bridges available from third party providers, can either provide your solution or, if not, allow metadata to be imported from source into Information Server's metadata repository. For...
by ray.wurlod
Wed Dec 19, 2018 12:54 am
Forum: General
Topic: Sequence job is not calling parallel jobs in DS1.5FixPack1
Replies: 3
Views: 1373

Is there a message in the sequence log stating something like the parallel job is being skipped? Or that a run of it has been requested? Is the Job activity preceded by anything else and, if so, what kind of trigger is it? Recompile the sequence and examine the generated code. This may give some clu...
by ray.wurlod
Tue Dec 18, 2018 12:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Junk character in sequential file viewer stage
Replies: 4
Views: 1792

Who knows? You've condemned what might be valid characters to be "junk". I'd examine that assumption pretty closely.
by ray.wurlod
Tue Dec 18, 2018 12:44 am
Forum: General
Topic: Need Plugin to connect InfoSphere Data Architect and TFS
Replies: 4
Views: 2160

Would it be acceptable to import the models into the IIS metadata repository from Data Architect then use a bridge to export from there to TFS?
by ray.wurlod
Mon Dec 17, 2018 1:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Junk character in sequential file viewer stage
Replies: 4
Views: 1792

What character set are you using? Could these be double-byte representations of Unicode characters?
by ray.wurlod
Sun Dec 09, 2018 6:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fixed width Cobol File
Replies: 8
Views: 2655

Your arithmetic will be out if there are any COMP fields.
by ray.wurlod
Sun Dec 09, 2018 6:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need help in the logic
Replies: 6
Views: 2165

I'd use an Aggregator stage if all that is required is the grouping columns and the minimum and maximum value per group.
by ray.wurlod
Sun Dec 09, 2018 6:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage DOUBLE convert to TEXT trailing zeros 2 dec
Replies: 4
Views: 1835

The Trim() function, in that form, is intended to drop leading non-significant zeroes.

You may need an explicit DecimalToString() conversion to preserve the non-significant trailing zeroes.
by ray.wurlod
Tue Dec 04, 2018 1:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading SAS code through datastage
Replies: 5
Views: 1957

You should be able to use the Java stage to read the SAS data through the SAS interface library calls.
by ray.wurlod
Tue Dec 04, 2018 1:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hierarchy stage <element/> tags
Replies: 4
Views: 1827

Don't try to force the stage (or any stage) to do what it's not designed to do. There are plenty of XML formatters out there; many of them are free. Use the right tool for the job.
by ray.wurlod
Tue Dec 04, 2018 1:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: COBOL file without copybook
Replies: 98
Views: 22649

That's certainly a possibility, though probably a waste of resources or bandwidth. One approach would be to convert all (or all but one of the) ODO clauses into OCCURS 20 TIMES with fillers (obviously if you need more than 20 adjust accordingly). DataStage can handle any number of OCCURS clauses, bu...