|
View previous topic :: View next topic
|
| Author |
Message |
prasad43
New User
Joined: 21 Oct 2005
Posts: 7
Location: blore
|
|
|
|
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 |
|
 |
ikumar
New User
Joined: 02 Aug 2005
Posts: 81
|
|
|
|
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 |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL
|
|
| Back to top |
|
|
Sridevi_C
Active User
Joined: 22 Sep 2005
Posts: 104
Location: Concord, New Hampshire, USA.
|
|
|
|
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 |
|
|
ikumar
New User
Joined: 02 Aug 2005
Posts: 81
|
|
|
|
Hi Sridevi,
2) So, would cobol allow WS-ARRAY(0) ??????
that gives abend defenitely....
Thanks,
Kumar |
|
| Back to top |
|
|
Sridevi_C
Active User
Joined: 22 Sep 2005
Posts: 104
Location: Concord, New Hampshire, USA.
|
|
| Back to top |
|
|
|
|
