Hi all,

I have a following requirement to write the cobol program.

I have to load the 129 variables from input sequential file
which are in excel sheet to the cobol inernal table. and
after loading into table i have to compare this data with
the business file. here compare means controlling the data
whether the format(numeric,alpha) is same in the business
file and in the table??? i have the same data in input and
business file.
could anyone please give me any idea of the logic?//

i have all the 129 different variables(129rows,1 column)is
there .

Answer Posted / ng

There is an FTP Utility, where u can load excel sheet into mainframe flat and then u can copy that file into VSAM,GDG whtever u want by using IDCAMS.for FTP ucan use 'GET' command of JCLand there are various methods to do START-RUN-utility.

Below example is by doing thru JCL , have a look!

http://www.google.co.in/#hl=en&sugexp=les%3B&gs_nf=3&cp=26&gs_id=3o&xhr=t&q=how+to+do+ftp+in+mainframes&pf=p&sclient=psy-ab&oq=how+to+do+ftp+in+mainframe&gs_l=&pbx=1&bav=on.2,or.r_gc.r_pw.r_qf.&fp=124c53738206d2fc&bpcl=37189454&biw=1366&bih=667

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the default value(s) for an initialize? What keyword will allow for an override of the default?

661


How to use the same COBOL program in Batch and CICS on lines? explain with an example

1914


Mention the guidelines to write a structured cobol program?

620


How to find out the closest prime number of an input number? I believe it has something to do with SEARCH and COBOL Linear Array.

3715


Name the divisions, which are available in a cobol program?

685






What are the access modes of START statement?

719


How many sections are there in data division in COBOL?

678


What is the utilization of copybook in cobol? Could we utilize a similar copybook?

716


In which area will you utilize 88 level items in cobol?

722


how to access the file from prodution from changeman tool and to submit a file to production

6684


how do you reference the esds vsam file formats from cobol programs

629


Which is the default, TEST BEFORE or TEST AFTER for a PERFORM statement?

823


What are the different types of condition in cobol and write their forms.

658


What is perform what is varying?

705


What is a scope terminator give example?

655