ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  MainFrame  >>  IBM AS400  >>  IBM AS400 AllOther
 
 


 

 
 RPG400 interview questions  RPG400 Interview Questions
 COBOL400 interview questions  COBOL400 Interview Questions
 DB400 interview questions  DB400 Interview Questions
 COOLPLEX interview questions  COOLPLEX Interview Questions
 IBM AS400 AllOther interview questions  IBM AS400 AllOther Interview Questions
Question 
WHICH COMMAND WE CAN USE TO UPDATE A PHYSICAL FILE USING C.L
PGM?
 Question Submitted By :: Cyjil
I also faced this Question!!     Rank Answer Posted By  
 
  Re: WHICH COMMAND WE CAN USE TO UPDATE A PHYSICAL FILE USING C.L PGM?
Answer
# 1		 
We cant update a database file using cl
 
Is This Answer Correct ?    18 Yes 2 No
Vignesh C
 
  Re: WHICH COMMAND WE CAN USE TO UPDATE A PHYSICAL FILE USING C.L PGM?
Answer
# 2		 
UPDATE
 
Is This Answer Correct ?    2 Yes 21 No
Ranjini
 
 
 
  Re: WHICH COMMAND WE CAN USE TO UPDATE A PHYSICAL FILE USING C.L PGM?
Answer
# 3		 
ranjini.. please tell the exact method
 
Is This Answer Correct ?    0 Yes 1 No
Cyjil
 
  Re: WHICH COMMAND WE CAN USE TO UPDATE A PHYSICAL FILE USING C.L PGM?
Answer
# 4		 
We can not update files from CL programs. We can read files
from CL.
 
Is This Answer Correct ?    9 Yes 0 No
Bharathi
 
  Re: WHICH COMMAND WE CAN USE TO UPDATE A PHYSICAL FILE USING C.L PGM?
Answer
# 5		 
We can update physical files from CL program by either 
usinf RUNSQLSTM or STRQMQRY
 
Is This Answer Correct ?    2 Yes 1 No
Sidd
 
  Re: WHICH COMMAND WE CAN USE TO UPDATE A PHYSICAL FILE USING C.L PGM?
Answer
# 6		 
PGM
        UPDDTA     FILE(*LIBL/FILENAME)
ENDPGM

By Using above command we update pf in cl pgm.
 
Is This Answer Correct ?    2 Yes 10 No
Nagaraju
 
  Re: WHICH COMMAND WE CAN USE TO UPDATE A PHYSICAL FILE USING C.L PGM?
Answer
# 7		 
By using RUNSQLSMT or STRQMQRY.
 
Is This Answer Correct ?    5 Yes 1 No
Mithun Paul
 
  Re: WHICH COMMAND WE CAN USE TO UPDATE A PHYSICAL FILE USING C.L PGM?
Answer
# 8		 
hi,

we can update data in cl, but we can use runsqlstm commance,

here if use select statement u canot select data, ucan 
update dlelete
 
Is This Answer Correct ?    2 Yes 3 No
Ramana
 
  Re: WHICH COMMAND WE CAN USE TO UPDATE A PHYSICAL FILE USING C.L PGM?
Answer
# 9		 
In CL program we can not update the database file ,
we can read only.
if any doubt contact at gauravag.innovative@gmail.com
 
Is This Answer Correct ?    6 Yes 0 No
Gaurav Agrawal
 
  Re: WHICH COMMAND WE CAN USE TO UPDATE A PHYSICAL FILE USING C.L PGM?
Answer
# 10		 
its not possible to update the physical file by using CL 
program.
 
Is This Answer Correct ?    8 Yes 0 No
Nagaraju
 
  Re: WHICH COMMAND WE CAN USE TO UPDATE A PHYSICAL FILE USING C.L PGM?
Answer
# 11		 
Use of RUNSQLSTM helps in updating the physical file within 
a CL program.

Syntax:

RUNSQLSTM SRCFILE(LIB/QSRCPF)SRCMBR(SQLPGM)COMMIT(*NONE)

SQLPGM should contain

UPDATE PF set DATA='Value' where DATA'='Value1' and it will 
update the PF
 
Is This Answer Correct ?    1 Yes 0 No
Anupam
 
  Re: WHICH COMMAND WE CAN USE TO UPDATE A PHYSICAL FILE USING C.L PGM?
Answer
# 12		 
i am sure cant update database file through clp.........
 
Is This Answer Correct ?    0 Yes 0 No
John
 

 
 
 
Other IBM AS400 AllOther Interview Questions
 
  Question Asked @ Answers
 
What is left outer join?  1
how to get no of records in file in rpg with out cl cmd iGate2
what is pointer error in rpg IV? CTS3
What is primary file? How many primary file can be declared in a RPG program? Valtech1
What is the difference between keys of a Physical file and the keys of a logical file? Bank-Of-America1
what are the types of errors available in rpg IV or 400.Like decimal data error,sessional error or device error etc...means important error occurings,ie to find out suddenly???pls give answ if u know? CTS1
Q.1.What is differences in STRDBG and STRISDB debugging commands? 2.Where we should use STRDBG and STRISDB Debugging commands? CTS4
Hi friends i have i question please reply me asap. what would be coding in DDS and programing part for this condition suppose that i have three fields in the display file(subfile)which has 7 record format. Condition is ''The supplier LOT, ISSUED TO PROD and LINE GRP fields in display file(Subfile) will not be shown if their respective fields are blank/zero in the record formats WIM311FM and Record format WIM311FM. I want coding part in DDS and Programing. Please reply me as soon as posible. IBM1
What is LEVEL CHECK? TCS4
how we lock a pf???? what are the parameters used in this command.how we understand whether an object is locked or not?? using command .....we have to use *PSSR? and trough *status..how??.if we give an eg to me???pls answer me anyone.. CTS3
how can i get the cursor position in display screen to to display my window?  4
Can you use multi format LF in CL program?  1
How to declare the length of emp no in the physilcal file and the mandatory length is 6 i.e. Emp No should be numeric, mandatory and fill all the 6 places  1
Hi Friends, I need immediately answer for this: Senario is that,I am selecting records from the display and window subfile on the basis of Reason Code and some more fields but spool file not showing the same records which i have selected by display and window subfile. Q.What could be the causes(resons)to not show records properly (just selected in the display file and Window subfile)according the selection criteria of the records. Q.What would be the solutions to show records properly in the spool file just as selected in in the display file and window subfile according to the selection criteria. IBM1
how can we view the entire objects and its types in a pgm? Mind-Tree7
Q.Suppose one job is running in a batch mode for a long time now i want to kill this batch job. how you achive this? IBM2
How many MONMSG commands can declare in a CL program?  1
PGM QSH CMD('/QOpenSys/bin/sftp -b/home/test/myfile.txt serverUserID@server') ENDPGM Can u plz tell me what the above code do exactly?  1
Hi, can you plz tell me ...syntax for GET command in FTP & SFTP is same or different???  2
what is the use of CPYFRMQRYF?  2
 
For more IBM AS400 AllOther Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com