Author |
Message |
Topic: Help on DFSORT |
Veera333
Replies: 3
Views: 2352
|
Forum: Utilities Posted: Tue Mar 22, 2011 12:53 am Subject: Help on DFSORT |
Hi,
There is no matching key. Both the files are sequential and LREC = 1300 for file 1 and LRECL= 500 for file2.
Small correction in my question, i should not create a new output file.I should r ... |
Topic: Help on DFSORT |
Veera333
Replies: 3
Views: 2352
|
Forum: Utilities Posted: Mon Mar 21, 2011 8:11 am Subject: Help on DFSORT |
Hi,
I have a requirement where i have two input files of different LRECL.
The output file must have the content of input files as follows
1: 43 content of file1 for first 43 bytes
44:10 conten ... |
Topic: Help regarding sort card |
Veera333
Replies: 2
Views: 2637
|
Forum: Job Control Language(JCL) Posted: Sun Dec 05, 2010 12:57 am Subject: Help regarding sort card |
Hi,
I have a requirement as follows
I have a file with Columns: Name,Designation, Band
I have to extract all the records with designation as 'Engineer'
Then If band is 'E' i have populate ... |
Topic: Help on Reorg |
Veera333
Replies: 1
Views: 2052
|
Forum: Database Posted: Thu Oct 07, 2010 3:48 am Subject: Help on Reorg |
Hi,
I am coding Reorg for a DB2 table. Please help me how to find the mapping table that is to be coded in REORG.
Thanks in advance,
Veera |
Topic: Help on Discard |
Veera333
Replies: 1
Views: 1414
|
Forum: Database Posted: Wed Aug 11, 2010 1:53 am Subject: Help on Discard |
Hi,
Can i use joins in DISCARD statement.
For example DISCARD FROM TABLE A
WHEN (SELECT 1 FROM TABLE B
WHERE A.COLUMN1 = B.COLUMN1) ... |
Topic: JCL to bind the program |
Veera333
Replies: 5
Views: 2667
|
Forum: Database Posted: Wed Jul 21, 2010 7:43 am Subject: JCL to bind the program |
Hi,
In development region i have to bind the program whenever i do a reorg on a table.
I was assuming the same case in production as well. Dont i need to bind or rebind the program every time reor ... |
Topic: JCL to bind the program |
Veera333
Replies: 5
Views: 2667
|
Forum: Database Posted: Tue Jul 20, 2010 8:31 am Subject: JCL to bind the program |
Hi,
Is there any JCL that binds the program and can be scheduled as daily or weekly job for rebinding.
Thanks in advance,
Veera |
|