Interstage Data Effector ユーザーズガイド

F.4 データのソート

入力データを指定した項目でソートし、結果をファイルに出力します。

■ドキュメントサンプル

入力データファイル (in.csv)

"Rcode","Rname","Scode","Sname","Sales","Location","Size"

"001","東京","1002","渋谷店","3000","繁華街","150"

"004","神奈川","4001","川崎店","5000","駅ビル","120"

"002","千葉","2002","浦安店","2000","駅ビル","137"

"002","千葉","2001","船橋店","1500","モール","215"

"001","東京","1006","品川店","5000","駅中","90"

"003","埼玉","3001","大宮店","3000","専門店","200"

"001","東京","1004","新宿店","9000","百貨店","120"

"004","神奈川","4002","横浜店","8000","繁華街","170"

"001","東京","1001","東京店","12000","駅中","100"

"003","埼玉","3002","浦和店","2000","専門店","95"

"002","千葉","2003","千葉店","6000","専門店","250"

■ソート条件

Rcodeについて昇順に並び替え、Rcodeが同じレコードについてはSalseで降順で並び替えて、各レコードのRcode、Rname、Sales、Snameを取り出します。

■APIの使用例

以下にAPIを使用したプログラミング例を示します。

#include <stdio.h>

#include "libAsis.h"



/* ソート機能 サンプルプログラム */

int main()

{

  /* ハンドル変数群 */

  ASISHANDLE handle;



  /* 作業用変数群 */

  int status;



  /* 入力パラメタ群 */

  char *logFile;

  char *envName;

  char *envValue;

  char *WorkFolder;

  int MemorySize;

  char *CharacterCode;

  char *inFileType;

  char *inFile;

  char *outFile;

  char *Ocondition;

  char *Rcondition;



  /* エラー用変数群 */

  int errorLevel;

  const char *Message;



  /* 変数の初期化 */

  handle = NULL;



  /* ソートハンドルの割当て */

  logFile = "C:\\shunAsis\\sample\\Sort.log";

  status = AsisAllocHandleSort( &handle, logFile );

  if ( status != ASIS_SUCCESS ) {

    goto ErrorEnd;

  }



  /* 数値演算式における空の扱いを指定 */

  envName = ASIS_ENV_SubstituteZeroForEmpty;

  envValue = "NO";

  status = AsisSetEnvironment( handle, envName, envValue );

  if ( status != ASIS_SUCCESS ) {

    goto ErrorEnd;

  }





  /* ソート機能の実行環境の設定 */

  WorkFolder = "C:\\shunAsis\\sample\\tmp";

  MemorySize = 500;

  status = AsisSetEnvSort( handle, WorkFolder, MemorySize,

                           NULL, NULL );

  if ( status != ASIS_SUCCESS ) {

    goto ErrorEnd;

  }



  /* ソートの実行 */

  CharacterCode = "SHIFT-JIS";

  inFileType = "CSV";

  inFile = "C:\\shunAsis\\sample\\in.csv";

  outFile = "C:\\shunAsis\\sample\\out.csv";

  Ocondition = "$Rcode, val($Sales) DESC";

  Rcondition = "$Rcode, $Rname, $Sales, $Sname";

  status = AsisExecuteSort( handle, CharacterCode, inFileType,

                            inFile, outFile, Ocondition,

                            Rcondition, NULL, NULL );

  if ( status != ASIS_SUCCESS ) {

    goto ErrorEnd;

  }



  /* ソートハンドルの解放 */

  status = AsisFreeHandleSort( handle );

  if ( status != ASIS_SUCCESS ) {

    goto ErrorEnd;

  }



  return 0;





ErrorEnd:    /* エラーが発生した際のエラー処理 */



  /* エラー情報の取得 */

  status = AsisGetErrorLevel( handle, &errorLevel );

  if ( status == ASIS_SUCCESS ) {

    switch( errorLevel ) {

    case ASIS_EL_WARNING:

        printf( "エラーレベル    : 警告\n");

        break;

    case ASIS_EL_ERR_DATA:

        printf( "エラーレベル    : データのエラー\n");

        break;

    case ASIS_EL_ERR_PARAMETER:

        printf( "エラーレベル    : パラメタのエラーまたは使用方法のエラー\n");

        break;

    case ASIS_EL_ERR_ENVIRONMENT:

        printf( "エラーレベル    : 実行環境のエラー\n");

        break;

    default:

        printf( "エラーレベル取得エラー\n");

        break;

    }

  }

  else {

    printf( "エラーレベル取得エラー : %d\n", status );

  }



  status = AsisGetMessageText( handle, &Message );

  if ( status == ASIS_SUCCESS ) {

    printf( "メッセージ : %s\n", Message );

  }

  else {

    printf( "メッセージ取得エラー : %d\n", status );

  }



  /* ソートハンドルの解放 */

  if ( handle != NULL ) {

    status = AsisFreeHandleSort( handle );

    if ( status != ASIS_SUCCESS ) {

      printf( "ハンドル解放エラー : %d\n", status );

    }

  }



  return 1;

}

■実行結果 (out.csv)

"Rcode","Rname","Sales","Sname"

"001","東京","12000","東京店"

"001","東京","9000","新宿店"

"001","東京","5000","品川店"

"001","東京","3000","渋谷店"

"002","千葉","6000","千葉店"

"002","千葉","2000","浦安店"

"002","千葉","1500","船橋店"

"003","埼玉","3000","大宮店"

"003","埼玉","2000","浦和店"

"004","神奈川","8000","横浜店"

"004","神奈川","5000","川崎店