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

How to get the last record in vsam file in cluster? And how can you get the kids file records into your cobol program?

744


What is a SSRANGE and NOSSRANGE?

823


if we display var1 then what will b displayed in below condition. 77 var1 pic s9(2) value -10. 77 var1 pic s9(2) value -11. " " " -12. " " " -13. -14 ... ... -19.

5695


Our issue is there seems to be a disconnect, or no link, between our SELECT statement and our SD. We had SELECT SORT-FILE and SELECT SORT-FILE ASSIGN TO SORTWRK. ASSIGN TO SORTWRK1 SORTWRK2 SORTWRK3 SORTWRK4. with SD SORT_FILE RECORD CONTAINS 7833 CHARACTERS. In either case, at run time, the system ignored our SORTWRK# DD statements and allocated 16 sort works with the SORTWK## naming convention. Any ideas why the system does not recognize the connection? We do not even need the SORTWRK DD statements. Thanks

2337


What is difference between static and dynamic call in cobol?

777






Can we redefine the field of x(200) to less than 200?

820


Mention the guidelines to write a structured cobol program?

620


Write the code to count the sum of n natural numbers.

701


Can you please let me know the centre name of INS certification in Kolkata.

1715


What are the pertinent COBOL commands?

2626


how can i see junk values in dclgen or in hostvariable of comp ?

2544


how do you reference the fixed unblock file formats from cobol programs

712


How did the release of cobol/370 version 1.3 improve the performance of release 1.1?

645


Explain the configuration section of a cobol program with examples of syntax.

660


what are decleratives in cobol?

1827