覺得Access Key很機車的人,試試看
LSKEYF00
FORM JUMP_THE_WALL USING RC.
RC = 1.
CALL 'CHECK_TADIR_ACCESS_FREE'.
CHECK SY-SUBRC NE 0.
CHECK SY-BATCH EQ SPACE.
CALL 'GET_DEVELOPER_KEY' ID 'NAME' FIELD 'ABCDEFGHIJKL'
ID 'CUSTID' FIELD '1234567890'
ID 'KEY' FIELD DUMMY_KEY.
CHECK SY-SUBRC EQ 2. <- Break Point
MOVE SPACE TO DUMMY_KEY.
RC = 0.
ENDFORM. " JUMP_THE_WALL
2010年5月11日 星期二
摘錄一些SQL日期操作
TRUNC(DATE[,FORMAT])函數將日期DATE按照FORMAT指定的格式進行截取,缺省為'DD'，截取日期為當月第一天。
SELECT TRUNC(TO_DATE('12-6月-01'),'MM') "FIRST"
TRUNC(TO_DATE('18-6月-01'),'MM') "SECOND" FROM DUAL;
FIRST SECOND
------- ----------
01-6月-01 01-6月-01
select to_char(sysdate,'yyyy-mm-dd hh:mi:ss am') "result1",
to_char(trunc(sysdate),'yyyy-mm-dd hh:mi:ss am') "result2" from dual;
result1 result2
---------- --------------
2001-10-21 02:48:49 下午 2001-10-21 12:00:00 上午
這是計算一個月第一天的SQL 指令檔：
Select DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)
SELECT TRUNC(TO_DATE('12-6月-01'),'MM') "FIRST"
TRUNC(TO_DATE('18-6月-01'),'MM') "SECOND" FROM DUAL;
FIRST SECOND
------- ----------
01-6月-01 01-6月-01
select to_char(sysdate,'yyyy-mm-dd hh:mi:ss am') "result1",
to_char(trunc(sysdate),'yyyy-mm-dd hh:mi:ss am') "result2" from dual;
result1 result2
---------- --------------
2001-10-21 02:48:49 下午 2001-10-21 12:00:00 上午
這是計算一個月第一天的SQL 指令檔：
Select DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)
SAP 備份物料主檔
Delete a material master - MM module
If you created an material by error and you want to delete that material from the data base you can do it in this simple 4 steps. The only condition is that this material has to have no material movement recorded.
These are the steps:1
1) Flag material for deletion. transaction MM06
2) Run report MMREO001 - Selection of materials flagged for deletion and select the material
3) Run report MMREO050 Archive Materials to archive the material (some customisig settings might be required)
4) Run report MMREO110 Deletion Program for Archiving Materials to delete the material from the database.
addition
Archive Object: MM_SPSTOCK (batch & special stock)
RUN MMREO020
If you created an material by error and you want to delete that material from the data base you can do it in this simple 4 steps. The only condition is that this material has to have no material movement recorded.
These are the steps:1
1) Flag material for deletion. transaction MM06
2) Run report MMREO001 - Selection of materials flagged for deletion and select the material
3) Run report MMREO050 Archive Materials to archive the material (some customisig settings might be required)
4) Run report MMREO110 Deletion Program for Archiving Materials to delete the material from the database.
addition
Archive Object: MM_SPSTOCK (batch & special stock)
RUN MMREO020
MS SQL Log清除
ALTER DATABASE WT_EXP
SET RECOVERY SIMPLE
GO
ALTER DATABASE WT_EXP
SET RECOVERY FULL
GO
--BACKUP LOG [資料庫名稱] WITH NO_LOG
DBCC SHRINKDATABASE ([資料庫名稱], 10)
或是藉由SSMS把DB log level更改後shirnk也可
SET RECOVERY SIMPLE
GO
ALTER DATABASE WT_EXP
SET RECOVERY FULL
GO
--BACKUP LOG [資料庫名稱] WITH NO_LOG
DBCC SHRINKDATABASE ([資料庫名稱], 10)
或是藉由SSMS把DB log level更改後shirnk也可
ABAP : 如何轉換ASCII code與字元
From : http://www.sap-img.com/abap/how-can-i-get-ascii-value-of-any-letter.htm
report Demotest.
* 1.將字元轉成ASCII code
data : c value 'A'.
field-symbols : type x.
data : rn type i.
assign c to casting.
move to rn.
write rn.
* 2. 將ASCII code轉成字元
data : i type i value 66.
data : x type x.
field-symbols : type c.
move i to x.
assign x to casting type c.
move to c.
write c.
report Demotest.
* 1.將字元轉成ASCII code
data : c value 'A'.
field-symbols :
data : rn type i.
assign c to
move
write rn.
* 2. 將ASCII code轉成字元
data : i type i value 66.
data : x type x.
field-symbols :
move i to x.
assign x to
move
write c.
x64上使用SSIS的問題
因為Oracle Driver的問題
在server上必須同時安裝x64和win32的Oracle Client
在啟動SQL 2008 BIDS(Visual Studio,這其實是win32程式)時,
像C:\Program Files(x86)\這種path name會產生設計時的runtime error
必須額外利用捷徑, 打C:\PROGRA~2\這像的路徑才OK
至於已產生好的package, 在SQL Agent則是以x64來執行
就沒有這個問題了
在server上必須同時安裝x64和win32的Oracle Client
在啟動SQL 2008 BIDS(Visual Studio,這其實是win32程式)時,
像C:\Program Files(x86)\這種path name會產生設計時的runtime error
必須額外利用捷徑, 打C:\PROGRA~2\這像的路徑才OK
至於已產生好的package, 在SQL Agent則是以x64來執行
就沒有這個問題了
訂閱：
文章 (Atom)