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
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
190 | REPORT z04_05. | sapjoy | 2012.07.30 | 1439 |
» | REPORT z03_24 [1] | sapjoy | 2012.07.30 | 1428 |
188 | REPORT z17_13 . | sapjoy | 2012.08.01 | 1426 |
187 | REPORT z04_04. | sapjoy | 2012.07.30 | 1411 |
186 | PROGRAM z13_01. | sapjoy | 2012.08.01 | 1410 |
185 | REPORT z16_11. | sapjoy | 2012.08.01 | 1398 |
184 | REPORT z15_24. | sapjoy | 2012.08.01 | 1394 |
183 | REPORT z03_25. | sapjoy | 2012.07.30 | 1367 |
182 | REPORT z12_31. | sapjoy | 2012.07.30 | 1312 |
181 | REPORT z15_12. | sapjoy | 2012.08.01 | 1295 |
180 | REPORT z12_06. | sapjoy | 2012.07.30 | 1294 |
179 | REPORT z16_04. | sapjoy | 2012.08.01 | 1246 |
178 | REPORT Z12_22 | sapjoy | 2012.07.30 | 1226 |
177 | REPORT z15_17. [1] | sapjoy | 2012.08.01 | 1219 |
176 | REPORT z15_23. [1] | sapjoy | 2012.08.01 | 1216 |
175 | REPORT z12_27. | sapjoy | 2012.07.30 | 1208 |
174 | REPORT z15_20. | sapjoy | 2012.08.01 | 1195 |
173 | report Z12_33 | sapjoy | 2012.07.30 | 1193 |
172 | REPORT z15_25. [1] | sapjoy | 2012.08.01 | 1190 |
171 | REPORT z16_10. | sapjoy | 2012.08.01 | 1183 |
SUBSTR(B.CARRNAME, 1, 8)
SUBSTRING(B.CARRNAME, 1, 8)
으로 해야 오류가 안납니다. 저는 MSSQL 이더라구요 오라클이 아닌 경우 SUBSTRING 으로 해야됩니다.