DSXchange

read your source file and write it to a Hash file.

I am trying to get the job stats like when it is started, ended, input link counts and outut link count... I tried using DSGobLogSummary fucntion but the code i got it in message board is returning the same as in Director but i need the output in detail. Like if you click the director log it will po...

Where do we code the following code is it in JobControl or create it as a After/Before job routine. Any help is appreciated!! Thanks ArndW. That was quite useful, I enhanced the framework suggested by you to suit multi instant jobs and following is the code...Might be useful for some... Thanks again...

Thanks! Arndw

Luciana,

Actually i am looking for DSMakeJobReport function code it self.

Hi,

Any idea where do i get the code for DSMakeJobReport.

Thanks

Where do we run these SQL's if it is in Administrator, should it be in single line ?

Hi,

My Director is not able to show a particular job log , may be it is too big to load.
Is there a way to look at the Job Log in Unix? , not thru Director.
if so where do i look for job log in Ascential path?

Thanks

Thanks Ray!
it was my fault!!! project name is in "abc" (Lower case).

Hi
When i run following Dsjob command it is giving follwoing error ERROR: Failed to open project

Status code = -1002

I am running this command from Unix command line in DataStage/DSEngine/bin path.

Any help is appreciated!

Hi ArndW If i understood correctly, first i need to read the source file with out any delimeters... and in the transformer use Dcount to get the number of delimeters (for example if i get the count of delemeters 50 then in the constraint Dcount(Link.rec,'|') = 50 then good records) and write to outp...

Hi all, I have a sequential file with Pipe delimited format, and i have layout for that. But the some of the input records are not following the Metadata layout, i would like to write those records to another file and good records to good file. Good Input record with correct lay out:- AAA|BBB|CCC|12...

Craig summed it up well. Things will not break, if that's what you were concerned with. However, there is a computational penalty (recall that DataStage is primarily a 32-bit environment, so has to construct 64-bit numbers) as well as a space penalty (there are three or five pointers per record, so...

how to check that one.. ?

Hi Ray, We did not change any parameters in that job, we are currently (use to) using 50000 as Array Size at Oracle (ORAOCI9) stage and "Allow Stage Cache" check in Hash file stage. Do you think is 50000 is huge and also " allow stage cache" also over head at hash file stage. wha...