how to use DB2 function in stage

[yimwai]

Can I use DB2 function to transform a column in Transformer stage?

[MT]

Can I use DB2 function to transform a column in Transformer stage?

Hi,

no DB2 functions are SQL and the Transformer uses C-Code (or Basic if it is a Basic--Transformer).

Use your DB2 stage for SQL stuff or a stored procedure (separate stage)...

If you describe a little more what your problem is you will get better (more detailed) help though

kind regards
Michael

[manoj_23sakthi]

Hi,

no DB2 functions are SQL and the Transformer uses C-Code (or Basic if it is a Basic--Transformer).

U can use stored procedure or u hve to write routine to obtain this

Regards
Manoj

[MT]

Hi,

no DB2 functions are SQL and the Transformer uses C-Code (or Basic if it is a Basic--Transformer).

U can use stored procedure or u hve to write routine to obtain this

Regards
Manoj

Hi manoj_23sakthi

copying my answer is without quoting is NOT the way it works!
Write your own stuff or mark it as quote!

Michael

[ray.wurlod]

You can use DB2 functions in DataStage in the same way you use it in any other client - within a SELECT statement. This implies that the stage type is a DB2 or ODBC stage of some kind.

[DSguru2B]

What function are you interested in. Maybe we can help you achieve that without the use of db2 functions.

[chulett]

Sounds more like DDL than DML.