Search found 42189 matches

by chulett
Tue Nov 11, 2008 10:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage 8.0.1 installation problem in Windows
Replies: 9
Views: 5188

The documentation will list the supported compilers. "Supported" as in "work with the product".
by chulett
Tue Nov 11, 2008 10:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Exponent
Replies: 11
Views: 2802

Seems to be a known Excel "issue" when you do an automatic import by, say, double-clicking on a .csv file. Doesn't seem to be a good, automated solution other there, found this as one possibility: m Otherwise, it seems like you'd need to create a .txt file rather than a .csv to force the process thr...
by chulett
Tue Nov 11, 2008 6:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: retrieving a list of files in a remote ftp location
Replies: 12
Views: 2663

UserVariables Activity stage, call the routine there so the list ends up in a variable that can be leveraged by the Start Loop stage.
by chulett
Tue Nov 11, 2008 6:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to search a Sequential file for example x.csv in jobs
Replies: 10
Views: 2371

Make sure you are in a Project - either issue a LOGTO YourProject or launch the shell from inside the project directory so it is automatically logged into the right project.
by chulett
Tue Nov 11, 2008 6:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Exponent
Replies: 11
Views: 2802

:? What resolution are you after? Do you want the exponent or is this just a string with an 'E' in it? And the problem is strictly an Excel problem when you open the file in that tool?
by chulett
Tue Nov 11, 2008 6:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: filter unwanted records
Replies: 4
Views: 1017

We tried. :P

If you're just trying to detect the presence of a semi-colon in your data, then as noted the Index function should work for that. If there's more to it than that... [shrug]
by chulett
Tue Nov 11, 2008 2:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: filter unwanted records
Replies: 4
Views: 1017

Put your requirements into words so people don't have to guess what your filtering rules are.
by chulett
Tue Nov 11, 2008 1:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Internal Error: (k == numNodes)
Replies: 2
Views: 1521

Assertion errors are fatal code issues, I would think you'd need to take this to your official support provider, see if they can help.
by chulett
Tue Nov 11, 2008 10:43 am
Forum: General
Topic: How to protect a project/projects
Replies: 22
Views: 5904

OK, was wondering if all that it did was "kill" the process.

This should help with the different signals:

http://www.faqs.org/qa/qa-831.html

You won't be able to restart DataStage when you are done as it is already running. Simply restart dsrpcd with the nohup command you posted.
by chulett
Tue Nov 11, 2008 10:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job currently unscheduled ran at previously scheduled time ?
Replies: 5
Views: 1062

The Director only shows the crontab entries for the currently logged on user. So I'd wager it had been scheduled (and thus run) under a different user. Double-click on any log entry from the run, it will show the "User" there.
by chulett
Tue Nov 11, 2008 10:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: retrieving a list of files in a remote ftp location
Replies: 12
Views: 2663

So, a snippet from a script for a job where I needed to do almost the exact same thing: ftp -ni ${ftp_host} <<!! user ${user} ${pwd} cd ${destination} dir ${pattern} quit !! Wrapped in whatever level of error handling you feel you need. When the scri...
by chulett
Tue Nov 11, 2008 8:53 am
Forum: General
Topic: dsjob to print out status of all jobs
Replies: 6
Views: 2525

No, you'll need to get a list of all jobs and then iterate through them and parse the results. Curious what you mean by "print out the status"? Does "dsjob -jobinfo" have what you need?
by chulett
Tue Nov 11, 2008 8:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle_Enterprise_1 error
Replies: 4
Views: 1263

Re: Oracle_Enterprise_1 error

kajjam4u wrote:Add an index option or drop indexes and rerun step.

What's wrong with the solution it suggested?
by chulett
Tue Nov 11, 2008 8:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Display record counts on links in Designer from the last run
Replies: 15
Views: 2964

Sounds like it's time to open a case with your official support provider, see if that option is still valid in the 8.x release.