Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

swadesh yadav


{ City } bangalore
< Country > india
* Profession * s/w developer
User No # 21078
Total Questions Posted # 6
Total Answers Posted # 28

Total Answers Posted for My Questions # 32
Total Views for My Questions # 107832

Users Marked my Answers as Correct # 328
Users Marked my Answers as Wrong # 112
Answers / { swadesh yadav }

Question { 29027 }

How to add a field to a PF and compile it without loss of data?


Answer

First Add the fields whatever you want

then use CHGPF command

Physical file . . . . . . . . . > MyPf
Library . . . . . . . . . . . MyLib
System . . . . . . . . . . . . . *LCL
Source file . . . . . . . . . . MYSourceFile
Library . . . . . . . . . . . MyLib

Update the Physical file.No need to compile again.

Is This Answer Correct ?    24 Yes 0 No

Question { 20666 }

How to update only a field of a PF in an RPG program.
I don't want to update the record, only one field.


Answer

If file FileA has fields field1, field2, field3, and we
want to write out field2 only ...

C...except..Change

OfileA...E...Change
O...............field2

Hope it will work fine.

For Free Format try out following...

Update Recformat %fields(field2);

Is This Answer Correct ?    33 Yes 1 No


Question { 6709 }

1.what are the builtin funtions in cl pgg?Explain with
example
2.what is meant by left outer join?where we can use this?


Answer

Hi,
Refer to Cl reference book.

http://publib.boulder.ibm.com/infocenter/iadthelp/v7r0/topic
/com.ibm.etools.iseries.langref2.doc/rbam6builtinfunc.html

Is This Answer Correct ?    0 Yes 0 No

Question { 10367 }

what is difference between accespath and datapath?
what is the difference between accespath and open datapath?


Answer

Access Parh: Describes the Order in which records are to
be retrieved i.e Sequential Access path ,Keyed Access path.

Open Data Path: Provide the way for more then one program
in the same job to share the same file information like
file pointer position, storage area.
It is quite useful to improve the performances and reduces
the open/close file.

Is This Answer Correct ?    14 Yes 1 No

Question { ANZ, 15025 }

1.What is the difference between regular join logical file
and non join logical file?
2.what are the nessasary keywords for non join logical file


Answer

Answer1:
More than one Database file can be joined by different ways
like..
1)Inner join or Join Logical file
2)Left outer Loin
3)Right outer Join
4)Self join
These all are join logical file.
Non Join Logical file means Simple Logical file i.e Only
one PF file.
Answer2:
PFILE is the necessary keyword for non
join logical file.

R Rec-For PFILE(PF name)

Is This Answer Correct ?    20 Yes 0 No

Question { HCL, 12260 }

what is multijoin logical file?
what are the keywords available in joinlogical file?
what are the mandatary keywords for joinlogical file?
explai the keywords?


Answer

Keywords for Join logical file..
JDFTVAl(File Lavel Keyword)
JFILE (*Record format lavel Kewword)
JOIN (*Record format lavel Kewword)
JFLD (*Record format lavel Kewword)
JREF (*Field lavel Keyword)
JDUPSEQ (Field lavel Keyword)

* Manadatary Keyword

Is This Answer Correct ?    5 Yes 3 No

Question { 10782 }

1..Write an sql query to find the employee name who is
having 2 phone numebr?
2.Write an sql query to the the second highest salary of
the employee?


Answer

Q1:select Emp_name from Table-Name group by Emp_name having
count(Phone)=2

Hope it'll work out.

Is This Answer Correct ?    3 Yes 3 No

Question { IBM, 9552 }

1.Coding in cl to send an message?
2..What is turnover and use? What are the different levels?


Answer

Q2:Turnover is the Change managment tool.It have three
levels 1.Dovelopment level 2. Regression Testing Level
and 3. Production Level

Is This Answer Correct ?    2 Yes 2 No

Question { Hexaware, 13082 }

We have a Physical file, after reading 5 records,it has to
read LF of that same Physical file,Will it start reading
from Ist record or will start reading from 5th record?


Answer

It will start from first Record.

Is This Answer Correct ?    31 Yes 0 No

Question { Hexaware, 19699 }

In a particular program one file is used where override
command is applied to a file, now this program calls
another program where we want to use the same file but
without override.How it can be done?


Answer

Suppose File Name(MyFile) is overriding to File(MyFile1) in
one Cl program (i.e ClPGM1) by

Ovrdbf File(MyFile) ToFile(MyLib/MyFile1)

Now You are calling the program(i.e RPG1)in Cl Pgm(CLPGM1)
and want to use same file(MyFile1)

So Just Declare the File in F- spec

F MyFile1 IE F Disk
.
.
.
In this way we can use the file

Hope you got your answer!

Thanks!!

Is This Answer Correct ?    3 Yes 13 No

Question { 6532 }

how we create binder member for updating service program and
where we type this code on command line or in program ?
strpgmexp pgmlvl(*current)
export symbol (xyz0
endpgmexp.
plz explain me this step by step .


Answer

We write a program Of Source Type BND and write the code
inside it like..

strpgmexp pgmlvl(*current)
export symbol (xyz0)
endpgmexp.


Suppose later date you want to add another procedure say
(xyz1),you can do by
strpgmexp pgmlvl(*current)
export symbol (xyz0)
export symbol (xyz1)
endpgmexp.

strpgmexp pgmlvl(*Pre)
export symbol (xyz0)
endpgmexp.

In this way, we don't need to compile the other programs
which are using this service program cause this binder
contains both types of Signature Current as well as
Previous.




Thanks!!

Is This Answer Correct ?    11 Yes 0 No

Question { CSC, 46499 }

I want to add 10 days in current date. how it is possible in
CL program...?


Answer

Hi,
Try this one
PGM
DCL VAR(&DATE) TYPE(*Char) Len(6)
ADDDATE DAYS(10) TOVAR(&DATE) TOVARFMT(*SYSVAL) +
DATEFMT(*SYSVAL)
ENDPGM
you will get the flexibility by ADDDATE Command to change
the date format into desired format.

Is This Answer Correct ?    2 Yes 16 No

Question { CSC, 46499 }

I want to add 10 days in current date. how it is possible in
CL program...?


Answer

Opps!! by mistake i left the one line to add. that is...

PGM
DCL VAR(&DATE) TYPE(*Char) Len(6)
RTVSYSVAL SYSVAL(QDATE) RTNVAR(&DATE)
ADDDATE DAYS(10) TOVAR(&DATE) TOVARFMT(*SYSVAL) +
DATEFMT(*SYSVAL)
ENDPGM

Is This Answer Correct ?    13 Yes 10 No

Prev    1    [2]