Search found 537 matches

by Natarajan
Thu Oct 07, 2010 12:46 pm
Forum: JOB DISCUSSION
Topic: Required Suggestion
Replies: 1
Views: 3509

Since you joined mainframe course 1 month before, my suggestion is, concentrate on current mainframe course that you are attending in MAPLES training institute. On the other options , that you selected.. both are good. Now a days, there are opening for the guys who know mainframe and unix. Testing s...
by Natarajan
Tue Oct 05, 2010 2:53 pm
Forum: ABEND CODES / ERROR CODES
Topic: S30A Reason Code 14
Replies: 3
Views: 6897

When you got this error? While executing SORT utitlity? Following may be helpful to you. S30A - 14 - PRIVATE STORAGE IS NOT IN THE SUBPOOL SPECIFIED. This is a secondary ABEND which may occur if another task within the adddress space abends and Sort has been invoked in Key 0 - 7. This is really a se...
by Natarajan
Tue Oct 05, 2010 2:44 pm
Forum: VSAM - File system
Topic: VSAM CI CA split
Replies: 9
Views: 13873

As suggested by Anuj, use FREESPACE option to reserve freespace in data component of KSDS to handle newly inserted/updated records.
by Natarajan
Tue Sep 28, 2010 3:24 pm
Forum: EASYTRIEVE
Topic: comparing two files on some fields
Replies: 4
Views: 11877

EAZYTRIEVE file matching

YES, there are more chances that you will write duplicate records into outputfile. Instead of write so much logic in the program to handle this. Using sort remove duplicates from exception file. If it is not feasible, do let us know, we can work on to implement the logic for that. First make sure, f...
by Natarajan
Mon Sep 27, 2010 7:56 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: difference between oracle and db2
Replies: 1
Views: 3102

In this forum, we dont discuss much about oracle.
DB2 is a RDBMS database very similar to ORACLE.

These two different RDBMS databases from two different companies.
DB2 can run on any platform. I am not sure ORACLE can be run on mainframe.
by Natarajan
Mon Sep 27, 2010 7:42 pm
Forum: EASYTRIEVE
Topic: comparing two files on some fields
Replies: 4
Views: 11877

EAZYTRIEVE FILE MATCHING

You can use IF MATCHED command to do this. JOB INPUT (FILEA KEY(TRAN-IDA) + FILEB KEY(TRAN-IDB) + FILEC KEY(TRAN-IDC) ) IF MATCHED FILEA FILEB WRITE to OUTFILE1 ELSE WRITE to exception file. END-IF IF MATCHED FILEA FILEC WRITE to OUTFILE2 ELSE WRITE to exception file....
by Natarajan
Mon Sep 27, 2010 7:34 pm
Forum: CICS
Topic: Data exception error
Replies: 4
Views: 8262

Hi Aashiq,

before LINk command move value to LENGTH-comm.
It will solve the problem in CICS program.
by Natarajan
Fri Sep 24, 2010 6:40 am
Forum: CICS
Topic: Data exception error
Replies: 4
Views: 8262

CICS LINK ASRA ABEND

Check the value of LENGTH-comm before/while executing the LINK CICS command in program A. There might be initialization issue in program A.


OR

use LENGTH OF ws-comm with LENGTH option of LINK command.


Try this and let us know the result.
by Natarajan
Thu Sep 23, 2010 5:58 pm
Forum: FILE-AID
Topic: Unit testing using File-Aid
Replies: 8
Views: 16872

unit testing using FILE-AID

Hi, You can edit your input files to enter proper input data using FILE-AID. you can create your layouts using FILE-AID. You can enter required data into DB2 tables using FILE AID for DB2. Overalll you can use FILEAID for creating test data in the unit testing process. and then submit your your batc...
by Natarajan
Tue Sep 21, 2010 11:02 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Deleting rows
Replies: 1
Views: 2882

Try this. Assuming EID has unique value.

Code: Select all


 DELETE * FROM TABLE1  WHERE EID IN 
 &#40;Select  EID  FROM TABLE1  A  WHERE  1 <
&#40; SELECT COUNT&#40;*&#41; FROM TABLE1  B  WHERE  B.DID = A.DID &#41; &#41;


by Natarajan
Tue Sep 21, 2010 10:54 am
Forum: COBOL
Topic: redefines
Replies: 1
Views: 2918

Did you tried this?

My guess is...

First display give the answer as

Code: Select all

7  7  7
Second display give the answer as

Code: Select all

14    14    14
by Natarajan
Tue Sep 21, 2010 10:38 am
Forum: CICS
Topic: CICS Tutorial
Replies: 7
Views: 15647

mainframegurkul contains some basic tutorial on CICS. may be useful for those,
who visit this thread.

http://www.mainframegurukul.com/tutoria ... /cics.html
by Natarajan
Tue Sep 21, 2010 10:36 am
Forum: CICS
Topic: VERTICAL ARRAY IN CICS
Replies: 12
Views: 21829

Did you implemented the same concept that we discussed?
Are there any changes. Please share the details.
by Natarajan
Thu Sep 16, 2010 3:56 pm
Forum: VSAM - File system
Topic: Tool for VSAM connection and File comparison
Replies: 4
Views: 9229

I dont have much knowledge on VB.net, i know, in some of the project in our company they does VB programming to connect to mainframe to get the data. From mainframes using FTP utility , we can FTP /NDM the files to other systems. we may need to use that method to transfer the file mainframe to other...
by Natarajan
Thu Sep 16, 2010 2:35 pm
Forum: VSAM - File system
Topic: Tool for VSAM connection and File comparison
Replies: 4
Views: 9229

Using VB.net , you can connect to mainframes and get the files you want.
(or) you can use FTP tool to get the data to windows.