cjc 发表于 2013-1-13 18:56:49

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 mytab
http://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]
查看完整版本: DB2的函数(实现按位与或)