DSXchange

Obiwon666 wrote:I do some test to do conversion only if col_2 is not null but i still have this warning.

Show us.

A derivation is a derivation, it won't matter where it is when it comes to how long it takes to be evaluted. As noted, one typically uses a stage variable to do something once and allow it to be reused in multiple places, be it other stage variables or in a column's derivation. That can even be some...

Please use meaningful subject lines in the future, something related to the question or issue - everything here is "DataStage" related in one way or another.

Kryt0n wrote:For a start, 0000-00-00 00:00:00 is not a valid timestamp so that may be the cause

This.

Your subject is a little misleading.

pandeesh wrote:I just want to know how ceil() is implemented in datastage.

You could always start by reading the documentation.

If you get the correct answer for values > 12 and the only issue is the zero you get for any number less than 12, seems to me you could simply translate the 0 to a 1 post function call. Or is there more to it than that?

It is failing after two hours with the indicated error or right away? Have you taken the issue to your DBA or SysAdmin to see if they can help?

Why would you think you could insert 'sample data' that is > 4000 into a field with a precision of 4000? :? Of course, you could trucate the string to 4000 and load it. You may also run into an issue with BYTE semantics - your target column may hold 4000 bytes which does not always equal 4000 charac...

Do all of these target tables have identical metadata?

Please explain for us what "considering the columns" means. If by that you mean that it doesn't respect the "First record is column names" setting for any but the first file, that's a known limitation when reading multiple files using any of the available mechanisms. Unless they'...

If you insist on using a SQL file, you would need to translate the parameter and build the file with the actual value in it. Each time.

Split into your own post.

Please don't "me too" on the end of older posts, always start your own and then (if it seems like it would help) link to the older post.

The included MKS Toolkit would allow the use of UNIX commands.

I'd still recommend waiting for the OP to come back and clarify their needs before people keep playing this endless guessing game.

No clue but it comes up when searched for with DB2 and JDBC 4.0 support. Best to ask your official support provider.