Re: How to code SQL embebed in RPGIII?
Thanks for support quickly!:-)
- When I use command "GO LICPGM" and take option 10. I look that SQL is installed.
The results as below:
LICENSED INSTALLED
PROGRAM STATUS DESCRIPTION
5722SS1 *COMPATIBLE OS/400 - LIBRARY QGPL
5722SS1 *COMPATIBLE OS/400 - LIBRARY QUSRSYS
5722SS1 *COMPATIBLE OPERATING SYSTEM/400
5722SS1 *COMPATIBLE OS/400 - EXTENDED BASE SUPPORT
5722SS1 *COMPATIBLE OS/400 - ONLINE INFORMATION
5722SS1 *COMPATIBLE OS/400 - EXTENDED BASE DIRECTORY SUPPORT
5722SS1 *COMPATIBLE OS/400 - SYSTEM/36 ENVIRONMENT
5722SS1 *COMPATIBLE OS/400 - SYSTEM/38 ENVIRONMENT
5722SS1 *COMPATIBLE OS/400 - EXAMPLE TOOLS LIBRARY
5722SS1 *COMPATIBLE OS/400 - AFP COMPATIBILITY FONTS
5722SS1 *COMPATIBLE OS/400 - *PRV CL COMPILER SUPPORT
5722SS1 *COMPATIBLE OS/400 - HOST SERVERS
5722SS1 *COMPATIBLE OS/400 - SYSTEM OPENNESS INCLUDES
5722SS1 *COMPATIBLE OS/400 - MEDIA AND STORAGE EXTENSIONS
5722SS1 *COMPATIBLE OS/400 - QSHELL
5722SS1 *COMPATIBLE OS/400 - DOMAIN NAME SYSTEM
5722SS1 *COMPATIBLE OS/400 - PORTABLE APP SOLUTIONS ENVIRONMENT
5722SS1 *COMPATIBLE OS/400 - DIGITAL CERTIFICATE MANAGER
5722AC3 *INSTALLED CRYPTO ACCESS PROVIDER 128-BIT
5722AP1 *COMPATIBLE ADVANCED DBCS PRINTER SUPPORT
5733A19 *INSTALLED 5733-A19 IBM TOOLBOX FOR AS/400 VERSION 4
5722BR1 *COMPATIBLE BACKUP RECOVERY AND MEDIA SERVICES
5722CE3 *INSTALLED CLIENT ENCRYPTION 128-BIT
5722DB1 *INSTALLED AS/400 SYSTEM/38 UTILITIES
5722DG1 *COMPATIBLE IBM HTTP SERVER
5722DG1 *COMPATIBLE TRIGGERED CACHE MANAGER
5722JC1 *COMPATIBLE TOOLBOX FOR JAVA
5722JV1 *COMPATIBLE DEVELOPER KIT FOR JAVA
5722JV1 *COMPATIBLE JAVA DEVELOPER KIT 1.3
5722PT1 *COMPATIBLE PERFORMANCE TOOLS
5722PT1 *COMPATIBLE PERFORMANCE TOOLS - MANAGER FEATURE
5722PT1 *COMPATIBLE PERFORMANCE TOOLS - AGENT FEATURE
5722QU1 *COMPATIBLE QUERY
5722ST1 *COMPATIBLE DB2 QUERY MGR AND SQL DEVKIT
5722TC1 *COMPATIBLE TCP/IP UTILITIES
5722WDS *COMPATIBLE WEBSPHERE DEVELOPMENT STUDIO FOR ISERIES
5722WDS *COMPATIBLE ISERIES TOOLS - APPLICATION DEVELOPMENT
5722WDS *COMPATIBLE ILE RPG
5722WDS *COMPATIBLE SYSTEM/36 COMPATIBLE RPG II
5722WDS *COMPATIBLE SYSTEM/38 COMPATIBLE RPG III
5722WDS *COMPATIBLE RPG/400
5722WDS *COMPATIBLE ILE RPG *PRV COMPILER
5722WDS *COMPATIBLE ILE COBOL
5722WDS *COMPATIBLE SYSTEM/36 COMPATIBLE COBOL
5722WDS *COMPATIBLE SYSTEM/38 COMPATIBLE COBOL
5722WDS *COMPATIBLE OPM COBOL
5722WDS *COMPATIBLE ILE COBOL *PRV COMPILER
5722WDS *COMPATIBLE ILE C
5722WDS *COMPATIBLE ILE C++
5722WDS *COMPATIBLE IXLC FOR C/C++
5722WDS *COMPATIBLE WEBSPHERE DEV STUDIO CLIENT - SERVER SUPPORT
5722XE1 *COMPATIBLE ISERIES ACCESS FOR WINDOWS
5722XW1 *COMPATIBLE ISERIES ACCESS FAMILY
5722XW1 *COMPATIBLE ISERIES ACCESS ENABLEMENT SUPPORT
1BPCS82 *INSTALLED BPCS V8.2.00 (c) SSA Global Technologies 2003
1BPCS82 *INSTALLED BPCS V8.2.00 (c) SSA Global Technologies 2003
But I do not know "use iseries navigator or client access to export it in proper format" as your description. Please help me use what tool to export it! I do not have experience!
- I changed type from SQLRPG -> RPGILE and compile with CRTRPGPGM and the error still happend as my description above:
M E S S A G E S U M M A R Y
* QRG5006 SEVERITY: 10 NUMBER: 6
MESSAGE . . . . : NOT ENTRY NOT N OR BLANK.
* QRG5007 SEVERITY: 10 NUMBER: 7
MESSAGE . . . . : CONDITIONING-INDICATOR ENTRY INVALID.
* QRG5008 SEVERITY: 30 NUMBER: 1
MESSAGE . . . . : THE FACTOR 1 FIELD-NAME ENTRY IS NOT VALID.
* QRG5015 SEVERITY: 30 NUMBER: 3
MESSAGE . . . . : OPERATION ENTRY BLANK. SPECIFICATION IGNORED.
* QRG5175 SEVERITY: 20 NUMBER: 3
MESSAGE . . . . : THE CONTROL-LEVEL ENTRY IS INVALID FOR A
SUBROUTINE-CALCULATION SPECIFICATION.
* QRG7031 SEVERITY: 00 NUMBER: 17
MESSAGE . . . . : THE NAME OR INDICATOR IS NOT REFERENCED.
* QRG7086 SEVERITY: 00 NUMBER: 2
MESSAGE . . . . : RPG HANDLES BLOCKING FUNCTION FOR FILE. INFDS
.....
- I compiled my embebed program by using CRTRPGPGM, as arrow483 description. I try to use "CRTRPGSQL" command, but system show error:
COMMAND CRTRPGSQL IN LIBRARY *LIBL NOT FOUND.
I seem there is not this command in my AS400 system.
Thanks for all. What libraries, or tools do I need?
Thanks for support quickly!:-)
- When I use command "GO LICPGM" and take option 10. I look that SQL is installed.
The results as below:
LICENSED INSTALLED
PROGRAM STATUS DESCRIPTION
5722SS1 *COMPATIBLE OS/400 - LIBRARY QGPL
5722SS1 *COMPATIBLE OS/400 - LIBRARY QUSRSYS
5722SS1 *COMPATIBLE OPERATING SYSTEM/400
5722SS1 *COMPATIBLE OS/400 - EXTENDED BASE SUPPORT
5722SS1 *COMPATIBLE OS/400 - ONLINE INFORMATION
5722SS1 *COMPATIBLE OS/400 - EXTENDED BASE DIRECTORY SUPPORT
5722SS1 *COMPATIBLE OS/400 - SYSTEM/36 ENVIRONMENT
5722SS1 *COMPATIBLE OS/400 - SYSTEM/38 ENVIRONMENT
5722SS1 *COMPATIBLE OS/400 - EXAMPLE TOOLS LIBRARY
5722SS1 *COMPATIBLE OS/400 - AFP COMPATIBILITY FONTS
5722SS1 *COMPATIBLE OS/400 - *PRV CL COMPILER SUPPORT
5722SS1 *COMPATIBLE OS/400 - HOST SERVERS
5722SS1 *COMPATIBLE OS/400 - SYSTEM OPENNESS INCLUDES
5722SS1 *COMPATIBLE OS/400 - MEDIA AND STORAGE EXTENSIONS
5722SS1 *COMPATIBLE OS/400 - QSHELL
5722SS1 *COMPATIBLE OS/400 - DOMAIN NAME SYSTEM
5722SS1 *COMPATIBLE OS/400 - PORTABLE APP SOLUTIONS ENVIRONMENT
5722SS1 *COMPATIBLE OS/400 - DIGITAL CERTIFICATE MANAGER
5722AC3 *INSTALLED CRYPTO ACCESS PROVIDER 128-BIT
5722AP1 *COMPATIBLE ADVANCED DBCS PRINTER SUPPORT
5733A19 *INSTALLED 5733-A19 IBM TOOLBOX FOR AS/400 VERSION 4
5722BR1 *COMPATIBLE BACKUP RECOVERY AND MEDIA SERVICES
5722CE3 *INSTALLED CLIENT ENCRYPTION 128-BIT
5722DB1 *INSTALLED AS/400 SYSTEM/38 UTILITIES
5722DG1 *COMPATIBLE IBM HTTP SERVER
5722DG1 *COMPATIBLE TRIGGERED CACHE MANAGER
5722JC1 *COMPATIBLE TOOLBOX FOR JAVA
5722JV1 *COMPATIBLE DEVELOPER KIT FOR JAVA
5722JV1 *COMPATIBLE JAVA DEVELOPER KIT 1.3
5722PT1 *COMPATIBLE PERFORMANCE TOOLS
5722PT1 *COMPATIBLE PERFORMANCE TOOLS - MANAGER FEATURE
5722PT1 *COMPATIBLE PERFORMANCE TOOLS - AGENT FEATURE
5722QU1 *COMPATIBLE QUERY
5722ST1 *COMPATIBLE DB2 QUERY MGR AND SQL DEVKIT
5722TC1 *COMPATIBLE TCP/IP UTILITIES
5722WDS *COMPATIBLE WEBSPHERE DEVELOPMENT STUDIO FOR ISERIES
5722WDS *COMPATIBLE ISERIES TOOLS - APPLICATION DEVELOPMENT
5722WDS *COMPATIBLE ILE RPG
5722WDS *COMPATIBLE SYSTEM/36 COMPATIBLE RPG II
5722WDS *COMPATIBLE SYSTEM/38 COMPATIBLE RPG III
5722WDS *COMPATIBLE RPG/400
5722WDS *COMPATIBLE ILE RPG *PRV COMPILER
5722WDS *COMPATIBLE ILE COBOL
5722WDS *COMPATIBLE SYSTEM/36 COMPATIBLE COBOL
5722WDS *COMPATIBLE SYSTEM/38 COMPATIBLE COBOL
5722WDS *COMPATIBLE OPM COBOL
5722WDS *COMPATIBLE ILE COBOL *PRV COMPILER
5722WDS *COMPATIBLE ILE C
5722WDS *COMPATIBLE ILE C++
5722WDS *COMPATIBLE IXLC FOR C/C++
5722WDS *COMPATIBLE WEBSPHERE DEV STUDIO CLIENT - SERVER SUPPORT
5722XE1 *COMPATIBLE ISERIES ACCESS FOR WINDOWS
5722XW1 *COMPATIBLE ISERIES ACCESS FAMILY
5722XW1 *COMPATIBLE ISERIES ACCESS ENABLEMENT SUPPORT
1BPCS82 *INSTALLED BPCS V8.2.00 (c) SSA Global Technologies 2003
1BPCS82 *INSTALLED BPCS V8.2.00 (c) SSA Global Technologies 2003
But I do not know "use iseries navigator or client access to export it in proper format" as your description. Please help me use what tool to export it! I do not have experience!
- I changed type from SQLRPG -> RPGILE and compile with CRTRPGPGM and the error still happend as my description above:
M E S S A G E S U M M A R Y
* QRG5006 SEVERITY: 10 NUMBER: 6
MESSAGE . . . . : NOT ENTRY NOT N OR BLANK.
* QRG5007 SEVERITY: 10 NUMBER: 7
MESSAGE . . . . : CONDITIONING-INDICATOR ENTRY INVALID.
* QRG5008 SEVERITY: 30 NUMBER: 1
MESSAGE . . . . : THE FACTOR 1 FIELD-NAME ENTRY IS NOT VALID.
* QRG5015 SEVERITY: 30 NUMBER: 3
MESSAGE . . . . : OPERATION ENTRY BLANK. SPECIFICATION IGNORED.
* QRG5175 SEVERITY: 20 NUMBER: 3
MESSAGE . . . . : THE CONTROL-LEVEL ENTRY IS INVALID FOR A
SUBROUTINE-CALCULATION SPECIFICATION.
* QRG7031 SEVERITY: 00 NUMBER: 17
MESSAGE . . . . : THE NAME OR INDICATOR IS NOT REFERENCED.
* QRG7086 SEVERITY: 00 NUMBER: 2
MESSAGE . . . . : RPG HANDLES BLOCKING FUNCTION FOR FILE. INFDS
.....
- I compiled my embebed program by using CRTRPGPGM, as arrow483 description. I try to use "CRTRPGSQL" command, but system show error:
COMMAND CRTRPGSQL IN LIBRARY *LIBL NOT FOUND.
I seem there is not this command in my AS400 system.
Thanks for all. What libraries, or tools do I need?
Comment