DSXchange

Seems that the problem is when the file is in cache. If the file is in cache, in other words if this command returns true: Locate HashTable in FilesOpened Setting POS Then Then this section fails: Read Rec From FileHandles(POS), Keyfield Then With the error: Improper data type Why ? Chris. What does...

That's the DSRMessage function call.

Chris.

ArndW wrote:What does your function do for the ELSE part of the OPENPATH?

I haven't used the function in the ETL job yet, I only use the Test Function functionality. Christer. So, you copied the routine and the only change was from Open to OpenPath, yes? If that's the case, then the problem would not be with the routine itself but how you are calling it. Can you provide a...

I changed the value of the HastTable variable to contain path and filename: HashTable = 'hasfilepath' : Arg1 When I do this change, the function manages to locate the file, if I don't, the function failes to locate the file. The second change was change of Open statement to Openpath. That's it ! The...

The UtilityHashLookup function only works on the VOC file. If I Change the code to access one of my own HashFiles (Openpath instead of Open). I get an Improper Data Type error message, no matter what!! The sections that fails is: Read RecFrom FileHandlers(POS), KeyField Then Ans = Rec<1> Is there so...

I have a hash file containing three key colums, one of the columns is a number column containing 100, 200, 500 etc. (sorted) The main input column mapped to the hash file contains numbers between 0 and 1000. I want to be able to map to the correct column in the hash file using less than or grather t...

I think I found the solution.
Case closed.

Well, I have used some time searching with no luck.

Therefore I created a new post.

Christer.

Hi. When using the Oracle Enterprice stage, the -dboption don't tolerate $ in the Oracle schema password. Has this anything to do with NLS_LANG settings? Error message: Incorrect -dbotpions option list; it failed on Expected "," or "}", gor: "$", line 1. Why does the -d...

Hi. I'm new to parallel jobs, but have som experience with server jobs. When I use parameters containing quotes, the quotes are removed when the SQL is prepared. I use Source.Read Method=User Defined SQL. I use the Oracle Enterprise stage. Example: I have a job parameter named PARAM1 and it contains...