 |
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 31 matches |
| Author | Message |
|---|---|
 Topic: Packages bound to tables |
|
| pcmoonbeam Replies: 2 Views: 2536 |
 Forum: Database Posted: Fri Apr 17, 2015 1:26 pm Subject: Packages bound to tables |
Thank you Kolusu so very much. You have saved my day once again.  |
|
| Topic: Packages bound to tables |
|
| pcmoonbeam Replies: 2 Views: 2536 |
Forum: Database Posted: Fri Apr 17, 2015 10:59 am Subject: Packages bound to tables |
| How do I determine what packages are bound to a table? We are DB2 V10. I also have Data Studio 4.1.0.1 installed on my workstation. Can it be used to find the answer to my question? | |
| Topic: SELECTIVE COMMIT |
|
| pcmoonbeam Replies: 2 Views: 2888 |
Forum: Database Posted: Mon Dec 30, 2013 2:03 pm Subject: SELECTIVE COMMIT |
| Is it possible to selectively commit work for individual tables within a COBOL batch DB2 program? I have a program that updates several tables, but I would like to commit only a few tables. This is a ... | |
| Topic: How Does One Reset An IDENTITY Column |
|
| pcmoonbeam Replies: 2 Views: 2450 |
Forum: Database Posted: Mon Sep 19, 2011 5:38 pm Subject: How Does One Reset An IDENTITY Column |
| Thank you so much! | |
| Topic: How Does One Reset An IDENTITY Column |
|
| pcmoonbeam Replies: 2 Views: 2450 |
Forum: Database Posted: Mon Sep 19, 2011 3:55 pm Subject: How Does One Reset An IDENTITY Column |
| I had to drop a test table and load it with data from my production environment which has an IDENTITY column that is automatically incremented by DB2. When I dropped the table, this of course gets res ... | |
| Topic: Can a timestamp be formatted by a concatenation? |
|
| pcmoonbeam Replies: 3 Views: 2598 |
Forum: Database Posted: Wed Feb 04, 2009 11:37 am Subject: Can a timestamp be formatted by a concatenation? |
| Kolusu,
You are my hero!! It worked like a charm. Thank you very much.  |
|
| Topic: Can a timestamp be formatted by a concatenation? |
|
| pcmoonbeam Replies: 3 Views: 2598 |
Forum: Database Posted: Wed Feb 04, 2009 11:31 am Subject: Can a timestamp be formatted by a concatenation? |
| Kolusu,
I'll give it a try and let you know the result.  |
|
| Topic: Can a timestamp be formatted by a concatenation? |
|
| pcmoonbeam Replies: 3 Views: 2598 |
Forum: Database Posted: Tue Feb 03, 2009 7:11 pm Subject: Can a timestamp be formatted by a concatenation? |
| I have a table to which I have added a new timestamp column (CREATE_DATE) . On a go forward basis, this column will be populated each time a row is added to the table with the current timestamp.
... |
|
| Topic: How to limit an output field size from concatenated fields |
|
| pcmoonbeam Replies: 6 Views: 2846 |
Forum: Database Posted: Thu Dec 11, 2008 7:25 pm Subject: How to limit an output field size from concatenated fields |
| KOLUSU,
It worked like a charm. Thank you very much. |
|
| Topic: How to limit an output field size from concatenated fields |
|
| pcmoonbeam Replies: 6 Views: 2846 |
Forum: Database Posted: Thu Dec 11, 2008 7:13 pm Subject: How to limit an output field size from concatenated fields |
| kolusu,
Thank you. I'll give it a try and let you know the result. |
|
| Topic: How to limit an output field size from concatenated fields |
|
| pcmoonbeam Replies: 6 Views: 2846 |
Forum: Database Posted: Thu Dec 11, 2008 5:54 pm Subject: How to limit an output field size from concatenated fields |
| Kolusu,
Yes you are correct, the decimal column is 8 characters. I didn't read your post carefully enough. But still the problem is the character field which could be up to 40 bytes. I hope my e ... |
|
| Topic: How to limit an output field size from concatenated fields |
|
| pcmoonbeam Replies: 6 Views: 2846 |
Forum: Database Posted: Thu Dec 11, 2008 5:52 pm Subject: How to limit an output field size from concatenated fields |
| I'm not sure if you understood the problem Kolusu.
The decimal column is not really the issue. It's the var_char COL which is actually a first name. It can be up to 40 bytes, but the combined len ... |
|
| Topic: How to limit an output field size from concatenated fields |
|
| pcmoonbeam Replies: 6 Views: 2846 |
Forum: Database Posted: Thu Dec 11, 2008 5:11 pm Subject: How to limit an output field size from concatenated fields |
| I am trying to concatenate 3 columns in an SQL statement. The first column is an integer, but I only want the 4 low order digits of the column. The second column is decimal, the third is a name (varc ... | |
| Topic: EXTENDED ATTRIBUTES IN A BMS MAP |
|
| pcmoonbeam Replies: 4 Views: 6297 |
Forum: CICS and Middleware Posted: Thu Jun 19, 2008 4:41 pm Subject: EXTENDED ATTRIBUTES IN A BMS MAP |
| I would like to be able to use extended attributes on a map to cause an error message to blink. However, when I assemble the map, I can't seem to get the extended attribute output in the DSECT that is ... | |
| Topic: Using 'SET' paramaters for JCL OVERRIDES |
|
| pcmoonbeam Replies: 3 Views: 2927 |
Forum: Job Control Language(JCL) Posted: Wed Dec 13, 2006 2:26 pm Subject: Using 'SET' paramaters for JCL OVERRIDES |
| Thanks, that's what I thought, but was hoping otherwise. | |
All times are GMT - 5 Hours |