• 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 ' +...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Definition of the withGrant parameter in SQL

    When giving permissions to database users in SQL, what does the withGrant parameter do?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Parameters in RUNRMTCMD?

    Can I pass parametes in a runrmtcomd?

    J07285 pointsBadges:
  • 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...

    OBI Girl85 pointsBadges:
  • 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 parameters without defining each individual field.

    r.otto810 pointsBadges:
  • 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...

    toddio0 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