• Single Page Subfile code

    Hi i have started learning Subfile and i've written a Load All Subfile code to display all the records in a PF. Iit is working fine.But I want to know what else should i include in this code to make it accodring to coding standard. Also i need help in writing the single page Subfile program.So what...

    ITKBHARAT120 pointsBadges:
  • Display only subfile record format

    I am using load all subfile...in that first it will display all records. My question is when i give any condition it has to display empty subfile ie.only subfile record format? plz guide me as early as possible..

    shyedajmal285 pointsBadges:
  • Delete all records from file using SQLRPGLE

    How to delete all the records from file(bpro1) using sqlrpgle?

    Minuvinu35 pointsBadges:
  • Variable not found when calling a SQLRPGLE program

    Variable not found when calling a SQLRPGLE program with parameters in CL program CALL PGM(LIBXYZ/TESTRPG1) PARM(&LIBNAM &FILNAM) here LIBNAM AD FILNAM are passed with VALUES to the SQLRPGLE program and at sql statemet ie. insert INTO LIB/FILl( LIB is having the value and FILL is not getting...

    ravula700 pointsBadges:
  • Problem with updating status of PF1 in SQLRPGLE

    Please help. I am trying to execute the below code but the update doesn't seems to be happening. DDATS E DS EXTNAME(PF1) C/EXEC SQL C+ DECLARE TESTC CURSOR FOR SELECT * FROM PF1 ORDER BY NUMBER C+ FOR UPDATE OF STATUS C/END-EXEC *OPEN the CURSOR C/EXEC SQL C+ OPEN TESTC C/END-EXEC C/EXEC SQL C+...

    juslikdat1440 pointsBadges:
  • What is the difference between using RPGLE and SQLRPGLE when updating a file?

    What is the difference in updating a file using RPGLE or SQLRPGLE?

    mcasantoshrai55 pointsBadges:
  • How to write multiple SQLRPGLE records into a printer file

    C/EXEC SQL C+ SELECT DISTINCT(CTP),COUNT(*) INTO :$Ctp,:#Ctotl FROM CUSTPF C+ GROUP BY CTP C/END-EXEC CTP is CustomerType in Customer File. Here actually I am getting 3 records as output. But I don't know how to write those 3 records into a printer file. Can anybody explain me how to write the...

    Sasikumarr195 pointsBadges:
  • Character in Cast argument not valid

    I need to retrieve the RRN and use it within my RPGLE program. I have the Select RRN(file) statement, but I get a Character in Cast argument not valid when executing. Any suggestions?

    trishahles10 pointsBadges:
  • 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:
  • 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?

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

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

    mvrkrishna535 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:
  • How to login if QSECOFR password is lost

    I am new in AS/400 Administration so I wanna learn more things. Please suggest me how I will be able to login on the system if my QSECOFR password is lost. Also, what are the best books which are available online to learn about LPAR,OS upgradation and AS/400 performance monitoring and resolving...

    JennyMack4,280 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:

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