IBM MainFrame (5234)
IBM AS400 (1355)
IBM PL/1 (31) 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 11284i 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 7451How 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 13081I 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 165015 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 6377if 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 8268Is it possible to mutliply a comp variable with an comp-3 variable. Will there be any error if i do it?
3 10300If 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 10273i 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 7396
can error messages as a result of a comp, range or values keyword be overridden?
What is the meaning concurrency in the db2 database?
how can the same proc be re-used and called by many jobs?
What is the batch job?
how many files, printer files you can describe in a rpg?
Explain the difference between section, paragraph and sentences?
Can you explain dfhmdf bms macro?
what is the most common way of building queue-id of a tsq?
Are scope terminators compulsory? If they are, when?
is their a difference in cobol400 for the release 5.2 and 6.1 at the as400.
what is the difference between udate and the system date?
What is a trigger in the db2 database?
What are the 2 types of parameters in dd statement?
File1 has 100 records and file2 has 200 records I want to copy 50 records which are in both file into file3?
Why do we bind in db2?