DB2的函数(实现按位与或)
<div style="padding-right: 5.4pt; padding-left: 5.4pt; background: #e6e6e6; padding-bottom: 4px; width: 95%; padding-top: 4px;">http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif CREATE TABLE mytabhttp://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif (name varchar(30) not null,
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif age int not null,
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif flag1 smallint NOT NULL,
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif flag2 smallint NOT NULL);
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifselect NAME, AGE, FLAG1, FLAG2
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif from UU.MYTAB;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif --转化为二进制
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifCREATE FUNCTION int_to_binary (N1 Integer)
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifRETURNS varchar(32)
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifLANGUAGE SQL
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifSPECIFIC int2bin
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifBEGIN ATOMIC
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifDECLARE M1, i, len Integer default 0;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifDECLARE temp_str varchar(32) default ' ';
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifDECLARE result_str varchar(32) default ' ';
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif SET M1 = N1;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif WHILE M1 > 0 DO
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif SET temp_str = temp_str || cast(mod(m1,2) as char(1));
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif set m1 = m1/2;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif END WHILE;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif set len = length (temp_str);
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif while i < len do
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif set result_str = result_str || substr(temp_str,len-i,1);
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif set i = i+1;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif end while;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifRETURN result_str;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifEND
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifselect int_to_binary(8) from mytab;
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifdrop function int_to_binary;
页:
[1]