DSXchange

What database? What drivers? I don't think I have a table name that doesn't have an underscore in it and haven't seen this problem.

Have you tried searching for part of your message, like "Failed to add user to UV_USERS". I got several hits when I searched.

Beat Ray to that one.

ArndW wrote:It is questions like this that make me wonder and that bother me. Is DSXchange considered to be a replacement for the help files, the documentation and other sources?

I stopped wondering quite some time ago - the answer is a definite and unqualified yes.

Wildcard pattern?

Well, you've certain come to the wrong place if you want some doubt.

Google not working for you? Checked Wikipedia? It's all out there...

http://en.wikipedia.org/wiki/Environment_variable

Look up the various 'Date' functions, like DateFromString and StringFromDate off the top of my head.

I guessing you could use the Filter option in the Sequential File stage to unzip the file to standard out and then consume the stream. No idea how much temp space, if any, that would still require.

Helps to make proper use of the 'code' tags so your formatting is preserved. Where, exactly, are you getting this "status of 1"? I am creating a sub routine to read in one parameter from a sequential file. I keep getting a status of 1 which is "An end-of-file" was encoutered. I have this set up to c...

Sorry for continuing in the same link but i dont know how to link it. Come on... a link is a URL to the post in question. You get that from the Forum view or the address bar in your brower and then you paste it into your post. It's not rocket science. Regarding the telnet prompt, below are the sett...

Yes, the BASIC Transformer can use 'all basic functions' but you really want to learn and use the PX equivalents instead where possible.

Didn't realize there was a Google contest going on. Surrogate key is a substitution for the natural primary key. It is just a unique identifier or number for each row that can be used for the primary key to the table. The only requirement for a surrogate primary key is that it is unique for each row...

That would be what the Start Loop and End Loop stages would be for.

30 minutes?

Search will help you help yourself, this question has been asked and answered many, many (many) times before.