Author |
Message |
Topic: Different indexes for different partitions |
Spolacek
Replies: 4
Views: 5136
|
Forum: Database Posted: Tue Nov 16, 2021 8:03 pm Subject: Different indexes for different partitions |
Hello Bauer
I'm no longer working so I can't confirm whether the detach partition command pertains DB2 on zOS. I recall DBAs talking about partition ranging and detaching partitions, but I'm not ce ... |
Topic: Different indexes for different partitions |
Spolacek
Replies: 4
Views: 5136
|
Forum: Database Posted: Sun Oct 31, 2021 5:51 pm Subject: Different indexes for different partitions |
Hello Michael
I think what you want to accomplish can be done by defining the table using range partitioning. For example, each partition could house rows for a particular sales_date week. At the e ... |
Topic: Initaiize group variable |
Spolacek
Replies: 6
Views: 8166
|
Forum: Application Programming Posted: Wed Oct 06, 2021 11:28 am Subject: Initaiize group variable |
If you're using COBOL version 6, there's an extension to the INITIALIZE verb that will also initialize FILLER fields.
Here's how the COBOL Language Reference describes it:
FILLER phrase
When ... |
Topic: Debug tool and skipping code |
Spolacek
Replies: 8
Views: 6966
|
Forum: Utilities Posted: Fri Jul 23, 2021 4:07 pm Subject: Debug tool and skipping code |
I've worked with Xpediter and Debug. I don't believe there is a Debug command that is equivalent to the Xpediter 'SKIP' command.
However, the same functionality can be achieved by using the Debug ... |
Topic: Trying to understand how storage is allocated with COMP-5 |
Spolacek
Replies: 3
Views: 3909
|
Forum: Application Programming Posted: Wed Jun 02, 2021 1:57 pm Subject: Trying to understand how storage is allocated with COMP-5 |
Hello Michael
The answer is slack bytes. The compiler is inserting slack bytes between some fields in order that the binary fields align on the proper boundary.
For example, field SYFTE is 3 ... |
Topic: Convert CSL format data to zoned decimal |
Spolacek
Replies: 2
Views: 2182
|
Forum: Utilities Posted: Tue Apr 07, 2020 8:33 am Subject: Convert CSL format data to zoned decimal |
Hello Kolusu
Your SORT job worked like a charm. Thanks for the quick response.
Also, thanks for the information about ICETOOL ddnames. |
Topic: Convert CSL format data to zoned decimal |
Spolacek
Replies: 2
Views: 2182
|
Forum: Utilities Posted: Mon Apr 06, 2020 4:49 pm Subject: Convert CSL format data to zoned decimal |
We had a need to convert the values in a field from CSL (character with a leading sign) format to zoned decimal. I checked the SORT manual but I didn't see an example there on how to do this. I coded ... |
Topic: How to get Line of code for each application |
Spolacek
Replies: 10
Views: 5407
|
Forum: Utilities Posted: Mon Feb 24, 2020 3:59 pm Subject: How to get Line of code for each application |
For shops that use IBM File Manager instead of Fileaid, you can use File Manager to generate a list of members in a PDS with a count of the number of records in each member.
//STEP01 EXEC PGM=FMNMA ... |
Topic: Cobol V6 IS NUMERIC question |
Spolacek
Replies: 2
Views: 3991
|
Forum: Application Programming Posted: Thu Nov 28, 2019 7:56 am Subject: Cobol V6 IS NUMERIC question |
Hello Vijay
I've seen situations like the one you described where an IF NUMERIC test returns different results from one version of COBOL to another. In most cases, the different results can be tra ... |
Topic: Slow Rate of Transfer using FTP |
Spolacek
Replies: 4
Views: 6004
|
Forum: Job Control Language(JCL) Posted: Thu May 02, 2019 9:56 am Subject: Slow Rate of Transfer using FTP |
I apologize for responding late to this post. I hope that someone may find my information helpful.
Three factors come into play in any computer process:
1. The environment
2. The program
3. T ... |
Topic: CI Split |
Spolacek
Replies: 1
Views: 3037
|
Forum: Data Management Posted: Sat Aug 09, 2003 10:57 pm Subject: CI Split |
Neoframer:
I suggest you download IBM Redbook "VSAM Demystified."
http://publib-b.boulder.ibm.com/Redbooks.nsf/Redbooks?SearchView&Query=vsam+demystified&SearchMax=4999
I believe yo ... |
Topic: Allocate new Node & Deallocate of a Cobol link list |
Spolacek
Replies: 5
Views: 4884
|
Forum: Application Programming Posted: Fri May 23, 2003 10:40 am Subject: Allocate new Node & Deallocate of a Cobol link list |
IBM supplies a sample COBOL program to demonstrate how to use Language Environment services CEEGTST and CEEFRST. The sample program uses these services to build a linked list.
This sample program ... |
Topic: SYSOUD |
Spolacek
Replies: 7
Views: 7191
|
Forum: Job Control Language(JCL) Posted: Tue Mar 11, 2003 7:10 pm Subject: SYSOUD |
At a former place of employment, they had a standard that all displays from a COBOL program be written to ddname SYSOUD. The SYSOUT ddname was reserved for messages coming from the SORT program.
... |
Topic: Download All members of a PDS to workstation |
Spolacek
Replies: 15
Views: 26334
|
Forum: Other Technical Topics Posted: Fri Jan 31, 2003 11:46 pm Subject: Download All members of a PDS to workstation |
Mly:
Log on to TSO and go to option 7.3 (dialog test, variable). Scroll down the list until you come to a variable called ZSYSNODE. The value of ZSYSNODE is the 'node' of your system.
Also, i ... |
Topic: Checking Sign out in Endevor |
Spolacek
Replies: 5
Views: 8324
|
Forum: TSO and ISPF Posted: Thu Jan 30, 2003 8:45 am Subject: Checking Sign out in Endevor |
Phantom:
If you are using the Endevor reports, report '08' should get you a list of all elements signed-out in the specified environment, system, and subsystem for type 'PARM'. This is how the scr ... |
|