Hello everyone,
I am using OpenEdge Release: 10.2B07 on Windows 7, 64-bit System. I have a Server with Linux (64-bit), on which a Progress database (the same Version of Progress) is running. For the last couple of days I have been trying without any success the following:
1) In the database there is a field of BLOB datatype with a dump of some other table in it; I copy the content of this field to a file on my Computer using COPY-LOB FROM OBJECT <field-name> TO FILE <file-name> NO-CONVERT;
2) I define a temp-table like the table, a dump of which I have saved in the BLOB-field (from step 1 );
3) I import the content of the created file (step 1 ) to the temp-table (step 2 ) using:
INPUT STREAM <stream-name> FROM VALUE(<file-name>) BINARY NO-ECHO.
REPEAT:
CREATE <temp-table name>.
IMPORT STREAM <stream-name> <temp-table name>.
END.
INPUT STREAM <stream-name> CLOSE.
4) I display the contents of the temp-table using:
FOR EACH <temp-table name> NO-LOCK:
DISPLAY <temp-table name> WITH 1 COLUMNS WIDTH 100.
END.
but here I get some coded data (probably in binary code) instead of the content that was dumped and saved in the BLOB-field (from step 1 ).
I thought that it might be because of different operating systems, but "binary", if I am not mistaken, should be platform independent. I also tried the same with a database running on Windows XP 32-bit, but I have not been successful neither, although I am not sure, whether "32-bit" could be the reason.
At the moment I do not have any idea, what I am doing wrong, so any help is appreciated!
I am using OpenEdge Release: 10.2B07 on Windows 7, 64-bit System. I have a Server with Linux (64-bit), on which a Progress database (the same Version of Progress) is running. For the last couple of days I have been trying without any success the following:
1) In the database there is a field of BLOB datatype with a dump of some other table in it; I copy the content of this field to a file on my Computer using COPY-LOB FROM OBJECT <field-name> TO FILE <file-name> NO-CONVERT;
2) I define a temp-table like the table, a dump of which I have saved in the BLOB-field (from step 1 );
3) I import the content of the created file (step 1 ) to the temp-table (step 2 ) using:
INPUT STREAM <stream-name> FROM VALUE(<file-name>) BINARY NO-ECHO.
REPEAT:
CREATE <temp-table name>.
IMPORT STREAM <stream-name> <temp-table name>.
END.
INPUT STREAM <stream-name> CLOSE.
4) I display the contents of the temp-table using:
FOR EACH <temp-table name> NO-LOCK:
DISPLAY <temp-table name> WITH 1 COLUMNS WIDTH 100.
END.
but here I get some coded data (probably in binary code) instead of the content that was dumped and saved in the BLOB-field (from step 1 ).
I thought that it might be because of different operating systems, but "binary", if I am not mistaken, should be platform independent. I also tried the same with a database running on Windows XP 32-bit, but I have not been successful neither, although I am not sure, whether "32-bit" could be the reason.
At the moment I do not have any idea, what I am doing wrong, so any help is appreciated!