DSXchange

In this case, the requirement is a parameter or macro.

If you have a routine or function return value, you have to set it in a parameter and passed to the job.

Alternatively you can work around by re-arranging the data outside.

Plagvreugd wrote:but I see no way in using that in the Filename property.

Why can't you use in file name ? apart from the business reasons.

And where is the to_date ?

vijay.barani wrote:Hi
I am getting the error "OCI has fetched truncated data".I do not have info that on which column it is happening.PLease could anybody crack this??

Did you do what was asked from you ?

Avoid duplicate posting without any effort from your side.

If you are not involved in the same job as the initial poster, please start a new thread.

Truncating implies char or varchar. So try removing couple of varchar columns and see when that disappears.

Use the "Process of elimination".

Maybe you need a To_Date rather than %DateTimeIn

What happens if you provide two non-empty values. Something like '123','456' - together.

Initial looks suggest possible memory allocation problem due to malloc.

Try setting that as result[1000] or your maximum string length.

Alternatively you can use another variable at the end to hold the return value and free the result.

Posted same in FAQ also.

You can create the hashed file with a parameter value as its name.

You have to look into the TRANS4 lines 109 to 112 to see what operation is being carried out.

My assumption is that you are doing some arithmetic division in a transformer stage in your job.

Initial looks suggest possible memory allocation problem due to malloc.

Try setting that as result[1000] or your maximum string length.

Alternatively you can use another variable at the end to hold the return value and free the result.

How is the column name provided ?

You can import the column names alone as first line being header.

From your initial response, it appers to be compiler configuration issue.

Can you post you compiler setup.

Include a command stage with and branch depending on the result

Your SQL is performing select on the same table in the inner query from which you are selecting the outer query.

What are you planning to achieve ?

Did you try running in db2 query tool itself ?