1
  • Passing Parameters to submitted job

    The CL runs online, displays a prompt screen for report options and then submits itself with the parms now containing the report options from the user's display input. It uses RTVJOBA JOBTYPE to determine if it's running online or in batch.  In either batch or online mode, depending on how the...

    PermanentVacationMan30 pointsBadges:
  • OPNQRY and OVRDBF

    Hi, Can you please tell me more about OPNQRY and OVRDBF and why we are going to use them? Thanks &Regars, Raum

    VENKYAS40075 pointsBadges:
  • What is ovrdbf?

    Hi all, Actually I know OVRDBF is used to override database file. After OVRDBF, we have to use OPENQRY command. But my question is: What purpose this OVRDBF file created and after creation it will be accessible to all the programs at a single time? Meaning can we access OVRDBF file in multiple...

    Sms121185 pointsBadges:
  • How to use OVRDBF to find specific field in my physical file data.

    So right now im trying to make a CLfile that prints out the fields on the SDA fields when i input the field number. For example, i have a customer database which has the fields EMPNO,EMPNAME,COMPNAME ,etc. so by typing the empno (lets say 'A00001' ) in the input field, i want to able to pull the...

    rootlocus5 pointsBadges:
  • JFILE and OPNQRYF

    Hi !I have two PF's named A and B, A is having EMPID,EMPNAM,EMPADDR,etc, here EMPID is the Key field.B is having STKID,STKYR,STKSR,EMPCOD,STKDET,etc, here STKID and STKYR are key fields but not unique, STKSR is unique for a STKID.Now i wanted to display the list of all EMPID and details(if EMPID,...

    Sureyz2,475 pointsBadges:
  • OPNQRYF error in QRYSLT

    PGM DCLF FILE(LIBRARY/DISPLAY) START: SNDRCVF RCDFMT(REC) WAIT(*YES) IF COND(&IN03 *EQ '1') THEN(DO) GOTO CMDLBL(END) ENDDO IF COND(&ENQQUA1 *EQ ' ') THEN(DO) GOTO CMDLBL(START) ENDDO IF COND(&ENQQUA1 *NE *BLANKS) THEN(DO) OPNQRYF FILE((SARKNS/ENQP002)) OPTION(*ALL) +...

    Khadar90 pointsBadges:
  • Run time error when OPNQRY is executed

    I'm getting a run time error when OPNQRY is executed. APGLDT field is numeric and & POST is *CHAR value retrieved from dtaara. Similar is the case with APINVDT. I tried without %DIGITS also and it still doesn't work. OPNQRYF FILE((*LIBL/APH *FIRST *ONLY)) + QRYSLT('%DIGITS(APGLDT) *EQ "' *CAT...

    itanswers0 pointsBadges:
  • Problem with the syntax of OPNQRY command

    Hi I have a problem with the syntax of OPNQRY command I am getting values from a display file using RCVF and then using the qryslt parameter in OPNQRY to select a few records;See the command below OPNQRYF FILE((*LIBL/APH *FIRST *ONLY)) + QRYSLT('APCMPY *EQ ''*CAT XPCMP *CAT''') Where XPCMP(numeric)...

    itanswers0 pointsBadges:
  • CL400/OPNQRY

    I HAVE A CASE LIKE THIS IN CL/400OPNQRYF FILE((MADE07/GLM0120)) QRYSLT('(GLFINP *NE 99) *AND (GLPRDC *EQ "AR" *OR GLPRDC *EQ"SW" *OR GLPRDC *EQ "WP" *OR GLPRDC *EQ "LR" *OR GLPRDC *EQ "MD") *and (glbrnc *eq "%substr(&bc 1 1)")') HERE BC IS A FIELD IN DISPLAY FILE I NEED TO filter data according to...

    Zilan85 pointsBadges:
  • AS400 OPNQRY FILE

    I want to use one non keyed Physical file as keyed file in RPGLE Program. I want to achieve this OPNQRYF Command. Is it possible? If 'Yes', How to compile the RPGLE Program? Eg: File1 - Non Keyed File Program1 I want to use FFILE1IF E K DISK How do i achieve this?

    rajeshece1,215 pointsBadges:
  • CLLE – Openqry Files

    Using opnqry files, we create any key field for physical file for temporarily usage.Instead of creating another logical can i create opnqry? Please give code

    Sudheerk9950 pointsBadges:
  • Odd problem (conversion or openquery?) only appearing in a stored procedure but not when running it adhoc

    Here's the code I can run with no problems: declare @AnneeSelectionnee numeric select @AnneeSelectionnee = 2009 declare @DateDernierImport datetime select @DateDernierImport =  'Nov 14 2008 12:00AM' SELECT     LTRIM(RTRIM(T_ASFSTAG0.STANS1)),     LTRIM(RTRIM(T_ASFSTAG0.STHFO1)),...

    LeftForDead20 pointsBadges:
  • AS400 – RRN of PF

    FILE1 is a PF. I want to read 100th Record directly. I want to perform this operation without using LF, OPNQRY, Native I/O. want to achieve this using RRN value of File. How to code this in RPGLE Program

    rajeshece1,215 pointsBadges:
  • opnqry

    I have four selection parameters in a screen which is used as selection criteria in my opnqry.Ideally if all parameters are given the qryslt in opnqry will have all four fields in the select criteria. Now i have a scenario where if any of the selection parameter is not given in the screen the...

    0 pointsBadges:
  • opnqry

    I need to select a range of dates for a single parameter in opnqry. qryslt(’date *EQ ‘ *CAT &wrkDTE),where date is numeric and wrkDTE is char.here i have just selected 1 day i want data for range of dates Please suggest.

    0 pointsBadges:
  • OPNQRY and WRKQRY

    In wrkqry there is an option to save the selected records to an output file.Similarly is there a way to use OPNQRY in a CL or in an SQLRPG to directly move the selected records to another file?

    0 pointsBadges:
1

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