 |
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 18 matches |
| Author | Message |
|---|---|
 Topic: request for system administrators in the MVS world |
|
| dr_te_z Replies: 3 Views: 4012 |
 Forum: Data Management Posted: Tue Mar 25, 2008 1:52 am Subject: request for system administrators in the MVS world |
| dr_te_z,
TrySORT VOLUME D  Thanks. |
|
| Topic: request for system administrators in the MVS world |
|
| dr_te_z Replies: 3 Views: 4012 |
Forum: Data Management Posted: Fri Mar 21, 2008 2:40 am Subject: request for system administrators in the MVS world |
| Please re-concider "naming convention" for volumes.
When I am in 3.4 looking at my datasets and I give the command: "sort volume" then - 1st I see my GDG entries "??????&qu ... |
|
| Topic: Need tips for tuning below mentioned queries |
|
| dr_te_z Replies: 14 Views: 6655 |
Forum: Database Posted: Thu Mar 20, 2008 6:21 am Subject: Need tips for tuning below mentioned queries |
| So? Code likeSelect DAT_GELDIG_TOT from whatever_table
where DAT_GELDIG_TOT between (date (2007-03-20) + 1 day) and (date (2008-04-26) - 1 day ... |
|
| Topic: Passing multiple rows as parameter to a Stored Procedure |
|
| dr_te_z Replies: 2 Views: 1880 |
Forum: Database Posted: Thu Mar 20, 2008 6:10 am Subject: Passing multiple rows as parameter to a Stored Procedure |
| Some kind of temp-table/MQT like solution
or concider a federated database solution so you c |
|
| Topic: Need tips for tuning below mentioned queries |
|
| dr_te_z Replies: 14 Views: 6655 |
Forum: Database Posted: Mon Mar 17, 2008 8:44 am Subject: Need tips for tuning below mentioned queries |
| No, I know. I did not say that. I just said that it can be re-coded that way.
You must look close at the content of you host-vars. Just add/subtrract 1 day where needed and you're done. |
|
| Topic: Need tips for tuning below mentioned queries |
|
| dr_te_z Replies: 14 Views: 6655 |
Forum: Database Posted: Mon Mar 17, 2008 2:57 am Subject: Re: Need tips for tuning below mentioned queries |
|
WHERE B.EFCT_DATE < :HV-END-DATE AND B.EFCT_DATE > :HV-BGN-DATE Yep, agree with previous posters. Use the "IN" and "BETWEEN" predicate where ... |
|
| Topic: How to create PDS using JCL |
|
| dr_te_z Replies: 13 Views: 39166 |
Forum: Utilities Posted: Thu Mar 13, 2008 9:00 am Subject: How to create PDS using JCL |
| Well, maybe slight off-topic but I use this job to create/populate a PDS/E:
//COPY EXEC PGM=IEBCOPY //SYSUT1 DD DSN=&SYSUID..SPUFX,DISP=SHR ... |
|
| Topic: How to decide space attribute for a temporary dataset? |
|
| dr_te_z Replies: 12 Views: 8649 |
Forum: Data Management Posted: Thu Jan 24, 2008 7:03 am Subject: How to decide space attribute for a temporary dataset? |
| Do not calculate youself:
SPACE=(60,(37,1),,CONTIG),AVGREC=M, This means: allowcate room for 37 miljon records of 60 char each. But this will be better: //SORTWK01 DD SPAC ... |
|
| Topic: it's a question of *MINDSET* |
|
| dr_te_z Replies: 0 Views: 1159 |
Forum: Utilities Posted: Fri Jan 04, 2008 2:45 am Subject: it's a question of *MINDSET* |
| Please discuss with me:
I've worked for various companies both on mainframe and dinky-toy (unix/windows) environments. At my present customer's they have both cobol and java/webpshere on z/OS. So ... |
|
| Topic: cobol stored procedure versus subprogram |
|
| dr_te_z Replies: 6 Views: 3275 |
Forum: Application Programming Posted: Mon Dec 03, 2007 1:51 am Subject: cobol stored procedure versus subprogram |
| http://www.tek-tips.com/viewthread.cfm?qid=1400958&page=2 | |
| Topic: Having a CLOSE CURSOR is not necessary !? |
|
| dr_te_z Replies: 5 Views: 2481 |
Forum: Database Posted: Tue Nov 27, 2007 7:08 am Subject: Having a CLOSE CURSOR is not necessary !? |
| I wrote a small DB2-COBOL program without CLOSE CURSOR and it was closed automatically.Yeah? Did your program have an iteration where you open/fetch/close more than once?
In the old days (using ada ... |
|
| Topic: FTP - DB2 UDB - Mainframe compatible data types |
|
| dr_te_z Replies: 2 Views: 1992 |
Forum: Utilities Posted: Mon Nov 05, 2007 3:59 am Subject: FTP - DB2 UDB - Mainframe compatible data types |
| Do not try to walk that road:"using native database formats and expect them to be handled well during 'unload/ftp/ascii ebcdic translation / load' process"
Guide your data trough that pro ... |
|
| Topic: Catalog an empty dataset |
|
| dr_te_z Replies: 10 Views: 5506 |
Forum: Job Control Language(JCL) Posted: Fri Sep 21, 2007 12:49 am Subject: Catalog an empty dataset |
| On the mainframe there are 2 flavors of an "empty" file.
- 1 Only a catalog entry. This file is never opened for output (typically IEFBR14) - 2 A "real" empty file. This file ... |
|
| Topic: How to read records in descending order with the ISN of Adab |
|
| dr_te_z Replies: 2 Views: 2201 |
Forum: Database Posted: Wed Sep 05, 2007 12:48 am Subject: How to read records in descending order with the ISN of Adab |
| READ FILE BY ISN
ENDThat's Natural code. The topic-starter mentiones COBOL. When the topicstarter does not mention how he/she accesses ADABAS from COBOL no-one can answer. |
|
| Topic: Using host variable in IN predicate |
|
| dr_te_z Replies: 6 Views: 3497 |
Forum: Database Posted: Wed Aug 29, 2007 3:35 am Subject: Using host variable in IN predicate |
| Nice topic. When I faced the same problem I codedwhere type in (:ws1 , :ws2 , :ws3 , :ws4 , :ws5 , :ws6 , :ws7)(actually 50 parameters)
The DB2-guru on site told m ... |
|
All times are GMT - 5 Hours |