程序博客网 > python数据处理代码

AIX系统下proc*数据采集

来源：互联网 发布：python数据处理代码 编辑：程序博客网 时间：2024/06/09 20:59

分享一篇关于AIX系统下采用proc*实现oracle数据采集的例子，采用的技术主要有shell脚本、C++、proc*以及makefile

首先呢看看c++头文件test.h,要注意的是头文件需要引入类库stdlib.h和sqlca.h

[cpp] view plaincopyprint?
  1. #include <stdio.h> 
  2. #include <stdlib.h> 
  3. #include <sqlca.h> 
  4. #include <string.h> 
  5. #include <stdarg.h> 
  6. #include <strings.h> 
  7. #include <time.h>  
  8.  
  9.  
  10.  
  11. /*系统参数*/ 
  12. #define DEFAULT_PRINT_NUM       10000               /*默认打印行数*/ 
  13. #define DEFAULT_INTERVAL_NUM    10000               /*默认每个输出文件纪录条数*/ 
  14. #define DEFAULT_BUF_SIZE        2000                /*默认缓存纪录数*/ 
  15. #define DEFAULT_OUTPUT_LENGTH   3000                /*默认每条纪录长度--------对速度影响较大*/ 
  16. #define DEFAULT_INI_FILE        "param.conf"        /*默认配置文件*/ 
  17. #define DEFAULT_LOG_FILE        "DATATOFILE.log"    /*默认日志文件*/ 
  18. #define DEFAULT_FILE_NUM        1000                /*默认产生文件数*/ 
  19.  
  20. #define DEFAULT_FILEBUFFER_LEN  1024*1024           /*写文件缓冲大小*/ 
  21. #define MAXLINES 10000  
  22.  
  23. FILE* p_fp,* in_fp; 
  24. char c_tmp[200]; 
  25. char c_str[25]; 
  26. char buf[MAXLINES][25];  
  27. char* ps[3]; 
  28. int k = 0,n = 0; 
  29. char* p; 
  30.  
  31.  
  32. /*方法声明*/ 
  33. void getconf(); 
  34. void initparam(); 
  35. void rearparam(); 
  36. void GetValue(char* c_str,char* c_value, char* c_valuename); 
  37. void PrintParam(); 
  38. int ConnectDB(char * u_username); 
  39. void DisconnectDB(); 
  40. void Query(); 
  41. void setparam(int argc,char* argv[]); 
  42. void PRINTF(char msg[]); 
  43. int GetDateTime(char *sDateTime); 
  44. int c = 0; 
  45.  
  46. /*参数构成体*/ 
  47. struct Param 
  48. { 
  49.     char username[200]; 
  50.     char userpass[200]; 
  51.     char database[200]; 
  52.     char USER_PASSWORD[200]; 
  53.     char FILENAME[200]; 
  54.     char c_SqlStr[3000]; 
  55.     char POSTFIX[200]; 
  56. }param; 
  57.  
  58. char* pd[] = 
  59. { 
  60.     "[USER_NAME]", "[USER_PASSWD]","[DATABASE]", "[USER_PASSWORD],[FILENAME],[SQL]" 
  61. }; 
  62.  
  63.  
  64. /***************参数初始化***********************/ 
  65. void initparam() 
  66. { 
  67.     memset( param.username, 0, sizeof( param.username) ) ; 
  68.     memset( param.userpass, 0, sizeof( param.userpass) ) ; 
  69.     memset( param.database, 0, sizeof( param.database) ) ; 
  70.     memset( param.FILENAME, 0, sizeof( param.FILENAME) ) ; 
  71.      
  72.     } 
  73. /***************参数处理*************************/ 
  74. void setparam(int argc,char* argv[]) 
  75. { 
  76.      
  77.     char c_str[50000]; 
  78.     if ((p_fp = fopen(argv[2], "r")) == NULL) 
  79.         printf("打开配置文件%s失败!\n", argv[2]); 
  80.     else 
  81.     { 
  82.         if (strcmp(argv[1], "-f") == 0) 
  83.         { 
  84.             /*while (1)
  85.                     {
  86.                         if (fgets(c_str, 25, p_fp) == NULL)
  87.                             break;
  88.                         strcpy(buf[n], c_str);
  89.                         p = strstr(buf[n], ":");
  90.                         my_Map.insert(make_pair<string, char*>(pd[k], p));
  91.                         k++;
  92.                         n++;
  93.                         if (n >= MAXLINES)
  94.                         {
  95.                             printf(">%d lines ignored.\n", MAXLINES);
  96.                             break;
  97.                         }
  98.                     }*/ 
  99.         } 
  100.         else if (strcmp(argv[1],"-d") == 0)   //输入参数不同 
  101.         { 
  102.             while (1) 
  103.             { 
  104.                 if (fgets(c_str, sizeof(c_str), p_fp) == NULL) 
  105.                     break; 
  106.                 if (c_str[0] != '[' || strstr(c_str, ":") == NULL) 
  107.                     continue;     
  108.                 if (strstr(c_str, "[USER_NAME]") != NULL) 
  109.                 { 
  110.                     GetValue(c_str, param.username, "[USER_NAME]"); 
  111.                     continue; 
  112.                 } 
  113.  
  114.                 /**DB**/ 
  115.  
  116.                 if (strstr(c_str, "[USER_PASSWD]") != NULL) 
  117.                 { 
  118.                     GetValue(c_str, param.userpass, "[USER_PASSWD]"); 
  119.                     continue; 
  120.                 } 
  121.  
  122.                 if (strstr(c_str, "[DATABASE]") != NULL) 
  123.                 { 
  124.                     GetValue(c_str, param.database, "[DATABASE]") ; 
  125.                     continue; 
  126.                 } 
  127.                 if (strstr(c_str,"[USER_PASSWORD]") != NULL) 
  128.                 { 
  129.                     GetValue(c_str, param.USER_PASSWORD, "[USER_PASSWORD]") ; 
  130.                     continue; 
  131.                 } 
  132.                 if (strstr(c_str, "[FILENAME]") != NULL) 
  133.                 { 
  134.                     GetValue(c_str, param.FILENAME, "[FILENAME]") ; 
  135.                     continue; 
  136.                 } 
  137.                 if (strstr(c_str,"[SQL]") != NULL) 
  138.                 { 
  139.                     GetValue(c_str, param.c_SqlStr, "[SQL]") ; 
  140.                     continue; 
  141.                 } 
  142.                 if (strstr(c_str, "[POSTFIX]") != NULL) 
  143.                 { 
  144.                     GetValue(c_str, param.POSTFIX, "[POSTFIX]") ; 
  145.                     continue; 
  146.                 } 
  147.             } 
  148.         } 
  149.     } 
  150. } 
  151. /**********************输出配置信息**************************/ 
  152. void PrintParam() 
  153. { 
  154.     printf("**********************************参数信息如下：**********************************\n"); 
  155.     printf("[SYS]\n");  
  156.     printf("[USER_NAME]:%s\n", param.username); 
  157.     printf("[USER_PASSWD]:%s\n", param.userpass);  
  158.     printf("[DATABASE]:%s\n", param.database); 
  159.     printf("[USER_PASS_BASE]:%s\n", param.USER_PASSWORD); 
  160.     printf("[FILENAME]:%s\n", param.FILENAME); 
  161.     printf("[POSTFIX]:%s\n", param.POSTFIX); 
  162.     /*printf("[SQL]:%s\n", param.c_SqlStr);*/ 
  163.     printf("*********************************************************************************\n"); 
  164. } 
  165.  
  166. /**********************读取配置文件**************************/ 
  167. void GetValue(char* c_str,char* c_value, char* c_valuename) 
  168. { 
  169.     char* s = NULL; 
  170.  
  171.     if ((s = strchr(c_str,':')) == NULL) 
  172.     { 
  173.         printf("读取参数%s失败！\n", c_valuename); 
  174.         exit(-1); 
  175.     } 
  176.  
  177.     strcpy(c_value, s + 1); 
  178.     if (c_value[strlen(c_value) - 1] =='\n') 
  179.         c_value[strlen(c_value) - 1] = '\0'; 
  180. } 
  181. void PRINTF(char  msg[]) 
  182. { 
  183.      
  184.     printf("%s\n",msg); 
  185. } 
  186.  
  187. int GetDateTime(char *sDateTime) 
  188. { 
  189.     char    achar_date_time[32]; 
  190.     struct tm   * s_tm_time; 
  191.     time_t  timer; 
  192.  
  193.     memset(achar_date_time,0,sizeof(achar_date_time)); 
  194.      
  195.     time(&timer); 
  196.     s_tm_time=(struct tm *)localtime(&timer); 
  197.     strftime(achar_date_time,sizeof(achar_date_time),"%Y-%m-%d %H:%M:%S",s_tm_time); 
  198.      
  199.     strcpy(sDateTime,achar_date_time); 
  200.      
  201.     return strlen(sDateTime); 
  202. } 

然后是test.cpp文件，引入test.h头文件

[cpp] view plaincopyprint?
  1. /* Result Sets Interface */ 
  2. #ifndef SQL_CRSR 
  3. #  define SQL_CRSR 
  4.   struct sql_cursor 
  5.   { 
  6.     unsigned int curocn; 
  7.     void *ptr1; 
  8.     void *ptr2; 
  9.     unsigned int magic; 
  10.   }; 
  11.   typedef struct sql_cursor sql_cursor; 
  12.   typedef struct sql_cursor SQL_CURSOR; 
  13. #endif /* SQL_CRSR */ 
  14.  
  15. /* Thread Safety */ 
  16. typedef void * sql_context; 
  17. typedef void * SQL_CONTEXT; 
  18.  
  19. /* Object support */ 
  20. struct sqltvn 
  21. { 
  22.   unsigned char *tvnvsn;  
  23.   unsigned short tvnvsnl;  
  24.   unsigned char *tvnnm; 
  25.   unsigned short tvnnml;  
  26.   unsigned char *tvnsnm; 
  27.   unsigned short tvnsnml; 
  28. }; 
  29. typedef struct sqltvn sqltvn; 
  30.  
  31. struct sqladts 
  32. { 
  33.   unsigned int adtvsn;  
  34.   unsigned short adtmode;  
  35.   unsigned short adtnum;   
  36.   sqltvn adttvn[1];        
  37. }; 
  38. typedef struct sqladts sqladts; 
  39.  
  40. static struct sqladts sqladt = { 
  41.   1,1,0, 
  42. }; 
  43.  
  44. /* Binding to PL/SQL Records */ 
  45. struct sqltdss 
  46. { 
  47.   unsigned int tdsvsn;  
  48.   unsigned short tdsnum;  
  49.   unsigned char *tdsval[1];  
  50. }; 
  51. typedef struct sqltdss sqltdss; 
  52. static struct sqltdss sqltds = 
  53. { 
  54.   1, 
  55.   0, 
  56. }; 
  57.  
  58. /* File name & Package Name */ 
  59. struct sqlcxp 
  60. { 
  61.   unsigned short fillen; 
  62.            char  filnam[8]; 
  63. }; 
  64. static conststruct sqlcxp sqlfpn = 
  65. { 
  66.     7, 
  67.     "test.pc" 
  68. }; 
  69.  
  70.  
  71. static unsigned int sqlctx = 9995; 
  72.  
  73.  
  74. static struct sqlexd { 
  75.    unsigned long  sqlvsn; 
  76.    unsigned int   arrsiz; 
  77.    unsigned int   iters; 
  78.    unsigned int   offset; 
  79.    unsigned short selerr; 
  80.    unsigned short sqlety; 
  81.    unsigned int   occurs; 
  82.       const short *cud; 
  83.    unsigned char  *sqlest; 
  84.       const char  *stmt; 
  85.    sqladts *sqladtp; 
  86.    sqltdss *sqltdsp; 
  87.    unsigned char  **sqphsv; 
  88.    unsigned long  *sqphsl; 
  89.             int   *sqphss; 
  90.             short **sqpind; 
  91.             int   *sqpins; 
  92.    unsigned long  *sqparm; 
  93.    unsigned long  **sqparc; 
  94.    unsigned short  *sqpadto; 
  95.    unsigned short  *sqptdso; 
  96.    unsigned int   sqlcmax; 
  97.    unsigned int   sqlcmin; 
  98.    unsigned int   sqlcincr; 
  99.    unsigned int   sqlctimeout; 
  100.    unsigned int   sqlcnowait; 
  101.             int   sqfoff; 
  102.    unsigned int   sqcmod; 
  103.    unsigned int   sqfmod; 
  104.    unsigned char  *sqhstv[4]; 
  105.    unsigned long  sqhstl[4]; 
  106.             int   sqhsts[4]; 
  107.             short *sqindv[4]; 
  108.             int   sqinds[4]; 
  109.    unsigned long  sqharm[4]; 
  110.    unsigned long  *sqharc[4]; 
  111.    unsigned short  sqadto[4]; 
  112.    unsigned short  sqtdso[4]; 
  113. } sqlstm = {12,4}; 
  114.  
  115. // Prototypes 
  116. extern "C" { 
  117.   void sqlcxt (void **, unsignedint *, 
  118.                struct sqlexd *, const struct sqlcxp *); 
  119.   void sqlcx2t(void **, unsignedint *, 
  120.                struct sqlexd *, const struct sqlcxp *); 
  121.   void sqlbuft(void **,char *); 
  122.   void sqlgs2t(void **,char *); 
  123.   void sqlorat(void **, unsignedint *, void *); 
  124. } 
  125.  
  126. // Forms Interface 
  127. static constint IAPSUCC = 0; 
  128. static constint IAPFAIL = 1403; 
  129. static constint IAPFTL  = 535; 
  130. extern "C" {void sqliem(char *,int *); } 
  131.  
  132. typedef struct { unsignedshort len; unsigned char arr[1]; } VARCHAR; 
  133. typedef struct { unsignedshort len; unsigned char arr[1]; } varchar; 
  134.  
  135. /* cud (compilation unit data) array */ 
  136. static constshort sqlcud0[] = 
  137. {12,4130,852,0,0, 
  138. 5,0,0,1,0,0,283,21,0,0,4,4,0,1,0,1,9,0,0,1,10,0,0,1,10,0,0,1,10,0,0, 
  139. 36,0,0,2,0,0,288,35,0,0,0,0,0,1,0, 
  140. 51,0,0,3,51,0,260,60,0,0,1,0,0,1,0,2,9,0,0, 
  141. 70,0,0,4,0,0,273,84,0,0,1,1,0,1,0,1,9,0,0, 
  142. 89,0,0,4,0,0,301,90,0,0,0,0,0,1,0, 
  143. 104,0,0,4,0,0,269,95,0,0,1,0,0,1,0,2,9,0,0, 
  144. 123,0,0,4,0,0,271,112,0,0,0,0,0,1,0, 
  145. 138,0,0,5,0,0,286,113,0,0,0,0,0,1,0, 
  146. }; 
  147.  
  148.  
  149.  
  150. #include "test.h" 
  151.  
  152. int main(int argc,char* argv[]) 
  153. { 
  154.     initparam(); 
  155.     setparam(argc, argv); 
  156.     PrintParam(); 
  157.     Query(); 
  158.     return 0; 
  159. } 
  160. int ConnectDB(char* c_UserPasswd) 
  161. { 
  162. /*  EXEC SQL INCLUDE SQLCA;
  163. */  
  164. /*
  165. * $Header: sqlca.h 24-apr-2003.12:50:58 mkandarp Exp $ sqlca.h
  166. */ 
  167.  
  168. /* Copyright (c) 1985, 2003, Oracle Corporation.  All rights reserved.  */ 
  169.   
  170. /*
  171. NAME
  172.   SQLCA : SQL Communications Area.
  173. FUNCTION
  174.   Contains no code. Oracle fills in the SQLCA with status info
  175.   during the execution of a SQL stmt.
  176. NOTES
  177.   **************************************************************
  178.   ***                                                        ***
  179.   *** This file is SOSD.  Porters must change the data types ***
  180.   *** appropriately on their platform.  See notes/pcport.doc ***
  181.   *** for more information.                                  ***
  182.   ***                                                        ***
  183.   **************************************************************
  185.   If the symbol SQLCA_STORAGE_CLASS is defined, then the SQLCA
  186.   will be defined to have this storage class. For example:
  188.     #define SQLCA_STORAGE_CLASS extern
  190.   will define the SQLCA as an extern.
  192.   If the symbol SQLCA_INIT is defined, then the SQLCA will be
  193.   statically initialized. Although this is not necessary in order
  194.   to use the SQLCA, it is a good pgming practice not to have
  195.   unitialized variables. However, some C compilers/OS's don't
  196.   allow automatic variables to be init'd in this manner. Therefore,
  197.   if you are INCLUDE'ing the SQLCA in a place where it would be
  198.   an automatic AND your C compiler/OS doesn't allow this style
  199.   of initialization, then SQLCA_INIT should be left undefined --
  200.   all others can define SQLCA_INIT if they wish.
  202.   If the symbol SQLCA_NONE is defined, then the SQLCA variable will
  203.   not be defined at all.  The symbol SQLCA_NONE should not be defined
  204.   in source modules that have embedded SQL.  However, source modules
  205.   that have no embedded SQL, but need to manipulate a sqlca struct
  206.   passed in as a parameter, can set the SQLCA_NONE symbol to avoid
  207.   creation of an extraneous sqlca variable.
  209. MODIFIED
  210.     lvbcheng   07/31/98 -  long to int
  211.     jbasu      12/12/94 -  Bug 217878: note this is an SOSD file
  212.     losborne   08/11/92 -  No sqlca var if SQLCA_NONE macro set
  213.   Clare      12/06/84 - Ch SQLCA to not be an extern.
  214.   Clare      10/21/85 - Add initialization.
  215.   Bradbury   01/05/86 - Only initialize when SQLCA_INIT set
  216.   Clare      06/12/86 - Add SQLCA_STORAGE_CLASS option.
  217. */ 
  218.   
  219. #ifndef SQLCA 
  220. #define SQLCA 1 
  221.   
  222. struct   sqlca 
  223.          { 
  224.          /* ub1 */ char    sqlcaid[8]; 
  225.          /* b4  */ int     sqlabc; 
  226.          /* b4  */ int     sqlcode; 
  227.          struct 
  228.            { 
  229.            /* ub2 */ unsignedshort sqlerrml; 
  230.            /* ub1 */ char           sqlerrmc[70]; 
  231.            } sqlerrm; 
  232.          /* ub1 */ char    sqlerrp[8]; 
  233.          /* b4  */ int     sqlerrd[6]; 
  234.          /* ub1 */ char    sqlwarn[8]; 
  235.          /* ub1 */ char    sqlext[8]; 
  236.          }; 
  237.  
  238. #ifndef SQLCA_NONE  
  239. #ifdef   SQLCA_STORAGE_CLASS 
  240. SQLCA_STORAGE_CLASS struct sqlca sqlca 
  241. #else 
  242.          struct sqlca sqlca 
  243. #endif 
  244.   
  245. #ifdef  SQLCA_INIT 
  246.          = { 
  247.          {'S', 'Q','L', 'C','A', ' ',' ', ' '}, 
  248.          sizeof(struct sqlca), 
  249.          0, 
  250.          { 0, {0}}, 
  251.          {'N', 'O','T', ' ','S', 'E','T', ' '}, 
  252.          {0, 0, 0, 0, 0, 0}, 
  253.          {0, 0, 0, 0, 0, 0, 0, 0}, 
  254.          {0, 0, 0, 0, 0, 0, 0, 0} 
  255.          } 
  256. #endif 
  257.          ; 
  258. #endif 
  259.   
  260. #endif 
  261.   
  262. /* end SQLCA */ 
  263.  
  264.     /* EXEC SQL BEGIN DECLARE SECTION; */  
  265.  
  266.     /* VARCHAR UserPasswd[200]; */  
  267. struct { unsigned short len; unsigned char arr[200]; } UserPasswd; 
  268.  
  269.     /* EXEC SQL END DECLARE SECTION; */  
  270.  
  271.     strcpy((char*)UserPasswd.arr, c_UserPasswd); 
  272.     UserPasswd.len = strlen((char*)UserPasswd.arr); 
  273.  
  274.     /* EXEC SQL connect : UserPasswd; */  
  275.  
  276. { 
  277. struct sqlexd sqlstm; 
  278. sqlstm.sqlvsn = 12; 
  279. sqlstm.arrsiz = 4; 
  280. sqlstm.sqladtp = &sqladt; 
  281. sqlstm.sqltdsp = &sqltds; 
  282. sqlstm.iters = (unsigned int  )10; 
  283. sqlstm.offset = (unsigned int  )5; 
  284. sqlstm.cud = sqlcud0; 
  285. sqlstm.sqlest = (unsigned char  *)&sqlca; 
  286. sqlstm.sqlety = (unsigned short)256; 
  287. sqlstm.occurs = (unsigned int  )0; 
  288. sqlstm.sqhstv[0] = (unsigned char  *)&UserPasswd; 
  289. sqlstm.sqhstl[0] = (unsigned long )202; 
  290. sqlstm.sqhsts[0] = (         int  )202; 
  291. sqlstm.sqindv[0] = (         short *)0; 
  292. sqlstm.sqinds[0] = (         int  )0; 
  293. sqlstm.sqharm[0] = (unsigned long )0; 
  294. sqlstm.sqadto[0] = (unsigned short )0; 
  295. sqlstm.sqtdso[0] = (unsigned short )0; 
  296. sqlstm.sqphsv = sqlstm.sqhstv; 
  297. sqlstm.sqphsl = sqlstm.sqhstl; 
  298. sqlstm.sqphss = sqlstm.sqhsts; 
  299. sqlstm.sqpind = sqlstm.sqindv; 
  300. sqlstm.sqpins = sqlstm.sqinds; 
  301. sqlstm.sqparm = sqlstm.sqharm; 
  302. sqlstm.sqparc = sqlstm.sqharc; 
  303. sqlstm.sqpadto = sqlstm.sqadto; 
  304. sqlstm.sqptdso = sqlstm.sqtdso; 
  305. sqlstm.sqlcmax = (unsigned int )100; 
  306. sqlstm.sqlcmin = (unsigned int )2; 
  307. sqlstm.sqlcincr = (unsigned int )1; 
  308. sqlstm.sqlctimeout = (unsigned int )0; 
  309. sqlstm.sqlcnowait = (unsigned int )0; 
  310. sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn); 
  311. } 
  312.  
  313.  
  314.     if (sqlca.sqlcode != 0) 
  315.     { 
  316.         printf("连接数据库失败，错误代码:%ld\n", sqlca.sqlcode); 
  317.     } 
  318.     else 
  319.     { 
  320.         printf("连接数据库成功:%ld\n", sqlca.sqlcode); 
  321.     } 
  322.     return sqlca.sqlcode; 
  323. } 
  324.  
  325. void DisconnectDB() 
  326. { 
  327.     /* EXEC SQL ROLLBACK WORK RELEASE; */  
  328.  
  329. { 
  330. struct sqlexd sqlstm; 
  331. sqlstm.sqlvsn = 12; 
  332. sqlstm.arrsiz = 4; 
  333. sqlstm.sqladtp = &sqladt; 
  334. sqlstm.sqltdsp = &sqltds; 
  335. sqlstm.iters = (unsigned int  )1; 
  336. sqlstm.offset = (unsigned int  )36; 
  337. sqlstm.cud = sqlcud0; 
  338. sqlstm.sqlest = (unsigned char  *)&sqlca; 
  339. sqlstm.sqlety = (unsigned short)256; 
  340. sqlstm.occurs = (unsigned int  )0; 
  341. sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn); 
  342. } 
  343.  
  344.  
  345. } 
  346.  
  347. void Query() 
  348. { 
  349.     char *datainfo; 
  350.     char c_DateTime[50];    /*输出的时间变量*/ 
  351.     int i = 0; 
  352.     int j=0; 
  353.     GetDateTime(c_DateTime); 
  354.     char msg[DEFAULT_FILEBUFFER_LEN]; 
  355.     char C_SP_TYPE_CODE[DEFAULT_FILEBUFFER_LEN]; 
  356. /*  EXEC SQL INCLUDE SQLCA;
  357. */  
  358. /*
  359. * $Header: sqlca.h 24-apr-2003.12:50:58 mkandarp Exp $ sqlca.h
  360. */ 
  361.  
  362. /* Copyright (c) 1985, 2003, Oracle Corporation.  All rights reserved.  */ 
  363.   
  364. /*
  365. NAME
  366.   SQLCA : SQL Communications Area.
  367. FUNCTION
  368.   Contains no code. Oracle fills in the SQLCA with status info
  369.   during the execution of a SQL stmt.
  370. NOTES
  371.   **************************************************************
  372.   ***                                                        ***
  373.   *** This file is SOSD.  Porters must change the data types ***
  374.   *** appropriately on their platform.  See notes/pcport.doc ***
  375.   *** for more information.                                  ***
  376.   ***                                                        ***
  377.   **************************************************************
  379.   If the symbol SQLCA_STORAGE_CLASS is defined, then the SQLCA
  380.   will be defined to have this storage class. For example:
  382.     #define SQLCA_STORAGE_CLASS extern
  384.   will define the SQLCA as an extern.
  386.   If the symbol SQLCA_INIT is defined, then the SQLCA will be
  387.   statically initialized. Although this is not necessary in order
  388.   to use the SQLCA, it is a good pgming practice not to have
  389.   unitialized variables. However, some C compilers/OS's don't
  390.   allow automatic variables to be init'd in this manner. Therefore,
  391.   if you are INCLUDE'ing the SQLCA in a place where it would be
  392.   an automatic AND your C compiler/OS doesn't allow this style
  393.   of initialization, then SQLCA_INIT should be left undefined --
  394.   all others can define SQLCA_INIT if they wish.
  396.   If the symbol SQLCA_NONE is defined, then the SQLCA variable will
  397.   not be defined at all.  The symbol SQLCA_NONE should not be defined
  398.   in source modules that have embedded SQL.  However, source modules
  399.   that have no embedded SQL, but need to manipulate a sqlca struct
  400.   passed in as a parameter, can set the SQLCA_NONE symbol to avoid
  401.   creation of an extraneous sqlca variable.
  403. MODIFIED
  404.     lvbcheng   07/31/98 -  long to int
  405.     jbasu      12/12/94 -  Bug 217878: note this is an SOSD file
  406.     losborne   08/11/92 -  No sqlca var if SQLCA_NONE macro set
  407.   Clare      12/06/84 - Ch SQLCA to not be an extern.
  408.   Clare      10/21/85 - Add initialization.
  409.   Bradbury   01/05/86 - Only initialize when SQLCA_INIT set
  410.   Clare      06/12/86 - Add SQLCA_STORAGE_CLASS option.
  411. */ 
  412.   
  413. #ifndef SQLCA 
  414. #define SQLCA 1 
  415.   
  416. struct   sqlca 
  417.          { 
  418.          /* ub1 */ char    sqlcaid[8]; 
  419.          /* b4  */ int     sqlabc; 
  420.          /* b4  */ int     sqlcode; 
  421.          struct 
  422.            { 
  423.            /* ub2 */ unsignedshort sqlerrml; 
  424.            /* ub1 */ char           sqlerrmc[70]; 
  425.            } sqlerrm; 
  426.          /* ub1 */ char    sqlerrp[8]; 
  427.          /* b4  */ int     sqlerrd[6]; 
  428.          /* ub1 */ char    sqlwarn[8]; 
  429.          /* ub1 */ char    sqlext[8]; 
  430.          }; 
  431.  
  432. #ifndef SQLCA_NONE  
  433. #ifdef   SQLCA_STORAGE_CLASS 
  434. SQLCA_STORAGE_CLASS struct sqlca sqlca 
  435. #else 
  436.          struct sqlca sqlca 
  437. #endif 
  438.   
  439. #ifdef  SQLCA_INIT 
  440.          = { 
  441.          {'S', 'Q','L', 'C','A', ' ',' ', ' '}, 
  442.          sizeof(struct sqlca), 
  443.          0, 
  444.          { 0, {0}}, 
  445.          {'N', 'O','T', ' ','S', 'E','T', ' '}, 
  446.          {0, 0, 0, 0, 0, 0}, 
  447.          {0, 0, 0, 0, 0, 0, 0, 0}, 
  448.          {0, 0, 0, 0, 0, 0, 0, 0} 
  449.          } 
  450. #endif 
  451.          ; 
  452. #endif 
  453.   
  454. #endif 
  455.   
  456. /* end SQLCA */ 
  457.  
  458.     /* EXEC SQL BEGIN DECLARE SECTION; */  
  459.  
  460.     /* VARCHAR count[20]; */  
  461. struct { unsigned short len; unsigned char arr[20]; } count; 
  462.  
  463.     /* VARCHAR  SqlStr[5000]; */  
  464. struct { unsigned short len; unsignedchar arr[5000]; } SqlStr; 
  465.  
  466.      
  467.     /* VARCHAR SP_TYPE[20]; */  
  468. struct { unsigned short len; unsignedchar arr[20]; } SP_TYPE; 
  469.  
  470.     /* VARCHAR  SP_TYPE_CODE[DEFAULT_FILEBUFFER_LEN]; */  
  471. struct { unsigned short len; unsigned char arr[1048576]; } SP_TYPE_CODE; 
  472.  
  473.     /* EXEC SQL END DECLARE SECTION; */  
  474.  
  475.     strcpy ((char *)SqlStr.arr,param.c_SqlStr); 
  476.     SqlStr.len = strlen((char*)SqlStr.arr); 
  477.  
  478.     if (ConnectDB(param.USER_PASSWORD) == 0) 
  479.     { 
  480.         /* EXEC SQL SELECT count(*) INTO :count FROM TD_B_PARTY_SERVICE; */  
  481.  
  482. { 
  483.   struct sqlexd sqlstm; 
  484.   sqlstm.sqlvsn = 12; 
  485.   sqlstm.arrsiz = 4; 
  486.   sqlstm.sqladtp = &sqladt; 
  487.   sqlstm.sqltdsp = &sqltds; 
  488.   sqlstm.stmt = "select count(*)  into :b0  from TD_B_PARTY_SERVICE "; 
  489.   sqlstm.iters = (unsigned int  )1; 
  490.   sqlstm.offset = (unsigned int  )51; 
  491.   sqlstm.selerr = (unsigned short)1; 
  492.   sqlstm.cud = sqlcud0; 
  493.   sqlstm.sqlest = (unsigned char  *)&sqlca; 
  494.   sqlstm.sqlety = (unsigned short)256; 
  495.   sqlstm.occurs = (unsigned int  )0; 
  496.   sqlstm.sqhstv[0] = (unsigned char  *)&count; 
  497.   sqlstm.sqhstl[0] = (unsigned long )22; 
  498.   sqlstm.sqhsts[0] = (         int  )0; 
  499.   sqlstm.sqindv[0] = (         short *)0; 
  500.   sqlstm.sqinds[0] = (         int  )0; 
  501.   sqlstm.sqharm[0] = (unsigned long )0; 
  502.   sqlstm.sqadto[0] = (unsigned short )0; 
  503.   sqlstm.sqtdso[0] = (unsigned short )0; 
  504.   sqlstm.sqphsv = sqlstm.sqhstv; 
  505.   sqlstm.sqphsl = sqlstm.sqhstl; 
  506.   sqlstm.sqphss = sqlstm.sqhsts; 
  507.   sqlstm.sqpind = sqlstm.sqindv; 
  508.   sqlstm.sqpins = sqlstm.sqinds; 
  509.   sqlstm.sqparm = sqlstm.sqharm; 
  510.   sqlstm.sqparc = sqlstm.sqharc; 
  511.   sqlstm.sqpadto = sqlstm.sqadto; 
  512.   sqlstm.sqptdso = sqlstm.sqtdso; 
  513.   sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn); 
  514. } 
  515.  
  516.  
  517.         if (sqlca.sqlcode < 0) 
  518.         { 
  519.             DisconnectDB(); /*断开数据库连接*/ 
  520.  
  521.             printf("建立游标错误！错误代码:%d\n", sqlca.sqlcode); 
  522.             exit(-1); 
  523.         } 
  524.         strcpy((char*)msg, (char*)count.arr); 
  525.      
  526.          
  527.         if ((in_fp = fopen(param.FILENAME,"w")) != NULL) 
  528.         { 
  529.             printf("打开%s文件成功\n\n", param.FILENAME);  
  530.             printf("---------------------%s 开始处理数据---------------------\n\n", c_DateTime); 
  531.             printf("[SQL]:%s\n\n", param.c_SqlStr); 
  532.             /*if (setvbuf(in_fp, msg, _IONBF, DEFAULT_FILEBUFFER_LEN) != 0)
  533.                 printf("设置缓冲失败\n");
  534.             else
  535.             {
  536.                 printf("设置缓冲成功：%d\n", setvbuf(in_fp, msg, _IONBF, DEFAULT_FILEBUFFER_LEN));
  537.             }
  538.             */ 
  539.             /* prepare */ 
  540.             /* EXEC SQL PREPARE s FROM :SqlStr; */  
  541.  
  542. { 
  543.    struct sqlexd sqlstm; 
  544.    sqlstm.sqlvsn = 12; 
  545.    sqlstm.arrsiz = 4; 
  546.    sqlstm.sqladtp = &sqladt; 
  547.    sqlstm.sqltdsp = &sqltds; 
  548.    sqlstm.stmt = ""; 
  549.    sqlstm.iters = (unsigned int  )1; 
  550.    sqlstm.offset = (unsigned int  )70; 
  551.    sqlstm.cud = sqlcud0; 
  552.    sqlstm.sqlest = (unsigned char  *)&sqlca; 
  553.    sqlstm.sqlety = (unsigned short)256; 
  554.    sqlstm.occurs = (unsigned int  )0; 
  555.    sqlstm.sqhstv[0] = (unsigned char  *)&SqlStr; 
  556.    sqlstm.sqhstl[0] = (unsigned long )5002; 
  557.    sqlstm.sqhsts[0] = (         int  )0; 
  558.    sqlstm.sqindv[0] = (         short *)0; 
  559.    sqlstm.sqinds[0] = (         int  )0; 
  560.    sqlstm.sqharm[0] = (unsigned long )0; 
  561.    sqlstm.sqadto[0] = (unsigned short )0; 
  562.    sqlstm.sqtdso[0] = (unsigned short )0; 
  563.    sqlstm.sqphsv = sqlstm.sqhstv; 
  564.    sqlstm.sqphsl = sqlstm.sqhstl; 
  565.    sqlstm.sqphss = sqlstm.sqhsts; 
  566.    sqlstm.sqpind = sqlstm.sqindv; 
  567.    sqlstm.sqpins = sqlstm.sqinds; 
  568.    sqlstm.sqparm = sqlstm.sqharm; 
  569.    sqlstm.sqparc = sqlstm.sqharc; 
  570.    sqlstm.sqpadto = sqlstm.sqadto; 
  571.    sqlstm.sqptdso = sqlstm.sqtdso; 
  572.    sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn); 
  573. } 
  574.  
  575.   
  576.              
  577.             /*声明一个跟该动态语句相关的游标*/ 
  578.             /* EXEC SQL DECLARE cur_out CURSOR FOR s; */  
  579.  
  580.              
  581.             /*通过OPEN操作向动态语句传递参数*/ 
  582.             /* EXEC SQL OPEN cur_out; */  
  583.  
  584. { 
  585.    struct sqlexd sqlstm; 
  586.    sqlstm.sqlvsn = 12; 
  587.    sqlstm.arrsiz = 4; 
  588.    sqlstm.sqladtp = &sqladt; 
  589.    sqlstm.sqltdsp = &sqltds; 
  590.    sqlstm.stmt = ""; 
  591.    sqlstm.iters = (unsigned int  )1; 
  592.    sqlstm.offset = (unsigned int  )89; 
  593.    sqlstm.selerr = (unsigned short)1; 
  594.    sqlstm.cud = sqlcud0; 
  595.    sqlstm.sqlest = (unsigned char  *)&sqlca; 
  596.    sqlstm.sqlety = (unsigned short)256; 
  597.    sqlstm.occurs = (unsigned int  )0; 
  598.    sqlstm.sqcmod = (unsigned int )0; 
  599.    sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn); 
  600. } 
  601.  
  602.  
  603.              
  604.             /* EXEC SQL WHENEVER NOT FOUND GOTO notfound; */  
  605.  
  606.         while(TRUE)  
  607.             { 
  608.                 /* EXEC SQL FETCH cur_out into :SP_TYPE_CODE; */  
  609.  
  610. { 
  611.     struct sqlexd sqlstm; 
  612.     sqlstm.sqlvsn = 12; 
  613.     sqlstm.arrsiz = 4; 
  614.     sqlstm.sqladtp = &sqladt; 
  615.     sqlstm.sqltdsp = &sqltds; 
  616.     sqlstm.iters = (unsigned int  )1; 
  617.     sqlstm.offset = (unsigned int  )104; 
  618.     sqlstm.selerr = (unsigned short)1; 
  619.     sqlstm.cud = sqlcud0; 
  620.     sqlstm.sqlest = (unsigned char  *)&sqlca; 
  621.     sqlstm.sqlety = (unsigned short)256; 
  622.     sqlstm.occurs = (unsigned int  )0; 
  623.     sqlstm.sqfoff = (         int )0; 
  624.     sqlstm.sqfmod = (unsigned int )2; 
  625.     sqlstm.sqhstv[0] = (unsigned char  *)&SP_TYPE_CODE; 
  626.     sqlstm.sqhstl[0] = (unsigned long )1048578; 
  627.     sqlstm.sqhsts[0] = (         int  )0; 
  628.     sqlstm.sqindv[0] = (         short *)0; 
  629.     sqlstm.sqinds[0] = (         int  )0; 
  630.     sqlstm.sqharm[0] = (unsigned long )0; 
  631.     sqlstm.sqadto[0] = (unsigned short )0; 
  632.     sqlstm.sqtdso[0] = (unsigned short )0; 
  633.     sqlstm.sqphsv = sqlstm.sqhstv; 
  634.     sqlstm.sqphsl = sqlstm.sqhstl; 
  635.     sqlstm.sqphss = sqlstm.sqhsts; 
  636.     sqlstm.sqpind = sqlstm.sqindv; 
  637.     sqlstm.sqpins = sqlstm.sqinds; 
  638.     sqlstm.sqparm = sqlstm.sqharm; 
  639.     sqlstm.sqparc = sqlstm.sqharc; 
  640.     sqlstm.sqpadto = sqlstm.sqadto; 
  641.     sqlstm.sqptdso = sqlstm.sqtdso; 
  642.     sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn); 
  643.     if (sqlca.sqlcode == 1403)goto notfound; 
  644. } 
  645.  
  646.  
  647.                 if (sqlca.sqlcode < 0) 
  648.                 { 
  649.                     DisconnectDB(); /*断开数据库连接*/ 
  650.  
  651.                     printf("建立游标错误！错误代码:%d\n", sqlca.sqlcode); 
  652.                     exit(-1); 
  653.                 } 
  654.                 strcpy((char*)C_SP_TYPE_CODE, (char*)SP_TYPE_CODE.arr); 
  655.                 fputs(C_SP_TYPE_CODE, in_fp); 
  656.                 fputc('\n', in_fp); 
  657.                 i++; 
  658.                 if (i%1000==0) 
  659.                     printf(" 输出[%d]条记录\n",i); 
  660.              
  661.             } 
  662.             notfound: 
  663.             /* EXEC SQL CLOSE cur_out; */  
  664.  
  665. { 
  666.    struct sqlexd sqlstm; 
  667.    sqlstm.sqlvsn = 12; 
  668.    sqlstm.arrsiz = 4; 
  669.    sqlstm.sqladtp = &sqladt; 
  670.    sqlstm.sqltdsp = &sqltds; 
  671.    sqlstm.iters = (unsigned int  )1; 
  672.    sqlstm.offset = (unsigned int  )123; 
  673.    sqlstm.cud = sqlcud0; 
  674.    sqlstm.sqlest = (unsigned char  *)&sqlca; 
  675.    sqlstm.sqlety = (unsigned short)256; 
  676.    sqlstm.occurs = (unsigned int  )0; 
  677.    sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn); 
  678. } 
  679.  
  680.  
  681.         /* EXEC SQL COMMIT RELEASE; */  
  682.  
  683. { 
  684.       struct sqlexd sqlstm; 
  685.       sqlstm.sqlvsn = 12; 
  686.       sqlstm.arrsiz = 4; 
  687.       sqlstm.sqladtp = &sqladt; 
  688.       sqlstm.sqltdsp = &sqltds; 
  689.       sqlstm.iters = (unsigned int  )1; 
  690.       sqlstm.offset = (unsigned int  )138; 
  691.       sqlstm.cud = sqlcud0; 
  692.       sqlstm.sqlest = (unsigned char  *)&sqlca; 
  693.       sqlstm.sqlety = (unsigned short)256; 
  694.       sqlstm.occurs = (unsigned int  )0; 
  695.       sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn); 
  696. } 
  697.  
  698.  
  699.         printf("-------------关闭文件%s成功！-------------\n",param.FILENAME); 
  700.             printf("--------------------------共处理%d条数据---------------------------\n\n", i); 
  701.             fclose(in_fp); 
  702.             exit(0); 
  703.         } 
  704.     } 
  705. } 

再就是pc文件test.pc，其需要引入test.h文件，主要是调用test.h方法

[cpp] view plaincopyprint?
  1. #include "test.h" 
  2.  
  3. int main(int argc,char* argv[]) 
  4. { 
  5.     initparam(); 
  6.     setparam(argc, argv); 
  7.     PrintParam(); 
  8.     Query(); 
  9.     return 0; 
  10. } 
  11. int ConnectDB(char* c_UserPasswd) 
  12. { 
  13.     EXEC SQL INCLUDE SQLCA; 
  14.     EXEC SQL BEGIN DECLARE SECTION; 
  15.     VARCHAR UserPasswd[200]; 
  16.     EXEC SQL END DECLARE SECTION; 
  17.     strcpy((char*)UserPasswd.arr, c_UserPasswd); 
  18.     UserPasswd.len = strlen((char*)UserPasswd.arr); 
  19.  
  20.     EXEC SQL connect : UserPasswd; 
  21.     if (sqlca.sqlcode != 0) 
  22.     { 
  23.         printf("连接数据库失败，错误代码:%ld\n", sqlca.sqlcode); 
  24.     } 
  25.     else 
  26.     { 
  27.         printf("连接数据库成功:%ld\n", sqlca.sqlcode); 
  28.     } 
  29.     return sqlca.sqlcode; 
  30. } 
  31.  
  32. void DisconnectDB() 
  33. { 
  34.     EXEC SQL ROLLBACK WORK RELEASE; 
  35. } 
  36.  
  37. void Query() 
  38. { 
  39.     char *datainfo; 
  40.     char c_DateTime[50];    /*输出的时间变量*/ 
  41.     int i = 0; 
  42.     int j=0; 
  43.     GetDateTime(c_DateTime); 
  44.     char msg[DEFAULT_FILEBUFFER_LEN]; 
  45.     char C_SP_TYPE_CODE[DEFAULT_FILEBUFFER_LEN]; 
  46.     EXEC SQL INCLUDE SQLCA; 
  47.     EXEC SQL BEGIN DECLARE SECTION; 
  48.     VARCHAR count[20]; 
  49.     VARCHAR  SqlStr[5000]; 
  50.      
  51.     VARCHAR SP_TYPE[20]; 
  52.     VARCHAR  SP_TYPE_CODE[DEFAULT_FILEBUFFER_LEN]; 
  53.     EXEC SQL END DECLARE SECTION; 
  54.     strcpy ((char *)SqlStr.arr,param.c_SqlStr); 
  55.     SqlStr.len = strlen((char*)SqlStr.arr); 
  56.  
  57.     if (ConnectDB(param.USER_PASSWORD) == 0) 
  58.     { 
  59.         EXEC SQL SELECT count(*) INTO :count FROM TD_B_PARTY_SERVICE; 
  60.         if (sqlca.sqlcode < 0) 
  61.         { 
  62.             DisconnectDB(); /*断开数据库连接*/ 
  63.  
  64.             printf("建立游标错误！错误代码:%d\n", sqlca.sqlcode); 
  65.             exit(-1); 
  66.         } 
  67.         strcpy((char*)msg, (char*)count.arr); 
  68.      
  69.          
  70.         if ((in_fp = fopen(param.FILENAME,"w")) != NULL) 
  71.         { 
  72.             printf("打开%s文件成功\n\n", param.FILENAME);  
  73.             printf("---------------------%s 开始处理数据---------------------\n\n", c_DateTime); 
  74.             printf("[SQL]:%s\n\n", param.c_SqlStr); 
  75.             /*if (setvbuf(in_fp, msg, _IONBF, DEFAULT_FILEBUFFER_LEN) != 0)
  76.                 printf("设置缓冲失败\n");
  77.             else
  78.             {
  79.                 printf("设置缓冲成功：%d\n", setvbuf(in_fp, msg, _IONBF, DEFAULT_FILEBUFFER_LEN));
  80.             }
  81.             */ 
  82.             /* prepare */ 
  83.             EXEC SQL PREPARE s FROM :SqlStr;  
  84.              
  85.             /*声明一个跟该动态语句相关的游标*/ 
  86.             EXEC SQL DECLARE cur_out CURSOR FOR s; 
  87.              
  88.             /*通过OPEN操作向动态语句传递参数*/ 
  89.             EXEC SQL OPEN cur_out; 
  90.              
  91.             EXEC SQL WHENEVER NOT FOUND GOTO notfound; 
  92.         while(TRUE)  
  93.             { 
  94.                 EXEC SQL FETCH cur_out into :SP_TYPE_CODE; 
  95.                 if (sqlca.sqlcode < 0) 
  96.                 { 
  97.                     DisconnectDB(); /*断开数据库连接*/ 
  98.  
  99.                     printf("建立游标错误！错误代码:%d\n", sqlca.sqlcode); 
  100.                     exit(-1); 
  101.                 } 
  102.                 strcpy((char*)C_SP_TYPE_CODE, (char*)SP_TYPE_CODE.arr); 
  103.                 fputs(C_SP_TYPE_CODE, in_fp); 
  104.                 fputc('\n', in_fp); 
  105.                 i++; 
  106.                 if (i%1000==0) 
  107.                     printf(" 输出[%d]条记录\n",i); 
  108.              
  109.             } 
  110.             notfound: 
  111.             EXEC SQL CLOSE cur_out; 
  112.         EXEC SQL COMMIT RELEASE; 
  113.         printf("-------------关闭文件%s成功！-------------\n",param.FILENAME); 
  114.             printf("--------------------------共处理%d条数据---------------------------\n\n", i); 
  115.             fclose(in_fp); 
  116.             exit(0); 
  117.         } 
  118.     } 
  119. } 

ok，主要的代码就这些，接下来呢就是要编译pro*文件了，这就用到makefile，这里需要注意的就是要引入oracle的lib了，不能少了也不可乱了顺序，否则会有意想不到的错误发生，我的系统是AIX，所以编译采用的是xlc，linux系统可用cpp。编译命令是make proc，生成可执行文件DATATOFILE

Makefile

[cpp] view plaincopyprint?
  1. CPP       = xlC_r7 -q64 -bh:5 -g  
  2. CPPFLAGS    =   -c -o  
  3.  
  4.  
  5. LFLAGS    = $(PLATFORM_DEF) -D_REENTRANT -D_THREAD_SAFE -g -w -o 
  6. LIB       = -L$(PATH_LIB) 
  7. PATH_TEST =/ngbss/mddms/interface/other/SRBI/test 
  8. PROC_INCLUDE =  -I${ORACLE_HOME}/precomp/public 
  9. PROC_LIB =-L${ORACLE_HOME}/lib -L${ORACLE_HOME}/precomp/lib  
  10. OCI_INCLUDE =   -O -I${ORACLE_HOME}/rdbms/include -I${ORACLE_HOME}/rdbms/demo -I${ORACLE_HOME}/rdbms/public -I${ORACLE_HOME}/plsql/public -I${ORACLE_HOME}/network/public  
  11. OCI_LIBPATH = -L. -L.. -L${ORACLE_HOME}/lib  
  12. INCLUDE   = $(OCI_INCLUDE) 
  13.  
  14.  
  15.      
  16. proc: 
  17.     proc SQLCHECK=SEMANTICS  HOLD_CURSOR=YES userid=uop_uif1/123456@ngcrm1_taf code=CPP iname=test.pc oname=test.cpp 
  18.  
  19.  
  20.     xlc  -qdfp -I${ORACLE_HOME}/rdbms/lib32 \ 
  21.             -I${ORACLE_HOME}/lib32 \ 
  22.             -I${ORACLE_HOME}/precomp/public \ 
  23.             -L${ORACLE_HOME}/lib32\ 
  24.             -I${ORACLE_HOME}/precomp/lib \ 
  25.             -L${ORACLE_HOME}/rdbms/lib32 \ 
  26.           -L${ORACLE_HOME}/rdbms/lib -L${ORACLE_HOME}/lib -locci -lclntsh  test.cpp  -o DATATOFILE 
  27.  
  28.      

好了，最后看看我们如何利用shell脚本调用DATATOFILE取出oracle数据的,shell脚本将会生成一个*.ini的配置文件，配置信息呢就是
[cpp] view plaincopyprint?
  1. cat<<EndCfg>$szCfgFile到EndCfg直接的类容，[]就是配置信息标记，${BIN_PATH}/DATATOFILE -d $INI_PATH/filename_${x}.ini这句呢就是调用我们的可执行程序生成数据了 
  2. 然后我们执行sh test.sh运行脚本。生成数据文件*.AVL 

test.sh

[cpp] view plaincopyprint?
  1. #!/bin/sh 
  2. #-------------------------------------------------------------------- 
  3. # Fuction：产品域   TD_B_SPTYPE SP业务类型参数表 
  4. # Version: 1.0 
  5. # Created: wangkun 
  6. # Created date:2012/10/12 
  7. # Modify history: 
  8. #-------------------------------------------------------------------- 
  9.  
  10. begintime=`date +%s` 
  11. . /ngbss/mddms/.profile 
  12. export NLS_LANG="AMERICAN_AMERICA.utf8" 
  13. ###################################################################################### 
  14. SafeCmd() 
  15. { 
  16. $* 
  17. return 0 
  18. } 
  19.  
  20. DEALDATE=`date +%Y%m%d` 
  21. curdate=`date +%Y%m%d` 
  22.  
  23. #得到前一天日期 
  24. GetPrevDate() 
  25. { 
  26.         if (test $# -eq 0) 
  27.         then 
  28.                 CurDate=`date +%Y%m%d` 
  29.         else 
  30.                 CurDate=$1 
  31.         fi 
  32.  
  33.         CurYear=`echo $CurDate | cut -c1-4` 
  34.         CurMonth=`echo $CurDate | cut -c5-6` 
  35.         CurDay=`echo $CurDate | cut -c7-8` 
  36.  
  37.         GetYear="$CurYear" 
  38.         GetMonth="$CurMonth" 
  39.         GetDay="`expr $CurDay - 1`" 
  40.  
  41.         if [ "$GetDay" -le 0 ]; then 
  42.  
  43.             GetMonth=`expr $CurMonth - 1` 
  44.  
  45.             if [ "$GetMonth" -le 0 ] ; then 
  46.  
  47.                     GetYear=`expr $CurYear - 1` 
  48.                     GetMonth=12 
  49.  
  50.             fi 
  51.  
  52.             case "$GetMonth" 
  53.             in 
  54.                 1|3|5|7|8|10|12) 
  55.                       GetDay=31;; 
  56.                 4|6|9|11) 
  57.                       GetDay=30;; 
  58.                 2) 
  59.  
  60.                       if [ `expr "$CurYear" % 400` -eq 0 ]; then 
  61.  
  62.                               GetDay=29 
  63.  
  64.                       elif [ `expr "$CurYear" % 4` -eq 0 -a `expr"$CurYear" % 100` -ne 0 ]; then 
  65.  
  66.                               GetDay=29 
  67.  
  68.                       else 
  69.                               GetDay=28 
  70.                       fi 
  71.             esac 
  72.         fi 
  73.  
  74.         if [ `echo "$GetMonth" | wc -m` -ne 3 ] ; then 
  75.  
  76.                 GetMonth=0$GetMonth 
  77.         fi 
  78.  
  79.         if [ `echo "$GetDay" | wc -m` -ne 3 ] ; then 
  80.  
  81.                 GetDay=0$GetDay 
  82.         fi 
  83.  
  84.         echo  "$GetYear""$GetMonth""$GetDay" 
  85. } 
  86.  
  87. sdate=`GetPrevDate` 
  88.  
  89. #######################公共配置############################################### 
  90. szProcTime=`date +%Y%m%d%H%M%S` 
  91. WORK_PATH=/ngbss/mddms/interface/other/SRBI/test 
  92. LOGPATH=/ngbss/mddms/interface/other/SRBI/log 
  93. FILE_PATH=/ngbss/mddms/interface/other/SRBI/test/files 
  94. CHKSHPATH=/ngbss/mddms/interface/other/SRBI/ddchk.sh 
  95. BAK_PATH=/ngbss/mddms/interface/other/SRBI/test/bak 
  96. BIN_PATH=/ngbss/mddms/interface/other/SRBI/test 
  97. INI_PATH=/ngbss/mddms/interface/other/SRBI/test/ini 
  98. COMMON_PATH=/ngbss/mddms/interface/common/ 
  99. ######################公共配置############################################### 
  100.  
  101.  
  102. cd $COMMON_PATH 
  103. #CONN=`sh /ngbss/mddms/interface/getid/getid.sh BIuop_cen1 uop_cen1` 
  104. CONN1=uop_cen1/123456@NGcrm1-gs 
  105. #CONN2=uop_crm2/123456@ngcrm1_taf 
  106. #割接开启 
  107. cd $WORK_PATH 
  108. CHANNEL="uop_cen1"   
  109.          
  110.          
  111. table_column_name="SP_TYPE_CODE,SP_TYPE" 
  112. table_column_type="VARCHAR2,VARCHAR2" 
  113.  
  114. for x in $CHANNEL 
  115. do 
  116. if [ "$x" = uop_cen1 ] 
  117. then 
  118.   filename='BA087D01001'$sdate'00000001' 
  119.   CONN=$CONN1 
  120. fi 
  121.  
  122. echo ====================================================================================== 
  123.  
  124. echo `date +%H\:%M\'%S\"` 正在处理$filename... 
  125.  
  126. ##############################配置信息############################################# 
  127. szCfgFile=$INI_PATH/filename_${x}.ini 
  128.  
  129. cat<<EndCfg>$szCfgFile 
  130.  
  131. [SYS] 
  132.  
  133. #每条纪录的长度 对速度影响较大 
  134. [SINGLE_LENGTH]:1000 
  135.  
  136. [DB] 
  137.  
  138. [USER_PASSWORD]:$CONN 
  139.  
  140. #可以加入UNION ALL 等语句 decode(a.modify_tag, '0', '1', '1', '2', '1') 
  141. [SQL]: select replace(replace( PARTY_ID||chr(01)||SP_TYPE_CODE||chr(01)||SP_ID||chr(01)||SP_NAME||chr(01)||STATES||chr(01)||START_DATE||chr(01)||END_DATE||chr(01)||UPDATE_TIME ,chr(10)),chr(13)) from TD_B_PARTY_SERVICE    
  142.  
  143. [FILENAME]:${FILE_PATH}/$filename 
  144.  
  145. #文件后缀名 
  146. [POSTFIX]:AVL 
  147.  
  148. [OTHER] 
  149.  
  150. [COMMOND]: ls 
  151. EndCfg 
  152. ##############################配置信息############################################# 
  153. cd $WORK_PATH 
  154. ${BIN_PATH}/DATATOFILE -d $INI_PATH/filename_${x}.ini 
  155. cd $FILE_PATH 
  156. mv $filename ${filename}.AVL 
  157. done 
  158. endtime=`date +%s` 
  159. echo "共计时间："  $((endtime-begintime))"秒" 

python数据处理代码 python数据处理代码
原创粉丝点击
热门IT博客
淘宝网上有卖烟的吗淘宝网上有卖烟的吗
淘宝备注在哪淘宝备注在哪
仙界网络直播间女主
国外免费源码网站
9wifi九维网络
centos 搭建svn服务器
知乎年度吐槽精选二
mysql 触发器 本表
光盘数据循环冗余错误
甄嬛传 皇后 知乎
剑桥中国史知乎
logo在线制作软件
开票软件是什么
ubuntu 16.04 lts 源
淘宝用邮箱怎么注册
淘宝骑行头盔哪家靠谱
linux set export
鼻子变小知乎
单片机继电器模块接线
js原型对象
热门问题 老师的惩罚 人脸识别 我在镇武司摸鱼那些年 重生之率土为王 我在大康的咸鱼生活 盘龙之生命进化 天生仙种 凡人之先天五行 春回大明朝 姑娘不必设防，我是瞎子 漫步者e3100 漫步者音箱配件 漫步者电视音响 漫步者音箱大全 漫步者迷你音响 漫步者低音喇叭 漫步者r201t 漫步者r26t 漫步者h180 漫步者耳机哪款好 漫步者k800 漫步者无线耳机 漫步者h290 漫步者h840 漫步者手机耳机 漫步者h280 漫步者耳机音质 漫步者h210 漫步者h850 漫步者的耳机好不 漫步者h210p 漫步者h230p 漫步者吧 漫步者股票吧 002351漫步者股吧 慢步者 漫步者s1000ma 漫步者w855bt 漫步者edifier 漫步者w288bt 漫步者e100 漫步者h185p 漫步者h190p 漫步者h220 漫步者m210 漫步者k210 漫步者r102v 漫步者mkii 漫步者r201tiii edifier/漫步者 漫步者r19u

程序博客网，程序员的互联网技术博客家园。csdn论坛精品 msdn技术资料都在这里