Search found 53125 matches

by ray.wurlod
Fri Feb 03, 2012 8:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage sequential file
Replies: 8
Views: 3714

As a test, can you try reading from the file with the metadata describing only one field, say VarChar(2000) data type?
by ray.wurlod
Fri Feb 03, 2012 8:35 pm
Forum:
Topic: Importing into metadata repository using istool
Replies: 18
Views: 6322

How did you create the archive file that you mentioned in your import command?
by ray.wurlod
Fri Feb 03, 2012 4:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage sequential file
Replies: 8
Views: 3714

Server jobs don't have reject links on Sequential File stage.

Are there any warnings in the job log?
by ray.wurlod
Fri Feb 03, 2012 4:25 am
Forum:
Topic: Importing into metadata repository using istool
Replies: 18
Views: 6322

The message suggests that there are no common metadata (-cm) elements in your archive.
by ray.wurlod
Fri Feb 03, 2012 12:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dataset column order
Replies: 5
Views: 3361

If it's that important, create the 100 jobs. You should be able to knock them all over in a single day if the table definitions have been imported already.
by ray.wurlod
Fri Feb 03, 2012 12:10 am
Forum: General
Topic: Error calling subroutine DSR_EXECJOB action=4
Replies: 11
Views: 3321

We're talking operating system (file system) permissions here, not Information Server roles. Does the user under which your agent process runs have correct permission to the relevant file system objects? Do all DataStage users have umask set correctly? To which group does the user referred to earlie...
by ray.wurlod
Thu Feb 02, 2012 9:02 pm
Forum: General
Topic: Command line create project issue
Replies: 2
Views: 1283

From the syntax diagram, -domain, -user, -password and -server arguments are mandatory.
by ray.wurlod
Thu Feb 02, 2012 3:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Extract (decoded) images from the XML
Replies: 1
Views: 748

You can certainly read any payload using the MQ Connector stage. However that's all that that stage does. Downstream of that you will need something like an XML stage to parse the XML. What were you planning to do with the image data?
by ray.wurlod
Thu Feb 02, 2012 3:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dataset column order
Replies: 5
Views: 3361

Data Sets share with database tables the property that the order in which columns are stored is not under control of the user. It's not relevant to the user. You can use a Copy stage or a Transformer stage or a Modify stage to change the order of columns. Copy stage requires the fewest resources of ...
by ray.wurlod
Thu Feb 02, 2012 3:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sort option
Replies: 6
Views: 3046

If there's only one key column, then cluster key and sort key tend to be the same. In your example, Col1=50 forms a cluster even if Col2 is not a sort key.
by ray.wurlod
Thu Feb 02, 2012 3:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job control process (pid 26562) has failed
Replies: 3
Views: 2549

This error usually occurs if the controlling process (sequence, process running dsjob, job executing DSRunJob, etc.) is killed or if connection between the node and the conductor is lost for any reason. This is why a re-run is usually successful - the interruption does not occur the second time. The...
by ray.wurlod
Thu Feb 02, 2012 3:00 pm
Forum: General
Topic: CITRIX based Datastage clients accessing Datastage
Replies: 10
Views: 4138

Two I've worked at recently.
In one I was working in Tokyo and the clients were in Switzerland.
In the other I was working in Brisbane (Australia) and the clients were in Perth (Australia).
I am aware of others.
by ray.wurlod
Thu Feb 02, 2012 2:55 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Lookup based analysis
Replies: 13
Views: 6070

Create a virtual table based on the join, and then analyze the virtual table.
by ray.wurlod
Thu Feb 02, 2012 12:08 am
Forum: Enhancement Wish List
Topic: Local Date Formats
Replies: 1
Views: 7828

Local Date Formats

How hard could it be to allow tools like FastTrack, Metadata Workbench and so on to use local date formats rather than US ones? Dates like 1/17/12 are anathema in my part of the world, where DMY is the default order. If that's too hard, why not hard code every date in ISO 8601 format (CCYY-MM-DD HH:...
by ray.wurlod
Thu Feb 02, 2012 12:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sort option
Replies: 6
Views: 3046

Cluster is where the rows are clustered (contiguous) but not necessarily sorted.