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?
Answer Question | February 19, 2013 7:31 PM
AS/400, Business Intelligence, Data warehouse
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…
Answer Question | February 18, 2013 7:14 PM
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.
Answer Question | February 15, 2013 3:27 PM
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…
Answer Question | February 15, 2013 5:13 AM
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…
Answer Question | February 15, 2013 2:04 AM
Does anybody have an example of Self-Join Logical File code?
Answer Question | February 14, 2013 10:50 AM
AS/400, DB2 database
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
Answer Question | February 14, 2013 8:29 AM
AS/400, AS/400 database, VB .NET
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
Answer Question | February 13, 2013 10:12 AM
AS/400, AS/400 journaling
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…
Answer Question | February 13, 2013 10:03 AM
API, AS/400, COBOL 400
How to print the fields in bold letters in printer file? Can you give me a sample program?
Answer Question | February 13, 2013 6:37 AM
AS/400, AS/400 printing
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?
Answer Question | February 13, 2013 4:08 AM
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…
Answer Question | February 12, 2013 1:36 PM
KFLD, KLIST, RPG Program
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.
Answer Question | February 12, 2013 8:53 PM
5250 emulation, iSeries
How do you print shading in RPG?
Answer Question | February 11, 2013 8:09 PM
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.
Answer Question | February 11, 2013 12:44 PM
AS/400, AS/400 administration
Is there a date format like this dd/mm/yyyy?
Answer Question | February 13, 2013 11:44 AM
AS/400, AS/400 administration
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…
Answer Question | February 11, 2013 9:19 AM
AS/400, OPNQRYF, STRSQL
RPGLE object was changed and we can see it is DSPOBJD. We want to know who had changed the object? Thanks in advance.
Answer Question | February 11, 2013 7:17 AM
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?
Answer Question | February 11, 2013 2:18 PM
AS/400, iSeries, SAVSECDTA
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…
Answer Question | February 8, 2013 4:27 AM
Data structures, iSeries