Hi All,

I am using DB2 UDB 8.1 on linux platform.

I want to import or read .asc file from DB2 stored procedure. This file
contains encryption and decryption key in multiple lines. I have
following problem when i use load command or import command

When I use load or import utility then these separate lines of
encryption and decryption key goes as separate rows in table. So when I
again want to export this data and use these keys in my program i am
facing problem.
So Is there any way in DB2 UDB so that I can read .asc file byte by
byte and then place that data in my table.

My single file contain single key value in multiple rows. I want to
store this value in single row means single cell.
Please give me suggestion if any other method.

Thanks
Suresh

You've at least two possible alternatives:
1. Add an additional record at the beginning and end of the file
containing a single double-quote character (the string delimiter),
specify loading from a DEL file and use the DELPRIORITYCHAR modifier.
This assumes that you don't have a double-quote character in the key.
You can change the delimiter character using DELCHAR. See the LOAD
section of the utilities reference for additional details.
2. Ask your support programmer to write a shell script that will copy
the file, removing the record delimiters, making a single record to load.

Phil Sherman



Suresh wrote:
> Hi All,
>
> I am using DB2 UDB 8.1 on linux platform.
>
> I want to import or read .asc file from DB2 stored procedure. This file
> contains encryption and decryption key in multiple lines. I have
> following problem when i use load command or import command
>
> When I use load or import utility then these separate lines of
> encryption and decryption key goes as separate rows in table. So when I
> again want to export this data and use these keys in my program i am
> facing problem.
> So Is there any way in DB2 UDB so that I can read .asc file byte by
> byte and then place that data in my table.
>
> My single file contain single key value in multiple rows. I want to
> store this value in single row means single cell.
> Please give me suggestion if any other method.
>
> Thanks
> Suresh
>