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 .
- 4 Answers
- 12145 Views
- IBM, Syntel, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / madhan
plz anybody knows forward it to my mail id:-
kpalli_ms001@yahoo.co.in
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ravi
Hi,
Step 1.. convert all the data into to ASCII data with the rows
step 2.. Read this input file
Step 3.. Load all the data in the internal table
Step 4.. Read your business data with the internal table
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between perform … with test after and perform … with test before?
Which of the following EDITind and PICTURE symbols is to be used if a minus(-) is to appear before the value if the value is -ve and a plus(+) is to appear before the value if the value is +ve? (a) + (b) - (c) + OR (d) It is not possible
SIGN TRAILING SEPARATE field occupy ?
01 x pic s9(8) comp. How will the following value be internally allocated '18787'
What are all the divisions of a COBOL program?
HOW WE WILL SORT THE ARRAY WHICH IS GOING TO USE FOR SEARCH ALL?
can we read records in a file from botom to top. if possible how can we read
How to define a array dynamically.....
in cobol main pgm is calling sub pgm but sub pgm does not exists , what abend i get if submit the job?
What are ISOLATION LEVELS? Where do we need to specify them in compiling JCL (Exactly which statement and what is syntax for it)?
What are VS COBOL 11 special features?
How To Separate The Numerics From An Alphanumric Data Item Which Contains Both Alphabates And Numerics ?
COBOL 
