View previous topic :: View next topic
|
Author |
Message |
suganthyprabha
New User
Joined: 28 Jul 2005 Posts: 58
|
|
|
|
Dear Friends,
Can u please give the answer for the foll questions.
1. Which is best Static call or Dynamic call? What all are the advantages of using either Static call or Dynamic call? How will u get S0C4 when u are using CALL statement?
2. In which situation u will Rebind again for Package? and for Plan?
3. U are having 100000 records. U have processed 50000 records and now there is some problem, due to that the sytem is shut down.How can u avoid Processing the Records from the First step, as i have processed 50000 records.
4. I am using Cobol+Db2 program. In that i am pasing the input from Parm. What all are the other ways to pass the input? Then i said Sysin DD *. Then he asked how will u Accept it in Cobol+db2 Program. that is i am not going to use PARM. What all are other ways and How?
5. What is the need for giving Header and Trailer Records for the Input files and in my Output file i don't want to write the Header and Trailer Record, How will u code it?
I said using SORT we can do this, but he asked me to code it in the CObol+Db2 Program
Actually i couldn't able to Test in my system, SO can u guys please give me the answers?
Thanks and Regards,
Suganthy. |
|
Back to top |
|
|
reshma
New User
Joined: 10 Sep 2005 Posts: 9 Location: software engineer
|
|
|
|
suganthyprabha,
u keep on posting questions in this forum.but no answers from ur side.
dont tell like tht u r not able to test in ur system.get a job first and then test it in ur company |
|
Back to top |
|
|
khamarutheen
Active Member
Joined: 23 Aug 2005 Posts: 677 Location: NJ
|
|
|
|
Hi frnd,
Dear Reshma plz dont discourage any pals in this site. try to answer else leave it..
Here in i had explained the answers which is up to my knowledge.
1. Which is best Static call or Dynamic call? What all are the advantages of using either Static call or Dynamic call? How will u get S0C4 when u are using CALL statement?
Static is the best. since most of the thing which v r going to extract is known in advance whereas dynamic v need to get initialize it in runtime. where some exceptions may occur.
similarly S0C4 is Caused by subscript being out of range in general. it is caused in CALL statement when using call by reference i think so. check it.
2. In which situation u will Rebind again for Package? and for Plan?
during the compilation Bind process is being taken place na. then once u made any changes in the Cobol+db2 interface then it should affect the changes such that u go for rebinding a packages/plan. since package has the advantage of rebinding the particular plan.
3. U are having 100000 records. U have processed 50000 records and now there is some problem, due to that the sytem is shut down.How can u avoid Processing the Records from the First step, as i have processed 50000 records.
It's not a exact point that v had known already that at 100000th record the system get crashes. so just keep the checkpoint at some interval and do the commit process at the same.
4. I am using Cobol+Db2 program. In that i am pasing the input from Parm. What all are the other ways to pass the input? Then i said Sysin DD *. Then he asked how will u Accept it in Cobol+db2 Program. that is i am not going to use PARM. What all are other ways and How?
one way is PARAM said already. the another way is u can just give in SYSIN DD * and type the input value. use accept verb and move it to the DB2 defined variable. i think tat's the two way for batch process.
5. What is the need for giving Header and Trailer Records for the Input files and in my Output file i don't want to write the Header and Trailer Record, How will u code it?
The Header and Trailer is given inorder to find out the record sequences and the record desc in short. so if u need to eliminate that just v can skip the header and trailer by comparing to some variable. if any other solution plz place ...
if i get the coding then i will post... All the best for ur future interview |
|
Back to top |
|
|
suganthyprabha
New User
Joined: 28 Jul 2005 Posts: 58
|
|
|
|
Dear Kamarudeen,
Thanks for ur Reply.
I was really hurted by Reshma's Reply.
If i could able to do it and i know the answer i wil not disturb others.
Really i couldn't able to test programs in my shop. We are using Changeman package,now that package is into Production. so i couldn't able to check it. In the Testing Region also i couldn't able to compile Normal Cobol programs also as 2 of the PDS are not Existing. i have tried to create it but it is giving error as Authorisation failiure.
Once again thank u so much.
Thanks and Regards,
Suganthy. |
|
Back to top |
|
|
sathish_rathinam
New User
Joined: 22 Aug 2005 Posts: 59 Location: india
|
|
|
|
hi suganthy,
for ur 4th question,answer is u can pass paramets thru run jcl to the cobol-db2 program like
STEP EXEC PGM=IKJEFT01
DSN SYSTEM(REGION NAME)
SYSTSIN DD *
RUN PROGRAM(PRGNAME)
PLAN(PLANNAME)
LIB(LIBRARYNAME)
PARMS(GIVE THE PARAMETERS HERE)
REGARDS,
SATHISH |
|
Back to top |
|
|
khamarutheen
Active Member
Joined: 23 Aug 2005 Posts: 677 Location: NJ
|
|
|
|
hi frnd,
No problem...i too facing the same problem in my shop. i had sent the mail to my frnds. once i get the right code i will post it. b patient. i cant assure u but mean while i will try my level best. Reshma may b in some tension while she post the solution. dont mistake her and dont fix her words in ur heart. Leave it and prepare well. All the best. |
|
Back to top |
|
|
suganthyprabha
New User
Joined: 28 Jul 2005 Posts: 58
|
|
|
|
Hi Kamarudeen,
Thanks a lot. I will do the best.
Hi sathish,
Thank u so much for ur reply.
Regards,
Suganthy. |
|
Back to top |
|
|
|