MainFrame Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

IBM MainFrame (5234)
IBM AS400 (1355)
IBM PL/1 (31)

MainFrame Interview Questions

Questions Answers Views Company eMail

how to fetch first 100 rows in db2

2 13160

when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations

IBM,

3 8210

if we give two job cards in a single what happens

IBM,

3 8472

how to split a file

IBM,

4 18067

can we display comp-3 variables. if we want to display what we have to do . give me one example

CGI, Deloitte,

6 49780

BY seeing a program how can we say that it is static call or dynamic call

CGI,

5 12902

The content of Physical file is as below: hfcftp wruquief SENDPASV 0 CDUP ASCII GET 01100901.CSV ramndk/ECP505.EC0110090 (REPLACE QUIT Thw above commands will get executed when we call STRTCPFTP from CL program.... Now if I want to use SFTP what can be the solution? plz reply in detail....Thank you for ny help... I m using RPG/ILERPG to download...

2365

can we use ASCII ,CDUP,SENDPASV commands in SFTP?

3664

If I want to execute Sftp commands(LS & GET) stored in Physical file from CL program automatically...Can u Plz tell me how can I do this?...How the script will look?? THANX FOR NY HELP...

2777

PGM QSH CMD('/QOpenSys/bin/sftp -b/home/test/myfile.txt serverUserID@server') ENDPGM In above example,what is content of myfile.txt ...Thanx

2 8175

what are the parameters required for calling ls & get command(SFTP COMMANDS) from cl progtram.... e.g call PGM(qp2shell) PARM('/qopensys/usr/bin/sh' '-c' 'sftp -b /home/mydir/tmp.txt user@host.com') Plz reply in detail...

1 7377

what are the parameters required for calling ls & get command(SFTP COMMANDS) from cl progtram.... I want to transfer files(using GET COMMAND) that are retrieved by LS command ...FROM 1 SYSTEM TO ANOTHER... STEP 1:LS-list all files...from remote system STEP 2:GET-actually transfer the files(listed in step 1) from remote system to local system & get stored in some Physical file....Plz reply in detail...Thanx

EDS,

1 4926

what is command in SFTP which is equivalent to SDUP command in FTP?

2 6850

WHICH REPLY CODE IS USED BT sftp ? ... (e.g.226 is used by FTP IF FILE IS TRANSFERED)

2169

Hi, can you plz tell me ...syntax for GET command in FTP & SFTP is same or different???

3 8466

Un-Answered Questions { MainFrame }

Does jcl support automatic restart?

1232

What is the difference between binary search and sequential search?

1089

what is scan and xlate?

1839

What does db2 stand for?

1025

How are type 1 and type 2 indexes different?

1018

What is the pic clause for the data type of length option field type of data fields?

943

What is the maximum number of subfiles that can be specified in a display file?

1921

Why is free space left in ksds dataset?

1138

Is db2 a mainframe?

1043

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2097

What is the meaning concurrency in the db2 database?

1110

how can you check if a file is empty using jcl?

1422

Explain the advantage of creating the acbs well ahead of time?

3571

How is next sentence and continue different?

983

how do we describe cataloged procedure and an instream procedure?

1083

For More Un-Answered { MainFrame } Questions Click Here