Is line sequential file read by PH on HP-UX 11i/9000
Edis, Robert
Robert.Edis@blistex.com
Thu, 15 May 2003 10:57:15 -0500
Raj
It appears to from that your record definition in the PHD needs to have an
extra char added to it to handle the explicit LF. Just create a new item
called 'LF' or whatever at the end of the record item list.
Blue
-----Original Message-----
From: raj hanchan [mailto:raj_hanchan@rediffmail.com]
Sent: Thursday, May 15, 2003 10:51 AM
To: Edis,Robert
Subject: Re: RE: Is line sequential file read by PH on HP-UX 11i/9000
Blue,
Thanks for your prompt reply. Here is the test results of both line seq and
seq. I have used a c program convert_lseq2seq.exe to convert from line seq
to seq.
About CR/LF yes i do see LF(\n with od -c command) in my line seq data file.
/dtest/data_conversion/cisamtest >ls -l *.pdl
-rwxr-xr-x 1 dtestbat dtestgrp 421 May 10 23:56 TSTDATATEST.pdl
/dtest/data_conversion/cisamtest >cat TSTDATATEST.pdl
element REC-KEY-TSTDATATEST CHARACTER size 28
element ACCT-NO CHARACTER size 14
element TEST-NO CHARACTER size 14
element CALL-ID CHARACTER size 16
file TSTDATATEST organization sequential &
open $DIRDATA/TSTDATATEST
record TSTDATATEST
item REC-KEY-TSTDATATEST datatype CHARACTER size 28
begin structure
item ACCT-NO datatype CHARACTER size 14
item TEST-NO datatype CHARACTER size 14
end structure
item CALL-ID
load
/dtest/data_conversion/cisamtest >ls -l *.pdc
-rw-r--r-- 1 dtestbat dtestgrp 12498 May 10 23:57 testdict.pdc
/dtest/data_conversion/cisamtest >ls -l TESTL0010TEST.*
-rw-r--r-- 1 dtestbat dtestgrp 1719 May 10 23:52
TESTL0010TEST.QZS
-rw-r--r-- 1 dtestbat dtestgrp 5376 May 10 23:58
TESTL0010TEST.qzc
/dtest/data_conversion/cisamtest/data >ls -l
/dtest/data_conversion/cisamtest/data >ls -l *.dat
-rw-r--r-- 1 dtestbat dtestgrp 1035 May 11 03:14 TSTDATA.dat
/dtest/data_conversion/cisamtest/data >cat TSTDATA.dat
82009963097043AL560404A 008521972580091F
82293925024229AL588562A 008521972381010F
82293925024229AL588564A 008521972580041F
96077805003107AL540466A 008521972390062F
96077805003107AL540467A 008521972991003F
96077805003107AL540468A 008521972590023F
96077805003107AL540469A 008521972991013F
98152574000123AL560422A 008521972380003F
98152574000123AL560484A 008521972381021F
98152576000113AL560423A 008521972580003F
98152576000113AL560485A 008521972980023F
98152579000195AL560424A 008521972580113F
98152579000195AL560486A 008521972980100F
98152580000137AL560425A 008521972980091F
98152580000137AL560487A 008521972580021F
98152584000117AL560426A 008521972980092F
98152584000117AL560488A 008521972580022F
98152587000102AL560427A 008521972580012F
98152587000102AL560489A 008521972980103F
98152590000131AL560428A 008521972980080F
98152590000131AL560490A 008521972580143F
98152591000126AL560429A 008521972580121F
98152591000126AL560491A 008521972980101F
/dtest/data_conversion/cisamtest/data >cp TSTDATA.dat TSTDATATEST.dat
/dtest/data_conversion/cisamtest/data >cat TSTDATATEST.dat
82009963097043AL560404A 008521972580091F
82293925024229AL588562A 008521972381010F
82293925024229AL588564A 008521972580041F
96077805003107AL540466A 008521972390062F
96077805003107AL540467A 008521972991003F
96077805003107AL540468A 008521972590023F
96077805003107AL540469A 008521972991013F
98152574000123AL560422A 008521972380003F
98152574000123AL560484A 008521972381021F
98152576000113AL560423A 008521972580003F
98152576000113AL560485A 008521972980023F
98152579000195AL560424A 008521972580113F
98152579000195AL560486A 008521972980100F
98152580000137AL560425A 008521972980091F
98152580000137AL560487A 008521972580021F
98152584000117AL560426A 008521972980092F
98152584000117AL560488A 008521972580022F
98152587000102AL560427A 008521972580012F
98152587000102AL560489A 008521972980103F
98152590000131AL560428A 008521972980080F
98152590000131AL560490A 008521972580143F
98152591000126AL560429A 008521972580121F
98152591000126AL560491A 008521972980101F
/dtest/data_conversion/cisamtest/data >cd ..
/dtest/data_conversion/cisamtest >echo $DIRDATA
/dtest/data_conversion/cisamtest/data
/dtest/data_conversion/cisamtest >ls -l *.txt
*.txt not found
/dtest/data_conversion/cisamtest >quiz dict=testdict
Q U I Z (PowerHouse 8.23.D7)
Copyright 2001 COGNOS INCORPORATED
Licensed PH8-DEMO for customer: 0712570002 COGNOS HU DEMO
Warning: Temporary licensing of PowerHouse Server products expires
15-May-2033.
Please contact your local Sales Administration office for a permanent
license.
> execute TESTL0010TEST.qzc
Records selected: 23
Records sorted: 23
Lines printed: 30
Pages printed: 1
> e
/dtest/data_conversion/cisamtest >ls -l *.txt
-rw-r--r-- 1 dtestbat dtestgrp 3105 May 11 03:42
TESTL0010TEST.txt
/dtest/data_conversion/cisamtest >cat TESTL0010TEST.txt
DATE - 2003/05/11 TEST BILLING SYSTEM
REPORT - TESTL0010
TIME - 03:42 MONTHLY SYSTEM PROFILE -- ACCOUNT /
TEST LINE PAGE - 1
ACCOUNT NO SUBSCRIBER NAME LINE
NO. CALL ID
----------------------------------------------------------------------------
--------------------------------------------------------
8229392502422 9AL588562A
008521972381010
008521972 580121F
981525 91000126AL560491
0085219725 80143F
9815259 1000126AL560429A
00852197298 0080F
98152590 000131AL560490A
008521972980 103F
981525900 00131AL560428A
0085219725800 12F
9815258700 0102AL560489A
0023F
96077805 003107AL540469 A
0085219729
003F
960778050 03107AL540468A
00852197259
00852197258002 2F
98152587000 102AL560427A
08521972980092 F
981525840001 17AL560488A
1972580113F
98 152579000195AL 560486A
0085
1F
96077805003 107AL540466A
0085219723900
DATE - 2003/05/11 TEST BILLING SYSTEM
REPORT - TESTL0010
TIME - 03:42 MONTHLY SYSTEM PROFILE -- ACCOUNT /
TEST LINE PAGE - 1
ACCOUNT NO SUBSCRIBER NAME LINE
NO. CALL ID
----------------------------------------------------------------------------
--------------------------------------------------------
8229392502422 9AL588562A
008521972381010
008521972 580121F
981525 91000126AL560491
0085219725 80143F
9815259 1000126AL560429A
00852197298 0080F
98152590 000131AL560490A
008521972980 103F
981525900 00131AL560428A
0085219725800 12F
9815258700 0102AL560489A
0023F
96077805 003107AL540469 A
0085219729
003F
960778050 03107AL540468A
00852197259
00852197258002 2F
98152587000 102AL560427A
08521972980092 F
981525840001 17AL560488A
1972580113F
98 152579000195AL 560486A
0085
1F
96077805003 107AL540466A
0085219723900
21972980100F
9 8152580000137A L560425A
008
2381021F
98152 576000113AL560 423A
0085219
380003F
981525 74000123AL5604 84A
00852197
521972980091F
98152580000137 AL560487A
00
62F
9607780500 3107AL540467A
008521972991
72580003F
9815 2576000113AL56 0485A
008521
82009963097043
AL560404A 008521972580091F
8521972580021F
9815258400011 7AL560426A 0
91013F
9815257 4000123AL56042 2A
008521972
972980023F
981 52579000195AL5 60424A
00852
F
822939250242 29AL588564A
00852197258004
----------------------------------------------------------------------------
--------------------------------------------------------
NO. OF ACCOUNT = 23
*** End of Report
***
/dtest/data_conversion/cisamtest >cd data
/dtest/data_conversion/cisamtest/data >ls -l *.dat
-rw-r--r-- 1 dtestbat dtestgrp 1035 May 11 03:39 TSTDATATEST.dat
-rw-r--r-- 1 dtestbat dtestgrp 1035 May 11 03:14 TSTDATA.dat
/dtest/data_conversion/cisamtest/data >cat TSTDATATEST.dat
82009963097043AL560404A 008521972580091F
82293925024229AL588562A 008521972381010F
82293925024229AL588564A 008521972580041F
96077805003107AL540466A 008521972390062F
96077805003107AL540467A 008521972991003F
96077805003107AL540468A 008521972590023F
96077805003107AL540469A 008521972991013F
98152574000123AL560422A 008521972380003F
98152574000123AL560484A 008521972381021F
98152576000113AL560423A 008521972580003F
98152576000113AL560485A 008521972980023F
98152579000195AL560424A 008521972580113F
98152579000195AL560486A 008521972980100F
98152580000137AL560425A 008521972980091F
98152580000137AL560487A 008521972580021F
98152584000117AL560426A 008521972980092F
98152584000117AL560488A 008521972580022F
98152587000102AL560427A 008521972580012F
98152587000102AL560489A 008521972980103F
98152590000131AL560428A 008521972980080F
98152590000131AL560490A 008521972580143F
98152591000126AL560429A 008521972580121F
98152591000126AL560491A 008521972980101F
/dtest/data_conversion/cisamtest/data >cat TSTDATA.dat
82009963097043AL560404A 008521972580091F
82293925024229AL588562A 008521972381010F
82293925024229AL588564A 008521972580041F
96077805003107AL540466A 008521972390062F
96077805003107AL540467A 008521972991003F
96077805003107AL540468A 008521972590023F
96077805003107AL540469A 008521972991013F
98152574000123AL560422A 008521972380003F
98152574000123AL560484A 008521972381021F
98152576000113AL560423A 008521972580003F
98152576000113AL560485A 008521972980023F
98152579000195AL560424A 008521972580113F
98152579000195AL560486A 008521972980100F
98152580000137AL560425A 008521972980091F
98152580000137AL560487A 008521972580021F
98152584000117AL560426A 008521972980092F
98152584000117AL560488A 008521972580022F
98152587000102AL560427A 008521972580012F
98152587000102AL560489A 008521972980103F
98152590000131AL560428A 008521972980080F
98152590000131AL560490A 008521972580143F
98152591000126AL560429A 008521972580121F
98152591000126AL560491A 008521972980101F
/dtest/data_conversion/cisamtest/data
>/dtest/migration_data/convert_lseq2seq.exe 44 TSTDATA.dat TSTDATATEST.dat
Successfully converted TSTDATA.dat into sequential. Out file :
TSTDATATEST.dat
/dtest/data_conversion/cisamtest/data >cat TSTDATATEST.dat
82009963097043AL560404A 008521972580091F82293925024229AL588562A
008521972381010F82293925024229AL588564A
008521972580041F96077805003107AL540466A
008521972390062F96077805003107AL540467A
008521972991003F96077805003107AL540468A
008521972590023F96077805003107AL540469A
008521972991013F98152574000123AL560422A
008521972380003F98152574000123AL560484A
008521972381021F98152576000113AL560423A
008521972580003F98152576000113AL560485A
008521972980023F98152579000195AL560424A
008521972580113F98152579000195AL560486A
008521972980100F98152580000137AL560425A
008521972980091F98152580000137AL560487A
008521972580021F98152584000117AL560426A
008521972980092F98152584000117AL560488A
008521972580022F98152587000102AL560427A
008521972580012F98152587000102AL560489A
008521972980103F98152590000131AL560428A
008521972980080F98152590000131AL560490A
008521972580143F98152591000126AL560429A
008521972580121F98152591000126AL560491A
008521972980101F/dtest/data_conversion/cisamtest/data > cd ..
/dtest/data_conversion/cisamtest >quiz dict=testdict
Q U I Z (PowerHouse 8.23.D7)
Copyright 2001 COGNOS INCORPORATED
Licensed PH8-DEMO for customer: 0712570002 COGNOS HU DEMO
Warning: Temporary licensing of PowerHouse Server products expires
15-May-2033.
Please contact your local Sales Administration office for a permanent
license.
> execute TESTL0010TEST.qzc
Records selected: 23
Records sorted: 23
Lines printed: 30
Pages printed: 1
> e
/dtest/data_conversion/cisamtest >cat TESTL0010TEST.txt
DATE - 2003/05/11 TEST BILLING SYSTEM
REPORT - TESTL0010
TIME - 03:52 MONTHLY SYSTEM PROFILE -- ACCOUNT /
TEST LINE PAGE - 1
ACCOUNT NO SUBSCRIBER NAME LINE
NO. CALL ID
----------------------------------------------------------------------------
--------------------------------------------------------
82009963097043
AL560404A 008521972580091F
82293925024229
AL588562A 008521972381010F
AL588564A 008521972580041F
96077805003107
AL540466A 008521972390062F
AL540467A 008521972991003F
AL540468A 008521972590023F
AL540469A 008521972991013F
98152574000123
AL560422A 008521972380003F
AL560484A 008521972381021F
98152576000113
AL560423A 008521972580003F
AL560485A 008521972980023F
98152579000195
AL560424A 008521972580113F
AL560486A 008521972980100F
98152580000137
AL560425A 008521972980091F
AL560487A 008521972580021F
98152584000117
AL560426A 008521972980092F
AL560488A 008521972580022F
98152587000102
AL560427A 008521972580012F
AL560489A 008521972980103F
98152590000131
AL560428A 008521972980080F
AL560490A 008521972580143F
98152591000126
AL560429A 008521972580121F
AL560491A 008521972980101F
----------------------------------------------------------------------------
--------------------------------------------------------
NO. OF ACCOUNT = 11
*** End of Report
***
/dtest/data_conversion/cisamtest >
On Thu, 15 May 2003 Edis, Robert wrote :
>Raj
>
>Are you saying that you have explicit CR/LF chars in the file to terminate
>each record?
>
>How are you producing this file? I.e. is it defined in the dictionary, is
>it a subfile, or a dat (no sfd) file?
>
>Can you provide an example of the source that produces the records and
reads
>the records for us?
>Can you give us the first two rows of the data file?
>Can you provide the PDL file/record definition if it is defined in the PHD?
>Can you tell us what component of PowerHouse you are writing/reading the
>file with? (Quick, Quiz, QTP)
>
>Regards,
>Blue
>
>-----Original Message-----
> From: raj hanchan [mailto:raj_hanchan@rediffmail.com]
>Sent: Thursday, May 15, 2003 10:23 AM
>To: powerh-l@lists.swau.edu
>Subject: Is line sequential file read by PH on HP-UX 11i/9000
>
>
>Folks,
>
>I have been tinkering around with PH, over this particular problem
>I am facing. But the PH manual, or Googling did not help. The
>question seems to be very fundamental...
>
>My PH program generates a line sequential file (records separated
>by newline, fixed length) okay. But then it is unable the read the
>same file it has generated !!! I need to read this LS file, and
>generate a report...but the report I get is all junk...
>
>*** My question is: Can PH read a line sequential input ? Or is it
>that, it will _only_ accept sequential input as it is on UNIX ?
>
>I am using PH on HP-UX 11i. I'd appreciate if someone can answer
>this question, as this seems very trivial, but I could gather no
>info about this in the manuals, or on the web.
>
>Thanks in advance.
>
>Warm Regards,
>Raj
>
>___________________________________________________
>Get www. mycompany .com and 5 matching email ids.
>Just Rs. 1499/ year.
>Click here http://www.rediffmailpro.com
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.swau.edu
>Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request@lists.swau.edu
>http://lists.swau.edu/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.swau.edu
>Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
>Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.swau.edu
>http://lists.swau.edu/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
___________________________________________________
Get www. mycompany .com and 5 matching email ids.
Just Rs. 1499/ year.
Click here http://www.rediffmailpro.com