DSXchange

Establish? First order of business would be to install it on your PC and then read the pdf documentation that installs along with it. There is a Methodology chapter which walks you through How It Works. Plus it documents the post-install steps you need to complete before you can start using it.

All it means is that you should pick the order that most fits the data coming in. If most of them will be inserts, then have it try the insert first. By "faster" all they mean is it will be one operation, the secondary operation only happens if the primary operation fails. Hence it can be considered...

I thought IsNullStr comes from the PX side. If it's user written, then I would hope that someone there should be able to "fix" it so it always works as expected. At worst case, post the code.

The Merge stage in Server jobs merges / combines two flat files. That's got nothing to do with how you go about inserting or updating a target table.

Perhaps if you explained in more detail your requirements?

Surely you can't send a space character (" ") to a date column in any case? No, you can't. At least not in Oracle, can't imagine that's true in any database. At the time of data loading , change the data type of all date column as Varchar2[38], Oracle automaticaly load as time stamp . Better to spe...

just as a note, you can download the command-line WinZip interface and I've used that for .bat programs and I haven't seen any popups. Which is exactly what I am using for this as well. You will have to have a real live registered version of WinZip before you can use the command line option. The -m...

No way for me to know without either seeing your job or getting a better explanation as to exactly what it is doing to the data as it moves it through. Is there a hash lookup involved? Are you using values from it even if the lookup fails? Have you tried debugging the job to watch the data flow thro...

What kind of help do you need? The problem is spelled out in the message:

Cannot insert the value NULL into column 'fund_name', table 'uci.dbo.nsar'; column does not allow nulls.

You are trying to put a null into a field that doesn't allow it. Stop doing that.

Or just take the first 10 characters of the Timestamp field.

Oracle DATE fields are best handled as Timestamps datatypes in DataStage, in my opinion and experience, since it contains a time portion.

Curious on how they plan on restricting that?

Switch from the roll-your-own batch file to the spanky one available out on ADN. It doesn't have that issue, creates daily backup directories and has hooks for compressing all of my exports into a single zip. Not sure what it does special to avoid your issue, however. Are you redirecting the output ...

dak wrote:Only thing is that I am running in a Windows 2000 environment so I can't use the Unix 'cat' function.

So then you would use 'copy' in that case. Or possibly even 'type'.

palmeal wrote:I am being told that my Company's corporate standard is not to use Job Sequences. I am also being told that another standard is that Sendmail is not supported.

Those are... interesting... non-standards to be saddled with.

Interesting. I've seen Mercator in the past, but that was a long time ago and never since acquired by Ascential and morphed into TX. I'll have to keep that in mind.