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 purrpose this OVRDBF file created and After creation it will accessible to all the programs at a single time , Means can we access OVRDBF file in [...]

Answer Question   |  March 3, 2011  12:28 PM
AS400/OPNQRYF, CLP, OPNQRY, OVRDBF

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

Answer Question   |  September 22, 2010  9:07 AM
AS/400, CLLE, CLLE - Opnqryf, Open Query, Open Query File, OPNQRY, Physical Files

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 user wants to run it, it [...]

Answer Question   |  August 5, 2010  2:38 AM
AS/400, OPNQRY

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?

Answer Question   |  October 1, 2010  6:51 PM
OPNQRY, OPNQRYF, RPGLE Program

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)), LTRIM(RTRIM(T_ASFSTAG0.STRSP1))    FROM T_ASFSTAG0    WHERE   (T_ASFSTAG0.STANS1=@AnneeSelectionnee) AND     ((isdate(T_ASFSTAG0.STCRT1)=1 and convert(datetime,convert(varchar,T_ASFSTAG0.STCRT1,103),103)>=convert(datetime,convert(varchar,@DateDernierImport,103),103)) or     (isdate(T_ASFSTAG0.STMAJ1)=1 and convert(datetime,convert(varchar,T_ASFSTAG0.STMAJ1,103),103)>=convert(datetime,convert(varchar,@DateDernierImport,103),103))) Please note that T_ASFSTAG0 is a view [...]

Answer Question   |  September 18, 2009  8:48 AM
Linked Server, OPNQRY, SQL 2000

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

Answer Question   |  January 20, 2009  11:43 AM
OPNQRY, PF, RPGLE, RPGLE Program, RRN

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 branch code(bc) from [...]

Answer Question   |  May 20, 2011  12:07 PM
CL/400, OPNQRY, OPNQRYF

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 qryslt [...]

Answer Question   |  December 29, 2008  12:19 PM
OPNQRY

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.

Answer Question   |  December 29, 2008  12:18 PM
OPNQRY

opnqry
Am getting a runtime 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 doesnt work. OPNQRYF FILE((*LIBL/APH *FIRST *ONLY)) + QRYSLT(‘%DIGITS(APGLDT) *EQ “‘ *CAT &POST + *CAT ‘” *AND %DIGITS(APINVDT) *EQ “‘ *CAT + &DOCD [...]

Answer Question   |  December 19, 2008  4:38 PM
APGLDT, APINDVT, AS/400 error messages, AS/400 Runtime Errors, OPNQRY

opnqry
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) is the screen field name.This command [...]

Answer Question   |  December 17, 2008  2:58 PM
OPNQRY, OPNQRYF, QRYSLT, RCVF

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?

Answer Question   |  December 18, 2008  1:11 PM
CL, Open Query, OPNQRY, Query/400, SQLRPG, Work with Query, WRKQRY

OPNQRY and ovrdbf
Hi, Can you please tel about OPNQRY and OVRDBF, why we are going to use them, Thanks &Regars, Raum

Answer Question   |  July 2, 2008  11:10 AM
OPNQRY, OVRDBF