DSXchange

ray.wurlod, chulett As you both have been suggesting perfman to create an Environment varibale which he pointed out, I now have an unstablity in understanding the Environment variable. How the manual creation of an undefined-but-documented Environment variable(starts with APT, for parallel Extender)...

Author(perfman), Regarding your problem, there can be for now two solutions with the touch of flexibility by one hand. 1. If the format of the Input data is flexible to be changed as having blankspace, the above mentioned method can help you. 2. If the format of the Input data is NOT flexible to be ...

OK, try setting the Null Field Value property to "". This will NOT work as was. the reason is as given below. Here, the datatype of nullable field is "TimeStamp" which has indeed fixed width length of 19 characters by default . If this type of field does have null values, Null r...

have a search for the dsadmin command, that might help

The command dsadmin is NOT used for Project Export and Import purpose instead for Creating/Deleting a Project and Creating/Deleting Environment variable and many more.

Search on uvbackup and uvrestore can resolve your issue.

yuva010 wrote:Thanks for answering, few more questions -
Does it capture whole source row or only some referrence?
Does it capable of giving the reason of rejection?

1. Reject from only Source(if it is in Transformer Stage)

2. No. Reason for rejection should be user-described.

if they are being rejected from a Transformer stage you can click on the 'constraints' button (top left) and set up a reject link The constraints to a particular link will NOT result setting up a Reject Link to a Trasformer Stage. You might come to say that clicking on the Otherwise/Log in the Cons...

When you create any New Parallel Stage for generic or specific purpose, you may better have a practice of exporting Job Design along with the user-defined New Parallel Stage(s) which is(are) used directly or indirectly(--> Container) inside the Job Design, to another Project.

Hi, Use a Constraint IsNotNull(Column_name), and apply Null handling function NullToValue() for the columns which are getting dropped and you will be able to retrieve the records in reject link If the Stream Output Link of a Transformer Stage is converted to Reject Link using "Convert to Rejec...

ray.wurlod, If writes were not buffered your theory would be OK but this is not the case. If writes were NOT buffered, how dspxlearn's theory("if the 'Link Execution order" option on the transformer executes on the order we give") would be OK? I can remind myself to note the phrase fr...

Can I do it without using a routine? Yes. But instead, an insertion of Execute Command Activity in the Job Sequence to run a Shellscript(your OS) which checks whether the Sequential file is empty. If the Sequential file is not empty, Job Sequence continues to call the main Load Job. In this suggest...

Hi, my friends.... I'm looking a way to know each job modification date (server or sequencer). If I compile the job today, I can see that the Date/Time modified (within Manager) is set to today date. Is there a way to get the real job update date and time ? What you need exactly? Job Modification T...

Hi, my friends.... I'm looking a way to know each job modification date (server or sequencer). If I compile the job today, I can see that the Date/Time modified (within Manager) is set to today date. Is there a way to get the real job update date and time ? What you need exactly? Job Modification T...

The check boxes Custom Server Routines and Custom Parallel Stage Types are not available in DataStage v7.5x2. Help pages do not ensure availability of such options in the wizard.

They are available in DataStage v7.5.1.

There's a checkbox on the first page of the Wizard to 'Compile Custom Server Routines' but you don't seem to need to enable it There is no such checkbox in the wizard in the DataStage i use(v7.5x2). I see only checkboxes - Server, Parallel, Mainframe, Sequence, Only select uncompiled Jobs, Show Job...

chulett, The Multiple Job Compiler will compile routines. Can you please elaborate it saying how we can achieve this because i dont find any documentation on how to compile Routine as well by Multiple Job Compiler nor the proper search results from DSXchange. Frankly saying i can not make Multiple J...