Page 1 of 1
how to use DB2 function in stage
Posted: Mon Dec 20, 2010 1:54 am
by yimwai
Can I use DB2 function to transform a column in Transformer stage?
Re: how to use DB2 function in stage
Posted: Mon Dec 20, 2010 2:41 am
by MT
yimwai wrote: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
Re: how to use DB2 function in stage
Posted: Mon Dec 20, 2010 3:05 am
by 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
Re: how to use DB2 function in stage
Posted: Mon Dec 20, 2010 4:16 am
by MT
manoj_23sakthi wrote: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
Posted: Mon Dec 20, 2010 4:41 am
by 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.
Posted: Mon Dec 20, 2010 9:01 am
by DSguru2B
What function are you interested in. Maybe we can help you achieve that without the use of db2 functions.
Posted: Tue Dec 21, 2010 1:11 am
by chulett
Sounds more like DDL than DML.
