portable subfile from Windows to OpenVms
Joe Boyle
atla38 at dsl.pipex.com
Sat Nov 25 18:02:44 CST 2006
Not that I am suggesting that this is not a bug and therefore should be
fixed by Cognos - clearly, there is a problem with a 'portable' subfile
which cannot be ftp'd in it's default state to another server running a
different OS, and then read by that server's ph version.
-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Joe Boyle
Sent: 25 November 2006 21:06
To: 'Jeff Hoffman'; powerh-l at lists.sowder.com
Subject: RE: portable subfile from Windows to OpenVms
I,m pretty sure that this is now solved, the reason being the content of
Jari's last email - see below - which was blocked by the list because the it
was over 40k in size,
----------------------------------------------------------------------------
----
having taken another look at your data below, I suspect that all you need to
do now is edit the .psd file and remove the references to the cr and lf
elements and that should do the trick.
----------------------------------------------------------------------------
----
From: Joe Boyle [mailto:atla38 at dsl.pipex.com]
Sent: 24 November 2006 17:20
To: 'Jari.Kaljunen at sergel.com'; 'powerh-l at lists.sowder.com'
Subject: RE: portable subfile from Windows to OpenVms
One other thing Jari,
When you say you can read the subfile content correctly in an editior, are
you referring to the data on the VMS side ? if so, you may only need to edit
the .psd file to reflect the record length of the .ps file as specified by
dir/full or analyse/rms
----------------------------------------------------------------------------
----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Jari.Kaljunen at sergel.com
Sent: 24 November 2006 16:17
To: powerh-l at lists.sowder.com
Subject: SV: portable subfile from Windows to OpenVms
Thank you, but this is the result:
quiz:
acc gs_paymentplan in sincos_2
set sub name d:\ak2sincos\t_gs_paymentplan portable keep
define lfn integer size 2 = 10
define lf char*1 = char(lfn)
define crn integer size 2 = 13
define cr char*1 = char(crn)
rep sum projid gs_spaymentplanid cr lf
go
FTP in ascii worksk fine but on OpenVms the result is:
2006-11-24 Sergel Kredittjänster AB PAGE
1
Projid Gs cr lf
Spaymentplanid
0035-G-0001624677 000000737 0 0
35-G-0001643810 00 0000739 00 3 5
-G-0001636110 0000 00758 0033 - G
-0001114955 000000 761 0033-G - 0
001114955 00000076 3 0035-G-0 0 0
1653258 000000767 0084-G-002 7 0
23803 000000813 00 35-G-00016 5 2
219 000000817 0043 -G-0006015 7 5
In the editor the subfile looks fine:
0035-G-0001637861 000000863
0035-G-0001644493 000000867
0035-G-0001633064 000000895
0035-G-0001647046 000000899
0033-G-0001519231 000000912
0035-G-0001647771 000000928
0038-G-0002004381 000000930
0035-G-0001637167 000000935
BTW, I have tried with zipped file too.
/Jari
_____________________________________________
-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Jeff Hoffman
Sent: 25 November 2006 06:06
To: powerh-l at lists.sowder.com
Subject: Re: portable subfile from Windows to OpenVms
Hi
I kind of remember when transferring from MPE to HP/UX I had to ftp one of
the files as binary and the other type as ascii cannot remember which ones
where which but it was fairly simple to organise.
Alternatively
If your VMS file system is a relational DB, then try creating tab separated
records in the sequence and the format of the tables and use BCP to load
the data. when you load the data do not have any indexes, they can be
created afterwards.
Jeff
At 02:23 AM 25/11/2006, you wrote:
>Content-class: urn:content-classes:message
>Content-Type: multipart/alternative;
> boundary="----_=_NextPart_001_01C70FDC.786DE10E"
>
>Hello,
>
>I am migrating data from Windows to OpenVms. First I create portable
>subfiles on Windows
>
>acc gs_paymentplan in sincos_2
>
>set sub name d:\ak2sincos\t_gs_paymentplan portable keep
>
>rep sum projid GS_SPAYMENTPLANID
>
>go
>
>The portable subfile looks Ok on Windows.
>
>Transfer to OpenVms with FTP from OpenVms:
>
>ascii
>
>get t_gs_paymentplan.psd
>
>bin
>
>get t_gs_paymentplan.ps
>
>It is not possible to transfer the ps-file in ASCII-mode because:
>
>-RMS-W-RTB, 61440 byte record too large for user's buffer
>
>426 Connection closed; transfer aborted.
>
>When read it looks like this:
>
>QUIZ_SC> set rep limit 10 page len 0
>
>acc *t_gs_paymentplan
>
>QUIZ_SC> acc *t_gs_paymentplan
>
>sho item
>
>QUIZ_SC> sho item
>
>INPUT OUTPUT
>
>T_GS_PAYMENTPLAN TYPE SCALE SCALE DEC PICTURE
>
>PROJID CHAR X(25)
>
>GS_SPAYMENTPLANID CHAR X(10)
>
>rep projid gs_spaymentplanid
>
>QUIZ_SC> rep projid gs_spaymentplanid
>
>QUIZ_SC>
>
>go
>
>QUIZ_SC> go
>
>24.11.2006 Sincos PAGE 1
>
>Projid Gs
>
>Spaymentplanid
>
>0035-G-0001624677 000000737
>
>035-G-0001643810 0 00000739 0
>
>35-G-0001636110 00 0000758 00
>
>3-G-0001114955 000 000761 003
>
>-G-0001114955 0000 00763 0035
>
>G-0001653258 00000 0767 0084-
>
>-0027023803 000000 813 0035-G
>
>0001652219 0000008 17 0043-G-
>
>006015756 00000082 2 0035-G-0
>
>01648912 000000854 0038-G-00
>
>
>
>The record are obviusly not correct.
>
>If I do conversion the result becomes
>
>$convert /fdl=sys$input t_gs_paymentplan.ps test.ps
>
>file
>
>organization sequential
>
>record
>
>carriage_control carriage_return
>
>format variable
>
>$cop t_gs_paymentplan.psd test.psd
>
>%COPY-S-COPIED, DISK99:[SINCOS_CONVERT]T_GS_PAYMENTPLAN.PSD;1 copied to
>DISK99:[
>
>SINCOS_CONVERT]TEST.PSD;11 (0.50KB)
>
>$quiz_sc
>
>Q U I Z (7.10.G)
>
>Copyright 1998 COGNOS INC. (ALPHA)
>
>Licensed PH-AXP-RUNTIME for customer: 8200290001 Sergel Kredttjanster AB
axp
>
>set rep limit 10 page len 0
>
>QUIZ_SC> set rep limit 10 page len 0
>
>acc *test
>
>QUIZ_SC> acc *test
>
>sho item
>
>QUIZ_SC> sho item
>
>INPUT OUTPUT
>
>TEST TYPE SCALE SCALE DEC PICTURE
>
>PROJID CHAR X(25)
>
>GS_SPAYMENTPLANID CHAR X(10)
>
>rep projid gs_spaymentplanid
>
>QUIZ_SC> rep projid gs_spaymentplanid
>
>QUIZ_SC>
>
>go
>
>QUIZ_SC> go
>
>24.11.2006 Sincos PAGE 1
>
>Projid Gs
>
>Spaymentplanid
>
>0035-G-0001624677 000000737
>
>0035-G-0001643810 000000739
>
>0035-G-0001636110 000000758
>
>0033-G-0001114955 000000761
>
>0033-G-0001114955 000000763
>
>0035-G-0001653258 000000767
>
>0084-G-0027023803 000000813
>
>0035-G-0001652219 000000817
>
>0043-G-0006015756 000000822
>
>0035-G-0001648912 000000854
>
>
>
>Which is correct BUT from record number 10987 it becomes like this: (the
>last field is count) the same record is written to output and quiz gets in
>continuos loop!!
>
>0033-G-0001322471 000014734 10982
>
>0033-G-0001380915 000014736 10983
>
>0026-00743-000000001 000014737 10984
>
>0026-00525-000000018 000014738 10985
>
>0026-00699-000000010 000014745 10986
>
>0026-00701-000000059 000014748 10987
>
>0026-00701-000000059 000014748 10988
>
>0026-00701-000000059 000014748 10989
>
>0026-00701-000000059 000014748 10990
>
>0026-00701-000000059 000014748 10991
>
>0026-00701-000000059 000014748 10992
>
>0026-00701-000000059 000014748 10993
>
>0026-00701-000000059 000014748 10994
>
>0026-00701-000000059 000014748 10995
>
>I have a database with 30 tables with hundreds of fields to migrate so the
>portable subfiles should be convinient to use.
>
>My question is: has anyone taken a portable subfile from Windows to
>OpenVms, were there problems like this and what is possible to do to solve
>this?
>
>Thanks in advance, Jari
>
>
>
>
>
>
>
>
>
>
>
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to
>powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>Add 'site:lists.sowder.com powerh-l' to your search terms to search the
>list archive at Google.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the list
archive at Google.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the list
archive at Google.
More information about the powerh-l
mailing list