We are using KBM software for our ERP system. We have a mandate to build a data warehouse so we can use a good BI tool to extract data. We would like to run this on our AS400. Does anyone have suggestions as to a good product for us to investigate?

I have a function (I did not write it) that is calling a subroutine from def_break command and one field that is defined on the def_break command is not being cleared when break occurs. The last value of this field just repeats on the next break line. I ran this function under a debug and…

We have an OUTQ which got deleted yesterday, however we tried checking thru DSPJRNE and other means as LOGs, however it doesn’t show up. The only thing which comes in the log is when the writer has ended. The obj deletion is not coming up.

Hi, Does RPGLE triggers can be added to the tables? I created a Table and RPGLE Trigger. But I am getting error saying ‘Receiver too small to hold the result’. But the same code is accepting the physical files. Do I need to set any attributes while creating the RPGLE triggers or tables? Please suggest…

Please help. I am trying to execute the below code but the update doesn’t seems to be happening. DDATS E DS EXTNAME(PF1) C/EXEC SQL C+ DECLARE TESTC CURSOR FOR SELECT * FROM PF1 ORDER BY NUMBER C+ FOR UPDATE OF STATUS C/END-EXEC *OPEN the CURSOR C/EXEC SQL C+ OPEN TESTC C/END-EXEC C/EXEC SQL C+ FETCH…

Does anybody have an example of Self-Join Logical File code?

Hi all. Here I’m using iSeries Server. I just want to connect VB.NET with AS/400 database. Simply I want to retrieve some data from a PF on VB.NET. Anybody can you tell me what is the connection string should be used? If you have any simple sample code in VB.NET please post here… Surey

Hi experts, Does Hibernate require AFTER and BOTH the Images of Journalling (Journalled files). Please let us know. Or After image alone is enough for Hibernate? AFTER or BOTH images is better to use for database? Thanks , Amutha

I want to list all the Job Schedule entries and save them in a Physical file , I used API QWCLSCDE to fetch that list in a User Space , then I did a QUSRTVUS to load the data in my COBOL program. As the variable Starting position and Length of data are Binary, and…

How to print the fields in bold letters in printer file? Can you give me a sample program?

Is there any way to prevent the message subfile to have the system generated messages? I have a monitor block in my program and the message tracked by the on-error block is appearing to the user through the message subfile, I dont want this to happen. Any suggestions?

Hi, I’m debugging an RPG program and came across a ‘KLIST ‘ with ‘KFLDS’. What I know so far is that a KLIST is used as a search argument and KFLDS make up the argument, but what I want to know is how does this actually work? Are the KFLDS concentrated to make up one…

I am running 5250 emulation on a PC.  It was running fine until today because now I receive an error remote address could not be resolved.

How do you print shading in RPG?

I got a request asking for reconfiguring the AP and an IP address is given in the request. I am not aware of what is AP and how to reconfigure it.

Is there a date format like this dd/mm/yyyy?

Like we select fields in STRSQL, is there a way I can specify the fields I want in OPNQRYF? Say I have 40 fields in my file, but I am interested in 10 fields and wanted to make a CSV out of it. Can I achieve this with OPNQRYF instead of creating another file with…

RPGLE object was changed and we can see it is DSPOBJD. We want to know who had changed the object? Thanks in advance.

When restoring SAVSECDTA (240 user profiles) on iSeries, 220 profiles restored and 20 authorization lists were restored. This obviously equals my total number of saved profiles but I don’t see the total number of profiles on the restored system. Any idea why this is happening?

I would like to have sample code on the OPCODE LIKEREC with all its parameters like with *All and *KEY and *INPUT and *OUTPUT. Also, I want to know whether OPCODE EVAL-CORR in iSeries or not  because when I want to transfer data from one DS (Data Structure) to another DS using EVAL-CORR, I’m getting…