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 .
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 |
how we rectify soc7 and soc4 errors in project?
What is IMPACT analysis?
What are the cobol coding sheets?
If my program receives input feed from program in other system.. if the receiving field size is less than the sending field.. what abend will be happening.
in real time what is the suitable exp where in-stream procedure is better then catalog procedure.
what is linkcard in cobol?
where will u code file status ?
What is inspect in cobol ?
In CICS/VSAM every file that is accessed should be defined in FCT. we have CICS READ, WRITE, BROWSE commands for VSAM files. How does it work with DB2 tables. It know it has to do with the plan. Please expain with examples.
tell me about examine inspect and evaluate ?
How do you code cobol to access a parameter that has been defined in jcl? And do you code the parm parameter on the exec line in jcl?
if a file has 1000 recods how copy the records from 1 to 100 records using sort