Author |
Message |
Topic: Registering a DB2 Plan in IMS-DC online environment |
programmer1
Replies: 2
Views: 3174
|
Forum: IMS Posted: Sat May 05, 2007 7:27 am Subject: Registering a DB2 Plan in IMS-DC online environment |
I probably have the answer for my 2nd question that I will need to create an RTT table but someone will have to explain me the process of it's creation (Our system does not have an RTT table defined). ... |
Topic: Registering a DB2 Plan in IMS-DC online environment |
programmer1
Replies: 2
Views: 3174
|
Forum: IMS Posted: Sat May 05, 2007 7:03 am Subject: Registering a DB2 Plan in IMS-DC online environment |
Hi,
Can someone please try to address my queries:
1) How do we find, which all DB2 plans are being used in an online IMS-DC environment ?
2) How do we make a new DB2 plan available to the onl ... |
Topic: browse the records of a VSAM KSDS dataset |
programmer1
Replies: 9
Views: 5303
|
Forum: CICS and Middleware Posted: Tue Feb 27, 2007 12:49 pm Subject: browse the records of a VSAM KSDS dataset |
Try this:
CEMT I FILE file-name READ |
Topic: browse the records of a VSAM KSDS dataset |
programmer1
Replies: 9
Views: 5303
|
Forum: CICS and Middleware Posted: Tue Feb 27, 2007 12:13 pm Subject: browse the records of a VSAM KSDS dataset |
Why do you need a EXEC CICS command to browse through a file in CICS region ? |
Topic: Creating a PDS (Library). |
programmer1
Replies: 10
Views: 5283
|
Forum: Job Control Language(JCL) Posted: Tue Feb 27, 2007 12:08 pm Subject: Creating a PDS (Library). |
Each time I could not visit the internet cafe to check out the answers....that is why I could not read it completely.
Wow ! So you access www.mvsforums.com from your intranet ? |
Topic: LOAD problem |
programmer1
Replies: 10
Views: 4966
|
Forum: Database Posted: Tue Feb 27, 2007 12:31 am Subject: LOAD problem |
What exactly is your requirement ? I can't understand you. |
Topic: LOAD problem |
programmer1
Replies: 10
Views: 4966
|
Forum: Database Posted: Tue Feb 27, 2007 12:14 am Subject: LOAD problem |
Create a dataset with the required data and append 'XYZ' to every record of your load dataset |
Topic: move alphanumeric to numeric |
programmer1
Replies: 14
Views: 6425
|
Forum: Application Programming Posted: Mon Feb 26, 2007 10:36 pm Subject: move alphanumeric to numeric |
If your alphanumeric variable doesn't contain any spaces you can simply move the X(7) into 9(7) and then 9(7) into 9(7) comp.
If the variable contains spaces and you cannot use NUMVAL, simply use I ... |
Topic: Update on large number of rows |
programmer1
Replies: 9
Views: 4808
|
Forum: Database Posted: Thu Feb 22, 2007 10:22 am Subject: Update on large number of rows |
I have 200 records in this table and I need to update Emp-code of all 200 rows with the code "A"
If you want to update all the records, why not use a simple update as:
UPDATE EMP
... |
Topic: Help with ALTERNATE INDEX |
programmer1
Replies: 10
Views: 9901
|
Forum: Data Management Posted: Wed Feb 21, 2007 1:21 pm Subject: Help with ALTERNATE INDEX |
DEFINE PATH -
(NAME (INVOICES.TABLE.APATH) -
PATHENTRY (INVOICES.TABLE) )
... |
Topic: Help with ALTERNATE INDEX |
programmer1
Replies: 10
Views: 9901
|
Forum: Data Management Posted: Wed Feb 21, 2007 11:25 am Subject: Help with ALTERNATE INDEX |
I somehow thought that we need to use the PATH dataset as the physical file for a Cobol program. Now I know for sure that I was wrong. |
Topic: how to know latest tables created |
programmer1
Replies: 2
Views: 1444
|
Forum: Database Posted: Tue Feb 20, 2007 9:48 pm Subject: how to know latest tables created |
The above is the answer to your other post.
Check SYSIBM.SYSTABLES for your above requirement. |
Topic: Help with ALTERNATE INDEX |
programmer1
Replies: 10
Views: 9901
|
Forum: Data Management Posted: Tue Feb 20, 2007 8:01 pm Subject: Help with ALTERNATE INDEX |
Change the SELECT statement in your program as follows:
SELECT INVOICE-TABLE ASSIGN TO UT-V-INVTABL1 |
Topic: Help with ALTERNATE INDEX |
programmer1
Replies: 10
Views: 9901
|
Forum: Data Management Posted: Tue Feb 20, 2007 3:29 pm Subject: Help with ALTERNATE INDEX |
I hope you are using the PATH dataset name in your run JCL? |
Topic: What is the maximum record length in COBOL? |
programmer1
Replies: 3
Views: 4983
|
Forum: Application Programming Posted: Sun Feb 18, 2007 11:48 pm Subject: What is the maximum record length in COBOL? |
COBOL supports QSAM spanned records up to 32,760 bytes long. |
|