Prev: XML output
Next: XMLGROUP cost too high
From: Serge Rielau on 28 May 2010 17:34
For those of you busily enabling those Oracle applications to DB2 things
are getting (even) easier:
1. DBMS_DDL.WRAP() and DBMS_DDL.CREATE_WRAPPED()
Provide obfuscation for your PL/SQL (and SQL PL) procedures,
functions, triggers, ..
2. NCHAR, NVARCHAR2, NCLOB support with related functions
(e.g. TO_NCHAR)
3. DEFAULT parameters for functions
CREATE FUNCTION FOO(arg1 INT DEFAULT 7) ...
4. Named parameter invocation for functions
SELECT FOO(arg=>7) FROM DUAL
5. BULK COLLECT got faster
6. Various CLPPlus enhancements
....

All features (except BULK COLLECT) are of course available to "regular"
DB2 as well.

Enjoy
Serge
--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

From: Troels Arvin on 29 May 2010 04:13
About the "Databases can be restored using transportable sets" news:
Are transportable sets architecture-independent, so that they can be used
to transport a database from - e.g. - AIX64 to Linux x86_64?

--
Troels
From: Serge Rielau on 29 May 2010 08:28
On 5/29/2010 4:13 AM, Troels Arvin wrote:
> About the "Databases can be restored using transportable sets" news:
> Are transportable sets architecture-independent, so that they can be used
> to transport a database from - e.g. - AIX64 to Linux x86_64?
>
I do not think so. In the end the technology is based on restore. So the
same rules apply.

Cheers
Serge


--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

From: Frederik Engelen on 29 May 2010 09:17
On 29 mei, 14:28, Serge Rielau <srie...(a)ca.ibm.com> wrote:
> On 5/29/2010 4:13 AM, Troels Arvin wrote:> About the "Databases can be restored using transportable sets" news:
> > Are transportable sets architecture-independent, so that they can be used
> > to transport a database from - e.g. - AIX64 to Linux x86_64?
>
> I do not think so. In the end the technology is based on restore. So the
> same rules apply.
>
> Cheers
> Serge
>
> --
> Serge Rielau
> SQL Architect DB2 for LUW
> IBM Toronto Lab

I assume it has the same limitations as a tablespace restore with
regards to HADR (ie. not possible). Am I correct?

Kind regards,

Frederik
From: Serge Rielau on 29 May 2010 09:28
On 5/29/2010 9:17 AM, Frederik Engelen wrote:
> On 29 mei, 14:28, Serge Rielau<srie...(a)ca.ibm.com> wrote:
>> On 5/29/2010 4:13 AM, Troels Arvin wrote:> About the "Databases can be restored using transportable sets" news:
>>> Are transportable sets architecture-independent, so that they can be used
>>> to transport a database from - e.g. - AIX64 to Linux x86_64?
>>
>> I do not think so. In the end the technology is based on restore. So the
>> same rules apply.
> I assume it has the same limitations as a tablespace restore with
> regards to HADR (ie. not possible). Am I correct?
That I do not know....

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

 | 
Pages: 1
Prev: XML output
Next: XMLGROUP cost too high