REPORT z03_24.
TYPES: BEGIN OF t_str ,
carrid LIKE sflight-carrid,
connid LIKE sflight-connid,
carrname LIKE scarr-carrname,
END OF t_str.
DATA gs_wa TYPE t_str.
DATA : gv_carrid LIKE sflight-carrid VALUE 'AA'.
EXEC SQL PERFORMING WRITE_DATA.
SELECT A.CARRID, SUBSTR(B.CARRNAME, 1, 8)
INTO :GS_WA-CARRID, :GS_WA-CARRNAME
FROM SFLIGHT A, SCARR B
WHERE A.MANDT = B.MANDT
AND A.CARRID = B.CARRID
AND A.MANDT = :SY-MANDT
AND A.CARRID = :GV_CARRID
ENDEXEC.
FORM write_data.
WRITE : / gs_wa-carrid, gs_wa-carrname.
ENDFORM. "WRITE_DATA
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
490 | REPORT z15_12. | sapjoy | 2012.08.01 | 1295 |
489 | REPORT z12_31. | sapjoy | 2012.07.30 | 1312 |
488 | REPORT z03_25. | sapjoy | 2012.07.30 | 1367 |
487 | REPORT z15_24. | sapjoy | 2012.08.01 | 1392 |
486 | REPORT z16_11. | sapjoy | 2012.08.01 | 1398 |
485 | PROGRAM z13_01. | sapjoy | 2012.08.01 | 1410 |
484 | REPORT z04_04. | sapjoy | 2012.07.30 | 1411 |
483 | REPORT z17_13 . | sapjoy | 2012.08.01 | 1426 |
» | REPORT z03_24 [1] | sapjoy | 2012.07.30 | 1428 |
481 | REPORT z04_05. | sapjoy | 2012.07.30 | 1439 |
480 | REPORT z04_02. | sapjoy | 2012.07.30 | 1442 |
479 | REPORT Z04_12. | sapjoy | 2012.07.30 | 1443 |
478 | REPORT z03_26. | sapjoy | 2012.07.30 | 1445 |
477 | REPORT z04_10. | sapjoy | 2012.07.30 | 1479 |
476 | REPORT z04_03. | sapjoy | 2012.07.30 | 1494 |
475 | REPORT Z03_17. | sapjoy | 2012.07.30 | 1495 |
474 | REPORT Z03_18. | sapjoy | 2012.07.30 | 1495 |
473 | REPORT Z03_12. | sapjoy | 2012.07.30 | 1498 |
472 | REPORT z03_11. | sapjoy | 2012.07.30 | 1500 |
471 | REPORT z04_15. | sapjoy | 2012.07.30 | 1500 |
SUBSTR(B.CARRNAME, 1, 8)
SUBSTRING(B.CARRNAME, 1, 8)
으로 해야 오류가 안납니다. 저는 MSSQL 이더라구요 오라클이 아닌 경우 SUBSTRING 으로 해야됩니다.