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 # 94368

Users Marked my Answers as Correct # 17
Users Marked my Answers as Wrong # 0
Questions / { karthik gatla }
Questions Answers Category Views Company eMail

how can you define a dataarea(DTAARA) IN RPG? Which spec you define it C-spec/D-spec?

 IBM MainFrame AllOther 1513

what are the common errors that occured while programming in AS/400?

 IBM MainFrame AllOther 1201

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

 1 IBM MainFrame AllOther 1858

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

 1 IBM MainFrame AllOther 1895

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

 1 IBM MainFrame AllOther 1956

difference between MSGSFL AND SFL?

 1 IBM MainFrame AllOther 2283

what are the commands that frequently used in cl?

 1 IBM MainFrame AllOther 2049

how to find a   "source of particular program"?

 1 IBM MainFrame AllOther 2141

what does the keyword   SFLRCDNBR?

 1 IBM MainFrame AllOther 2036

is it possible to create a new field  dynamically?

 1 IBM MainFrame AllOther 1923

what is the msg id for   OPNQRYF?

 1 IBM MainFrame AllOther 2192

have you ever know what is the meaning of Packed Decimal  

 IBM MainFrame AllOther 1233

is it possible to write array elements to pf

 IBM MainFrame AllOther 1209

error code 7030 cpf7030 what is the level check error

 1 IBM MainFrame AllOther 2527

how will you find a particular line in debugging if its a infinite loop

 IBM MainFrame AllOther 1421

 [1]   2   3    Next



Answers / { karthik gatla }

Question { IBM, 17338 }

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, 10535 }

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 { 7789 }

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 { 6941 }

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 { 1858 }

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 { 1895 }

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 { 1956 }

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 { 2283 }

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 { 2049 }

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 { 2141 }

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 { 2036 }

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 { 1923 }

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 { 2192 }

what is the msg id for   OPNQRYF?


Answer

CPF9899

Is This Answer Correct ?    0 Yes 0 No

Question { 2527 }

error code 7030 cpf7030 what is the level check error


Answer

FIELD/INDICATOR NOT DEFINED

Is This Answer Correct ?    0 Yes 0 No

Question { 3903 }

does cl support arrays


Answer

NO

Is This Answer Correct ?    7 Yes 0 No

 [1]   2    Next