V5R4

How to install a digital certificate

Has anyone installed a digital certificate on an iSeries lately?  For example, a certificate from VeriSign or GoDaddy.  Can you give me any pointers? After the certificate is installed we need to export it to a Microsoft ISA server which will be the front door for users who need to use our AS/400...

Auto reply for end of forms message PQT4103

Printers send to operator: [strong]Message ID . . . . . . :   PQT4103       Severity . . . . . . . :   99       Message type . . . . . :   Inquiry                                           Date sent  . . . . . . :   10/27/09     ...

SQLCODE = 1077952576

All- I'm getting the above error code from an RPGSQL program. This is just after a DECLARE statement. Other fields in the SQLCA are blank. I can run the statement in Interactive SQL w/o errors. I should be getting a small subset. I get 0 records. Any Ideas?  It's not in the SQLCODE finder. Phil ...

Clear leading zeros

I have a 10A character field which hold a numeric value. Problem is that it contains leading zeros. How can I remove them? Many thanks.   Software/Hardware used: V5R4 iSeries

External DB2 Database link/trigger

In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables. Software/Hardware used: i5 i5/os v5m4

Analyzing Security Audit Journal

Hello, could you please tell me where can I find a book, guide or course about Tracking and Analizing Security Audit Journal on iSeries?  I have tried Appendix F on Security Guide but there are not all entries and it does not explain how to analize records in journal.  Thanks a lot ...

Using prototypes and data structures

How do I convert the following into using prototypes (including the *ENTRY) and /free?? D RDCTL         E DS  EXTNAME(RDCTL)     Software/Hardware used: V5R4 RPG

PKCS#7 certificate

Hi, We have a PKCS#7 certificate(webservice) needs to installed in i5. Could you please provide me the steps for installation. we have done it in windows but now we need to do the same in i5. in windows it was simple which we just copied. but not sure how it works in i5. Please suggest. ...

9117-MMA Performance

WE have recently installed a 9117 MMA p570 which has 11 partitions, 3 of which are iSeries. All disk is on DS6800. Our performance has gone backwards on the Production iSeries partition, runtimes blown out excessively though I have seen some batch jobs running faster. We  have heard thru the...

Retrieve error message in RPG

I have an interactive RPGLE program ,PGMA, that calls another RPG program, RPG3P, based on a parameter and that job is not interactive. If RPG3P aborts how can I find out what the error mesage was? The job log does not give enough information to help find the problem. Software/Hardware used: V5R4

Database member Cross reference in Qsys? - Where's it hidden?

A number of useful objects are in Qsys these days. Items like QADBIFLD are very useful when you want a system wide search for a field. I've been looking for the equivalent for file members. Specifically, I want to search for all occurrences of a given file member name across the system's many...

Problem Running SQLRPGLE program in Batch: Works Fine Interactively

Hello all, We currently have a program that runs in batch. Last night, we had the following error occur: RNQ0103: The target for a numeric operation is too small to hold the result. The program works perfectly when run interactively. When the program was originially written, I compensated for...

CCSID for South Africa

Is there a specific CCSID that need to be used for South Africa? We are running AS/400 V5R4.

RPGIV - numeric field to character field

Experience shows you cannot move a numeric field to a character field using EVAL - so what is the best method? Is Movel the only way? Thanks. Software/Hardware used: iSeries V5.4

iSeries Navigator message monitor failing on endpoint system

After years of working very well, iSeries Nagivator (Ops Nav) refuses to monitor messags on an endpoint iSeries.  This is a recent development.  Its been working just fine on the endpoint in question for the last 3+ years.  The QYPSJSVR job log shows CPFB904 and CPFB905.  Both are running V5R4...

missing Host Application

I am manage several LPAR under OS/400 V5R4M0, at least three of them were created with restore from other one. In those LPARs I can see QIBM_EJB_PRODUCT tree into Host Applications option of Application Administration in iSeries Navigator. The original LPAR have it. The question is, how can I...

6.1 OS

Will RPG IV programs generated using the increase field sizes in 6.1 be able to run on previous versions (i.e. V5R4)?

not a valid Query Management variable.

Hi, can someone please help me, I am trying to use the QMQRY function to run an update statement. I pass it a variable from the program. Get the following error. is not a valid Query Management variable. Error found on STRQMQRY command. Function check. CPF0001 unmonitored by PGMFCTSEC at statement...

Best way to retrieve values, SQL or Queries and how?

Hello everybody, my problem is, in a iseries i have ia file and in this file exist one field with 10000 lenght (character) and i want retrieve a value like (  60F: ) but i don´t know in what position, after i find this value i need the follow values. ex: this is a part of one record  {4: ...

Connection to Iseries for multiple users V5R4

Have shared computer and need to make connection to iseries that works for each user that logs onto the system without having to make same connection manually for each user. Software/Hardware used: Client Express V5R4