Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
I have doubts plz clarify it

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
prasad43

New User


Joined: 21 Oct 2005
Posts: 7
Location: blore

PostPosted: Thu Oct 27, 2005 5:23 pm    Post subject: I have doubts plz clarify it
Reply with quote

what is the max value of N in OCCURS N times.
2)occurs 0 times is valid or not.
3)2 JOBNAMES are same is it valid or not.
4)If we give JOBNAME and STEPNAME are same is it will execute or not
5)I have 2 files in COBOL with some fields on both files
I want third file with matching fields of file1 in file2.what is the logic.
6)I have one table with 5 fields.I want to count total no of rows in one field only.
7) I want to retrieve records in one table and update one field at every fifth recorin that atble.
8) Howmany jobs we can submit max at a time.[color=blue][/
Back to top
View user's profile Send private message

ikumar

New User


Joined: 02 Aug 2005
Posts: 81

PostPosted: Thu Oct 27, 2005 5:51 pm    Post subject: Re: I have doubts plz clarify it
Reply with quote

Please post the questions in the right forum...

1) In Enterprise COBOL, the limit is 134,217,727
2) occurs 0 is not valid
3) If both the jobnames present in one member, then it should be different, otherwise you can have same job names, if the jobs are in different members.
4) It executes
5) need clear explanation....
6) select count(*) as noofrows from table-name
7) use cursor and update after every 5th fetch....
8) It depends on shop set-up....

Please let me know if i am wrong anywhere...

Cheers,
Kumar.
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Thu Oct 27, 2005 6:14 pm    Post subject: Re: I have doubts plz clarify it
Reply with quote

5) http://ibmmainframes.com/viewtopic.php?t=4340

Regards,

Priyesh.
Back to top
View user's profile Send private message
Sridevi_C

Active User


Joined: 22 Sep 2005
Posts: 104
Location: Concord, New Hampshire, USA.

PostPosted: Thu Oct 27, 2005 7:24 pm    Post subject:
Reply with quote

Hi,
2)occurs 0 to 10 times depending on dataname is valid.
3)2 jobnames can be same.But the problem comes when one abends and you got to debug.
6)count(*) can not be used to count total no of rows in "one field only".It counts null values and duplicates too, for the rows in a "table".Try this...
SELECT COUNT(field1) FROM table;To eliminate duplicates go for
SELECT COUNT(DISTINCT field1) FROM table;
Regards,
Sridevi.
Back to top
View user's profile Send private message
ikumar

New User


Joined: 02 Aug 2005
Posts: 81

PostPosted: Thu Oct 27, 2005 8:40 pm    Post subject: Re: I have doubts plz clarify it
Reply with quote

Hi Sridevi,

2) So, would cobol allow WS-ARRAY(0) ??????
that gives abend defenitely....

Thanks,
Kumar
Back to top
View user's profile Send private message
Sridevi_C

Active User


Joined: 22 Sep 2005
Posts: 104
Location: Concord, New Hampshire, USA.

PostPosted: Thu Oct 27, 2005 9:57 pm    Post subject:
Reply with quote

Hi Kumar,
2)Yes it does in case of dynamic table.Refer manual.
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/IGYL1101/2.7.6.2?SHELF=&DT=19930312093006&CASE=
Regards,
Sridevi.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Please clarify an doubt in DB2 tables... Machani Hanuprasad DB2 2 Mon Aug 06, 2012 12:38 pm
No new posts Doubts in MQ data Converstions Thamilselvi Java & MQSeries 3 Mon Jul 02, 2012 3:48 pm
No new posts Doubts related to insertion of table ... Vidya Kajale COBOL Programming 1 Tue Apr 24, 2012 11:54 am
No new posts Doubts regarding Merging Rahul_kumar JCL & VSAM 5 Wed Apr 27, 2011 4:41 pm
No new posts Doubts in LA BhavaniV PL/I & Assembler 4 Wed Oct 06, 2010 6:45 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us