Not Running SQLRPGLE

[debdas]

Hi Experts,

One strange thing which I am unable to solve, we have two AS/400 servers 170 and 270.

I have written one program on SQLRPGLE which is executable on 170 (V4R4M0) and not on 270 (V5R1M0). Its neither showing any errors while compiling nor executing.

Please tell me what could be the reasons …

 

[RedMage1967]

On which iSeries did you write the program on?

RedMage1967
IBM Certifed - RPG IV Progammer

 

[as400pro]

Is it possible the program is running but not selecting any data for processing?
Did you verify you have data on the system that meets the SELECTion criteria?

 

[debdas]

Older one is 170 & new one is iseries 270.

While doing DSPLICPGM on both servers

on 170
5769RG1 *COMPATIBLE ILE RPG for AS/400

on iseries 270
5722WDS *COMPATIBLE Compiler - ILE RPG IV


I cannot find "ILE RPG for AS/400" on iseries 270 is it because of that ????

 

[iSeriesCodePoet]

In 5.1 the compilers got rename to WebSphere Development Studio (or something like that). Thus the WDS. RPG, COBOL, C, and C++ are all included in this price. That was first introduced in 4.5. I guess one question would be if you have SQL on both machines. To compile SQL, you need the SQL licensed program installed.

iSeriesCodePoet
IBM iSeries (AS/400) Programmer

Want to have all your bookmarks in one spot?

http://www.koldark.net/bookmark4u/

 

[debdas]

Can you please name the SQL licensed program

I am listing you what we have. Please point me out

Program Status Description
5798RZG *INSTALLED AS/400 Service Agent
5722XW1 *COMPATIBLE Client Access Enablement Support
5722XW1 *COMPATIBLE Client Access Family for Windows
5722XE1 *COMPATIBLE Client Access/400 Express for Windows
5722WDS *COMPATIBLE Compiler - ILE C
5722WDS *COMPATIBLE Compiler - ILE C *PRV
5722WDS *COMPATIBLE Compiler - ILE C++
5722WDS *COMPATIBLE Compiler - ILE C++ *PRV
5722WDS *COMPATIBLE Compiler - ILE COBOL
5722WDS *COMPATIBLE Compiler - ILE COBOL *PRV
5722WDS *COMPATIBLE Compiler - ILE RPG IV
5722WDS *COMPATIBLE Compiler - ILE RPG IV *PRV
5722WDS *COMPATIBLE Compiler - OPM COBOL
5722WDS *COMPATIBLE Compiler - RPG/400
5722WDS *COMPATIBLE Compiler - System/36 Compatible COBOL
5722WDS *COMPATIBLE Compiler - System/36 Compatible RPG II
5722WDS *COMPATIBLE Compiler - System/38 Compatible COBOL
5722WDS *COMPATIBLE Compiler - System/38 Compatible RPG III
5722ST1 *COMPATIBLE DB2 Query Mgr and SQL DevKit
5722JV1 *COMPATIBLE Developer Kit for Java
5722DG1 *COMPATIBLE IBM HTTP Server
5722WDS *COMPATIBLE IBM Open Class - source and samples
5722WSV *COMPATIBLE Integration for Windows 2000
5722WSV *COMPATIBLE Integration for Windows NT 4.0
5722WSV *COMPATIBLE Integration for Windows Server
5722JV1 *COMPATIBLE Java Developer Kit 1.1.8
5722JV1 *COMPATIBLE Java Developer Kit 1.2
5722SS1 *COMPATIBLE Operating System/400
5722SS1 *COMPATIBLE OS/400 - Digital Certificate Manager
5722SS1 *COMPATIBLE OS/400 - Directory Services
5722SS1 *COMPATIBLE OS/400 - Domain Name System
5722SS1 *COMPATIBLE OS/400 - Extended Base Directory Support
5722SS1 *COMPATIBLE OS/400 - Extended Base Support
5722SS1 *COMPATIBLE OS/400 - Host Servers
5722SS1 *BACKLEVEL OS/400 - Library QGPL
5722SS1 *BACKLEVEL OS/400 - Library QUSRSYS
5722SS1 *COMPATIBLE OS/400 - Online Information
5722SS1 *COMPATIBLE OS/400 - QShell Interpreter
5722TC1 *COMPATIBLE TCP/IP Connectivity Utilities
1TMELCF *INSTALLED Tivoli Management Agent
5722JC1 *COMPATIBLE Toolbox for Java
5722WDS *COMPATIBLE Tools - Application Development
5722DG1 *COMPATIBLE Triggered Cache Manager
5722WDS *COMPATIBLE WebSphere Development ToolSet
5722WDS *COMPATIBLE Workstation Tools - Base
5722WDS *COMPATIBLE Workstation Tools - VisualAge for Java
5722WDS *COMPATIBLE Workstation Tools - VisualAge RPG
5722WDS *COMPATIBLE Workstation Tools - WebFacing, CODE
5722WDS *COMPATIBLE Workstation Tools - WebSphere Studio

 

[as400pro]

The following is your SQL product,
5722ST1 *COMPATIBLE DB2 Query Mgr and SQL DevKit


T. Bishop

http://www.as400pro.com

 

[debdas]

If it is there then WHY it is not executing ???

even simple SQLRPGLE IS NOT EXECUTING

Sample Program

C/exec sql
C+ INSERT INTO dastest/item
C+ select mmcono,mmitno
C+ from mitmas
C/end-exec
C
C/exec sql
C+ commit
C/end-exec
C

 

[iSeriesCodePoet]

So you can compile it?

iSeriesCodePoet
IBM iSeries (AS/400) Programmer

Want to have all your bookmarks in one spot?

http://www.koldark.net/bookmark4u/

 

[debdas]

Yes, I can compile it, if I give DSPLY statement before and after SQL it displays on the screen, but not executing SQL statement

 

[iSeriesCodePoet]

Sorry for sounding so basic. I just want to have all the details.

So what happens when you run it in debug? Step through your "basic program" and see what happens after every statement. Check the variable SQLCOD after every SQL command and see if there is any other status codes.



You can email me privately "mnwills AT taylorcorp DOT com" if you want a more immediate response. Then we can post the results out here.

iSeriesCodePoet
IBM iSeries (AS/400) Programmer

Want to have all your bookmarks in one spot?

http://www.koldark.net/bookmark4u/

 

[tcsbiz]

How about writing a quick old-style RPG program with mitmas as your INPUT-PRIMARY FILE (... horrors... he's suggesting using the cycle...) and item as your OUTPUT file.

For each read cycle of mitmas, write one to item.

This would be a quick test using a different method.

Tom.

"It may be just an opinion but it is MY opinion."

 

[tcsbiz]

Is mitmas a logical file pointing to the wrong physical file that has no data?