DSXchange

Hello,

I read in the post

"difference between Datastage' S release 6x and 7x"

that one could start again a job sequencer only on the jobs in failure. How to make? Is it about a new functionality of V7?

Thank you for your help

Muriel

Hello,

I have a job which must be to carry out time as many as there are files in the repertory.


How can I make?

Thank you for your assistance

Muriel

Thank you for your answers.

I chose the solution of vikramarjula.

I had another problem.

I had dates 0001-01-01. With the solution of vikramarjula, I can treat the data without problem

Bye

Muriel

Hello, I start under PX. I must extract from the data of a base DB2 with dates and stored in a dataset of which the structure is the same one as the table. The problem is compared to the dates. How then I convertr a date db2 my date : 12965 (2003-06-30) I want : 2003-06-06 or 12965 (2003-06-30) when...

What I want to do, it is for each recording of the table, I must recover a field in the lookup, by making a joint on the key field of the lookup (like a hasfile on a job server)

In a preceding job, I charge the lookup.

Thanks for your help

Muriel Auvray

hello I beginning on PX. I am much more at ease on Datastage server. I do not manage to have a lookup in reference. As soon as I want to set up the bond, I have an error message which says that the training course to transform cannot receive several direct links in input. somebody can it explain to ...

Hello,

I have several lines which I would like to put on only one line.

I have

Key_1|Key_2
1 A
1 B
1 C
2 A
2 C
3 B

I want

1 A B C
2 A C
3 B

I do not know how much it can exist events.
How then to make?

Thanks

Muriel Auvray

Hy, I had the same problem. The problem to make the "delete" in "before sql", it is that if you have many lines to remove, you risks saturated the newspaper with transaction on DB2. The solution that we installation constitutes to carry out the following order in "before job...

Hello,

the function should be used:

FMT('Arg1', '14RZ')

the function TRIM should be imbricated

TRIM(FMT('Arg1', '14RZ'))



Muriel

Hello, You do not need to reinstall. should be followed the following stages: It is necessary to be connected with an account administrator. it is necessary to connect to the base universe datastage in a window telnet telnet host machine user admin datastage password datastage account (project) Carr...

Hello, I have a routine which was provided to me by the support Ascential France. This routine Purges the logs of a job in function deu last RUN, of a date, or all the log. ********************************************************* **WARNING : This routine should not be used to clear the logs of a ru...

Why you do not put a default value (sysdate) in the script of creation of the table on fields "CREATE_DATE COLUMN" ? With each new insertion the fields will be indicated by the date system. You do not need to treat it in your jobs, and it as that it is not updated in the event of update. T...

Hello, We use the DSMakereport function to manage a report at the end of each treatment. The problem is that after the first loading, if a job did not turn, the report returns the last status of the job. I will thus wish to make a job control which will make a reset of all the jobs before each treat...

Hello
Do you Have to try in the module director to make a "clear status file" on the job concerned?

When I have the problem, I proceed in this way and it goes, but it is in V6...

Muriel

I will test the loading without constraint and transformations.

For the lookups, I pass by the hashfiles, and there I do not have problems of performances.

The only problems of performances, are at the time of the writing in the data base...


Muriel