QDLS/*.txt to PF

Silenus paparias

unread,

Dec 20, 2011, 5:48:59 AM12/20/11

to

I have a txt in QDLS/ which contens only numbers.
i try to put this txt to a PF but without success.
if Upload this txt file with CA file transfer from PC, i use the
following *FDF file :
PCFDF
PCFT 1
PCFO 1,1,2,1,2
PCFL F1 160
which works without problems.

Can someone tell me the meanings of the FDF description so i can use
the right parameters on CPYFRMIMPF or CPYFRMPCD command ?

thanks in advantage.

CRPence

unread,

Dec 20, 2011, 1:39:47 PM12/20/11

to

On 20-Dec-2011 02:48 , Silenus paparias wrote:
> I have a txt in QDLS/ which contens only numbers. i try to put this
> txt to a PF but without success. if Upload this txt file with CA file
> transfer from PC, i use the following *FDF file :
> PCFDF
> PCFT 1
> PCFO 1,1,2,1,2
> PCFL F1 160
> which works without problems.
>

> Can someone tell me the meanings of the FDF description so I can use

> the right parameters on CPYFRMIMPF or CPYFRMPCD command ?

That is the old\Standard [versus Enhanced] Field Definition File
which describes the data in the "PC File". The first token PCFDF
indicates the file is an FDF, the PCFT is the File Type where 1=ASCII
Text, the PCFO is the File Options which I believe are DateFormat=1
DateSep=1 DcmlSep=2 TimeFormat=1 TimeSep=2, and the PCFL describes the
first and only field\column with name=F1 and 160-byte character.

Described as one column of text, I am not sure what would be the
point in adding CPYFRMIMPF into the mix.?

Regards, Chuck

Silenus paparias

unread,

Dec 21, 2011, 2:04:08 AM12/21/11

to

Hello Chuck.
Thanks for the respose.
As i see the PF in which must be puted the txt file has only on record
F1 and is 60-byte Character(and not 160 as i have mentioned above!).
The data In the txt file are written row by row, each row has 60-
characters.
Each row must be transfered as is, in the PF row by row.
i aim not sure which parametrs can i use for the CPYFRMIMPF command ,
especially for STRDLM,FLDDLM(since i have one FIELD), RCDDLM.?

CRPence

unread,

Dec 21, 2011, 1:08:13 PM12/21/11

to

On 20-Dec-2011 23:04 , Silenus paparias wrote:
> On 20 Δεκ, 20:39, CRPence<CRPe...@vnet.ibm.com> wrote:
>> On 20-Dec-2011 02:48 , Silenus paparias wrote:
>>
>>> I have a txt in QDLS/ which contens only numbers. i try to put
>>> this txt to a PF but without success. if Upload this txt file
>>> with CA file transfer from PC, i use the following *FDF file :
>>> PCFDF
>>> PCFT 1
>>> PCFO 1,1,2,1,2
>>> PCFL F1 1 60
>>> which works without problems.
>>
>>> Can someone tell me the meanings of the FDF description so I can
>>> use the right parameters on CPYFRMIMPF or CPYFRMPCD command ?
>>
>> That is the old\Standard [versus Enhanced] Field Definition File
>> which describes the data in the "PC File". The first token PCFDF
>> indicates the file is an FDF, the PCFT is the File Type where
>> 1=ASCII Text, the PCFO is the File Options which I believe are
>> DateFormat=1 DateSep=1 DcmlSep=2 TimeFormat=1 TimeSep=2, and the
>> PCFL describes the first and only field\column with name=F1 and

>> 60-byte character.
>>
>> Described as one column of text, I am not sure what would be the
>> point in adding CPYFRMIMPF into the mix.?
>>
>

> As I see the PF, in which must be put the txt file, has only on record
> F1 and is 60-byte Character. The data In the txt file are written row

> by row, each row has 60-characters.

> Each row must be transferred as is, in the PF row by row. I am not
> sure which parameters can I use for the CPYFRMIMPF command,
> especially for STRDLM,FLDDLM (since I have one FIELD), RCDDLM.?
>

Use CPYFRMSTMF instead; a simple text-to-text copy. CPYFRMIMPF
should be possible, identifying the data in the stream file as "*FIXED"
instead of "*DLM", but then an FDF is required. The CPYFRMIMPF is a
database data import facility, and a simple text copy does not require
that tool. The RCDDLM tells the import facility what is the "end of
record" in the stream file.

Regards, Chuck

CRPence

unread,

Dec 22, 2011, 7:22:35 AM12/22/11

to

On 20-Dec-2011 23:04 , Silenus paparias wrote:

> On 20 Δεκ, 20:39, CRPence<CRPe...@vnet.ibm.com> wrote:
>> On 20-Dec-2011 02:48 , Silenus paparias wrote:
>>
>>> I have a txt in QDLS/ which contens only numbers. i try to put
>>> this txt to a PF but without success. if Upload this txt file
>>> with CA file transfer from PC, i use the following *FDF file :
>>> PCFDF
>>> PCFT 1
>>> PCFO 1,1,2,1,2
>>> PCFL F1 1 60
>>> which works without problems.
>>
>>> Can someone tell me the meanings of the FDF description so I can
>>> use the right parameters on CPYFRMIMPF or CPYFRMPCD command ?
>>
>> That is the old\Standard [versus Enhanced] Field Definition File
>> which describes the data in the "PC File". The first token PCFDF
>> indicates the file is an FDF, the PCFT is the File Type where
>> 1=ASCII Text, the PCFO is the File Options which I believe are
>> DateFormat=1 DateSep=1 DcmlSep=2 TimeFormat=1 TimeSep=2, and the
>> PCFL describes the first and only field\column with name=F1 and

>> 60-byte character.
>>
>> Described as one column of text, I am not sure what would be the
>> point in adding CPYFRMIMPF into the mix.?
>>
>

> As I see the PF, in which must be put the txt file, has only on record
> F1 and is 60-byte Character. The data In the txt file are written row
> by row, each row has 60-characters.
> Each row must be transferred as is, in the PF row by row. I am not
> sure which parameters can I use for the CPYFRMIMPF command,
> especially for STRDLM,FLDDLM (since I have one FIELD), RCDDLM.?
>

Apologies if this is a duplicate; I received an error sending the
first time.