 |
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 22 matches |
| Author | Message |
|---|---|
 Topic: How can I get Version Info of a stopped Db2-System |
|
| zefrim Replies: 2 Views: 3372 |
 Forum: Database Posted: Thu Apr 12, 2012 5:36 am Subject: How can I get Version Info of a stopped Db2-System |
| Hi there
need some info from the Db2-V10 users. With the help of a REXX I determine the release status of our systems Db2 I read in the SDSNEXIT by the member DSNHDECP. In this file ... |
|
| Topic: DB2 V10 - DSNDRIB -Macro |
|
| zefrim Replies: 2 Views: 2159 |
Forum: Database Posted: Tue Jan 18, 2011 7:17 am Subject: DB2 V10 - DSNDRIB -Macro |
| Hi
I need the structure (definitions) of the new DSNDRIB macros which is located in the SDSNMACS for the new DB2 V.10. Unfortunately, I can see the IBM-books no exact description of this macro ... |
|
| Topic: List tables with Index count using SQL |
|
| zefrim Replies: 4 Views: 2565 |
Forum: Database Posted: Mon Dec 13, 2010 3:57 am Subject: List tables with Index count using SQL |
| HI
thanks for the query but I also need those tables which have no index, so it is somewhat more complicated Zefrim |
|
| Topic: List tables with Index count using SQL |
|
| zefrim Replies: 4 Views: 2565 |
Forum: Database Posted: Fri Dec 10, 2010 9:18 am Subject: List tables with Index count using SQL |
| HI there
maybe someone can help me: I would like to know how many indexes a table. The output should look like this: Creator Name TOTAL-IX ------------------------------- crea1 tab1 5 c ... |
|
| Topic: Compare structure of 2 Tables |
|
| zefrim Replies: 1 Views: 1328 |
Forum: Database Posted: Tue Jul 27, 2010 1:41 am Subject: Compare structure of 2 Tables |
| HI
I would like to compare the structures of two tables to determine whether the tables have different field names. In a step 2.ten I would also compare the field characteristics. Maybe some ... |
|
| Topic: DB2 V9 NFM - Lower case tables |
|
| zefrim Replies: 1 Views: 1309 |
Forum: Database Posted: Fri Sep 19, 2008 3:52 am Subject: DB2 V9 NFM - Lower case tables |
| Hello
How can I determine whether in a DB2 system (Z-OS V.9 NFM) Tables with lowercase letters are included. I want to do this wiht only one SQL ? Thank you zefrim |
|
| Topic: DB2 Mode (CM,ENFM,NFM) in Version 9 (Z/OS) |
|
| zefrim Replies: 1 Views: 1643 |
Forum: Database Posted: Mon Aug 25, 2008 8:12 am Subject: DB2 Mode (CM,ENFM,NFM) in Version 9 (Z/OS) |
| Hi
How can I determine in a PL1/Programm the mode in which I am (CM-Compat, ENFM = enabled, or FUNCTION NEW MODE) Zefrim |
|
| Topic: DB2 Z-OS / SQL-Question |
|
| zefrim Replies: 1 Views: 1332 |
Forum: Database Posted: Tue May 27, 2008 2:09 am Subject: DB2 Z-OS / SQL-Question |
| Hi
Maybe someone can help me: I would like an SQL evaluation on the sysibm.systables and determine whether a table contains CLOB fields or not all in a single SQL. Maybe someone ca ... |
|
| Topic: DB2 Z-os 8.1 - CUrrent Collection |
|
| zefrim Replies: 1 Views: 1464 |
Forum: Database Posted: Fri Mar 28, 2008 9:10 am Subject: DB2 Z-os 8.1 - CUrrent Collection |
| Hi All
Is it possible to determine what the environment is just my current PGM / Package Located . I mean the Current COllection Thanks Zefrim |
|
| Topic: REXX Upper Case and Lower Case |
|
| zefrim Replies: 2 Views: 1933 |
Forum: TSO and ISPF Posted: Thu Feb 21, 2008 8:15 am Subject: REXX Upper Case and Lower Case |
| Hello Forum participants
I have several problems with 2 Rexx procedures. The first procedure is as follows: SRT1: / * * REXX / ADDRESS ISPEXEC "SELECT CMD (SRT2 NAME (Mailing List) ... |
|
| Topic: REXX Upper Case and Lower Case |
|
| zefrim Replies: 0 Views: 2022 |
Forum: TSO and ISPF Posted: Thu Feb 21, 2008 7:55 am Subject: REXX Upper Case and Lower Case |
| Hello Forum participants
I have several problems with 2 Rexx procedures. The first procedure is as follows: / * * REXX / ADDRESS ISPEXEC "SELECT CMD (SRT2 NAME (Mailing List))" ... |
|
| Topic: Different Tables in Db2 V8 Z-OS |
|
| zefrim Replies: 4 Views: 2087 |
Forum: Database Posted: Wed Jan 02, 2008 5:03 am Subject: Different Tables in Db2 V8 Z-OS |
| HI
i mean the structure of the both Tables. The Name of the Table ist different. How can I do this by SQL ? Zefrim |
|
| Topic: Different Tables in Db2 V8 Z-OS |
|
| zefrim Replies: 4 Views: 2087 |
Forum: Database Posted: Wed Jan 02, 2008 4:22 am Subject: Different Tables in Db2 V8 Z-OS |
| Dear Forum participants
Perhaps someone has a suitable SQL for me .. Also in our DB2-System are lots of similar tables, but with different table name. How can I find out in 2 tables if the ... |
|
| Topic: Return Code in a JCL |
|
| zefrim Replies: 4 Views: 7440 |
Forum: Job Control Language(JCL) Posted: Wed Sep 12, 2007 3:44 am Subject: Return Code in a JCL |
| Hello
I would set manually gladly into my JCL a return code. Example: //TEST EXEC PGM=ABC //SET RC = 0 Thus the return code of the PGM ABC should be set to 0 Question: this is possible ... |
|
| Topic: Translate Unicode Rows to EBCDIC in a rexx proc |
|
| zefrim Replies: 5 Views: 3282 |
Forum: Database Posted: Fri Dec 22, 2006 5:26 am Subject: Translate Unicode Rows to EBCDIC in a rexx proc |
| HI
How can I translate Unicoded-Rows to EBCDIC in a REXX-PGM ? Greetings Zefrim |
|
All times are GMT - 5 Hours |