karthik gatla


{ City }
< Country > india
* Profession *
User No # 109166
Total Questions Posted # 39
Total Answers Posted # 23

Total Answers Posted for My Questions # 28
Total Views for My Questions # 89632

Users Marked my Answers as Correct # 17
Users Marked my Answers as Wrong # 0
Answers / { karthik gatla }

Question { IBM, 16837 }

Hello friends, i am new to AS/400. Can any one help me in
AS/400 i meant say can you send me some FAQS and interview
questions.


Answer

you have lots of questions in this website..............and.....also search in go4as400.com

Is This Answer Correct ?    1 Yes 0 No

Question { Patni, 10243 }

can we concate fileds in physical file? If yes how can we
do?


Answer

no...concatenation  of two/more fields in pf not possible...


  if you want to do it...it can be possible  with the help of  lf(logical file)



example: eid   concat(jdate name dept)

here eid created with
3 other fields:
they are
joining date and
name
and dept...

Is This Answer Correct ?    0 Yes 0 No


Question { 7434 }

In how many ways we can create a logical file?`


Answer

mr.venkat prasad sir  may i know how you create LF by using OPNQRYF

Is This Answer Correct ?    1 Yes 0 No

Question { 6711 }

How can we know that a trigger has been added on a PF? and
what is the purpose of adding a trigger?


Answer

sujata can you plz explain it with the help of example program.........

Is This Answer Correct ?    0 Yes 0 No

Question { 1726 }

IF a file has 10-members how do you process all of them?
using CL& USING RPG?


Answer

IN CL: OVRDBF FILE(FILENAME)    MBR(*ALL)


IN RPG: Use the keyword EXTMBR(*ALL) IN F-SPEC

Is This Answer Correct ?    0 Yes 0 No

Question { 1762 }

WHAT ARE THE RETRIVAL ORDER OF FILES IN RPG&sql?


Answer

IN rpg...>in keyorder if you defined key...otherwise it is in arrival sequence access path..



in SQL..>it is only in ARRIVAL SEQUENCE ACCESSPATH 

Is This Answer Correct ?    0 Yes 0 No

Question { 1823 }

Why we use  "OCCUR"  with multiple occurence DS(Data Structure)?


Answer

nothing but  Repetition of DS for N-no.of times...

Is This Answer Correct ?    0 Yes 0 No

Question { 2094 }

difference between MSGSFL AND SFL?


Answer

MSGSFL(MESSAGE SUBFILE):
i)displays multiple msgs...
ii)here   CLEAR && LOAD routines not required..
iii)enable to dispaly MULTIPLE ERROR MSGS  at a time...



sfl(subfile):
i)displays multiple records
ii)clear && load routines are required
iii)used to display multiple records at a time..

Is This Answer Correct ?    0 Yes 0 No

Question { 1915 }

what are the commands that frequently used in cl?


Answer

RTVSYSVAL

RTVMBRD

RTVJOBA

RTVOBJD

CVTDAT

CHGVAR

Is This Answer Correct ?    0 Yes 0 No

Question { 1959 }

how to find a   "source of particular program"?


Answer

DSPOBJD   OBJ(OBJ NAME)   OBJTYPE(*PGM)



                       Press enter

Option 8   to  "watch the program source"

Is This Answer Correct ?    0 Yes 0 No

Question { 1898 }

what does the keyword   SFLRCDNBR?


Answer

IT DISPLAYS    page of sfl   with selected  rcd nbr....


ex: sfl pag=3  sflsize=9

means i have total 9 records in sfl and each pag contaiins 3-records..........

1st page         2nd page         3rd page
rec=1            rec=4             rec=7
rec=2            rec=5             rec=8
rec=3            rec=6             rec=9



if SFLRCDNBR=8  then third page would be dispalyed

Is This Answer Correct ?    1 Yes 0 No

Question { 1819 }

is it possible to create a new field  dynamically?


Answer

yes...by using   opnqryf cmd...

so that you can define new field in  MAPFLD parm..

Is This Answer Correct ?    0 Yes 0 No

Question { 2084 }

what is the msg id for   OPNQRYF?


Answer

CPF9899

Is This Answer Correct ?    0 Yes 0 No

Question { 2382 }

error code 7030 cpf7030 what is the level check error


Answer

FIELD/INDICATOR NOT DEFINED

Is This Answer Correct ?    0 Yes 0 No

Question { 3719 }

does cl support arrays


Answer

NO

Is This Answer Correct ?    7 Yes 0 No

 [1]   2    Next