Search found 42189 matches

by chulett
Mon Feb 13, 2012 8:10 am
Forum: General
Topic: issue with DS.TOOLS menu not working from adminstrator.
Replies: 9
Views: 2925

Re: issue with DS.TOOLS menu not working from adminstrator.

venkat_april wrote:I am not able open the menu DS.TOOLS from adminstrator for one project but it's working for rest of all the projects.
Is this still true, one project only?
by chulett
Mon Feb 13, 2012 8:06 am
Forum: General
Topic: File Name in format Name_date_recordcount
Replies: 1
Views: 645

It's been discussed here quite a bit. For the 'filename' portion, one approach is to pass the date in as a Job Parameter so that it can be leveraged in the output stage. Adding in the complication of the record count means you either need to pre-count the data for the file and pass that in as well o...
by chulett
Sun Feb 12, 2012 10:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Substracting two timestamp columns
Replies: 5
Views: 1699

So let it be written, so let it be done. Welcome to the PX forum. Let us know if that was a bad choice.
by chulett
Sun Feb 12, 2012 10:55 pm
Forum: General
Topic: Routine DSSendMail error
Replies: 2
Views: 1334

You're certain nothing has changed? Sure seems like something must have. What about UNIX patches, changes to your SMTP software or anything of that ilk? Have you had a chat with your Admin? According to the standards, that error is supposed to mean that the command it received was actually recognize...
by chulett
Sun Feb 12, 2012 8:03 am
Forum: Site/Forum
Topic: Are you able to read/write topics? Errors on many forums...
Replies: 5
Views: 5837

... and away we go.
by chulett
Sat Feb 11, 2012 10:38 am
Forum: Site/Forum
Topic: Are you able to read/write topics? Errors on many forums...
Replies: 5
Views: 5837

:idea: People, if you are voting No (and I see we have some already) and the ones you can't access are not locked or member only forums that you aren't a member of, can you please include a comment as to the specific forums you are having an issue with?

Thanks.
by chulett
Sat Feb 11, 2012 10:35 am
Forum: Site/Forum
Topic: Are you able to read/write topics? Errors on many forums...
Replies: 5
Views: 5837

I'm not sure I'm a good person to be responding (what with my superpowers and all, LOL) but did want to point out a couple of things. Some of the forums are locked and they have a padlock included in their icon: Archive of DataStage Users@Oliver.com Talent Parameter Manager Compile All Plus Locked f...
by chulett
Fri Feb 10, 2012 6:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS job CREATE/UPDATE
Replies: 15
Views: 13559

That path leads to the Dark Side. :wink:
by chulett
Fri Feb 10, 2012 1:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS job CREATE/UPDATE
Replies: 15
Views: 13559

Away put your weapon. :wink:
by chulett
Fri Feb 10, 2012 10:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS job CREATE/UPDATE
Replies: 15
Views: 13559

Quite. That's the nature of sequential media. Now, we're not talking via an editor, stream or not, I'm saying you can't treat it like a relational source and update a specific record in place... unless we've moved into the realm of indexed sequential files.
by chulett
Fri Feb 10, 2012 8:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS job CREATE/UPDATE
Replies: 15
Views: 13559

There is no mechanism to "update" a sequential file. You'll need to compare both sources and either write out new/updated records from the new source or any original records not 'updated'.
by chulett
Fri Feb 10, 2012 8:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error loading DB2 table using ODBC stage
Replies: 5
Views: 3187

How are you controlling the partitioning? Do an exact search here for "deadlock" to find many conversations on this subject.
by chulett
Fri Feb 10, 2012 8:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Ds job should run daily and pick the current date file.
Replies: 9
Views: 10247

It's been "reverted"... do you have any specific questions?
by chulett
Fri Feb 10, 2012 8:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 904 Error
Replies: 7
Views: 1773

This minimizes the amount of memory that the Aggregator uses, basically allowing you to go back to one job and process any number of records.
by chulett
Fri Feb 10, 2012 8:08 am
Forum: General
Topic: Restoring VOC
Replies: 10
Views: 3578

ray.wurlod wrote:SQUAWK is a keyword that specifies that you want the COPY command to report what it has done. A synonym is REPORTING (but don't you find that horribly staid now that you know about SQUAWK?).
I find it horribly 8)

Perhaps whomever coded this up was a former Air Traffic Controller.