MVSFORUMS.com

Hi.

can i use SELECT * statement in embded SQl. like in cobol can i use this stetemnet. if yes can any one give me the syntax.

exec sql
select * into ......
end-exec.

what host varible ...

Hi,

I have one query. that is i have two input files and i want to write common records from two input files into out file using JCL.i know how to eliminate duplicate records, thru sort utility usi ...

Hi,

my question is s9(9) comp will occupy 4 bytes. and S9(10) comp will occupy 8 bytes. this everybody knows. but my doubt is why s9(9) comp is taking 4 bytes where as s9(10) comp is taking 8 bytes ...

Hi,

there is one sequential file having 100 records. for reading this file thru cobol program it is taking 5 minits. after 10 years same file and same progarm for reading it is taking more than 5 ...

Hi,

if i insert data into a DB-2 table. internally it will store the data in LDS data set formate. suppose i am inserting data into table1, is there any way to find out the name of the LDS data set ...

Hi,

can i have more than one file stucture for a file in my cobol program.

Bye
Raja

Hi,

i am using cobol program , in that i neeed to find out whcih call it is using to call a subrotuine. without seeing loadmodule and compilere options.

Bye

Hi,

How can we say that wether the program is using VSAM r NON-VSAM file by looking into JCL.

Bye
Raja

Hi,

How can we say that wether the main program is calling a subroutine .
eithere statically r dynamicllay. without seeing loadmodule and compiler options.

Bye

Raja

Hi,

if i use where, Group by, having, order by clauses in my select query what is the order it will execute. like whether it is order by or group by etc. could u plz tell me the order how it iwll e ...

Hi,

can u plz explain me the differance between SYNC sort and DFsort.

bye.
Raja

Hi,

1) How can i decide wether i have to use KSDS r ESDS files in my program.

2) if i defined file contol section with access mod e is Random can i access the file sequnetially. if it is not p ...

Hi ,

we all know that we can not pass instream data thru procs.if we want
pass we have to pass thru overriding parameters or tru control card.
could u please tell me the reason. why w ...

Hi,

How can i identify by looking into cobol program wether it is using VSAM files or NON-VSAM files?

How can i identify wether the subroutine is calling dynamically or statically?

In a cobol ...

Thanx for ur reply,

but if i insert a row into the view which was created without primary key, praimary key will be not null, so what will be inserted into that cloumn. if i insert thru view even ...