How do you check for a null value in a db2 column?

Have you used comp and comp-3 in your project? And how?

IBM,

Why we are using comp and comp-3 in real time projects?

IBM,

Have you used the sort in your project?for this type of questions any working on real time project give the eg. with real time scenario.

IBM,

How to code fscode 10 in cobol program? Where yoy code in your pgm?give ans for the question.

IBM,

how to check whether the open command of a sequential file is successful? or not?

CSC, IBM,

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

Our issue is there seems to be a disconnect, or no link, between our SELECT statement and our SD. We had SELECT SORT-FILE and SELECT SORT-FILE ASSIGN TO SORTWRK. ASSIGN TO SORTWRK1 SORTWRK2 SORTWRK3 SORTWRK4. with SD SORT_FILE RECORD CONTAINS 7833 CHARACTERS. In either case, at run time, the system ignored our SORTWRK# DD statements and allocated 16 sort works with the SORTWK## naming convention. Any ideas why the system does not recognize the connection? We do not even need the SORTWRK DD statements. Thanks

Hello, I have 3 years of exp as a mainframes tester in a leading IT company, now am looking to change my company. Could you please let me know, what are the interview questions/topics i should prepare. Your suggestions are truly valuable for me :) Thanks !!

How to submit multiple jobs. These jobs are members in PDS. The second job should run if the first job runs successfully and so on.

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

Infosys,

what is the sortcard for comparing two files with a field key and get the duplicates in onefile and noduplicates in another file

Virtusa,

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

IBM,

In your JCL, run the even numbered steps if date is even and run odd numbered steps if date is odd . Where do you generate the date ??in cobol or JCL ??

CSC,

How to find the length of variable length copybook using fileaid ??

CSC,