Search found 53125 matches

by ray.wurlod
Tue Jul 15, 2008 7:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: access hashed file through unix
Replies: 2
Views: 1012

In general no. A hashed file is a database table. Your question is analogous to "can we access (read field) from Oracle table?". You can invoke dssh to execute an appropriate query in that environment. There is an operating system level command for reading the entirety of a single record from a hash...
by ray.wurlod
Tue Jul 15, 2008 7:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SubStr Function
Replies: 5
Views: 2801

It's done with square bracket notation if you are using a Transformer stage. Syntax is string[start,length] so, in your case, InLink.TheString[4,6] There is also a substring function for the Modify stage if you are preferring to use that. Beware, though, that counting in the Modify stage is zero-bas...
by ray.wurlod
Tue Jul 15, 2008 7:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Rounding of Decimals places
Replies: 1
Views: 857

There is an environment variable that governs intermediate precision of decimal calculations. I'm not at a site where I can check, but its name is something like APT_DECIMAL_INTERM_PRECISION. This may help.
by ray.wurlod
Tue Jul 15, 2008 7:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SSL connection in MQ with datastage
Replies: 6
Views: 6415

If they do, they will respond next time they log in. Absence of a response may be taken to indicate that no-one who has thus far read this thread has anything concrete to contribute. Please be patient. If you can't be patient involve your support provider - whom you are paying to support you! DSXcha...
by ray.wurlod
Tue Jul 15, 2008 7:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Accessing Datastage Env variable value in Basic Rouitne
Replies: 6
Views: 2211

FUNCTION GetEnvironmentVariable(EnvVarName) If UnAssigned(EnvVarName) Or IsNull(EnvVarName) Then Ans = @NULL End Else Call DSExecute("UV", "ENV", Output, ExitStatus) FindStr EnvVarName In Output Setting FMC,VMC,SMC Then Ans = Field(Output<FMC,...
by ray.wurlod
Tue Jul 15, 2008 4:37 pm
Forum: IBM QualityStage
Topic: Handling Name with spl characters
Replies: 7
Views: 2146

Investigate stage processing the output file from the Standardize stage.
C-mask gets the field analyzed (investigated) and included in the report.
X-mask gets the field included in the report without being analyzed.
by ray.wurlod
Tue Jul 15, 2008 4:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Deleting Datasets
Replies: 10
Views: 2575

Use your Data Set Management utility in the Manager client. You can much more easily delete data sets from there.
by ray.wurlod
Tue Jul 15, 2008 4:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuration File Help
Replies: 5
Views: 1208

Copy/paste/edit the processing node that is already there. The configuration file must appear as follows. /* Optional comments can appear anywhere */ { node "nodename1" { node definition } node "nodename2" { node definition } /* and so on */ }
by ray.wurlod
Tue Jul 15, 2008 4:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Env variables in Parallel shared container
Replies: 3
Views: 1215

Pass them into container parameters from job parameters.
by ray.wurlod
Tue Jul 15, 2008 4:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date Extraction
Replies: 2
Views: 1435

Investigate the database-specific date conversions available in the SDK.
by ray.wurlod
Tue Jul 15, 2008 4:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: importing multiple DCLGENs
Replies: 1
Views: 689

I don't think it's possible (to import multiple table definitions from a single DCLGEN). :(
by ray.wurlod
Tue Jul 15, 2008 4:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dastage 7.5 orchestrate operator manual
Replies: 1
Views: 2004

You can get these ("OEM manuals") from your support provider.
by ray.wurlod
Tue Jul 15, 2008 4:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Link Collector and Hash Files
Replies: 1
Views: 821

Hashed files (not, it's not "hash files") are simply not available in parallel jobs, other than in a server shared container. The nearest equivalent is a Lookup File Set stage, but you can also use a Sequential File stage since there's only one row. The nearest equivalent to a link collector is a Fu...