DSXchange

Those question marks could be any number of characters and certain ones in Key fields are not allowed. Dump the record to a flat file and examine it with a hex editor and let us know what it actually is.

octogun wrote:can we put 32bit c++ software on 64bit RHEL 4 OS?

Sure, but the question is - you may have a 64bit version of the O/S running but is your DataStage software 32bit or 64bit? That answer would drive your solution.

Yes, still an option and exactly the same as before. Or, as noted, you could use a 'naked' Server job and supply your own code to run under the Job Control tab. FWIW, I much prefer the latter.

That is how one would do that. Can you post the actual, unedited error(s) you are seeing? Any chance this is a permissions issue?

Perhaps you could be a little more specific as to the "issues" you are seeing. Examples are good, too.

You can still create "Batch::" jobs in 8.x can you not? As noted, they don't care if they are Server or Parallel jobs. Or just create a job with nothing on the canvas and your own code under the Job Control tab.

You don't need a routine and that would just complicate this. Leverage the command line interface for your DB from a script - for example, using sqlplus for Oracle. So for SQL Server it would be isql I believe, yes?

Then it's time to mark your post as Resolved using the big button at the top of the page!

Ah yes, forgot to ask about that. Glad you got it sorted out! :D

I know, just wanted to point that out to anyone reading this that may not find that so obvious or thinks they had to do it like that.

D'oh... true. But there's no need for the char() function as these are all displayable characters unless your goal is obfuscation.

convert(chr(65):chr(66),chr(32):chr(32),Link)

Yes, you can do this in a script via the "Universe shell", search here for dssh or uvsh for examples where people have done similar things.

So, your plan is to have a single job that can process any number of columns from any number of tables? And then what do you need to do with these columns? Hopefully nothing in the way of transformations if you think RCP is going to be your big saviour here.

However, the query is not that simple. I am actually trying to pull last month's data based on a date field from the table. It looks like this: select col1, clo2 from tablename where to_date(col1,'yyyy-mm-dd hh24:mi:ss')) = to_date(to_char(last_day(add_months(sysdate,'yyyy-mm-dd') ||' 00:00:00','yy...