DSXchange

And what if they want to preserve it? Use the Server Sequential File stage in a Server Shared Container.

Solved how? Please share what you've learned from this with whomever comes searching with the same problem in the future...

See what happens when you post a real example?

Exactly. And no, the Folder stage doesn't do this. While it can read multiple files it is primarily meant to be used with XML files - which come in as one long string and are then parsed into individual fields in job.

Wow, that sounds like a pretty crappy work environment. :? One thing to keep in mind... I'm not sure that the DBA would be able to solve a Datastage problem. You do not have a "Datastage problem". You have a SQL problem. DataStage is another SQL client, just like SQL Developer - both send ...

You need to treat them as one large file, either buy concatenating them all together first or by using the Filter option in the Sequential File stage and using 'cat/type *' to send the contents to std out, which the stage will then consume.

The LIKE should be fine and if that column is indexed it could actually be performant since it is matching the 'leading edge' of the data. Not sure a sub-query would help there but if push comes to shove, the explain plan should help make that decision.

Aha! :D You can search for that variable name here and see the other discussions where it comes up and it's usually an "oh yah, forgot about that" moment as it doesn't come up very often. From what I recall, it has been mentioned earlier when milliseconds have been added to a DATE field by...

Pet Peeve Alert: "my SQL query is somewhat like the following" It irks me when we get examples that are "somewhat like" reality. We have gone down many a rabbit hole because of crappy examples people have given us. If all you've changed are the names of the tables and fields but ...

Off we go!

A little too picky of a differentiator for me.

What "it" won't work?

What version of VisualStudio? And what version of Windows?

OK... that would have all been good information to include in your original post rather than make me ask it and then rate my response as "Off-topic/Superflous". :evil: Are you certain it is setup correctly? Can you share your related DS environment variable settings for the compiler and li...

First off, there are a ton of existing posts for this general problem, did you try searching at all? Secondly, it is important to understand that you need a supported C++ compiler installed on the DataStage server in order to compile PX jobs with transformers and that it needs to be properly configu...