Search found 93 matches

by joesat
Thu Feb 05, 2009 12:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Display Jobs in a Category
Replies: 20
Views: 8300

I wrote a batch file that does it : !DirDSBin!dssh COMO ON !FicSortie! !DirDSBin!dssh SELECT !CommandeDS! move !FicSortie! %DirSauve%\!FicSortie! set FicResultat=Repository_!Projet!.csv for /F "skip=3" %%B in (%DirSauve%\!FicSortie!) do ( set LigneLue=%%B if !LigneLue! neq "SQL+"...
by joesat
Tue Feb 03, 2009 10:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Record Count of Hashed File
Replies: 12
Views: 6482

I do not have administrator priviledges :-(...can i still do what you guys have suggested?.. thanks for the replies!
by joesat
Tue Feb 03, 2009 9:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Record Count of Hashed File
Replies: 12
Views: 6482

Record Count of Hashed File

Is there any way that we can get the record count of a hashed file? I do realize that we can write it to a sequential file and then get the count. When it comes to datasets, we are able to use the orchadmin commands to get the count. Similarly, is there any way to get the record count of a hashed fi...
by joesat
Thu Nov 06, 2008 7:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Display Jobs in a Category
Replies: 20
Views: 8300

i am sorry.. but is this code in "francaise"?
by joesat
Thu Nov 06, 2008 4:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Display Jobs in a Category
Replies: 20
Views: 8300

..and, I am using DS 7.5 version..
by joesat
Thu Nov 06, 2008 4:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Display Jobs in a Category
Replies: 20
Views: 8300

I am also looking for a similar requirement.

But I do not understand the initial command the shaanc is talking about either. :-(
by joesat
Tue Jul 08, 2008 2:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Write failed for Hashed file
Replies: 2
Views: 1128

Search did not return any results.. just the same old 'No posts match your criteria' However, i tried searching for the same terms again two hours hence and it seems to return results... maybe, there was some maintenance thing going on... anyway, will close this topic and search the other options av...
by joesat
Mon Jul 07, 2008 10:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Write failed for Hashed file
Replies: 2
Views: 1128

Write failed for Hashed file

A Server job with hashed file stages failed with the following error. I checked if this was due to lack of disk space, but there seems to be abundant space available. HashStageName.hashCGP.TohshSplyis98: WriteHash() - Write failed for record id '7074STL' Please let me know where I need to start chec...
by joesat
Wed May 28, 2008 10:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Logs path in /dsadm??
Replies: 9
Views: 3219

DS Logs path in /dsadm??

I have used a Peek stage in a job for debugging. It so happened that a large number(60000) of records was displayed in the job logs, and so used up a large area in the log folder. I would like to know where exactly the logs are being stored in the /dsadm path, so that I can delete them. I am aware t...
by joesat
Mon May 05, 2008 4:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Capture job parameters during runtime..?
Replies: 15
Views: 8475

I am not sure what you did to make it work Jim :?:
by joesat
Mon May 05, 2008 3:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence does not abort even though job activity aborts
Replies: 3
Views: 2064

It would be great, if you guys can educate me on the DS Constants part, ie. using inbuilt values as Arndw suggested... is it any different from specifying the exit codes as numeric values... could this be a cause for my problem?
by joesat
Mon May 05, 2008 12:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence does not abort even though job activity aborts
Replies: 3
Views: 2064

I'll try that Rubu, thanks :-) But I have some other existing sequences which seem to work properly with the same kind of condition (ie. specified as Jobstatus=1 or 2 in the trigger section)... that is, the job triggers the next activity when it finishes OK or with warnings; but fails otherwise, and...
by joesat
Fri May 02, 2008 7:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Capture job parameters during runtime..?
Replies: 15
Views: 8475

The different job parameters used along with a job will be displayed in the job logs. One can extract that specific log and write it to a sequential file.
by joesat
Fri May 02, 2008 7:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence does not abort even though job activity aborts
Replies: 3
Views: 2064

Sequence does not abort even though job activity aborts

I have a job sequence with a Job Activity followed by an Execute Command Activity. I have given two conditions for the trigger from the Job Activity - one to trigger the Execute Command if the job completes with a status 1 or 2, second to terminate the sequence if the job aborts. I have used a termi...
by joesat
Mon Apr 28, 2008 7:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is there a PX equivalent to the Char() and Seq() functions?
Replies: 7
Views: 1492

so the only help available is the 'Search' button on dsxchange.com, right Arndw :wink: ?