DSXchange

Hmm. Thats strange. Uncheck the reject line and explicity provide the constraint.

You can just do the comparison in the stage variables. Search for row comparison. Its been covered gazillions of times.

You have commas in your data, thats why.
Set your quote character to double quotes.(")

Are you providing the lengths of all the varchar fields?

jjrbikes wrote:If I'm reading your code correctly, this would search my hashed file for the three possible values in the input file, and if not found would return basically a LookUpFile.NOTFOUND value. Correct?

It will return a -1 if the value is not found. You can leverage that for LookUpFile.NOTFOUND

I have no idea what X, Y, P, Q, A and C are. Reading your second post, you can get that done with a custom routine. Something like Retvalue="" Open "suresh" to myfile else ABORT Readu Retvalue from myfile, Arg1 else Readu Retvalue from myfile, Arg2 else Readu Retvalue from myfile...

Check your columns and see if they are exactly what your selecting in your sql

See if this helps

First of all, please delete the other duplicate post before anyone replies to it.
Are PROM_FROM1 AND PROM_FROM2 Date columns. You need to do TO_CHAR() and then do your comparison. See if that helps.

No. It wont.

So you want to extract V- and whatever single character is with it? Is that correct. Give us a few examples, this is confusing.

chulett wrote:I don't know about candy, but you're almost at the 20K point level where you can finally get that pony you've always wanted.

A pony, damn, I want a shelby

jgreve wrote:The large load ran 100% without aborting, that
is over 200 invocations just fine (it used to abort
up every few dozen invocations).
John G.

You must be one happy fellow.

You can read your file with ReadMethod = "File Pattern". Specify an extra column that gets the File Name from the options. Do all your processing and load the column with your file name along with the rest of the columns to a sequential file. This is to ensure that all the data has been read. Then y...

Congrats Craig on reaching another unimaginable milestone. So do I get a candy now