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
how a varible can be passed to a subfile...accnt1 contain
data in a data area..ie Daccnt1 uds,Daccnt2 3
overlay(accnt1:1),
DNo 4 overlay(accnt1:4)..we want to transfer this dataarea
value from acnt0001 to a subfile..that means to enter each
record we have to incriment account no,,
i normal window we can do
move accnt1 account_no
eval account_no=accnt1
eval no=no+1
exfmt usr_account
how it possible with Subfile????????.Please do answer?
(Thank you for all your answers dear friends!!)
I/o error detected,Record Out of sequence,Permanent I/o
error occured....I mean give one eg for these errors...i
understand only,update/delete operation without prior read
oprn..give details of remaining
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?Pls give the answer
1,,,,,,,to 12.........ie how it will happened like...for eg
if a file is not closiing ,,,like this error is happened...
if sufficient data is not in a pf to write in a display
file. or sfldsp is not "on"......sessional or device error
occured...like this give details all 1 to 12 errors
(syam..)....give details PLsssssssssss?
give an eg of ACQ-(ACQUIRE),BIT OFF,BIT
ON,DEALLOC,DUMP,FEOD,FORCE,MHHZO,MHLZO,MHLLZO,MLHZO,REL,RESET,TESTZ,TESTB,TESTN----GIVE
SMALL EXAMPLE TO THE OPCODES...TO UNDERSTAND
FUNCTIONING...........
If I want to execute Sftp commands(LS & GET) stored in
Physical file from CL program automatically...Can u Plz
tell me how can I do this?...How the script will look??
THANX FOR NY HELP...
21
RETRIVING DELETED RECORDS :-
I'm frequently asked how to retrieve deleted records from
an unjournaled physical file when the deleted records have
not yet been removed from the file.
Utility UNDEL lets you undelete records in a physical file.
This public domain program is available in CISC and RISC
versions, and the complete source code is available for
download at:
UNDEL for AS/400 Save File (RISC):
http://www.as400network.com/sharewarefiles/undelris.zip
UNDEL for AS/400 Save File (CISC):
http://www.as400network.com/sharewarefiles/undel.zip
UNDEL for AS/400 Save File (Source code):
http://www.as400network.com/sharewarefiles/undelsrc.zip
The utility takes advantage of the fact that deleted
records in physical files are only flagged as deleted, and
the record data still exists until it is overwritten or the
file is reorganized with a utility such as RGZPFM. UNDEL
simply reads the deleted record, then reuses the record by
writing over it with the new record (thus eliminating the
flag for the deleted record).
Some homegrown and commercial utilities copy the file
containing undeleted records to a save file, then use a
program to read the save file, which contains live and
undeleted records, to a file to undelete the records. The
UNDEL utility is superior to the SAVF technique because
there's no need to copy the file to a save file, which is
especially important for really large files.
When run, UNDEL displays the physical file records in their
unformatted, raw text form. You can either position the
display to a given relative record number or use F19 or F20
to find the previous and next deleted record, respectively.
The utility also includes online help, which is almost
unheard of for free utilities.
Other utilities include the ability to undelete records.
You can use the RTVDLTRCD command in the old QUSRTOOL (no
longer supported by IBM). QUSRTOOL is now a commercial
product called TAA Productivity Tools (
http://www.taatool.com ). The free file editor WRKDBF has a
built-in undelete capability ( http://www.wrkdbf.com ), and
several commercial file editors can undelete records. For a
complete list of file editors, go to
http://www.sourcebook400.com, select "Programmer Tools"
under "Product Category," then select "File Editors."
104
what is primarykey?what is difference between primary key
and forign key?
28
What you have to do in the display file when you are using
message subfile?
17
How do I remove a flag or check no. or name when a user
opens too many sessions?
162
Write the subfile logic program for the given concept. Load
the data to the subfile
depends upon the designation where designation is not a
key field?
Q:HI friends accually ihave one problem plesase let me know
the alternate code of this code.
Related field description of code:
Add a field, CALvsPRD, "Calendar Day Starts Before/After
Production Day" to the parameter set WRKORDER which accepts
values 'A' or 'B'
o B = Calendar Day Starts Before Production Day
o A = Calendar Day Starts After Production Day
o Any other value indicates the production and
calendar dates are always the same.
code:
Automatic Execution Of *INZSR Subroutine
/Z01 * retrieves WRKORDER field values.
/Z01 * Calculate default Production Date and return it to
caller.
/Z01 * Production date defaults to system date
/Z01 C Eval P@Pdate = %DATE()
/Z01 * unless Calendar date starts Before PDN(production)
date and
/Z01 * system time is before PDN Start Time then
/Z01 * PDN date is yesterday.
/Z01 C If W@CALvsPRD = 'B'
and
/Z01 C %TIME() < %TIME
(W@Strtime)
/Z01 C Eval P@Pdate -= %Day(1)
/Z01 * unless Calendar date starts After PDN date and
/Z01 * system time is *GE PDN(production) Start Time then
/Z01 * PDN date is tomorrow.
/Z01 C ElseIf W@CALvsPRD = 'A' and
W@Strtime > *Zero and
/Z01 C %TIME() >= %TIME
(W@STrtime)
/Z01 C Eval P@Pdate += %Day(1)
/Z01 C
EndIf
/Z01 C Eval *InLr = *On
what is OUTFILE?what is the uses and disadvantage?
where we can use this?
24
How to create a link between multiple maps in a mapset? How
to make use of Transid in this case?
196
can anybody help me to solve this problem. the program that
i m checking display error message saying "Record format
for file AJDSPFFD does not match model file and decimal
error. how to solve this problem. The AJDSPFFD is snapshot
the AJTLOG that is the audit trail list.
124
in which journalling which attributes are necessary
WHICH REPLY CODE IS USED BT sftp ? ...
(e.g.226 is used by FTP IF FILE IS TRANSFERED)
24
can I copy content of Physican file in some source Member
of type TXT?
Thanx..
15
what are the parameters required for calling ls & get
command(SFTP COMMANDS) from cl progtram....
I want to transfer files(using GET COMMAND) that are
retrieved by LS command ...FROM 1 SYSTEM TO ANOTHER...
STEP 1:LS-list all files...from remote system
STEP 2:GET-actually transfer the files(listed in step 1)
from remote system to local system & get stored in some
Physical file....Plz reply in detail...Thanx
15
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
7
can we use ASCII ,CDUP,SENDPASV commands in SFTP?
19
Q:Hi all,i want accurate answer with code using in built
functions.please sent me code as soon as posible.
I have program nmed PGM1 which '' RETRIEVE Current
production date''should correctly default the production
date for the user who is issuing raw materials to the
manufacturing.The production date can be different from the
celendra date.
However, the program does not make the correct adjustment
for all manufacturing plants.
there is a parameter which determines the
production start time e.g. 07:00 if the system time
precedes this,the program subtracts one from the celendra
day.This work fine when the celendar day starts after
production day as it does in England,the system should be
adding one to the celendar day during the overlap.
unfortunately the program was desined to assumed the
celendar day always starts before the production day.
Change required in the program:
Change the
PROGRAM PGM1 to use the new parrameter to decide whether to
add or subtract 1 from the celendar day when determining
the production date.
To Refer this Site to Your Friends 
Site Map
