Search found 53125 matches

by ray.wurlod
Fri Nov 02, 2007 8:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to move jobs from one project to another?
Replies: 32
Views: 10833

Etiquette Note
We don't do "urgent" here. If you need urgent support sign up with your support provider for premium service and learn the true cost of urgent. People who post here are all volunteers who post as and when they can.
by ray.wurlod
Fri Nov 02, 2007 8:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to move jobs from one project to another?
Replies: 32
Views: 10833

As Craig notes, what you have attempted to do is inappropriate. The only safe ways to move objects from one project to another is export/import, Version Control or uvbackup/uvrestore. You can probably repair the old project. It depends what went wrong, and why. Copying files into a new project at th...
by ray.wurlod
Fri Nov 02, 2007 8:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC Connection Error
Replies: 3
Views: 1464

Note the square brackets in the error message. These tell you how far along the chain of processing things got before the error occurred. In your case the final token was that of the ODBC driver manager, which suggests that the ODBC driver itself could not be loaded. The driver test utility typicall...
by ray.wurlod
Fri Nov 02, 2007 8:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Japanese Data in SQL Server 2000
Replies: 18
Views: 4221

Your note in the original post mentioned that NLS is disabled. I'm surprised you can do anything at all with Japanese characters.
by ray.wurlod
Fri Nov 02, 2007 8:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using OConv with MP tag
Replies: 5
Views: 1573

Take a look at the SDK routines for converting COMP data types, then try to reverse their logic. It will be slightly different depending on whether you are processing signed values and on the number of decimal places.
by ray.wurlod
Fri Nov 02, 2007 8:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Row Count
Replies: 6
Views: 1762

The @INROWNUM system variable will give the row count thus far processed, but won't contain the total row count until the final row has been through the job. You *could* take a link out of the Transformer stage containing just one column, run it through an Aggregator stage that performs a Count (wit...
by ray.wurlod
Fri Nov 02, 2007 8:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Question about month
Replies: 5
Views: 1313

Time to mark the thread as Resolved, then?
by ray.wurlod
Fri Nov 02, 2007 8:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to enable menu bar after it has been closed in designer
Replies: 10
Views: 6501

As Craig notes there are shortcut keys to all menu items, and shortcut keys only to some items of functionality.

If you don't have access to regedt32 I suggest you find someone who does.
by ray.wurlod
Fri Nov 02, 2007 10:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem with fixed width file
Replies: 4
Views: 2622

Review the manual's section on importing table definition for fixed-width files. The total number of characters in the metadata must exactly match the total number of characters in the data record.
by ray.wurlod
Fri Nov 02, 2007 10:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reg:Configuration file
Replies: 22
Views: 19522

DataStage 7.5x2 will simply not run on Vista - I suspect it can't even be installed.

Is your F: drive local or remote? DataStage configuration file must be on a local file system on the machine on which DataStage server is installed.
by ray.wurlod
Fri Nov 02, 2007 10:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Bitmap Indexes
Replies: 8
Views: 4333

It's not DataStage. DataStage just throws rows at the database server. Any restrictions exist there. For example, it is perfectly possible to bulk load the Red Brick database even when there is a mix of B-tree, target and bitmap indexes on a table. But, then, Red Brick was designed from the ground u...
by ray.wurlod
Fri Nov 02, 2007 10:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reg:Datastage error
Replies: 8
Views: 3701

We still need you to post the contents of default.apt so we can try to see why this might be happening.

Some progress has been made - you now know that the configuration file is faulty. Not corrupted, but not working either.

Is F: drive local or remote?
by ray.wurlod
Fri Nov 02, 2007 10:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSjob -jobinfo
Replies: 4
Views: 2706

Make sure that you include a -jobstatus (preferred) or -wait option along with the -run option so that control does not return to the script immediately. Either of these options changes the dsjob command to synchronous execution by not returning (from the dsjob command) until the job changes state f...
by ray.wurlod
Fri Nov 02, 2007 7:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reg:Datastage error
Replies: 8
Views: 3701

Please post the contents of default.apt

Also advise whether you have set a different configuration file for that particular job.
by ray.wurlod
Fri Nov 02, 2007 7:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: load data from odbc stage to get XML ouput
Replies: 2
Views: 1247

I second Craig's observation.

Your location suggests that you are working for one of the world's largest suppliers of consultants. Get them to enrol you in a training class.