 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 54 matches |
| Author | Message |
|---|---|
 Topic: Declaring variables in Trigger |
|
| SMS Replies: 7 Views: 3117 |
 Forum: Database Posted: Tue Jul 22, 2008 7:34 am Subject: Declaring variables in Trigger |
| I am using SQL Assistant. Let me try changing the delimiter. Thanks! | |
| Topic: Declaring variables in Trigger |
|
| SMS Replies: 7 Views: 3117 |
Forum: Database Posted: Mon Jul 21, 2008 2:09 pm Subject: Declaring variables in Trigger |
| No, I didn't change the delimiter | |
| Topic: Declaring variables in Trigger |
|
| SMS Replies: 7 Views: 3117 |
Forum: Database Posted: Mon Jul 21, 2008 11:11 am Subject: Declaring variables in Trigger |
| Thanks for your responses. I have shown just the portion of my trigger. Actual intention of using this variable is different. So I need to use the DECLARE statement, but not sure whether it is possibl ... | |
| Topic: Declaring variables in Trigger |
|
| SMS Replies: 7 Views: 3117 |
Forum: Database Posted: Mon Jul 21, 2008 9:50 am Subject: Declaring variables in Trigger |
| Hi,
I am having an issue in declaring variables inside a trigger. The trigger statement is as follows. If I remove the declare and set, able to create the trigger. Otherwise getting the SQL error 2 ... |
|
| Topic: Runstats for a Z/os DB2 table via DB2 command line processor |
|
| SMS Replies: 2 Views: 2593 |
Forum: Database Posted: Tue Jun 24, 2008 11:22 am Subject: Runstats for a Z/os DB2 table via DB2 command line processor |
| Thanks Kolusu. I will check. | |
| Topic: Runstats for a Z/os DB2 table via DB2 command line processor |
|
| SMS Replies: 2 Views: 2593 |
Forum: Database Posted: Fri Jun 20, 2008 10:53 am Subject: Runstats for a Z/os DB2 table via DB2 command line processor |
| Hi,
I am trying to perform the runstats for a DB2 O/s table thru the Db2 Command line processor as follows but I am getting an error. db2 => RUNSTATS ON TABLE AZ.TEST1 AND SAMPLED DETAILED I ... |
|
| Topic: CLOB value passed to a Stored Procedure |
|
| SMS Replies: 0 Views: 3049 |
Forum: Database Posted: Sun Mar 30, 2008 9:24 am Subject: CLOB value passed to a Stored Procedure |
| Hi
I need some help in using the CLOB data type. I need to pass big volume of data (in MBs) from a Cobol program to a DB2 stored procedure(SP) using a single parameter. The SP is using an extern ... |
|
| Topic: Passing multiple rows as parameter to a Stored Procedure |
|
| SMS Replies: 2 Views: 1726 |
Forum: Database Posted: Mon Mar 24, 2008 7:47 am Subject: Passing multiple rows as parameter to a Stored Procedure |
| Thanks, I will look into it. | |
| Topic: Maximum length of parameter for a Stored Procedure call |
|
| SMS Replies: 2 Views: 1874 |
Forum: Database Posted: Wed Mar 19, 2008 7:46 am Subject: Maximum length of parameter for a Stored Procedure call |
| Kolusu,
Thanks for your help. Could you please tell me from where I could see this information so as to pass on to my colleagues. |
|
| Topic: Maximum length of parameter for a Stored Procedure call |
|
| SMS Replies: 2 Views: 1874 |
Forum: Database Posted: Tue Mar 18, 2008 5:19 pm Subject: Maximum length of parameter for a Stored Procedure call |
| Hi,
Does anyone know what is the maximum bytes of data that can be passed to a DB2 stored procedure as parameter? I need to find out this in order to receive some data from the front end. I have ... |
|
| Topic: Passing multiple rows as parameter to a Stored Procedure |
|
| SMS Replies: 2 Views: 1726 |
Forum: Database Posted: Tue Mar 18, 2008 10:31 am Subject: Passing multiple rows as parameter to a Stored Procedure |
| Hi,
I have been brainstorming for the following requirement. From the front end, around 20,000 rows that are present on the grid needs to be saved to a DB2 table with the connection extablished ... |
|
| Topic: RRSAF Connection fails |
|
| SMS Replies: 7 Views: 13045 |
Forum: Database Posted: Fri Dec 14, 2007 3:27 pm Subject: RRSAF Connection fails |
| Thanks to all.
Actually that stored procedure was trying to use a new table. In my shop, for every new table there should be a RACF access in place. But for this table I forgot to get the same. T ... |
|
| Topic: RRSAF Connection fails |
|
| SMS Replies: 7 Views: 13045 |
Forum: Database Posted: Wed Dec 12, 2007 8:35 am Subject: RRSAF Connection fails |
| Actually I am not explicity doing anything with the RRSAF. For compiling the programs, we have the customized comilation screens wherein we will just provide the required program details. The system w ... | |
| Topic: RRSAF Connection fails |
|
| SMS Replies: 7 Views: 13045 |
Forum: Database Posted: Wed Dec 12, 2007 8:08 am Subject: RRSAF Connection fails |
| I am invoking the stored procedure via a COBOL program. Yes I am using DSNRLI. | |
| Topic: Passing parameter values using PARM statement |
|
| SMS Replies: 6 Views: 2783 |
Forum: Database Posted: Wed Dec 12, 2007 7:54 am Subject: Passing parameter values using PARM statement |
| Thanks dbzTHEdinosauer. I will try that | |
All times are GMT - 5 Hours |