mainframegurukul.com

Hi, We have SORT, DFSORT, SYNCSORT. All the sorts more or less do the same work. DFSORT is IBMS tool SYNCSORT is competing it. The syntax of SORT is Normally we give the input and the output files in the ddnames SORTIN and SORTOUT. and we also give the work files with some space allocated to them an...

Hi
We get a SOC4 error when
(1)Index exceeds the size of the table.
(2)When we use the file-section variables with out opening the file.

we get a SOC7 error when
(1)Moving the non-numeric value to a numeric value.
(2)Not initializing the numeric variables before the first use.

Hai,

Actually i wanted to know is there any difference between the direct access files and VSAM files. Please explain me in detail.

Thanks in advance.

Hi,
Can any body explain what is file-aid and why is it used ? please explain clearly?

Hai,
I read some basics about cursors and i wanted to know in detail what a cursor does and what are row positoned ,row-set positioned cursors.
and also what r scrollable ,non-scrollable,held and non-held cursors .
I saw the mainframe manuals other than that any links .

thanks in advance.

Hai
Can any one please tell me where can i find detailed information on cursors .
I mean any links that give detailed information on cursors.

Thanks in advance .

Hai,

Iam a beginner.Can anybody explain me about the foreign key i.e.

when we use references what is on delete set null

and what is on delete restrict

thanks in advance .

Hai,
Thanks dave.I saw the contents of the book and felt that the book is very good to learn the funda and the basics .

hai,
I wanted to know the good and easy book(i mean which is easily understood) for db2.I know cobol,jcl and want to learn db2.Iam a begginer.

thanks in advance.