• iSeries: Command that accepts object name as parameter

    I've been trying (and trying) to create a new command on iSeries, where the parameter has the same file name using the LIBRARY/FILE MEMBER syntax. Something like this:MYCMD FILE(MYLIB/MYFILE MYMEMBER)Or this:MYCMD FILE(MYLIB/MYFILE) MEMBER(MYMEMBER)I've tried several things including:Create a PARM...

    ITKE341,745 pointsBadges:
  • Passing parameters to report viewer

    Hi Kindly excuse me if I appear a bit ignorant on this subject as I am relatively new to SSRS. I have managed to create a report that has 3 parameters (ie. Start Date,End Date,Drop down list) which I have successfully deployed to Report Server. The report basically uses a stored procedure which has...

    Shaygen5 pointsBadges:
  • Date parameters within crystal reports 8.5 still brining up all records

    Hi, I have created a date parameter as I would like to be able to view absence within the company during certain dates. When I run the parameter it still brings up all the records. Is anyone able to help?

    Ajmx5 pointsBadges:
  • Passing parameters RPG-CL-RPG

    I am trying to modify an intermediate CLLE program to submit itself to batch. The calling program (ILE RPG) passes a parameter as a character field with a number in it. The CL program receives it as a numeric field and then calls another RPG program and passes that parameter. The final RPG program...

    Vatchy1,410 pointsBadges:
  • CLP parameters overwritten

    Hi.  When I call a CLP, either from command line or from a sbmjob with alpha parameters, if I don't fill up the whole string length it's trailing blanks are overwritten by the next parameters.  Example:  PGM PARM(&P1 &P2 &P3)  DCL VAR(&P1) TYPE(*CHAR) LEN(50)  DCL VAR(&P2) TYPE(*CHAR)...

    Jsebastians15 pointsBadges:
  • help with access database

    Searched high and low and while there are many internet posts addressing this topic, none seem to be geared low enough for this ubernubee. I have 2 tables, one lists various addresses and associated file numbers, the file numbers are unique and the primary key in the table. The other table lists...

    Joebaich5 pointsBadges:
  • Error Message when trying to change Parameters – Crystal Reports 11

    Failed to Retrieve data from the database. Details: ADO Error Code: 0x80040e14 Source: Microsoft OLE DB Provider for Oracle Description: ORA-06550: Line 1, Column 7: PLS-00201: identifier 'WHSP_USER.SP_RPT_DAILY_LANE_EXCEPTION' must be declared ORA-06550: Line 1, Column 7: PL/SQL: Statement ignored...

    Nmarrakchi5 pointsBadges:
  • Can i use two parameter in oracle report

    i want to make a report with two parameter when user select user name in one parametr other show names of all users and user select one name ane detail of that user is shown in report.or if user select any other field other parametr show data of that selected column to selected by the user to...

    Zaraiqbal5 pointsBadges:
  • Adding New Parameter to a existing Crystal reports 9.5

    I have a exsiting crystal rpt that passes 5 parameters to a stored proc.  We have added 1 more parameter to the procedure now when attempting to run the crystal rpt it errors out with proc expects parameter "new" (new being the added parameter).   I have been unable to get around this. Can...

    Ftrucks015 pointsBadges:
  • Returning AS/400 parameters from procedures

    If I have a sub procedure :- P SUBP B D SUBP PI X(10) D Parm1 X D Parm2 X D Parm3 X(10) value options(*nopass) D Data_item X(10) C /free C [some][/some]C If %parm < 3 C Return Data_item C Else C Parm3 = Data_item C Return C Endif C /end free P SUBP E And then if I call it using Callp SUBP(A: B:...

    MichaelRlancaster15 pointsBadges:
  • SQL Server Reporting Services (SSRS) Reports 2005

    How to include to Input parameters in the report, so as to help users identify the parameters on which the report was run.

    YogeshNT5 pointsBadges:
  • Float type parameter containing incorrect value after a callp

    I'm calling a procedure from an rpg pgm(V5R4). It has several parameters with different types. Before calling, they are set to 0 or blanks. After calling, all is coming back with correct value except for 1 float(8f) field. We don't have the source for the procedure however, it's been tested in C...

    kglen0145 pointsBadges:
  • XML Publisher Report

    I made Matrix report in XML Publisher in that there are two parameter for Date (From Date & To Date)when i run report for one day it is working fine when i run for a month it givs worning i.e Beginning post-processing of request 76437793 on node TAJORN3 at 30-SEP-2010 12:02:15. Post-processing of...

    Naved5 pointsBadges:
  • Using AS400 COBOL or CL Program to Call an Excel File and Pass Parameters Back and Forth from 400 to Excel Back to 400

    [html xmlns=""> I am beginning my investigation to figure out how to use either a 400/COBOL program or a CL program to call an excel spreadsheet that requires three parameters to a calculation and to return a value back to my 400/COBOL program of CL program so that I then can use that value in my...

    400Programmer185 pointsBadges:
  • Crystal Reports XI – Duplicate input parameters

    I am creating a Report with the input parameter for all the sales representatives across multiple states. On the report input parameter the values listed are as follows: N/A User1 - CA User2 - CA User3 - CA N/A User1 - CO User2 - CO User3 - CO and so on. I am hard coding N/A as the default value...

    NaviIT5 pointsBadges:
  • Conditional processing for Connect Direct on UNIX

    I want to send a parameter to my unix script which I use to decide if the file that was sent using Connect Direct is moved to backup. The only Condition is seems to use is if the previous step was successful.

    Petermay015 pointsBadges:
  • Are parameters permitted on SQL Server 2000 views

    I think the answer to this is NO, but is there a way to create a view that accepts input parameters? I created the view hard coding in something that now needs the flexibility that a parameter would provide, but I've never seen a parameter on a view - Is it possible? Thanks

    CO Bill120 pointsBadges:
  • How to create a parameter based on previous parameter.

    How to create a parameter based on previous parameter. Good Day, I am fairly new to CR and I was wondering if there was any way to accomplish the following? I am looking to create a parameter based on a previous parameter. I am using CR v.XI. Simple Example: Parameter #1: Run Report BY: (a)...

    Forpeekaboo5 pointsBadges:
  • Call RPGLE Program from RPG Program

    I have an RPG program. In that program I want to CALL a RPGLE program and pass parameters to it. What I need to know is there some parameter in the compile that I need to do to do this? I get errors when I try to compile the RPG normally.

    SoccerDave5 pointsBadges:
  • Creating a stored procedure in SQL

    I need to create a stored procedure in SQL where the clause WHERE is a parameter. Is this possible? If yes, how?

    SQL Server Ask the Experts2,585 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