How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.
5540I 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 20025How 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 18989In 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 10897Write a JCL by using the below requirement: File1 =1, File2 =11 and output needs to come as File3 =111?
8 19648When concatenating two PDS can any one PDS can have empty dataset i.e without any value(Dummy).
2 7093How 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 9215I 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?
2276Hi, 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 9627How 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 21466Hi, 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 6996
What is the physical storage length of date data type?
Explain how to initialize a register to 0000?
Name the various locking levels available?
Hello Guys, I have 1+ Year Experience in MAINFRAME TESTING. After 1 Week I have an Interview With a Company on Mainframe Testing. Please Could You Guys Please Suggest me What Sections Should I prepare ?? ___Tell Me the Topic Or Appropriate Site & Links. ?? ---------------Thank You
What is the difference between nvl and coalesce?
how do you create a dataset in a jcl with the same file organisation as that of another existing dataset?
List the different components of jcl statement?
What are Naming Standards in QMF?
Explain the function of dd name parameter with a 2 part structure; audit.report?
Explain the difference between cics program control table (pct) and cics processing program table (ppt)?
what is the meaning, the advantages and which are the types of evaluate statement?
What is dbkey? Explain.
What is a vsam dataset?
How to code the db2 queries using rexx, and also plz send some link and examples using db2 queries?
Explain how can you accomplish breakpoint in intertest?