Search found 42189 matches

by chulett
Wed Aug 27, 2008 7:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Run-time error '457'
Replies: 10
Views: 8319

Reindex the project. Search the forums for reindex and/or DS.TOOLS for any of the many conversations we've already had on this topic.
by chulett
Wed Aug 27, 2008 7:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file Normalize on
Replies: 2
Views: 1596

You need a VOC record for that, so the hashed file has to be created in an 'account' rather than pathed or you need to create the VOC record manually.
by chulett
Wed Aug 27, 2008 7:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version Control repository
Replies: 11
Views: 4970

just need to determine the number sequencer for the 6 hash files I'm seeing on each job. The files I'm seeing one of them is a temp file RT_BP5456 RT_BP5456.O RT_CONFIG5456 RT_LOG5456 RT_STATUS5456 DS_TEMP5456 Interesting. I have five. The ".O" one is created when the job is compiled and one doesn'...
by chulett
Tue Aug 26, 2008 11:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Droping Oracle Table
Replies: 13
Views: 3929

The "DSU" prefix means it is a user written BASIC routine, so the only one that can fix or trouble shoot it is you and yours. Check the Routines\Custom branch of the repository from the Manager for starters.
by chulett
Tue Aug 26, 2008 11:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing Parameter value with double quotes
Replies: 8
Views: 2582

Are you saying the double-quotes are actually part of the table name? That's hard to believe and a horrible practice if true. Are you certain? Have you tried the query without them to see if it works that way? Many tools like Toad optionally quote object names like that, the vast majority of the tim...
by chulett
Tue Aug 26, 2008 11:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Confusion on DS 7.5x2?
Replies: 4
Views: 1387

If you only need Server jobs then you are wasting a whole lotta money if you buy the Enterprise Edition.
by chulett
Tue Aug 26, 2008 11:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML Output stage
Replies: 7
Views: 2610

Can you say "Code tags preserve whitespace" boys and girls? I knew you could. :wink:

(need to put that on a license plate frame or something)
by chulett
Tue Aug 26, 2008 11:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Confusion on DS 7.5x2?
Replies: 4
Views: 1387

At a high level, Server means Server and Enterprise means both Server and Parallel. 7.5x2 is 'enterprise' as it only exists to allow PX jobs to run on Windows in the 7.x world.
by chulett
Tue Aug 26, 2008 11:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version Control repository
Replies: 11
Views: 4970

Re: Version Control repository

In regards to problems related to moving things around from 1 category to another, many of those posts result in advice to re-build repository index. I don't see the connection unless you get an error when trying to move something. In that case yes, you need to reindex to fix the corruption. The di...
by chulett
Tue Aug 26, 2008 11:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to FTP a file from Remote Server to Datastage Server
Replies: 6
Views: 5118

rajeshknl wrote:Chullete i think transfering of file is different from transfering data. By latter i mean reading data from remote file and write to the destination file.

Semantics.
by chulett
Tue Aug 26, 2008 11:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to FTP a file from Remote Server to Datastage Server
Replies: 6
Views: 5118

First mention of zipped files or 'poll and ftp lot of files'. The answers you get are directly affected by the questions you ask and the detail you do (or in this case do not) provide. The FTP stage is metadata driven, so it only handles single files and only then if you can accomodate the metadata...
by chulett
Tue Aug 26, 2008 6:26 pm
Forum: General
Topic: Invocation Id not being always set
Replies: 9
Views: 3713

On the off chance you're not aware - from the command line you append the invocation id to the job name with a dot separator.

JobName.InvocationID
by chulett
Tue Aug 26, 2008 5:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Left Outer Join results in empty values which we cant check
Replies: 12
Views: 8645

I know, but was trying to point out why that 'worked' when the IsNull function was not 'working as expected'. And that would be when checking an empty string and assuming it was null or when thinking they were the same thing.
by chulett
Tue Aug 26, 2008 4:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Left Outer Join results in empty values which we cant check
Replies: 12
Views: 8645

That doesn't check for nulls, it checks for an empty string.