Search found 53125 matches

by ray.wurlod
Mon Oct 19, 2015 10:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Leading Question Mark Appears on First row of data
Replies: 6
Views: 3870

My guess is that it's a Byte Order Mark.
by ray.wurlod
Mon Oct 19, 2015 10:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: use user defined configuration file
Replies: 14
Views: 7973

Just as a test can you place your configuration file in the same Configurations folder as default.apt, then use the Configurations tool in DataStage Designer to verify it, letting us know the results?
by ray.wurlod
Mon Oct 19, 2015 4:15 pm
Forum: General
Topic: How to find out number of users in Datastage side ?
Replies: 3
Views: 1282

Use web console for Information Server, Session Management.
by ray.wurlod
Mon Oct 19, 2015 4:14 pm
Forum: General
Topic: Bundled DB2 for metadata repository.
Replies: 4
Views: 1307

By "Information Server" database tables are included not only the metadata repository and its staging area, but also the analysis database, the exceptions database, and the QualityStage match designer database, should you choose to implement any of these. (Or you can use other database pro...
by ray.wurlod
Mon Oct 19, 2015 4:11 pm
Forum: General
Topic: Installing engine tier on multiple machines, where to start?
Replies: 5
Views: 2306

In a QualityStage-only licence (if I recall correctly) you probably do not have the real time stage types enabled, nor the restructure stage types.
by ray.wurlod
Mon Oct 19, 2015 1:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: use user defined configuration file
Replies: 14
Views: 7973

To add an environment variable as a job parameter go to Job Properties, Parameters tab, and click the Add Environment Variable button. Choose $APT_CONFIG_FILE from those on offer. When the job run request is made, provide the full pathname of your configuration file as the value for the $APT_CONFIG_...
by ray.wurlod
Sun Oct 18, 2015 11:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: || Symbol - Append Dynamically
Replies: 11
Views: 3812

Had you told us that up front I would not have needed to surmise, nor to waste time on solutions based on those surmises. The solution you require is nothing more difficult that a series of If..Then..Else statements concatenated together. Each of the generated strings will be preceded by "|| &q...
by ray.wurlod
Sun Oct 18, 2015 8:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: || Symbol - Append Dynamically
Replies: 11
Views: 3812

If they come in as separate columns in the same row, use Column Import stage. If they come in in separate rows, use Pivot stage to bring them into the same row, then use Column Import stage. If they come in as a delimited string, change the delimiter to "||". Use the Ereplace function docu...
by ray.wurlod
Sun Oct 18, 2015 4:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: px.connect.fail##### files generated
Replies: 9
Views: 6843

Almost certainly not. Problems with kernel size will usually be picked up at installation time.
by ray.wurlod
Sun Oct 18, 2015 4:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP stage writes to /tmp, how to change this directory?
Replies: 3
Views: 2277

Check the value of the TEMP environment variable.
by ray.wurlod
Sun Oct 18, 2015 4:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: FTP Leading Zeros
Replies: 6
Views: 7272

Not if the data type is Decimal.

Well... you can, but DataStage will reinstate them.
by ray.wurlod
Sun Oct 18, 2015 4:01 pm
Forum: General
Topic: unable to logon/open DS job to datastage 9.1clients
Replies: 10
Views: 7372

Check too that the passwords for XMETA, XMETASR and other "system" accounts, as well as those for Engine credential mappings, have not expired.
by ray.wurlod
Sun Oct 18, 2015 3:59 pm
Forum: General
Topic: Installing engine tier on multiple machines, where to start?
Replies: 5
Views: 2306

One you've installed Machine1 and Machine2 (in that order) you can install Machine3 and Machine4 in either order or, indeed, simultaneously. When you connect clients this is initially to the services tier. From there you are presented with a list of engine-based projects, qualified with machine name...
by ray.wurlod
Sun Oct 18, 2015 3:35 pm
Forum: General
Topic: Execute Command Actvivty
Replies: 8
Views: 3106

Your script IS being executed; it is reporting its exit status. The problem for the Execute Command activity is that your script may not be returning a zero exit status. Possibly it's returning the exit status of the test command. Force the script to have a zero exit status and all should be well. ....
by ray.wurlod
Sun Oct 18, 2015 3:25 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Foriegn key analysis-Referential Integrity Detail Report
Replies: 3
Views: 4193

It may be, of course, that there are no referential integrity violations in the second case. You did not provide us with that knowledge.

It is also possible that you have discovered a bug. In that case involve your official support provider; we are not able to fix bugs.