<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2995" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN
class=790255714-24112006>Hello,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=790255714-24112006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=790255714-24112006>I am migrating data
from Windows to OpenVms. First I create portable subfiles on Windows
</SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=790255714-24112006><FONT face=r_ansi>
<P><FONT size=2>acc gs_paymentplan in sincos_2</FONT></P>
<P><FONT size=2>set sub name d:\ak2sincos\t_gs_paymentplan portable keep
</FONT></P>
<P><FONT size=2>rep sum projid GS_SPAYMENTPLANID</FONT></P>
<P><FONT size=2>go</FONT></P>
<P><SPAN class=790255714-24112006><FONT face=Arial size=2>The portable subfile
looks Ok on Windows.</FONT></SPAN></P>
<P><SPAN class=790255714-24112006><FONT face=Arial size=2>Transfer to OpenVms
with FTP from OpenVms:</FONT></SPAN></P><SPAN class=790255714-24112006><FONT
face=r_ansi>
<P><FONT size=2>ascii</FONT></P>
<P><FONT size=2>get t_gs_paymentplan.psd</FONT></P>
<P><FONT size=2>bin</FONT></P>
<P><FONT size=2>get t_gs_paymentplan.ps</FONT></P>
<P><SPAN class=790255714-24112006><FONT face=Arial size=2>It is not possible
to transfer the ps-file in ASCII-mode because:</FONT></SPAN></P><SPAN
class=790255714-24112006><FONT face=r_ansi>
<P><FONT size=2>-RMS-W-RTB, 61440 byte record too large for user's
buffer</FONT></P>
<P><FONT size=2>426 Connection closed; transfer aborted.</FONT></P>
<P><SPAN class=790255714-24112006><FONT face=Arial size=2>When read it looks
like this:</FONT></SPAN></P><SPAN class=790255714-24112006><FONT face=Arial
size=2><FONT face=r_ansi size=2>
<P>QUIZ_SC> set rep limit 10 page len 0</P>
<P>acc *t_gs_paymentplan </P>
<P>QUIZ_SC> acc *t_gs_paymentplan</P>
<P>sho item</P>
<P>QUIZ_SC> sho item</P>
<P>INPUT OUTPUT</P>
<P>T_GS_PAYMENTPLAN TYPE SCALE SCALE DEC PICTURE</P>
<P>PROJID CHAR X(25)</P>
<P>GS_SPAYMENTPLANID CHAR X(10)</P>
<P>rep projid gs_spaymentplanid</P>
<P>QUIZ_SC> rep projid gs_spaymentplanid</P>
<P>QUIZ_SC> </P>
<P>go</P>
<P>QUIZ_SC> go</P>
<P>24.11.2006 Sincos PAGE 1</P>
<P>Projid Gs</P>
<P>Spaymentplanid</P>
<P>0035-G-0001624677 000000737</P>
<P>035-G-0001643810 0 00000739 0</P>
<P>35-G-0001636110 00 0000758 00</P>
<P>3-G-0001114955 000 000761 003</P>
<P>-G-0001114955 0000 00763 0035</P>
<P>G-0001653258 00000 0767 0084-</P>
<P>-0027023803 000000 813 0035-G</P>
<P>0001652219 0000008 17 0043-G-</P>
<P>006015756 00000082 2 0035-G-0</P>
<P>01648912 000000854 0038-G-00</P></FONT></FONT></SPAN>
<P><SPAN class=790255714-24112006><FONT face=Arial
size=2></FONT></SPAN> </P>
<P><SPAN class=790255714-24112006><FONT face=Arial size=2>The record are
obviusly not correct.</FONT></SPAN></P>
<P><SPAN class=790255714-24112006><FONT face=Arial size=2>If I do conversion the
result becomes </FONT></SPAN></P><SPAN class=790255714-24112006><FONT
face=r_ansi>
<P><FONT size=2>$convert /fdl=sys$input t_gs_paymentplan.ps test.ps</FONT></P>
<P><FONT size=2>file </FONT></P>
<P><FONT size=2>organization sequential </FONT></P>
<P><FONT size=2></FONT></P>
<P><FONT size=2>record </FONT></P>
<P><FONT size=2>carriage_control carriage_return </FONT></P>
<P><FONT size=2>format variable </FONT></P>
<P><FONT size=2>$cop t_gs_paymentplan.psd test.psd</FONT></P>
<P><FONT size=2>%COPY-S-COPIED, DISK99:[SINCOS_CONVERT]T_GS_PAYMENTPLAN.PSD;1
copied to DISK99:[</FONT></P>
<P><FONT size=2>SINCOS_CONVERT]TEST.PSD;11 (0.50KB)</FONT></P>
<P><FONT size=2>$quiz_sc</FONT></P>
<P><FONT size=2>Q U I Z (7.10.G)</FONT></P>
<P><FONT size=2>Copyright 1998 COGNOS INC. (ALPHA)</FONT></P>
<P><FONT size=2>Licensed PH-AXP-RUNTIME for customer: 8200290001 Sergel
Kredttjanster AB axp</FONT></P>
<P><FONT size=2>set rep limit 10 page len 0</FONT></P>
<P><FONT size=2>QUIZ_SC> set rep limit 10 page len 0</FONT></P>
<P><FONT size=2>acc *test</FONT></P>
<P><FONT size=2>QUIZ_SC> acc *test</FONT></P>
<P><FONT size=2>sho item</FONT></P>
<P><FONT size=2>QUIZ_SC> sho item</FONT></P>
<P><FONT size=2>INPUT OUTPUT</FONT></P>
<P><FONT size=2>TEST TYPE SCALE SCALE DEC PICTURE</FONT></P>
<P><FONT size=2>PROJID CHAR X(25)</FONT></P>
<P><FONT size=2>GS_SPAYMENTPLANID CHAR X(10)</FONT></P>
<P><FONT size=2>rep projid gs_spaymentplanid</FONT></P>
<P><FONT size=2>QUIZ_SC> rep projid gs_spaymentplanid</FONT></P>
<P><FONT size=2>QUIZ_SC> </FONT></P>
<P><FONT size=2>go</FONT></P>
<P><FONT size=2>QUIZ_SC> go</FONT></P>
<P><FONT size=2>24.11.2006 Sincos PAGE 1</FONT></P>
<P><FONT size=2>Projid Gs</FONT></P>
<P><FONT size=2>Spaymentplanid</FONT></P>
<P><FONT size=2>0035-G-0001624677 000000737</FONT></P>
<P><FONT size=2>0035-G-0001643810 000000739</FONT></P>
<P><FONT size=2>0035-G-0001636110 000000758</FONT></P>
<P><FONT size=2>0033-G-0001114955 000000761</FONT></P>
<P><FONT size=2>0033-G-0001114955 000000763</FONT></P>
<P><FONT size=2>0035-G-0001653258 000000767</FONT></P>
<P><FONT size=2>0084-G-0027023803 000000813</FONT></P>
<P><FONT size=2>0035-G-0001652219 000000817</FONT></P>
<P><FONT size=2>0043-G-0006015756 000000822</FONT></P>
<P><FONT size=2>0035-G-0001648912 000000854</FONT></P>
<P><FONT size=2></FONT> </P>
<P><SPAN class=790255714-24112006><FONT face=Arial size=2>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!! </FONT></SPAN></P><SPAN class=790255714-24112006><FONT face=r_ansi>
<P><FONT size=2>0033-G-0001322471 000014734 10982</FONT></P>
<P><FONT size=2>0033-G-0001380915 000014736 10983</FONT></P>
<P><FONT size=2>0026-00743-000000001 000014737 10984</FONT></P>
<P><FONT size=2>0026-00525-000000018 000014738 10985</FONT></P>
<P><FONT size=2>0026-00699-000000010 000014745 10986</FONT></P>
<P><FONT size=2>0026-00701-000000059 000014748 10987</FONT></P>
<P><FONT size=2>0026-00701-000000059 000014748 10988</FONT></P>
<P><FONT size=2>0026-00701-000000059 000014748 10989</FONT></P>
<P><FONT size=2>0026-00701-000000059 000014748 10990</FONT></P>
<P><FONT size=2>0026-00701-000000059 000014748 10991</FONT></P>
<P><FONT size=2>0026-00701-000000059 000014748 10992</FONT></P>
<P><FONT size=2>0026-00701-000000059 000014748 10993</FONT></P>
<P><FONT size=2>0026-00701-000000059 000014748 10994</FONT></P>
<P><FONT size=2>0026-00701-000000059 000014748 10995</FONT></P>
<P><SPAN class=790255714-24112006><FONT face=Arial size=2>I have a database with
30 tables with hundreds of fields to migrate so the portable subfiles
should be convinient to use. </FONT></SPAN></P>
<P><SPAN class=790255714-24112006><FONT face=Arial size=2>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?</FONT></SPAN></P>
<P><SPAN class=790255714-24112006><FONT face=Arial size=2>Thanks in advance,
Jari</FONT></SPAN></P>
<P><FONT face=Arial size=2></FONT> </P></FONT></SPAN></FONT></SPAN>
<P><SPAN class=790255714-24112006><FONT face=Arial
size=2></FONT></SPAN> </P>
<P><SPAN class=790255714-24112006><FONT face=Arial
size=2></FONT></SPAN> </P></FONT></SPAN>
<P><FONT face=Arial size=2></FONT> </P></FONT></SPAN>
<P><SPAN class=790255714-24112006><FONT face=Arial
size=2></FONT></SPAN> </P>
<P><FONT face=Arial size=2></FONT><FONT face=Arial
size=2></FONT></FONT></SPAN></FONT><FONT face=Arial size=2><SPAN
class=790255714-24112006></SPAN></FONT> </P></DIV></BODY></HTML>