Retrieving DDS Source
steve.c
I have a Physical File, but have no DDS source for it.
Is there a way of recreating the DDS source file, so that I can edit
it to create and amend fields?
Any help would be appreciated.
Regards,
Steve.
Richard Knechtel
do a DSPFFD (Display Field File Discription) on the file. it will give
you all the field names sizes type etc.. I use this now and again
myself!
--
Richard Knechtel
EDS
(Systems Engineer/System Administrator)
(Aspiring AS/400 GURU)
(Aspiring Linux GURU)
(Aspiring VB Programmer)
The contents of this message express only MY opinion.
This message does not necessarily reflect the policy or views of
my employer, EDS. All responsibility for the statements
made in this posting resides solely and completely with the
ME.
I Ex-Spaminate spammers!
See US Code Title 47, Sec.227(a)(2)(B), Sec.227(b)(1)(C)
and Sec.227(b)(3)(C).
Frank Healy
Steve:
Go to the http://www.news400.com site and look in the shareware
utilities section. There are a number of utilities that will recreate
DDS for PF/LFs.
Regards,
Frank
Dave Ritz
You can use the command DSPFFD to display the file's field descriptions.
tho...@inorbit.com
Steve:
Others have pointed out where you can find utilities for this, but I wanted to
point out that you need to be certain that this was a DDS-created file in the
first place. Especially with SQL use on the rise, you might recreate the file
but not duplicate it, i.e., it might not work exactly as it did before. And if
you're unlucky enough to have this linked to a data dictionary, you might mess
someone else up.
In short, there might never have been any DDS in the first place.
Tom Liotta
In article <3512a548...@news.dial.pipex.com>,
sjc...@dial.pipex.com (steve.c) wrote:
>
> I have a Physical File, but have no DDS source for it.
> Is there a way of recreating the DDS source file, so that I can edit
> it to create and amend fields?
> Any help would be appreciated.
>
> Regards,
> Steve.
>
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading
Bob Gilsdorf
Dave Ritz wrote:
>
> You can use the command DSPFFD to display the file's field descriptions.
>
>
> > I have a Physical File, but have no DDS source for it.
> > Is there a way of recreating the DDS source file, so that I can edit
> > it to create and amend fields?
> > Any help would be appreciated.
> >
> > Regards,
> > Steve.
You also need DSPFD to find out about any keys in the file. DSPDBR will
display the logical over the file.
--
R. Gilsdorf
AS/400 System Engineer
Sophisticated Systems Inc.
R...@centuryinter.net
helper
do a dspffd to a outfile then write a program to take the outfile and make
dds
it will help you learn something about the computer
or send me lots of money and i will do it for you
GEORGE WANG
You can use command RTVDSPSRC to retrieve physical file source code.
Usaigcr
Use RTVDSPSRC to get the source PF, and either build a program to recreate
the PF or do it by SEU...another way is using DSPFFD, next use DSPDBR to get
the LF's conected to your PF.......Good Luck.
Anton Gombkötö
RTVDSPSRC is not included in OS/400. The name of the command makes me think
of Retreive Display Source, which isn't suitable for PFs.
(There is also no RTVDDSSRC command).
As others already mentioned, there mustn't be a DDS from which a file has
been created.
Anton Gombkötö
Gombkoetoe@nospam@ASsoft.com
AS Software
Vienna, Austria, Europe
All opinions are mine, not necessarily those of my employer, AS Software.
GEORGE WANG schrieb in Nachricht <6f4kku$n...@bgtnsc03.worldnet.att.net>...
steve.c
I tried this and got 9 identical records; the last field being Format
Level Identifier ! - what do I do with it now?
Regards,
Steve.
David Dunfield
TAATOOLS contains RTVPFSRC to retrieve Physical File Source.
GEORGE WANG
Sorry, in my previous message, I misspelled the command. It should be RTVPFSRC.
Thanks David.
Anton Gombkötö
Ah!
Thank you, David, i will have to check TAA tools out once again; didn't
think of the commands in there.
Anton Gombkötö
Gombkoetoe@nospam@ASsoft.com
AS Software
Vienna, Austria, Europe
All opinions are mine, not necessarily those of my employer, AS Software.
David Dunfield schrieb in Nachricht <35165108...@net-link.net>...
Orangtang
I you have DBU, you can retrieve the source..or id you have TAATOOLS, there is
a cmd to retrieve the source...otherwise just do a DSPFFD and you can create it
from that...Ron
David Shea
My company sells a product called ARCTOOLS that, amongst other things,
will retrieve DDS source from compiled physical files. It also adds the
archiving feature to any existing purge program without programming, and
it will provide the ability to purge without programming.
Check out my web site at http://www.ziplink.net/~dcsoft/ or send me an
email for more information. If you are interested, I can get you a free
demo.
DAVE SHEA
DigitlDude
If you have a current version of TAATOLS there should be a command called
RTVPFSRC that will retrieve physical file source code for you.
Matthew Charlwood
In Article<199804020549...@ladder03.news.aol.com>,
<digit...@aol.com> writes:
> From: digit...@aol.com (DigitlDude)
> Newsgroups: comp.sys.ibm.as400.misc
> Subject: Re: Retrieving DDS Source
> Date: 2 Apr 1998 05:49:18 GMT
>
> If you have a current version of TAATOLS there should be a command called
> RTVPFSRC that will retrieve physical file source code for you.
Yeah...this is right Steve, use the command CRTTAATOOL to create the tool
RTVPFSRC...if you prompt CRTTAATOOL it'll give u all the info u need.
good luck
Matt
Richard Knechtel
What version of OS/400 is CRTTAATOOL in? it doesn't seem to be in V3R1
or V3R2?
Regards,
Matthew Charlwood
>
> What version of OS/400 is CRTTAATOOL in? it doesn't seem to be in V3R1
> or V3R2?
>
Richard,
the user tools have always been there as far as I know but they've disappeared
under the new release and you have to pay for them, but if you've got V3R2 or
earlier you will have them.
Basically you need to have the QUSRTOOL library setup...if it's not then
restore it from save files...if CRTTAATOOL does not exist as a cmd then you
need to create it. Look in the TXT file QATTINFO/CRTTAATOOL in QUSRTOOL for
details of how to create the command.
good luck
Matt
Any views expressed here are my own, humble, opinion and do not in any way
reflect the views of my employer..so there!