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
- 13257 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 jcl approach for programming?
what are the working storage fields in BMS macro?
what is the result of the following? DIVIDE A INTO B GIVING C. a.C=A/B b.the reminder of B/A is stored in C c.C=B/A d.the reminder of A/B is stored in C
WE HAVE 2 FILES IN COBOL. ONE IS FIXED LENGTH RECORDS ANOTHER ONE IS VARIABLE LENGTH. IF I DECLEAR LRECL OF FIXED ONE AS 80 AND 2ND RECORD AS 132. WHAT WE NEED TO DECLEAR LRECL FOR THOSE 2 FILES IN JCL?
record length in spool?
how can we find total no of records in a file ....is there any utility......?
write a program to eliminate duplicate records in a input file and send them to output file.THIS IS IGATE RECENT QUESTIONN.....JUST 1 WEEK BACKKKK...
What are the differences between OS VS COBOL and VS COBOL II?
what will happen if pass values more than 100 using PARM parameter?
COBOL Snippet: Tell where the control will when the below code execute IF (A=B) CONTINUE ELSE NEXT SENTENCE PERFORM <IMP-STMT> END-IF.
In COBOL "BEFORE" advancing is there or not ?
Can you call an OS VS COBOL pgm from a VS COBOL II pgm ?
COBOL 
