insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
3 9741We are aware of eliminating the duplicate records from outyput fiel using sort utility. Can we get the duplicate records in to another file in the Same sort utility?
2 9162I have a KSDS File.I hav a Records like 1,2,3,4,5,6,...100. I want to read using Dynamic mode like from 10 th Record onwards like, 10,12,14,16,18,....60. Waht is the command for this.
CTS,
2 8504How can i write a comp-3 variable into a sequential file should i declara the field in the file description as comp- 3?
1 11192
I have a cobol db2 program(PGM A) where other program (PGM B) will call this program and passes some 50 fields data to PGM A. PGM A has some layout in which it receives the data from PGM B. And this layout has been copied in the linkage section pf PGM A. After getting the data, PGM A writes the data in a flat file in the same layout which it receives from PGM B. PGM B is a simple COBOL pgm. Please provide a JCL to run these programs.
Can you define an alias?
What is a configuration management system, give examples?
Write about the self-referencing constraint?
What is dbrm in db2 database?
What is psb?
Explain how and where is the twa size set?
Mention some fields that are a part of sqlca.
What is the maximum number of pcbs allowed in a psb?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
what are the various stages of job processing?
Discuss about changing dataset name in proc.
How is data retrieved from multiple tables using a single sql statement?
What is the job entry system used in your project? based on what criteria the sequence of jobs are picked if priority is not mentioned in the job card?
What is data manager?