• 博客园logo
  • 会员
  • 周边
  • 新闻
  • 博问
  • 闪存
  • 众包
  • 赞助商
  • Chat2DB
    • 搜索
      所有博客
    • 搜索
      当前博客
  • 写随笔 我的博客 短消息 简洁模式
    用户头像
    我的博客 我的园子 账号设置 会员中心 简洁模式 ... 退出登录
    注册 登录
 






GoDevil

 
 

Powered by 博客园
博客园 | 首页 | 新随笔 | 联系 | 订阅 订阅 | 管理

随笔分类 -  SQR

 
Add Leading Characters to a Value or Field
摘要:A function to facilitate the addition of a leading character to a field value. The function takes three parameters:- &LEADCHAR: The character you want to append to your value.- &FIELDZISE: The... 阅读全文
posted @ 2009-07-27 13:10 Kevin's Blogy 阅读(206) 评论(0) 推荐(0)
Read Env Variables from an SQR
摘要:Get the O/S environment variables from within SQR programs There is a function called GetEnv(). This gets the TEMP environment variable on the machine where SQR is run. Returns the value of the spec... 阅读全文
posted @ 2009-01-09 14:49 Kevin's Blogy 阅读(330) 评论(0) 推荐(0)
Calling a Batch File/EXE from an SQR
摘要:Use the following code to call a batch file or executable from an SQR. Put the complete path of the batch or executable in the variable $command_line. If $message is not 0 then you have an error from ... 阅读全文
posted @ 2009-01-09 14:48 Kevin's Blogy 阅读(218) 评论(0) 推荐(0)
Strip out additional chars from Phone Numbers
摘要:Below is a good SQR tip for stripping out special characters from those nasty Phone Number formats stored in HRMS. begin-procedure main . . do parse_phone($phone_number, $phone_number) . . end-proc... 阅读全文
posted @ 2009-01-09 14:47 Kevin's Blogy 阅读(185) 评论(0) 推荐(0)
Use an SQR to call DataMover to Export then call a
摘要:Below is a sample piece of SQR code which you can use to call Datamover to export data perform some processing, and call another SQR within that SQR to posibly load the data. It's a good sample! !**... 阅读全文
posted @ 2009-01-09 14:46 Kevin's Blogy 阅读(331) 评论(0) 推荐(0)