DSXchange

Need to make the small changes in the properties of the CFF, while selecting the type, as IBM370 instead of IEEE standard.

Then, we will achieve, what we need.

We cannot perform this operation in the CFF Stage, instead of this make use of the sequential stage, write as a mainframe cobol format, in the properties tab, wherever, we need the low values, need to pass Setnull () from the transformer, before this Seq stage and then, pass the default null field v...

Also, try clearing the status of the job, thru DS Director.. then, re run the job.

Sometimes, this may happen due to the space overflow in the ramdisk, if you have mentioned it the config file.

To avoid inserting the Tsort operator, you can add explicit sorter stage, before the Join stage.

Just specify, the constraints as H, D, T in the constraints tab of the CFF stage. However, you can see the other records except H,D,T in the reject file connected.

Hi,

Do we have any Orchadmin Utilities to search the data from the dataset thru UNIX ?

As suggested by Craig, list out the warnings occurred during the execution.. So, that it can be easier to resolve the issue.
Also, you can validate all the Stage Variables, Constraints and Derivations of all the 5 Transformers, usually, you may find the issues over there it self.

Facing issue, to handle the COMP-2 Float value in the CFF stage for couple of fields. Please, find the below sample value: The value of the field in the Mainframe is 411A19ED7C6FBD27 and usage in the copy book is COMP-2, and in the COBOL Layout observed in CFF stage of datastage is PIC S9(14) V9(4) ...

I guess, Datastage will try to read the files from the Unix server itself. Hence, 201107* should work. Pls try and let me know if the issue persists.

Try using Source - \\ladiappd01\etl_src_files\EDW\Work_Folder\201107* and make sure that the property is set to comma as a delimiter.

Facing issue, to handle the COMP-2 Float value in the CFF stage for couple of fields. Please, find the below sample value: The value of the field in the Mainframe is 411A19ED7C6FBD27 and usage in the copy book is COMP-2, and in the COBOL Layout observed in CFF stage of datastage is PIC S9(14) V9(4) ...

This might be because of two below issues:
1) The sequential file may be empty.
2) The metadata mismatch.

Create a copy of the same job in the designer and compile it. I guess, you would be able to see the job in the director too.

Hi Srini,

This warning is because of the same columns (except key columns) in both of the inputs of the joiner. So, remove the column ACCT_SAG_ID from one of the input.