insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
3 9613We 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 9034I 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 8408How can i write a comp-3 variable into a sequential file should i declara the field in the file description as comp- 3?
1 11092
i was faced one question- i have value -00001234.56 Suppress the zeroes and the output should be -1234.56 But Not - 1234.56 spaces should not be available after suppressing the zeroes. logic in jcl and cobol?
What is the eib?
How may sets be ordered?
What is runstats utility in db2?
Receive consists of buffer option in it. What is the significance of this option?
What kind of database is db2?
Explain how to receive data passed through jcl parm parameter in a natural program? How data definition is defined in the program?
What is meant by union and union all?
Whats the difference between search & search ALL?
Can you use max on a char column?
How can you access qsam (seq) files from cics?
What is the advantage of creating the acbs well ahead of time?
what are the thress bms options?
How do you stop a db2 database in linux?
My IMS main progam is calling Db2 subroutine ...Its giving - 923 db2 sql code..so could any one tell how to solve this issue.