Help need to porting from MS SQL to DB2 8.1

[James Hong]

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
success
(changing the script a bit on data type), but i fail to move some of the UDF
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,
DecimalDigit)
Do any one know how to script this function in DB2.

Note : Maxlan and DecimalDigit are optional parameter.
--
Best Regards,
James Hong

[Mark A]

"James Hong" <jhcg@onebox.com> wrote in message
news:3f690d27$1_2@news.tm.net.my...

> 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
> success
> (changing the script a bit on data type), but i fail to move some of the

UDF

> 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,
> DecimalDigit)
> Do any one know how to script this function in DB2.
>
> Note : Maxlan and DecimalDigit are optional parameter.
> --
> Best Regards,
> James Hong
>

Usually the best way to get a response on the this forum is to exactly
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
site).

You might also check out this porting guide, but don't know if it answers
this specific question:
[url]http://www7b.boulder.ibm.com/dmdd/library/techarticle/0203rada/0203rada.html[/url]

[Mark Yudkin]

The equivalent to the MS SQL STR function in DB2 is the CHAR function;
however, DB2 doesn't support the MaxLen (not maxlan) parameter. You can
achieve the same effect by wrapping the call to CHAR in a call to INSERT.

"James Hong" <jhcg@onebox.com> wrote in message
news:3f690d27$1_2@news.tm.net.my...

> 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
> success
> (changing the script a bit on data type), but i fail to move some of the

UDF

> 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,
> DecimalDigit)
> Do any one know how to script this function in DB2.
>
> Note : Maxlan and DecimalDigit are optional parameter.
> --
> Best Regards,
> James Hong
>
>

[Blair Adamache]

Have a look at:
[url]http://www7b.boulder.ibm.com/dmdd/library/techarticle/0303rada/0303rada.html[/url]

Other resources: are here:
[url]https://www6.software.ibm.com/dl/db2_03/migtkt-p[/url]

James Hong wrote:

> 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
> success
> (changing the script a bit on data type), but i fail to move some of the UDF
> 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,
> DecimalDigit)
> Do any one know how to script this function in DB2.
>
> Note : Maxlan and DecimalDigit are optional parameter.

[Blair Adamache]

Other samples:

[url]http://www7b.boulder.ibm.com/dmdd/library/samples/db2/0205udfs/index.html[/url]

Blair Adamache wrote:

> Have a look at:
> [url]http://www7b.boulder.ibm.com/dmdd/library/techarticle/0303rada/0303rada.html[/url]
>
>
> Other resources: are here:
> [url]https://www6.software.ibm.com/dl/db2_03/migtkt-p[/url]
>
> James Hong wrote:
>

>> 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
>> success
>> (changing the script a bit on data type), but i fail to move some of
>> the UDF
>> 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,
>> DecimalDigit)
>> Do any one know how to script this function in DB2.
>>
>> Note : Maxlan and DecimalDigit are optional parameter.

>
>