How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.
5546I 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 20049How 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 19008In 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 10919Write a JCL by using the below requirement: File1 =1, File2 =11 and output needs to come as File3 =111?
8 19674When concatenating two PDS can any one PDS can have empty dataset i.e without any value(Dummy).
2 7112How 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 9220I 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?
2285Hi, 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 9662How 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 21493Hi, 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 7011
What is check constraint. Explain with example.
difference between tsq and tdq?
What are catalog tables in db2?
What is the syntax of JCL statement?
which parameter is used to check the syntax of a jcl without executing it?
How does a cursor work?
what are s0c1, s0c4, s0c5, s0c7 abends?
Define the necessity of run stats among the environment test?
How many types of evaluate statements are available?
What is the difference between drop table and delete table?
Can you name a few software running under the mainframe?
What are Naming Standards in QMF?
What language is db2 written in?
What is dpf in db2?
What rules are followed by the search verb.