 |
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 16 matches |
| Author | Message |
|---|---|
 Topic: ABEND=S04C |
|
| Eric.C.Bakke Replies: 5 Views: 20315 |
 Forum: Database Posted: Tue Jul 22, 2008 10:44 am Subject: ABEND=S04C |
| Yes, SO4C is a different abend alltogether...my dislexia struck again...sorry about that. | |
| Topic: ABEND=S04C |
|
| Eric.C.Bakke Replies: 5 Views: 20315 |
Forum: Database Posted: Mon Jul 21, 2008 2:38 pm Subject: ABEND=S04C |
| SO4C can mean several things...but generally, it's a memory problem where you have gone out of the bounds of working storage. if you program has internal tables, make sure you are not exceeding the n ... | |
| Topic: Runstats |
|
| Eric.C.Bakke Replies: 3 Views: 2083 |
Forum: Database Posted: Mon Jul 21, 2008 2:33 pm Subject: Runstats |
| What is your RUNSTATS cards? Did you specify COLUMN(ALL) or COLUMN(your column name)? If not, try specifying the COLUMN option. See DB2 Utility manual for more info. | |
| Topic: No of rows returned by a cursor |
|
| Eric.C.Bakke Replies: 2 Views: 1670 |
Forum: Database Posted: Fri Jul 18, 2008 3:14 pm Subject: No of rows returned by a cursor |
| If you are on DB2 V8 NFM or above, you could do a multi-row fetch in a cursor (better performance) where you can and will want to evaluate sqlerr3 for the number of rows returned in a single multi-row ... | |
| Topic: Reading PDS Members |
|
| Eric.C.Bakke Replies: 37 Views: 45782 |
Forum: Application Programming Posted: Thu Jul 17, 2008 12:50 pm Subject: Reading PDS Members |
| kolusu,
Thanks for edit capability. I tested the program on both PDS and PDSE using Z/OS v1.9. I'm working on a new directory module that will provide in linkage the member name and additional ... |
|
| Topic: Reading PDS Members |
|
| Eric.C.Bakke Replies: 37 Views: 45782 |
Forum: Application Programming Posted: Thu Jul 17, 2008 10:08 am Subject: Reading PDS Members |
| One more thing...I realized that I left the DB2 connection to DSN in my example JCL after I posted it but since I'm not allowed to edit my posts I couldn't change it. You should probably use the dire ... | |
| Topic: Reading PDS Members |
|
| Eric.C.Bakke Replies: 37 Views: 45782 |
Forum: Application Programming Posted: Thu Jul 17, 2008 10:01 am Subject: Reading PDS Members |
| Yes, you could replace IKJEFT1B with this...I'm a DB2 DBA so I'm used to using the batch TSO method...both work the same. | |
| Topic: Reading PDS Members |
|
| Eric.C.Bakke Replies: 37 Views: 45782 |
Forum: Application Programming Posted: Wed Jul 16, 2008 5:14 pm Subject: Reading PDS Members |
| I'm new to this forum and appreciate the info in this post.
I've created a program that reads a pds directory and the subsequently reads each pds member record. If your interested, the code ... |
|
| Topic: LOADING THE TABLE USING IMAGECOPIES |
|
| Eric.C.Bakke Replies: 3 Views: 1718 |
Forum: Database Posted: Wed Jul 16, 2008 7:15 am Subject: LOADING THE TABLE USING IMAGECOPIES |
| If you have access to DB2 utilities, check the ibm utility manuals. DSNTIAUL is a sample cobol program that uses dynamic sql. A load will be slower using this method than DB2 LOAD utility using NO ... | |
| Topic: CREATE TABLE AS |
|
| Eric.C.Bakke Replies: 5 Views: 2204 |
Forum: Database Posted: Tue Jul 15, 2008 4:59 pm Subject: CREATE TABLE AS |
| the -551 is due to you not having authority to select from the table...you'll need someone to grant you access before you can use the 'LIKE' or 'AS' methods. | |
| Topic: CREATE TABLE AS |
|
| Eric.C.Bakke Replies: 5 Views: 2204 |
Forum: Database Posted: Tue Jul 15, 2008 4:57 pm Subject: CREATE TABLE AS |
| using the MQT style of creating tables 'WITH NO DATA' clause is required if you only want a table defined in the catalog with no data which means the table isn't really an Materialized Query table. T ... | |
| Topic: CREATE TABLE AS |
|
| Eric.C.Bakke Replies: 5 Views: 2204 |
Forum: Database Posted: Tue Jul 15, 2008 4:36 pm Subject: CREATE TABLE AS |
| Did you check the DB2 Application SQL Manual for proper syntax? What version DB2 are you on? Are you trying to create an MQT? Or are you trying to create another table that is a clone of TLCS135... ... | |
| Topic: date calculation (-401 error) |
|
| Eric.C.Bakke Replies: 5 Views: 2796 |
Forum: Database Posted: Mon Jul 14, 2008 5:37 pm Subject: date calculation (-401 error) |
| Or better, try
Code: WHERE UPSTAMP >= CURRENT TIMESTAMP - 5 YEARS; |
|
| Topic: Query on DB2 catalog tables |
|
| Eric.C.Bakke Replies: 8 Views: 6230 |
Forum: Database Posted: Mon Jul 14, 2008 5:34 pm Subject: Query on DB2 catalog tables |
| SYSTABAUTH will tell you plans and packages that have been bound to a table using static SQL. I don't believe an entry will be made for dynamic SQL but I could be wrong. Plus, a table that is access ... | |
| Topic: Query on DB2 catalog tables |
|
| Eric.C.Bakke Replies: 8 Views: 6230 |
Forum: Database Posted: Mon Jul 14, 2008 12:47 pm Subject: Query on DB2 catalog tables |
| SYSPLANDEP and SYSPACKDEP only records static SQL dependancies. So if a program has dynamic SQL accessing the table, you'll not find it in these catalog tables unless it also has static sql for tabl ... | |
All times are GMT - 5 Hours |