Interested to Buy Any Domain ? << Click Here >> for more details...
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 11076i 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 7337How 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 12991I 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 163155 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 6238if 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 8092Is it possible to mutliply a comp variable with an comp-3 variable. Will there be any error if i do it?
3 10112If 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 10043i 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 7233if 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 8790first 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 5453
INCLUDE is used ONLY on MVS/ESA Version 4 or higher systems to name an INCLUDE group. An INCLUDE group is a set of one or more valid JCL statements that are stored together in a JCLLIB data set or a system procedure library, and that are read in and used to replace the INCLUDE statement itself within the job. Any number of INCLUDE statements can be used in a job, but the name field value used on each should be unique within the job. The INCLUDE statements can appear in a job anywhere after the JOB statement, but may not appear between a CNTL and ENDCNTL JCL statement.
Can we redefine the field of x(200) to less than 200?
Kindly specify the pic clause for the data type of length option field type of data fields?
What is a page in db2?
Explain in brief how does db2 determine what lock-size to use?
In sms datasets, what is the function of the dd mgmtclas keyword?
What is a run unit?
What is the difference between read work file 1 and read work file once? Why we are using work file once?
Difference between array and sub-script ?
List the different jcl statements that are not permitted in the procedures?
Explain how can the attributes of one sms dataset be copied to another dataset?
What is the use of lds (linear data set)?
Write a cobol program making use of the redefine clause.
What is the use of base and index registers in the IBM 360/370 processor?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
