DSXchange

Only reason I asked is because I was under the impression you needed to use that particular one for Hive.

... and make sure you CLOSE the file in the routine, as Ray noted.

:!: Wait... you are writing to a single sequential file by multiple processes at the same time? Multiple readers are fine but multiple writers is generally what is known as a Very Bad Idea due to the nature of sequential media. The only thing that may save you is the LOCK part mentioned above so you...

https://en.wikipedia.org/wiki/HTTP_403 Not sure why you're getting that but that is what it means, in case you hadn't looked up the error. I would double-check your configuration in the stage, make sure all of the values are appropriate and your running user has whatever privs are needed to access t...

They specifically said they have "two columns" so yeah... commas needed if it actually is a "csv".

Are you looking for architecture advice or something more DataStage related?

So where are the commas?

So says the "C" man. You really shouldn't have to explicitly do that here from what I recall.

Yeah, I think that last bit are just different names out there in the wild for very similar things - code point, code page, characterset - see Character Encoding as one Google'd up example.

Show us the file, copy/paste the contents here and let us know what settings you are using in the Sequential File stage to read it.

It's been quite a while but I believe you only need to use WEOFSEQ (write End Of File) when you want to 'truncate' a sequential file, typically from a specific spot in the file. You should always CLOSE any file you open and I believe your issue noted in #2 is from not properly closing the file.

Look like support questions to me. Or something for Google.

Which "that location"? And when you say it's not "picking up" from there, what exactly does that mean - you get an error? Details, please.

Yes. Each project is stored in a directory which stores all of the hashed files that record each job you define... it can also be called the 'legacy' repository. When a job runs, it runs from there, meaning the project directory is the CWD or "current working directory". If your base pathn...

I would look in the appropriate Project directory...