DSXchange

Hello,

I seek the routine "jobs reports" for DataStage V5.2.
I have it for V7, but I cannot import it on V5.
Can somebody help me?

Thank you in advance

Muriel

Thanks, I tested, but there makes some is a routine which is called "JobReport", and this routine is provided compiled without the source code. I think that there is a problem of libriairie. When I make the importation I have error messages : "Line 70: Unknown property name 'Orchestra...

hello,

I would like to know if somebody has the job "DSJobReport.dsx" so that I can put it on version 5.2.


The version that I recovered on the forum cannot be imported on version 5.2

Thank you very much


Muriel

Hello,

I must extract the data of a data base (DB2) and store them in flat files with fixed size.

My problem is to generate files with the first line is the name of the columns.

How then I to make?

thank you for your assistance.


Muriel

Hi,

The dsjob.exe command is in the repertory of the engine

==> by default on windows /Ascential/datastage/Engine/bin

Try this

Muriel

Was the installation made with the account "root"? If so, have you to position the umask with 022, so that the rights are to propagate with under repertories of the projects? Do you connect yourself with dsadm? If so, it is strange which you cannot reach the projects, if dsadm is the owner...

Hi

It is necessary to check that your to user formed well part of the group who is owner of the repertories of your projects.

If it is not the case, then adds your to user with the group (in general the group it's dstage)

good courage

Muriel

Hello,

I must write in sequential files, but the first line must be the heading of columns. I do not find the option which makes it possible to do that. Can one do it in PX? If so, how?

I did not find anything in documentation

Muriel

Thank kduke, But how to make a head on each file, since when the job traverses the repertory, it makes the equivalent of a concatenation of file, therefore I do not find any more the first line starting from the 2nd file ? vmcburney, it is a coincidence the fact that the first character is numerical...

Hello, I have several files sequentiels in a repertory, and a job which treats the whole of the files of the repertory. Each one of these files contain a first recording different from the others (cutting different). File_1 INPUT Line 1 : AAA12345ZZZZZZZZZZ Line2 : 38890BBBBBCCCDDDDD Line2 : 99990EE...

Hello, I have several files sequentiels in a repertory, and a job which treats the whole of the files of the repertory. Each one of these files contain a first recording different from the others (cutting different). I must recover information in the first line of each file. I make a test: If @INROW...

I have just made the test, and it is not obligatory to have the training course "Exception".

It's cool :D

Still thank you

Muriel

Thank you beacoup, I will carry out a test.

Muriel

Thank you very much. Is it obligatory to have a stage "Exception Handler" in the Job Sequencer so that that functions?? If so, I did not understand at which place I must positioned. :roll: In entry of each job must it be? Like the drawing below ? JobActivity_01------------------------> Seq...

I am in version 7.1 :D , but how is that set up?

Muriel