Search found 42189 matches

by chulett
Tue May 01, 2007 6:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to stop running job
Replies: 8
Views: 2663

Since you've marked the post as such, what is your 'workaround'? So, you stopped it but your issue is the fact that the Director doesn't reflect that? The kill command should be avoided as much as possible, especially a "kill -9". You need to know that when you kill a phantom process, the fact that ...
by chulett
Tue May 01, 2007 6:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Facing a problem in order to pass a value from Sequencer
Replies: 8
Views: 3137

Sorry, but the problem I have with 'silver platter' answers like this is there typically is no learning involved. I suggested the search because then one would get to read discussions on what exactly was happening and why the solution as provided, was provided. Then the brain juices start flowing an...
by chulett
Mon Apr 30, 2007 10:38 pm
Forum: General
Topic: Zero Byte file Input problem
Replies: 11
Views: 5919

So do you always write only one record to the output file? Or do you process all of the incoming data, write some/all to the output and then always append one more record to the file? More of a curiosity than anything. I'd suggest you write an 'after job' routine. Pass it in the Stage Name of the Tr...
by chulett
Mon Apr 30, 2007 9:45 pm
Forum: General
Topic: Zero Byte file Input problem
Replies: 11
Views: 5919

You're right, an empty source file will process zero records in the job and then nothing will be written to the target file. What is special about this 'one record' that needs to be written when you have no input? Describe it, please.
by chulett
Mon Apr 30, 2007 6:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Folder Stage
Replies: 8
Views: 2222

Doesn't matter, I've used both mechanisms without issue and I never knew how many files there will be. Concatenate / Loop based on a wildcard pattern.
by chulett
Mon Apr 30, 2007 5:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Folder Stage
Replies: 8
Views: 2222

Concatenate them together, then load. Or build a Sequence job to Loop through them one at a time, assuming you are on at lease a 7.5.x release.
by chulett
Mon Apr 30, 2007 5:05 pm
Forum: General
Topic: Batch Password change?
Replies: 12
Views: 3451

I'd suggest you search the pdf docs for $PROJDEF as the bits that explain this are a little scattered around. The Administrator Guide and Designer Guide primarily cover it.
by chulett
Mon Apr 30, 2007 2:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC for Accessing Flat Files
Replies: 10
Views: 1548

DSguru2B wrote:I have giving you a link in my previous post.

Oh really? Not in this thread.
by chulett
Mon Apr 30, 2007 1:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: using grep
Replies: 6
Views: 1349

Sorry, misunderstood what needed the quotes. So, coldes is passed into the routine as Arg1? With the double-quotes inside? And then you reassign inside the routine? coldes = Arg1 If you've done something like that, then you need to get the variable out of the string so the value gets properly substi...
by chulett
Mon Apr 30, 2007 12:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: using grep
Replies: 6
Views: 1349

Try:

Code: Select all

Ucmd='grep coldes "':<filename>:'"'

So that the double-quotes are just part of the command string when built. Or there is something like a 'dquote' function, I believe.
by chulett
Mon Apr 30, 2007 11:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to run Parallel Jobs on my Machine.
Replies: 2
Views: 1024

Nothing is wrong, per se. You've got a version that doesn't allow PX jobs to run on Windows - it needs to be either 7.5x2 or 8.x for your jobs to be runable on Windows.
by chulett
Mon Apr 30, 2007 11:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC connection to Sybase
Replies: 3
Views: 954

Yes, that's exactly what I mean. :wink:
by chulett
Mon Apr 30, 2007 9:46 am
Forum: General
Topic: Batch Password change?
Replies: 12
Views: 3451

Aren't you using Job Parameters for this? If so, why aren't those values stored in some sort of central location that all jobs leverage, like parameter files or tables? That would make the change a '2 second' change. You could play the export / edit /import game to do this all in one big whack but ...
by chulett
Mon Apr 30, 2007 9:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Autosys Job
Replies: 14
Views: 10599

Seems to me you have at least two choices. What people typically 'schedule' is a script that wrappers the dsjob command. If you want to build that functionality into the script itself, that would be one answer that is not AutoSys specific. Otherwise, I would think it would be trivial to just tell th...
by chulett
Mon Apr 30, 2007 9:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: pivot dyanmic user
Replies: 2
Views: 711

Do you know the maximum occurances?