DSXchange

One possiblity to cause this issue is that the key columns having NULL value so check the key column values.

HTWH.

Regards
Saravanan

Build the unix command 'rm ': <pathname>:FileName. Execute this to delete this file and use DSExecute to execute this command. Build this command as 'touch ':<pathname>:FileName to create this file. Use DSExecute to create this file. Check for output and return code to ensure that the file deletion ...

Check whether the file exists, delete the file if it exists. And recreate the file. Delete and creation of the file use OS command if the file is required to be sequential/ascii text file.

HTWH.

Regards
Saravanan

Clear the file in the job control and writing the records into all files with append option.

HTWH.

Regards
Saravanan

What is the source? Is it any DB or Sequential file?

If it is seq file, you can use OpenSeq/ReadSeq/WriteSeq to write the amount into a seq file. If it is DB, write the amount info into a file and do the beforesaid steps.

HTWH.

Regards
Saravanan

Why do you want to perform this tasks in a batch script as all tasks can be performed using Job Sequencer.

Regards
Saravanan

Yes. the file size can be increased to unlimited if the admin agrees.

Regards
Saravanan

Basic transformer can be used DS EE.

Regards
Saravanan

Kumar, Even you use Fileset, Dataset, Seq file stages, the files are created based on the ulimit settings for that user. Login to unix using the user name, which used to run the job and execute the command as suggessted by Arnd and that would tell you the size limit for the particular user id that w...

We are using DS 7.5 and OCI 9i stage and array size is being mentioned as 500. We used to get the number ORA error messages and the number of problematic records matched while running the jobs.

HTWH.

Regards
Saravanan

Yes. It is.

If you are using Parallel transformer, most of the functions cannot be used. In order to call those functions, the BASIC transformer is to be used.

Regards
Saravanan

The default value can be specified if the column has null value and this property is available in Seq file stage. And you need to transform back to NULL while writing into a DataSet.

HTWH.

Regards
Saravanan

This OConv/IConv functions available when you use Basic transformer not for Parallel transformer. Pls keep in mind that when you use transformer to achieve this.

Regards
Saravanan

Understand from his post he wants to exclude Saturday and Sunday while adding no of days to a date. If that is the case, you should check if the date falls on on these two days when you add no of days to the date.

Regards
Saravanan

As suggessted by Vincent, sort & partition could cause this issue. Pls look at the generated OSH code to identify the sort and partition that are used in the aggregator and join stage. And use the right partition and sort the data that will help you in resolving the issue.

Regards
Saravanan