OPNQRY

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)),...

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

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

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

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.

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)) + ...

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

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?

OPNQRY and ovrdbf

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