portable subfile from Windows to OpenVms

[Jeff Hoffman]

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.