• Getting data from a SQL Server through Cobol – AS/400 application

    I've seen a lot of questions and answers about accessing data from SQL database but I am still not sure of how to handle what I need to do.  I have a Cobol application on our AS/400 that needs to get data from a SQL server. I have an ODBC connection already configured, but not sure how to...

    CWELLSEATON30 pointsBadges:
  • Which iSeries models support P6 processors?

    Hi, we currently have 550 and 825 boxes, I'm assuming they are all P5 processors. Please could you tell me which are the model boxes that would support P6 processors? Thanks in advance.

    harisudhan211,005 pointsBadges:
  • RSTLIB and Journaling

    I am doing a SAVLIB of our Production Data Libraries creating SaveFiles on our Production iSeries, then thru FTP, transferring the SaveFiles to our Development iSeries, then doing RSTLIBs. During the RSTLIBs I get a CPF7085 - Journal QSQJRN already exists and CPF3756 - JRN QSQJRN not restored. It...

    wpoulin2,480 pointsBadges:
  • Print Image File in iSeries

    Hi, I would like to ask for help to use the data type field GRAPHIC in iSeries. Can I save an image file into this field type? If so, how do I do this? I have tried but it always shows an error of character conversion not valid. Please help. Regards, Tony Tam

    Tonytam0 pointsBadges:
  • Lexmark E323 off an iSeries 720

    My Lexmark E323 won't print off the AS/400 even though in the out queue it goes into the writing status after responding "G" in qsysopr. Seems like the output disappears into thin air. Any ideas on what is going on? The printer is on a wired network. It will print from the user's window environment...

    Rrbond07135 pointsBadges:
  • Tuning DB2/400 queries on iSeries

    We are using lot of DB2/400 queries in our iSeries system. Are there any tools available on the market to tune them?

    AS400 - Ask the Expert485 pointsBadges:
  • iSeries on the Web – some pages HTTP, some HTTPS?

    Warning: newbie to web programming and all the security implications. We are developing a small shopping website to be hosted on our iSeries. We will be purchasing an SSL certificate. Only some of our pages need to be encrypted (HTTPS). Most of the pages do not contain sensitive info, so do not...

    Chance105 pointsBadges:
  • Retreiving JOB information (command String) for JOBS waiting in JOB queues on an iSeries

    When we submit a job on an iSeries to a job queue, it gets submitted with a command string. I have a process where I am using APIs to go out and get information on jobs that are on our job queues that are waiting to run. The APIs that I use work great but they do not show me the command string that...

    ISERIESTECH135 pointsBadges:
  • JOBSCDE INQUIRY

    Is there any way to query the JOBSCDE entries to find job names or other keywords without going into each individual entry?

    Dhinton5 pointsBadges:
  • What is XML toolkit for iSeries?

    Hi everybody, Could you tell me what is this? And for what I need this? 5733XT2   V1R2M0      XML Toolkit for IBM System i5 I think that product as necessary for my RPG programs if I want put instructions in XML, and that's all. Could anybody give anything more about this? Thanks, in...

    BUG68235 pointsBadges:
  • List of Outfiles

    I've seen a list of the System Supplied Outfiles in one of the manuals. Can anyone direct me to that manual? Thanks, Bill Poulin

    wpoulin2,480 pointsBadges:
  • Transferring data from one iSeries to another

    We have 2 iSeries Servers, 1 for Production, 1 for Development. I have been asked to refresh our production data libraries on our Development System on a regular basis. My thought is to create a Save File of the data libraries on our Production System then FTP the Save File to our Development...

    wpoulin2,480 pointsBadges:
  • SQL statement using RRN(file) on join pulling only Max(date) records from second file in iSeries

    I am using WebSmart with the I-series data base files. I am joining two data base files receiving the RRN so that I can use the fetch rrn and the fextnext to display one screen at a time in my WebSmart program. I have used this method many times except this time I have a one to many relationship...

    Isjld35 pointsBadges:
  • Twinax Printers on Power 7

    We upgraded from a 9406 570 to a power 7 9117 - 770 server. The problem is we still have 2 important twinax printers which are now not supported. One is a 4234 which has a nic card. We want to try to configure this as a lan printer. Is there any documentation on this?  If this is not possible, can...

    Iseriesnovice10 pointsBadges:
  • i5/OS Upgrade

    I realize how ludicrous this question must sound. However: I want to upgrade my IBM i5/OS from V5R2 to V5R3 (or straight to V5R4) and I don't know how to order a CD of the upgrade. (I don't want to download the upgrade) I do have software support. We bought our existing hardware via IBM Direct so I...

    Selectsoft65 pointsBadges:
  • Modify QINACTITV to a limited number of users

    Sir, how do you configure a limited number of users where the objective is that the session of these users will not automatically sign-off. Because the way i understand it, this is done using WRKSYSVAL SYSVAL(QINACTITV) but this approach will affect all users and this is not what i intend to do. i...

    danmd5systemad370 pointsBadges:
  • User Signed on Notification in iSeries

    Hi. If a user profile already has a CL in the initial program to call parameter and that CL can't be modified to add a sndbrkmsg. Is there another way to have a message sent to the admin that a specific user has just signed on to the iSeries?

    Bsalley15 pointsBadges:
  • What is Partial DST?

    What is Partial DST? and how do we do it with out putting system in Manual mode?

    qmaster1,675 pointsBadges:
  • Copy Spooled File to a Source Physical File Member

    How do I copy a spooled file listing into a member of a source physical file? I accidentally deleted the source member, but have a spooled copy taken via option 6.  I would like to convert the spooled file back into the deleted member.

    Paul10204215 pointsBadges:
  • Restore History Logs and Audit Journal from tape backup

    1. How do you restore History logs and audit journals from tape full system backup (e.g. rstobj qsys/qhst* and rstobj qsys/quadjrn)? 2. Can this be stored in a temporary library without effects on the system? 3. How do you read the logs (history and audjrn)? Thanks!

    Jedlasquite360 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