DSXchange

It only "starts with 0" if you consider "no rows" as the starting state. But still, it's a simple count of the rows down the link, nothing more than that.

I'm afraid I don't really have an answer for that. Can you talk with the SQL Server DBA and find out what the equivalent of their NLS_LANG value is set to?

You need a constraint on the other link as well, something to "not" the constraint logic on the reject link.

What? You get the count that went down the link - zero, one, eleventy-seven - whatever it was.

Sure, look up the DSGetLinkInfo function, use it with the DSJ.LINKROWCOUNT InfoType.

You need to find out what the actual NLS_LANG setting is for your target and use that in the job that writes to it. And if you really do need to use a different NLS_LANG setting, source v. target, then you'll need to split your job in two if you haven't done so already.

"CLEAR.FILE &PH&" simply clears that "phantom" directory in the attached project. There is no command to "clear all log files in one shot".

Still confused, but if that's really what you want to do simply use the IsNull() function to check and if true then replace the value with two pipes:


Yes, for every column.

No, there's nothing to enable/activate for this. Talk to your SysAdmins if you are having a problem with 'sendmail' on your system, as that is what DataStage uses.

So does the OCI stage, but neither one is a PX "Enterprise" stage.

Permissions are usually up to the receiving system AFAIK. If you can telnet to the server, an 'after' command to 'chmod' the file can be attempted, but just because you can ftp doesn't necessarily mean you can telnet.

Yes - "call unix scipt use Execsh option".

If you are writing to a pipe delimited file, then what you want to happen will happen automatically. What issue are you having?

As already noted, use "dsjob" with the various "-log" functions. Read the Server Job Developer's Guide chapter on the Command Line Interface for explanations of their use.

For Designing the Polling process job we dont need RTI or webservices pack in Datastage? No. Polling for files has been around a heck of a lot longer than web services. So, there's no actual "arrival"? Meaning, they are not sent to you but rather you need to poll a remote system for their generatio...