At 02:33 PM 4/3/2013, John Docherty wrote:
Razzak,
Thanks Razzak - yes, please let me know what I need to do.
John,
You can easily convert the VARCHAR data to NOTE data!
Try the exercise below to get an idea.
Example:
TableA:
ColumnA INTEGER
ColumnB VARCHAR
TableB:
ColumnA INTEGER
ColumnC NOTE
Routine to convert VARCHAR to NOTE Field:
INSERT INTO TableB (ColumnA, ColumnC) SELECT ColumnA, ColumnB FROM TableA
The resulting ColumnC in TableB will include the converted VARCHAR to NOTE.
That's all there is to it!
In your specific case, you can accomplish the task using TEMPORARY tables.
Once you have the required data as NOTE column, you can use the power of
UNLOAD or GATEWAY EXPORT options to extract data, on demand.
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
