Search found 53125 matches

by ray.wurlod
Mon May 12, 2008 6:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Get the Login name from the PX job
Replies: 3
Views: 1037

You can not. GetEnvironment() is a function whose specific purpose is to retrieve the value of a particular environment variable.

Depending on where you are executing from, you may be able to execute the set command with no command arguments.
by ray.wurlod
Mon May 12, 2008 6:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Internal Error: failed to convert date
Replies: 18
Views: 4616

The rule is that the date format must match exactly the format on the advice of the authorization code.

Check that your expiry date is, in fact, 01/01/2500 on the documentation.
by ray.wurlod
Mon May 12, 2008 6:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Director error
Replies: 2
Views: 1151

Moderator: please move to parallel forum

Orchestrate "step" means the same thing as DataStage "job". You will need to implement some diagnostics to determine which process is generating the SIGINT signal.
by ray.wurlod
Mon May 12, 2008 6:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Padding blank spaces behing the passed string in Oracle
Replies: 6
Views: 1364

Moderator: please move to parallel forum
by ray.wurlod
Mon May 12, 2008 6:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: variable to get DataStage Home directory path
Replies: 8
Views: 6899

However, you appear not to have noticed that the cat command was surrounded by back-quotes, not single-quote characters.

(System(32) remains the easiest approach.)
by ray.wurlod
Mon May 12, 2008 6:21 am
Forum: General
Topic: difference between routine and a function in datastage
Replies: 3
Views: 2091

You have marked the job type as TX. Is that correct?
by ray.wurlod
Sun May 11, 2008 9:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Get the Login name from the PX job
Replies: 3
Views: 1037

You should be able to use

Code: Select all

GetEnvironment("USER") 
to retrieve the value of the USER environment variable.
by ray.wurlod
Sun May 11, 2008 6:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Windows Vista hiding the expression editor
Replies: 11
Views: 3193

Funny how it doesn't stop Microsoft apps from moving into focus, usually at the most inconvenient time!
by ray.wurlod
Sun May 11, 2008 5:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS Administrator
Replies: 14
Views: 3986

The Admin console is one tab (Reporting is another). These are all part of the IBM Information Server (IIS) console, which you open in a browser specifying port number 9080. I think you will find that the Web admin console opens the WebSphere Application Server (WAS) console, which connects to the W...
by ray.wurlod
Sun May 11, 2008 5:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding Rejected Data
Replies: 6
Views: 1357

That is because 00000000 is not a valid date. Specify as Char(8) and perform IsValid() and conversions within your job, or specify 00000000 as the null field value.
by ray.wurlod
Sun May 11, 2008 5:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Windows Vista hiding the expression editor
Replies: 11
Views: 3193

Sure is. Please mark the thread as Resolved.
by ray.wurlod
Sun May 11, 2008 5:31 pm
Forum: General
Topic: Article: Run-time Architecture of DataStage Server Jobs
Replies: 17
Views: 21035

This will be my final post on this thread. As Ernie notes, you have burned a lot of time on this - you have also consumed a lot of our time, and then misunderstood or misinterpreted the information we have provided. I will answer your specific points and conclude with something more general. I do no...
by ray.wurlod
Sun May 11, 2008 5:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS Administrator
Replies: 14
Views: 3986

No. DataStage Administrator administers DataStage projects only.

Information Server admin console administers all products running in the domain (under IIS) - DataStage is just one of these.
by ray.wurlod
Sun May 11, 2008 4:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding Rejected Data
Replies: 6
Views: 1357

Your metadata (table definition) should specify a field width for each field. This is mandatory when there are no delimiters. It is via the field widths that the record is parsed into its constituent fields.
by ray.wurlod
Sun May 11, 2008 4:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Executable file of a DS Job
Replies: 26
Views: 17921

This Job executable file is located at the Project Directory at version DS 7.5 RT_CONFIGnnn - A Run Engine Executable file, nnnn --> Job Number That is completely incorrect. RT_CONFIGnnn contains only data about the job configuration - data that are used by DSD.RUN and DSD.StageRun. There is no job...