DSXchange

Chuck thanks for the response. I'm not sure if I understand you so let me recap. I already have both of those options turned off. my job looks like this: OCI1 --> HASH | | OCI2 --> XFM --> OCI_BULK The OCI1 loads the hash file then OCI2 goes to the transformer and does lookup against the hash file. ...

Good afternoon. I'm not sure if this is even possible, but I wanted to perform a lookup against a hash file. Now the tricky part is for each record that is used in the hash file for looking up I want to update a column named "PROCESSED" to TRUE. That way I can keep track of which records f...

Chuck, Good to hear from you again. Actually I did try the QUOTE = 000 but just like you said now my problem is comma's inside the fields. So it's a constant problem. Either with commas or double quotes. I didn't try the Trim function though, because I would like to keep the fields as they come from...

kc,

Thanks for your input. Unfortunately I had already done that. I did it again anyways and it left the quote character as a double quote("). I still have the sequential file as I posted previously. It still has quotes within the fields.

Has anyone encountered the handling of quotes incoming from an ODBC source stage. I have an ODBC connection that will create a sequential file in the end. But some CHAR fields have quotes inside of them and it's creating a file with quotes which then cannot be used as an input to a hashed file like ...

Chuck, using the debug with breakpoints and watches set up I was able to find the bad record. There was a quote (") in the middle of a column in the sequential file. Actually I found a few of them which are there because the file is comma delimited but has quotes around each column. This file i...

Hi chuck.

My setting are all default for the one's you asked:
Fixed width = No
Quote char = "
delimiter = ,
escape = \ (I also tried leaving this blank)

My sequential file does have quoted columns and is comma delimited.

Thanks chuck and ray. I'm really learning a lot here. I had the lookup going to the ODBC when it was suppose to go to the sequential file. I also added a hashed file to be created from the sequential file for faster lookups. I then added the correct NOTFOUND logic to the Transformer's contraints and...

Let me start by saying thanks to the MODS and Admin of this great site. I'm new to DS and this site is going to help me a lot. Great Job!!! No onto my Q: I'm trying to join two data sources and retrieve the differences. for example: DataSource1 EmployeeID Name 1 xx 2 yy DataSource2 EmplyeeID Name 1 ...