Thanks for reply ..
I faced one biggest problem with this nested type is,if i am having type with 90+ col and
this type is coming from front end and we are doing some operation by this type like
(insert into table or selecting etc. )on that time my DB2 server is stopped.
but if we make one standalone function in front end and from there they will call BE package.then it works.
but if we use in our application...
sumitv13
Last Activity: Jan 9 '13, 07:12 AM
Joined: Nov 14 '12
Location: bangalore
-
nested table type
Hello,
In DB2,we can't use nested table type and after discussion we split type into 2 type and now we r using by this way we are getting so many problems.and one by one we are trying to solve.
Why DB2 is not supporting nested type ,,
now i get this site for discussion ..so i am asking my all the problems with respect to DB2
PLEASE HELP ME OUT.......... -
using union with table type
Hello,
i am converting oracle code into DB2 and at one place they are using union with table type
...Code:ORACLE ex:- declare l_out1 pgty_type.tabletype_name; l_out2 pgty_type.tabletype_name; l_out3 pgty_type.tabletype_name; begin select ...bulk collect into l_out1 from table_name ; select ...bulk collect into l_out2 from table_name(same tale) ; l_out3 :=l_out1 multiset
Last edited by zmbd; Nov 14 '12, 01:35 PM. Reason: [Z(Please use the <CODE/> button to format posted code)] -
nls_database_parameters
i need alternative in DB2 pls help me …………………Code:SELECT a.value INTO l_nls_numchr FROM nls_database_parameters a WHERE a.parameter =’NLS_NUMERIC_CHARACTERS’;
Last edited by zmbd; Nov 14 '12, 01:39 PM. Reason: [Z(Please use the <CODE/> button to format posted code)]
No activity results to display
Leave a comment: