• Bad data in as/400 database.. cant display record

    We have a user that insists on using cut and paste to enter data into our system. The problem is bad hex/ascii chars are causing errors trying to retrieve the data. If you try to edit the data using STRDFU it gives the message "The retrieved record contains invalid data." To make things worse you...

    ToddN200056,535 pointsBadges:
  • View spool file without having to window left/right

    While viewing a spooled file is there a way to look at it in one window -- no matter the size of the screen, we have to window left or right -- is there a way to limit the size so that the output displays without having to window?

    Cosmo15 pointsBadges:

    I am converting RPG III code to RPG ILE (brand new to ILE). I have several program where field lengths were assign via the MOVE/MOVEL operations. Is there a way to do that also with the EVAL/EVALR operations or can anyone suggest another. ?    

    Dcarney115 pointsBadges:
  • Displaying data through DSPF and CL programm.!

    I would like to be able to display one record from my PF with DSP file through a CL program on my screen. I have these sources: CL program: ******************************************** QSYSPRT          1  QPADEV0021  USERNAME      pgm              DCLF      ...

    Avrelivs80 pointsBadges:
  • file user open exceptions for printer file

    i'm opening a program defined printer file in SQLRPGLE.. i get error file is already open.... if that is the case, then i'm trying to write in that file but now this gives me exception that attempting to write in closed file...   Please help

    Nutangujar895 pointsBadges:
  • AS/400 Print Job – Save Status

    Does anyone know of a way to always have a print job in the AS/400 to default to SAVE(*YES) status?

    VickiBrewer5 pointsBadges:
  • AS/400 iseries PTF prerequisites

    what are the Perquisites when we will install the PTF

    VenkatPemmasani40 pointsBadges:
  • QCTL

    We have a 9402 model system which not connected with any workstation. Unfortunately it was disabled(hanged). screen has been locked. How can i enable qctl. and how to bring back my system into normal mode? Urgent and important Pls? ThanksIn Advace?

    qmaster1,675 pointsBadges:
  • Need to know the date and time a particular sql command was fired through an interactive session

    Is it possible to find the date and time a particular sql command was entered. Iam able to view the commands entered in an sql session but not able to find the date and time the commands where fired.

    JohnsonMumbai1,365 pointsBadges:
  • SAVSYS vs Daily Backups

    My question is about the AS/400 and SAVSYS. Is it true that a daily backup process backs-up everything that has changed since the last SAVSYS? I’m being told that all changes (including data, programs and patches) are backed up as part of the daily backup. They also tell me that the daily backup...

    Pepper5 pointsBadges:
  • Why do I have such a problem with passing to a program a 8 byte field using a parm.

    Why do I have such a problem with passing to a program a 8 byte field using a parm. Parm field is define as packed(8,0) but as soon as the program tries to acquired the parm I get a Decimal data error. *ENTRY       ...

    nitzinger385 pointsBadges:
  • Copy File from PC file to Iseries- Change record length.

    I am trying to copy a PC text file and copy it in a wrapping format to an ISeries DB File with a single 128 length field. I am trying CPYFRMIMPF, CPYFRMPCD, CPYFRMSTRMF and they all seem to cut off part of the record. Can this be done short of counting characters in a record?

    Brenry5 pointsBadges:
  • Help!! Physical file accidentally deleted, logicals still there. Is there hope?

    I made a HUGE mistake and realized it way too late!! I needed to do a copy of a physical file with *NOMAX on it for the errors because there were 10 corrupted files. Anyway, things went wrong, we restored from backup. Things were back to normal, or so I thought. I got back on the system a couple...

    Kristy112935 pointsBadges:
  • ASNA Datagate vs Client Access

    Hello ... I am looking at developing a VS 200x .net application and want to use DB2 as my datasource. I have been using ASNA's datagate for years (writting classes to retrieve my data). Is it possible to do the same thing using Client Access?? thanks gollnick

    Pgollnic10 pointsBadges:
  • QSECOFR user profile is not allowed in TCP/IP socket mode!

    I am getting an error message when I try to connect to the i5 with a Windows based query application. QSECOFR user profile is not allowed in TCP/IP socket mode! I read a couple of articles, it might has something to do with an FTP restriction on i5 side. Could anyone point me to right direction? I...

    Chabsta85 pointsBadges:
  • Apache HTTP server for AS/400 and OS/400

    I've looked for the download for Apache Tomcat Server HTTP for AS/400 and OS/400, but can only find versions for Windows, Unix and IS/2. Does anyone know the download location?

    Gmil494365 pointsBadges:
  • logical file

    what is the difference between OPNQRYF and LF

    Hemavijay85 pointsBadges:
  • How Can I pass multiple USER ID’s to QEZSNDMG

    Does anyone have an example of passing multple user id's to the API QEZSNDMG?  I have a CL that calls QEZSNDMG and it works fine with one user or *ALLACT.  I need to supply a list of multiple users that I can pass to it.  Anyone have an example of that?

    GaryT50 pointsBadges:
  • BTACH Debug

    How to debug the the Batch JOb without holding it i.e SBMJOB with HOLD(*NO)

    Nandhubunny405 pointsBadges:

    Dear all, i am done one program in this program one data base file which are Master file and it's use all day and lot of records are there, my program make the report it taking too much time, i am want to use OPNQRYF but it s not posible in master file because it's use some time any other option or...

    Nelson01250 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.

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