I've one sequential file, That file contains millians of Junk & CHAR recoreds example File 1 ,,,,,...,,,.....,.,.INFOSYS.....,,,,,,,,,,,WIPRO..........., ,...,..,. My questions is : I want omit the 44th posstion to 4 CHAR (WIPRO) remaining things I want output file (including Junk CHAR also)... How can we slove this problem & give me a syntax. Please provide the result as soon as possible.
CTS,
5 9314i have two flat files.i want to select one record from that file by using jcl.for example file1 contains emp no,name,joining date. file2 has same details.emp no is primary key. i will give empno.that emp details send to outfile.please let me know if any one knows it.give sample code.
TCS,
1 6281How can I find the maximum value of a field in a file while reading the file dynamically? without using sort function. Suppose i have a file with fields Timestamp, description, teamname, teamnumber.. i have read the file till end and find the maximun value of timestamp which is not in sorted order.. can we use function max(timestamp)?
CGI,
1 12096I have the transaction name for cics screen.. With the transaction name, how will I find the cics program written for the transaction and BMS map program also...
CGI,
4 147305 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
2 5221if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
UST,
4 6567Is it possible to mutliply a comp variable with an comp-3 variable. Will there be any error if i do it?
3 8619If i have defined an temperory dataset in step2, how can i call back or use the same dataset in step5 of the same job
UST,
4 8311i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
UST,
3 5960if i am reading a file with some 50000 records and moving to a DB2 table and suddenly the program abends in between, is there anyway i could restart from the exact record at which the job failed once the program restarts.
UST,
2 7726first when i try to write a record into the file, wresp=duprec, but follwed with that if i try to read the record it say record not fnd.. actually the record is not written in the file, but it says that duprec when trying to write... why this happens, pls help me asap..!
1 4632
can I redistribute oorexx freely with commercial software?
what are the differences between temporary storage queue (tsq) and transient data quene (tdq)?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Can anybody tell what is tool used to generate the list of PROCS used in JCL to generate a PROCTREE
what is the meaning, the advantages and which are the types of evaluate statement?
What do you understand by the term “keyword” with respect to jcl and what is the opposite of the term?
What is meant by an AICA ABEND?
When the like statement is used?
What are foreign keys in db2?
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.
What is dbdgen process?
Tandem COBOL Interview questions (on TACL,SCOBOL,ENSCRIBE,PATHWAY0
how to pass the parameters from jcl to assembler pgm?
What is the idd in idms?
How to know whether the module is dynamical or statistical?