Is line sequential file read by PH on HP-UX 11i/9000
Edis, Robert
Robert.Edis@blistex.com
Thu, 15 May 2003 11:57:31 -0500
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