011——PDM生成sql脚本添加注释的问题解决

PDM里面的物理表 在导 sql 出来的时候（db2数据库），添加列注释：

步骤：
将下面的脚本拷贝
PowerDesigner->Tools->Execute Commands->Edit/Run Scripts，然后RUN，再导出就有注释了

Script代码：

Option   Explicit   
ValidationMode   =   True   
InteractiveMode   =    im_Batch   
  
Dim    mdl   '    the    current    model   
  
'    get    the    current    active    model   
Set    mdl   =    ActiveModel   
If    (mdl   Is   Nothing)   Then   
      MsgBox   "There    is    no    current    Model "   
ElseIf   Not    mdl.IsKindOf(PdPDM.cls_Model)   Then   
      MsgBox   "The    current    model    is    not    an    Physical    Data    model. "   
Else   
       ProcessFolder    mdl   
End   If   
  
'    This    routine    copy    name    into    comment    for    each    table,    each    column    and    each    view   
'    of    the    current    folder   
Private   sub    ProcessFolder(folder)   
      Dim    Tab   'running      table   
      for   each    Tab    in    folder.tables   
            if   not    tab.isShortcut   then   
                   tab.comment   =    tab.name   
                  Dim    col   '    running    column   
                  for   each    col    in    tab.columns   
                         col.comment=    col.name   
                  next   
            end   if   
      next   
  
      Dim    view   'running    view   
      for   each    view    in    folder.Views   
            if   not    view.isShortcut   then   
                   view.comment   =    view.name   
            end   if   
      next   
  
      '    go    into    the    sub-packages   
      Dim    f   '    running    folder   
      For   Each    f    In    folder.Packages   
            if   not    f.IsShortcut   then   
                   ProcessFolder    f   
            end   if   
      Next   
end   sub

再在保存 script 的时候选择把comment加上就可以了