What is dump

varsha · New User Joined: 20 May 2005 Posts: 12 Location: bangalore

HI,
What is dump? how & where is it used?

where is the structure of VSAM dataset get stored? i mean which lib?

when we declare a cursor where does the cursor pointer points?

I want to fetch a row from anywhere in the middle of a column, so how can i do this? pls snd me the code?

How & where can we use the bind statement? pls send me the code or screen shot?

what is DSORG? when should it be used?

varsha · New User Joined: 20 May 2005 Posts: 12 Location: bangalore

send me the code how to execute a set of JCL from cobol?

what is the use of null indicator?

whatever programs we code where do they get stored?

how to retrieve the first 10 rows of a table? pls send me the code?

how can we improve the performance of database?

krishh · New User Joined: 20 May 2005 Posts: 12

hai varsha,
dump means it contains information about the ouput of the job in spool.
when a job abended or to get the information about the status of the job
it is useful.
the storage of dump you can specify in job by using sysout .

for ur 2nd question
when a dataset created then it should be catloged in user catlog or in vsam catlog also the informaiton about the dataset is maintained in VTOC.
it contains information about the dataset.if you want to know the information about the dataset u can IDCAMS utility and specify in
sysin dd *
use LISTCAT ALL
it will give the entire information about datset.

krishh · New User Joined: 20 May 2005 Posts: 12

hai
Normally cursor declared for tables.and it will give a resultant table.
when u open the cursor it will point to the before first record in the table.

if you want to fetch rows from middle of the table.
for every table there is row-id so by using row-id we can access the required no.of records.

DOSRG means dataset organization it is used in jcl in the DCB parameter
it is used to declared the dataset organization while creating the datset.
DSORG=PO/PS.