• How to write SQLRPGLE query with many select criteria

    I have a report to print using SQLRPGLE. The Report criteria screen has around 15-20 select conditions. Based on the conditions entered by the user, I build a query of type: Select * from emp1 where val1 = ? and val2 =? and val3 = ? and........... This is the first time I'm dealing with so many...

    Nutangujar895 pointsBadges:
  • Best SmartForms learning resources

    I am starting my carrier as a ABAPer and my first project involves working in SmartForms. I'm not trained in it. Are there any books or sites on the internet from where I can get really good material to start with? It should start from basics and move into advance stuff in SmartForms. I would...

    Shafiqrahman0 pointsBadges:
  • Delete a record from COBOL/400 file

    In COBOL/400 PGM the file has been declared with ACCESS as SEQUENTIAL and ORGANIZATION as SEQUENTIAL. How to delete a record from such file?

    mvrkrishna555 pointsBadges:
  • How to invoke an auto start job in COBOL/400?

    How can I invoke an auto start job in COBOL/400 application?

    mvrkrishna555 pointsBadges:
  • Replace 1 character in a string with 1 or more characters in COBOL/400

    I want to replace 1 character in a string with 1 or more characters in COBOL/400. How can i perform this? Example: 1) A with ABC 2)A with ABCDE 3)A with A Etc.

    C.naveen09140 pointsBadges:
  • What’s the future of SAP in the industry?

    Hi, I'm a COBOL programmer working on mainframes with a work experience of 2 yrs. I've worked with technologies like JCL, COBOL, VSAM, DB2, IMS DB/DC, IDMS, FOCUS etc. I have an opportunity to get into SAP technical (ABAP/4) as a programmer in my organisation. Looking at the future prospects of the...

    ABAPer920 pointsBadges:
  • iSeries Navigator goes down when printing

    I just installed Client Access 5.2 on a Win XP PC (I am successfully tunning this level on other PCs with the same OS) and whenever I try to print in Navigator, CWBUNNAV.EXE "encounters a problem" and brings down Navigator. I need help.

    Ace910 pointsBadges:
  • CL or EXIT program to find iSeries navigator users

    How can I find iSeries navigator users? Is there any EXIT program or can I use any CL for this?

    Maltaf65 pointsBadges:
  • Identifying users of the iSeries Navigator

    How can i find how many users and who are using the iSeries Navigator. Can I use any exit program?

    Maltaf65 pointsBadges:
  • Download physical file from AS/400 to text file using FTP

    How to download PF from AS400 to text file in PC? I tried reflection.. It worked but having issues with larger files. I tried FTP command get from system. But the text file obtained has lot of special characters which are not present in the database. I gave the conversion mode as ASCII. Any other...

    vibgyor280 pointsBadges:
  • Retain leading zeroes with CPYTOIMPF

    I am copying a PF from the iSeries (V5R3M0) using Cpytoimpf, within the file is an alpha field with leading zeros. When the file is opened in Excel it drops the leading zeros. Assuming it is a numeric field, is there any way to retain the leading zeros?

    AmandaC30 pointsBadges:
  • CPYTOIMPF for copying spool file to IFS

    I want to copy a spool file to the IFS. I tried ===> CPYTOIMPF FROMFILE(FILES/SPRINT198) TOSTMF('print/testprint.txt') STMFCCSI D(*STDASCII) RCDDLM(*CRLF) DTAFMT(*FIXED) and I got nothing.

    Deon5 pointsBadges:
  • CPYTOIMPF error code 3025

    I am new to AS/400 and I wanted to transfer a file from AS/400 to PC using CPYTOIPMF as per advised here. But I am receiving an error, "File system error occurred" (Error number 3025) What's wrong?

    Radycal45 pointsBadges:
  • Using CPYTOIMPF to copy records from a physical file to an Excel book

    CPYTOIMPF FROMFILE(SARKNS/ENQP003) TOSTMF('C:/Documents and Settings/user/exc.xls') MBROPT(*REPLACE) RCDDLM(*LF) DTAFMT(*iso) Here I have created an Excel book with name exc.xls. My requirement is to copy all the records from my physical file (sarkns/enqp003) to the desired Excel book. When I run...

    Chrisjam95 pointsBadges:
  • CPYTOIMPF error code 7

    When i enter this command I find this error:CPYFRMIMPF FROMSTMF('/new_recon_conv.csv') TOFILE(NAVNEET/TT4 TT4) MBROPT( *REPLACE) RCDDLM(*CRLF) STRDLM('"') FLDDLM('|') DATFMT(*USA) RPLNULLVAL(*F LDDFT) The copy did not complete for reason code 7. What should I do?

    Kapiltiwari350 pointsBadges:
  • RPG/400 filename length

    I have a physical file name with length of 10. I need to declare the same file in RPG/400 but here accepting only 8 length. Any way to overcome this?

    Askt265 pointsBadges:
  • Hold all AS/400 print jobs for the same user

    How can I hold all the print jobs in the AS/400 for just one user, then have the same user to release all her jobs whenever she wants to print?

    Querys100 pointsBadges:
  • What is the difference between a logical file and view in DB2/400?

    What is the difference between logical file and View in DB2/400?

    rajeshece1,215 pointsBadges:
  • What is the difference between physical and logical reads in DB2/400?

    When we do DSPFD for a file it shows physical and logical reads. What is the difference between physical and logical reads?

    Kajeeva10 pointsBadges:
  • Display records in ascending order in DB2/400 physical file

    I have created one physical file with 1 key field. After that I added some data in that file. Records in the file are displayed in arrival order. While viewing the records using DSPPFM, STRSQL commands. As per my assumption, it should be ascending order. Why it is not displaying in ascending order?

    rajeshece1,215 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