DSXchange

Could anybody help me to resolve my issue.To understand the restartability I only aborted the seuqence

@ray.wurlod At the Job sequence level I enabled all the four properties.To understand the property Add check points so sequence is restartable on failure,I replaced some Dummy file dummy.txt in Job2 during first run.So sequence got aborted .During second run I replaced dummy.txt with target1.txt but...

Thanks ray for your Input. I have to recompile the sequence after running the sequence first time because when I ran the sequence first time sequence is aborted.I am getting below warning when I ran the sequence second time The Job is not in runnable state it may neds to be re-compiled.It's current ...

1) Go TO Datastage Project location
2)cd ParameterSets

Here u can see all the parameter sets that are present in a project.Use proper unix command in this directory to get required Parameter Set

Hi, I designed the Job sequence as below Job1-->Job2-->Job3 Job1 loads the data from file.txt to target file target1.txt Job2 loads the data from target1.txt file to target file target2.txt Job3 loads the data from target2.txt file to target file target3.txt Add Checkpoints so sequence is restartabl...

I think dssearch command will work for u

1)Identify the distinct Key values after validation and write the result into a textfile 2)Use execute command stage to convert the result obtained in first step into some pipe or comma delimiter output 3)use Loop activity stage for each distinct value of the key and use proper constraint to filter ...

Use the JOb

JOB1 -------> JOB2

and mention the trigger condition as below

Job1 is finished with no warnings or Job1 is unsucccesful(aborted) or Job1 is finished with warnings


Please correct me if i am wrong

ray.wurlod wrote:

Code: Select all

SELECT NAME FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL "@RECORD" LIKE '%.sh%');

...

Could You please clarify what is meant by EVAL and @RECORD in the above query?

I am using one Parameter Set for all the Jobs[Around 250 parallel Jobs and sequences] in entire project.Due to some reasons we changed values for two parameters in the parameter set which should be reflected for all the Jobs in entire Project.Is there any easy procedure instead of changing manually ...

I checked in log It is showing ******.Could you please mention where exactly in the Log?

How to identify Encrypted Password in dsx file?I mean where to get LD8@1HV@N this information?

1)Could anybody explain how dates are generated in Row Generator Stage with the following Settings for a particular column?

Type=random
Limit=2000

I gone through the help manual but not able be get it.

1)I Just started learning Fasttrack.By using Fasttrack we can can generate Datastage Jobs.Is it possible to implement any complex scenario that implemented in Datastage also possible to implement in Fasttrack because it saves time?

2)Any link for the examples?

@ray.wurlod

We are using DSJobReport in after job routine to get Job Report Details.
How can we use both DSJobReport and ExecSH for a single Job. Please correct me if I am wrong?