Search found 53125 matches

by ray.wurlod
Fri Jun 04, 2010 4:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mixed O/S 3 Tier Architecture for DataStage
Replies: 12
Views: 7156

Theoretically it's possible but IBM usually advise against mixing platform types.
by ray.wurlod
Fri Jun 04, 2010 4:21 pm
Forum: General
Topic: CORBA TRANSACTION_ROLLEDBACK
Replies: 4
Views: 12421

Let's start with what kind of user authentication you are using with WebSphere Application Server for Information Server - is it internal user registry (Information Server repository), operating system or LDAP? "Failed to authenticate the current user against the selected Domain" reports t...
by ray.wurlod
Fri Jun 04, 2010 4:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Insert and update DB table fails when input umlaut character
Replies: 16
Views: 6293

That is so ugly. What's wrong with two jobs? I have to guess that dummy is a Transformer stage, and that the file to which you write in the sequential file stage downstream of dummy is not the same file read by this stage. Have you placed documentation in your job - ideally an annotation - alering f...
by ray.wurlod
Fri Jun 04, 2010 4:12 pm
Forum: IBM QualityStage
Topic: Exporting Xmeta Repository
Replies: 1
Views: 1489

Information Server Manager (GUI tool). It has istool as its command line equivalent.
by ray.wurlod
Fri Jun 04, 2010 4:10 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: InformationAnalyzer Log
Replies: 7
Views: 4048

That log is native_stderr.log, and all its showing is one problem allocating memory (which was managed) and garbagecollect operations occurring as required (every minute suggests that some activity was finishing). There's nothing in this particular problem to indicate that you have the same problem ...
by ray.wurlod
Fri Jun 04, 2010 6:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cause of Error: field does not exist in the table
Replies: 9
Views: 2242

Ordinarily I recommend creating an alias/synonym for the table name, with no space or other illegal characters, and the use of that for interaction with DataStage.
by ray.wurlod
Fri Jun 04, 2010 6:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Environment variables
Replies: 12
Views: 3990

An infinite list?!! Even an infinite number of monkeys could only manage the complete works of Shakespeare - not a single environment variable among them!
by ray.wurlod
Fri Jun 04, 2010 6:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Insert and update DB table fails when input umlaut character
Replies: 16
Views: 6293

True (what Craig said) but a sufficiently severe setting of transaction isolation level can cause even inserts to take a page-level or table-level lock.
by ray.wurlod
Fri Jun 04, 2010 6:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cause of Error: field does not exist in the table
Replies: 9
Views: 2242

Shouldn't matter. The column does not exist in the named table.
by ray.wurlod
Fri Jun 04, 2010 2:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading data from PDF file.
Replies: 3
Views: 1687

I'd use a Sequential File stage with a PDF converter as the filter command.
by ray.wurlod
Fri Jun 04, 2010 2:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Documents related to partitioning
Replies: 1
Views: 885

The "Server to Parallel Transition Lab" training DVD, available from DSXchange Learning Center, has some material on partitioning.

So does the IBM training class "Advanced DataStage" or some such title.
by ray.wurlod
Fri Jun 04, 2010 2:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cause of Error: field does not exist in the table
Replies: 9
Views: 2242

The Field (column) called 'WORK_HISTORY_FUNCT_LOCAT_SHORT_DESCR_CHR' does not exist in the table 'Work History'. That is, the metadata (table definition) used in your job does not accurately reflect the column name(s) used in the 'Work History' table. This error may be being thrown spuriously becaus...
by ray.wurlod
Fri Jun 04, 2010 2:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Insert and update DB table fails when input umlaut character
Replies: 16
Views: 6293

Change your Array Size to 1, at least while testing, so that the OLE provider can accurately report the actual row in which the allegedly invalid data occurs.
by ray.wurlod
Fri Jun 04, 2010 12:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Read Dat file in datastage
Replies: 7
Views: 3374

Seriously, though, rameshkm needs to elaborate what is meant by "Dat file", as requested.
by ray.wurlod
Fri Jun 04, 2010 12:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Read Dis File in Datastage
Replies: 4
Views: 1147

Oh noes! You broke the juxtaposition with Read Dat file in DataStage!!