dbTalk Databases Forums  

Is there %TYPE equivalent?

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss Is there %TYPE equivalent? in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Vladimir Cholak
 
Posts: n/a

Default Is there %TYPE equivalent? - 08-12-2003 , 07:32 AM






Hi,
I'm dealing with migrating Oracle PL/SQL procedures to DB2 UDB 8.1.
Oracle uses %TYPE attribute to dynamically get column type.
Is there a db2 equivalent for that or I should spesify concrete type?

Reply With Quote
  #2  
Old   
Serge Rielau
 
Posts: n/a

Default Re: Is there %TYPE equivalent? - 08-14-2003 , 10:18 AM






Hi Vladimir,

DB2 supports user defined distinct type (akak TYPEDEF) which is a somewhat
different paradigm.
%TYPE as you know it is not supported.

Cheers
Serge



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.