DSXchange

Hello there, Can anyone help me in storing the log files, generated in compilation, in a separate directory. I searched the archive and could not find a solution to my problem, eventhough I found some useful information. I would highly appreciate if someone could post their views here which I think ...

Hello there, Can anyone help me in storing the log files, generated in compilation, in a separate directory. I searched the archive and could not find a solution to my problem, eventhough I found some useful information. I would highly appreciate if someone could post their views here which I think ...

Hello all,

Thank you very much for your suggestions.
-Yamini

Hi Roy,

First of all thank you for your reply.
Can you explain to me how to accomplish the two tasks you listed: Text/Ascii files and Report summary.

I appreciate your time.
-Yamini

Hi Ray,

Thank you very much for your reply. Can you elaborate about the SQL code in DataStage(TCL) Environment.
I appreciate your time.

-Yamini

Hello there, I have 5 jobs in my project and I want to store all the log files generated while executing the jobs. To be precise, when I execute a job 'A' for example, I want to store the log file generated for this job in a directory. Similarly, I want to store all the log files generated when I ex...

Hello there, I have 5 jobs in my project and I want to store all the log files generated while executing the jobs. To be precise, when I execute a job 'A' for example, I want to store the log file generated for this job in a directory. Similarly, I want to store all the log files generated when I ex...

Hello there,

Thank you all for your suggestions. I got the solution for the problem. Actually, there were some leading spaces in the 'Name' column.

-Yamini

Hi,

These are the conditions I was using to define the Constraints.

DSLink3.Name = 'SUN' (It does'nt work)
DSLink3.Age = 26 (It works fine)

Can you explain me what is the problem.

Thanx in advance.
-Yamini

Hello there, I am trying to distribute data in the source table into three target tables based on the values in the source columns. I am trying to accomplish this by defining a constraint in the 'Transformer' Stage. When the source column is of numeric type, I have no problem in defining the constra...

Hello there, I have one source table(A) with details of employees. It contains Dept.Name and Dept.Number columns along with some other columns. A person can work in different departments. In the target database, I have two tables namely employee table(B) and employee_account table(C). If a person(Sa...

Thank you David,

-Yamini

Thank you Ray.

-Yamini

Hi Eric,

Even as the user 'dsadm', I can just compile the job. After that I could not execute it. Any suggestions what could be wrong.
Thanks in advance.

-Yamini

Hello Ray,

Yes, the Run option dialog box opens and nothing is happening after that. Any suggestions.
-Yamini