DSXchange

The database is informix. I am loading from seq. flat file into odbc using a server job. If I use the Ereplace I think I will be losing data on the way in -- for example Data coming in pipe delimited-- rec1|"Frank's and Jane's Co"|12/3/72 rec2|"Bob's Resturant"|12/3/72 I believe ...

Hi,

Into a database. I do not want to remove the quote marks in the data.

I want the string "Frank's and Jane's Co" to move into the database the way I receive it. The tick marks are screwing up the load. How do I ignore them on the way in????

Hi, I am using Server and trying to generate a job to read in a record, divide one field into multiple rows. Example -- Record in informix source Record 1 Field 1: A Field 2: XYZ Records needed in informix target Record 1 Field 1:A Field 2:X Record 2 Field 1:A Field 2:Y Record 3 Field 1:A Field 2:Z ...

Hello,

I was loading sequencial file the is pipe delimited. On a record the job failed because a string being loaded looked like this -- "Frank's and Jane's Company". The problem is the ticks on Frank and Jane. Does anyone know how to ignore these in reading in strings?

Thanks,
Brian

Here is the solution that was provided by Ascential: 1. Check if the file system where RT_LOGxxx resides to make sure it is not a space issue. 2. If there is plenty of space, then it looks like the log file of the job became corrupted. We will need to delete it if it exists and recreate it. Please f...

I ran CLEAR.FILE RT_LOG444 in the DS Admin and got a warning back --
WARNING: Internal File corruption detected during file open!
File must be repaired, possible truncation.
hsize: 2048
bsize: 2048
fsize: 1073741312
CANNOT OPEN FILE RT_LOG444
*** Processing cannot continue. ***

Do I run this command in DS Administrator?

I have been running multiple jobs over the weekend. Today I have been getting this error message and I don't know what caused it.