By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,236 Members | 1,453 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,236 IT Pros & Developers. It's quick & easy.

About Reading ASC files - Urgent

P: n/a
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

Aug 17 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Aug 18 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.