DSXchange

In few cases I have faced problems with Transformer compliation,
That case was, when I tried to handle the null for a stage variable.

I tried like If Isnull(STAGEVAR1) then ' ' Else Trim(STAGEVAR1).

Check out, If you have any cases like these.

One can reduce the overhead of including additional stages when the same functionality is provided by the previous stage (ORDER BY clause in this case).[/quote] Here overhead of one sort stage is not a problem. The tsort operators from Datastage will overhead to your job. The tsort operators will de...

Hi, Can we write a script to assign default value to Datastage ENVIRONMENT variables? If yes, then is it a good practice or not ? Bandish Normally, Datastage ENVIRONMENT variables are used to Override the default values at project level or at job level. Usually these values are True or False and so...

Hi, Warning Messages- We have to analyse those warnings properly and by max, we have to find the cause and solution for the same. Message Handlers are helpful, whenever your warning is not harming your job and if your unable to find a solution for your warning. Warning like Prior Component with same...

Hi, More Info about ulimit : /usr/bin/ulimit The ulimit utility sets or reports the file-size writing limit imposed on files written by the shell and its child processes (files of any size may be read). Only a process with appropriate privileges can increase the limit. Fire the following command in ...

Hi, As per your requirement, It is must to abort your main sequence and then only you have a option of Restart of Main and Subsequence after failure. It will not make any problem, even though your main sequence shows aborted. More ver, it is giving you a option of restarting of your failed sub seque...

Yes. I type password in parameter. And I sure that password is correct. Sorry... haw I can hardcore the values? Try to Hardcore the value means, instead of paasing the value as parameter inside the DB2 EE stage, use the Hardocre value. For Ex : If you are passing password as '#DB2_PASSWORD#' in pla...

No I am resetting the aborted jobs and then starting but it's starting from first sequence onwords but i want to start where ever it's failed Ex: If 1 sequence had total 6 subsequences but 4,5 subsequences are failed So,while restarting I need to excutre that 4&5 only How can i do that Thanks i...

m903782 wrote:is there any way to reach the name of the file when you work on it in datastage

Hi,

First clarify your requirement. Other wise, here so many assumptions are going on.

You mean you want to pass the file name as parameter ? ( One more assumption )

Hi Nagesh, That is fine to enable that "add check points is ok" But If i want to excute only failed sequences while restarting for that how can i maintain, and how can i start only that sequence in failed cases Thanks in advance Hi, What happening, if you start the Main sequence, after fa...

You can parameterize Servername,Schemaname,username and password and I don't think so database name is required in the parameterisation.

We have jobs with all parameters other than table name.

What is the problem with the below approach :

Sequential File .............. Transformer............. SQL server

Did you face any problems with it ?

As Bird said, Sequential file will allow either input or output and a reject link.

Just Try out by null handling with the nullable YES input fields.

Source : Nullable YES
If Isnull(ColumnA)
then ' ' or 0 (depends on your requirement, usually for sting Spaces and for numeric 0)
Else
ColumnA.

Target : Nullable ( Yes/No)

Hi, I think, these are all because of resource allocation to the jobs for monitoring the data. We have environmental variables called APT_MONITOR_SIZE and APT_MONITOR_TIME. These variables will lead the monitoring functionality in Data Stage. overridden the default setting with values, set APT_MONIT...

Hi Praveen, In which stage you are performing this converison either Transformer or Modify stage. Use the Proper syntax for that in the above stages. If you are perfoming this in any satge without any conversion, then it will throw error to you. In Tarnsformer : TimestampToString Return the string r...