Is line sequential file read by PH on HP-UX 11i/9000
Rohde Dirk
Dirk.Rohde@vpgroup.com
Thu, 15 May 2003 10:45:41 -0700
This is not a PowerHouse issue. Unix sequential files consist of streamed
data, which means that any carriage returns or line feeds that are included,
because the data was entered using "vi" or was transferred directly from
another operating system, are treated as data. Another option instead of
adding the linefeed character to the dictionary would be to convert the data
using the Unix "dd" command with the "conv=block" option before accessing it
as follows:
dd if=<input_file> of=<output_file> cbs=<record_size> conv=block
Dirk Rohde
VantagePoint Systems Inc.
-----Original Message-----
From: Edis, Robert [mailto:Robert.Edis@blistex.com]
Sent: Thursday, May 15, 2003 9:58 AM
To: Powerh-L (E-mail)
Subject: RE: Is line sequential file read by PH on HP-UX 11i/9000
Good. I believe that PH understands only one type of sequential file under
UNIX. On other platforms there is more variety.
Contact Cognos for more info.
Blue
-----Original Message-----
From: raj hanchan [mailto:raj_hanchan@rediffmail.com]
Sent: Thursday, May 15, 2003 11:52 AM
To: Edis,Robert
Subject: Re: RE: RE: Is line sequential file read by PH on HP-UX
11i/9000
Blue,
It worked!!! Thanks a lot!!! now I am able to read line sequential
file. I got your logic. But, by this can we conclude that
powerhouse on HP-UX can not read line seq or anything we are
missing at file organization level without declaring one more
element LF.
Is it really a problem in PH on HP-UX. Can I approach COGNOS on
this for a fix.
-Raj
On Thu, 15 May 2003 Edis, Robert wrote :
>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
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>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
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.