DSXchange

The function is simply referenced as if it were a column name. Test it outside of DataStage in a tool like Toad first to ensure you have it working.

You'll need to find the "version" that is recorded in your 7.5.x export and edit your 8.x export to report that version before it will even let you attempt to import from what I recall. After that, as noted, Caveat Emptor.

What characterset is your database using?

... and doesn't really know or care if the job it is running is Server or Parallel.

asorrell wrote:Oh - and by the way - I will be changing your topic title to "How can I do Audit Reporting" fairly soon, since your question doesn't really pertain to administration.

Done. Plus a little cleaning upping.

If you want to see the correct syntax for your previous effort:
That could be done as part of an if-then-else construct or left as-is to set a boolean value in a stage variable or constraint.

I don't see any issue and have done so without issue in the past. Do you have any specific concerns?

Decided to move this from General to here, seeing as how FastTrack is PX only.

mcas wrote:How can i change this post to Parallel? Do i have to copy everything?

Thanks!

You cannot but luckily I can.

So... you are trying to compare a valid date in one database with a null date in another? What's "not working" about it? What are you expecting to happen?

You need to supply a matching format mask so it knows how to parse the incoming string.

That thread is four years old and kumar3846 hasn't posted in over a year. Regardless, it's always better to start your own post in situations like this. Since you didn't seem to be willing to do that, I've split your post out accordingly. Since you can't have "the exact same" error with a ...

Functions are not stored procedures. You 'call' them by including them in a SQL select statement.

Sounds more like a question for Attunity than for us. According to this they 'seemlessly' integrate with ETL tools by automatically populating change tables that you would then source from... have you set things up that way?

I find it curious that the vast majority of your posts seem like "interview questions" rather than any kind of problem that you are actually having. We don't really allow the former here but we're more than happy to help with the latter.