How to print output from openquery in as400 ?



How to print output from openquery in as400 ?..

Answer / ericles daltonious

OPNQRYF FILE((LIBRARY/INFILE)) QRYSLT('Selection')
CPYFRMQRYF FROMOPNID(INFILE) TOFILE(LIBRARY/OUTFILE)

Is This Answer Correct ?    18 Yes 2 No

Post New Answer

More RPG400 Interview Questions

Suppose I have 3 jobs a b and c. I want to submit b after successful completion of a and want to submit c after successful completion of b. Without using job scheduler or job queue, how can I do that through cl program?

1 Answers  


Can anybody tell me the setps to create .csv file in IFS folder on AS/400. I also need to know how I can send this .csv file to PC in xls sheet.....?

2 Answers  


IN RLU what are the record level keyword is used?

5 Answers   iGate, TCS,


what is the necessary keyword needed to scroll subfile records?

0 Answers   IBM,


What will be the value of STRING after line 0106 is executed in the code below? 0101 E* Fromfiletofile..tabnameprnentlenpdatabnamlenpda 0102 E ARR 8 1 0103 ISTRING DS 0104 I 1 8 ARR 0105 C MOVE *BLANK STRING 0106 C MOVEA'ABC' ARR A) 'AAAAAAAA' B) 'BBBBBBBB' C) 'CCCCCCCC' D) 'ABC ' E) ' ABC'

2 Answers  


in a cl pgm records are copied to a file in qtemp a pgm is called to delete records from the file in qtemp no of records in file in library qtemp is checked wat shud be the count of records let say it was 10 initially endpgm

2 Answers  


How can we access Interactive job LDA in Batch Job?. and How we can access a file in interactive QTEMP lib in Batch job?.

4 Answers   IBM,


how to find whether a date format is valid or not in RPG400 not in RPGILE.Can you please write the coding for this sir,i'm new to AS400.Please help.

1 Answers  


what are the parameters of jobd?give in detail.&what are the parameters of subsystem...????

1 Answers   CTS,


What are the types of identifiers?

0 Answers  


1.Can any body share me about thease opcodes with example please.Im new for AS/400.Could u please tell me in real senario? 1.TESTN, 2.EVAL 3.EVALR, TIME, 4.MONITOR 5. ENDMON 6.ON-ERROR 7.COMMIT ROLLBACK?

1 Answers   CSC,


How can you determine the number of characters in a variable?

3 Answers  


Categories