如何实现100%的动态数据管道(二)

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

主要思路解决了,下面开始写详细(以ASE为例,其他各位扩展):

            1.建立中间层表vdt_columns,这个表的属性用于构建管道中的列资料.



            执行类似的代码生成:

            ls_sql="createtablevdt_columns("
            ls_sql+="uid            int            null   ,"
           ls_sql+="upkey           varchar(1)     null   ,"
           ls_sql+="udmid     int       null,"
           ls_sql+="udmname    varchar(30)  null,"
           ls_sql+="unulls          varchar(1)    null   ,"
           ls_sql+="uwidth          int     null   ,"
           ls_sql+="uscale        int        null,"
           ls_sql+="uname        varchar(30)  null,"
           ls_sql+="udefault      varchar(255) null,"  
           ls_sql+="ucheck        varchar(255) null,"    
           ls_sql+="uidentity       int    null"
           ls_sql+=")"
   
           EXECUTEIMMEDIATE:ls_sqlusingSrcSqlca;


        2.构建其他相关的可能用到中间层视图:


           系统对象视图:


            ls_sql='createviewvdt_objects(uid,uuid,uname,utype)as'+&
              'selectid,uid,name,(casetypewhen~'TR~'then~'T~'elsetypeend)fromsysobjects'1<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>