• Portlet Factory connection to iSeries data

    I am working on a model using WebSphere portlet factory that I cannot get to connect to the data on our iSeries. Does anyone have the Server Administrative Console setup required for this connection? Are there any other configuration elements that are needed? Thanks! Carolyn

    ITKE357,070 pointsBadges:
  • AS/400 printing – DDS spec PAGRTT in record format definitions

    What do they mean when they say you must be 'on the page boundary' for this keyword (PAGRTT) to function? How can I check if I'm there or not? I would like to have one page in my printer file print portrait and the next in landscape, but PAGRTT doesn't work.

    JohnnyMooch35 pointsBadges:
  • VBA code to transfer data from iSeries to Excel

    Hi everyone, could someone provide VBA code to automate the Transfer of data from the iSeries into an Excel 2003 Spreadsheet. Currently we have to manually use the iSeries Excel Add-In. All fields are left default except the Library/File field where we enter PRODDTA/F56EXT. The data then transfers...

    Mblair.au25 pointsBadges:
  • iSeries HMC Console Connectivity Problem

    Hi When i tried to connect my iSeries Hmc Console,I'm getting "0043 Connected - waiting for screen data",Now,I don't have access to the box.I have submitted a FULLSYSTEM backup in restricted mode,while it was in progress,my console got disconnected ang getting the above said message while getting...

    qmaster1,675 pointsBadges:
  • Block Crystal Reports from iSeries access

    We have a user who wants to use Crystal Reports to access data on an MS SQL server. She also has access to view limited data on the iSeries using an iSeries application with built-in security. How can we prevent her from accessing data on the iSeries using Crystal Reports. Is there a service we can...

    WoodEngineer6,945 pointsBadges:
  • SCP From iSeries to iSeries

    Hello All, Can someone help me on following Secure File Transfer issue: I want to Copy document existing in IFS from One iSeries to another iSeries server using SCP, both the servers are in the same network. I have SSHD running on host. I have followed following steps to transfer file, (I have used...

    sim400305 pointsBadges:
  • V5R4 IBM support

    Hi all - does anyone know when IBM will cease to support V5R4 of the iSeries operating system?

    Bristoldoug45 pointsBadges:
  • Sorting an array by two elements

    I want to sort and array by data and then by ship via, both elements of an Order Array. Does anyone know a way that I can sort at two levels in the Array?

    APierce215 pointsBadges:
  • Retrieve AS/400 User Profile

    How to use the QSYRUSRI API with the iSeries?

    BGramby15 pointsBadges:
  • SMTP and internet mail

    Using the SNDDST command on an iSeries with Notes mail. Recently had to switch to HA box (don't ask..). Made all the SMTP command changes, ended the server and restarted. Cannot send internet mail. Returns NOT ABLE TO DELIVER MAIL, 554. FIrst was using our backup mail server (not defined on...

    GirlScout10 pointsBadges:
  • SQLRPGLE – How to override data set data structure at run time

    I currently have an SQLRPGLE routine that receives a SELECT statement as a parameter and then fetches the data set into a data structure based on the file. This only works over a single file as the datastructure is created at compile time and has to be based on filea. I would like to make this...

    NarkedDiver20 pointsBadges:
  • Send mutiple spool files via single

    Could somebody guide me above much appreciated (sample program much appreciated). Appreciate if somebody can send me sample code of 'QtmmSendMail'. Thanks in advance!

    Tilan10 pointsBadges:
  • RPG free array processing problem

    If you've seen this question before it's because when I add my code and submit and view it, it is unreadable. I'm trying to get a "clean" representation of my question. Thanks for your patience. I have loaded a data structure from a database file with three 3 byte fields, i.e. 100101102. It loads...

    SKF75 pointsBadges:
  • SMS Direct from iSeries

    Hi, Is there any simple ways to send SMS from a phone connected to ISeries? By Java, RPG or cheap program? We just need a simple system to send only. Regards, Hamish

    Hamish Vietnam5 pointsBadges:
  • Work function usage commands gives list of users with access

    Work function usage commands gives list of users with access , are these stored in any file as we can only get display output of these files and not data output. This we require as we need to match the data with other files in the system.

    JohnsonMumbai1,200 pointsBadges:
  • Passing parms to Query400

    Has anyone ever come across a method of passing a parm into a query run - such as a date?

    Abbey120 pointsBadges:
  • Need Help With QMHRCVM – Receive Nonprogram Message API

    Need Help With QMHRCVM - Receive Nonprogram Message API.  I am having problems with the parameters (4 BYTES)  Can someone help? D ERRORDS         DS                  INZ      D  BYTESPROV              1      4B 0 INZ(116) D ...

    jldunn55 pointsBadges:
  • Using Query/400 to create SQL-style GROUP BY

    Greetings and salutations, I'm trying to put together a query for one of my users to track sales numbers and it is starting to give me a headache. I've put together a query using Query/400 with a break at each invoice to sum the dollar amount for each one. The issue is that on many of our invoices,...

    Kyoojin0 pointsBadges:
  • Running the API (QUSLSPL) List Spool FIles

    I have downloaded an RPG example program where the program creates a user space with the API (QUSCRTUS) and then calls the API (QUSLSPL) to list spool files. This program runs fine I run it for *CURRENT as the user parm. I want to run it for *ALL users to get a list of all spool files on our system...

    ISERIESTECH135 pointsBadges:
  • PDF Mapping Program Email Activity Log in iSeries

    Using PDF Mapping program as the PDF User Program in a PSFCFG object. Modified program to write a log when an email with PDF attachment is created. Program is called from within PSFCFG twice each time - but I only need one record, anyone have any suggestions or has anyone resolved this problem in...

    Kdbwheels180 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following