1 - 10 of 10
PREVIOUS 1 NEXT
PASSING PARAMETERS TO REPORT VIEWER
Hi Kindly excuse me if i appear abit 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...
Hi Kindly excuse me if i appear abit 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...
5 pts.
Scope identity on a stored procedure in SQL
I have created the following stored procedure in SQL: CREATE procedure [dbo].[sp_trip_number] @Table_Name nvarchar(100), @Trip_Number int output as begin set nocount on begin transaction DECLARE @DynamicSQL NVARCHAR(1000) DECLARE @New_Trip_Number int SET @DynamicSQL='INSERT INTO...
I have created the following stored procedure in SQL: CREATE procedure [dbo].[sp_trip_number] @Table_Name nvarchar(100), @Trip_Number int output as begin set nocount on begin transaction DECLARE @DynamicSQL NVARCHAR(1000) DECLARE @New_Trip_Number int SET @DynamicSQL='INSERT INTO...
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
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
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?
I need to create a stored procedure in SQL where the clause WHERE is a parameter. Is this possible? If yes, how?
Definition of the withGrant parameter in SQL
When giving permissions to database users in SQL, what does the withGrant parameter do?
When giving permissions to database users in SQL, what does the withGrant parameter do?
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.
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.
How to access and use subform data/calculations
Access 2007 Database; Employee Info; Form:Sick Days Docking/Pay. I created a form with a subform that keeps track of Employee sick days. It transfers totals from the subform onto the main form...Then the main form does a couple calculations on those amounts...But I need to access that information...
Access 2007 Database; Employee Info; Form:Sick Days Docking/Pay. I created a form with a subform that keeps track of Employee sick days. It transfers totals from the subform onto the main form...Then the main form does a couple calculations on those amounts...But I need to access that information...
Parameter structure COBOL vs RPG
We have a COBOL program which can select up to 42 lines. The parameter structure is: 01 PARM PIC X(1024). 03 ID PIC X(4). 03 SELECTED OCCURS 42. 05 ITEM PIC X(4). 05 DESCRPT PIC x(20). I need to call this pgm in RPG. How do I best define the...
We have a COBOL program which can select up to 42 lines. The parameter structure is: 01 PARM PIC X(1024). 03 ID PIC X(4). 03 SELECTED OCCURS 42. 05 ITEM PIC X(4). 05 DESCRPT PIC x(20). I need to call this pgm in RPG. How do I best define the...
ILE RPG call to ILE COBOL passing large array
Our RPG program calls the COBOL program with a large linkage made up of an external file record format occurring 999 times. The COBOL program loads 121 of the occurrences with data. The RPG program, however, appears to start processing with the following occurrence 122 even though the COUNT index...
Our RPG program calls the COBOL program with a large linkage made up of an external file record format occurring 999 times. The COBOL program loads 121 of the occurrences with data. The RPG program, however, appears to start processing with the following occurrence 122 even though the COUNT index...
1 - 10 of 10
PREVIOUS 1 NEXT
