"James Hong" <jhcgonebox.com> wrote in message
news:3f690d27$1_2news.tm.net.my...UDF> Dear All,
> I porting my MS SQL stucture and those UDF to db2 v8.1.
> I using the IBM Migation tools to do it, all the stucture are migrate
> (changing the script a bit on data type), but i fail to move some of theUsually the best way to get a response on the this forum is to exactly> because those UDF using the MS SQL system function that not exist in db2.
> Do any one know any URL can i find those mapping on system function?
> My program and UDF use a lot the MS SQL function STR(Int, MaxLan,
> Do any one know how to script this function in DB2.
> Note : Maxlan and DecimalDigit are optional parameter.
> Best Regards,
> James Hong
explain how the MS SQL function works and then ask if there is a similar
function in DB2. In this way, those who don't know about MS SQL Server
functions can help you.
Also, you should check out the manuals (can be downloaded from the IBM
You might also check out this porting guide, but don't know if it answers
this specific question: