How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.
5612I was asked in HSBC interview following questions: 1. A string was given " techincal seminar on cobol language" Interviewer asked me to calculate the number of vowels in this string.
HSBC,
5 20190How do you unload data from DB2 tables into a PS file.write the code and how do you do it? what will be the syntax?
3 19165In a string " SEMINAR" .Replace "A" by 123. will this replacement will happen ot will it give error? If not , den what will be the output?
HSBC,
5 11110Write a JCL by using the below requirement: File1 =1, File2 =11 and output needs to come as File3 =111?
8 19922When concatenating two PDS can any one PDS can have empty dataset i.e without any value(Dummy).
2 7204How to solve SOC7. I have the cobol coded as below 01 A PIC 9(4). 01 AIN REDEFINES A. 05 AIN1 PIC S9(4) 01 B PIC 9(4)V99. 01 BIN REDEFINES B. 05 BIN1 PIC S9(4)V99. PROCEDURE DIVISION. START-PARA. INITIALIZE A AIN B BIN. ACCEPT A B. DISPLAY 'VALUE OF A=' A. DISPLAY 'VALUE OF B=' B. DISPLAY 'VALUE OF BIN1=' BIN1. DISPLAY 'VALUE OF AIN1=' AIN1. COMPUTE AIN1 = BIN1 - AIN1. DISPLAY 'VALUE OF AIN1=' AIN1. When i'm executing this code i'm getting SOC7 for A = 12 & B=34. Can someone explain SDSF OUTPUT DISPLAY TCOM058R JOB05458 DSID 102 LINE 0 COLUMNS 02- 81 COMMAND INPUT ===> SCROLL ===> CSR ********************************* TOP OF DATA ********************************** VALUE OF A=12 VALUE OF B=34 VALUE OF BIN1=34 VALUE OF AIN1=12 CEE3207S The system detected a data exception (System Completion Code=0C7). From compile unit PROG1 at entry point PROG1 at statement 29 at compile +000004CE at address 00007ECE. Please address how to solve this issue Thanks in advance.
1 9312I need to compare 3 variables(dates) and do some processing based on the earliest date. There could be more then 1 date record in any of the 3 fields. What is the best way to code this?
2338Hi, all suppose i have 5 steps (S1,S2,S3,S4,S5) what will happen if cond is true or false (which of the other steps get executed)? 1) //s3 exec pgm=abc,cond=(0,le) 2) //s3 exec pgm=abc,cond=(0,le,step2) 3) In the jobcord RESTART=step3,cond=(0,le) 4) can i code COND=TRUE in jobcard, if yes what will happen?
3 9799How to read records in reverse order in flat file? I know we can do it by reading all records into an array.... Then read records in reverse order by using subscript or index but can any body give me the exact code.
TCS,
5 21670Hi, all Suppose i have 10 step in a job (s1,s2,s3,...s10) i want to execute step9 first and then step3 and i used the DPRTY for these steps. so what will happen to other steps? Will the get executed or only these two steps get executed?
2 7127
How scary is it to write code for a bank?
Define autostatus in idms?
Explain the processing modes available in ims db?
How to check table size in db2 sap?
Which command is used to remove all rows from a table?
how you will the direct the data to spool using sysout option?
What is package in cobol db2?
List the type of locks?
What do you mean by the term fct?
How to List the Available Tables?
What is drda ?
What is the latest version of ibm db2?
Can I share my data with other jobs? How?
What parameter of the job statement is used to limit the cpu time consumed by the job?
hello friends ,i have exam in Hsbc,pls any on send me placement papers and technical questions on mainframes,thank u