Search found 42189 matches

by chulett
Tue May 12, 2009 7:37 am
Forum: General
Topic: What is the use of Command tab in Datastage Administrator ?
Replies: 2
Views: 1006

Edited to add - Assuming you mean the button :wink: it's so you can run sql-like 'commands' against the Universe repository. Common usage - to get the internal job number for a job name or vice versa. Tip of the iceberg.
by chulett
Tue May 12, 2009 5:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DRS Stage "Function Sequence Error" w/SQL Server
Replies: 7
Views: 3303

But the job runs fine? :?
by chulett
Tue May 12, 2009 5:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to allocate Type 30 descriptor, table is full
Replies: 10
Views: 9317

With everything stopped / shutdown:

$DSEngine/bin/uv -admin -regen

This makes any changes to your uvconfig file... 'live'.
by chulett
Tue May 12, 2009 5:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: link collector stage time out problem
Replies: 1
Views: 1281

Search the forums for "timeout waiting for mutex", 68 matches and rising.
by chulett
Mon May 11, 2009 4:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Concatenation of multiple row string values to one column
Replies: 4
Views: 2559

That would be a 'vertical pivot' of rows to columns, search for that term here for many discussions on the topic. Typically, a transformer and stage variables are used to do the concatenation within key groups.
by chulett
Mon May 11, 2009 1:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Selecting a particular row in a sequential file
Replies: 7
Views: 2537

Still, the answer to the question is 'no'. It's sequential media and thus somehow you have to read the first 8 records to get to the 9th one.
by chulett
Mon May 11, 2009 7:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Process Multiple files:Process Each file in each run
Replies: 4
Views: 1994

The name of the routine you wrote, as one example.
by chulett
Mon May 11, 2009 6:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: odbc issue in datastage 8.0.1
Replies: 6
Views: 1780

How can we, with so little information posted? What are you trying to connect to and with what driver? Details, man, details.
by chulett
Mon May 11, 2009 6:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with Pivot and bulk load stage
Replies: 3
Views: 1348

If you made any changes to the dsenv file for the old version, you'll need to make them again after the upgrade as it was reset back to the default. At least double-check it. Your old one should be backed up there.
by chulett
Mon May 11, 2009 6:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Output stage
Replies: 2
Views: 1119

Post the XPath Expressions you are using and let us know which column is marked as the Key column.
by chulett
Mon May 11, 2009 6:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Like Operator in datastage
Replies: 4
Views: 15612

So... resolved? If so, mark it Resolved using the button at the top of the screen please.
by chulett
Mon May 11, 2009 6:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Filter Error: The system cannot find the file specified
Replies: 11
Views: 4182

Does the filter command work if the job parameters are not environment variables but just 'normal' ones?

ps. Why mark it as having a 'workaround'? :?
by chulett
Mon May 11, 2009 6:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Rotine Activity triggers
Replies: 2
Views: 1544

Suggest more information is needed. Post the complete Sequence design and the details of what the routine does and the triggers used.
by chulett
Mon May 11, 2009 6:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job is being accessed by another user
Replies: 2
Views: 1700

First question - did you attempt this as either 'dsadm' or the logged in user you were attempting to unlock?
by chulett
Mon May 11, 2009 6:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DRS Stage "Function Sequence Error" w/SQL Server
Replies: 7
Views: 3303

You get this when the job runs or just when you do a View Data? I ask because after I reported some odd problems, I was told quite insistently that I could not use an older 7.5.x client with a newer 7.5.x server, in spite of the fact that it was documented as compatible.