Search found 42189 matches

by chulett
Fri Aug 13, 2010 7:32 am
Forum: General
Topic: My loop stopped working
Replies: 6
Views: 1883

Fair enough. In hindsight while I didn't generally have issues with 'complex' sequence jobs, I did have an issue with one and oddly enough it also involved a loop. It had been working fine and then went sideways after I tweaked some innocuous thing. Now that I think about it, it started looping once...
by chulett
Fri Aug 13, 2010 6:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to view the Log file.
Replies: 20
Views: 4962

Somehow in all those shenanigans you corrupted or removed part (or all) of the log's dynamic hashed file. The reimport recreated that for you.
by chulett
Fri Aug 13, 2010 6:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: External Target Stage
Replies: 5
Views: 3065

First (for me at least) you'd need to clarify what exactly it is you are trying to accomplish. For whatever reason, neither your original post nor your fifo solution make much sense to me as I'm not really sure what you mean by 'assigned this value dynamically to the dsadmin commands'. Can you expan...
by chulett
Fri Aug 13, 2010 6:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic Transformer in Datastage 8.1 Parallel job
Replies: 7
Views: 6851

As they say - TNSTAAFL. This decision may very well have saved 'lots of efforts' now but will hurt you in the long run as it really is not a Best Practice especially when painted on with such a liberal brush. As noted you should allocate time later in the project to do this the right way before it b...
by chulett
Fri Aug 13, 2010 6:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dssearch command not recognizing category name having space
Replies: 6
Views: 3556

From a TCL prompt or using dssh:

Code: Select all

SELECT NAME FROM DS_JOBS WHERE CATEGORY = 'xxxxxx';
by chulett
Fri Aug 13, 2010 6:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to remove control M or special character by ds jobs
Replies: 8
Views: 11732

Sainath.Srinivasan wrote:If ^M is at the end of the record, it may be due to DOS type record termination. Setting this property will handle it properly.
This, typically. But as Arnd noted there are various ways so it really depends on the where and the what of it.
by chulett
Fri Aug 13, 2010 6:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error reading Excel worksheet
Replies: 5
Views: 4219

So is this actually a Server job? Yours are usually PX ones and we are in the PX forum after all, hence the question.
by chulett
Fri Aug 13, 2010 6:17 am
Forum: General
Topic: My loop stopped working
Replies: 6
Views: 1883

That's... odd. I have no idea what would cause something like that or why you'd have to take such drastic action to get it to loop properly. One suggestion would be to look at the Job Properties tab with all of that loverly generated code and step through that, see if anything there lets you know wh...
by chulett
Thu Aug 12, 2010 11:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Change Capture Stage Warning
Replies: 4
Views: 3354

So 'promote' the message handler from the job along with it. They're stored locally in the one of the job specific folders (SC?) with 'msh' in the filename from what I recall.
by chulett
Thu Aug 12, 2010 8:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: String data getting Null or Hex(00) appended to it
Replies: 8
Views: 2863

It's actually $APT_STRING_PADCHAR and the default is the null you are seeing. If it doesn't exist, add it as noted set to a space. Seems like you could do as you said - extract, trim, reload - or you could probably just do this via sql in your target database without all that.
by chulett
Thu Aug 12, 2010 5:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Phantom error and need to stop file creation in &PH&
Replies: 7
Views: 2360

Disable? No. Prune? Yes. Easy enough to create a cron script to run in off hours and delete all files over X days old.
by chulett
Thu Aug 12, 2010 5:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RT_SCTEMP/jobname.fifo locked
Replies: 6
Views: 4613

Durga, please start your own post so we can have all of the particulars of your version of this problem since I doubt it is exactly the same version, hardware, O/S, etc as this three year old post.
by chulett
Thu Aug 12, 2010 4:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Varchar Length
Replies: 5
Views: 1693

:idea: The words you are looking for are "positive" and "negative", not "+ve" or "-ve".