5.6 機能を組み合わせた例

Interstage Data Effector ユーザーズガイド

目次索引

5.6 機能を組み合わせた例

Data Effectorの4機能を組み合わせた業務例を以下に示します。1つ目のコマンドの結果を標準出力に出力し、その出力を2つ目のコマンドの入力とすることで、複数のコマンドの処理を一連の処理として実行できます。以下に2つの例を用いて説明します。

例で使用するデータは以下になります。

◆従業員データ

"ENO","NAME","DEPARTMENT","POSITION","AREA","BLDG"

"070","田中","総務","課員","大阪","竹ビル"

"031","鈴木","総務","課員","大阪","竹ビル"

"003","高橋","総務","課長","東京","松ビル"

"009","渡辺","営業","課長","大阪","竹ビル"

"120","伊藤","総務","課長","大阪","竹ビル"

"055","山本","総務","課員","大阪","竹ビル"

"135","中村","営業","課長","東京","松ビル"

"095","小林","営業","課員","東京","松ビル"

"094","斎藤","営業","課員","東京","松ビル"

"085","加藤","営業","課員","大阪","竹ビル"

"033","佐藤","営業","課員","福岡","梅ビル"

"032","吉田","営業","課員","福岡","梅ビル"

◆従業員データ

<EMPLOYEE><ENO>070</ENO><NAME>田中</NAME><DEPARTMENT>総務</DEPARTMENT><POSITION>課員</POSITION><AREA>大阪</AREA><BLDG>竹ビル</BLDG></EMPLOYEE>

<EMPLOYEE><ENO>031</ENO><NAME>鈴木</NAME><DEPARTMENT>総務</DEPARTMENT><POSITION>課員</POSITION><AREA>大阪</AREA><BLDG>竹ビル</BLDG></EMPLOYEE>

<EMPLOYEE><ENO>003</ENO><NAME>高橋</NAME><DEPARTMENT>総務</DEPARTMENT><POSITION>課長</POSITION><AREA>東京</AREA><BLDG>松ビル</BLDG></EMPLOYEE>

<EMPLOYEE><ENO>009</ENO><NAME>渡辺</NAME><DEPARTMENT>営業</DEPARTMENT><POSITION>課長</POSITION><AREA>大阪</AREA><BLDG>竹ビル</BLDG></EMPLOYEE>

<EMPLOYEE><ENO>120</ENO><NAME>伊藤</NAME><DEPARTMENT>総務</DEPARTMENT><POSITION>課長</POSITION><AREA>大阪</AREA><BLDG>竹ビル</BLDG></EMPLOYEE>

<EMPLOYEE><ENO>055</ENO><NAME>山本</NAME><DEPARTMENT>総務</DEPARTMENT><POSITION>課員</POSITION><AREA>大阪</AREA><BLDG>竹ビル</BLDG></EMPLOYEE>

<EMPLOYEE><ENO>135</ENO><NAME>中村</NAME><DEPARTMENT>営業</DEPARTMENT><POSITION>課長</POSITION><AREA>東京</AREA><BLDG>松ビル</BLDG></EMPLOYEE>

<EMPLOYEE><ENO>095</ENO><NAME>小林</NAME><DEPARTMENT>営業</DEPARTMENT><POSITION>課員</POSITION><AREA>東京</AREA><BLDG>松ビル</BLDG></EMPLOYEE>

<EMPLOYEE><ENO>094</ENO><NAME>斎藤</NAME><DEPARTMENT>営業</DEPARTMENT><POSITION>課員</POSITION><AREA>東京</AREA><BLDG>松ビル</BLDG></EMPLOYEE>

<EMPLOYEE><ENO>085</ENO><NAME>加藤</NAME><DEPARTMENT>営業</DEPARTMENT><POSITION>課員</POSITION><AREA>大阪</AREA><BLDG>竹ビル</BLDG></EMPLOYEE>

<EMPLOYEE><ENO>033</ENO><NAME>佐藤</NAME><DEPARTMENT>営業</DEPARTMENT><POSITION>課員</POSITION><AREA>福岡</AREA><BLDG>梅ビル</BLDG></EMPLOYEE>

<EMPLOYEE><ENO>032</ENO><NAME>吉田</NAME><DEPARTMENT>営業</DEPARTMENT><POSITION>課員</POSITION><AREA>福岡</AREA><BLDG>梅ビル</BLDG></EMPLOYEE>

◆事務所データ

"LOCALE","BLDG","NEWBLDG","PHONE","CODE","ADDRESS"

"東京","松ビル","","7100","00001","東京都品川区東五反田"

"大阪","竹ビル","亀ビル","7200","00002","大阪府大阪市北区梅田"

"福岡","梅ビル","","7300","00008","福岡県福岡市博多区中州"

◆事務所データ

<INFO><LOCALE>東京</LOCALE><BLDG></BLDG><NEWBLDG></NEWBLDG><PHONE>7100</PHONE><CODE>00001</CODE><ADDRESS>東京都港区高輪</ADDRESS></INFO>

<INFO><LOCALE>大阪</LOCALE><BLDG>竹ビル</BLDG><NEWBLDG>亀ビル</NEWBLDG><PHONE>7200</PHONE><CODE>00002</CODE><ADDRESS>大阪府大阪市北区梅田</ADDRESS></INFO>

<INFO><LOCALE>福岡</LOCALE><BLDG>梅ビル</BLDG><NEWBLDG></NEWBLDG><PHONE>7300</PHONE><CODE>00008</CODE><ADDRESS>福岡県福岡市博多区博多駅</ADDRESS></INFO>

5.6.1 抽出、連結および集計のコマンド組合せ例
5.6.2 抽出およびソートのコマンド組合せ例

目次索引