20091113215000

来源：互联网发布：网络老是掉线怎么回事编辑：程序博客网时间：2024/05/17 21:05

sleep(3600); /*秒*/

struct timeval timeout;
memset(&timeout, 0, sizeof(struct timeval));
timeout.tv_usec = 50; timeout.tv_sec = 0;
select(0, NULL, NULL, NULL, &timeout); /* 睡眠50毫秒 */

——————————————————————————————————————————————————

remove(filename);

unlink(filename);

——————————————————————————————————————————————————

tar cvf ……

tar rvf ……/*追加*/

——————————————————————————————————————————————————

/*增加recordnum1明细*/
LoopNode = GetDataNode ( NULL, "recordnum1" ) ;
ClearNode( LoopNode ); /* 清掉recordnum1字总线节点 */

/*新增总线节点*/
SubLine = AddNodeNewSubLine(LoopNode);

/*增加明细*/

AddNewNode(SubLine, "len60r1", tmp_pch );

……

DumpNode2File( "sky", &GlobalLine, "recordnum1", NULL );

DumpDataLine( &GlobalLine, -1 );

——————————————————————————————————————————————————

ls -l -tr

tail -f filename

——————————————————————————————————————————————————

pid_t BatchPid = atoi(tmppid);

/* 看批次进程号是否在运行 */
        if ( BatchPid>0 ) {
        rc = kill(BatchPid, 0);
        if ( rc>=0 ) {
          sprintf(KLL.errdescex, "进程[%d]项目[%s]正在处理,请核实再发送", BatchPid, KLL.len12r2);
          return -1;
        }
        }

——————————————————————————————————————————————————

if((fp = fopen(filename1, "r")) == NULL)
{
ErrorMsg( "打开文件失败" );
return -1;
}
while(fgets(buf, 512, fp) != NULL){

……

}

http://hi.baidu.com/liu_jinyong/blog/item/728781dd34c7f5ec77c638e9.html

http://hi.baidu.com/guly699/blog/item/7bf4f103383b247f3812bb47.html

——————————————————————————————————————————————————

/*直接显示文件内容*/

SetIpcFileName(filename1);

/*获得查询数据*/

GetMultiSqlRecord( sqlbuf, "recordnum1" );

/*下传明细文件*/

DumpNode2File( "sky", &GlobalLine, "recordnum1", NULL );

——————————————————————————————————————————————————

索引

—————————————————————————————————————————————————

事务

int rc = 0;

exec sql begin work;
if ( sqlca.sqlcode ) {
  ErrorMsg( "启动事务失败:%Q" );
  return -9988;
}

rc = function();

if ( rc != 0 ) {
  DebugMsg(4,"进行回滚操作,错误吗[%s]",KLL.errcode);
  exec sql rollback;
}

exec sql commit work;

—————————————————————————————————————————————————

/*非select语句，动态sql--【http://www.blogjava.net/pdw2009/archive/2007/09/28/149017.html】*/

sprintf(sqlstr,"drop table %s",str_jfqy2);
EXEC SQL EXECUTE IMMEDIATE :sqlstr;

—————————————————————————————————————————————————

select decode(td_busitype,'02','固话收费','08','联合收费','99','对账')from kba_sms_snd where ……

—————————————————————————————————————————————————

sprintf(sqlStr, " select distinct chn_batchno,td_busitype,td_busitype1,len40r4 from kba_sms_snd where to_char(len40r1,'%s') = '%s'"
          " union "
          " select distinct chn_batchno,td_busitype,td_busitype1,len40r4 from kba_sms_snd_his where to_char(len40r1,'%s') = '%s'",
          "%Y%m%d",len40r1,
          "%Y%m%d",len40r1);                       /*union all不能排除两张表中有相同的数据*/

—————————————————————————————————————————————————

GetFormatTime(KLL.len40r1, "YYYYMMDDHHmmSS"); /* 写入时间(len40r1) datetime year to second */

EXEC SQL INSERT INTO kba_sms_snd(
   len40r1, /* 写入时间(len40r1) char() */
  )
  values(
      to_date(:KLL.len40r1, "%Y%m%d%H%M%S"), /* 写入时间(len40r1)   */
  );

—————————————————————————————————————————————————

EXEC SQL delete from kba_sms_snd
                where
                len40r1<((current year to second)-(2 UNITS day)) /* 2天前写入 */
  ;

http://blog.csdn.net/ldq210/archive/2007/12/11/1928752.aspx

—————————————————————————————————————————————————

/*不同的格式化方式*/

EXEC SQL select *from table where to_char(len40r1,'%Y%m%d')>'20091113'

—————————————————————————————————————————————————

/*统计字符串金额的和并且最后转成字符串*/

EXEC SQL select round(sum(number+0)) from table

cast(money as float);

/*参考http://hi.baidu.com/%CE%D2%CA%C7%D6%DC%D1%D2/blog/item/0f77f90f4993b3e5aa64572c.html*/